public VMIndex()
{
_lstOpenTrades = null;
_lstTradeHistory = null;
_VMOptionFilterType = null;
}
public VMIndex(List<CTrade> lstOpenTrades, List<CTrade> lstTradeHistory, VMOptionFilterType oVMOptionFilterType)
{
_lstOpenTrades = lstOpenTrades;
_lstTradeHistory = lstTradeHistory;
_VMOptionFilterType = oVMOptionFilterType;
}
public VMOptionFilterType GetOptionFilters(int UserId)
{
VMOptionFilterType objVMOptionFilterType = new VMOptionFilterType();
objVMOptionFilterType.lstVMOptionFilter = new List<VMOptionFilter>();
using (SqlConnection cnn = new SqlConnection(CommonCollection.ConnectionString))
{
try
{
cnn.Open();
using (SqlCommand cmm = new SqlCommand("select SymbolTypeId,SymbolTypeName from SymbolType_info", cnn))
{
using (SqlDataAdapter a = new SqlDataAdapter(cmm))
{
DataTable t = new DataTable();
a.Fill(t);
if (t.Rows.Count > 0)
{
foreach (DataRow dtRow in t.Rows)
{
using (SqlCommand cmd = new SqlCommand("SELECT SYMBOLID,SYMBOLNAME,SYMBOLTYPE FROM SYMBOL_INFO WHERE SYMBOLTYPE = " + dtRow["SymbolTypeId"].ToString() + "ORDER BY TABINDEX", cnn))
{
using (SqlDataAdapter a1 = new SqlDataAdapter(cmd))
{
DataTable t1 = new DataTable();
a1.Fill(t1);
VMOptionFilter objVMOptionFilter = new VMOptionFilter();
objVMOptionFilter.lstCSymbol = new List<CSymbol>();
objVMOptionFilter.oCSymbolType = new CSymbolType();
foreach (DataRow dtRow1 in t1.Rows)
{
CSymbol objCSymbol = new CSymbol();
objCSymbol.SymbolId = Convert.ToInt32(dtRow1["SYMBOLID"]);
objCSymbol.SymbolName = dtRow1["SYMBOLNAME"].ToString();
objCSymbol.SymbolType = Convert.ToInt32(dtRow1["SYMBOLTYPE"]);
objVMOptionFilter.lstCSymbol.Add(objCSymbol);
}
objVMOptionFilter.oCSymbolType.SymbolTypeId = Convert.ToInt32(dtRow["SymbolTypeId"]);
objVMOptionFilter.oCSymbolType.SymbolTypeName = dtRow["SymbolTypeName"].ToString();
objVMOptionFilterType.lstVMOptionFilter.Add(objVMOptionFilter);
}
}
}
}
}
}
}
catch (Exception ex)
{
//throw new Exception(ex.ToString(), ex);
}
finally
{
cnn.Close();
cnn.Dispose();
GC.Collect();
SqlConnection.ClearPool(cnn);
}
return objVMOptionFilterType;
}
}
