public List <ProcessRequestDTO> GetListWithModel(ProcessRequestDTO searchModel)
{
log.MethodStart();
List <ProcessRequestDTO> objList = new List <ProcessRequestDTO>();
//var searchModel = JsonSerializer.Deserialize<HospitalDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objReturn1 = _db.TRProcessRequests.ToList();
objList = _mapper.Map <List <ProcessRequestDTO> >(objReturn1);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
public List <ProcessRequestDTO> GetListWithModel(ProcessRequestDTO searchModel)
{
log.MethodStart();
List <ProcessRequestDTO> objList = new List <ProcessRequestDTO>();
//var searchModel = JsonSerializer.Deserialize<HospitalDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
objList = _db.ProcessRequestDTOs.FromSqlRaw <ProcessRequestDTO>("sp_GET_TRProcessRequest_DTO {0}, {1}, {2}, {3}, {4}, {5}, {6}", searchModel.pcr_code, searchModel.pcr_arh_code, searchModel.pcr_prv_code, searchModel.pcr_hos_code, searchModel.pcr_month_start, searchModel.pcr_month_end, searchModel.pcr_year).ToList();
//objList = _mapper.Map<List<ProcessRequestDTO>>(objReturn1);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
public ProcessRequestDTO GetData(string pcr_code)
{
log.MethodStart();
ProcessRequestDTO objModel = new ProcessRequestDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objReturn1 = _db.TRProcessRequests.FirstOrDefault(x => x.pcr_code == pcr_code);
objModel = _mapper.Map <ProcessRequestDTO>(objReturn1);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public ProcessRequestDTO SaveData(ProcessRequestDTO model)
{
log.MethodStart();
ProcessRequestDTO objReturn = new ProcessRequestDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = _db.TRProcessRequests.FirstOrDefault(x => x.pcr_code == model.pcr_code);
objModel = _mapper.Map <TRProcessRequest>(model);
//objModel.hos_status = objModel.hos_active == true ? "A" : "I";
_db.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public ProcessRequestDTO GetData(string pcr_code)
{
log.MethodStart();
ProcessRequestDTO objModel = new ProcessRequestDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
//var objReturn1 = _db.TRProcessRequests.FirstOrDefault(x => x.pcr_code == pcr_code);
var objReturn1 = _db.TRProcessRequests.FromSqlRaw <TRProcessRequest>("sp_GET_TRProcessRequest {0}, {1}, {2}, {3}, {4}, {5}, {6}", pcr_code, null, null, null, null, null, null).ToList();
if (objReturn1 != null)
{
objModel = _mapper.Map <ProcessRequestDTO>(objReturn1.FirstOrDefault());
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public async Task <ProcessRequestDTO> GetDataWithModelAsync(ProcessRequestDTO searchData)
{
ProcessRequestDTO data = new ProcessRequestDTO();
data = await _apiHelper.PostDataAsync <ProcessRequestDTO>("processrequest_api/Get_DataWithModel", searchData);
return(data);
}
public async Task <ProcessRequestDTO> GetDataAsync(string pcr_code)
{
ProcessRequestDTO menu = new ProcessRequestDTO();
menu = await _apiHelper.GetDataByIdAsync <ProcessRequestDTO>("processrequest_api/Get_Data", pcr_code);
return(menu);
}
public async Task <List <ProcessRequestDTO> > GetListByModelAsync(ProcessRequestDTO searchData)
{
List <ProcessRequestDTO> objList = new List <ProcessRequestDTO>();
objList = await _apiHelper.GetDataListByModelAsync <ProcessRequestDTO, ProcessRequestDTO>("processrequest_api/Get_ListByModel", searchData);
return(objList);
}
public ProcessRequestDTO SaveDataToPublic(string pcr_code)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
ProcessRequestDTO objReturn = new ProcessRequestDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TRProcessRequest();
objModel = _db.TRProcessRequests.FirstOrDefault(x => x.pcr_code == pcr_code);
if (objModel != null)
{
objModel.pcr_status = "P";
objModel.pcr_updateuser = currentUser;
objModel.pcr_updatedate = currentDateTime;
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "ProcessRequest",
log_tran_id = objModel.pcr_id.ToString(),
log_action = (objModel.pcr_status == "N" ? "New" : "Update"),
log_desc = "Update ProcessRequest " + objModel.pcr_code,
log_createuser = currentUser,
log_createdate = currentDateTime
});
#endregion
_db.SaveChanges();
trans.Commit();
}
objReturn = _mapper.Map <ProcessRequestDTO>(objModel);
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public async Task <List <ProcessRequestDTO> > GetListByParamAsync(ProcessRequestDTO searchData)
{
List <ProcessRequestDTO> objList = new List <ProcessRequestDTO>();
var searchJson = JsonSerializer.Serialize(searchData);
objList = await _apiHelper.GetDataListByParamsAsync <ProcessRequestDTO>("processrequest_api/Get_List", searchJson);
return(objList);
}
public async Task <ProcessRequestDTO> SaveDataAsync(ProcessRequestDTO 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 <ProcessRequestDTO>("processrequest_api/Post_SaveData", model);
return(menua);
}
public async Task <ProcessRequestDTO> SaveDataToPublicAsync(string pcr_code)
{
//MenuDTO menu = new MenuDTO()
//{
// mnu_id = "2",
// mnu_name = "TEST_name",
// mnu_area = "TEST_area",
// mnu_controller = "TEST_controller"
//};
ProcessRequestDTO data = new ProcessRequestDTO();
data = await _apiHelper.GetDataByIdAsync <ProcessRequestDTO>("processrequest_api/Save_DataToPublic", pcr_code);
return(data);
}
public ProcessRequestDTO GetDataWithModel(ProcessRequestDTO searchModel)
{
log.MethodStart();
ProcessRequestDTO objModel = new ProcessRequestDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
//var objReturn1 = _db.TRProcessRequests.FirstOrDefault(x => x.pcr_code == pcr_code);
var objReturn1 = _db.TRProcessRequests.Where(x => x.pcr_hos_code == searchModel.pcr_hos_code &&
x.pcr_prv_code == searchModel.pcr_prv_code &&
x.pcr_arh_code == searchModel.pcr_arh_code &&
x.pcr_month_start == searchModel.pcr_month_start &&
x.pcr_month_end == searchModel.pcr_month_end &&
x.pcr_year == searchModel.pcr_year &&
x.pcr_type == searchModel.pcr_type &&
x.pcr_spc_code == searchModel.pcr_spc_code
).ToList();
if (objReturn1 != null && objReturn1.Count > 0)
{
objModel = _mapper.Map <ProcessRequestDTO>(objReturn1.FirstOrDefault());
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public List <ProcessRequestCheckDetailDTO> GetCheckDetailListWithModel(ProcessRequestDTO searchModel)
{
log.MethodStart();
List <ProcessRequestCheckDetailDTO> objList = new List <ProcessRequestCheckDetailDTO>();
//var searchModel = JsonSerializer.Deserialize<HospitalDTO>(param);
using (var trans = _db.Database.BeginTransaction())
{
try
{
var date_start = new DateTime(Convert.ToInt32(searchModel.pcr_year), Convert.ToInt32(searchModel.pcr_month_start), 1);
var date_end = new DateTime(Convert.ToInt32(searchModel.pcr_year), Convert.ToInt32(searchModel.pcr_month_end), 1).AddMonths(1);
var objReturnList = _db.ProcessRequestDetailDTOs.FromSqlRaw <ProcessRequestDetailDTO>("sp_GET_TRProcessRequestDetail_DTO {0}, {1}, {2}, {3}, {4}, {5}, {6}", "C", null, searchModel.pcr_arh_code, searchModel.pcr_prv_code, searchModel.pcr_hos_code, date_start, date_end).ToList();
objList = _mapper.Map <List <ProcessRequestCheckDetailDTO> >(objReturnList);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objList);
}
public void Process(ProcessRequestDTO request)
{
_renderServiceTransport.Send(request);
}
public ProcessRequestDTO Post_SaveData([FromBody] ProcessRequestDTO model)
{
var objReturn = _service.SaveData(model);
return(objReturn);
}
public IEnumerable <ProcessRequestDetailDTO> Get_PermissionListByModel([FromBody] ProcessRequestDTO searchModel)
{
var objReturn = _service.GetDetailListWithModel(searchModel);
return(objReturn);
}
public ProcessRequestDTO SaveData(ProcessRequestDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
var new_pcr_code = "";
ProcessRequestDTO objReturn = new ProcessRequestDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TRProcessRequest();
objModel = _mapper.Map <TRProcessRequest>(model);
var currentYearCode = $"PCR_{DateTime.Now.ToString("yyyyMMdd")}";
var objDataList = _db.TRProcessRequests.Where(x => x.pcr_code.Contains(currentYearCode)).ToList();
if (objDataList.Count > 0)
{
var lastData = objDataList.LastOrDefault();
var lastCode = lastData.pcr_code.Replace(currentYearCode, "");
var newCodeInt = (Convert.ToInt32(lastCode) + 1);
new_pcr_code = currentYearCode + newCodeInt.ToString("0000");
}
else
{
new_pcr_code = currentYearCode + (1).ToString("0000");
}
objModel.pcr_id = 0;
objModel.pcr_code = new_pcr_code;
objModel.pcr_status = "W";
objModel.pcr_active = true;
objModel.pcr_status = objModel.pcr_active == true ? "A" : "I";
objModel.pcr_createdate = currentDateTime;
objModel.pcr_updatedate = currentDateTime;
currentUser = objModel.pcr_updateuser;
_db.TRProcessRequests.Add(objModel);
var objData = _db.TRProcessRequests.FirstOrDefault(x => x.pcr_code == model.pcr_prev_code);
if (objData != null)
{
objData.pcr_status = "I";
objData.pcr_active = false;
objData.pcr_updateuser = model.pcr_updateuser;
objData.pcr_updatedate = currentDateTime;
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "ProcessRequest",
log_tran_id = objModel.pcr_id.ToString(),
log_action = (model.pcr_status == "N" ? "New" : "Update"),
log_desc = "Update ProcessRequest " + objModel.pcr_code,
log_createuser = currentUser,
log_createdate = currentDateTime
});
#endregion
_db.SaveChanges();
trans.Commit();
objReturn = _mapper.Map <ProcessRequestDTO>(objModel);
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
public ProcessResponseDTO ProcessPipeline(ClassificationDTO data)
{
try
{
HttpStatusCode statusCode;
ProcessRequestDTO postObj = data.docs;
postObj.client = data.docs.client;
// JavaScriptSerializer req_serializer = new JavaScriptSerializer();
//req_serializer.MaxJsonLength = Int32.MaxValue;
var json = JsonConvert.SerializeObject(postObj);
//var json = new JavaScriptSerializer().Serialize(postObj);
string respone = MakeHttpPostRequest(data.access.PythonServiceBaseURL + "/prediction_service/process_pipeline", json, out statusCode);
//Logger.Info("Response Received");
//JavaScriptSerializer serializer = new JavaScriptSerializer();
//serializer.MaxJsonLength = Int32.MaxValue;
EncodedProcessResponseDTO resObj = (EncodedProcessResponseDTO)JsonConvert.DeserializeObject(respone, typeof(EncodedProcessResponseDTO));
//Logger.Info("Deserialized");
var sOutput = new MemoryStream();
string text;
byte[] gzBuffer = Convert.FromBase64String(resObj.response);
using (var ms = new MemoryStream())
{
ms.Write(gzBuffer, 0, gzBuffer.Length);
var buffer = new byte[ms.Length * 1024];
ms.Position = 0;
using (var infS = new ZlibStream(ms, Ionic.Zlib.CompressionMode.Decompress))
{
infS.Read(buffer, 0, buffer.Length);
//infS.CopyTo(sOutput);
}
text = Encoding.UTF8.GetString(buffer, 0, buffer.Length);
}
text = text.TrimEnd('\0');
ProcessResponseDTO responseObj = (ProcessResponseDTO)JsonConvert.DeserializeObject(text, typeof(ProcessResponseDTO));
//Logger.Info("Decoded data =>" + responseObj);
if (statusCode != HttpStatusCode.OK)
{
throw new Exception("Web request failure during process pipeline. Status Code:" + statusCode.ToString());
}
else if (responseObj.message == "Token is valid but Expired, Please generate request to get new token")
{
//tokenResult tr = Authorization(pythonBasedURL, User, Password);
//docs.token = tr.token;
//ProcessResponseDTO responseObj1 = ProcessPipeline(docs, pythonBasedURL, User, Password);
//return responseObj1;
}
else if (!responseObj.status.Equals("success"))
{
throw new Exception(responseObj.message);
}
return(responseObj);
}
catch (Exception ex)
{
//Logger.Info(ex.Message);
}
return(new ProcessResponseDTO());
}
public IEnumerable <ProcessRequestDTO> Post_SaveData([FromBody] ProcessRequestDTO model)
{
var objReturn = _service.GetList();
return(objReturn);
}
public ProcessRequestDTO Get_DataWithModel([FromBody] ProcessRequestDTO searchModel)
{
var objReturn = _service.GetDataWithModel(searchModel);
return(objReturn);
}
