public ActionResult SaveForm(TransferOrderViewModel TransferOrderViewModel) { if (Session["strUserId"] == null) { return(RedirectToAction("Login", "Account")); } else { LoadSession(); TransferOrderViewModel.TransferOrderReceiveby = strUserId; if (TransferOrderViewModel.TransferOrderList != null) { TransferOrderViewModel.TransferOrderList.RemoveAll(x => !x.IsChecked); if (TransferOrderViewModel.TransferOrderList.Any()) { TransferOrderServices.Receivetransferorder(TransferOrderViewModel); TempData["message"] = "Successfully Received Order"; ModelState.Clear(); } } TransferOrderViewModel.TransferOrderList = TransferOrderServices.LoadOrderPendingInformation(strStoreId); return(View("TransferOrderReceive", TransferOrderViewModel)); } }
public TransferOrders() : base() { InitializeComponent(); this.toolstripChild = this.toolStripChildForm; this.fastListIndex = this.fastTransferOrderIndex; this.transferOrderAPIs = new TransferOrderAPIs(CommonNinject.Kernel.Get <ITransferOrderAPIRepository>()); this.transferOrderViewModel = CommonNinject.Kernel.Get <TransferOrderViewModel>(); this.transferOrderViewModel.PropertyChanged += new PropertyChangedEventHandler(ModelDTO_PropertyChanged); this.baseDTO = this.transferOrderViewModel; }
public JsonResult GetInventoryItemInformation(TransferOrderViewModel TransferOrderViewModel) { if (Session["strUserId"] == null) { return(Json(new { redirectUrl = Url.Action("Login", "Account"), isRedirect = true })); } else { var data = TransferOrderServices.GetInventoryItemInformation(TransferOrderViewModel); return(Json(data, JsonRequestBehavior.AllowGet)); } }
public void Canceltransferorder(TransferOrderViewModel TransferOrderViewModel) { for (int i = 0; i < TransferOrderViewModel.TransferOrderList.Count; i++) { var id = TransferOrderViewModel.TransferOrderList[i].TransferOrderId; var result = unitOfWork.TransferOrderRepository.Get().SingleOrDefault(b => b.TransferOrderId == id); if (result != null) { result.OrderRecieve = "Canceled"; result.TransferOrderReceiveby = TransferOrderViewModel.TransferOrderReceiveby; result.TransferOrderReceiveDate = DateTime.Now.Date; unitOfWork.Save(); } } }
public ActionResult Search(TransferOrderViewModel transferOrderViewModel) { if (Session["strUserId"] == null) { return(RedirectToAction("Login", "Account")); } else { LoadSession(); transferOrderViewModel.FromStoreId = Convert.ToInt32(strStoreId); TransferOrderViewModel TransferOrderViewModel = new TransferOrderViewModel(); TransferOrderViewModel.TransferOrderList = new List <TransferOrderViewModel>(); TransferOrderViewModel.TransferOrderList = TransferOrderServices.GetSearchInformation(transferOrderViewModel); ModelState.Clear(); LoadAll(strStoreId); return(View(TransferOrderViewModel)); } }
public ActionResult TransferOrderReceive() { if (Session["strUserId"] == null) { return(RedirectToAction("Login", "Account")); } else { LoadSession(); ViewBag.Pending = TransferOrderServices.LoadOrderPending(strStoreId); TransferOrderViewModel TransferOrderViewModel = new TransferOrderViewModel(); TransferOrderViewModel.TransferOrderList = new List <TransferOrderViewModel>(); TransferOrderViewModel.TransferOrderList = TransferOrderServices.LoadOrderPendingInformation(strStoreId); return(View(TransferOrderViewModel)); } }
public ActionResult Search() { if (Session["strUserId"] == null) { return(RedirectToAction("Login", "Account")); } else { LoadSession(); LoadAll(strStoreId); ViewBag.Orderlist = TransferOrderServices.CountOrderInformattion(strStoreId); ViewBag.Receivelist = TransferOrderServices.CountOrderReceiveInformattion(strStoreId); ViewBag.Pendinglist = TransferOrderServices.CountOrderPendingInformattion(strStoreId); ViewBag.Cancellist = TransferOrderServices.CountOrderCancelInformattion(strStoreId); //ViewBag.Orderlist = TransferOrderServices.CountOrderInformattion(strStoreId); TransferOrderViewModel TransferOrderViewModel = new TransferOrderViewModel(); TransferOrderViewModel.TransferOrderList = new List <TransferOrderViewModel>(); TransferOrderViewModel.TransferOrderList = TransferOrderServices.LoadOrderInformation(strStoreId); return(View(TransferOrderViewModel)); } }
public void BuildSelectLists(TransferOrderViewModel transferOrderViewModel) { transferOrderViewModel.ApproverDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), transferOrderViewModel.UserID); transferOrderViewModel.PreparedPersonDropDown = aspNetUserSelectListBuilder.BuildSelectListItemsForAspNetUsers(aspNetUserRepository.GetAllAspNetUsers(), transferOrderViewModel.UserID); }
public WizardMaster(TransferOrderViewModel transferOrderViewModel) { InitializeComponent(); this.transferOrderViewModel = transferOrderViewModel; }
public List <TransferOrderViewModel> GetSearchInformation(TransferOrderViewModel transferOrderViewModel) { var S = (from s in unitOfWork.StoreRepository.Get() select new { SID = s.StoreId, Name = s.StoreName }).Union( (from s in unitOfWork.SubStoreRepository.Get() select new { SID = s.SubStoreId, Name = s.SubStoreName, })).Union( (from s in unitOfWork.SubSubStoreRepository.Get() select new { SID = s.SubSubStoreId, Name = s.SubSubStoreName, })).Union( (from s in unitOfWork.SubSubSubStoreRepository.Get() select new { SID = s.SubSubSubStoreId, Name = s.SubSubSubStoreName, })).Union( (from s in unitOfWork.SubSubSubSubStoreRepository.Get() select new { SID = s.SubSubSubSubStoreId, Name = s.SubSubSubSubStoreName, })); var r = (from s in unitOfWork.TransferOrderRepository.Get() join store in S on s.FromStoreId equals store.SID join tstore in S on s.ToStoreId equals tstore.SID join item in unitOfWork.ItemRepository.Get() on s.ItemId equals item.ItemId join unit in unitOfWork.UnitRepository.Get() on s.UnitId equals unit.UnitId join c in unitOfWork.ConditionOfItemRepository.Get() on s.ConditionOfItemId equals c.ConditionOfItemId where s.FromStoreId == transferOrderViewModel.FromStoreId select new TransferOrderViewModel { TransferOrderId = s.TransferOrderId, FromStoreId = s.FromStoreId, FromStoreName = store.Name, ToStoreId = s.ToStoreId, ToStoreName = tstore.Name, ItemId = s.ItemId, ItemName = item.ItemName, TransactionQuantity = s.TransactionQuantity, UnitId = s.UnitId, UnitName = unit.UnitName, TransferTypeId = s.TransferTypeId, TransferTypeName = s.TransferType.TransferTypeName, TransferOrderdate = s.TransferOrderdate, TransferOrderDeliverydate = s.TransferOrderDeliverydate, ConditionOfItemId = s.ConditionOfItemId, ConditionOfItemName = c.ConditionOfItemName, OrderRecieve = s.OrderRecieve }); if (transferOrderViewModel.ToStoreId > 0) { r = r.Where(p => p.ToStoreId == transferOrderViewModel.ToStoreId); } if (transferOrderViewModel.ItemId > 0) { r = r.Where(p => p.ItemId == transferOrderViewModel.ItemId); } if (transferOrderViewModel.ConditionOfItemId > 0) { r = r.Where(p => p.ConditionOfItemId == transferOrderViewModel.ConditionOfItemId); } if (transferOrderViewModel.TransferTypeId > 0) { r = r.Where(p => p.TransferTypeId == transferOrderViewModel.TransferTypeId); } //if (transferOrderViewModel.FromDate!=null && transferOrderViewModel.ToDate!= null) // r =r.Where(p =>Convert.ToDateTime( p.TransferOrderdate) >= Convert.ToDateTime(transferOrderViewModel.FromDate) && Convert.ToDateTime(p.TransferOrderdate) <= Convert.ToDateTime(transferOrderViewModel.ToDate)); //if (transferOrderViewModel.FromDate!=null && transferOrderViewModel.ToDate != null) // r =r.Where(p => DateTime.ParseExact(p.TransferOrderdate, "MM/dd/yyyy", CultureInfo.InvariantCulture) >= transferOrderViewModel.FromDate && DateTime.ParseExact(p.TransferOrderdate, "MM/dd/yyyy", CultureInfo.InvariantCulture) <= transferOrderViewModel.ToDate); //if (transferOrderViewModel.FromDate!=null) // r = r.Where(p => Convert.ToDateTime(p.TransferOrderdate) <= transferOrderViewModel.ToDate); if (transferOrderViewModel.TransferCriteria == "Received") { r = r.Where(p => p.OrderRecieve == "Received"); } if (transferOrderViewModel.TransferCriteria == "Pending") { r = r.Where(p => p.OrderRecieve == "Pending"); } if (transferOrderViewModel.TransferCriteria == "Canceled") { r = r.Where(p => p.OrderRecieve == "Canceled"); } if (transferOrderViewModel.FromDate != null && transferOrderViewModel.ToDate != null) { r = r.Where(p => p.TransferOrderdate >= transferOrderViewModel.FromDate && p.TransferOrderdate <= transferOrderViewModel.ToDate); } var data = r.ToList(); return(data); }
public int GetInventoryItemInformation(TransferOrderViewModel TransferOrderViewModel) { int count = (from x in unitOfWork.StoreRepository.Get() where x.StoreId == TransferOrderViewModel.ToStoreId select x.StoreId).Count(); if (count == 1) { // Calculating the total Available quantity for Transfer Store var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get() join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == TransferOrderViewModel.ToStoreId && IM.SubStoreId == null && IM.SubSubStoreId == null && IM.SubSubSubStoreId == null && IM.SubSubSubSubStoreId == null select(int?) ID.AvailableQty).Sum() ?? 0; return(TotalAvailable); } int count2 = (from x in unitOfWork.SubStoreRepository.Get() where x.SubStoreId == TransferOrderViewModel.ToStoreId select x.SubStoreId).Count(); if (count2 == 1) { var storeid = unitOfWork.SubStoreRepository.Get().Where(a => a.SubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single(); // Calculating the total Available quantity for Transfer Store var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get() join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == TransferOrderViewModel.ToStoreId && IM.SubSubStoreId == null && IM.SubSubSubStoreId == null && IM.SubSubSubSubStoreId == null select(int?) ID.AvailableQty).Sum() ?? 0; return(TotalAvailable); } int count3 = (from x in unitOfWork.SubSubStoreRepository.Get() where x.SubSubStoreId == TransferOrderViewModel.ToStoreId select x.SubSubStoreId).Count(); if (count3 == 1) { var storeid = unitOfWork.SubSubStoreRepository.Get().Where(a => a.SubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single(); var substoreid = unitOfWork.SubSubStoreRepository.Get().Where(a => a.SubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single(); // Calculating the total Available quantity for Transfer Store var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get() join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == substoreid && IM.SubSubStoreId == TransferOrderViewModel.ToStoreId && IM.SubSubSubStoreId == null && IM.SubSubSubSubStoreId == null select(int?) ID.AvailableQty).Sum() ?? 0; return(TotalAvailable); } int count4 = (from x in unitOfWork.SubSubSubStoreRepository.Get() where x.SubSubSubStoreId == TransferOrderViewModel.ToStoreId select x.SubSubSubStoreId).Count(); if (count4 == 1) { var storeid = unitOfWork.SubSubSubStoreRepository.Get().Where(a => a.SubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single(); var substoreid = unitOfWork.SubSubSubStoreRepository.Get().Where(a => a.SubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single(); var subsubstoreid = unitOfWork.SubSubSubStoreRepository.Get().Where(a => a.SubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single(); // Calculating the total Available quantity for Transfer Store var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get() join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == substoreid && IM.SubSubStoreId == subsubstoreid && IM.SubSubSubStoreId == TransferOrderViewModel.ToStoreId && IM.SubSubSubSubStoreId == null select(int?) ID.AvailableQty).Sum() ?? 0; return(TotalAvailable); } int count5 = (from x in unitOfWork.SubSubSubSubStoreRepository.Get() where x.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId select x.SubSubSubSubStoreId).Count(); if (count5 == 1) { var storeid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.StoreId).Single(); var substoreid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single(); var subsubstoreid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single(); var subsubsubstoreid = unitOfWork.SubSubSubSubStoreRepository.Get().Where(a => a.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId).Select(a => a.SubStoreId).Single(); // Calculating the total Available quantity for Transfer Store var TotalAvailable = (from IM in unitOfWork.InventoryMasterRepository.Get() join ID in unitOfWork.InventoryDetailRepository.Get() on IM.Inv_HD_ID equals ID.Inv_HD_ID where ID.ItemId == TransferOrderViewModel.ItemId && IM.StoreId == storeid && IM.SubStoreId == substoreid && IM.SubSubStoreId == subsubstoreid && IM.SubSubSubStoreId == subsubsubstoreid && IM.SubSubSubSubStoreId == TransferOrderViewModel.ToStoreId select(int?) ID.AvailableQty).Sum() ?? 0; return(TotalAvailable); } return(0); }