private void buttonDepositDepositCash_Click(object sender, EventArgs e) { try { customerObject.balance += Convert.ToDecimal(textBoxDepositCash.Text); GateWay gateWayObject = new GateWay(); string updateString = "update customer set balance=" + customerObject.balance + " where account_no='" + customerObject.acc_no + "'"; string insertString = @"INSERT INTO [diposit_history] (account_no, date, ammount) VALUES (@account_no, @date, @ammount)"; List <SqlParameter> parameter = new List <SqlParameter>(); parameter.Add(new SqlParameter("@account_no", customerObject.acc_no)); parameter.Add(new SqlParameter("@date", (DateTime.Now).ToString())); parameter.Add(new SqlParameter("@ammount", Convert.ToDecimal(textBoxDepositCash.Text))); if (gateWayObject.updateData(updateString) && gateWayObject.InsertData(insertString, parameter)) { MessageBox.Show("Deposit Successfull.\nNew balance" + customerObject.balance); } else { MessageBox.Show("Error in Deposit.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (FormatException ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } textBoxDepositCash.Clear(); }
private void buttonAddAddNewUsers_Click(object sender, EventArgs e) { try { var emptyBoxes = from Control currentControl in Controls where currentControl is TextBox && string.IsNullOrEmpty(currentControl.Text) orderby currentControl.TabIndex select currentControl; if (emptyBoxes.Count() > 0) { MessageBox.Show("Please fill in all fields.", "Missing", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { List <SqlParameter> parameter = new List <SqlParameter>(); GateWay gateWayObject = new GateWay(); DataTable dataTableObject = new DataTable(); Customer customerObject = new Customer(); customerObject.name = textBoxAddName.Text; customerObject.userName = txtUserName.Text; customerObject.address = textBoxAddAddress.Text; customerObject.phone = textBoxAddPhone.Text; customerObject.pinCode = textBoxAddPin.Text; customerObject.acc_no = textBoxAccountNo.Text; customerObject.balance = Convert.ToDecimal(textBoxAddBalance.Text); dataTableObject = gateWayObject.SelectData("Select * from customer"); bool found = false; for (int i = 0; i < dataTableObject.Rows.Count; i++) //check if the account no already exists { if (dataTableObject.Rows[i]["account_no"].ToString() == customerObject.acc_no) //check if the account no already exists { found = true; break; } } if (found) { MessageBox.Show("Account with this account number already exists", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { string insertString = @"INSERT INTO [customer] (c_name, user_name, address, phone, pin_code, account_no, balance) VALUES (@c_name, @user_name, @address, @phone, @pin_code, @account_no, @balance)"; parameter.Add(new SqlParameter("@c_name", customerObject.name)); parameter.Add(new SqlParameter("@user_name", customerObject.userName)); parameter.Add(new SqlParameter("@address", customerObject.address)); parameter.Add(new SqlParameter("@phone", customerObject.phone)); parameter.Add(new SqlParameter("@pin_code", customerObject.pinCode)); parameter.Add(new SqlParameter("@account_no", customerObject.acc_no)); parameter.Add(new SqlParameter("@balance", customerObject.balance)); gateWayObject.InsertData(insertString, parameter); // insert into customer table FormAddNewUsers_Load(this, new EventArgs()); //update data grid view //dataGridView1.Refresh(); btnClear_Click(this, new EventArgs()); // clear all text box } } } catch (FormatException ex) { MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonTransfer_Click(object sender, EventArgs e) { try { if (txtGuestAcc.Text != string.Empty && txtTransferAmount.Text != string.Empty) { GateWay gateWayObject = new GateWay(); DataTable dataTableObject = new DataTable(); string sqlString = "select account_no from customer where account_no='" + txtGuestAcc.Text + "'"; // determine whether the account is exist. dataTableObject = gateWayObject.SelectData(sqlString); //DataRow dr = dataTableObject.Rows[0]; if (dataTableObject.Rows.Count == 1 && txtGuestAcc.Text != customerObject.acc_no) { customerObject.balance -= Convert.ToDecimal(txtTransferAmount.Text); string updateCustomerString = "update customer set balance=" + customerObject.balance + " where account_no='" + customerObject.acc_no + "'"; string updateGusetString = "update customer set balance=balance+" + txtTransferAmount.Text + " where account_no='" + txtGuestAcc.Text + "'"; //insert into transfer_history table string insertString = @"INSERT INTO [transfer_history] (date, acc_from, acc_to, ammount, notification) VALUES (@date, @acc_from, @acc_to, @ammount, @notification)"; List <SqlParameter> parameter = new List <SqlParameter>(); parameter.Add(new SqlParameter("@date", (DateTime.Now).ToString())); parameter.Add(new SqlParameter("@acc_from", customerObject.acc_no)); parameter.Add(new SqlParameter("@acc_to", txtGuestAcc.Text)); parameter.Add(new SqlParameter("@ammount", Convert.ToDecimal(txtTransferAmount.Text))); parameter.Add(new SqlParameter("@notification", 1)); if (gateWayObject.updateData(updateCustomerString) && gateWayObject.updateData(updateGusetString) && gateWayObject.InsertData(insertString, parameter)) { MessageBox.Show("Transfer Successfull.\nNew balance" + customerObject.balance); } else { MessageBox.Show("Error in Transfer.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Invalid account number.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Account number or Amount should not be empty.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (FormatException ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } txtGuestAcc.Clear(); txtTransferAmount.Clear(); }