public HttpResponseMessage GetOrderstoGenerateInvoice() { var invoiceDtlList = dl.GetOrderstoGenerateInvoice(); var orders = new List <InvoiceBO>(); foreach (var list in invoiceDtlList) { InvoiceBO bo = new InvoiceBO(); bo.order = new DeliveryOrderBO(); bo.orderDetails = new DeliveryOrderDetailBO(); bo.order.OrderKey = list.OrderKey; bo.order.OrderNo = list.OrderNo; bo.order.OrderDate = list.OrderDate; bo.order.OrderType = list.OrderType; bo.order.BrokerRefNo = list.BrokerRefNo; bo.order.CustKey = list.CustKey; bo.order.BillToAddress = list.BillToAddress; bo.order.SourceAddress = list.SourceAddress; bo.order.DestinationAddress = list.DestinationAddress; bo.order.VesselName = list.VesselName; bo.order.BillofLading = list.BillofLading; bo.order.BookingNo = list.BookingNo; // bo.order.CutOffDate = list.CutOffDate; bo.orderDetails.OrderDetailKey = list.OrderDetails.OrderDetailKey; bo.orderDetails.ContainerNo = list.OrderDetails.ContainerNo; bo.orderDetails.ContainerSizeDesc = list.OrderDetails.ContainerSizeDesc; bo.orderDetails.ContainerSize = list.OrderDetails.ContainerSize; bo.orderDetails.Chassis = list.OrderDetails.Chassis; bo.orderDetails.SealNo = list.OrderDetails.SealNo; if (list.CustKey != null) { var addr = new AddressRepository().GetbyId(list.CustKey); if (addr != null) { bo.BillFrom = new AddressBO() { AddrKey = addr.addrkey, Address1 = addr.address1, Address2 = addr.address2, City = addr.city, State = addr.state, Zip = addr.zipcode, Email = addr.email, Phone = addr.phone, Fax = addr.fax, Name = addr.addrname }; } } if (list.CustKey != null) { var addrBillTo = new AddressRepository().GetbyId(list.BillToAddress); if (addrBillTo != null) { bo.BillTo = new AddressBO() { AddrKey = addrBillTo.addrkey, Address1 = addrBillTo.address1, Address2 = addrBillTo.address2, City = addrBillTo.city, State = addrBillTo.state, Zip = addrBillTo.zipcode, Email = addrBillTo.email, Phone = addrBillTo.phone, Fax = addrBillTo.fax, Name = addrBillTo.addrname }; } } if (list.SourceAddress != null) { var addrBillTo = new AddressRepository().GetbyId(list.SourceAddress); if (addrBillTo != null) { bo.Pickup = new AddressBO() { AddrKey = addrBillTo.addrkey, Address1 = addrBillTo.address1, Address2 = addrBillTo.address2, City = addrBillTo.city, State = addrBillTo.state, Zip = addrBillTo.zipcode, Email = addrBillTo.email, Phone = addrBillTo.phone, Fax = addrBillTo.fax, Name = addrBillTo.addrname }; } } if (list.DestinationAddress != null) { var addrBillTo = new AddressRepository().GetbyId(list.DestinationAddress); if (addrBillTo != null) { bo.Delivery = new AddressBO() { AddrKey = addrBillTo.addrkey, Address1 = addrBillTo.address1, Address2 = addrBillTo.address2, City = addrBillTo.city, State = addrBillTo.state, Zip = addrBillTo.zipcode, Email = addrBillTo.email, Phone = addrBillTo.phone, Fax = addrBillTo.fax, Name = addrBillTo.addrname }; } } orders.Add(bo); } return(Request.CreateResponse(HttpStatusCode.OK, orders, Configuration.Formatters.JsonFormatter)); }