void addNewStaff()
{
insUpdStaffIntoSql = new cInsUpdStaffIntoSql();
insUpdStaffIntoSql.sqlQuery = "insert into STAFFS(staffNameSurname, staffDuty, staffUserName,"
+ "staffPassword, staffPhoneNumber, staffStatus, staffPhoto)"
+ "VALUES (@name, @duty, @userName, @password, @phone, @status, @photo)";
insUpdStaffIntoSqlParameters();
insUpdStaffIntoSql.insertStaff();
}
void updateStaffInfo()
{
insUpdStaffIntoSql = new cInsUpdStaffIntoSql();
insUpdStaffIntoSql.sqlQuery = "update STAFFS set staffNameSurname = @name, staffDuty = @duty,"
+ "staffUserName = @userName, staffPassword = @password, staffPhoneNumber = @phone, staffStatus = @status,"
+ "staffPhoto = @photo where staffUserName = @userName";
insUpdStaffIntoSqlParameters();
insUpdStaffIntoSql.insertStaff();
}
