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; } }