}//end getDataTable
//logout from admin page
private void btnLogout_Click(object sender, EventArgs e)
{
this.Hide(); //hide the current form
frmRegister reg = new frmRegister(); //set new frmRegister called reg
reg.ctozero(); //call function ctozero to initialize c from frmRegister
reg.Show(); //show reg
}//end btnLogout
}//end btnLog
//function if button btnExit is clicked
private void btnExit_Click_1(object sender, EventArgs e)
{
this.Hide(); //hides the current form
frmRegister frmReg = new frmRegister(); //creates a new frmRegister called frmReg
frmReg.ctozero(); //calls function ctozero from frmReg to initialize c
frmReg.Show(); //shows frmReg
}//end btnExit
}//end time2use
//function if button btnPrint is clicked
private void btnPrint_Click(object sender, EventArgs e)
{
//AddToDatabase(); //calls function AddToDatabase
//DeleteVoucher(); //calls function DeleteVoucher
//printreceipt(); //calls function printreceipt
frmRegister frmReg = new frmRegister(); //creates new frmRegister called frmReg
frmReg.ctozero(); //calls function ctozero from frmRegister to initialize c
this.Hide(); //hides current form
frmReg.Show(); //show frmReg
}//end btnPrint
}//end connectToVoucherDb
//function to checkUser if it exist
private void checkUser()
{
voucherDatabase.Open(); //opens database connection
//command in database stored in querystr
String queryStr = "SELECT count(*) FROM useraccount WHERE username='******' AND userpass ='******'";
OleDbCommand oleDbCmd = new OleDbCommand(queryStr, voucherDatabase); //creates new oledbCommand with parameters queryStr and voucherDatabase
int count = (int)oleDbCmd.ExecuteScalar(); //stores executescalar if a username and password exist as 1 or 0
if (count > 0) //if statement if a match was found
{
voucherDatabase.Close(); //closes database connection
frmRegister formReg = new frmRegister(); //creates new frmRegister called frmReg
formReg.Show(); //show frmReg
this.Hide(); //hides the current form
}
else
{
MessageBox.Show("Invalid Account"); //prompts a messagebox that indicates no username and password exists
txtUser.Text = ""; //clears txtUser textbox
txtPass.Text = ""; //clears txtPass textBox
voucherDatabase.Close(); //closes database connection
}
}//end checkUser
