private void button2_Click(object sender, EventArgs e)
{
string accno, date;
double bal, depo;
accno = txtacc.Text;
date = txtdate.Text;
bal = double.Parse(txtbal.Text);
depo = double.Parse(txtdp.Text);
string query = "update Accounts set Balance=Balance+'" + depo + "' where AccountNo='" + accno + "'";
string query1 = "INSERT into Transactions (AccountNo,Date,Balance,Deposit,Withdraw) values ('" + accno + "','" + date + "'," + bal + "," + depo + ",0)";
try
{
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int n = dcc.ExecuteSQL(query);
dcc.CloseConnection();
dcc.ConnectWithDB();
int n1 = dcc.ExecuteSQL(query1);
dcc.CloseConnection();
MessageBox.Show("Done");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
if (txtNewpass.Text.Equals(txtConfirmpwd.Text))
{
string query = "update Login set Password='******' Where id='" + HomePage.identity + "'";
try
{
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int n = dcc.ExecuteSQL(query);
dcc.CloseConnection();
MessageBox.Show("Done");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
else
{
MessageBox.Show("Confirm Password doesn't Matched");
}
}
private void button1_Click(object sender, EventArgs e)
{
string cid, accno, acctype, des;
double bal;
cid = txtcid.Text;
accno = txtacc.Text;
acctype = txtacctype.Text;
des = txtdes.Text;
bal = double.Parse(txtbal.Text);
string query1 = "INSERT into Accounts(AccountNo,CustId,AccountType,Description,Balance)values('" + accno + "','" + cid + "','" + acctype + "','" + des + "','" + bal + "')";
try
{
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int n = dcc.ExecuteSQL(query1);
dcc.CloseConnection();
MessageBox.Show("Done");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
string fno;
string tono;
string date;
double amount;
fno = ftxt.Text;
tono = totxt.Text;
date = txtdate.Text;
amount = double.Parse(txtamount.Text);
string query = "update Accounts set Balance=Balance-'" + amount + "' where AccountNo='" + fno + "'";
string query1 = "update Accounts set Balance=Balance+'" + amount + "' where AccountNo='" + tono + "'";
string query2 = "INSERT into Transfers (F_Acc,To_Acc,Date,Amount) values ('" + fno + "','" + tono + "','" + date + "'," + amount + ")";
try
{
DatabaseConnectionClass dcc = new DatabaseConnectionClass();
dcc.ConnectWithDB();
int n = dcc.ExecuteSQL(query);
dcc.CloseConnection();
dcc.ConnectWithDB();
int n1 = dcc.ExecuteSQL(query1);
dcc.CloseConnection();
dcc.ConnectWithDB();
int n2 = dcc.ExecuteSQL(query2);
dcc.CloseConnection();
MessageBox.Show("Done");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
