public DataTable Login(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
string sQuery = "SELECT * FROM view_staffsaccount WHERE `USERNAME` = '" + staffsaccountEL.Username + "' AND `PASSWORD` = '" + staffsaccountEL.Password + "' ";
return(Helper.executeQuery(sQuery));
}
public bool Update(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(Helper.executeNonQueryBool("UPDATE staffsaccount SET username = '******', password = '******' WHERE staffaccountid = '" + staffsaccountEL.Staffaccountid + "' "));
}
public bool Delete(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(Helper.executeNonQueryBool("DELETE FROM staffsaccount WHERE staffaccountid = '" + staffsaccountEL.Staffaccountid + "' "));
}
public DataTable CheckUsername(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(Helper.executeQuery("SELECT * FROM view_staffsaccount WHERE `USERNAME` = '" + staffsaccountEL.Username + "'"));
}
public long Insert(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(Helper.executeNonQueryLong("INSERT INTO staffsaccount (staffid, username, password) VALUES ('" + staffsaccountEL.Staffid + "', '" + staffsaccountEL.Username + "', '" + staffsaccountEL.Password + "')"));
}
public DataTable Login(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(staffsaccountDL.Login(staffsaccountEL));
}
public bool Delete(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(staffsaccountDL.Delete(staffsaccountEL));
}
public bool Update(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(staffsaccountDL.Update(staffsaccountEL));
}
public long Insert(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(staffsaccountDL.Insert(staffsaccountEL));
}
public DataTable CheckUsername(EL.REGISTRATIONS.staffsaccount staffsaccountEL)
{
return(staffsaccountDL.CheckUsername(staffsaccountEL));
}