public List <AssetManager.Models.FailureView> GetFailureCauseReport(FailureCauseFilterRequest request) { //var data = this.DB.Fetch<Data.Model.FailureView>(";EXEC FailureFilterCauseReport @@startDate = @0, @@endDate = @1, @@sectionId = @2, @@stationId = @3, @@userId = @4, @@gearfaultId = @5, @@reportedId = @6, @@subGearfaultId =@7, @@manufactureId = @8, @@causeId = @9, @@subCauseId = @10, @@forSections = @11, @@forStations = @12, @@forUsers = @13, @@forGearfaults = @14, @@forReports = @15, @@forSubGears = @16, @@forManufactures = @17, @@forCauses = @18, @@forSubCauses = @19, @@stationTypeId = @20, @@forStationTypes = @21", request.FromDate.Date, request.ToDate.Date, request.SectionFilter, request.StationFilter, request.UserFilter, request.GearAtFaultFilter, request.ReportedFilter, request.SubGearAtFaultFilter, request.ManufactureFilter, request.CauseFilter, request.SubCauseFilter, 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.Causes.ToFilterCSV().ToString(), request.SubCauses.ToFilterCSV().ToString(), 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(null); }
public dynamic PostCauseAll(FailureCauseFilterRequest failureFilterRequest) { return(new { data = this.ReportService.GetFailureCauses(failureFilterRequest) }); }
public HttpResponseMessage PostExportFailureCauses(FailureCauseFilterRequest request) { request.FileName = "SFRReport"; request.SheetHeader = "SFRReport"; return(this.ExportFile <byte[]>(request, this.ReportService.GetFailureExportReport(this.ReportService.GetFailureCauseReport(request).GetSearchResults(request.SearchKey), "SFR Report"))); }
public List <AssetManager.Models.FailureView> GetFailureCauses(FailureCauseFilterRequest request) { //return this.DB.Fetch<Data.Model.FailureView>(";EXEC FailureFilterCauseReport @@startDate = @0, @@endDate = @1, @@sectionId = @2, @@stationId = @3, @@userId = @4, @@gearfaultId = @5, @@reportedId = @6, @@subGearfaultId =@7, @@manufactureId = @8, @@causeId = @9, @@subCauseId = @10, @@forSections = @11, @@forStations = @12, @@forUsers = @13, @@forGearfaults = @14, @@forReports = @15, @@forSubGears = @16, @@forManufactures = @17, @@forCauses = @18, @@forSubCauses = @19, @@stationTypeId = @20, @@forStationTypes = @21", request.FromDate.Date, request.ToDate.Date, request.SectionFilter, request.StationFilter, request.UserFilter, request.GearAtFaultFilter, request.ReportedFilter, request.SubGearAtFaultFilter, request.ManufactureFilter, request.CauseFilter, request.SubCauseFilter, 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.Causes.ToFilterCSV().ToString(), request.SubCauses.ToFilterCSV().ToString(), request.StationTypeFilter, request.StationTypes.ToFilterCSV().ToString()).MapCollectionTo<Data.Model.FailureView, AssetManager.Models.FailureView>().ToList(); return(null); }