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