public ActionResult Add() { string name = HttpContext.User.Identity.Name; List <SalePoint> salePointList = new List <SalePoint>(); salePointList = AgroExpressDBAccess.GetSalePointListForUSer(name); SalePointProductAdd salePointProductTransfer = new SalePointProductAdd(); salePointProductTransfer.salepointlist = salePointList.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); List <ProductTransferInfo> PTI = new List <ProductTransferInfo>(); var MilkInfo = AgroExpressDBAccess.IsProductExist("Milk"); if (MilkInfo != null) { PTI.Add(new ProductTransferInfo { ProductId = MilkInfo.PKProductId, Amount = null }); } else { Product MilkInfoAdd = new Product { ProductName = "Milk", SellingUnit = "Ltr", Stock = 0 }; AgroExpressDBAccess.AddProduct(MilkInfoAdd); MilkInfo = AgroExpressDBAccess.IsProductExist("Milk"); PTI.Add(new ProductTransferInfo { ProductId = MilkInfo.PKProductId, Amount = null }); } // Product dropdown list var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); ProductInf = ProductInf.Where(a => a.ProductName.ToLower() != "milk").ToList(); salePointProductTransfer.product = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); // int len = ProductInf.Count; for (int i = 0; i < len; i++) { PTI.Add(new ProductTransferInfo { ProductId = null, Amount = null }); } salePointProductTransfer.TransferedProductInfo = PTI; salePointProductTransfer.Date = System.DateTime.Now.Date; return(View(salePointProductTransfer)); }
public ActionResult Index([Bind(Exclude = "ProductSearchResult")] ProductListView SerchCriteria) { var ProductList = AgroExpressDBAccess.GetAllEnabledProduct(); ProductListView ProductListV = new ProductListView(); ProductListV.ProductList = ProductList.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName, Selected = x.PKProductId == SerchCriteria.SelectedProductID ? true : false }); var SearchResult = AgroExpressDBAccess.SearchProduct(SerchCriteria.SelectedProductID, SerchCriteria.MinimumStock, SerchCriteria.MaximumStock); if (SearchResult != null) { ProductListV.ProductSearchResult = SearchResult; } else { ProductListV.ProductSearchResult = new List <Product>(); } ProductListV.MaximumStock = SerchCriteria.MaximumStock; ProductListV.MinimumStock = SerchCriteria.MinimumStock; ModelState.Clear(); return(View(ProductListV)); }
public ActionResult TransferList() { SalePointProductAddList request = new SalePointProductAddList(); List <SalePoint> SalePointList = new List <SalePoint>(); SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint(); request.salepointlist = SalePointList.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); request.product = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); request.EntryDateMax = System.DateTime.Now; request.EntryDateMin = request.EntryDateMax.AddMonths(-1); request.SearchResult = AgroExpressDBAccess.GetSellPointProductAdd(request.EntryDateMin, request.EntryDateMax).OrderBy(a => a.Date).ToList(); return(View(request)); }
public ActionResult Add() { AddOrderListView newentry = new AddOrderListView(); List <Product> prlist = AgroExpressDBAccess.GetAllEnabledProduct(); var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); List <AddOrder> orders = new List <AddOrder>(); int len = ProductInf.Count; for (int i = 0; i < len; i++) { orders.Add(new AddOrder { productlist = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }), OrderPlacingDateTime = DateTime.Now.Date, Amount = 0 }); } newentry.orderlist = orders; return(View(newentry)); }
public ActionResult SingleOrderAdd(AddOrder newentry) { List <Product> prlist = AgroExpressDBAccess.GetAllEnabledProduct(); if (prlist != null) { newentry.productlist = prlist.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); } if (ModelState.IsValid) { if (AgroExpressDBAccess.AddSingleOrder(newentry)) { ModelState.Clear(); ViewBag.success = "Order has been placed Successfully"; } else { ViewBag.success = "Sorry, Your order is not placed, Please try again"; } } newentry.OrderPlacingDateTime = newentry.OrderPlacingDateTime; return(View(newentry)); }
public ActionResult Factory() { FactoryProduction productionInfo = new FactoryProduction(); var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); ProductInf = ProductInf.Where(a => a.ProductName.ToLower() != "milk").ToList(); int len = ProductInf.Count; List <ProductionInfo> NewProduction = new List <ProductionInfo>(); for (int i = 0; i < len; i++) { NewProduction.Add(new ProductionInfo { productlist = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }), Date = System.DateTime.Now, Amount = 0 }); } productionInfo.productionlist = NewProduction; productionInfo.ConsumptionDate = System.DateTime.Now.Date; return(View(productionInfo)); }
public ActionResult FactoryList(FactoryProductionList request) { List <Production> ProductionInfo = AgroExpressDBAccess.ProductionInfoByDate(request.EntryDateMin, request.EntryDateMax); if (request.ProductID != null) { ProductionInfo = ProductionInfo.Where(a => a.ProductId == request.ProductID).ToList(); } if (request.AmountMax != null) { ProductionInfo = ProductionInfo.Where(a => a.Amount <= request.AmountMax).ToList(); } if (request.AmountMin != null) { ProductionInfo = ProductionInfo.Where(a => a.Amount >= request.AmountMin).ToList(); } var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); ProductInf = ProductInf.Where(a => a.ProductName.ToLower() != "milk").ToList(); request.ProductList = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); request.SearchResult = ProductionInfo; return(View(request)); }
public ActionResult Stock() { SalePointProductStockList request = new SalePointProductStockList(); List <SalePoint> SalePointList = new List <SalePoint>(); SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint(); request.salepointlist = SalePointList.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); request.product = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); List <SalePointProductStock> productStock = new List <SalePointProductStock>(); productStock = AgroExpressDBAccess.GetSalePointProductStock(); request.SearchResult = productStock.OrderBy(o => o.SalePointId).ToList(); return(View(request)); }
public ActionResult Add(AddOrderListView newentry) { List <Order> neworder = new List <Order>(); for (int i = 0; i < newentry.orderlist.Count; i++) { if (newentry.orderlist[i].PKProductId != 0 && newentry.orderlist[i].Amount != 0 && newentry.orderlist[i].OrderPlacingDateTime != null) { neworder.Add(new Order { CustomerId = 1, ProductId = newentry.orderlist[i].PKProductId, OrderPlacingDateTime = newentry.orderlist[i].OrderPlacingDateTime, OrderDateTime = System.DateTime.Now.Date, Amount = newentry.orderlist[i].Amount }); } } if (AgroExpressDBAccess.AddOrder(neworder)) { ViewBag.success("Order Successful"); } else { ViewBag.success("Sorry, Your order is not placed, Please try again"); } List <Product> prlist = AgroExpressDBAccess.GetAllEnabledProduct(); var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); List <AddOrder> orders = new List <AddOrder>(); int len = ProductInf.Count; for (int i = 0; i < len; i++) { orders.Add(new AddOrder { productlist = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }), OrderPlacingDateTime = System.DateTime.Now.Date, Amount = 0 }); } newentry.orderlist = orders; return(View(newentry)); }
//[AcceptVerbs(HttpVerbs.Post)] public ActionResult Factory(FactoryProduction productionInfo) { List <Production> ProductionList = new List <Production>(); string name = HttpContext.User.Identity.Name; string operatorName = AgroExpressDBAccess.GetFullNamebyUserID(name); foreach (var production in productionInfo.productionlist) { if (production.PKProductId != null && production.Amount != null) { ProductionList.Add(new Production { ProductId = (int)production.PKProductId, Amount = (double)production.Amount, Date = production.Date, OperatorName = operatorName }); } } if (productionInfo.ConsumptionDate != null && productionInfo.MilkConsumption != null) { AgroExpressDBAccess.AddFactoryMilkConsumption((DateTime)productionInfo.ConsumptionDate, (double)productionInfo.MilkConsumption); } string message = AgroExpressDBAccess.AddPoductionList(ProductionList); if (message == "yes") { return(RedirectToAction(nameof(Factory))); } else { var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); int len = ProductInf.Count; List <ProductionInfo> NewProduction = new List <ProductionInfo>(); for (int i = 0; i < len; i++) { NewProduction.Add(new ProductionInfo { productlist = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }), Date = System.DateTime.Now, Amount = 0 }); } productionInfo.productionlist = NewProduction; ViewBag.message = message; } return(View(productionInfo)); }
public ActionResult SingleOrderAdd() { AddOrder newentry = new AddOrder(); List <Product> prlist = AgroExpressDBAccess.GetAllEnabledProduct(); if (prlist != null) { newentry.productlist = prlist.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); } newentry.OrderPlacingDateTime = System.DateTime.Now.Date; return(View(newentry)); }
public ActionResult FactoryList() { FactoryProductionList Production = new FactoryProductionList(); Production.EntryDateMax = System.DateTime.Now; Production.EntryDateMin = System.DateTime.Now.AddDays(-30); List <Production> ProductionInfo = AgroExpressDBAccess.ProductionInfoByDate(Production.EntryDateMin, Production.EntryDateMax); Production.SearchResult = ProductionInfo; var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); ProductInf = ProductInf.Where(a => a.ProductName.ToLower() != "milk").ToList(); Production.ProductList = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); return(View(Production)); }
public ActionResult TransferList(SalePointProductAddList request) { List <SalePoint> SalePointList = new List <SalePoint>(); SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint(); request.salepointlist = SalePointList.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); request.product = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); if (ModelState.IsValid) { var result = AgroExpressDBAccess.GetSellPointProductAdd(request.EntryDateMin, request.EntryDateMax).OrderBy(a => a.Date).ToList(); if (request.ProductId != null) { result = result.Where(a => a.ProductId == request.ProductId).ToList(); } if (request.SalePointId != null) { result = result.Where(a => a.SalePointId == request.SalePointId).ToList(); } if (request.StockAmountMin != null) { result = result.Where(a => a.Amount >= request.StockAmountMin).ToList(); } if (request.StockAmountMAx != null) { result = result.Where(a => a.Amount <= request.StockAmountMAx).ToList(); } request.SearchResult = result.OrderBy(a => a.salepoint.SalePointName).ToList(); } return(View(request)); }
public ActionResult Stock(SalePointProductStockList request) { List <SalePoint> SalePointList = new List <SalePoint>(); SalePointList = AgroExpressDBAccess.GetallEnabledSalePoint(); request.salepointlist = SalePointList.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); request.product = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); List <SalePointProductStock> productStock = new List <SalePointProductStock>(); productStock = AgroExpressDBAccess.GetSalePointProductStock(); if (request.SalePointId != null) { productStock = productStock.Where(a => a.SalePointId == request.SalePointId).ToList(); } if (request.ProductId != null) { productStock = productStock.Where(a => a.ProductId == request.ProductId).ToList(); } if (request.StockAmountMin != null) { productStock = productStock.Where(a => a.ProductStock >= request.StockAmountMin).ToList(); } if (request.StockAmountMAx != null) { productStock = productStock.Where(a => a.ProductStock <= request.StockAmountMAx).ToList(); } request.SearchResult = productStock.OrderBy(o => o.SalePointId).ToList(); return(View(request)); }
public ActionResult Index() { var ProductList = AgroExpressDBAccess.GetAllEnabledProduct(); ProductListView ProductListV = new ProductListView(); ProductListV.ProductList = ProductList.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); if (ProductList != null) { ProductListV.ProductSearchResult = ProductList; } else { ProductListV.ProductSearchResult = new List <Product>(); } return(View(ProductListV)); }
private ProductSaleAdd ProductSaleInitial() { string name = HttpContext.User.Identity.Name; ProductSaleAdd ProductSale = new ProductSaleAdd(); ProductSale.SaleDate = System.DateTime.UtcNow.AddHours(6); List <SalePoint> salePointList = new List <SalePoint>(); salePointList = AgroExpressDBAccess.GetSalePointListForUSer(name); if (salePointList != null) { ProductSale.salepointlist = salePointList.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); } List <Area> arealist = AgroExpressDBAccess.GetallEnabledArea(); if (arealist != null) { arealist = arealist.Where(a => salePointList.Any(b => b.PKSalePointID == a.SalePointId)).ToList(); ProductSale.Area = arealist.Select(x => new SelectListItem { Value = x.PKAreaId.ToString(), Text = x.AreaName }); } List <SubArea> sarealist = AgroExpressDBAccess.GetallEnabledSubArea(); if (sarealist != null) { sarealist = sarealist.Where(a => arealist.Any(b => b.PKAreaId == a.AreaId)).ToList(); ProductSale.SubArea = sarealist.Select(x => new SelectListItem { Value = x.PKSubAreaId.ToString(), Text = x.SubAreaName }); } List <Product> productList = AgroExpressDBAccess.GetAllEnabledProduct(); List <ProductSaleInfo> PSI = new List <ProductSaleInfo>(); var MilkInfo = AgroExpressDBAccess.IsProductExist("Milk"); if (MilkInfo != null) { PSI.Add(new ProductSaleInfo { ProductId = MilkInfo.PKProductId, Amount = null, Rate = null, Servicecharge = null }); } else { Product MilkInfoAdd = new Product { ProductName = "Milk", SellingUnit = "Ltr", Stock = 0 }; AgroExpressDBAccess.AddProduct(MilkInfoAdd); MilkInfo = AgroExpressDBAccess.IsProductExist("Milk"); PSI.Add(new ProductSaleInfo { ProductId = MilkInfo.PKProductId, Amount = null, Rate = null, Servicecharge = null }); } // Product dropdown list productList = productList.Where(a => a.ProductName.ToLower() != "milk").ToList(); ProductSale.product = productList.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); // int len = productList.Count; for (int i = 0; i < len; i++) { PSI.Add(new ProductSaleInfo { ProductId = null, Amount = null, Rate = null, Servicecharge = 0 }); } ProductSale.ProductSaleInfo = PSI; List <Customer> customer = AgroExpressDBAccess.GetallEnabledCustomer(); customer = customer.Where(a => sarealist.Any(b => b.PKSubAreaId == a.SubAreaId)).ToList(); ProductSale.Customer = customer.Select(x => new SelectListItem { Value = x.PKCustomerId.ToString(), Text = x.FullName }); return(ProductSale); }
public ActionResult SingleSale(SingleSaleAdd single) { List <SalePoint> salepointlist = AgroExpressDBAccess.GetallEnabledSalePoint(); if (salepointlist != null) { single.salepointlist = salepointlist.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); } List <Area> arealist = AgroExpressDBAccess.GetallEnabledArea(); if (arealist != null) { single.arealist = arealist.Select(x => new SelectListItem { Value = x.PKAreaId.ToString(), Text = x.AreaName }); } List <SubArea> sarealist = AgroExpressDBAccess.GetallEnabledSubArea(); if (sarealist != null) { single.subarealist = sarealist.Select(x => new SelectListItem { Value = x.PKSubAreaId.ToString(), Text = x.SubAreaName }); } List <Customer> culist = AgroExpressDBAccess.GetallEnabledCustomer(); if (culist != null) { single.customerlist = culist.Select(x => new SelectListItem { Value = x.PKCustomerId.ToString(), Text = x.FullName }); } List <Product> prlist = AgroExpressDBAccess.GetAllEnabledProduct(); if (prlist != null) { single.productlist = prlist.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); } if (ModelState.IsValid) { } return(View(single)); }
public ActionResult Add(SalePointProductAdd Request) { if (ModelState.IsValid) { string name = HttpContext.User.Identity.Name; string operatorName = AgroExpressDBAccess.GetFullNamebyUserID(name); List <ProductTransferInfo> PTI = Request.TransferedProductInfo; int len = PTI.Count; List <SalePointProductConsume> newProduct = new List <SalePointProductConsume>(); for (int i = 0; i < len; i++) { if (PTI[i].ProductId != null && (PTI[i].Amount != null)) { newProduct.Add(new SalePointProductConsume { SalePointId = Request.SalePointId, Date = Request.Date, ProductId = (int)PTI[i].ProductId, Amount = (int)PTI[i].Amount, OperatorName = operatorName }); } } ViewBag.message = AgroExpressDBAccess.AddSalePointProduct(newProduct); if (ViewBag.message == "yes") { return(RedirectToAction(nameof(Index))); } } foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { string errorme = error.ToString(); } } List <SalePoint> salePointList = new List <SalePoint>(); salePointList = AgroExpressDBAccess.GetSalePointListForUSer(HttpContext.User.Identity.Name); SalePointProductAdd salePointProductTransfer = new SalePointProductAdd(); salePointProductTransfer.salepointlist = salePointList.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); List <ProductTransferInfo> PTI1 = new List <ProductTransferInfo>(); var MilkInfo = AgroExpressDBAccess.IsProductExist("Milk"); if (MilkInfo != null) { PTI1.Add(new ProductTransferInfo { ProductId = MilkInfo.PKProductId, Amount = null }); } else { Product MilkInfoAdd = new Product { ProductName = "Milk", SellingUnit = "Ltr", Stock = 0 }; AgroExpressDBAccess.AddProduct(MilkInfoAdd); MilkInfo = AgroExpressDBAccess.IsProductExist("Milk"); PTI1.Add(new ProductTransferInfo { ProductId = MilkInfo.PKProductId, Amount = 0 }); } // Product dropdown list var ProductInf = AgroExpressDBAccess.GetAllEnabledProduct(); ProductInf = ProductInf.Where(a => a.ProductName.ToLower() != "milk").ToList(); salePointProductTransfer.product = ProductInf.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); // int len1 = ProductInf.Count; for (int i = 0; i < len1; i++) { PTI1.Add(new ProductTransferInfo { ProductId = null, Amount = null }); } salePointProductTransfer.TransferedProductInfo = PTI1; return(View(salePointProductTransfer)); }
public ActionResult SaleHistory() { SaleListView listview = new SaleListView(); List <SalePoint> salepointlist = AgroExpressDBAccess.GetallEnabledSalePoint(); if (salepointlist != null) { listview.salepointlist = salepointlist.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); } List <Area> arealist = AgroExpressDBAccess.GetallEnabledArea(); if (arealist != null) { listview.arealist = arealist.Select(x => new SelectListItem { Value = x.PKAreaId.ToString(), Text = x.AreaName }); } List <SubArea> sarealist = AgroExpressDBAccess.GetallEnabledSubArea(); if (sarealist != null) { listview.subarealist = sarealist.Select(x => new SelectListItem { Value = x.PKSubAreaId.ToString(), Text = x.SubAreaName }); } var customerlist = AgroExpressDBAccess.GetallEnabledCustomer(); if (customerlist != null) { listview.selectedcustomerlist = customerlist.Select(x => new SelectListItem { Value = x.PKCustomerId.ToString(), Text = x.FullName }); } var productList = AgroExpressDBAccess.GetAllEnabledProduct(); if (productList != null) { listview.selectedproductlist = productList.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); } listview.EntryDateMax = System.DateTime.Now.Date.AddDays(1); listview.EntryDateMin = listview.EntryDateMax.AddDays(-30); var saleifo = AgroExpressDBAccess.GetSaleInfoByDate(listview.EntryDateMin, listview.EntryDateMax); List <SaleList> sale = new List <SaleList>(); if (saleifo != null) { foreach (var li in saleifo) { sale.Add(new SaleList { DateTime = li.DateTime, CustomerName = li.customer.FullName, ProductName = li.product.ProductName, Amount = li.Amount, Total = (li.Amount * li.Rate) + (li.Amount * li.ServiceCharge), SMSSent = li.SMSSent, OperatorName = li.OperatorName }); } } listview.salelist = sale; return(View(listview)); }
public ActionResult SaleHistory(SaleListView listview) { List <SalePoint> salepointlist = AgroExpressDBAccess.GetallEnabledSalePoint(); if (salepointlist != null) { listview.salepointlist = salepointlist.Select(x => new SelectListItem { Value = x.PKSalePointID.ToString(), Text = x.SalePointName }); } List <Area> arealist = AgroExpressDBAccess.GetallEnabledArea(); if (arealist != null) { listview.arealist = arealist.Select(x => new SelectListItem { Value = x.PKAreaId.ToString(), Text = x.AreaName }); } List <SubArea> sarealist = AgroExpressDBAccess.GetallEnabledSubArea(); if (sarealist != null) { listview.subarealist = sarealist.Select(x => new SelectListItem { Value = x.PKSubAreaId.ToString(), Text = x.SubAreaName }); } var customerlist = AgroExpressDBAccess.GetallEnabledCustomer(); if (customerlist != null) { listview.selectedcustomerlist = customerlist.Select(x => new SelectListItem { Value = x.PKCustomerId.ToString(), Text = x.FullName }); } var productList = AgroExpressDBAccess.GetAllEnabledProduct(); if (productList != null) { listview.selectedproductlist = productList.Select(x => new SelectListItem { Value = x.PKProductId.ToString(), Text = x.ProductName }); } var saleifo = AgroExpressDBAccess.GetSaleInfoByDate(listview.EntryDateMin, listview.EntryDateMax.AddDays(1)); if (listview.AmountVMax != null) { saleifo = saleifo.Where(a => a.Amount <= listview.AmountVMax).ToList(); } if (listview.AmountVMin != null) { saleifo = saleifo.Where(a => a.Amount >= listview.AmountVMin).ToList(); } if (listview.CustomerID != null) { saleifo = saleifo.Where(a => a.CustomerId == listview.CustomerID).ToList(); } if (listview.SelectedProductID != null) { saleifo = saleifo.Where(a => a.ProductId == listview.SelectedProductID).ToList(); } List <Area> AreList = new List <Area>(); List <SubArea> subAreList = AgroExpressDBAccess.GetallEnabledSubArea(); if (listview.SalePointId != null) { AreList = AgroExpressDBAccess.GetAreaBySalePointID((int)listview.SalePointId); if (AreList != null) { subAreList = subAreList .Where(x => AreList.Any(y => y.PKAreaId == x.AreaId)).ToList(); } customerlist = customerlist.Where(customer => subAreList.Any(subarea => subarea.PKSubAreaId == customer.SubAreaId)).ToList(); saleifo = saleifo.Where(salei => customerlist.Any(customer => customer.PKCustomerId == salei.CustomerId)).ToList(); } if (listview.AreaId != null) { subAreList = subAreList.Where(su => su.AreaId == listview.AreaId).ToList(); customerlist = customerlist.Where(customer => subAreList.Any(subarea => subarea.PKSubAreaId == customer.SubAreaId)).ToList(); saleifo = saleifo.Where(salei => customerlist.Any(customer => customer.PKCustomerId == salei.CustomerId)).ToList(); } if (listview.SubAreaId != null) { customerlist = customerlist.Where(customer => customer.SubAreaId == listview.SubAreaId).ToList(); saleifo = saleifo.Where(salei => customerlist.Any(customer => customer.PKCustomerId == salei.CustomerId)).ToList(); } List <SaleList> sale = new List <SaleList>(); if (saleifo != null) { foreach (var li in saleifo) { sale.Add(new SaleList { DateTime = li.DateTime, CustomerName = li.customer.FullName, ProductName = li.product.ProductName, Amount = li.Amount, SMSSent = li.SMSSent, OperatorName = li.OperatorName }); } } listview.salelist = sale; return(View(listview)); }