public int ProcessCommission(string[] data)
{
int i = 0;
foreach (string SaleID in data)
{
int TotalCommission = GetCommission(SaleID);
string BusinessID = GetBusinessID(SaleID);
DateTime LastUpdated = DateTime.Now;
var Validation = GetCurrentCommision(BusinessID);
int NewBalance;
if (Validation.ValidChecker.Length > 1)
{
string[] validChecker = SystemTools.Decrypt(Validation.ValidChecker.ToString().Trim()).Split(',');
DateTime validDate = Convert.ToDateTime(validChecker[0]);
int validAmount = int.Parse(validChecker[1]);
if (validAmount != Convert.ToInt32(Validation.AvailableBalance) && validDate != Validation.DateUpdated)
{
return(99);
}
NewBalance = validAmount + TotalCommission;
}
else
{
NewBalance = 0 + TotalCommission;
}
string NewValidChecker = SystemTools.EncryptPass(LastUpdated.ToString("yyyy-MM-dd HH:mm:ss") + "," + NewBalance);
try
{
using (SqlConnection con = new SqlConnection(VendorConn))
{
con.Open();
using (SqlCommand com = new SqlCommand("UPDATE tbl_comm set actual_bal=actual_bal-@TotalCommission,available_bal=@NewBalance,ValidChecker=@NewValidChecker,DateUpdated=@DateUpdated WHERE business_id=@BusinessID", con))
{
com.Parameters.AddWithValue("@TotalCommission", TotalCommission);
com.Parameters.AddWithValue("@NewBalance", NewBalance);
com.Parameters.AddWithValue("@NewValidChecker", NewValidChecker);
com.Parameters.AddWithValue("@DateUpdated", LastUpdated);
com.Parameters.AddWithValue("@BusinessID", BusinessID);
i = com.ExecuteNonQuery();
}
}
SQLExecutor("Update tbl_sales_details set status=1 where sale_id='" + SaleID + "'");
}
catch (Exception ex)
{
}
}
return(i);
}