/// <summary>
///
/// </summary>
/// <param name="SymbolID"></param>
/// <param name="CollectionValue"></param>
/// <param name="Name"></param>
/// <param name="Code"></param>
/// <param name="BoolValue"></param>
/// <param name="StringValue"></param>
/// <param name="NumValue"></param>
/// <param name="DateValue"></param>
/// <returns></returns>
internal int AddNewMarketArea(int MarketAreaID, int CollectionValue, string Name, string Code, int BoolValue,
string StringValue, string NumValue, DateTime DateValue)
{
int Result = -1;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.MarketAreaConfigTableAdapter adap = new DSTableAdapters.MarketAreaConfigTableAdapter();
DS.MarketAreaConfigDataTable tbMarketAreaConfig = new DS.MarketAreaConfigDataTable();
try
{
conn.Open();
adap.Connection = conn;
Result = int.Parse(adap.AddNewMarketAreaConfig(MarketAreaID, Code, CollectionValue, StringValue, NumValue, BoolValue, DateValue, Name).ToString());
}
catch (Exception ex)
{
return -1;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="MarketAreaID"></param>
/// <returns></returns>
internal List<Business.ParameterItem> GetMarketAreaConfigByMarketAreaID(int MarketAreaID)
{
List<Business.ParameterItem> Result = new List<Business.ParameterItem>();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.MarketAreaConfigTableAdapter adap = new DSTableAdapters.MarketAreaConfigTableAdapter();
DS.MarketAreaConfigDataTable tbMarketAreaConfig = new DS.MarketAreaConfigDataTable();
try
{
conn.Open();
adap.Connection = conn;
tbMarketAreaConfig = adap.GetMarketAreaConfigByMarketAreaID(MarketAreaID);
if (tbMarketAreaConfig != null)
{
int count = tbMarketAreaConfig.Count;
for (int i = 0; i < count; i++)
{
Business.ParameterItem newParameterItem = new Business.ParameterItem();
newParameterItem.ParameterItemID = tbMarketAreaConfig[i].MarketAreaConfigID;
newParameterItem.SecondParameterID = tbMarketAreaConfig[i].MarketAreaID;
newParameterItem.Code = tbMarketAreaConfig[i].Code;
newParameterItem.Name = tbMarketAreaConfig[i].Name;
newParameterItem.BoolValue = tbMarketAreaConfig[i].BoolValue;
newParameterItem.StringValue = tbMarketAreaConfig[i].StringValue;
newParameterItem.NumValue = tbMarketAreaConfig[i].NumValue;
newParameterItem.DateValue = tbMarketAreaConfig[i].DateValue;
Result.Add(newParameterItem);
}
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="MarketAreaConfigID"></param>
/// <returns></returns>
internal Business.ParameterItem GetMarketAreaConfigByID(int MarketAreaConfigID)
{
Business.ParameterItem Result = new Business.ParameterItem();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.MarketAreaConfigTableAdapter adap = new DSTableAdapters.MarketAreaConfigTableAdapter();
DS.MarketAreaConfigDataTable tbMarketAreaConfig = new DS.MarketAreaConfigDataTable();
try
{
conn.Open();
adap.Connection = conn;
tbMarketAreaConfig = adap.GetMarketAreaConfigByID(MarketAreaConfigID);
if (tbMarketAreaConfig != null)
{
Result.ParameterItemID = tbMarketAreaConfig[0].MarketAreaConfigID;
Result.SecondParameterID = tbMarketAreaConfig[0].MarketAreaID;
Result.Code = tbMarketAreaConfig[0].Code;
Result.Name = tbMarketAreaConfig[0].Name;
Result.BoolValue = tbMarketAreaConfig[0].BoolValue;
Result.StringValue = tbMarketAreaConfig[0].StringValue;
Result.NumValue = tbMarketAreaConfig[0].NumValue;
Result.DateValue = tbMarketAreaConfig[0].DateValue;
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
