public IActionResult GetReportByTrainingProgramWithTrainingFilter([FromBody] TrainingFilterViewModel TrainingFilter) { string error = ""; try { if (TrainingFilter != null) { var hasData = this.repositoryReport.GetReportByTrainingProgramWithTrainingFilter(TrainingFilter); //(TrainingFilter.TrainingId, //string.IsNullOrEmpty(TrainingFilter.GroupCode) ? null : new List<string>() { TrainingFilter.GroupCode }, //string.IsNullOrEmpty(TrainingFilter.PositionCode) ? null : new List<string>() { TrainingFilter.PositionCode }, //TrainingFilter.LocateID); string imagePath = this.appEnvironment.WebRootPath + "\\images\\logoVIPCO.png"; if (hasData.Item1.Any()) { var stream = new ReportClasses.Report().CreateExcelDoc(hasData.Item1, imagePath, hasData.Item2); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Reports.xlsx")); } } } catch (Exception ex) { error = ex.ToString(); } return(NotFound(new { Error = "Training Program report not found " + error })); }
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 GetTrainingCostFromHistory([FromBody] TrainingFilterViewModel TrainingFilter) { if (TrainingFilter != null) { return(new JsonResult(this.repositoryReport.GetTrainingCostFromHistory(TrainingFilter), this.DefaultJsonSettings)); } return(NotFound(new { Error = "Training filter not found " })); }
public IActionResult GetReportByEmployeeCode([FromBody] TrainingFilterViewModel TrainingFilter) { if (TrainingFilter != null) { return(new JsonResult(this.repositoryReport.GetTrainingMasterFromEmployee(TrainingFilter).Result, this.DefaultJsonSettings)); } else { return(NotFound(new { Error = "Employee history not found" })); } }
public IActionResult GetReportByTrainingCourse([FromBody] TrainingFilterViewModel TrainingFilter) { if (TrainingFilter != null) { return(new JsonResult(this.repositoryReport.GetEmployeeFromTrainingCourse(TrainingFilter), this.DefaultJsonSettings)); } else { return(NotFound(new { Error = "Training course not found " })); } }
public IActionResult GetReportByTrainingProgramForSupplement([FromBody] TrainingFilterViewModel TrainingFilter) { if (TrainingFilter != null) { return(new JsonResult(this.repositoryReport.GetEmployeeFromTrainingProgramSupplementV2(TrainingFilter), this.DefaultJsonSettings)); } else { return(NotFound(new { Error = "Training program not found " })); } }
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 })); }