public void SaveOrderContactDetails(SaveOrderContactDetailsRequest request) { Domain.OrderContact orderContact = new Domain.OrderContact() { ContactName = request.ContactName, ContactNo = request.ContactNo, ExtNo = request.ExtNo, OrderId = request.OrderId }; _staffOrderRepo.SaveOrderContactDetails(orderContact); }
public GetListStaffOrdersForStaffMemberResponse GetStaffOrdersForStaffMember(GetStaffOrdersForStaffMemberRequest request) { var orders = _staffOrderRepo.GetOrdersForStaffMember(request.EmpNo); List <GetStaffOrdersForStaffMemberResponse> list = new List <GetStaffOrdersForStaffMemberResponse>(); foreach (var item in orders) { var contactDetails = _staffOrderRepo.GetOrderContactDetails(item.OrderId); if (contactDetails == null) { contactDetails = new Domain.OrderContact() { ContactName = String.Empty, ContactNo = String.Empty, OrderId = 0, ExtNo = String.Empty }; } list.Add(new GetStaffOrdersForStaffMemberResponse() { OrderId = item.OrderId, Dept = item.Dept, Description = item.Description, EmployeeNo = item.EmployeeNo, Mailing = item.Mailing, Month = item.Month, OrderDate = item.OrderDate.ToString("yyyy/MM/dd"), page = item.page, OrderCode = item.OrdCode, Price = item.Price, Size = item.Size, StatusID = item.StatusID, ContactName = contactDetails.ContactName, ContactNo = contactDetails.ContactNo, ExtNo = contactDetails.ExtNo }); } GetListStaffOrdersForStaffMemberResponse response = new GetListStaffOrdersForStaffMemberResponse() { Responses = list }; return(response); }
public OrderContact GetOrderContactDetails(int ordNo) { IDbConnection conn = _connectionFactory.GetNewSqlConnectionWithLoginDetails(new SqlConnection(connection), String.Empty, String.Empty); var sqlStr = "select StaffOrdNo as OrderId, " + "ContactName, " + "ContactNo, " + "ExtNo" + " from stoOrderContact " + "where StaffOrdNo = @OrdNo "; DynamicParameters param = new DynamicParameters(); param.Add("@OrdNo", ordNo, dbType: DbType.Int32, direction: ParameterDirection.Input); Domain.OrderContact orderContact = conn.Query <Domain.OrderContact>(sqlStr, param, commandType: CommandType.Text).SingleOrDefault(); return(orderContact); }