private void back(object sender, RoutedEventArgs e)
{
Window mainwindow = new ATMWindow(customer);
mainwindow.Show();
this.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Window back = new ATMWindow(customer);
back.Show();
this.Close();
}
private void done(object sender, RoutedEventArgs e)
{
if (Int32.Parse(amountxt.Text.ToString()) % 50000 != 0)
{
MessageBox.Show("Amount must be multiply by 50.000");
return;
}
if (customer.balance - Int32.Parse(amountxt.Text.ToString()) <= 50000 && customer.type.ToString() != "Student")
{
MessageBox.Show("The Balance left in your account must be more than or equals 50000!");
return;
}
if (customer.balance - Int32.Parse(amountxt.Text.ToString()) <= 1000 && customer.type.ToString() == "Student")
{
MessageBox.Show("The Balance left in your account must be more than or equals 1000!");
return;
}
DataTable dt = new DataTable();
dt = connect.executeQuery("select sum(amount) as 'Total' from transaction where transactiontype = 'Withdraw Money' and receiver = '" + customer.accountnumber + "' and date = current_date");
DataRow data = dt.Rows[0];
//if(Int32.Parse(data["Total"].ToString())+ Int32.Parse(amountxt.Text.ToString()) > 2500000 && customer.type == "Bronze")
//{
// MessageBox.Show("You have achieved the limit of withdraw money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 5000000 && customer.type == "Silver")
//{
// MessageBox.Show("You have achieved the limit of withdraw money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 7500000 && customer.type == "Gold")
//{
// MessageBox.Show("You have achieved the limit of withdraw money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 10000000 && customer.type == "Black")
//{
// MessageBox.Show("You have achieved the limit of withdraw money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 1000000 && customer.type == "Student")
//{
// MessageBox.Show("You have achieved the limit of withdraw money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
connect.executeUpdate("update customer set balance = balance - " + Int32.Parse(amountxt.Text.ToString()) + " where accountnumber = '" + customer.accountnumber + "'");
connect.executeUpdate("insert into transaction values('','', 'Withdraw Money', " + Int32.Parse(amountxt.Text.ToString()) + ", '" + customer.accountnumber + "', '', current_date)");
MessageBox.Show("Success Withdraw Money!");
Window mainwindow = new ATMWindow(customer);
mainwindow.Show();
this.Close();
}
private void done(object sender, RoutedEventArgs e)
{
if (rcvtxt.Text == "")
{
MessageBox.Show("Account Number Must Be Filled!");
return;
}
if (amountxt.Text == "")
{
MessageBox.Show("Amount Must Be Filled!");
return;
}
int balance = Int32.Parse(amountxt.Text.ToString());
string receiver = rcvtxt.Text.ToString();
string note = typebox.SelectedValue.ToString();
if (customer.balance - Int32.Parse(amountxt.Text.ToString()) <= 50000 && customer.type.ToString() != "Student")
{
MessageBox.Show("The Balance left in your account must be more than or equals 50000!");
return;
}
if (customer.balance - Int32.Parse(amountxt.Text.ToString()) <= 1000 && customer.type.ToString() == "Student")
{
MessageBox.Show("The Balance left in your account must be more than or equals 1000!");
return;
}
DataTable dt = new DataTable();
dt = connect.executeQuery("select sum(amount) as 'Total' from transaction where transactiontype in ('Transfer Money','Payments') and senderaccnum = '" + customer.accountnumber + "' and date = current_date");
DataRow data = dt.Rows[0];
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 2000000 && customer.type == "Bronze")
//{
// MessageBox.Show("You have achieved the limit of transfer money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 3000000 && customer.type == "Silver")
//{
// MessageBox.Show("You have achieved the limit of transfer money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 5000000 && customer.type == "Gold")
//{
// MessageBox.Show("You have achieved the limit of transfer money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 7000000 && customer.type == "Black")
//{
// MessageBox.Show("You have achieved the limit of transfer money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
//if (Int32.Parse(data["Total"].ToString()) + Int32.Parse(amountxt.Text.ToString()) > 500000 && customer.type == "Student")
//{
// MessageBox.Show("You have achieved the limit of transfer money today!");
// Window a = new ATMWindow(customer);
// a.Show();
// this.Close();
// return;
//}
string id = customer.accountnumber;
connect.executeUpdate("update customer set balance = balance - " + balance + " where accountnumber = '" + id + "'");
connect.executeUpdate("insert into transaction values('" + customer.name + "','" + customer.accountnumber + "', 'Payments', " + balance + ", '" + receiver + "', '" + note + "', current_Date)");
MessageBox.Show("Success!");
Window nextw = new ATMWindow(customer);
nextw.Show();
this.Close();
}