/// <summary>
/// Delete by investor group id
/// </summary>
/// <param name="id">group id</param>
/// <param name="connection">opened sqlconnection</param>
/// <returns></returns>
internal bool DFDeleteByInvestorGroupID(int id, SqlConnection connection,SqlTransaction trans)
{
List<int> igroupSecurityIDs = this.DFGetByInvestorGroupID(id, connection,trans);
int count = igroupSecurityIDs.Count;
for (int i = 0; i < count; i++)
{
DBWIGroupSecurityConfig dbwIGroupSecurityConfig = new DBWIGroupSecurityConfig();
dbwIGroupSecurityConfig.DFDeleteByIGroupSecurityID(igroupSecurityIDs[i], connection,trans);
}
DSTableAdapters.IGroupSecurityTableAdapter adap = new DSTableAdapters.IGroupSecurityTableAdapter();
adap.Connection = connection;
adap.Transaction = trans;
adap.DeleteIGroupSecurityByInvestorGroupID(id);
return true;
}
/// <summary>
///
/// </summary>
/// <param name="InvestorGroupID"></param>
/// <returns></returns>
internal bool DeleteIGroupSecurityByInvestorGroupID(int InvestorGroupID)
{
bool Result = true;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IGroupSecurityTableAdapter adap = new DSTableAdapters.IGroupSecurityTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
adap.DeleteIGroupSecurityByInvestorGroupID(InvestorGroupID);
}
catch (Exception ex)
{
Result = false;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}