public OrganismDTO SaveData(OrganismDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
OrganismDTO objReturn = new OrganismDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCOrganism();
if (model.org_status == "E")
{
objModel = _db.TCOrganisms.FirstOrDefault(x => x.org_id == model.org_id);
}
if (model.org_status == "N")
{
objModel = _mapper.Map <TCOrganism>(model);
objModel.ORG = model.org_mst_ORG;
objModel.ORG = model.org_mst_ORG;
objModel.GRAM = model.org_mst_GRAM;
objModel.ORGANISM = model.org_mst_ORGANISM;
objModel.STATUS = model.org_mst_STATUS;
objModel.org_status = objModel.org_active == true ? "A" : "I";
objModel.org_createdate = currentDateTime;
currentUser = objModel.org_createuser;
_db.TCOrganisms.Add(objModel);
}
else if (model.org_status == "E")
{
objModel.org_code = model.org_code;
objModel.ORG = model.org_mst_ORG;
objModel.GRAM = model.org_mst_GRAM;
objModel.ORGANISM = model.org_mst_ORGANISM;
objModel.STATUS = model.org_mst_STATUS;
objModel.org_active = model.org_active;
objModel.org_status = objModel.org_active == true ? "A" : "I";
objModel.org_updateuser = model.org_updateuser;
objModel.org_updatedate = currentDateTime;
currentUser = objModel.org_createuser;
//_db.TCHospitals.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "Organism",
log_tran_id = $"{objModel.org_mst_code}:{objModel.org_code}",
log_action = (model.org_status == "N" ? "New" : "Update"),
log_desc = (model.org_status == "N" ? "New" : "Update") + " Organism " + objModel.org_code,
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);
}
public MasterTemplateDTO SaveData(MasterTemplateDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
MasterTemplateDTO objReturn = new MasterTemplateDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCMasterTemplate();
if (model.mst_status == "E")
{
objModel = _db.TCMasterTemplates.FirstOrDefault(x => x.mst_code == model.mst_code);
}
if (model.mst_status == "N")
{
var new_mst_code = "";
var currentYearCode = $"MST_{DateTime.Now.ToString("yyyy")}";
MasterTemplateSearchDTO searchModel = new MasterTemplateSearchDTO();
var objDataList = _db.TCMasterTemplates.FromSqlRaw <TCMasterTemplate>("sp_GET_TCMasterTemplate {0}, {1}, {2}", currentYearCode, searchModel.mst_date_from, searchModel.mst_date_to).ToList();
if (objDataList.Count > 0)
{
var lastData = objDataList.LastOrDefault();
var lastCode = lastData.mst_code.Substring(7);
var newCodeInt = (Convert.ToInt32(lastCode) + 1);
new_mst_code = currentYearCode + newCodeInt.ToString("0000");
}
else
{
new_mst_code = currentYearCode + (1).ToString("0000");
}
model.mst_code = new_mst_code;
objReturn.mst_code = new_mst_code;
objModel = _mapper.Map <TCMasterTemplate>(model);
objModel.mst_status = objModel.mst_active == true ? "A" : "I";
objModel.mst_createdate = currentDateTime;
currentUser = objModel.mst_createuser;
_db.TCMasterTemplates.Add(objModel);
}
else if (model.mst_status == "E")
{
//objModel.mst_name = model.mst_name;
objModel.mst_version = model.mst_version;
objModel.mst_date_from = model.mst_date_from;
objModel.mst_active = model.mst_active;
objModel.mst_status = objModel.mst_active == true ? "A" : "I";
objModel.mst_updateuser = model.mst_updateuser;
objModel.mst_updatedate = currentDateTime;
currentUser = objModel.mst_updateuser;
//_db.TCTemplates.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "MasterTemplate",
log_tran_id = model.mst_code.ToString(),
log_action = (model.mst_status == "N" ? "New" : "Update"),
log_desc = (model.mst_status == "N" ? "New" : "Update") + " MasterTemplate " + objModel.mst_code,
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);
}
public AntibioticDTO SaveData(AntibioticDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
AntibioticDTO objReturn = new AntibioticDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCAntibiotic();
if (model.ant_status == "E")
{
objModel = _db.TCAntibiotics.FirstOrDefault(x => x.ant_id == model.ant_id);
}
if (model.ant_status == "N")
{
objModel = _mapper.Map <TCAntibiotic>(model);
objModel.ant_status = objModel.ant_active == true ? "A" : "I";
objModel.ant_createdate = currentDateTime;
currentUser = objModel.ant_createuser;
_db.TCAntibiotics.Add(objModel);
}
else if (model.ant_status == "E")
{
objModel.ant_code = model.ant_code;
objModel.ant_name = model.ant_name;
objModel.GUIDELINES = model.ant_mst_GUIDELINES;
objModel.ABX_NUMBER = model.ant_mst_ABX_NUMBER;
objModel.POTENCY = model.ant_mst_POTENCY;
objModel.ant_active = model.ant_active;
objModel.ant_status = objModel.ant_active == true ? "A" : "I";
objModel.ant_updateuser = model.ant_updateuser;
objModel.ant_updatedate = currentDateTime;
currentUser = objModel.ant_updateuser;
//_db.TCHospitals.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "Antibiotic",
log_tran_id = $"{objModel.ant_mst_code}:{objModel.ant_code}",
log_action = (model.ant_status == "N" ? "New" : "Update"),
log_desc = (model.ant_status == "N" ? "New" : "Update") + " Antibiotic " + objModel.ant_code,
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(model);
}
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);
}
public ExpertRuleDTO SaveData(ExpertRuleDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
ExpertRuleDTO objReturn = new ExpertRuleDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCExpertRule();
if (model.exr_status == "E")
{
objModel = _db.TCExpertRoles.FirstOrDefault(x => x.exr_id == model.exr_id);
}
if (model.exr_status == "N")
{
objModel = _mapper.Map <TCExpertRule>(model);
objModel.CATEGORY = model.exr_mst_CATEGORY;
objModel.PRIORITY = model.exr_mst_PRIORITY;
objModel.ORGANISMS = model.exr_mst_ORGANISMS;
objModel.DESCRIPTION = model.exr_mst_DESCRIPTION;
objModel.exr_status = objModel.exr_active == true ? "A" : "I";
objModel.exr_createdate = currentDateTime;
currentUser = objModel.exr_createuser;
_db.TCExpertRoles.Add(objModel);
}
else if (model.exr_status == "E")
{
objModel.exr_code = model.exr_code;
objModel.CATEGORY = model.exr_mst_CATEGORY;
objModel.PRIORITY = model.exr_mst_PRIORITY;
objModel.ORGANISMS = model.exr_mst_ORGANISMS;
objModel.DESCRIPTION = model.exr_mst_DESCRIPTION;
objModel.exr_active = model.exr_active;
objModel.exr_status = objModel.exr_active == true ? "A" : "I";
objModel.exr_updateuser = model.exr_updateuser;
objModel.exr_updatedate = currentDateTime;
currentUser = objModel.exr_updateuser;
//_db.TCHospitals.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "ExpertRole",
log_tran_id = $"{objModel.exr_mst_code}:{objModel.exr_code}",
log_action = (model.exr_status == "N" ? "New" : "Update"),
log_desc = (model.exr_status == "N" ? "New" : "Update") + " ExpertRole " + objModel.exr_code,
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);
}
public MasterHospitalDTO SaveData(MasterHospitalDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
var currentUser = "";
MasterHospitalDTO objReturn = new MasterHospitalDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TCHospital();
var objModelTR = new TRHospital();
if (model.hos_status == "E")
{
objModel = _db.TCHospitals.FirstOrDefault(x => x.hos_id == model.hos_id);
objModelTR = _db.TRHospitals.FirstOrDefault(x => x.hos_code == objModel.hos_code);
}
if (model.hos_status == "N")
{
objModel = _mapper.Map <TCHospital>(model);
objModel.hos_status = objModel.hos_active == true ? "A" : "I";
objModel.hos_createdate = currentDateTime;
currentUser = objModel.hos_createuser;
_db.TCHospitals.Add(objModel);
}
else if (model.hos_status == "E")
{
objModel.hos_name = model.hos_name;
objModel.hos_arh_code = model.hos_arh_code;
objModel.hos_province_code = model.hos_province_code;
objModel.hos_active = model.hos_active;
objModel.hos_status = objModel.hos_active == true ? "A" : "I";
objModel.hos_updatedate = currentDateTime;
currentUser = objModel.hos_updateuser;
if (objModelTR != null)
{
objModelTR.hos_name = model.hos_name;
objModelTR.hos_arh_code = model.hos_arh_code;
objModelTR.hos_prv_code = model.hos_province_code;
objModelTR.hos_active = model.hos_active;
objModelTR.hos_status = objModel.hos_active == true ? "A" : "I";
objModelTR.hos_updateuser = currentUser;
objModelTR.hos_updatedate = currentDateTime;
}
//_db.TCHospitals.Update(objModel);
}
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "MasterHospital",
log_tran_id = objModel.hos_code,
log_action = (model.hos_status == "N" ? "New" : "Update"),
log_desc = (model.hos_status == "N" ? "New" : "Update") + " MasterHospital " + objModel.hos_name,
log_createuser = currentUser,
log_createdate = currentDateTime
});
if (model.hos_status == "E" && objModelTR != null)
{
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = currentUser,
log_mnu_id = "",
log_mnu_name = "Hospital",
log_tran_id = objModel.hos_code.ToString(),
log_action = "Update",
log_desc = "Update Hospital " + objModel.hos_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);
}