private void button1_Click(object sender, EventArgs e) { try { amd = Convert.ToInt32(textBox1.Text); } catch (Exception e1) { MessageBox.Show("invalid input"); } if (amd > 0) { if (amd % 100 == 0) { if (amd <= 40000) { con.Open(); var date = DateTime.Now; string dat = date.ToString("dd/MM/yyyy:::hh:mm:ss"); SqlCommand cmd1 = new SqlCommand("insert into [transaction] (date,amount,cust_id) values('" + dat + "','" + amd + "','" + cust_id + "')", con); cmd1.ExecuteNonQuery(); SqlCommand cmd = new SqlCommand("update account set balance=balance+'" + amd + "' where cust_id='" + cust_id + "'", con); cmd.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand("select cust_name from customer where cust_id='" + cust_id + "'", con); using (SqlDataReader red = cmd2.ExecuteReader()) { if (red.Read()) { name = Convert.ToString(red["cust_name"]); } } con.Close(); this.Hide(); transactionbill tr = new transactionbill(amd, cust_id, name); tr.ShowDialog(); } else { MessageBox.Show("enter amount below 40000"); textBox1.Clear(); } } else { MessageBox.Show("ATM can accept notes of 100 500 2000 only"); textBox1.Clear(); } } else { MessageBox.Show("enter valid amount"); textBox1.Clear(); } }
public void withdrawamt(int s) { int balance = 0; string name = null; var time = DateTime.Now; con.Open(); SqlCommand cmd1 = con.CreateCommand(); cmd1.CommandType = CommandType.Text; string dt = time.ToString("dd/MM/yyyy:::hh:mm:ss"); cmd1.CommandText = "insert into [transaction] (date,amount,cust_id) values('" + dt + "','" + s + "','" + cust_id + "')"; cmd1.ExecuteNonQuery(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from account,customer where customer.cust_id=account.cust_id and customer.cust_id='" + cust_id + "' "; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) { balance = Convert.ToInt32(reader["balance"]); name = Convert.ToString(reader["cust_name"]); } } con.Close(); if (balance < s) { label2.Hide(); MessageBox.Show("Insufficient balance"); textBox1.Clear(); } else { con.Open(); SqlCommand cmd3 = con.CreateCommand(); cmd3.CommandType = CommandType.Text; int newb = balance - s; cmd3.CommandText = "update account set balance='" + newb + "' where cust_id='" + cust_id + "'"; cmd3.ExecuteNonQuery(); con.Close(); transactionbill tr = new transactionbill(s, cust_id, name); this.Hide(); tr.ShowDialog(); } }