public void SavePersonalDetails(SavePersonalDetails request) { Domain.StaffMember staffMember = new Domain.StaffMember() { ContactNo = request.ContactNo, Department = request.Department, EmpNo = request.EmpNo, ExtNo = request.ExtNo, FirstName = request.FirstName, LastName = request.LastName, UserName = request.UserName }; _staffOrderRepo.SavePersonalDetails(staffMember); }
public StaffMember GetStaffMemberEmpNo(string empNo) { IDbConnection conn = _connectionFactory.GetNewSqlConnectionWithLoginDetails(new SqlConnection(connection), String.Empty, String.Empty); var sqlStr = "select FirstName, " + "LastName, " + "EmpNo, " + "Dept," + "ContactNo, " + "ExtNo " + " from stoStaff " + "where EmpNo = @EmpNo "; DynamicParameters param = new DynamicParameters(); param.Add("@EmpNo", empNo, dbType: DbType.String, direction: ParameterDirection.Input); Domain.StaffMember staffMember = conn.Query <Domain.StaffMember>(sqlStr, param, commandType: CommandType.Text).SingleOrDefault(); return(staffMember); }