public ActionResult CreateForGift() { var model = new PhysicalInventoryViewModel(); model.Type = PhysicalInventoryType.Gift; var warehouseList = WarehouseRepository.GetAllWarehouse().Where(x => x.BranchId == Helpers.Common.CurrentUser.BranchId && x.Categories.Contains("GIFT")).AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); ViewBag.warehouseList = warehouseList; return(View(model)); }
public ActionResult Create() { var model = new PhysicalInventoryViewModel(); var warehouseList = WarehouseRepository.GetAllWarehouse().AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); ViewBag.warehouseList = warehouseList; var manufacturer = categoryRepository.GetCategoryByCode("manufacturerList").AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Value }); ViewBag.manufacturer = manufacturer; return(View(model)); }
public ActionResult Detail(int?Id) { var PhysicalInventory = PhysicalInventoryRepository.GetAllvwPhysicalInventory() .Where(item => item.Id == Id).FirstOrDefault(); if (PhysicalInventory != null) { var model = new PhysicalInventoryViewModel(); AutoMapper.Mapper.Map(PhysicalInventory, model); var detailList = PhysicalInventoryRepository.GetAllvwPhysicalInventoryDetail(Id.Value); model.DetailList = detailList.Select(item => new PhysicalInventoryDetailViewModel { Note = item.Note, ProductId = item.ProductId, ProductCode = item.ProductCode, ProductName = item.ProductName, PhysicalInventoryId = item.PhysicalInventoryId, QuantityInInventory = item.QuantityInInventory, QuantityRemaining = item.QuantityRemaining, QuantityDiff = item.QuantityDiff, CategoryCode = item.CategoryCode, ExpiryDate = item.ExpiryDate, LoCode = item.LoCode }) .OrderBy(item => item.CategoryCode) .ThenBy(item => item.ProductCode) .ToList(); return(View(model)); } if (Request.UrlReferrer != null) { return(Redirect(Request.UrlReferrer.AbsoluteUri)); } return(RedirectToAction("Index")); }
public ActionResult Create() { var model = new PhysicalInventoryViewModel(); model.Type = PhysicalInventoryType.Product; var warehouseList = WarehouseRepository.GetAllWarehouse().Where(x => x.BranchId == Helpers.Common.CurrentUser.BranchId).AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); ViewBag.warehouseList = warehouseList; var manufacturer = categoryRepository.GetCategoryByCode("manufacturerList").AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Value }); ViewBag.manufacturer = manufacturer; return(View(model)); }
public ActionResult Create(PhysicalInventoryViewModel model) { if (ModelState.IsValid) { PhysicalInventory PhysicalInventory = new Domain.Sale.Entities.PhysicalInventory(); AutoMapper.Mapper.Map(model, PhysicalInventory); PhysicalInventory.CreatedUserId = WebSecurity.CurrentUserId; PhysicalInventory.CreatedDate = DateTime.Now; PhysicalInventory.ModifiedUserId = WebSecurity.CurrentUserId; PhysicalInventory.ModifiedDate = DateTime.Now; PhysicalInventory.IsDeleted = false; PhysicalInventory.IsExchange = false; PhysicalInventory.BranchId = Helpers.Common.CurrentUser.BranchId; List <PhysicalInventoryDetail> PhysicalInventoryDetailList = new List <PhysicalInventoryDetail>(); if (model.DetailList != null) { foreach (var item in model.DetailList) { Inventory inventoryProduct = InventoryRepository.GetInventoryByWarehouseIdAndProductId(model.WarehouseId.Value, item.ProductId); int QuantityInInventory = 0; if (inventoryProduct != null) { QuantityInInventory = inventoryProduct.Quantity.Value; inventoryProduct.Quantity = item.QuantityRemaining; InventoryRepository.UpdateInventory(inventoryProduct); } PhysicalInventoryDetailList.Add(new PhysicalInventoryDetail { CreatedDate = DateTime.Now, CreatedUserId = WebSecurity.CurrentUserId, IsDeleted = false, Note = item.Note, ProductId = item.ProductId, QuantityInInventory = QuantityInInventory, QuantityRemaining = item.QuantityRemaining, QuantityDiff = item.QuantityRemaining - QuantityInInventory }); } } PhysicalInventoryRepository.InsertPhysicalInventory(PhysicalInventory, PhysicalInventoryDetailList); //cập nhật lại mã kiểm kho PhysicalInventory.Code = Erp.BackOffice.Helpers.Common.GetOrderNo("InventoryCheck"); PhysicalInventoryRepository.UpdatePhysicalInventory(PhysicalInventory); Erp.BackOffice.Helpers.Common.SetOrderNo("InventoryCheck"); TempData[Globals.SuccessMessageKey] = App_GlobalResources.Wording.InsertSuccess; if (model.Type == PhysicalInventoryType.Product) { return(RedirectToAction("Index")); } else { return(RedirectToAction("ListForCard")); } } var warehouseList = WarehouseRepository.GetAllWarehouse().Where(x => x.BranchId == Helpers.Common.CurrentUser.BranchId).AsEnumerable(); if (model.Type == PhysicalInventoryType.Card) { warehouseList = warehouseList.Where(x => x.Categories.Contains("CARD")); } else if (model.Type == PhysicalInventoryType.Gift) { warehouseList = warehouseList.Where(x => x.Categories.Contains("GIFT")); } var warehouseSelectList = warehouseList .Select(item => new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); ViewBag.warehouseList = warehouseSelectList; var manufacturer = categoryRepository.GetCategoryByCode("manufacturerList").AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Value }); ViewBag.manufacturer = manufacturer; return(View(model)); }
private void PhysicalInventories_OnUnloaded(object sender, RoutedEventArgs e) { PhysicalInventoryViewModel.CleanUp(); }
public ActionResult Create(PhysicalInventoryViewModel model) { if (ModelState.IsValid) { using (var scope = new TransactionScope(TransactionScopeOption.Required)) { try { PhysicalInventory PhysicalInventory = new Domain.Sale.Entities.PhysicalInventory(); AutoMapper.Mapper.Map(model, PhysicalInventory); PhysicalInventory.CreatedUserId = WebSecurity.CurrentUserId; PhysicalInventory.CreatedDate = DateTime.Now; PhysicalInventory.ModifiedUserId = WebSecurity.CurrentUserId; PhysicalInventory.ModifiedDate = DateTime.Now; PhysicalInventory.IsDeleted = false; PhysicalInventory.IsExchange = false; var warehouse = WarehouseRepository.GetWarehouseById(model.WarehouseId.Value); PhysicalInventory.BranchId = warehouse.BranchId; List <PhysicalInventoryDetail> PhysicalInventoryDetailList = new List <PhysicalInventoryDetail>(); if (model.DetailList != null) { var list_inventoryProduct = InventoryRepository.GetAllInventory(); foreach (var item in model.DetailList) { var inventoryProduct = list_inventoryProduct.Where(x => x.WarehouseId == PhysicalInventory.WarehouseId && x.ProductId == item.ProductId).ToList(); if (!string.IsNullOrEmpty(item.LoCode)) { inventoryProduct = inventoryProduct.Where(x => x.LoCode == item.LoCode).ToList(); } else { inventoryProduct = inventoryProduct.Where(x => x.LoCode == null).ToList(); } if (item.ExpiryDate == null) { inventoryProduct = inventoryProduct.Where(x => x.ExpiryDate == null).ToList(); } else { inventoryProduct = inventoryProduct.Where(x => x.ExpiryDate == item.ExpiryDate).ToList(); } int QuantityInInventory = 0; if (inventoryProduct.Count() > 0) { var ii = inventoryProduct.FirstOrDefault(); QuantityInInventory = ii.Quantity.Value; ii.Quantity = item.QuantityRemaining; InventoryRepository.UpdateInventory(ii); } PhysicalInventoryDetailList.Add(new PhysicalInventoryDetail { CreatedDate = DateTime.Now, CreatedUserId = WebSecurity.CurrentUserId, IsDeleted = false, Note = item.Note, ProductId = item.ProductId, QuantityInInventory = QuantityInInventory, QuantityRemaining = item.QuantityRemaining, QuantityDiff = item.QuantityRemaining - QuantityInInventory, LoCode = item.LoCode, ExpiryDate = item.ExpiryDate }); } } PhysicalInventoryRepository.InsertPhysicalInventory(PhysicalInventory, PhysicalInventoryDetailList); //cập nhật lại mã kiểm kho string prefix = Erp.BackOffice.Helpers.Common.GetSetting("prefixOrderNo_InventoryCheck"); PhysicalInventory.Code = Erp.BackOffice.Helpers.Common.GetCode(prefix, PhysicalInventory.Id); PhysicalInventoryRepository.UpdatePhysicalInventory(PhysicalInventory); scope.Complete(); } catch (DbUpdateException) { return(Content("Fail")); } } TempData[Globals.SuccessMessageKey] = App_GlobalResources.Wording.InsertSuccess; return(RedirectToAction("Index")); } var warehouseList = WarehouseRepository.GetAllWarehouse().AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Id.ToString() }); ViewBag.warehouseList = warehouseList; var manufacturer = categoryRepository.GetCategoryByCode("manufacturerList").AsEnumerable() .Select(item => new SelectListItem { Text = item.Name, Value = item.Value }); ViewBag.manufacturer = manufacturer; return(View(model)); }