public IActionResult GetReportExcelByTrainingCourseAll([FromBody] TrainingFilterViewModel trainingFilter) { try { var worker = new Worker() { TemplateFolder = this.appEnvironment.WebRootPath + "\\reports\\", }; var hasData = this.repositoryReport .GetReportByTrainingCourse(trainingFilter); var creDataTable = new MyDataTable(); var dataTable = creDataTable.CreateMyDataTable <TrainingMasterReportViewModel>(hasData.Item1); Dictionary <string, string> dic = new Dictionary <string, string>() { { "TrainingCourse", hasData.Item2.TrainingCousreCode }, { "TrainingCourseName", hasData.Item2.TrainingCousreName } }; var stream = worker.Export(dataTable, dic, "TrainingMasterReport"); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Reports.xlsx")); } catch (Exception ex) { return(NotFound(new { Error = "Training Master report not found " + ex.ToString() })); } }
public IActionResult GetReportByTrainingProgramWithPosition(int id) { try { var worker = new Worker() { TemplateFolder = this.appEnvironment.WebRootPath + "\\reports\\", }; var hasData = this.repositoryReport.GetReportByTrainingProgram(id); var creDataTable = new MyDataTable(); var dataTable = creDataTable.CreateMyDataTable <TrainingProgram2ReportViewModel>(hasData.Item1); Dictionary <string, string> dic = new Dictionary <string, string>() { { "Detail", hasData.Item2 }, }; var stream = worker.Export(dataTable, dic, "TrainingProgramReport"); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Reports.xlsx")); } catch (Exception ex) { return(NotFound(new { Error = "Training Program report not found " + ex.ToString() })); } }
public IActionResult GetTrainingCostFromHistoryExcel([FromBody] TrainingFilterViewModel TrainingFilter) { string ErrorMessage = ""; try { if (TrainingFilter != null) { if (TrainingFilter.AfterDate.HasValue && TrainingFilter.EndDate.HasValue) { var HasData = this.repositoryReport.GetTrainingCostFromHistory(TrainingFilter); if (HasData != null) { var worker = new Worker() { TemplateFolder = this.appEnvironment.WebRootPath + "\\reports\\", }; var creDataTable = new MyDataTable(); var dataTable = creDataTable.CreateMyDataTable <TrainingCostViewModel>(HasData); var StartDate = HelperClass.ConverterDate(TrainingFilter.AfterDate.Value.AddHours(7)); var EndDate = HelperClass.ConverterDate(TrainingFilter.EndDate.Value.AddHours(7)); Dictionary <string, string> dic = new Dictionary <string, string>() { { "StartDate", "Çѹ·Õè " + StartDate + " " }, { "EndDate", " ¶Ö§Çѹ·Õè " + EndDate }, }; var stream = worker.Export(dataTable, dic, "TrainingCostReport"); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Reports.xlsx")); } } } } catch (Exception ex) { ErrorMessage = ex.ToString(); } return(NotFound(new { Error = "Employee history not found" + ErrorMessage })); }
public IActionResult GetReportByEmployeeCodeExcel(string EmployeeCode) { string ErrorMessage = ""; try { if (!string.IsNullOrEmpty(EmployeeCode)) { var HasData = this.repositoryReport.GetEmployeeHistoryTraining(EmployeeCode); if (HasData != null) { var worker = new Worker() { TemplateFolder = this.appEnvironment.WebRootPath + "\\reports\\", }; var creDataTable = new MyDataTable(); var dataTable = creDataTable.CreateMyDataTable <CourseHistory>(HasData.HistoryCourses); Dictionary <string, string> dic = new Dictionary <string, string>() { { "EmpCode", HasData.EmpCode }, { "EmpName", HasData.EmpName }, { "Position", HasData.Position }, { "Section", HasData.Section }, { "StartDate", HasData.StartDate }, }; var stream = worker.Export(dataTable, dic, "TrainingEmployeeReport"); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Reports.xlsx")); } } } catch (Exception ex) { ErrorMessage = ex.ToString(); } return(NotFound(new { Error = "Employee history not found" + ErrorMessage })); }