public async Task <string> DownloadPDFFileAsync(GlassFileListDTO selectedobj)
{
var statuscode = "";
try
{
log.MethodStart();
var filename = selectedobj.analyze_file_path.Remove(0, 1) + "/" + selectedobj.analyze_file_name;
var fileextension = Path.GetExtension(selectedobj.analyze_file_name).Replace(".", ""); //.xlsx
var extension = Path.GetExtension(selectedobj.analyze_file_name);
var PdfFileName = filename.Replace(extension, ".pdf"); // GLASS/20200730_01_GLASS/2019_13_glass.pdf
var lstfullname = filename.Split("/");
//var strFullPath = "";
List <ParameterDTO> objParamList = new List <ParameterDTO>();
var searchParam = new ParameterDTO()
{
prm_code_major = "RPT_PROCESS_PATH"
};
objParamList = await _apiHelper.GetDataListByModelAsync <ParameterDTO, ParameterDTO>("dropdownlist_api/GetParameterList", searchParam);
if (objParamList.FirstOrDefault(x => x.prm_code_minor == "PATH") != null)
{
_reportPath = objParamList.FirstOrDefault(x => x.prm_code_minor == "PATH").prm_value;
//FileInfo outputfileInfo = new FileInfo(Path.Combine(_reportPath, PdfFileName));
//strFullPath = Path.Combine(_reportPath, PdfFileName);
//FileInfo outputfileInfo = new FileInfo(strFullPath);
statuscode = await _apiHelper.ExportToPdfDataAsync("exportpdf_api/PdfGenerator", lstfullname);
}
else
{
statuscode = "ERR_PATH";
}
log.MethodFinish();
}
catch (Exception ex)
{
log.Error(ex);
}
return(statuscode);
}
public async Task <string> RequestAnalyseFileAsync(GlassFileListDTO selectedobj)
{
// -- Note --
// สร้าง Report ใหม่ทุกครั้งที่กดปุ่ม Download
var statuscode = "";
try
{
log.MethodStart();
var filename = selectedobj.analyze_file_path.Remove(0, 1) + "\\" + selectedobj.analyze_file_name;
var strFullPath = "";
// Get Report Path
List <ParameterDTO> objParamList = new List <ParameterDTO>();
var searchParam = new ParameterDTO()
{
prm_code_major = "RPT_PROCESS_PATH"
};
objParamList = await _apiHelper.GetDataListByModelAsync <ParameterDTO, ParameterDTO>("dropdownlist_api/GetParameterList", searchParam);
if (objParamList.FirstOrDefault(x => x.prm_code_minor == "PATH") != null)
{
_reportPath = objParamList.FirstOrDefault(x => x.prm_code_minor == "PATH").prm_value;
strFullPath = Path.Combine(_reportPath, filename);
FileInfo OriginalfileExcel = new FileInfo(strFullPath);
statuscode = await _apiHelper.DownloadDataAsync <GlassFileListDTO>("glassreport_api/GenerateAnalyzeFile", OriginalfileExcel, selectedobj);
}
else
{
statuscode = "ERR_PATH";
}
log.MethodFinish();
}
catch (Exception ex)
{
log.Error(ex);
}
return(statuscode);
}
public List <GlassInfectSpecimenDTO> GlassInfectSpecimenModel(GlassFileListDTO searchModel)
{
log.MethodStart();
List <GlassInfectSpecimenDTO> objList = new List <GlassInfectSpecimenDTO>();
//var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.DropdownGlassInfectSpecimenDTOs.FromSqlRaw <GlassInfectSpecimenDTO>("sp_GET_RPGlassInfectSpecimen {0},{1}"
, searchModel.arh_code
, searchModel.year
).ToList();
objList = _mapper.Map <List <GlassInfectSpecimenDTO> >(objDataList);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
