コード例 #1
0
 public object AssignWarehouseCarrier(int FulOrderId, int WarehouseId, int CarrierId, int CarrierServiceId)
 {
     try
     {
         int      FulStatusId          = (from fs in context.FulOrderStatus where fs.Name.ToUpper() == _iconfiguration["ASSIGNED"] select fs.FulOrderStatusId).FirstOrDefault();
         bool     FulOrderAutoHold_FLG = (from cs in context.CarrierService where cs.CarrierServiceId == CarrierServiceId select cs.FulOrderAutoHold_FLG).FirstOrDefault();
         int      OnHoldReasonId       = (from r in context.OnHoldReason where r.Name.ToUpper() == _iconfiguration["EXPENSIVE_SERVICE_WAS_ASSIGNED"] select r.OnHoldReasonId).FirstOrDefault();
         FulOrder FulOrderObj          = (from fo in context.FulOrder
                                          where fo.FulOrderId == FulOrderId
                                          select fo).FirstOrDefault();
         if (FulOrderObj != null)
         {
             FulOrderObj.AssignedWarehouseId      = WarehouseId;
             FulOrderObj.AssignedCarrierId        = CarrierId;
             FulOrderObj.AssignedCarrierServiceId = CarrierServiceId;
             FulOrderObj.FulOrderStatusId         = FulStatusId;
             FulOrderObj.Assignment_DT            = DateTime.Now;
             if (FulOrderAutoHold_FLG)
             {
                 FulOrderObj.OnHold_FLG     = true;
                 FulOrderObj.OnHoldReasonId = OnHoldReasonId;
             }
             context.FulOrder.Update(FulOrderObj);
             context.SaveChanges();
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception Ex)
     {
         LogServiceObj.LogException(Ex);
         MailServiceObj.SendMail(Ex.Message ?? "", (Ex.InnerException != null) ? Ex.InnerException.Message : "", Ex.StackTrace ?? "");
         return(false);
     }
 }
コード例 #2
0
 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;
     }
 }
コード例 #3
0
        public Object PalletizeFulOrder(string trackingNumber, int palletId)
        {
            try
            {
                Guid TrackingNumber;
                if (!Guid.TryParse(trackingNumber, out TrackingNumber))
                {
                    return(new { status = false, message = _iconfiguration["INVALID_TRACKINGFORMAT"] });
                }
                /*get FulOrder information based on given tracking number and palletId*/
                Shipment shipmentObj = new Shipment();
                shipmentObj = (from s in context.Shipment
                               where s.TrackingNumber == TrackingNumber
                               select s).FirstOrDefault();
                if (shipmentObj == null)
                {
                    return(new { status = false, message = _iconfiguration["TRACKINGNO_NOTFOUND"] });
                }

                Pallet PalletObj = (from p in context.Pallet
                                    where p.PalletId == palletId
                                    select p).FirstOrDefault();
                if (PalletObj == null)
                {
                    return new { status = false, message = _iconfiguration["PALLETID_NOTFOUND"] }
                }
                ;

                int?CarrierServiceTypeId = (from cs in context.CarrierService
                                            where cs.CarrierServiceId == shipmentObj.CarrierServiceId && cs.CarrierId == shipmentObj.CarrierId
                                            select cs.CarrierServiceTypeId).FirstOrDefault();

                if (PalletObj.CarrierId != shipmentObj.CarrierId || PalletObj.CarrierServiceTypeId != CarrierServiceTypeId)
                {
                    return new { status = false, message = _iconfiguration["PALLET_SHIPMENT_CARRIER_NOT_MATCH"] }
                }
                ;

                if (shipmentObj.CarrierId == PalletObj.CarrierId && CarrierServiceTypeId != null && CarrierServiceTypeId == PalletObj.CarrierServiceTypeId)
                {
                    FulOrder FulOrderObj = new FulOrder();

                    FulOrderObj = (from fo in context.FulOrder
                                   join fos in context.FulOrderStatus on fo.FulOrderStatusId equals fos.FulOrderStatusId
                                   where fo.FulOrderId == shipmentObj.FulOrderId && fos.Name == _iconfiguration["PACKAGED"]
                                   select fo).FirstOrDefault();

                    if (FulOrderObj == null)
                    {
                        return new { status = false, message = _iconfiguration["FULORDER_NOT_IN_PACKAGE"] }
                    }
                    ;

                    FulOrderStatus FulOrderStatusObj = (from fos in context.FulOrderStatus
                                                        where fos.Name.ToUpper() == _iconfiguration["PALLETIZED"]
                                                        select fos).FirstOrDefault();
                    FulOrderObj.FulOrderStatusId = FulOrderStatusObj.FulOrderStatusId;
                    FulOrderObj.PalletId         = palletId;
                    context.FulOrder.Update(FulOrderObj);
                    context.SaveChanges();

                    Product ProductObj = new Product();
                    ProductObj = (from fi in context.FulItem
                                  join p in context.Product on fi.ProductId equals p.ProductId
                                  select p).FirstOrDefault();
                    ProductSKU productSKUObj = (from ps in context.ProductSKU
                                                where ps.ProductId == ProductObj.ProductId
                                                select ps).FirstOrDefault();

                    UpdateTrackingDTO response = new UpdateTrackingDTO();
                    response.fulOrderId     = FulOrderObj.FulOrderId;
                    response.fulOrderStatus = FulOrderStatusObj.Name;
                    response.productName    = ProductObj.Name;
                    response.sku            = productSKUObj.SKU;
                    response.trackingNumber = shipmentObj.TrackingNumber.ToString();
                    return(new { status = true, data = response, message = string.Format(_iconfiguration["PALLETIZED_SUCCESS"], FulOrderObj.FulOrderId.ToString()) });
                }
                return(new { status = false, message = _iconfiguration["ERROR_NOFULORDERPACKAGEFOUND"] });
            }
            catch (Exception Ex)
            {
                LogServiceObj.LogException(Ex);
                MailServiceObj.SendMail(Ex.Message ?? "", (Ex.InnerException != null) ? Ex.InnerException.Message : "", Ex.StackTrace ?? "");
                return(new
                {
                    status = false,
                    message = _iconfiguration["ERROR_CREATEPALLET"]
                });
            }
        }
コード例 #4
0
        public object CreatePackage(int fulOrderId)
        {
            try
            {
                UpdateTrackingDTO response    = new UpdateTrackingDTO();
                FulOrder          FulOrderObj = (from fo in context.FulOrder
                                                 join fos in context.FulOrderStatus on fo.FulOrderStatusId equals fos.FulOrderStatusId
                                                 where fo.FulOrderId == fulOrderId &&
                                                 fos.Name.ToUpper() == _iconfiguration["LABELCREATED"]
                                                 select fo).FirstOrDefault();
                if (FulOrderObj == null)
                {
                    return new
                           {
                               status  = false,
                               message = _iconfiguration["FULORDER_NOT_LABELED"]
                           }
                }
                ;
                FulOrderStatus FulOrderStatus = (from fos in context.FulOrderStatus
                                                 where fos.Name.ToUpper() == _iconfiguration["PACKAGED"]
                                                 select fos).FirstOrDefault();

                Product productObj = (from fi in context.FulItem
                                      join p in context.Product on fi.ProductId equals p.ProductId
                                      where fi.FulOrderId == fulOrderId
                                      select p).FirstOrDefault();
                ProductSKU productSKU = (from p in context.Product
                                         join ps in context.ProductSKU on p.ProductId equals ps.ProductId
                                         join pt in context.ProductSKUType on ps.SKUTypeId equals pt.ProductSKUTypeId
                                         where p.ProductId == productObj.ProductId && pt.Name.ToUpper() == _iconfiguration["SKU"]
                                         select ps).FirstOrDefault();
                Shipment shipmentObj = (from s in context.Shipment
                                        where s.FulOrderId == fulOrderId
                                        select s).FirstOrDefault();

                FulOrderObj.FulOrderStatusId = FulOrderStatus.FulOrderStatusId;
                context.FulOrder.Update(FulOrderObj);
                context.SaveChanges();

                if (productObj != null && productSKU != null && shipmentObj != null)
                {
                    response.fulOrderId = fulOrderId;

                    response.fulOrderStatus = FulOrderStatus.Name;
                    response.productName    = productObj.Name;
                    response.sku            = productSKU.SKU;
                    response.trackingNumber = shipmentObj.TrackingNumber.ToString();
                }
                else if (productObj == null)
                {
                    return(new { status = false, message = _iconfiguration["PRODUCTNOTFOUND"] });
                }
                else if (productSKU == null)
                {
                    return(new { status = false, message = _iconfiguration["PRODUCTSKUNOTFOUND"] });
                }
                else if (shipmentObj == null)
                {
                    return(new { status = false, message = _iconfiguration["SHIPMENTNOTFOUND"] });
                }
                return(new { status = true, message = string.Format(_iconfiguration["PACKAGE_SUCCESS"], fulOrderId.ToString()), data = response });
            }
            catch (Exception Ex)
            {
                LogServiceObj.LogException(Ex);
                MailServiceObj.SendMail(Ex.Message ?? "", (Ex.InnerException != null) ? Ex.InnerException.Message : "", Ex.StackTrace ?? "");
                return(new { status = false, message = _iconfiguration["ERROR_PACKAGE"] });
            }
        }
コード例 #5
0
        public object GenerateLabel(string UPC)
        {
            try
            {
                Product ProductObj = (from p in context.Product
                                      join ps in context.ProductSKU on p.ProductId equals ps.ProductId
                                      join pt in context.ProductSKUType on ps.SKUTypeId equals pt.ProductSKUTypeId
                                      where pt.Name.ToUpper() == _iconfiguration["SKU"] &&
                                      p.UPC == UPC
                                      select p).FirstOrDefault();
                Guid?RandomTrackingNumberStr = Guid.Empty;

                if (ProductObj != null)
                {
                    bool   GenerateShipment = false;
                    string ProductSKU       = (from psku in context.ProductSKU
                                               join pskutype in context.ProductSKUType on psku.SKUTypeId equals pskutype.ProductSKUTypeId
                                               where psku.ProductId == ProductObj.ProductId && pskutype.Name.ToUpper() == _iconfiguration["SKU"]
                                               select psku.SKU).FirstOrDefault();
                    FulOrder fulOrderObj = (from fi in context.FulItem
                                            join fo in context.FulOrder on fi.FulOrderId equals fo.FulOrderId
                                            join fs in context.FulOrderStatus on fo.FulOrderStatusId equals fs.FulOrderStatusId
                                            where fs.Name.ToUpper() == _iconfiguration["LABELCREATED"] &&
                                            (fo.OnHold_FLG ?? false) == false &&
                                            fi.ProductId == ProductObj.ProductId
                                            select fo).OrderBy(fo => fo.OrderId).FirstOrDefault();

                    if (fulOrderObj != null)
                    {
                        GenerateShipment        = true;
                        RandomTrackingNumberStr = (from s in context.Shipment where s.FulOrderId == fulOrderObj.FulOrderId select s.TrackingNumber).FirstOrDefault();
                    }
                    else
                    {
                        fulOrderObj = (from fi in context.FulItem
                                       join fo in context.FulOrder on fi.FulOrderId equals fo.FulOrderId
                                       join fs in context.FulOrderStatus on fo.FulOrderStatusId equals fs.FulOrderStatusId
                                       where fs.Name.ToUpper() == _iconfiguration["PICKING"] &&
                                       (fo.OnHold_FLG ?? false) == false &&
                                       (fo.Error_FLG ?? false) == false &&
                                       fi.ProductId == ProductObj.ProductId
                                       select fo).OrderBy(fo => fo.OrderId).FirstOrDefault();
                    }
                    if (fulOrderObj == null)
                    {
                        return new { status = false, message = _iconfiguration["UPC_PICKED_NOTFOUND"] }
                    }
                    ;

                    FulOrderStatus fulOrderStatusObj = (from fs in context.FulOrderStatus where fs.Name.ToUpper() == _iconfiguration["LABELCREATED"] select fs).FirstOrDefault();
                    Box            BoxObj            = (from b in context.Box
                                                        where b.BoxId == ProductObj.BoxId
                                                        select b).FirstOrDefault();
                    if (!GenerateShipment && fulOrderObj != null && ProductObj != null)
                    {
                        fulOrderObj.FulOrderStatusId = fulOrderStatusObj.FulOrderStatusId;

                        RandomTrackingNumberStr = Guid.NewGuid();
                        /* Insertion of Shipment record */
                        Shipment ShipmentObj = new Shipment();
                        ShipmentObj.CarrierId        = fulOrderObj.AssignedCarrierId ?? 0;
                        ShipmentObj.CarrierServiceId = fulOrderObj.AssignedCarrierServiceId ?? 0;
                        ShipmentObj.FulOrderId       = fulOrderObj.FulOrderId;
                        ShipmentObj.Height           = (BoxObj != null) ? BoxObj.Height : 0;
                        ShipmentObj.Length           = (BoxObj != null) ? BoxObj.Length : 0;
                        ShipmentObj.StatusUpdatedDT  = DateTime.Now;
                        ShipmentObj.Width            = (BoxObj != null) ? BoxObj.Width : 0;
                        ShipmentObj.Weight           = ProductObj.Weight;
                        ShipmentObj.TrackingNumber   = RandomTrackingNumberStr;
                        ShipmentObj.ShippingLabel    = null;
                        ShipmentObj.ShipmentStatusId = (from ss in context.ShipmentStatus
                                                        where ss.Name.ToUpper() == _iconfiguration["ACTIVE"]
                                                        select ss.ShipmentStatusId).FirstOrDefault();
                        context.Shipment.Add(ShipmentObj);
                        context.FulOrder.Update(fulOrderObj);
                        context.SaveChanges();
                    }
                    UpdateTrackingDTO TrackingDTOObj = new UpdateTrackingDTO();
                    TrackingDTOObj.fulOrderId     = fulOrderObj.FulOrderId;
                    TrackingDTOObj.productName    = ProductObj.Name;
                    TrackingDTOObj.fulOrderStatus = fulOrderStatusObj.Name;
                    TrackingDTOObj.sku            = ProductSKU;
                    TrackingDTOObj.trackingNumber = (RandomTrackingNumberStr != null) ? RandomTrackingNumberStr.ToString() : "";
                    return(new { status = true, data = TrackingDTOObj });
                }
                else
                {
                    return(new { status = false, message = _iconfiguration["UPC_NOT_FOUND"] });
                }
            }
            catch (Exception Ex)
            {
                LogServiceObj.LogException(Ex);
                MailServiceObj.SendMail(Ex.Message ?? "", (Ex.InnerException != null) ? Ex.InnerException.Message : "", Ex.StackTrace ?? "");
                return(new { status = false, message = _iconfiguration["UNHANDLEDEXCEPTION"] });
            }
        }
コード例 #6
0
        private bool SaveFulfillOrders(string OrderNumber, List <OrderLine> OrderLineList)
        {
            try
            {
                /*Pending Part: Need to check whether inventory is available or not*/
                List <FulOrder>         FulOrderList         = new List <FulOrder>();
                List <FulItem>          FulItemList          = new List <FulItem>();
                List <ProductInventory> ProductInvListUpdate = new List <ProductInventory>();
                List <Order>            OrderListUpdate      = new List <Order>();
                Order    OrderObj           = (from o in context.Order where o.OrderNumber == OrderNumber select o).FirstOrDefault();
                bool     isPrime            = OrderObj.IsPrime_FLG;
                string   CarrierDescription = OrderObj.CarrierDescription;
                DateTime ShipByDT           = OrderObj.ShipByDT;
                int      FulOrderStatusId   = context.FulOrderStatus.Where(StatusRec => StatusRec.Name.ToUpper() == _iconfiguration["ENTERED"]).Select(StatusRec => StatusRec.FulOrderStatusId).FirstOrDefault();

                foreach (OrderLine OrdrLineObj in OrderLineList)
                {
                    ProductInventory ProductInvObj = context.Product.Join(context.ProductVersion, p => p.ProductId, PI => PI.ProductId, (p, PI) => PI)
                                                     .Join(context.ProductInventory, pi => pi.ProductVersionId, pv => pv.ProductVersionId, (pi, pv) => new { pi, pv })
                                                     .Where(pv => pv.pi.ProductId == OrdrLineObj.ProductId).Select(x => x.pv).FirstOrDefault();
                    if (ProductInvObj != null && ProductInvObj.Quantity >= OrdrLineObj.Quantity)
                    {
                        Product productObj = context.Product.Where(P => P.ProductId == OrdrLineObj.ProductId).Select(p => p).FirstOrDefault();
                        if (productObj != null && productObj.ShipsAlone_FLG)
                        {
                            int iteration = 0;
                            while (iteration < OrdrLineObj.Quantity)
                            {
                                iteration++;
                                FulOrder FulOrderObj = new FulOrder();
                                FulOrderObj.OrderId            = OrdrLineObj.OrderId;
                                FulOrderObj.FulOrderStatusId   = FulOrderStatusId;
                                FulOrderObj.OnHold_FLG         = false;
                                FulOrderObj.Error_FLG          = false;
                                FulOrderObj.IsPrime_FLG        = isPrime;
                                FulOrderObj.CarrierDescription = CarrierDescription;
                                FulOrderObj.ShipByDT           = ShipByDT;
                                FulOrderList.Add(FulOrderObj);
                            }
                        }
                        else if (productObj != null && !productObj.ShipsAlone_FLG)
                        {
                            FulOrder FulOrderObj = new FulOrder();
                            FulOrderObj.OrderId            = OrdrLineObj.OrderId;
                            FulOrderObj.FulOrderStatusId   = FulOrderStatusId;
                            FulOrderObj.OnHold_FLG         = false;
                            FulOrderObj.Error_FLG          = false;
                            FulOrderObj.IsPrime_FLG        = isPrime;
                            FulOrderObj.CarrierDescription = CarrierDescription;
                            FulOrderObj.ShipByDT           = ShipByDT;
                            FulOrderList.Add(FulOrderObj);
                        }
                    }
                    else if (ProductInvObj != null && ProductInvObj.Quantity < OrdrLineObj.Quantity)
                    {
                        MailServiceObj.SendMail(string.Format(_iconfiguration["ProductInventoryShortage"],
                                                              OrdrLineObj.SKU,
                                                              OrderNumber ?? "",
                                                              OrdrLineObj.Quantity.ToString(),
                                                              ProductInvObj.Quantity.ToString(),
                                                              (OrdrLineObj.Quantity - ProductInvObj.Quantity).ToString()));
                    }
                }
                context.FulOrder.AddRange(FulOrderList);
                try
                {
                    context.SaveChanges();
                }
                catch (Exception Ex)
                {
                    throw Ex;
                }
                bool OrderLineSaveResponse = false;
                if (FulOrderList.Count > 0)
                {
                    OrderLineSaveResponse = SaveFulItems(OrderLineList, FulOrderList);
                }
                return(OrderLineSaveResponse);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }