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