public Object EditFulorder(FulfillOrderViewDTO FulOrder) { try { bool isSuccess = false; string result = string.Empty; int fulOrderId = FulOrder.fulOrderId; FulOrder FulOrderObj = (from fo in context.FulOrder where fo.FulOrderId == fulOrderId select fo).FirstOrDefault(); if (FulOrderObj != null) { FulOrderObj.Error_FLG = FulOrder.errorFlag == "No" ? false : true; FulOrderObj.OnHold_FLG = FulOrder.onHoldFlag == "No" ? false : true; FulOrderObj.OnHoldReasonId = Convert.ToInt32(FulOrder.onHoldReason); FulOrderObj.ErrorReasonId = Convert.ToInt32(FulOrder.errorReason); context.FulOrder.Update(FulOrderObj); context.SaveChanges(); result = _iconfiguration["FULORDER_EDITED_SUCCESSFUL"]; isSuccess = true; } return(new { status = isSuccess, fulOrderID = FulOrder.fulOrderId, message = result }); } catch (Exception ex) { if (ex.InnerException != null) { return(new { status = false, fulOrderID = FulOrder.fulOrderId, message = ex.InnerException.Message }); } else { return(new { status = false, fulOrderID = FulOrder.fulOrderId, message = ex.Message }); } throw ex; } }
public object GetFullOrder(int FulOrderId) { FulfillOrderViewDTO FulOrderObj = new FulfillOrderViewDTO(); FulOrderObj = (from fo in context.FulOrder join c in context.CancelReason on fo.CancelReasonId equals c.CancelReasonId into crjoin from cjoin in crjoin.DefaultIfEmpty() join awh in context.Warehouse on fo.AssignedWarehouseId equals awh.WarehouseId into awhjoined from awhj in awhjoined.DefaultIfEmpty() join ac in context.Carrier on fo.AssignedCarrierId equals ac.CarrierId into acjoined from acj in acjoined.DefaultIfEmpty() join b in context.Box on fo.BoxId equals b.BoxId into bjoin from bj in bjoin.DefaultIfEmpty() join acs in context.CarrierService on fo.AssignedCarrierServiceId equals acs.CarrierServiceId into acsjoined from acsj in acsjoined.DefaultIfEmpty() join p in context.Pallet on fo.PalletId equals p.PalletId into pjoin from pj in pjoin.DefaultIfEmpty() join e in context.ErrorReason on fo.ErrorReasonId equals e.ErrorReasonId into ejoin from ej in ejoin.DefaultIfEmpty() join ohr in context.OnHoldReason on fo.OnHoldReasonId equals ohr.OnHoldReasonId into ohrjoined from ohrj in ohrjoined.DefaultIfEmpty() join fos in context.FulOrderStatus on fo.FulOrderStatusId equals fos.FulOrderStatusId into fosjoined from fosj in fosjoined.DefaultIfEmpty() where fo.FulOrderId == FulOrderId select new FulfillOrderViewDTO { assignedCarrier = (acj != null ? acj.Name : ""), assignedCarrierService = (acsj != null ? acsj.Name : ""), assignedWareHouse = (awhj != null ? awhj.Name : ""), assignmentDate = fo.Assignment_DT, box = (bj != null ? bj.Name : ""), cancelReason = (cjoin != null ? cjoin.Name : ""), carrierDescription = fo.CarrierDescription, carrierUpdateDate = fo.CarrierUpdateDT, errorFlag = (fo.Error_FLG != null ? fo.Error_FLG.ToString() : "No"), errorReason = (ej != null ? ej.Name : ""), fullItemDetails = new List <FulItemViewDTO>(), fulOrderId = fo.FulOrderId, fulOrderStatus = (fosj != null ? fosj.Name : ""), isPrime = (fo.IsPrime_FLG != null ? fo.IsPrime_FLG.ToString() : "No"), labelBatchId = fo.LabelBatchId, onHoldFlag = (fo.OnHold_FLG != null ? fo.OnHold_FLG.ToString() : "No"), onHoldReason = (ohrj != null ? ohrj.Name : ""), orderId = fo.OrderId, originalFulOrderId = fo.OriginalFulOrderId, palletName = (pj != null ? pj.Name : ""), pickingBatchId = fo.PickingBatchId, shipByDate = fo.ShipByDT }).FirstOrDefault(); if (FulOrderObj != null) { FulOrderObj.fullItemDetails = (from fi in context.FulItem join psku in context.ProductSKU on new { p1 = 1, p2 = fi.ProductId } equals new { p1 = psku.SKUTypeId, p2 = psku.ProductId } into pskujoined from pskuj in pskujoined.DefaultIfEmpty() join pv in context.ProductVersion on pskuj.ProductId equals pv.ProductId into pvjoined from pvj in pvjoined.DefaultIfEmpty() where fi.FulOrderId == FulOrderId select new FulItemViewDTO { fulItemId = fi.FulItemId, orderLineId = fi.OrderLineId, productId = fi.ProductId, productVersion = (pvj != null) ? pvj.Version : 0, quantity = fi.Quantity, sku = (pskuj != null) ? pskuj.SKU : "" }).OrderBy(x => x.fulItemId).ToList(); } return(FulOrderObj); }
public ActionResult <Object> EditFulorder(FulfillOrderViewDTO FulOrder) { var result = fulfillService.EditFulorder(FulOrder); return(Ok(result)); }