Hiblet/NewZopa01 — pull request #21 by Hiblet (2014-03-17 11:06:31+00:00)
Title: MarketName added to order books; Username now lowercase;

FIXED: Account.cs; AccountDAL.cs
-- Loading the bool variable failed during the cast. Now ctor uses int.

CHANGED: AsyncHttpHandlerOrders.cs
-- Now calls OrderSubsManager Subscribe or ProcessOrders (dummy fn).
-- Now forces inbound username to lowercase

CHANGED: UserAccountJunction.cs
-- Forces username to lowercase on object creation

CHANGED: UserAccountManager.cs
-- Forces username keys to storage dictionary into lowercase
-- Added GetPrivilegedAccounts() to return list of account name for user
-- Changed HasTradingRights() and HasViewingRights() to use lowercase username

CHANGED: OrderSubscriptionManager.cs
-- Uses lowercase username in functions
-- Added ProcessOrders placeholder to ensure Async request gets completed

CHANGED: AppUtility.cs
-- ToCSVString() can now optionally add quotes to create a quoted csv.

CHANGED: MarketManager.cs
-- Added static fn to return market name for a given symbol.

CHANGED: Order.cs
-- Added _marketName member variable, accessors, sqlizers, getOrder fns

CHANGED: Position.cs
-- Added _marketName member, and population by ctor lookup.

CHANGED: FillDAL.cs; OrderHistoryDAL.cs; WorkingOrderDAL.cs
-- Added MarketName column

CHANGED: PositionDAL.cs; PositionHistoryDAL.cs
-- Added MarketName column

CHANGED: Trading.aspx.cs
-- Added code to avoid loading deleted records in sql command
-- Added lookup of accounts when building sql command
-- Added MarketName column to order book data

CHANGED: TableCreateScript.sql (2 instances)
-- Added MarketName to WRK, HIS, FIL, POS and PHS tables

CHANGED: web.config
-- Changed pulled column list in SQL column spec
-- Changed list of mapping columns to include MarketName in order books
-- Moved to MySQL