private void button2_Click(object sender, EventArgs e) { if (button2.Text == "Validate") { Connecntion cn = new Connecntion(); using (SqlCommand StrQuer = new SqlCommand("SELECT * FROM [user] WHERE Username=@userid AND Password=@password", cn.con)) { cn.connOpen(); StrQuer.Parameters.AddWithValue("@userid", textBox1.Text.ToString()); StrQuer.Parameters.AddWithValue("@password", textBox2.Text.ToString()); using (SqlDataReader dr = StrQuer.ExecuteReader()) { if (dr.HasRows == false) { MessageBox.Show("User ID Incorrect", "Error"); } else { button2.Text = "Confirm"; textBox3.ReadOnly = false; textBox4.ReadOnly = false; textBox1.ReadOnly = true; textBox2.ReadOnly = true; passChange(); } } } } else { passChange(); } }
private void button3_Click(object sender, EventArgs e) { if (textBox2.Text != string.Empty) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("select Name from customer where Account_no=(select Account_No from loan where Account_No='" + textBox2.Text + "' and Loan_Status='Approved')", cn.con)) { using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("Account doesn't have any Loan", "Result"); textBox2.Clear(); textBox2.Select(); } else if (rd.Read()) { textBox3.Text = rd.GetString(0); } } } } else { MessageBox.Show("Enter Account Number", "Missing Data"); } }
public void inQuery() { Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("insert into customer(Account_No,Name,DOB,Phone_No,Email,Address,District,Gender,Marital_Status,Father_Name,Mother_Name,Balance,Photo) values (@ac,@na,@dob,@pno,@em,@add,@dis,@gen,@msta,@fn,@mn,@bl,@ph)", cn.con)) { byte[] image = getPic(); cmd.Parameters.AddWithValue("@ac", textBox1.Text); cmd.Parameters.AddWithValue("@na", textBox2.Text); cmd.Parameters.AddWithValue("@dob", dateTimePicker1.Text); cmd.Parameters.AddWithValue("@pno", textBox3.Text); cmd.Parameters.AddWithValue("@em", textBox4.Text); cmd.Parameters.AddWithValue("@add", richTextBox1.Text); cmd.Parameters.AddWithValue("@dis", textBox5.Text); cmd.Parameters.AddWithValue("@gen", gen); cmd.Parameters.AddWithValue("@msta", mstat); cmd.Parameters.AddWithValue("@fn", textBox8.Text); cmd.Parameters.AddWithValue("@mn", textBox9.Text); cmd.Parameters.AddWithValue("@bl", textBox10.Text); cmd.Parameters.AddWithValue("@ph", image); try { cmd.ExecuteNonQuery(); MessageBox.Show("Information Saved!", "Operation Completed"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } cn.con.Close(); this.Close(); }
public void inQuery() { Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("insert into [user] (Name,Username,Password,Gender,DOB,User_Type,Phone,Address) values (@name,@uname,@pass,@gen,@dob,@utype,@pno,@add)", cn.con)) { cmd.Parameters.AddWithValue("@name", textBox1.Text); cmd.Parameters.AddWithValue("@uname", textBox2.Text); cmd.Parameters.AddWithValue("@pass", textBox4.Text); cmd.Parameters.AddWithValue("@add", richTextBox1.Text); cmd.Parameters.AddWithValue("@utype", comboBox1.Text); cmd.Parameters.AddWithValue("@dob", dateTimePicker1.Text); cmd.Parameters.AddWithValue("@pno", textBox3.Text); cmd.Parameters.AddWithValue("@gen", gen); try { cmd.ExecuteNonQuery(); MessageBox.Show("User added to database", "Operation Sucess"); } catch (Exception ex) { MessageBox.Show(ex.Message); } cn.con.Close(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("Select Name,Password,Gender,DOB,Phone,Address from [user] where Username='******'", cn.con)) { using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("No Matching details found", "No Data!"); } else if (rd.Read()) { textBox2.Text = rd.GetString(0); if (rd.GetString(2) == "Male") { radioButton1.Checked = true; } else { radioButton2.Checked = true; } textBox3.Text = rd.GetString(4); dateTimePicker1.Value = rd.GetDateTime(3); richTextBox1.Text = rd.GetString(5); } } cn.con.Close(); } }
public void inQuery() { Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("update [user] set Name=@name,Username=@uname,Gender=@gen,DOB=@dob,Phone=@pno,Address=@add where Username='******'", cn.con)) { cmd.Parameters.AddWithValue("@name", textBox2.Text); cmd.Parameters.AddWithValue("@uname", textBox1.Text); cmd.Parameters.AddWithValue("@add", richTextBox1.Text); cmd.Parameters.AddWithValue("@dob", dateTimePicker1.Text); cmd.Parameters.AddWithValue("@pno", textBox3.Text); cmd.Parameters.AddWithValue("@gen", gen); try { cmd.ExecuteNonQuery(); MessageBox.Show("User updated to database", "Operation Sucess"); } catch (Exception ex) { MessageBox.Show(ex.Message); } cn.con.Close(); this.Close(); } }
public void inQueryP() { Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("Update customer set Name='" + textBox2.Text + "',DOB='" + dateTimePicker1.Text + "',Phone_No='" + textBox8.Text + "',Email='" + textBox9.Text + "',Address='" + richTextBox1.Text + "',District='" + textBox5.Text + "',Gender=@gen,Marital_Status=@mstat,Father_Name='" + textBox4.Text + "',Mother_Name='" + textBox5.Text + "',Balance='" + textBox3.Text + "',Photo=@img where Account_No='" + textBox1.Text + "'", cn.con)) { byte[] image = getPic(); cmd.Parameters.AddWithValue("@gen", gen); cmd.Parameters.AddWithValue("@mstat", mstat); cmd.Parameters.AddWithValue("@img", image); try { SqlDataReader rd = cmd.ExecuteReader(); if (MessageBox.Show("Info Updated!", "Operation Complete", MessageBoxButtons.OK, MessageBoxIcon.Information) == DialogResult.OK) { Clear_Boxes(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } cn.con.Close(); }
public void passChange() { if (textBox3.Text == string.Empty || textBox4.Text == string.Empty) { MessageBox.Show("Please type new password and confirm password"); textBox3.Select(); } else if (textBox3.Text != textBox4.Text) { MessageBox.Show("Password didn't match", "Error"); } else { Connecntion cn = new Connecntion(); using (SqlCommand cmd = new SqlCommand("update [user] set Password='******'where Username='******'", cn.con)) { cn.connOpen(); try { cmd.ExecuteNonQuery(); MessageBox.Show("Password Updated", "Operation Succeed"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
private void button3_Click(object sender, EventArgs e) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("Select Name,Balance from customer where Account_no='" + textBox1.Text + "'", cn.con)) { using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("There is no Account with whis Account Number", "Result", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox1.Clear(); } else if (rd.Read()) { textBox5.Text = rd.GetString(0); textBox6.Text = rd.GetInt32(1).ToString(); } } } cn.con.Close(); }
private void button1_Click(object sender, EventArgs e) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("Select * from customer where Account_no=@ac", cn.con)) { cmd.Parameters.AddWithValue("@ac", textBox1.Text); rd = cmd.ExecuteReader(); if (rd.HasRows == false) { MessageBox.Show("Account No Unavailable"); } else if (rd.Read()) { textBox2.Text = rd.GetString(1); textBox4.Text = rd.GetString(9); textBox5.Text = rd.GetString(10); textBox8.Text = rd.GetString(3); textBox9.Text = rd.GetString(4); richTextBox1.Text = rd.GetString(5); textBox10.Text = rd.GetString(6); textBox3.Text = rd.GetInt32(11).ToString(); dateTimePicker1.Value = rd.GetDateTime(2); if (rd.GetString(7) == "Male") { radioButton1.Checked = true; } else { radioButton2.Checked = true; } if (rd.GetString(8) == "Married") { radioButton3.Checked = true; } else { radioButton4.Checked = true; } byte[] img = (byte[])(rd[12]); if (img == null) { pictureBox1.Image = null; } else { MemoryStream ms = new MemoryStream(img); pictureBox1.Image = Image.FromStream(ms); } } } cn.con.Close(); }
public void acc() { Connecntion cn = new Connecntion(); cn.connOpen(); SqlCommand cmd = new SqlCommand("select max(Account_no+1) from customer", cn.con); //int count = (int)cmd.ExecuteScalar(); textBox1.Text = cmd.ExecuteScalar().ToString(); cn.con.Close(); }
private void button5_Click(object sender, EventArgs e) { if (richTextBox2.Text == string.Empty) { MessageBox.Show("Enter Customer Account Number", "Enter Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (richTextBox2.Text != string.Empty) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("select * from loan where Account_No='" + richTextBox2.Text + "'", cn.con)) { using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("No loan record found", "Not Found"); } else if (rd.Read()) { rd.Close(); using (SqlCommand cm3 = new SqlCommand("Select Loan_Status from loan where Account_No='" + richTextBox2.Text + "'", cn.con)) { object result = cm3.ExecuteScalar(); string res = Convert.ToString(result); if (res == "Approved") { MessageBox.Show("Loan is approved!\n Can not decline", "Declined"); } else { using (SqlCommand cmd2 = new SqlCommand("Delete loan where Account_No='" + richTextBox2.Text + "'", cn.con)) { try { cmd2.ExecuteNonQuery(); MessageBox.Show("Loan Declined", "Updated!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } } } } } }
private void button2_Click(object sender, EventArgs e) { if (textBox2.Text != string.Empty) { Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("select Username from [user] where Username=@uname", cn.con)) { cmd.Parameters.AddWithValue("@uname", textBox2.Text); SqlDataReader rd = cmd.ExecuteReader(); if (rd.HasRows) { MessageBox.Show("Username already exists!" + "\nType another one", "Warning!!"); textBox2.Clear(); } } cn.con.Close(); } if (textBox1.Text != string.Empty && textBox2.Text != string.Empty && textBox3.Text != string.Empty && textBox4.Text != string.Empty && richTextBox1.Text != string.Empty) { //if textbox r not empty if (radioButton1.Checked || radioButton2.Checked) { //if radio buttons are selected correctly if (dateTimePicker1.Value < DateTime.Today.AddYears(-18) && dateTimePicker1.Value > DateTime.Today.AddYears(-100)) { //after checking the customer is >18 if (comboBox1.Text == string.Empty) { MessageBox.Show("Pick a role", "Combobox unchecked"); } else { inQuery(); } } else { MessageBox.Show("Wrong Date of Birth"); } } else { MessageBox.Show("Choose a gender"); } } else { MessageBox.Show("Input all the informations"); } }
private void button1_Click(object sender, EventArgs e) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataAdapter d = new SqlDataAdapter("select * from [transaction]", cn.con); DataTable t = new DataTable(); d.Fill(t); dataGridView1.DataSource = t; //DataSet ds = new DataSet(); //d.Fill(ds,"transaction,transfer"); //dataGridView1.DataSource = ds; //dataGridView1.DataMember = "transaction,transfer"; }
public void inQuery() { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd2 = new SqlCommand("Select * from customer where Account_No='" + textBox1.Text + "'", cn.con)) { using (rd = cmd2.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("Account does not exist", "Resuult"); textBox1.Clear(); textBox1.Select(); } else if (rd.Read()) { rd.Close(); using (SqlCommand cmd = new SqlCommand("insert into fd (Account_No,Type,Amount,Period,Interest,Date) values(@acc,@type,@amount,@per,@inte,@date)", cn.con)) { cmd.Parameters.AddWithValue("@acc", textBox1.Text); cmd.Parameters.AddWithValue("@type", rb); cmd.Parameters.AddWithValue("@amount", textBox3.Text); cmd.Parameters.AddWithValue("@per", textBox4.Text); cmd.Parameters.AddWithValue("@inte", textBox5.Text.ToString()); cmd.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd.ExecuteNonQuery(); MessageBox.Show("Fd Form Created", "Operation Complete"); cn.con.Close(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } } }
private void button3_Click(object sender, EventArgs e) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; SqlCommand cmd; using (cmd = new SqlCommand("Select * from [user] where Username='******'", cn.con)) { try { rd = cmd.ExecuteReader(); if (rd.HasRows) { rd.Close(); cmd = new SqlCommand("Delete from [user] where Username='******'", cn.con); try { rd = cmd.ExecuteReader(); MessageBox.Show("User Info Deleted!", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("No record found", "Result"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } cn.con.Close(); this.Close(); }
private void button4_Click(object sender, EventArgs e) { if (richTextBox2.Text == string.Empty) { MessageBox.Show("Enter Customer Account Number", "Enter Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (richTextBox2.Text != string.Empty) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("select * from loan where Account_No='" + richTextBox2.Text + "'", cn.con)) { using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("No loan record found", "Not Found"); } else if (rd.Read()) { rd.Close(); using (SqlCommand cmd2 = new SqlCommand("update loan set Loan_Status='Approved' where Account_No='" + richTextBox2.Text + "'", cn.con)) { try { cmd2.ExecuteNonQuery(); MessageBox.Show("Loan Accepted!", "Updated!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } } } }
public void setLabel() { Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("Select COALESCE(SUM(Balance), 0) from customer", cn.con)) { object result = cmd.ExecuteScalar(); label10.Text = Convert.ToString(result); } using (SqlCommand cmd = new SqlCommand("Select COALESCE(SUM(Loan_Amount), 0) from loan where Loan_Status='approved'", cn.con)) { object result = cmd.ExecuteScalar(); label11.Text = Convert.ToString(result); } using (SqlCommand cmd = new SqlCommand("Select Count(Username) from [user] ", cn.con)) { object result = cmd.ExecuteScalar(); label12.Text = Convert.ToString(result); } using (SqlCommand cmd = new SqlCommand("Select Count(Account_No) from customer ", cn.con)) { object result = cmd.ExecuteScalar(); label13.Text = Convert.ToString(result); } using (SqlCommand cmd = new SqlCommand("Select Count(Account_No) from loan where Loan_Status='approved'", cn.con)) { object result = cmd.ExecuteScalar(); label14.Text = Convert.ToString(result); } using (SqlCommand cmd = new SqlCommand("Select Count(Account_No) from fd", cn.con)) { object result = cmd.ExecuteScalar(); label15.Text = Convert.ToString(result); } }
public void inQuery() { Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("select * from customer where Account_No='" + textBox1.Text + "'", cn.con)) { SqlDataReader rd; using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("Accoung does not exist", "Error"); textBox1.Clear(); textBox1.Select(); } else if (rd.Read()) { rd.Close(); using (SqlCommand cmd3 = new SqlCommand("select * from loan where Account_No='" + textBox1.Text + "'", cn.con)) { using (rd = cmd3.ExecuteReader()) { if (rd.HasRows == false) { rd.Close(); using (SqlCommand cmd2 = new SqlCommand("insert into loan (Account_No,Loan_Amount,Monthly_Pay,Period,Interest,Loan_Status,Date) values(@acc,@loan,@mpay,@per,@inte,@loanstat,@date)", cn.con)) { string str = "Pending"; cmd2.Parameters.AddWithValue("@acc", textBox1.Text); cmd2.Parameters.AddWithValue("@loan", textBox2.Text); cmd2.Parameters.AddWithValue("@loanstat", str.ToString()); cmd2.Parameters.AddWithValue("@mpay", textBox3.Text); cmd2.Parameters.AddWithValue("@per", textBox4.Text); cmd2.Parameters.AddWithValue("@inte", textBox5.Text.ToString()); cmd2.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd2.ExecuteNonQuery(); MessageBox.Show("Loan Form Created", "Operation Complete"); cn.con.Close(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } else { MessageBox.Show("There is already a Loan for this Account", "Request Denied"); textBox1.Select(); } } } } } } }
public void inQuery() { int main_loan = 0; int up_loan = 0; Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("select Loan_Amount from loan where account_no='" + textBox2.Text.ToString() + "'", cn.con)) { using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("Account doesn't have any Loan", "Result"); textBox2.Clear(); textBox2.Select(); } else if (rd.Read()) { main_loan = rd.GetInt32(0); } } } if (main_loan >= Convert.ToInt32(textBox5.Text.ToString())) { //procedure call up_loan = main_loan - Convert.ToInt32(textBox5.Text); using (SqlCommand cmd = new SqlCommand("loan_pay", cn.con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ano", Convert.ToInt32(textBox2.Text.ToString())); cmd.Parameters.AddWithValue("@n", textBox3.Text); cmd.Parameters.AddWithValue("@pm", textBox4.Text); cmd.Parameters.AddWithValue("@pa", Convert.ToInt32(textBox5.Text)); cmd.Parameters.AddWithValue("@dt", DateTime.Today.ToString("yyyy-MM-dd")); cmd.Parameters.AddWithValue("@ul", up_loan); try { //cn.con.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("Loan Installment Successfull"); this.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); } } } else { MessageBox.Show("incorrect payment"); } }
private void button2_Click(object sender, EventArgs e) { if (textBox5.Text != string.Empty) { Connecntion cn = new Connecntion(); cn.connOpen(); SqlDataReader rd; using (SqlCommand cmd = new SqlCommand("select * from customer where Account_No='" + textBox4.Text + "'", cn.con)) { using (rd = cmd.ExecuteReader()) { if (rd.HasRows == false) { MessageBox.Show("No Account Found\ninput again", "Result"); textBox4.Clear(); textBox4.Select(); } else if (rd.Read()) { rd.Close(); using (SqlCommand cmd2 = new SqlCommand("update customer set Balance=Balance+'" + textBox5.Text + "'where Account_no='" + textBox4.Text + "'", cn.con)) { try { cmd2.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } using (SqlCommand cmd2 = new SqlCommand("update customer set Balance=Balance-'" + textBox5.Text + "' where Account_No='" + textBox2.Text + "'", cn.con)) { try { cmd2.ExecuteNonQuery(); MessageBox.Show("Customer Table Updated", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } using (SqlCommand cmd2 = new SqlCommand("insert into [transfer] (Payee_Account,Recv_Account,Transfer_Amount,Date) values(@pa,@ra,@amount,@date) ", cn.con)) { cmd2.Parameters.AddWithValue("@pa", textBox2.Text); cmd2.Parameters.AddWithValue("@ra", textBox4.Text); cmd2.Parameters.AddWithValue("@amount", textBox5.Text); cmd2.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd2.ExecuteNonQuery(); MessageBox.Show("Transfer Table Updated!", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } using (SqlCommand cmd2 = new SqlCommand("insert into [transaction] (Account_No,TransferFrom,TransferTo,Amount,Date) values (@acc,@tf,@tt,@amount,@date)", cn.con)) { cmd2.Parameters.AddWithValue("@acc", textBox2.Text.ToString()); cmd2.Parameters.AddWithValue("@tf", textBox2.Text); cmd2.Parameters.AddWithValue("@tt", textBox4.Text); cmd2.Parameters.AddWithValue("@amount", textBox5.Text); cmd2.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd2.ExecuteNonQuery(); MessageBox.Show("Transaction Complete!", "OPeration Succedd!!"); cn.con.Close(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } } } else { MessageBox.Show("Enter Amount!", "Error"); } }
private void button2_Click(object sender, EventArgs e) { if (textBox7.Text != string.Empty) { int deposit; deposit = Convert.ToInt32(textBox7.Text); deposit = int.Parse(textBox7.Text); Connecntion cn = new Connecntion(); cn.connOpen(); using (SqlCommand cmd = new SqlCommand("insert into deposit(Account_No,Deposit_Amount,Date) values (@acc,@da,@date)", cn.con)) { cmd.Parameters.AddWithValue("@acc", textBox1.Text); cmd.Parameters.AddWithValue("@da", textBox7.Text); cmd.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd.ExecuteNonQuery(); MessageBox.Show("Deposit Completed!", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } using (SqlCommand cmd = new SqlCommand("insert into [transaction] (Account_No,Credit,Date) values (@acc,@da,@date)", cn.con)) { cmd.Parameters.AddWithValue("@acc", textBox1.Text); cmd.Parameters.AddWithValue("@da", textBox7.Text); cmd.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd.ExecuteNonQuery(); MessageBox.Show("Transaction Table Updated!", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } int crrBalance; crrBalance = Convert.ToInt32(textBox6.Text); crrBalance = int.Parse(textBox6.Text); int finalbalance = deposit + crrBalance; using (SqlCommand cmd = new SqlCommand("update customer set balance='" + finalbalance + "' where Account_No='" + textBox1.Text + "'", cn.con)) { try { cmd.ExecuteNonQuery(); MessageBox.Show("Customer Table Updated", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } cn.con.Close(); this.Close(); } else { MessageBox.Show("Input Deposit Money", "No Value"); textBox7.Clear(); textBox7.Select(); } }
private void button2_Click(object sender, EventArgs e) { if (textBox7.Text != string.Empty) { int anInteger; anInteger = Convert.ToInt32(textBox7.Text); anInteger = int.Parse(textBox7.Text); Connecntion cn = new Connecntion(); cn.connOpen(); int crrBalance; crrBalance = Convert.ToInt32(textBox6.Text); crrBalance = int.Parse(textBox6.Text); if (anInteger <= crrBalance) { { using (SqlCommand cmd = new SqlCommand("insert into withdraw(Account_No,Withdraw_Amount,Date) values (@acc,@wa,@date)", cn.con)) { cmd.Parameters.AddWithValue("@acc", textBox1.Text); cmd.Parameters.AddWithValue("@wa", textBox7.Text); cmd.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd.ExecuteNonQuery(); MessageBox.Show("Withdraw Completed!", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } using (SqlCommand cmd = new SqlCommand("insert into [transaction] (Account_No,Debit,Date) values (@acc,@ca,@date)", cn.con)) { cmd.Parameters.AddWithValue("@acc", textBox1.Text); cmd.Parameters.AddWithValue("@ca", textBox7.Text); cmd.Parameters.AddWithValue("@date", DateTime.Now.ToString("yyyy-MM-dd")); try { cmd.ExecuteNonQuery(); MessageBox.Show("Transaction Table Update!!!", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } int finalbalance = crrBalance - anInteger; using (SqlCommand cmd = new SqlCommand("update customer set balance='" + finalbalance + "' where Account_No='" + textBox1.Text + "'", cn.con)) { try { cmd.ExecuteNonQuery(); MessageBox.Show("Customer Table Updated", "Operation Complete"); } catch (Exception ex) { MessageBox.Show(ex.Message); } cn.con.Close(); this.Close(); } } else { MessageBox.Show("Withdrawal amount is more than Current Balance\nInput Again", "Error Result"); textBox7.Clear(); textBox7.Select(); } cn.con.Close(); } else { MessageBox.Show("Input Withdrawal Amount", "No Value"); textBox7.Clear(); textBox7.Select(); } }