public ActionResult CurrentStock() { ViewBag.ItemId = new SelectList(_dbContext.Items, "Id", "Name"); ViewBag.CategoryId = new SelectList(_dbContext.ItemCategoryies, "Id", "CategoryName"); ViewBag.StoreId = new SelectList(_dbContext.Store, "Id", "Name"); List <StockBookViewModel> stockBookViewModelList = new List <ViewModel.StockBookViewModel>(); var issueItems = _dbContext.IssueItems.ToList(); var storeItems = _dbContext.StoreItems.OrderBy(x => x.ItemAddedDate); // var viewModel = Mapper.Map<IEnumerable<StockBookViewModel>>(storeItems); foreach (var storeItem in storeItems) { StockBookViewModel stockBookViewModelNew = new StockBookViewModel(); stockBookViewModelNew.ItemAddedDate = storeItem.ItemAddedDate; stockBookViewModelNew.Name = storeItem.Name; stockBookViewModelNew.Quantity = storeItem.Quantity; stockBookViewModelNew.UnitPrice = storeItem.UnitPrice; stockBookViewModelNew.ExtendedPrice = storeItem.ExtendedPrice; stockBookViewModelNew.BalanceQuantity = storeItem.Quantity; stockBookViewModelNew.Type = storeItem.Type; stockBookViewModelList.Add(stockBookViewModelNew); var issue = issueItems.Where(x => x.StoreItemsId == storeItem.Id); if (issue.Count() == 0) { //StockBookViewModel stockBookViewModel = new StockBookViewModel(); //stockBookViewModel.ItemAddedDate = storeItem.ItemAddedDate; //stockBookViewModel.Name = storeItem.Name; //stockBookViewModel.Quantity = storeItem.Quantity; //stockBookViewModel.UnitPrice = storeItem.UnitPrice; //stockBookViewModel.ExtendedPrice = storeItem.ExtendedPrice; //stockBookViewModelList.Add(stockBookViewModel); } else { foreach (var issueItem in issue) { StockBookViewModel stockBookViewModel = new StockBookViewModel(); stockBookViewModel.ItemAddedDate = issueItem.IssueDate; stockBookViewModel.Name = storeItem.Name; stockBookViewModel.IssuedQuantity = issueItem.IssuedQuantity; stockBookViewModel.BalanceQuantity = issueItem.RemainingItem; stockBookViewModel.Type = issueItem.IssueType; stockBookViewModelList.Add(stockBookViewModel); } } } return(View(stockBookViewModelList)); }
public ActionResult DisplaySearchResults(Guid?StoreId, int?CategoryId, Guid?ItemId, DateTime?todate, DateTime?fromdate) { List <StockBookViewModel> stockBookViewModelList = new List <ViewModel.StockBookViewModel>(); if (StoreId != null) { if (CategoryId != null) { var items = _dbContext.Items.Where(x => x.ItemCategoryId == CategoryId); var viewModel = Mapper.Map <IEnumerable <ItemViewModel> >(items); var issueItems = _dbContext.IssueItems.ToList(); if (todate != null && fromdate != null) { foreach (var item in viewModel) { var storeItems = _dbContext.StoreItems.Where(s => s.Code == item.Code && s.StoreId == StoreId); var toFromList = storeItems.Where(d1 => d1.ItemAddedDate >= todate && d1.ItemAddedDate <= fromdate); if (storeItems.Count() != 0) { foreach (var storeItem in toFromList) { StockBookViewModel stockBookViewModelNew = new StockBookViewModel(); stockBookViewModelNew.ItemAddedDate = storeItem.ItemAddedDate; stockBookViewModelNew.Name = storeItem.Name; stockBookViewModelNew.Quantity = storeItem.Quantity; stockBookViewModelNew.UnitPrice = storeItem.UnitPrice; stockBookViewModelNew.ExtendedPrice = storeItem.ExtendedPrice; stockBookViewModelNew.BalanceQuantity = storeItem.Quantity; stockBookViewModelNew.Type = storeItem.Type; stockBookViewModelList.Add(stockBookViewModelNew); var issue = issueItems.Where(x => x.StoreItemsId == storeItem.Id); if (issue.Count() == 0) { //StockBookViewModel stockBookViewModel = new StockBookViewModel(); //stockBookViewModel.ItemAddedDate = storeItem.ItemAddedDate; //stockBookViewModel.Name = storeItem.Name; //stockBookViewModel.Quantity = storeItem.Quantity; //stockBookViewModel.UnitPrice = storeItem.UnitPrice; //stockBookViewModel.ExtendedPrice = storeItem.ExtendedPrice; //stockBookViewModelList.Add(stockBookViewModel); } else { foreach (var issueItem in issue) { StockBookViewModel stockBookViewModel = new StockBookViewModel(); stockBookViewModel.ItemAddedDate = issueItem.IssueDate; stockBookViewModel.Name = storeItem.Name; stockBookViewModel.IssuedQuantity = issueItem.IssuedQuantity; stockBookViewModel.BalanceQuantity = issueItem.RemainingItem; stockBookViewModel.Type = issueItem.IssueType; stockBookViewModelList.Add(stockBookViewModel); } } } } } } else { foreach (var item in viewModel) { var storeItems = _dbContext.StoreItems.Where(s => s.Code == item.Code && s.StoreId == StoreId); if (storeItems.Count() != 0) { foreach (var storeItem in storeItems) { StockBookViewModel stockBookViewModelNew = new StockBookViewModel(); stockBookViewModelNew.ItemAddedDate = storeItem.ItemAddedDate; stockBookViewModelNew.Name = storeItem.Name; stockBookViewModelNew.Quantity = storeItem.Quantity; stockBookViewModelNew.UnitPrice = storeItem.UnitPrice; stockBookViewModelNew.ExtendedPrice = storeItem.ExtendedPrice; stockBookViewModelNew.BalanceQuantity = storeItem.Quantity; stockBookViewModelNew.Type = storeItem.Type; stockBookViewModelList.Add(stockBookViewModelNew); var issue = issueItems.Where(x => x.StoreItemsId == storeItem.Id); if (issue.Count() == 0) { //StockBookViewModel stockBookViewModel = new StockBookViewModel(); //stockBookViewModel.ItemAddedDate = storeItem.ItemAddedDate; //stockBookViewModel.Name = storeItem.Name; //stockBookViewModel.Quantity = storeItem.Quantity; //stockBookViewModel.UnitPrice = storeItem.UnitPrice; //stockBookViewModel.ExtendedPrice = storeItem.ExtendedPrice; //stockBookViewModelList.Add(stockBookViewModel); } else { foreach (var issueItem in issue) { StockBookViewModel stockBookViewModel = new StockBookViewModel(); stockBookViewModel.ItemAddedDate = issueItem.IssueDate; stockBookViewModel.Name = storeItem.Name; stockBookViewModel.IssuedQuantity = issueItem.IssuedQuantity; stockBookViewModel.BalanceQuantity = issueItem.RemainingItem; stockBookViewModel.Type = issueItem.IssueType; stockBookViewModelList.Add(stockBookViewModel); } } } } } } } else { var issueItems = _dbContext.IssueItems.ToList(); var storeItems = _dbContext.StoreItems.Where(s => s.StoreId == StoreId); if (todate != null && fromdate != null) { var toFromList = storeItems.Where(d1 => d1.ItemAddedDate >= todate && d1.ItemAddedDate <= fromdate); foreach (var storeItem in toFromList) { StockBookViewModel stockBookViewModelNew = new StockBookViewModel(); stockBookViewModelNew.ItemAddedDate = storeItem.ItemAddedDate; stockBookViewModelNew.Name = storeItem.Name; stockBookViewModelNew.Quantity = storeItem.Quantity; stockBookViewModelNew.UnitPrice = storeItem.UnitPrice; stockBookViewModelNew.ExtendedPrice = storeItem.ExtendedPrice; stockBookViewModelNew.BalanceQuantity = storeItem.Quantity; stockBookViewModelNew.Type = storeItem.Type; stockBookViewModelList.Add(stockBookViewModelNew); var issue = issueItems.Where(x => x.StoreItemsId == storeItem.Id); if (issue.Count() == 0) { //StockBookViewModel stockBookViewModel = new StockBookViewModel(); //stockBookViewModel.ItemAddedDate = storeItem.ItemAddedDate; //stockBookViewModel.Name = storeItem.Name; //stockBookViewModel.Quantity = storeItem.Quantity; //stockBookViewModel.UnitPrice = storeItem.UnitPrice; //stockBookViewModel.ExtendedPrice = storeItem.ExtendedPrice; //stockBookViewModelList.Add(stockBookViewModel); } else { foreach (var issueItem in issue) { StockBookViewModel stockBookViewModel = new StockBookViewModel(); stockBookViewModel.ItemAddedDate = issueItem.IssueDate; stockBookViewModel.Name = storeItem.Name; stockBookViewModel.IssuedQuantity = issueItem.IssuedQuantity; stockBookViewModel.BalanceQuantity = issueItem.RemainingItem; stockBookViewModel.Type = issueItem.IssueType; stockBookViewModelList.Add(stockBookViewModel); } } } } else { foreach (var storeItem in storeItems) { StockBookViewModel stockBookViewModelNew = new StockBookViewModel(); stockBookViewModelNew.ItemAddedDate = storeItem.ItemAddedDate; stockBookViewModelNew.Name = storeItem.Name; stockBookViewModelNew.Quantity = storeItem.Quantity; stockBookViewModelNew.UnitPrice = storeItem.UnitPrice; stockBookViewModelNew.ExtendedPrice = storeItem.ExtendedPrice; stockBookViewModelNew.BalanceQuantity = storeItem.Quantity; stockBookViewModelNew.Type = storeItem.Type; stockBookViewModelList.Add(stockBookViewModelNew); var issue = issueItems.Where(x => x.StoreItemsId == storeItem.Id); if (issue.Count() == 0) { //StockBookViewModel stockBookViewModel = new StockBookViewModel(); //stockBookViewModel.ItemAddedDate = storeItem.ItemAddedDate; //stockBookViewModel.Name = storeItem.Name; //stockBookViewModel.Quantity = storeItem.Quantity; //stockBookViewModel.UnitPrice = storeItem.UnitPrice; //stockBookViewModel.ExtendedPrice = storeItem.ExtendedPrice; //stockBookViewModelList.Add(stockBookViewModel); } else { foreach (var issueItem in issue) { StockBookViewModel stockBookViewModel = new StockBookViewModel(); stockBookViewModel.ItemAddedDate = issueItem.IssueDate; stockBookViewModel.Name = storeItem.Name; stockBookViewModel.IssuedQuantity = issueItem.IssuedQuantity; stockBookViewModel.BalanceQuantity = issueItem.RemainingItem; stockBookViewModel.Type = issueItem.IssueType; stockBookViewModelList.Add(stockBookViewModel); } } } } // var viewModel = Mapper.Map<IEnumerable<StockBookViewModel>>(storeItems); } } return(PartialView("_CurrentStock", stockBookViewModelList)); }