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