private void btnAddMoney_Click(object sender, EventArgs e) { var form = new AddMoney(); form.Show(); refreshForm(); }
private void btnAddMoney_Click(object sender, EventArgs e) { if (txtAccountNo.Text != string.Empty || txtAccountHolder.Text != string.Empty || txtIFSC.Text != string.Empty || txtPaytmName.Text != string.Empty || txtPaytmNo.Text != string.Empty || txtCCHolder.Text != string.Empty || txtCCNo.Text != string.Empty || txtCCcVV.Text != string.Empty || txtCCExpiry.Text != string.Empty || txtDCHolder.Text != string.Empty || txtDCcVV.Text != string.Empty || txtDCExpiry.Text != string.Empty || txtAirtelName.Text != string.Empty || txtAir.Text != string.Empty) { decimal totalAmount = 0.0m; string test = string.Empty; using (var connection = new SqlCeConnection(@"Data Source = |DataDirectory|\WalletDB.sdf")) { var cmd = new SqlCeCommand(); cmd.Connection = connection; connection.Open(); cmd.CommandText = "SELECT Amount from AddAmount"; var result = cmd.ExecuteReader(); while (result.Read()) { test = result.GetValue(0).ToString(); } if (txtAddMoneyValue.Text != string.Empty) { totalAmount = Convert.ToDecimal(txtAddMoneyValue.Text) + Convert.ToDecimal(test); cmd.CommandText = "insert into AddAmount(ID,Amount,Date) Values(@ID,@Amount,@Date)"; cmd.Parameters.AddWithValue("@ID", "UPPCL" + s); cmd.Parameters.AddWithValue("@Amount", totalAmount); cmd.Parameters.AddWithValue("@Date", s); int x = cmd.ExecuteNonQuery(); if (x > 0) { refreshForm(); string message = "Amount added successfully"; MessageBox.Show(message); cmd.CommandText = "insert into AvailableBalance(ID,Balance,Status,AddedBy,Date) Values(@IDAB,@Balance,@Status,@AddedBy,@DateAB)"; cmd.Parameters.AddWithValue("@IDAB", "UPPCL" + s); cmd.Parameters.AddWithValue("@Balance", txtAddMoneyValue.Text); cmd.Parameters.AddWithValue("@Status", "Added"); if (cmbPaymentMethod.SelectedIndex == 1) { cmd.Parameters.AddWithValue("@AddedBy", "Paytm Wallet"); } else if (cmbPaymentMethod.SelectedIndex == 2) { cmd.Parameters.AddWithValue("@AddedBy", "NetBanking"); } else if (cmbPaymentMethod.SelectedIndex == 3) { cmd.Parameters.AddWithValue("@AddedBy", "Credit Card"); } else if (cmbPaymentMethod.SelectedIndex == 4) { cmd.Parameters.AddWithValue("@AddedBy", "Debit Card"); } else if (cmbPaymentMethod.SelectedIndex == 5) { cmd.Parameters.AddWithValue("@AddedBy", "Airtel Wallet"); } cmd.Parameters.AddWithValue("@DateAB", s); x = cmd.ExecuteNonQuery(); var form = new AddMoney(); this.Close(); // string s = Convert.ToString(totalAmount); Details detailForm = new Details(); detailForm.refreshForm(); //detailForm.lblWalletBalanceValue.Text = this.lblWalletBalance.Text; //Form f = new Details(); //foreach (Control c in f.Controls) // if (c.Name == "lblWalletBalanceValue") // { // c.Text = Convert.ToString(totalAmount); // return; // } } } else { MessageBox.Show("Please enter money"); } } } else { MessageBox.Show("Please enter details"); } }
private void btnPayMoney_Click(object sender, EventArgs e) { if (txtBillNo.Text == string.Empty || txtConsumerNo.Text == string.Empty || txtAmount.Text == string.Empty) { string message = "All Fields are mandatory"; MessageBox.Show(message); } else { string test = string.Empty; using (var connection = new SqlCeConnection(@"Data Source = |DataDirectory|\WalletDB.sdf")) { var cmd = new SqlCeCommand(); cmd.Connection = connection; connection.Open(); cmd.CommandText = "SELECT Amount from AddAmount"; var result = cmd.ExecuteReader(); while (result.Read()) { test = result.GetValue(0).ToString(); } if (!(string.IsNullOrEmpty(txtAmount.Text))) { if (Convert.ToDecimal(test) >= Convert.ToDecimal(txtAmount.Text)) { decimal totalAmount = Convert.ToDecimal(test) - Convert.ToDecimal(txtAmount.Text); cmd.CommandText = "insert into BillPaid(ID,Amount,ConsumerNo,BillNo,Date,Status) Values(@ID,@Amount,@ConsumerNo,@BillNo,@Date,@Status) "; cmd.Parameters.AddWithValue("@ID", "UPPCL" + txtConsumerNo.Text); cmd.Parameters.AddWithValue("@Amount", txtAmount.Text); cmd.Parameters.AddWithValue("@ConsumerNo", txtConsumerNo.Text); cmd.Parameters.AddWithValue("@BillNo", txtBillNo.Text); cmd.Parameters.AddWithValue("@Date", s); cmd.Parameters.AddWithValue("@Status", "Paid"); int x = cmd.ExecuteNonQuery(); if (x > 0) { string message = "Amount paid successfully"; MessageBox.Show(message); cmd.CommandText = "insert into AvailableBalance(ID,Balance,Status,PaidTo,Date) Values(@ID,@Balance,@Status,@PaidTo,@Date) "; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@ID", "UPPCL" + System.DateTime.Now); cmd.Parameters.AddWithValue("@Balance", txtAmount.Text); cmd.Parameters.AddWithValue("@Status", "Paid"); cmd.Parameters.AddWithValue("@PaidTo", txtConsumerNo.Text); cmd.Parameters.AddWithValue("@Date", s); x = cmd.ExecuteNonQuery(); cmd.CommandText = "insert into AddAmount(ID,Amount,Date) Values(@IDA,@Amount,@DateA)"; cmd.Parameters.AddWithValue("@IDA", "UPPCL" + System.DateTime.Now); cmd.Parameters.AddWithValue("@Amount", totalAmount); cmd.Parameters.AddWithValue("@DateA", s); x = cmd.ExecuteNonQuery(); BillDue(); refreshForm(); txtAmount.Text = string.Empty; txtConsumerNo.Text = string.Empty; txtBillNo.Text = string.Empty; txtPaymentDate.Text = string.Empty; if (!(x > 0)) { message = "Amount is not deducted"; MessageBox.Show(message); var form = new AddMoney(); this.Close(); } } //update availble balance } else { string message = "Wallet balance is not sufficient"; MessageBox.Show(message); txtAmount.Text = string.Empty; txtConsumerNo.Text = string.Empty; txtBillNo.Text = string.Empty; txtPaymentDate.Text = string.Empty; refreshForm(); } } else { refreshForm(); string message = "Please add amount"; MessageBox.Show(message); txtAmount.Text = string.Empty; txtConsumerNo.Text = string.Empty; txtBillNo.Text = string.Empty; txtPaymentDate.Text = string.Empty; } } } }