public ReportViewModel <TrainerReportViewModel> GetTrainerReport(TrainerReportFilterModel model, int OrganizationId) { ObjectParameter totalRecords = new ObjectParameter("TotalRecords", typeof(int)); var list = base.RepositoryContext.SP_GetTrainerReport(model.PageNo, model.PageSize, model.SortColumn, model.SortOrder, model.TrainerId, OrganizationId, totalRecords).ToList(); ReportViewModel <TrainerReportViewModel> report = new ReportViewModel <TrainerReportViewModel>() { ReportModel = Mapper.Map <List <SP_GetTrainerReport_Result>, List <TrainerReportViewModel> >(list), TotalRecords = Convert.ToInt32(totalRecords.Value) }; return(report); }
public HttpResponseMessage DownloadTrainerReport([FromUri] TrainerReportFilterModel model) { var listReport = this._ITrainingRepository.GetTrainerReport(model, base.OrganizationId).ReportModel; HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK); var stream = new MemoryStream(new UTF8Encoding().GetBytes(listReport.BuildCsvString())); result.Content = new StreamContent(stream); result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); result.Content.Headers.ContentDisposition.FileName = "export.csv"; result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream"); result.Content.Headers.ContentLength = stream.Length; return(result); }
public ReportViewModel <TrainerReportViewModel> GetTrainerReport([FromUri] TrainerReportFilterModel model) { return(this._ITrainingRepository.GetTrainerReport(model, base.OrganizationId)); }