public JsonResult GetResultData(ResultsDataTableSent sent)
{
var model = _service.GetAssetsPaginated(sent);
return(Json(model));
}
public DataTableReturned GetAssetsPaginated(ResultsDataTableSent sent)
{
var searchResults = GetAssetDTOs(sent);
var count = GetNumOfAssets(searchResults);
var data = searchResults;
var model = new DataTableReturned(sent)
{
recordsTotal = count,
recordsFiltered = count,
data = data
};
return(model);
}
public IEnumerable <AssetDTO> GetAssetDTOs(ResultsDataTableSent sent)
{
if (string.IsNullOrEmpty(sent.KeywordSearch))
{
var result = from a in db.Asset
.Where(a => a.IsDisposed == false && (a.AssetKey.ToString().Contains(sent.AssetTag.ToString()) || a.InventoryOwner.Contains(sent.InventoryOwner)) && (a.ClientSiteKey.Equals(sent.ClientSiteKey) || a.LocationKey.Equals(sent.LocationKey)))
orderby a.AssetKey ascending
select new AssetDTO()
{
AssetTag = a.AssetKey,
Product = a.ProductKeyNavigation.ProductName,
Manufacturer = a.ManufacturerKeyNavigation.ManufacturerName,
Model = a.ModelKeyNavigation.ModelName,
SerialNumber = a.SerialNumber,
ItemName = a.ItemName,
Location = a.LocationKeyNavigation.LocationName,
ClientSite = a.ClientSiteKeyNavigation.ClientSiteName,
PurchaseDate = a.PurchaseDate,
InventoryOwner = a.InventoryOwner,
InventoriedBy = a.InventoriedBy,
isDisposed = a.IsDisposed
};
return(result);
}
else
{
var result = from a in db.Asset
.Where(a => a.IsDisposed == false &&
a.AssetKey.ToString().Contains(sent.KeywordSearch.ToString()) ||
a.InventoriedBy.Contains(sent.KeywordSearch) ||
a.InventoryDate.ToString().Contains(sent.KeywordSearch) ||
a.InventoryOwner.Contains(sent.KeywordSearch) ||
a.ItemName.Contains(sent.KeywordSearch) ||
a.LocationKeyNavigation.LocationName.Contains(sent.KeywordSearch) ||
a.ManufacturerKeyNavigation.ManufacturerName.Contains(sent.KeywordSearch) ||
a.ModelKeyNavigation.ModelName.Contains(sent.KeywordSearch) ||
a.ProductKeyNavigation.ProductName.Contains(sent.KeywordSearch) ||
a.PurchaseDate.ToString().Contains(sent.KeywordSearch) ||
a.SerialNumber.ToString().Contains(sent.KeywordSearch) ||
a.AssetKey.ToString().Contains(sent.AssetTag.ToString()) ||
a.ClientSiteKey.Equals(sent.ClientSiteKey) ||
a.LocationKey.Equals(sent.LocationKey))
orderby a.AssetKey ascending
select new AssetDTO()
{
AssetTag = a.AssetKey,
Product = a.ProductKeyNavigation.ProductName,
Manufacturer = a.ManufacturerKeyNavigation.ManufacturerName,
Model = a.ModelKeyNavigation.ModelName,
SerialNumber = a.SerialNumber,
ItemName = a.ItemName,
Location = a.LocationKeyNavigation.LocationName,
ClientSite = a.ClientSiteKeyNavigation.ClientSiteName,
PurchaseDate = a.PurchaseDate,
InventoryOwner = a.InventoryOwner,
InventoriedBy = a.InventoriedBy,
isDisposed = a.IsDisposed
};
return(result);
}
}
