private void label5_Click(object sender, EventArgs e)
{
HOME home = new HOME();
home.Show();
this.Hide();
}
private void bunifuThinButton21_Click(object sender, EventArgs e)
{
if (wdamtTb.Text == "")
{
MessageBox.Show("Missing Information");
}
else if (Convert.ToInt32(wdamtTb.Text) <= 0)
{
MessageBox.Show("Enter a Valid Amount");
}
else if (Convert.ToInt32(wdamtTb.Text) > bal)
{
MessageBox.Show("Balance Can not be negative");
}
else
{
try
{
newbalance = bal - Convert.ToInt32(wdamtTb.Text);
try
{
Con.Open();
string query = "update AccountTbl set Balance=" + newbalance + " where AccNum='" + Acc + "';";
SqlCommand cmd = new SqlCommand(query, Con);
cmd.ExecuteNonQuery();
MessageBox.Show("Success Withdraw");
Con.Close();
addtransaction();
HOME home = new HOME();
home.Show();
this.Hide();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
}
}
private void bunifuThinButton21_Click(object sender, EventArgs e)
{
Con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select count(*) from AccountTbl where AccNum='" + AccNumTb.Text + "' and Pin = " + PinTb.Text + "", Con);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows[0][0].ToString() == "1")
{
AccNumber = AccNumTb.Text;
HOME home = new HOME();
home.Show();
this.Hide();
Con.Close();
}
else
{
MessageBox.Show("Wrong Account Number Or PIN Code");
}
Con.Close();
}