コード例 #1
0
        public async Task<ActionResult> Inventory_Update([DataSourceRequest] DataSourceRequest request, InventoryViewModel inventoryViewModel)
        {
            if (inventoryViewModel != null && ModelState.IsValid)
            {
                Inventory data = db.Inventories.Find(inventoryViewModel.ID);

                //data.StockInById = inventoryViewModel.StockInUserId;
                //data.StockInDate = inventoryViewModel.StockInDate;
                //data.DealerId = inventoryViewModel.DealerId;
                List<SalesTransaction> sales = db.SalesTransactions.Where(s => s.InventoryId == inventoryViewModel.ID).ToList();

                if (sales.Count == 1)
                {
                    sales[0].ProductId = inventoryViewModel.ProductId;
                }


                data.ProductId = inventoryViewModel.ProductId;
                data.IMEI = inventoryViewModel.IMEI;
                data.Type = inventoryViewModel.Type;
                data.Note = inventoryViewModel.Note;
                if (data.Type == InventoryType.Purchased)
                {
                    data.PurchasedFrom = string.IsNullOrEmpty(inventoryViewModel.PurchasedFrom) ? null : inventoryViewModel.PurchasedFrom;
                    data.PurchasedById = inventoryViewModel.PurchasedById;
                    data.DefferCode = null;
                    data.DefferName = null;
                    data.DefferOrderNo = null;
                    inventoryViewModel.DefferCode = null;
                    inventoryViewModel.DefferName = null;
                    inventoryViewModel.DefferOrderNo = null;
                }
                else if (data.Type == InventoryType.Deffer)
                {
                    data.DefferCode = string.IsNullOrEmpty(inventoryViewModel.DefferCode) ? null : inventoryViewModel.DefferCode;
                    data.DefferName = string.IsNullOrEmpty(inventoryViewModel.DefferName) ? null : inventoryViewModel.DefferName;
                    data.DefferOrderNo = string.IsNullOrEmpty(inventoryViewModel.DefferOrderNo) ? null : inventoryViewModel.DefferOrderNo;
                    data.PurchasedFrom = null;
                    data.PurchasedById = null;
                    inventoryViewModel.PurchasedFrom = null;
                    inventoryViewModel.PurchasedById = null;
                }
                else
                {
                    data.PurchasedFrom = null;
                    data.PurchasedById = null;
                    data.DefferCode = null;
                    data.DefferName = null;
                    data.DefferOrderNo = null;
                    inventoryViewModel.PurchasedFrom = null;
                    inventoryViewModel.PurchasedById = null;
                    inventoryViewModel.DefferCode = null;
                    inventoryViewModel.DefferName = null;
                    inventoryViewModel.DefferOrderNo = null;
                }
                
                db.Entry(data).State = EntityState.Modified;
                await db.SaveChangesAsync();
            }

            return Json(new[] { inventoryViewModel }.ToDataSourceResult(request, ModelState));
        }
コード例 #2
0
        public async Task<ActionResult> Inventory_Create([DataSourceRequest] DataSourceRequest request, InventoryViewModel inventoryViewModel)
        {
            //if (inventory != null && ModelState.IsValid)
            //{
            //    db.Inventories.Add(inventory);
            //    //await db.SaveChangesAsync();
            //}

            ////var invetoryChangeHistory = new InvetoryChangeHistory
            ////{
            ////    ChangeDate = DateTime.Now,
            ////    Inventory = inventory,
            ////    OperatedByEmployeeID = User.Identity.GetUserId(),
            ////    OperationType = InventoryOperationType.In
            ////};

            ////db.InvetoryChangeHistories.Add(invetoryChangeHistory);
            //await db.SaveChangesAsync();

            //return Json(new[] { inventory }.ToDataSourceResult(request, ModelState));




            if (inventoryViewModel != null && ModelState.IsValid)
            {
                inventoryViewModel.StockInUserId = User.Identity.GetUserId();
                if (HelperMethods.GetDealerId().HasValue)
                    inventoryViewModel.DealerId = HelperMethods.GetDealerId().GetValueOrDefault();
                else
                {
                    //return HttpNotFound("No Current Dealer Found");
                }

                inventoryViewModel.StockInDate = DateTime.Now;

                Inventory data = new Inventory
                {
                    StockInById = inventoryViewModel.StockInUserId,
                    StockInDate = inventoryViewModel.StockInDate,
                    DealerId = inventoryViewModel.DealerId,
                    ProductId = inventoryViewModel.ProductId,
                    IMEI = inventoryViewModel.IMEI,
                    Type = inventoryViewModel.Type,
                    Note = inventoryViewModel.Note,
                    PurchasedFrom = string.IsNullOrEmpty(inventoryViewModel.PurchasedFrom) ? null:inventoryViewModel.PurchasedFrom,
                    PurchasedById = inventoryViewModel.PurchasedById,
                    DefferCode = string.IsNullOrEmpty(inventoryViewModel.DefferCode) ? null : inventoryViewModel.DefferCode,
                    DefferName = string.IsNullOrEmpty(inventoryViewModel.DefferName) ? null : inventoryViewModel.DefferName,
                    DefferOrderNo = string.IsNullOrEmpty(inventoryViewModel.DefferOrderNo) ? null : inventoryViewModel.DefferOrderNo
                };

                db.Inventories.Add(data);


                //add change record to history
                InvetoryChangeHistory changeHistory2 = new InvetoryChangeHistory();
                changeHistory2.IMEI = data.IMEI;
                changeHistory2.ChangeDate = data.StockInDate;
                changeHistory2.OldOperationType = null;
                changeHistory2.NewOperationType = InventoryOperationType.In;
                changeHistory2.OperatedByEmployeeID = data.StockInById;
                var result = await HelperMethods.GetCurrentDealer();
                changeHistory2.ToDealer = result.DealerName;
                db.InvetoryChangeHistories.Add(changeHistory2);

                await db.SaveChangesAsync();
                //db.SaveChanges();
                //inventoryViewModel.ID = data.InventoryId;
                await db.SaveChangesAsync();
                inventoryViewModel.ID = data.InventoryId;
            }
            //salesTransaction.LinkedPlan = db.Plans.FirstOrDefault(p => p.PlanId == salesTransaction.PlanId);
            //await db.SaveChangesAsync();
            return Json(new[] { inventoryViewModel }.ToDataSourceResult(request, ModelState));
        }