public frmMain(EL.Registrations.Staffs _staffEL, EL.Registrations.ContactDetails _contactDetailEL, EL.Registrations.BasicInformations _basicInformationEL, EL.Registrations.StaffPositions _staffPositionEL, EL.Registrations.Addresses _addressEL, EL.Registrations.StoreInformation _storeInformationEL, frmLogin _frmLogin)
{
InitializeComponent();
staffEL = _staffEL;
contactDetailEL = _contactDetailEL;
basicInformationEL = _basicInformationEL;
staffPositionEL = _staffPositionEL;
addressEL = _addressEL;
storeInformationEL = _storeInformationEL;
this.frmLogin = _frmLogin;
}
public frmManagePurchaseOrders(EL.Registrations.Staffs _staffEL)
{
InitializeComponent();
staffEL = _staffEL;
}
public DataTable Login(EL.Registrations.Staffs staffEL)
{
string sQuery = "select * from staffs_view where `Username` = '" + staffEL.Username + "' and password = '******' ";
return(Helper.executeQuery(sQuery));
}
public bool Delete(EL.Registrations.Staffs staffEL)
{
return(Helper.executeNonQueryBool("delete from staffs where staffid = '" + staffEL.Staffid + "' "));
}
public bool Update(EL.Registrations.Staffs staffEL)
{
return(Helper.executeNonQueryBool("update staffs set username = '******', password = '******', staffpositionid = '" + staffEL.Staffpositionid + "' where staffid = '" + staffEL.Staffid + "' "));
}
public long Insert(EL.Registrations.Staffs staffEL)
{
return(Helper.executeNonQueryLong("insert into staffs (username, password, contactdetailid, basicinformationid, staffpositionid) values ('" + staffEL.Username + "', '" + staffEL.Password + "', '" + staffEL.Contactdetailid + "', '" + staffEL.Basicinformationid + "', '" + staffEL.Staffpositionid + "')"));
}
public DataTable CheckUsername(EL.Registrations.Staffs staffEL, int id)
{
return(Helper.executeQuery("select * from staffs_view where `Username` = '" + staffEL.Username + "' and `Staff ID` <> " + id + ""));
}
public frmManageProfile(EL.Registrations.Staffs _staffEL, frmMain _frmMain)
{
InitializeComponent();
staffEL = _staffEL;
frmMain = _frmMain;
}
public DataTable Login(EL.Registrations.Staffs staffEL)
{
return(StaffDL.Login(staffEL));
}
public bool Delete(EL.Registrations.Staffs staffEL)
{
return(StaffDL.Delete(staffEL));
}
public bool Update(EL.Registrations.Staffs staffEL)
{
return(StaffDL.Update(staffEL));
}
public long Insert(EL.Registrations.Staffs staffEL)
{
return(StaffDL.Insert(staffEL));
}
public DataTable CheckUsername(EL.Registrations.Staffs staffEL, int id)
{
return(StaffDL.CheckUsername(staffEL, id));
}
