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 }));
}