public void PostBillTransaction(string param1, string param2, string billsCode, string wallet, float amount, float balance, string fullname, string customerNum) { Database.DBRetailers upd = new Database.DBRetailers(); Database.DBPostpaidBill.DBPostpaidBill postbills = Database.DBPostpaidBill.DBPostpaidBill.GetDataByCode(billsCode); float deduct = postbills.ServiceCharge + amount; float bal = balance - deduct; upd.UpdateBalance(wallet, bal); Database.DBMessages.DBOutbox add = new Database.DBMessages.DBOutbox(); Database.DBTransactions.DBPostpaidBillTransaction billtrans = new Database.DBTransactions.DBPostpaidBillTransaction(); billtrans.Add(DateTime.Now, billsCode, param1, param2, amount, wallet, "Pending", "", fullname, postbills.ServiceCharge, deduct, customerNum); Database.DBTransactions.DBPostpaidBillTransaction retrieve = Database.DBTransactions.DBPostpaidBillTransaction.GetDataLast(); add.Add(DateTime.Now, wallet, "A1+ Payment System : Your " + billsCode + " bill has been accepted, payment posting is w/in 24hrs. Pls keep your tracking #" + retrieve.Id.ToString("D6") + ". Current bal " + bal + ".", "Pending"); if (customerNum != "") { add.Add(DateTime.Now, customerNum, "Thank you using A1+ System. Your " + billsCode + " bill has been accepted, payment posting is w/in 24hrs. Pls keep yout tracking#" + retrieve.Id.ToString("D6") + ".", "Pending"); } }
private void cmd_Save_Click(object sender, EventArgs e) { if (input_Validity() == true) { Database.DBTransactions.DBPostpaidBillTransaction update = new Database.DBTransactions.DBPostpaidBillTransaction(); update.Update(Convert.ToInt32(TrackingNumber), BoxBillerReciept, Status); Database.DBRetailers ret = Database.DBRetailers.GetDataByWallet(Wallet); if (comboBox_Status.Text == "Unsuccessful") { float refund = (float)(Convert.ToDouble(Total)) + ret.Balance; Database.DBRetailers upd = new Database.DBRetailers(); upd.UpdateBalance(Wallet, refund); Class.Message add = new Class.Message(); add.AddtoOutBox(DateTime.Now, Wallet, WalletMessage, "Pending"); if (maskedTextBoxCustomerNumber.MaskCompleted) { add.AddtoOutBox(DateTime.Now, Customer_Number, CustomerMessage, "Pending"); } } if (comboBox_Status.Text == "Paid") { Class.Message add = new Class.Message(); add.AddtoOutBox(DateTime.Now, Wallet, WalletMessage, "Pending"); if (maskedTextBoxCustomerNumber.MaskCompleted) { add.AddtoOutBox(DateTime.Now, Customer_Number, CustomerMessage, "Pending"); } } ControlDisable(); } this.Close(); }