public WithdrawMoney(Employee emp, Customer cust)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
this.customer = cust;
InitializeComponent();
}
public FindCustomerByName()
{
this.connect = ConnectDatabase.getInstance();
InitializeComponent();
listbox.Visibility = Visibility.Hidden;
nextbutton.Visibility = Visibility.Hidden;
}
public Payments(Employee emp)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
InitializeComponent();
dt = new DataTable();
dt = connect.executeQuery("select * from customer");
int size = dt.Rows.Count;
for (int i = 0; i < size; i++)
{
data = dt.Rows[i];
sendernames.Add(data["name"].ToString());
senderaccnum.Add(data["accountnumber"].ToString());
}
combobox.ItemsSource = sendernames;
types.Add("Electric Bill");
types.Add("Phone Bill");
types.Add("Voucher");
types.Add("E-Commerce");
types.Add("Credit Card");
types.Add("Tickets");
types.Add("Others");
typebox.ItemsSource = types;
}
public WindowLogin()
{
this.connect = ConnectDatabase.getInstance();
InitializeComponent();
connect.executeUpdate("update deposit set enddate = (enddate + time) where (enddate - current_date) = 0 and aro = 0");
connect.executeUpdate("update virtualaccount set status = 'Expired' where (enddate - current_date) < 0 and status = 'Not Paid'");
connect.executeUpdate("delete from virtualaccount where status = 'Paid'");
}
public static ConnectDatabase getInstance()
{
if (Instance == null)
{
Instance = new ConnectDatabase();
}
return(Instance);
}
public TransferMoney(Employee emp, Customer cust)
{
this.connect = ConnectDatabase.getInstance();
this.employee = emp;
this.customer = cust;
InitializeComponent();
dt = new DataTable();
dt = connect.executeQuery("select * from customer");
int size = dt.Rows.Count;
for (int i = 0; i < size; i++)
{
data = dt.Rows[i];
sendernames.Add(data["name"].ToString());
senderaccnum.Add(data["accountnumber"].ToString());
}
combobox.ItemsSource = sendernames;
}
public FindCustomerByAccountNum(Employee emp, string nextaction)
{
this.connect = ConnectDatabase.getInstance();
InitializeComponent();
this.employee = emp;
this.action = nextaction;
if (nextaction.Equals("depositmoney"))
{
actiontxt.Content = "Deposit Money";
}
else if (nextaction.Equals("transfermoney"))
{
actiontxt.Content = "Transfer Money";
}
else
{
actiontxt.Content = "Payments";
}
nextbutton.Visibility = Visibility.Hidden;
listbox.Visibility = Visibility.Hidden;
}
public InputAccNum()
{
this.connect = ConnectDatabase.getInstance();
InitializeComponent();
}
public FindCustomerByAccountNum()
{
this.connect = ConnectDatabase.getInstance();
InitializeComponent();
}
public ATMDeposit(Customer cust)
{
this.connect = ConnectDatabase.getInstance();
this.customer = cust;
InitializeComponent();
}