private string UpdateUnsuccessfulWalletUserMessage() { Database.DBRetailers rec = Database.DBRetailers.GetDataByWallet(Wallet); float refund = rec.Balance + (float)Convert.ToDouble(Total); return("Sorry your " + BillsCode + "bill w/ acct#" + Parameter + " is not successful. " + Total + " is refunded to your wallet. Current bal " + Convert.ToString(refund) + " ."); }
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 dataGridView_BillsPaymentTransac_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e) { Database.DBRetailers rec = Database.DBRetailers.GetDataByWallet(this.dataGridView_BillsPaymentTransac.SelectedCells[1].Value.ToString()); Forms.BillsPayment bill = new Forms.BillsPayment(); bill.Show(); bill.TrackingNumber = this.dataGridView_BillsPaymentTransac.SelectedCells[0].Value.ToString(); bill.Wallet = this.dataGridView_BillsPaymentTransac.SelectedCells[1].Value.ToString(); bill.BillsCode = this.dataGridView_BillsPaymentTransac.SelectedCells[2].Value.ToString(); bill.Parameter = this.dataGridView_BillsPaymentTransac.SelectedCells[3].Value.ToString() + "/" + this.dataGridView_BillsPaymentTransac.SelectedCells[4].Value.ToString(); bill.Amount = this.dataGridView_BillsPaymentTransac.SelectedCells[5].Value.ToString(); bill.ConvFee = this.dataGridView_BillsPaymentTransac.SelectedCells[6].Value.ToString(); bill.Customer_Fullname = this.dataGridView_BillsPaymentTransac.SelectedCells[8].Value.ToString(); bill.Customer_Number = this.dataGridView_BillsPaymentTransac.SelectedCells[10].Value.ToString(); bill.DateTransact = Convert.ToDateTime(this.dataGridView_BillsPaymentTransac.SelectedCells[9].Value.ToString()); bill.WalletUser = rec.Fname + " " + rec.Lname; bill.Total = this.dataGridView_BillsPaymentTransac.SelectedCells[5].Value.ToString() + this.dataGridView_BillsPaymentTransac.SelectedCells[6].Value.ToString(); bill.Status = this.dataGridView_BillsPaymentTransac.SelectedCells[11].Value.ToString(); bill.BoxBillerReciept = this.dataGridView_BillsPaymentTransac.SelectedCells[7].Value.ToString(); if (this.dataGridView_BillsPaymentTransac.SelectedCells[11].Value.ToString() == "Paid" || this.dataGridView_BillsPaymentTransac.SelectedCells[11].Value.ToString() == "Unsuccessful") { bill.ControlDisable(); } }
private void cmd_Add_Click(object sender, EventArgs e) { load_ProviceList(); if (input_Validity() == true) { Database.DBRetailers r = new Database.DBRetailers(); r.Add(DateRegistered, Wallet_ID, Firstname, Lastname, Birthdate, Barangay, City, Province, BlockStr, Balance, Frozen, Sponsor_ID); load_dataGridView_Retailer(); input_clear(); this.cmd_Save.Enabled = this.cmd_Delete.Enabled = false; } }
private void cmd_Delete_Click(object sender, EventArgs e) { DialogResult dialogResult = MessageBox.Show(" Are You Sure ? ", "Warning !", MessageBoxButtons.YesNo, MessageBoxIcon.Error); if (dialogResult == DialogResult.Yes) { Database.DBRetailers del = new Database.DBRetailers(); del.Delete(Wallet_ID); load_dataGridView_Retailer(); this.cmd_Delete.Enabled = this.cmd_Save.Enabled = false; this.cmd_Add.Enabled = true; input_clear(); } }
private void cmd_Save_Click(object sender, EventArgs e) { if (input_Validity() == true) { Database.DBRetailers edit = new Database.DBRetailers(); edit.Update(DateRegistered, Wallet_ID, Firstname, Lastname, Birthdate, Barangay, City, Province, BlockStr); int selectedIndex = this.dataGridView_Retailer.CurrentCell.RowIndex; this.dataGridView_Retailer.Rows[selectedIndex].SetValues(Wallet_ID, DateRegistered.ToShortDateString(), Firstname, Lastname, Birthdate.ToShortDateString(), BlockStr, Barangay, City, Province); input_enableStatus(false); buttonEnable(false); this.cmd_Edit.Enabled = true; } }
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(); }
public bool PrepaidCableParsing(string mess, string sender) { string message = mess.ToUpper(); string[] words = message.Split(" ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); Array arr = words; Database.DBRetailers ret = Database.DBRetailers.GetDataByWallet(sender); if (ret != null) { Database.DBPrepaidCable.DBPrepaidCable preCable = Database.DBPrepaidCable.DBPrepaidCable.GetDataByCode(words[0].ToUpper()); if (preCable != null) { if (arr.Length == 4) { try { if ((float)(ret.Balance) >= (float)(Convert.ToDouble(words[2]) - (Convert.ToDouble(words[2]) * Convert.ToDouble(.02)))) { Database.DBPrepaidCable.DBPrepaidCards datalist = Database.DBPrepaidCable.DBPrepaidCards.GetDataByAmount(Convert.ToInt32(words[2]), preCable.Code); if (datalist != null) { float amountcoded = (float)(Convert.ToDouble(words[2])); float discount = amountcoded * (float)(0.02); Database.DBTransactions.DBPrepaidCableTransactions transac = new Database.DBTransactions.DBPrepaidCableTransactions(); transac.Add(sender, words[0], words[1], amountcoded, discount, datalist.Pin, words[3], DateTime.Now, "Sending"); if (PhoneNumberParsing(words[3]) != "") { //SEND TO CUSTOMER if (words[0] == "CIGNAL" || words[0] == "DREAM") { AddtoOutBox(DateTime.Now, words[3], words[0] + " " + datalist.Pin + " " + words[1] + "\n" + preCable.Gateway, "Pending"); } //sky or Gsat if (words[0] == "SKY" || words[0] == "GSAT") { AddtoOutBox(DateTime.Now, words[3], words[0] + " " + words[1] + " " + datalist.Pin + "\n" + preCable.Gateway, "Pending"); } return(true); } AddtoOutBox(DateTime.Now, sender, "Invalid Customer Number.", "Pending"); return(false); } AddtoOutBox(DateTime.Now, sender, "Amount : " + words[2] + " Code : " + words[0] + " None Available", "Pending"); return(false); } //youWallet is none enough AddtoOutBox(DateTime.Now, sender, "Your balance is " + ret.Balance + " None enough", "Pending"); return(false); } catch (Exception ex) { ex.ToString(); //No Code Amount Detected AddtoOutBox(DateTime.Now, sender, "Invalid Code ! must be a Number Amount : " + words[2], "Pending"); return(false); } } AddtoOutBox(DateTime.Now, sender, "Incomplete Command, please check your message format.", "Pending"); return(false); } //**sendPending/***Invalid first Primary Code AddtoOutBox(DateTime.Now, sender, "Invalid Primary Code, please check your message format.", "Pending"); return(false); } //Invalid Sender Unregistered Wallet //No reply... return(false); }
public bool PostpaidBillParsing(string mess, string sender) { string message = mess.ToUpper(); string[] words = message.Split(" ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); Array arr = words; if (words[0] == "PAY") { Database.DBRetailers ret = Database.DBRetailers.GetDataByWallet(sender); if (ret != null) { Database.DBPostpaidBill.DBPostpaidBill postBill = Database.DBPostpaidBill.DBPostpaidBill.GetDataByCode(words[1].ToUpper()); if (postBill != null) { if (arr.Length >= 5) { try { if ((float)(ret.Balance) >= (float)(Convert.ToDouble(words[2]) + postBill.ServiceCharge)) { if ((ParameterParsingWithSlash(ParameterStringParsing(mess))) == true) { string[] parameter = ParameterStringParsing(mess).Split("/".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); Array parameters = parameter; string param2; try { param2 = parameter[1]; } catch (Exception ex) { ex.ToString(); param2 = ""; } PostBillTransaction(parameter[0].ToUpper(), param2.ToUpper(), words[1], sender, (float)(Convert.ToDouble(words[2])), ret.Balance, FullNameStringParsing(mess, ParameterIntParsing(mess)), PhoneNumberParsing(words[arr.Length - 1])); return(true); } AddtoOutBox(DateTime.Now, sender, "Invalid Parameter / " + ret.Balance + " None enough", "Pending"); return(false); } //youWallet is none enough AddtoOutBox(DateTime.Now, sender, "Your balance is " + ret.Balance + " None enough", "Pending"); return(false); } catch (Exception ex) { ex.ToString(); //No Code Amount Detected AddtoOutBox(DateTime.Now, sender, "Invalid Code ! must be a Number Amount : " + words[2], "Pending"); return(false); } } AddtoOutBox(DateTime.Now, sender, "Incomplete Command, please check your message format.", "Pending"); return(false); } //**sendPending/***Invalid first Primary Code AddtoOutBox(DateTime.Now, sender, "Invalid Primary Bill Code, please check your message format.", "Pending"); return(false); } //Invalid Sender Unregistered Wallet //No reply... return(false); } return(false); }
public static void PrepaidCableConfirmationCustomer() { try{ string mess, mess1; mess = mess1 = ""; Database.DBTransactions.DBPrepaidCableTransactions trs = Database.DBTransactions.DBPrepaidCableTransactions.GetDataSendingStatus("Sending"); Database.DBMessages.DBOutbox add = new Database.DBMessages.DBOutbox(); if (trs != null) { Database.DBPrepaidCable.DBPrepaidCable preCable = Database.DBPrepaidCable.DBPrepaidCable.GetDataByCode(trs.Code); Database.DBMessages.DBOutboxLog outbl1 = Database.DBMessages.DBOutboxLog.GetDataMessage(trs.Code + " " + trs.Box_number + " " + trs.Pin); Database.DBMessages.DBOutboxLog outbl2 = Database.DBMessages.DBOutboxLog.GetDataMessage(trs.Code + " " + trs.Pin + " " + trs.Box_number); Database.DBMessages.DBOutbox outb1 = Database.DBMessages.DBOutbox.GetDataMessage(trs.Code + " " + trs.Pin + " " + trs.Box_number, "Unsuccessful"); Database.DBMessages.DBOutbox outb2 = Database.DBMessages.DBOutbox.GetDataMessage(trs.Code + " " + trs.Box_number + " " + trs.Pin, "Unsuccessful"); if (outbl1 != null || outbl2 != null) { Database.DBPrepaidCable.DBPrepaidCable cabletype = Database.DBPrepaidCable.DBPrepaidCable.GetDataByCode(trs.Code); Database.DBPrepaidCable.DBPrepaidCards cards = Database.DBPrepaidCable.DBPrepaidCards.GetDataByAmount(Convert.ToInt32(trs.Amount), cabletype.Code); Database.DBPrepaidCable.DBPrepaidCardslog cardslog = new Database.DBPrepaidCable.DBPrepaidCardslog(); Database.DBPrepaidCable.DBPrepaidCards cards1 = new Database.DBPrepaidCable.DBPrepaidCards(); cardslog.Add(cabletype.Code, cards.Amount, cards.Pin, DateTime.Now, "Used"); cards1.Delete(Convert.ToString(cards.Id)); Database.DBRetailers wallet = Database.DBRetailers.GetDataByWallet(trs.Wallet_id); Database.DBRetailers upd = new Database.DBRetailers(); float balance = wallet.Balance + trs.Discount - trs.Amount; upd.UpdateBalance(wallet.Wallet_Id, balance); var chars = trs.Pin.ToCharArray(); for (int x = chars.Length - 4; x >= 0; x--) { mess1 = chars[x] + mess1; } if (trs.Code == "CIGNAL" || trs.Code == "DREAM") { mess = trs.Code + " " + mess1 + "*** " + trs.Box_number; } if (trs.Code == "SKY" || trs.Code == "GSAT") { mess = trs.Code + " " + trs.Box_number + " " + mess1 + "***"; } add.Add(DateTime.Now, trs.Wallet_id, "A1+ : Successfully Transact ref#:" + trs.Id.ToString("D6") + " to " + trs.Customer_number + ". Current bal " + balance + ". \n" + mess + ".", "Pending"); Database.DBTransactions.DBPrepaidCableTransactions update = new Database.DBTransactions.DBPrepaidCableTransactions(); update.Update(trs.Id, "status", "Sent"); } else if (outb1 != null || outb2 != null) { Database.DBTransactions.DBPrepaidCableTransactions update = new Database.DBTransactions.DBPrepaidCableTransactions(); update.Update(trs.Id, "status", "Failed"); add.Add(DateTime.Now, trs.Wallet_id, " Transaction Failed !", "Pending"); } } } catch (Exception ex) { ex.ToString(); MessageBox.Show("Error Processing !"); } }