/// <summary>
/// Get Investor Group Config By Investor Group Config ID
/// Using List Result Call Function Delete In Table InvestorGroupConfig
/// </summary>
/// <param name="InvestorGroupConfigID">int InvestorGroupConfigID</param>
/// <returns>List<Business.ParameterItem></returns>
internal List<Business.ParameterItem> GetInvestorGroupConfigByID(int InvestorGroupConfigID)
{
List<Business.ParameterItem> Result = new List<Business.ParameterItem>();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.InvestorGroupConfigTableAdapter adap = new DSTableAdapters.InvestorGroupConfigTableAdapter();
DS.InvestorGroupConfigDataTable tbInvestorGroupConfig = new DS.InvestorGroupConfigDataTable();
try
{
conn.Open();
adap.Connection = conn;
tbInvestorGroupConfig = adap.GetInvestorGroupConfigByID(InvestorGroupConfigID);
if (tbInvestorGroupConfig != null)
{
Business.ParameterItem newParameterItem = new Business.ParameterItem();
newParameterItem.BoolValue = tbInvestorGroupConfig[0].BoolValue;
newParameterItem.Code = tbInvestorGroupConfig[0].Code;
newParameterItem.DateValue = tbInvestorGroupConfig[0].DateValue;
newParameterItem.SecondParameterID = tbInvestorGroupConfig[0].InvestorGroupID;
newParameterItem.Name = tbInvestorGroupConfig[0].Name;
newParameterItem.NumValue = tbInvestorGroupConfig[0].NumValue;
newParameterItem.ParameterItemID = tbInvestorGroupConfig[0].InvestorGroupConfigID;
newParameterItem.StringValue = tbInvestorGroupConfig[0].StringValue;
newParameterItem.CollectionValue = this.GetInvestorGroupConfigByCollectionValue(tbInvestorGroupConfig[0].InvestorGroupConfigID);
Result.Add(newParameterItem);
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
