// api/<controller>/FindInspections
public IHttpActionResult FindInspectionList(int pageNo = 1, int pageLength = 15, string searchQuery = null)
{
var inspectionList = new List<ClsInspection>();
var inspectionModel = new InspectionModel();
inspectionModel.PageNo = pageNo;
inspectionModel.PageLength = pageLength;
int startIndex = (pageNo - 1) * pageLength;
var inspections = new List<Inspection>();
if (!string.IsNullOrWhiteSpace(searchQuery))
{
inspectionModel.TotalRecords = db.Inspections.Count(x => x.Active == true && x.Deleted == false && x.Associate.Name.Contains(searchQuery));
inspections = db.Inspections.Where(x => x.Active && x.Deleted == false && x.Associate.Name.Contains(searchQuery)).OrderByDescending(inspection => inspection.Id)
.Skip(startIndex)
.Take(inspectionModel.PageLength).ToList();
}
else
{
inspectionModel.TotalRecords = db.Inspections.Count(x => x.Active == true && x.Deleted == false);
inspections = db.Inspections.Where(x => x.Active && x.Deleted == false).OrderByDescending(inspection => inspection.Id)
.Skip(startIndex)
.Take(inspectionModel.PageLength).ToList();
}
foreach (var inspection in inspections)
{
var objInspection = new ClsInspection();
objInspection.AssociateName = inspection.Associate.Name;
objInspection.AssociateEmail = inspection.Associate.Email;
objInspection.VehicleName = string.Format("{0} - {1} - {2}", inspection.Vehicle.Make, inspection.Vehicle.Model, inspection.Vehicle.Registration);
objInspection.VehicleId = inspection.VehicleId;
objInspection.AssociateId = inspection.AssociateId;
objInspection.Id = inspection.Id;
objInspection.InspectionDueDate = inspection.InspectionDueDate;
inspectionList.Add(objInspection);
}
inspectionModel.InspectionList = inspectionList;
return Ok(inspectionModel);
}
// api/<controller>/FindInspections
public IHttpActionResult FindInspections()
{
var inspections = db.Inspections.Where(x => x.Active == true && x.Deleted == false).ToList();
var inspectionList = new List<ClsInspection>();
foreach (var inspection in inspections)
{
var objInspection = new ClsInspection();
objInspection.AssociateName = inspection.Associate.Name;
objInspection.AssociateEmail = inspection.Associate.Email;
objInspection.VehicleName = string.Format("{0} - {1} - {2}", inspection.Vehicle.Make, inspection.Vehicle.Model, inspection.Vehicle.Registration);
objInspection.VehicleId = inspection.VehicleId;
objInspection.AssociateId = inspection.AssociateId;
objInspection.Id = inspection.Id;
objInspection.InspectionDueDate = inspection.InspectionDueDate;
inspectionList.Add(objInspection);
}
if (inspectionList.Count <= 0)
{
return NotFound();
}
return Ok(inspectionList);
}
