internal int AddNewIAgentSecurityByListIAgentSecurity(List<Business.IAgentSecurity> ListIAgentSecurity)
{
int Result = -1;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
int count = ListIAgentSecurity.Count;
for (int i = 0; i < count; i++)
{
Result = int.Parse(adap.AddIAgentSecurity(ListIAgentSecurity[i].AgentID, ListIAgentSecurity[i].SecurityID, ListIAgentSecurity[i].Use, ListIAgentSecurity[i].MinLots.ToString(), ListIAgentSecurity[i].MaxLots.ToString()).ToString());
}
}
catch (Exception ex)
{
return -1;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="AgentID"></param>
/// <returns></returns>
internal int DeleteIAgentSecurityByAgentID(int AgentID)
{
int Result = -1;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
Result = adap.DeleteIAgentSecurityByAgentID(AgentID);
}
catch (Exception ex)
{
Result = -1;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="AgentID"></param>
/// <param name="SecurityID"></param>
/// <returns></returns>
internal int AddNewIAgentSecurity(int AgentID, int SecurityID,bool IsUse,string MinLots,string MaxLots)
{
int Result = -1;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
Result = int.Parse(adap.AddIAgentSecurity(AgentID, SecurityID,IsUse,MinLots,MaxLots).ToString());
}
catch (Exception ex)
{
return -1;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="IAgentSecurityID"></param>
/// <param name="AgentID"></param>
/// <param name="SecurityID"></param>
/// <returns></returns>
internal bool UpdateIAgentSecurity(int IAgentSecurityID, int AgentID, int SecurityID,bool IsUse,string MinLots,string MaxLots)
{
bool Result = true;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
adap.UpdateIAgentSecurity(AgentID, SecurityID,IsUse,MinLots,MaxLots,IAgentSecurityID);
}
catch (Exception ex)
{
return false;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="SecurityID"></param>
/// <returns></returns>
internal List<Business.IAgentSecurity> GetIAgentSecurityBySecurityID(int SecurityID)
{
List<Business.IAgentSecurity> Result = new List<Business.IAgentSecurity>();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
DS.IAgentSecurityDataTable tbIAgentSecurity = new DS.IAgentSecurityDataTable();
try
{
conn.Open();
adap.Connection = conn;
tbIAgentSecurity = adap.GetIAgentSecurityBySecurityID(SecurityID);
if (tbIAgentSecurity != null)
{
int count = tbIAgentSecurity.Count;
for (int i = 0; i < count; i++)
{
Business.IAgentSecurity newIAgentSecurity = new Business.IAgentSecurity();
newIAgentSecurity.IAgentSecurityID = tbIAgentSecurity[i].IAgentSecurityID;
newIAgentSecurity.AgentID = tbIAgentSecurity[i].AgentID;
newIAgentSecurity.SecurityID = tbIAgentSecurity[i].SecurityID;
double min = 0;
double max = 0;
double.TryParse(tbIAgentSecurity[i].MinLots, out min);
double.TryParse(tbIAgentSecurity[i].MaxLots, out max);
newIAgentSecurity.MinLots = min;
newIAgentSecurity.MaxLots = max;
Result.Add(newIAgentSecurity);
}
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
///
/// </summary>
/// <param name="IAgentSecurityID"></param>
/// <returns></returns>
internal Business.IAgentSecurity GetIAgentSecurityByIAgentSecurityID(int IAgentSecurityID)
{
Business.IAgentSecurity Result = new Business.IAgentSecurity();
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
DS.IAgentSecurityDataTable tbIAgentGroup = new DS.IAgentSecurityDataTable();
try
{
conn.Open();
adap.Connection = conn;
tbIAgentGroup = adap.GetIAgentSecurityByIAgentSecurityID(IAgentSecurityID);
if (tbIAgentGroup != null)
{
Result.IAgentSecurityID = tbIAgentGroup[0].IAgentSecurityID;
Result.SecurityID = tbIAgentGroup[0].SecurityID;
Result.AgentID = tbIAgentGroup[0].AgentID;
double min = 0;
double max = 0;
double.TryParse(tbIAgentGroup[0].MinLots, out min);
double.TryParse(tbIAgentGroup[0].MaxLots, out max);
Result.MinLots = min;
Result.MaxLots = max;
}
}
catch (Exception ex)
{
return null;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
/// <summary>
/// delete IAgentSecurity by securityID
/// </summary>
/// <param name="securityID"></param>
/// <param name="connection"></param>
/// <returns></returns>
internal bool DFDeleteBySecurityID(int securityID,SqlConnection connection,SqlTransaction trans)
{
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
adap.Connection = connection;
adap.Transaction = trans;
int affectRow= adap.DeleteIAgentSecurityBySecurityID(securityID);
if (affectRow == 0)
return false;
else
return true;
}
/// <summary>
///
/// </summary>
/// <param name="SecurityID"></param>
/// <returns></returns>
internal bool DeleteIAgentSecurityBySecurityID(int SecurityID)
{
bool Result = false;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(DBConnection.DBConnection.Connection);
DSTableAdapters.IAgentSecurityTableAdapter adap = new DSTableAdapters.IAgentSecurityTableAdapter();
try
{
conn.Open();
adap.Connection = conn;
adap.DeleteIAgentSecurityBySecurityID(SecurityID);
Result = true;
}
catch (Exception ex)
{
Result = false;
}
finally
{
adap.Connection.Close();
conn.Close();
}
return Result;
}
