public ActionResult LoadDevices(DeviceFilterViewModel obj)
{
var devicesList = new List <Device>();
devicesList = _db.Device.ToList();
if (obj == null)
{
return(View(devicesList));
}
else
{
if (obj.CreatedStartDate != null)
{
devicesList = devicesList.Where(x => x.CreatedDate >= obj.CreatedStartDate).ToList();
}
else if (obj.CreatedEndDate != null)
{
devicesList = devicesList.Where(x => x.CreatedDate <= obj.CreatedStartDate).ToList();
}
else if (obj.DatePurchase != null)
{
devicesList = devicesList.Where(x => x.DatePurchase >= obj.DatePurchase).ToList();
}
else if (obj.BrandId != null)
{
devicesList = devicesList.Where(x => x.Devices_BrandId == obj.BrandId).ToList();
}
else if (obj.VendorId != null)
{
devicesList = devicesList.Where(x => x.VendorId == obj.VendorId).ToList();
}
else if (obj.ModelId != null)
{
devicesList = devicesList.Where(x => x.Device_BrandModelId == obj.ModelId).ToList();
}
else if (obj.SerialNumber != null)
{
devicesList = devicesList.Where(x => x.SerialNumber.ToLower() == obj.SerialNumber || x.SerialNumber.StartsWith(obj.SerialNumber) || x.SerialNumber.Contains(obj.SerialNumber)).ToList();
}
else if (obj.RpmServiceId != null)
{
devicesList = devicesList.Where(x => x.RPMServiceId == obj.RpmServiceId).ToList();
}
else if (obj.DeviceCurrentStatus != null)
{
devicesList = devicesList.Where(x => x.DeviceStatusId == obj.DeviceCurrentStatus).ToList();
}
}
return(View(devicesList));
}
public ActionResult Filters()
{
ViewBag.IsAvtiveStatus = Enum.GetValues(typeof(IsActiveStatus)).Cast <IsActiveStatus>().Select(y => new SelectListItem {
Text = y.ToString(), Value = ((int)y).ToString()
}).ToList();
ViewBag.DeviceStatus = Enum.GetValues(typeof(DeviceStatus)).Cast <DeviceStatus>().Select(y => new SelectListItem {
Text = y.ToString(), Value = ((int)y).ToString()
}).ToList();
ViewBag.ModelNumber = _db.Device_BrandModels.Select(x => new SelectListItem {
Text = x.Name, Value = x.Id.ToString()
}).ToList();
ViewBag.Vendors = _db.Device_Vendors.Select(x => new SelectListItem {
Text = x.Name, Value = x.Id.ToString()
}).ToList();
ViewBag.Device_brands = _db.Devices_Brands.Select(x => new SelectListItem {
Value = x.Id.ToString(), Text = x.Name
}).ToList();
DeviceFilterViewModel model = new DeviceFilterViewModel();
return(View(model));
}
