public CustomerReceiptCreditDetails GetCustomerReceiptDetails(int recordId)
{
CustomerReceiptCreditDetails cust = new CustomerReceiptCreditDetails();
try
{
procommand = PegPay_DB.GetStoredProcCommand("GetCustomerReceiptDetails", recordId);
DataTable dt = PegPay_DB.ExecuteDataSet(procommand).Tables[0];
if (dt.Rows.Count > 0)
{
cust.CustomerCode = dt.Rows[0]["CustomerCode"].ToString();
cust.CustomerAccount = dt.Rows[0]["CustomerAccount"].ToString();
cust.CustomerCreditAmount = dt.Rows[0]["CreditAmount"].ToString();
cust.ReceiptNumber = recordId;
cust.StatusCode = "0";
cust.StatusDescription = "SUCCESS";
}
else
{
cust.StatusCode = "100";
cust.StatusDescription = "INVALID CUSTOMER CODE.";
}
}
catch (Exception ex)
{
GetCustomerReceiptDetails(recordId);
// throw ex;
}
return(cust);
}
private void ProcessApprovals(string str)
{
try
{
int suc = 0;
int failed = 0;
int count = 0;
string[] arr = str.Split(',');
int i = 0;
string User = Session["UserName"].ToString();
for (i = 0; i < arr.Length; i++)
{
int RecordId = int.Parse(arr[i].ToString());
string ss = datafile.ApproveAccountCredit(RecordId);
if (ss.Equals("SUCCESS"))
{
count++;
//update approved credits
datafile.UpdateApprovedCredit(RecordId, User);
//Insert into
CustomerReceiptCreditDetails cust = datafile.GetCustomerReceiptDetails(RecordId);
DateTime todaydate = DateTime.Now;
string datetoday = todaydate.ToString().Replace("/", "-").Replace(":", "-").Replace(" ", "-");
string vendorTranld = "CREDIT" + datetoday;
int insertedstatuscount = 0;
insertedstatuscount = datafile.InsertIntoReceivedPrepaidTxns(cust.CustomerCode, cust.CustomerAccount, cust.CustomerCreditAmount, vendorTranld);
if (insertedstatuscount > 0)
{
//UpdateCustomerAccount
int updatestatuscount = 0;
updatestatuscount = datafile.UpdatePrepaidCustomerAccountBalance(cust.CustomerCode, cust.CustomerCreditAmount, cust.CustomerAccount);
if (updatestatuscount > 0)
{
}
}
}
else
{
failed++;
}
}
string msg = suc + " Credits Have Been Approved and " + failed + "Failed";
//datafile.LogActivity(Session["UserName"].ToString(), "Approved Account Credits Details");
ShowMessage(msg, false);
}
catch (Exception ex)
{
throw ex;
}
}
