private void Add_Products(int AccountId, int AccountSortCodeId, string paraStringProductId)
{
string[] strings = paraStringProductId.Trim().Split(',');
DataRow[] drs;
if (AccountId > 0)
{
foreach (string str in strings)
{
drs = TableBinary.Select(string.Format("AccountId = {0} AND AccountSortCodeId = 0 AND ProductId = {1} AND IsActive = 1", AccountId, Convert.ToInt32(str)));
if (drs.Length == 0)
{
AddTransaction(AccountId, 0, Convert.ToInt32(str), true);
}
}
}
if (AccountSortCodeId > 0)
{
foreach (string str in strings)
{
drs = TableBinary.Select(string.Format("AccountId = 0 AND AccountSortCodeId = {0} AND ProductId = {1} AND IsActive = 1", AccountSortCodeId, Convert.ToInt32(str)));
if (drs.Length == 0)
{
AddTransaction(0, AccountSortCodeId, Convert.ToInt32(str), true);
}
}
}
}
public void Inactivate_AccountId(int AccountId, int AccountSortCodeId)
{
DataRow[] drs = TableBinary.Select(string.Format("AccountId = {0} AND AccountSortCodeId = {1} AND IsActive = 1", AccountId, AccountSortCodeId));
foreach (DataRow dr in drs)
{
InactivateTransaction(dr.Field <int>("Id"));
}
}
public string GetProductIdString(int AccountId, int AccountSortCodeId)
{
DataRow[] drs;
string str = "";
drs = TableBinary.Select(string.Format("AccountId = {0} AND AccountSortCodeId = {1} AND IsActive = 1", AccountId, AccountSortCodeId));
foreach (DataRow dr in drs)
{
str = str + dr.Field <int>("ProductId").ToString() + ", ";
}
if (str.Length > 0)
{
str = str.Substring(0, str.Length - 2);
}
else
{
str = "";
}
return(str);
}