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)); }