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));
}
