/// <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; }