public List <AssetManager.Models.FailureView> GetFailureReport(FailureFilterRequest request)
{
//var data = this.DB.Fetch<Data.Model.FailureView>(";EXEC FailureFilterReport @@startDate = @0, @@endDate = @1, @@sectionId = @2, @@stationId = @3, @@userId = @4, @@gearfaultId = @5, @@reportedId = @6, @@subGearfaultId =@7, @@manufactureId = @8, @@forSections = @9, @@forStations = @10, @@forUsers = @11, @@forGearfaults = @12, @@forReports = @13, @@forSubGears = @14, @@forManufactures = @15, @@punctualityId = @16, @@stationTypeId = @17, @@forStationTypes = @18", request.FromDate.Date, request.ToDate.Date, request.SectionFilter, request.StationFilter, request.UserFilter, request.GearAtFaultFilter, request.ReportedFilter, request.SubGearAtFaultFilter, request.ManufactureFilter, request.Sections.ToFilterCSV().ToString(), request.Stations.ToFilterCSV().ToString(), request.Users.ToFilterCSV().ToString(), request.Gears.ToFilterCSV().ToString(), request.Reporteds.ToFilterCSV().ToString(), request.SubGears.ToFilterCSV().ToString(), request.Manufatures.ToFilterCSV().ToString(), request.PunctualityFilter.HasValue ? request.PunctualityFilter : -1, request.StationTypeFilter, request.StationTypes.ToFilterCSV().ToString()).MapCollectionTo<Data.Model.FailureView, AssetManager.Models.FailureView>().ToList();
////var data = this.DB.Fetch<Data.Model.FailureView>(";EXEC FailureReport @@startDate = @0, @@endDate = @1, @@sectionId = @2, @@stationId = @3, @@userId = @4, @@gearfaultId = @5, @@reportedId = @6", request.FromDate.Date, request.ToDate.Date, request.SectionFilter, request.StationFilter, request.UserFilter, request.GearAtFaultFilter, request.ReportedFilter).MapCollectionTo<Data.Model.FailureView, AssetManager.Models.FailureView>().ToList();
//if (request.TimeOfOccurenceOrder != AssetManager.Models.SortOrder.None || request.TotalTimeOrder != AssetManager.Models.SortOrder.None)
//{
// if (request.TotalTimeOrder == AssetManager.Models.SortOrder.Asc)
// {
// return data.OrderBy(s => s.TotalDuration).ToList();
// }
// if (request.TotalTimeOrder == AssetManager.Models.SortOrder.Desc)
// {
// return data.OrderByDescending(s => s.TotalDuration).ToList();
// }
// if (request.TimeOfOccurenceOrder == AssetManager.Models.SortOrder.Asc)
// {
// return data.OrderBy(s => s.TimeOfOccurance).ToList();
// }
// if (request.TimeOfOccurenceOrder == AssetManager.Models.SortOrder.Desc)
// {
// return data.OrderByDescending(s => s.TimeOfOccurance).ToList();
// }
//}
//return data;
return(null);
}
public dynamic PostAll(FailureFilterRequest failureFilterRequest)
{
return(new { data = this.ReportService.GetFailures(failureFilterRequest) });
}
public HttpResponseMessage PostExportFailures(FailureFilterRequest request)
{
request.FileName = "SFRReport";
request.SheetHeader = "SFRReport";
return(this.ExportFile <byte[]>(request, this.ReportService.GetFailureExportReport(this.ReportService.GetFailureReport(request).GetSearchResults(request.SearchKey), "SFR Report")));
}
public List <AssetManager.Models.FailureView> GetFailures(FailureFilterRequest request)
{
//return this.DB.Fetch<Data.Model.FailureView>(";EXEC FailureFilterReport @@startDate = @0, @@endDate = @1, @@sectionId = @2, @@stationId = @3, @@userId = @4, @@gearfaultId = @5, @@reportedId = @6, @@subGearfaultId =@7, @@manufactureId = @8, @@forSections = @9, @@forStations = @10, @@forUsers = @11, @@forGearfaults = @12, @@forReports = @13, @@forSubGears = @14, @@forManufactures = @15, @@punctualityId = @16, @@stationTypeId = @17, @@forStationTypes = @18", request.FromDate.Date, request.ToDate.Date, request.SectionFilter, request.StationFilter, request.UserFilter, request.GearAtFaultFilter, request.ReportedFilter, request.SubGearAtFaultFilter, request.ManufactureFilter, request.Sections.ToFilterCSV().ToString(), request.Stations.ToFilterCSV().ToString(), request.Users.ToFilterCSV().ToString(), request.Gears.ToFilterCSV().ToString(), request.Reporteds.ToFilterCSV().ToString(), request.SubGears.ToFilterCSV().ToString(), request.Manufatures.ToFilterCSV().ToString(), request.PunctualityFilter.HasValue ? request.PunctualityFilter : -1, request.StationTypeFilter, request.StationTypes.ToFilterCSV().ToString()).MapCollectionTo<Data.Model.FailureView, AssetManager.Models.FailureView>().ToList();
return(null);
}
