public Form1(String customer_id) { this.customer_id = customer_id; InitializeComponent(); dataGridView2.Visible = false; cbx_creditPeriod.DropDownStyle = ComboBoxStyle.DropDownList; cbx_loanCategory.DropDownStyle = ComboBoxStyle.DropDownList; lbl_customerBalance.Text = String.Format(new CultureInfo("en-US"), "{0:C}", customerDal.getBalance(customer_id)); String customer_name = customerDal.getCustomerName(customer_id).ToString(); lbl_welcome.Text = "WELCOME" + " " + customer_name.ToUpper();; lbl_customerName.Text = "Dear Customer " + customer_name.ToUpper() + " You Can Easily Apply For a Loan"; double customerDebt = customerDal.getCustomerCreditDebt(customer_id); lbl_customerCreditDebt.Visible = false; if (customerDebt != 0) { lbl_customerCreditDebt.Visible = true; lbl_customerCreditDebt.Text = ($" Your Remaining Loan Debt is {String.Format(new CultureInfo("en-US"), "{0:C}", customerDebt)} "); } }
public void PayBill(String customer_id, double customer_balance, double bill_amount, int bill_id, String type) { int j; try { connection.openConnection(); double updated_balance = customer_balance - bill_amount; MySqlCommand command = new MySqlCommand("DELETE FROM bill WHERE Bill_ID =@Id ", connection.mysqlconnect); command.Parameters.AddWithValue("@Id", bill_id); int i = command.ExecuteNonQuery(); CustomerDal customerDal = new CustomerDal(); if (type == "loan") { double debt = customerDal.getCustomerCreditDebt(customer_id); double updated_debt = debt - bill_amount; MySqlCommand command2 = new MySqlCommand("Update customer set creditDebt=@updated_debt where customer_id=@Id", connection.mysqlconnect); command2.Parameters.AddWithValue("@Id", customer_id); command2.Parameters.AddWithValue("@updated_debt", updated_debt); j = command2.ExecuteNonQuery(); int k = customerDal.updateBalance(customer_id, updated_balance); } else { j = customerDal.updateBalance(customer_id, updated_balance); } if (i > 0 && j > 00) { MessageBox.Show("Bill was paid succesfully"); } else { MessageBox.Show("Operation could not complete please try again"); } } catch (Exception e) { MessageBox.Show(e.Message); } connection.closeConnection(); }