Beispiel #1
0
        public ActionResult Save(RightOfAccesViewModel rightOfAccesViewModel)
        {
            if (Session["strUserId"] == null)
            {
                return(RedirectToAction("Login", "Account"));
            }
            else
            {
                LoadSession();
                LoadAll(strStoreId);

                if (rightOfAccesViewModel.rightOfAccesViewModelslist != null)
                {
                    rightOfAccesViewModel.rightOfAccesViewModelslist.RemoveAll(x => !x.IsChecked);
                    if (rightOfAccesViewModel.rightOfAccesViewModelslist.Any())
                    {
                        rightOfAccesViewModel.CreateBy = strUserName;
                        RightOfAccessService.Save(rightOfAccesViewModel);
                        ModelState.Clear();
                        TempData["message"] = "Successfully Received Order";
                    }
                }

                else
                {
                    TempData["message"] = "Empty Data";
                }


                return(RedirectToAction("Index", rightOfAccesViewModel));
            }
        }
Beispiel #2
0
 // GET: RightOfAccess
 public ActionResult Index()
 {
     if (Session["strUserId"] == null)
     {
         return(RedirectToAction("Login", "Account"));
     }
     else
     {
         LoadSession();
         LoadAll(strStoreId);
         RightOfAccesViewModel rightOfAccesViewModel = new RightOfAccesViewModel();
         rightOfAccesViewModel.rightOfAccesViewModelslist = new List <RightOfAccesViewModel>();
         rightOfAccesViewModel.rightOfAccesViewModelslist = RightOfAccessService.LoadRequest(rightOfAccesViewModel);
         return(View(rightOfAccesViewModel));
     }
 }
Beispiel #3
0
        public ActionResult Search(RightOfAccesViewModel rightOfAccesViewModel)
        {
            if (Session["strUserId"] == null)
            {
                return(RedirectToAction("Login", "Account"));
            }
            else
            {
                LoadSession();

                rightOfAccesViewModel.rightOfAccesViewModelslist = new List <RightOfAccesViewModel>();
                rightOfAccesViewModel.rightOfAccesViewModelslist = RightOfAccessService.GetSearchInfo(rightOfAccesViewModel);
                LoadAll(strStoreId);
                return(View("Index", rightOfAccesViewModel));
            }
        }
Beispiel #4
0
        public void Save(RightOfAccesViewModel rightOfAccesViewModel)
        {
            for (int i = 0; i < rightOfAccesViewModel.rightOfAccesViewModelslist.Count; i++)
            {
                var tempId        = rightOfAccesViewModel.rightOfAccesViewModelslist[i].TempId;
                var tmId          = rightOfAccesViewModel.rightOfAccesViewModelslist[i].TransferId;
                var tdId          = rightOfAccesViewModel.rightOfAccesViewModelslist[i].TransferDetailsId;
                var toId          = rightOfAccesViewModel.rightOfAccesViewModelslist[i].TransferOrderId;
                var RightOfAccess = new RightOfAcces
                {
                    TransferId        = rightOfAccesViewModel.rightOfAccesViewModelslist[i].TransferId,
                    TransferDetailsId = rightOfAccesViewModel.rightOfAccesViewModelslist[i].TransferDetailsId,
                    TransferOrderId   = rightOfAccesViewModel.rightOfAccesViewModelslist[i].TransferOrderId,
                    FromStoreId       = rightOfAccesViewModel.rightOfAccesViewModelslist[i].FromStoreId,
                    ToStoreId         = rightOfAccesViewModel.rightOfAccesViewModelslist[i].ToStoreId,
                    ItemId            = rightOfAccesViewModel.rightOfAccesViewModelslist[i].ItemId,
                    ProductId         = rightOfAccesViewModel.rightOfAccesViewModelslist[i].ProductId,
                    ItemQuantity      = rightOfAccesViewModel.rightOfAccesViewModelslist[i].ItemQuantity,
                    UnitId            = rightOfAccesViewModel.rightOfAccesViewModelslist[i].UnitId,
                    PO_Price          = rightOfAccesViewModel.rightOfAccesViewModelslist[i].PO_Price,
                    Remarks           = rightOfAccesViewModel.rightOfAccesViewModelslist[i].Remarks,
                    CreateBy          = rightOfAccesViewModel.CreateBy,
                    CreateDate        = DateTime.Now.Date,
                };

                var result = unitOfWork.TemporaryTransferInformationRepository.Get().SingleOrDefault(b => b.Id == tmId);
                if (result != null)
                {
                    result.PendingItemQuantity = result.PendingItemQuantity - rightOfAccesViewModel.rightOfAccesViewModelslist[i].PendingItemQuantity;
                }

                var result2 = unitOfWork.TransferDetailsRepository.Get().SingleOrDefault(b => b.TransferId == tmId && b.TransferDetailId == tdId);
                if (result2 != null)
                {
                    result2.PendingItemQuantity = result2.PendingItemQuantity - rightOfAccesViewModel.rightOfAccesViewModelslist[i].PendingItemQuantity;
                }
                unitOfWork.RightOfAccesRepository.Insert(RightOfAccess);
                unitOfWork.Save();
            }
        }
Beispiel #5
0
        public List <RightOfAccesViewModel> LoadRequest(RightOfAccesViewModel rightOfAccesViewModel)
        {
            var SN = (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 requestlist = (from p in unitOfWork.TemporaryTransferInformationRepository.Get()
                               join td in unitOfWork.TransferDetailsRepository.Get() on p.TransferDetailId equals td.TransferDetailId
                               join fstore in SN on p.FromStoreId equals fstore.SID
                               join tstore in SN on p.ToStoreId equals tstore.SID
                               join i in unitOfWork.ItemRepository.Get() on p.ItemId equals i.ItemId
                               join u in unitOfWork.UnitRepository.Get() on i.UnitId equals u.UnitId
                               where p.PendingItemQuantity > 0
                               select new RightOfAccesViewModel
            {
                TempId = p.Id,
                Inv_HD_ID = p.Inv_HD_ID,
                TransferId = p.TransferId,
                TransferDetailsId = p.TransferDetailId,
                TransferOrderId = td.TransferOrderId,
                FromStoreId = p.FromStoreId,
                FromStoreName = fstore.Name,
                ToStoreId = p.ToStoreId,
                ToStoreName = tstore.Name,
                PO_Price = p.PO_Price,
                ItemId = p.ItemId,
                ItemName = i.ItemName,
                ItemQuantity = p.TransactionQty,
                UnitId = p.UnitId,
                UnitName = u.UnitName,
                ProductId = p.ProductId,
                ReceiveItemQuantity = p.ReceiveItemQuantity,
                PendingItemQuantity = p.PendingItemQuantity
            }).ToList();


            return(requestlist);
        }
Beispiel #6
0
        public List <RightOfAccesViewModel> GetSearchInfo(RightOfAccesViewModel rightOfAccesViewModel)
        {
            var SN = (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 p in unitOfWork.TemporaryTransferInformationRepository.Get()
                     join fstore in SN on p.FromStoreId equals fstore.SID
                     join tstore in SN on p.ToStoreId equals tstore.SID
                     join i in unitOfWork.ItemRepository.Get() on p.ItemId equals i.ItemId
                     join u in unitOfWork.UnitRepository.Get() on i.UnitId equals u.UnitId
                     where p.PendingItemQuantity != null && p.ItemId == rightOfAccesViewModel.ItemId
                     select new RightOfAccesViewModel
            {
                TempId = p.Id,
                Inv_HD_ID = p.Inv_HD_ID,
                TransferId = p.TransferId,
                TransferDetailsId = p.TransferDetailId,
                FromStoreId = p.FromStoreId,
                FromStoreName = fstore.Name,
                ToStoreId = p.ToStoreId,
                ToStoreName = tstore.Name,
                PO_Price = p.PO_Price,
                ItemId = p.ItemId,
                ItemName = i.ItemName,
                ItemQuantity = p.TransactionQty,
                UnitId = p.UnitId,
                UnitName = u.UnitName,
                ProductId = p.ProductId,
                ReceiveItemQuantity = p.ReceiveItemQuantity,
                PendingItemQuantity = p.PendingItemQuantity
            });


            if (rightOfAccesViewModel.StoreId >= 1000 && rightOfAccesViewModel.StoreId <= 1999)
            {
                r = r.Where(p => p.ToStoreId == rightOfAccesViewModel.StoreId);
            }

            if (rightOfAccesViewModel.StoreId >= 2000 && rightOfAccesViewModel.StoreId <= 2999)
            {
                r = r.Where(p => p.ToStoreId == rightOfAccesViewModel.StoreId);
            }

            if (rightOfAccesViewModel.StoreId >= 3000 && rightOfAccesViewModel.StoreId <= 3999)
            {
                r = r.Where(p => p.ToStoreId == rightOfAccesViewModel.StoreId);
            }

            if (rightOfAccesViewModel.StoreId >= 4000 && rightOfAccesViewModel.StoreId <= 4999)
            {
                r = r.Where(p => p.ToStoreId == rightOfAccesViewModel.StoreId);
            }

            if (rightOfAccesViewModel.StoreId >= 5000 && rightOfAccesViewModel.StoreId <= 5999)
            {
                r = r.Where(p => p.ToStoreId == rightOfAccesViewModel.StoreId);
            }

            var rightaccesslist = r.ToList();

            return(rightaccesslist);
        }