public IList <StocksMapReport> SearchStocks(ReportStockInputDto searchInput) { string query = ""; if (searchInput.Query != null) { query = searchInput.Query.ToLower(); } _erpConnectionService.ConnectErp(_user, _password, ""); var stocksList = _erpConnectionService.GetAllStocksByCompanyReport(searchInput.CompanyName); _erpConnectionService.DisconnectErp(); //var stocksList = _stockRepository.GetAll(); stocksList = (IList <StocksMapReport>)stocksList.Where(a => a.NameAsset.ToLower().Contains(query.ToLower())); if (searchInput.CellarId != null) { stocksList = (IList <StocksMapReport>)stocksList.Where(a => a.CellarId == searchInput.CellarId.Value); } //stocksList = stocksList.Where(a => a.CompanyName.ToLower().Equals(searchInput.CompanyName.ToLower())); return(stocksList); }
public ActionResult Index() { ReportStockInputDto model = new ReportStockInputDto(); try { model.Query = ""; model.CompanyName = _currentUser.CompanyName; _erpConnectionService.ConnectErp(_user, _password, ""); model.StocksList = _erpConnectionService.GetAllStocksByCompanyReport(model.CompanyName); _erpConnectionService.DisconnectErp(); //model.Stocks = _reportStocksAppService.SearchStocks(model); model.Cellars = _reportStocksAppService.GetAllCellars(_currentUser.CompanyName); model.UserName = _currentUser.UserName; model.CurrentDateTime = _date.Now; model.Control = "ReportStocks"; model.Action = "Search"; model.ErrorCode = ErrorCodeHelper.Ok; model.ErrorDescription = ""; } catch (Exception e) { model.ErrorCode = ErrorCodeHelper.Error; model.ErrorDescription = "Error al buscar las Existencias"; } return(View(model)); }
public IEnumerable <Stock> SearchStocks(ReportStockInputDto searchInput) { string query = ""; if (searchInput.Query != null) { query = searchInput.Query.ToLower(); } var stocksList = _stockRepository.GetAll(); stocksList = stocksList.Where(a => a.IsDeleted == false && a.Asset.Name.ToLower().Contains(query.ToLower()) || a.Asset.Code.ToLower().Equals(query.ToLower()) || a.Asset.Code.ToLower().Contains(query) || a.Asset.Code.ToLower().Equals(query)); if (searchInput.CellarId != null) { stocksList = stocksList.Where(a => a.CellarId == searchInput.CellarId.Value); } stocksList = stocksList.Where(a => a.CompanyName.ToLower().Equals(searchInput.CompanyName.ToLower())); return(stocksList.Include(a => a.Asset).Include(a => a.Cellar).OrderBy(a => a.Asset.Name).Take(200).ToList()); }
public ViewResultBase Search(ReportStockInputDto model) { try { model.CompanyName = _currentUser.CompanyName; //var entities = SearchStocks(model); model.Cellars = _reportStocksAppService.GetAllCellars(_currentUser.CompanyName); model.UserName = _currentUser.UserName; model.CurrentDateTime = _date.Now; //model.StocksList = entities; model.ErrorCode = ErrorCodeHelper.Ok; model.ErrorDescription = ""; } catch (Exception e) { model.ErrorCode = ErrorCodeHelper.Error; model.ErrorDescription = "Error al buscar las Existencias"; } //if (Request.IsAjaxRequest()) //{ // return PartialView("_searchStockReportSearchPartial", model); //} return(View("Index", model)); }