/// <summary>
///
/// </summary>
/// <param name="InvestorGroupID"></param>
/// <param name="SecurityID"></param>
/// <returns></returns>
internal int AddIGroupSecurity(int InvestorGroupID, int SecurityID)
{
int Result = -1;
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;
Result = int.Parse(adap.AddIGroupSecurity(InvestorGroupID, SecurityID).ToString());
}
catch (Exception ex)
{
return -1;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <returns></returns>
internal int CountIGroupSecurity()
{
int? result = -1;
System.Data.SqlClient.SqlConnection conn = new SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IGroupSecurityTableAdapter adap = new DSTableAdapters.IGroupSecurityTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
result = adap.CountIGroupSecurity();
}
catch (Exception ex)
{
return -1;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return result.Value;
}
/// <summary>
///
/// </summary>
/// <param name="IGroupSecurityID"></param>
/// <returns></returns>
internal bool DeleteIGroupSecurityByIGroupSecurityID(int IGroupSecurityID)
{
bool Result = false;
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;
int ResultDelete = adap.DeleteIGroupSecurityByIGroupSecurityID(IGroupSecurityID);
if (ResultDelete > 0)
Result = true;
}
catch (Exception ex)
{
Result = false;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="IGroupSecurityID"></param>
/// <param name="SecurityID"></param>
/// <param name="InvestorGroupID"></param>
internal bool UpdateIGroupSecurity(int IGroupSecurityID, int SecurityID, 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.UpdateIGroupSecurity(SecurityID, InvestorGroupID, IGroupSecurityID);
}
catch (Exception ex)
{
return false;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="SecurityID"></param>
/// <returns></returns>
internal List<Business.IGroupSecurity> GetIGroupSecurityBySecurityID(int SecurityID)
{
List<Business.IGroupSecurity> Result = new List<Business.IGroupSecurity>();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IGroupSecurityTableAdapter adap = new DSTableAdapters.IGroupSecurityTableAdapter();
DS.IGroupSecurityDataTable tbIGroupSecurity = new DS.IGroupSecurityDataTable();
try
{
conn.Open();
adap.Connection = conn;
tbIGroupSecurity = adap.GetIGroupSecurityByInvestorGroupID(SecurityID);
if (tbIGroupSecurity != null)
{
int count = tbIGroupSecurity.Count;
for (int i = 0; i < count; i++)
{
Business.IGroupSecurity newParameterItem = new Business.IGroupSecurity();
newParameterItem.IGroupSecurityID = tbIGroupSecurity[i].IGroupSecurityID;
newParameterItem.SecurityID = tbIGroupSecurity[i].SecurityID;
newParameterItem.InvestorGroupID = tbIGroupSecurity[i].InvestorGroupID;
newParameterItem.IGroupSecurityConfig = DBWIGroupSecurity.DBWIGroupSecurityConfigInstance.GetIGroupSecurityConfigByIGroupSecurity(tbIGroupSecurity[i].IGroupSecurityID);
Result.Add(newParameterItem);
}
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="IGroupSecurityID"></param>
/// <returns></returns>
internal Business.IGroupSecurity GetIGroupSecurityByID(int IGroupSecurityID)
{
Business.IGroupSecurity Result = new Business.IGroupSecurity();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IGroupSecurityTableAdapter adap = new DSTableAdapters.IGroupSecurityTableAdapter();
DS.IGroupSecurityDataTable tbIGroupSecurity = new DS.IGroupSecurityDataTable();
try
{
conn.Open();
adap.Connection = conn;
tbIGroupSecurity = adap.GetIGroupSecurityByIGroupSecurityID(IGroupSecurityID);
if (tbIGroupSecurity != null)
{
Result.IGroupSecurityID = tbIGroupSecurity[0].IGroupSecurityID;
Result.InvestorGroupID = tbIGroupSecurity[0].InvestorGroupID;
Result.SecurityID = tbIGroupSecurity[0].SecurityID;
Result.IGroupSecurityConfig = DBWIGroupSecurity.DBWIGroupSecurityConfigInstance.GetIGroupSecurityConfigByIGroupSecurity(tbIGroupSecurity[0].IGroupSecurityID);
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <returns></returns>
internal List<Business.IGroupSecurity> GetAllIGroupSecurity()
{
List<Business.IGroupSecurity> Result = new List<Business.IGroupSecurity>();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IGroupSecurityTableAdapter adap = new DSTableAdapters.IGroupSecurityTableAdapter();
DSTableAdapters.IGroupSecurityConfigTableAdapter adapIGroupSecurityConfig = new DSTableAdapters.IGroupSecurityConfigTableAdapter();
DS.IGroupSecurityDataTable tbIGroupSecurity = new DS.IGroupSecurityDataTable();
DS.IGroupSecurityConfigDataTable tbIGroupSecurityConfig = new DS.IGroupSecurityConfigDataTable();
try
{
conn.Open();
adap.Connection = conn;
adapIGroupSecurityConfig.Connection = conn;
tbIGroupSecurity= adap.GetData();
if (tbIGroupSecurity != null)
{
int count = tbIGroupSecurity.Count;
for (int i = 0; i < count; i++)
{
Business.IGroupSecurity newIGroupSymbol = new Business.IGroupSecurity();
newIGroupSymbol.IGroupSecurityID = tbIGroupSecurity[i].IGroupSecurityID;
newIGroupSymbol.InvestorGroupID = tbIGroupSecurity[i].InvestorGroupID;
newIGroupSymbol.SecurityID = tbIGroupSecurity[i].SecurityID;
tbIGroupSecurityConfig = adapIGroupSecurityConfig.GetIGroupSecurityConfigByIGroupSecurity(tbIGroupSecurity[i].IGroupSecurityID);
//newIGroupSymbol.IGroupSecurityConfig = DBWIGroupSecurity.DBWIGroupSecurityConfigInstance.GetIGroupSecurityConfigByIGroupSecurity(tbIGroupSecurity[i].IGroupSecurityID);
if (tbIGroupSecurityConfig != null)
{
int countIGroupSecurityConfig = tbIGroupSecurityConfig.Count;
for (int j = 0; j < countIGroupSecurityConfig; j++)
{
Business.ParameterItem newParameter = new Business.ParameterItem();
newParameter.BoolValue = tbIGroupSecurityConfig[j].BoolValue;
newParameter.Code = tbIGroupSecurityConfig[j].Code;
newParameter.DateValue = tbIGroupSecurityConfig[j].DateValue;
newParameter.NumValue = tbIGroupSecurityConfig[j].NumValue;
newParameter.ParameterItemID = tbIGroupSecurityConfig[j].IGroupSecurityConfigID;
newParameter.SecondParameterID = tbIGroupSecurityConfig[j].IGroupSecurityID;
newParameter.StringValue = tbIGroupSecurityConfig[j].StringValue;
if (newIGroupSymbol.IGroupSecurityConfig == null)
newIGroupSymbol.IGroupSecurityConfig = new List<Business.ParameterItem>();
newIGroupSymbol.IGroupSecurityConfig.Add(newParameter);
}
}
Result.Add(newIGroupSymbol);
}
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
adapIGroupSecurityConfig.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
/// get all by group id
/// </summary>
/// <param name="id">group id</param>
/// <param name="connection">opended sql connection</param>
/// <returns></returns>
internal List<int> DFGetByInvestorGroupID(int id, SqlConnection connection,SqlTransaction trans)
{
List<int> ids = new List<int>();
DSTableAdapters.IGroupSecurityTableAdapter adap = new DSTableAdapters.IGroupSecurityTableAdapter();
adap.Connection = connection;
adap.Transaction = trans;
DS.IGroupSecurityDataTable tb= adap.GetIGroupSecurityByInvestorGroupID(id);
int count = tb.Rows.Count;
for (int i = 0; i < count; i++)
{
ids.Add(tb[i].IGroupSecurityID);
}
return ids;
}
/// <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;
}