/// <summary>
///
/// </summary>
/// <returns></returns>
internal List<IPresenter.IMarketArea> GetAllMarketArea()
{
List<IPresenter.IMarketArea> Result = new List<IPresenter.IMarketArea>();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.MarketAreaTableAdapter adap = new DSTableAdapters.MarketAreaTableAdapter();
DS.MarketAreaDataTable tbMarketArea = new DS.MarketAreaDataTable();
TradingServer.DBW.DBWMarketAreaConfig newMarketAreaConfig = new DBWMarketAreaConfig();
try
{
conn.Open();
adap.Connection = conn;
tbMarketArea = adap.GetData();
if (tbMarketArea != null)
{
int count = tbMarketArea.Count;
for (int i = 0; i < count; i++)
{
switch (tbMarketArea[i].Name)
{
case "SpotCommand":
{
IPresenter.IMarketArea newIMarketArea = new Business.SpotCommand();
newIMarketArea.IMarketAreaID = tbMarketArea[i].MartketAreaID;
newIMarketArea.IMarketAreaName = tbMarketArea[i].Name;
newIMarketArea.MarketAreaConfig = newMarketAreaConfig.GetMarketAreaConfigByMarketAreaID(tbMarketArea[i].MartketAreaID);
Result.Add(newIMarketArea);
}
break;
}
}
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="MarketAreaID"></param>
/// <returns></returns>
internal IPresenter.IMarketArea GetMarketAreaByID(int MarketAreaID)
{
IPresenter.IMarketArea Result = new Business.SpotCommand();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.MarketAreaTableAdapter adap = new DSTableAdapters.MarketAreaTableAdapter();
DS.MarketAreaDataTable tbMarketArea = new DS.MarketAreaDataTable();
TradingServer.DBW.DBWMarketAreaConfig newMarketAreaConfig = new DBWMarketAreaConfig();
try
{
conn.Open();
adap.Connection = conn;
tbMarketArea = adap.GetMarketAreaByID(MarketAreaID);
if (tbMarketArea != null)
{
switch (tbMarketArea[0].Name)
{
case "SpotCommand":
{
Result = new Business.SpotCommand();
Result.IMarketAreaID = tbMarketArea[0].MartketAreaID;
Result.IMarketAreaName = tbMarketArea[0].Name;
Result.MarketAreaConfig = newMarketAreaConfig.GetMarketAreaConfigByMarketAreaID(tbMarketArea[0].MartketAreaID);
}
break;
}
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
