public List <InventoryViewModel> Search(InventorySearchModel searchModel)
{
var products = _shopContext.Products.Select(x => new { x.Id, x.Name }).ToList();
var query = _inventoryContext.Inventory.Select(x => new InventoryViewModel
{
Id = x.Id,
UnitPrice = x.UnitPrice,
InStock = x.InStock,
ProductId = x.ProductId,
CurrentCount = x.CalculateCurrentCount(),
CreationDate = x.CreationDate.ToFarsi()
});
if (searchModel.ProductId > 0)
{
query = query.Where(x => x.ProductId == searchModel.ProductId);
}
if (searchModel.InStock)
{
query = query.Where(x => !x.InStock);
}
var inventory = query.OrderByDescending(x => x.Id).ToList();
inventory.ForEach(item =>
item.Product = products.FirstOrDefault(x => x.Id == item.ProductId)?.Name);
return(inventory);
}
public List <InventoryViewModel> Search(InventorySearchModel searchModel)
{
var products = _shopContext.Products.Select(p => new { Id = p.Id, Name = p.Name }).AsNoTracking().ToList();
var query = _db.Inventory.Select(i => new InventoryViewModel()
{
Id = i.Id,
ProductId = i.ProductId,
CurrentCount = i.CalculateCurrentCount(),
IsInStock = i.IsInStock,
UnitPrice = i.UnitPrice
});
if (searchModel.ProductId != 0)
{
query = query.Where(i => i.ProductId == searchModel.ProductId);
}
if (searchModel.IsNotInStock)
{
query = query.Where(i => i.IsInStock == false);
}
var result = query.AsNoTracking().ToList();
result.ForEach(i => i.Product = products.FirstOrDefault(p => p.Id == i.ProductId)?.Name);
return(result);
}
public void OnGet(InventorySearchModel searchModel)
{
var products = _productApplication.GetProducts();
Products = new SelectList(products, "Id", "Name");
Inventory = _inventoryApplication.Search(searchModel);
}
public List <InventoryViewModel> Search(InventorySearchModel searchModel)
{
var query = _context.Inventory.Select(c => new InventoryViewModel()
{
Id = c.Id,
CreationDate = c.CreationDate.ToFarsi(),
InStock = c.InStock,
CurrentCount = c.CalculateCurrentCount(),
ProductId = c.ProductId,
UnitPrice = c.UnitPrice
});
if (searchModel.ProductId > 0)
{
query = query.Where(c => c.ProductId == searchModel.ProductId);
}
if (searchModel.InStock)
{
query = query.Where(c => !c.InStock);
}
var Products = _shopcontext.Products.Select(c => new { c.Id, c.Name }).ToList();
var inventory = query.OrderByDescending(c => c.Id).ToList();
inventory.ForEach(
item => item.ProductName = Products.FirstOrDefault(c => c.Id == item.ProductId)?.Name);
return(inventory);
}
public List <InventoryViewModel> GetNameWiseSearchedInventories(InventorySearchModel model)
{
var sqlQuery = GetNameWiseSearchedInventoriesQuery(model.SearchKeyWord);
var searchedInventories = _db.Query <InventoryViewModel>(sqlQuery).ToList();
return(searchedInventories);
}
private IQueryable <ProductDto> GetDetail(InventorySearchModel searchModel)
{
IQueryable <ProductDto> list = null;
if (!searchModel.HasAnyValue())
{
list = _inventoryService.GetAll().OrderByDescending(i => i.ProductId);
}
else
{
var predicate = PredicateBuilder.True <ProductDto>();
if (!searchModel.CategoryId.IsNull())
{
predicate = predicate.And(c => c.CategoryId == searchModel.CategoryId);
}
if (!searchModel.ProductCode.IsNull())
{
predicate = predicate.And(c => c.ProductCode.Contains(searchModel.ProductCode));
}
if (!searchModel.ProductName.IsNull())
{
predicate = predicate.And(c => c.ProductName.Contains(searchModel.ProductName));
}
if (!searchModel.ProductDescription.IsNull())
{
predicate = predicate.And(c => c.ProductDescription.Contains(searchModel.ProductDescription));
}
if (!searchModel.ProductSize.IsNull())
{
predicate = predicate.And(c => c.ProductSize.Contains(searchModel.ProductSize));
}
if (!searchModel.CurrentNum.IsNull())
{
predicate = predicate.And(c => c.CurrentNum.Contains(searchModel.CurrentNum));
}
if (!searchModel.DRNum.IsNull())
{
predicate = predicate.And(c => c.DRNum.Contains(searchModel.DRNum));
}
if (!searchModel.CartonNum.IsNull())
{
predicate = predicate.And(c => c.CartonNum.Contains(searchModel.CartonNum));
}
list = _inventoryService.GetAll().AsExpandable().Where(predicate).OrderByDescending(i => i.ProductId);
}
return(list);
}
public IActionResult SearchInventory([FromBody] InventorySearchModel searchRequest)
{
try
{
var searchResults = _service.SearchInventory(searchRequest);
return(Ok(searchResults));
}
catch (Exception ex)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, "A problem happened while handling your request."));
}
}
public IHttpActionResult GetInventories(InventorySearchModel model)
{
try
{
var inventories = _inventoryService.GetInventories(model.CurrentDate);
return(Ok(new { data = inventories }));
}
catch (Exception ex)
{
_log.ErrorFormat("Error in get all inventories. Error : {0}", ex.Message);
_log.Error(ex);
throw;
}
}
public IHttpActionResult GetInventoryDetailByCode(long userId, long storeId, InventorySearchModel model)
{
try
{
var inventoryDetailByCode = _inventoryService.GetInventoryDetailByCode(storeId, model);
return(Ok(new { data = inventoryDetailByCode }));
}
catch (Exception ex)
{
_log.ErrorFormat("Error in getting inventory detail by code. Error : {0}", ex.Message);
_log.Error(ex);
throw;
}
}
public object GetInventoryDetailByCode(long storeId, InventorySearchModel model)
{
var inventoryModel = new InventoryViewModel();
var errorResponseModel = new ErrorResponseModel();
var webUrl = ConfigurationManager.AppSettings["WebUrl"] + "/";
if (string.IsNullOrEmpty(model.InventoryCode))
{
throw _exception.ThrowException(System.Net.HttpStatusCode.BadRequest, "", "QR kod kan inte vara tomt.");
}
var inventoryExist = _inventoryRepository.GetInventoryDetailByCode(model.InventoryCode);
if (inventoryExist == null)
{
errorResponseModel.Message = "Inventarielista saknas.";
return(errorResponseModel);
}
//throw _exception.ThrowException(System.Net.HttpStatusCode.OK, "", "Inventory does not exist.");
var isInventoryExistInStore = _inventoryRepository.IsInventoryExistInStore(inventoryExist.Id, storeId);
if (!isInventoryExistInStore)
{
throw _exception.ThrowException(System.Net.HttpStatusCode.BadRequest, "", "Det finns ingen inventarielista för denna butik.");
}
inventoryModel.Id = inventoryExist.Id;
inventoryModel.BrandName = inventoryExist.BrandName;
inventoryModel.Name = inventoryExist.Name;
inventoryModel.OutPriceIncVat = inventoryExist.OutPriceIncVat;
inventoryModel.REA = inventoryExist.REA;
inventoryModel.Specification = inventoryExist.Specification;
inventoryModel.CreatedBy = inventoryExist.CreatedBy;
inventoryModel.ImagePath = !string.IsNullOrEmpty(inventoryExist.ImagePath) ? inventoryExist.ImagePath.Replace("~/", webUrl) : null;
inventoryModel.InventoryCode = inventoryExist.InventoryCode;
inventoryModel.VolumeType = inventoryExist.VolumeType;
inventoryModel.Volume = inventoryExist.Volume;
inventoryModel.Supplier = inventoryExist.Supplier;
//TerminalId = x.TerminalId,
inventoryModel.ModifiedDate = inventoryExist.ModifiedDate;
return(inventoryModel);
}
public List <InventoryResponseModel> GetNameWiseSearchedInventories(InventorySearchModel model)
{
var inventoryViewModelList = new List <InventoryResponseModel>();
var searchedInventories = _inventoryRepository.GetNameWiseSearchedInventories(model);
var webUrl = ConfigurationManager.AppSettings["WebUrl"] + "/";
inventoryViewModelList = searchedInventories.ConvertAll(x => new InventoryResponseModel()
{
Id = x.Id,
BrandName = x.BrandName,
Name = x.Name,
Price = x.OutPriceIncVat,
REA = x.REA,
Description = x.Specification,
CreatedBy = x.CreatedBy,
ImagePath = !string.IsNullOrEmpty(x.ImagePath) ? x.ImagePath.Replace("~/", webUrl) : null,
InventoryCode = x.InventoryCode,
//TerminalId = x.TerminalId
});
return(inventoryViewModelList);
}
public IHttpActionResult GetNameWiseSearchedInventories(InventorySearchModel model)
{
try
{
if (model == null)
{
throw _exception.ThrowException(HttpStatusCode.BadRequest, "", "Ogiltig förfrågan.");
}
if (string.IsNullOrEmpty(model.SearchKeyWord))
{
throw _exception.ThrowException(HttpStatusCode.BadRequest, "", "Invalid keyword.");
}
var searchedInventories = _inventoryService.GetNameWiseSearchedInventories(model);
return(Ok(new { data = searchedInventories }));
}
catch (Exception ex)
{
_log.ErrorFormat("Error in getting searched wise inventories by name. Error : {0}", ex.Message);
_log.Error(ex);
throw;
}
}
public List <InventoryViewModel> Search(InventorySearchModel searchModel)
{
return(_inventoryRepository.Search(searchModel));
}
public List <InventorySearchResultsModel> SearchInventory(InventorySearchModel searchRequest) => _inventoryRepository.SearchInventory(searchRequest);
public virtual ActionResult GetDetails([DataSourceRequest] DataSourceRequest request, InventorySearchModel searchModel)
{
var list = GetDetail(searchModel);
return(Json(list.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
private void ResetSearch()
{
_searchModel = new InventorySearchModel();
}
