public List <WHONETColumnDTO> GetListWithModel(WHONETColumnDTO searchModel)
{
log.MethodStart();
List <WHONETColumnDTO> objList = new List <WHONETColumnDTO>();
//var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objDataList = _db.TCWHONETColumns.FromSqlRaw <TCWHONETColumn>("sp_GET_TCWHONETColumn {0}", searchModel.wnc_mst_code).ToList();
objList = _mapper.Map <List <WHONETColumnDTO> >(objDataList);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
public string CheckDuplicate(WHONETColumnDTO model)
{
log.MethodStart();
string objReturn = "";
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objResult = _db.TCWHONETColumns.Any(x => x.wnc_code == model.wnc_code);
if (objResult == true)
{
objReturn = "Dup";
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
log.Error(ex.Message);
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public WHONETColumnDTO GetData(string wnc_code)
{
log.MethodStart();
WHONETColumnDTO objModel = new WHONETColumnDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objReturn1 = _db.TCWHONETColumns.FirstOrDefault(x => x.wnc_code == wnc_code);
objModel = _mapper.Map <WHONETColumnDTO>(objReturn1);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public async Task <List <WHONETColumnDTO> > GetListByModelActiveAsync(WHONETColumnDTO searchData)
{
List <WHONETColumnDTO> objList = new List <WHONETColumnDTO>();
objList = await _apiHelper.GetDataListByModelAsync <WHONETColumnDTO, WHONETColumnDTO>("whonetcolumn_api/Get_List_Active_ByModel", searchData);
return(objList);
}
public WHONETColumnDTO Post_SaveData([FromBody] WHONETColumnDTO model)
{
var objReturn = _service.SaveData(model);
//var objReturn = _service.GetList();
return(objReturn);
}
public async Task <WHONETColumnDTO> GetDataAsync(string mst_code)
{
WHONETColumnDTO menu = new WHONETColumnDTO();
menu = await _apiHelper.GetDataByIdAsync <WHONETColumnDTO>("whonetcolumn_api/Get_Data", mst_code);
return(menu);
}
public async Task <List <WHONETColumnDTO> > GetListByParamAsync(WHONETColumnDTO searchData)
{
List <WHONETColumnDTO> objList = new List <WHONETColumnDTO>();
var searchJson = JsonSerializer.Serialize(searchData);
objList = await _apiHelper.GetDataListByParamsAsync <WHONETColumnDTO>("whonetcolumn_api/Get_List", searchJson);
return(objList);
}
public async Task <WHONETColumnDTO> SaveDataAsync(WHONETColumnDTO model)
{
//MenuDTO menu = new MenuDTO()
//{
// mnu_id = "2",
// mnu_name = "TEST_name",
// mnu_area = "TEST_area",
// mnu_controller = "TEST_controller"
//};
var menua = await _apiHelper.PostDataAsync <WHONETColumnDTO>("whonetcolumn_api/Post_SaveData", model);
return(menua);
}
public async Task ExportLabDataWithHIS(IJSRuntime iJSRuntime, LabDataWithHISSearchDTO model, MasterTemplateDTO ActiveMasterTemplate, HISFileTemplateDTO HISTemplateActive)
{
byte[] fileContents;
const int idxColLabNo = 3;
const int idxColSpcDate = 4;
const int idxColHN = 2;
const int idxColRef = 1;
int idcColWhonetConfig = 5;
var lstDynamicColumn = new List <int>();
var dctWhonetColumn = new Dictionary <string, int>();
//const int idxColAdmisDate = 6;
//const int idxColCINI = 7;
int idxRowCurrent = 1;
string COL_REF_NO = HISTemplateActive.hft_field1; // "Ref No";
string COL_HN_NO = HISTemplateActive.hft_field2; //"HN";
string COL_LAB_NO = HISTemplateActive.hft_field3; // "Lab";
string COL_DATE = HISTemplateActive.hft_field4; //"Date";
List <LabDataWithHISDTO> objLabWithRef = new List <LabDataWithHISDTO>();
List <HISDetailDTO> objHISDetail = new List <HISDetailDTO>();
List <WHONETColumnDTO> objWhonetActive = new List <WHONETColumnDTO>();
List <string> objWhonetHISColumn = new List <string>();
WHONETColumnDTO objSearchWhonet = new WHONETColumnDTO();
List <STGLabFileDataDetailDTO> objLabDetail = new List <STGLabFileDataDetailDTO>();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
//sp_GET_LabDataWithHIS
objLabWithRef = await _apiHelper.GetDataListByModelAsync <LabDataWithHISDTO, LabDataWithHISSearchDTO>("his_api/GetLabDataWithHIS", model);
objHISDetail = await _apiHelper.GetDataListByModelAsync <HISDetailDTO, LabDataWithHISSearchDTO>("his_api/GetHISDetail", model);
objLabDetail = await _apiHelper.GetDataListByModelAsync <STGLabFileDataDetailDTO, LabDataWithHISSearchDTO>("his_api/GetLabDataWithHISDetail", model);
if (objLabWithRef.Count == 0)
{
// Show message No data to export
}
using (var package = new ExcelPackage())
{
var workSheet = package.Workbook.Worksheets.Add("REF_HIS");
// Header Column
workSheet.Cells[idxRowCurrent, idxColRef].Value = COL_REF_NO;
workSheet.Cells[idxRowCurrent, idxColHN].Value = COL_HN_NO;
workSheet.Cells[idxRowCurrent, idxColLabNo].Value = COL_LAB_NO;
workSheet.Cells[idxRowCurrent, idxColSpcDate].Value = COL_DATE;
objSearchWhonet.wnc_mst_code = ActiveMasterTemplate.mst_code;
objWhonetActive = await _apiHelper.GetDataListByModelAsync <WHONETColumnDTO, WHONETColumnDTO>("whonetcolumn_api/Get_List_Active_ByModel", objSearchWhonet);
if (objWhonetActive != null)
{
// ToDo : change wnc_mendatory to wnc_his_export_flag
var objWhonetHIS = objWhonetActive.Where(w => w.wnc_mendatory == true).ToList();
objWhonetHISColumn = objWhonetHIS.Select(s => s.wnc_name).ToList();
//objWhonetHISColumn = new List<string> { "Last name", "First name", "Sex", "Date of birth", "Age", "Location" };
foreach (var obj in objWhonetHISColumn)
{
// Dynamic Column From Whonet Setting
workSheet.Cells[idxRowCurrent, idcColWhonetConfig].Value = obj;
if (!dctWhonetColumn.ContainsKey(obj))
{
dctWhonetColumn.Add(obj, idcColWhonetConfig);
}
//lstDynamicColumn.Add(idcColWhonetConfig);
idcColWhonetConfig++;
}
}
foreach (LabDataWithHISDTO objLab in objLabWithRef)
{
//if (idxRowCurrent == 11) { break; } //for test
idxRowCurrent += 1;
workSheet.Cells[idxRowCurrent, idxColRef].Value = objLab.ref_no;
workSheet.Cells[idxRowCurrent, idxColHN].Value = objLab.hn_no;
workSheet.Cells[idxRowCurrent, idxColLabNo].Value = objLab.lab_no;
workSheet.Cells[idxRowCurrent, idxColSpcDate].Value = objLab.spec_date;
workSheet.Column(idxColSpcDate).Style.Numberformat.Format = "dd/MM/yyyy";
// Note : obj.huh_id ที่เอามา where ต้องหาจาก query มาแล้วว่าเป็นตัวล่าสุด ที่จะ export ออกมา สถานะไม่ใช่ delete ...
//(First) Find HIS Data from Upload HIS
var objHISDetailFromHIS = objHISDetail.Where(w => w.ref_no == objLab.ref_no &&
w.hn_no == objLab.hn_no &&
w.lab_no == objLab.lab_no &&
w.spec_date == objLab.spec_date).ToList();
foreach (var objHIS in objHISDetailFromHIS)
{
if (objWhonetHISColumn.Contains(objHIS.hud_field_name))
{
if (!string.IsNullOrEmpty(objHIS.hud_field_value))
{
workSheet.Cells[idxRowCurrent, dctWhonetColumn[objHIS.hud_field_name]].Value = objHIS.hud_field_value;
}
}
}
//(Second) Find HIS Data from Lab
Guid guidHeaderId = new Guid(objLab.lab_header_id);
var objHISDetailFromLab = objLabDetail.Where(w => w.ldd_ldh_id == guidHeaderId).ToList();
foreach (var obj in objHISDetailFromLab)
{
if (objWhonetHISColumn.Contains(obj.ldd_whonetfield))
{
if (!string.IsNullOrEmpty(obj.ldd_originalvalue))
{
//var DecodeValue = CryptoHelper.UnicodeDecoding(obj.ldd_originalvalue);
if (workSheet.Cells[idxRowCurrent, dctWhonetColumn[obj.ldd_whonetfield]].Value == null)
{
workSheet.Cells[idxRowCurrent, dctWhonetColumn[obj.ldd_whonetfield]].Value = obj.ldd_originalvalue;
}
}
}
}
} // End Loop Lab Data
workSheet.Column(idxColRef).AutoFit();
workSheet.Column(idxColHN).AutoFit();
workSheet.Column(idxColLabNo).AutoFit();
workSheet.Column(idxColSpcDate).AutoFit();
workSheet.Protection.IsProtected = true; // Protect whole sheet
foreach (var colHIS in dctWhonetColumn.Values)
{
workSheet.Column(colHIS).Style.Locked = false;//unlock workSheet
workSheet.Column(1).AutoFit();
}
fileContents = package.GetAsByteArray();
}
try
{
await iJSRuntime.InvokeAsync <HISFileUploadService>(
"saveAsFile",
"HIS_WITH_SP.xlsx",
Convert.ToBase64String(fileContents)
);
}
catch (Exception ex)
{
}
}
public IEnumerable <WHONETColumnDTO> Get_List_Active_ByModel([FromBody] WHONETColumnDTO searchModel)
{
var objReturn = _service.GetList_Active_WithModel(searchModel);
return(objReturn);
}
public async Task ExportLabDataWithHIS(IJSRuntime iJSRuntime, LabDataWithHISSearchDTO model, MasterTemplateDTO ActiveMasterTemplate)
{
byte[] fileContents;
const int idxColLabNo = 3;
const int idxColSpcDate = 4;
const int idxColHN = 2;
const int idxColRef = 1;
int idcColWhonetConfig = 5;
var lstDynamicColumn = new List <int>();
//const int idxColAdmisDate = 6;
//const int idxColCINI = 7;
int idxRowCurrent = 1;
List <LabDataWithHISDTO> objLabHIS = new List <LabDataWithHISDTO>();
List <WHONETColumnDTO> objWhonetActive = new List <WHONETColumnDTO>();
WHONETColumnDTO objSearchWhonet = new WHONETColumnDTO();
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
using (var package = new ExcelPackage())
{
var workSheet = package.Workbook.Worksheets.Add("REF_HIS");
// Header Column
workSheet.Cells[idxRowCurrent, idxColRef].Value = "Ref";
workSheet.Cells[idxRowCurrent, idxColHN].Value = "HN";
workSheet.Cells[idxRowCurrent, idxColLabNo].Value = "Lab No.";
workSheet.Cells[idxRowCurrent, idxColSpcDate].Value = "Date";
// Dynamic Column From Whonet Setting
objSearchWhonet.wnc_mst_code = ActiveMasterTemplate.mst_code;
objWhonetActive = await _apiHelper.GetDataListByModelAsync <WHONETColumnDTO, WHONETColumnDTO>("whonetcolumn_api/Get_List_Active_ByModel", objSearchWhonet);
if (objWhonetActive != null)
{
// ToDo : change wnc_mendatory to wnc_his_export_flag
var objWhonetHIS = objWhonetActive.Where(w => w.wnc_mendatory == true).ToList();
foreach (var obj in objWhonetHIS)
{
workSheet.Cells[idxRowCurrent, idcColWhonetConfig].Value = obj.wnc_name;
lstDynamicColumn.Add(idcColWhonetConfig);
idcColWhonetConfig++;
}
}
//workSheet.Cells[idxRowCurrent, idxColAdmisDate].Value = "Admission Date";
//workSheet.Cells[idxRowCurrent, idxColCINI].Value = "CI/NI";
objLabHIS = await _apiHelper.GetDataListByModelAsync <LabDataWithHISDTO, LabDataWithHISSearchDTO>("his_api/GetLabDataWithHIS", model);
foreach (LabDataWithHISDTO obj in objLabHIS)
{
idxRowCurrent += 1;
workSheet.Cells[idxRowCurrent, idxColRef].Value = obj.ref_no;
workSheet.Cells[idxRowCurrent, idxColHN].Value = obj.hn_no;
workSheet.Cells[idxRowCurrent, idxColLabNo].Value = obj.lab_no;
workSheet.Cells[idxRowCurrent, idxColSpcDate].Value = obj.spec_date;
//if ((obj.admission_date.HasValue)) { workSheet.Cells[idxRowCurrent, idxColAdmisDate].Value = obj.admission_date; }
//if (!string.IsNullOrEmpty(obj.cini)) { workSheet.Cells[idxRowCurrent, idxColCINI].Value = obj.cini; }
}
workSheet.Protection.IsProtected = true; // Protect whole sheet
foreach (var colHIS in lstDynamicColumn)
{
workSheet.Column(colHIS).Style.Locked = false;//unlock column
}
fileContents = package.GetAsByteArray();
}
try
{
await iJSRuntime.InvokeAsync <HISFileUploadService>(
"saveAsFile",
"HIS_WITH_SP.xlsx",
Convert.ToBase64String(fileContents)
);
}
catch (Exception ex)
{
}
}
public WHONETColumnDTO SaveData(WHONETColumnDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
WHONETColumnDTO objReturn = new WHONETColumnDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCWHONETColumn();
if (model.wnc_status == "E")
{
objModel = _db.TCWHONETColumns.FirstOrDefault(x => x.wnc_id == model.wnc_id);
}
if (model.wnc_status == "N")
{
objModel = _mapper.Map <TCWHONETColumn>(model);
objModel.wnc_status = objModel.wnc_active == true ? "A" : "I";
objModel.wnc_createdate = currentDateTime;
currentUser = objModel.wnc_createuser;
_db.TCWHONETColumns.Add(objModel);
}
else if (model.wnc_status == "E")
{
objModel.wnc_name = model.wnc_name;
objModel.wnc_data_type = model.wnc_data_type;
objModel.wnc_encrypt = model.wnc_encrypt;
objModel.wnc_active = model.wnc_active;
objModel.wnc_status = objModel.wnc_active == true ? "A" : "I";
objModel.wnc_updateuser = model.wnc_updateuser;
objModel.wnc_updatedate = currentDateTime;
currentUser = objModel.wnc_updateuser;
//_db.TCHospitals.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "WHONETColumn",
log_tran_id = $"{objModel.wnc_mst_code}:{objModel.wnc_code}",
log_action = (model.wnc_status == "N" ? "New" : "Update"),
log_desc = (model.wnc_status == "N" ? "New" : "Update") + " WHONETColumn " + objModel.wnc_name,
log_createuser = currentUser,
log_createdate = currentDateTime
});
#endregion
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
