public static IList <ColumnSettingsInfo> GetColumnSettings(string userId, string tabID)
{
using (var clientCtx = new ClientDbContext())
{
return(clientCtx.ColumnSettingsInfo.Where(u => u.AccountID == userId && u.TabID == tabID).ToList());
}
}
public static LayoutInfo GetLayout(string userId, string frameID)
{
using (var clientCtx = new ClientDbContext())
{
return(clientCtx.LayoutInfo.FirstOrDefault(u => u.UserID == userId && u.FrameID == frameID));
}
}
public static IList <FilterSettings> GetFilterSettings(string userId, string ctrlID)
{
using (var clientCtx = new ClientDbContext())
{
return((clientCtx.FilterSettings.Where(c => c.UserID == userId && c.CtrlID == ctrlID)).ToList());
}
}
public static IEnumerable <int> GetOrderStatus(string userId, string tabID)
{
using (var clientCtx = new ClientDbContext())
{
return(clientCtx.OrderStatusFilter.Where(u => u.AccountID == userId && u.TabID == tabID).Select(u => u.Orderstatus).ToList());
}
}
public static IEnumerable <string> GetUserContracts(string userId, string tabID)
{
using (var clientCtx = new ClientDbContext())
{
return(clientCtx.MarketContract.Where(u => u.AccountID == userId && u.TabID == tabID).
Select(u => u.Contract).ToList());
}
}
public static void DeleteAllColumnSettings(string userId, string tabID)
{
using (var clientCtx = new ClientDbContext())
{
var columnInfos = clientCtx.ColumnSettingsInfo.Where(t => t.AccountID == userId && t.TabID == tabID);
clientCtx.ColumnSettingsInfo.RemoveRange(columnInfos);
clientCtx.SaveChanges();
}
}
public static void DeleteLayoutInfo(string userID, string frameID)
{
using (var clientCtx = new ClientDbContext())
{
var layoutInfos = clientCtx.LayoutInfo.Where(t => t.UserID == userID && t.FrameID == frameID);
clientCtx.LayoutInfo.RemoveRange(layoutInfos);
clientCtx.SaveChanges();
}
}
public static void DeleteFilterSettings(string id)
{
using (var clientCtx = new ClientDbContext())
{
var filterinfo = clientCtx.FilterSettings.FirstOrDefault(t => t.Id == id);
if (filterinfo != null)
{
clientCtx.FilterSettings.Remove(filterinfo);
}
clientCtx.SaveChanges();
}
}
public static void DeleteColumnSettings(string userId, string tabID, int columnIdx)
{
using (var clientCtx = new ClientDbContext())
{
var columnInfo = clientCtx.ColumnSettingsInfo.FirstOrDefault(t => t.AccountID == userId &&
t.ColumnIdx == columnIdx && t.TabID == tabID);
if (columnInfo != null)
{
clientCtx.ColumnSettingsInfo.Remove(columnInfo);
}
clientCtx.SaveChanges();
}
}
public static void DeleteOrderStatus(string userId, string tabID, int status)
{
using (var clientCtx = new ClientDbContext())
{
var orderstatus = clientCtx.OrderStatusFilter.FirstOrDefault(t => t.AccountID == userId &&
t.Orderstatus == status && t.TabID == tabID);
if (orderstatus != null)
{
clientCtx.OrderStatusFilter.Remove(orderstatus);
}
clientCtx.SaveChanges();
}
}
public static void DeleteUserContracts(string userId, string tabID, string contract)
{
using (var clientCtx = new ClientDbContext())
{
var contractinfo = clientCtx.MarketContract.FirstOrDefault(t => t.AccountID == userId &&
t.Contract == contract && t.TabID == tabID);
if (contractinfo != null)
{
clientCtx.MarketContract.Remove(contractinfo);
}
clientCtx.SaveChanges();
}
}
public static void SaveColumnSettings(string userID, string tabID, int columnIdx)
{
using (var clientCtx = new ClientDbContext())
{
var columnInfo = clientCtx.ColumnSettingsInfo.FirstOrDefault(t => t.AccountID == userID && t.TabID == tabID && t.ColumnIdx == columnIdx);
if (columnInfo == null)
{
columnInfo = new ColumnSettingsInfo
{
AccountID = userID,
ColumnIdx = columnIdx,
TabID = tabID,
};
clientCtx.ColumnSettingsInfo.Add(columnInfo);
clientCtx.SaveChanges();
}
}
}
public static void SaveOrderStatus(string userID, int status, string tabID)
{
using (var clientCtx = new ClientDbContext())
{
var orderstatus = clientCtx.OrderStatusFilter.FirstOrDefault(t => t.AccountID == userID && t.Orderstatus == status && t.TabID == tabID);
if (orderstatus == null)
{
orderstatus = new OrderStatusFilter
{
AccountID = userID,
Orderstatus = status,
TabID = tabID,
};
clientCtx.OrderStatusFilter.Add(orderstatus);
clientCtx.SaveChanges();
}
}
}
public static void SaveMarketContract(string userID, string contract, string tabID)
{
using (var clientCtx = new ClientDbContext())
{
var marketcontract = clientCtx.MarketContract.FirstOrDefault(t => t.AccountID == userID && t.Contract == contract && t.TabID == tabID);
if (marketcontract == null)
{
marketcontract = new MarketContract
{
AccountID = userID,
Contract = contract,
TabID = tabID,
};
clientCtx.MarketContract.Add(marketcontract);
clientCtx.SaveChanges();
}
}
}
public static ContractInfo FindContract(string contract)
{
ContractInfo ret;
if (!ContractDict.TryGetValue(contract, out ret))
{
using (var ctx = new ClientDbContext())
{
ret = ctx.ContractInfo.FirstOrDefault(c => c.Contract == contract);
if (ret != null)
{
ContractDict[ret.Contract] = ret;
}
}
}
return(ret);
}
public static IList <ContractInfo> GetContractFromCache(int productType)
{
IList <ContractInfo> ret;
ContractCache.TryGetValue(productType, out ret);
if (ret == null)
{
using (var ctx = new ClientDbContext())
{
ret = ctx.GetContractsByProductType(productType);
if (ret.Any())
{
ContractCache[productType] = ret;
}
}
}
return(ret);
}
public static void SaveLayoutInfo(string userID, string frameID, string layoutCFG)
{
using (var clientCtx = new ClientDbContext())
{
var layoutInfo = clientCtx.LayoutInfo.FirstOrDefault(t => t.UserID == userID && t.FrameID == frameID);
if (layoutInfo == null)
{
layoutInfo = new LayoutInfo
{
UserID = userID,
FrameID = frameID,
LayoutCFG = layoutCFG,
};
clientCtx.LayoutInfo.Add(layoutInfo);
}
else
{
layoutInfo.LayoutCFG = layoutCFG;
}
clientCtx.SaveChanges();
}
}
public static void SaveFilterSettings(string userID, string ctrlID, string id, string title, string exchange, string contract, string underlying, string portfolio)
{
using (var clientCtx = new ClientDbContext())
{
var filterinfo = clientCtx.FilterSettings.FirstOrDefault(t => t.Id == id);
if (filterinfo == null)
{
filterinfo = new FilterSettings
{
Id = id
};
//insert new record
clientCtx.FilterSettings.Add(filterinfo);
}
filterinfo.CtrlID = ctrlID;
filterinfo.Title = title;
filterinfo.Exchange = exchange;
filterinfo.Underlying = underlying;
filterinfo.Contract = contract;
filterinfo.UserID = userID;
filterinfo.Portfolio = portfolio;
clientCtx.SaveChanges();
}
}
