public bool updateData(DTO.DTO_Staff staff)
{
try
{
SqlCommand command = new SqlCommand("pr_updateStaff", con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@staffID", SqlDbType.VarChar).Value = staff.StaffID;
command.Parameters.Add("@staffName", SqlDbType.VarChar).Value = staff.StaffName;
command.Parameters.Add("@staffGender", SqlDbType.VarChar).Value = staff.StaffGender;
command.Parameters.Add("@staffFingerprint", SqlDbType.VarChar).Value = staff.StaffFingerprint;
command.Parameters.Add("@staffAddress", SqlDbType.VarChar).Value = staff.StaffAddress;
command.Parameters.Add("@staffPhoneNumber", SqlDbType.VarChar).Value = staff.StaffPhoneNumber;
command.Parameters.Add("@staffOfficeID", SqlDbType.VarChar).Value = staff.OfficeID;
int result = command.ExecuteNonQuery();
command.Parameters.Clear();
return(result >= 0);
}
catch
{
return(false);
}
}
public bool insertData(DTO.DTO_Staff staff)
{
return(new DAL.DAL_Staff().insertData(staff));
}
public bool updateData(DTO.DTO_Staff staff)
{
return(new DAL.DAL_Staff().updateData(staff));
}
