public OrganismMappingDataDTO GetOrganismMappingData(string ogm_id)
{
log.MethodStart();
OrganismMappingDataDTO objModel = new OrganismMappingDataDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objReturn1 = _db.TROrganismMappings.FirstOrDefault(x => x.ogm_id.ToString() == ogm_id);
objModel = _mapper.Map <OrganismMappingDataDTO>(objReturn1);
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public async Task <OrganismMappingDataDTO> GetOrganismMappingDataAsync(string ogm_Id)
{
OrganismMappingDataDTO OrganismMapping = new OrganismMappingDataDTO();
OrganismMapping = await _apiHelper.GetDataByIdAsync <OrganismMappingDataDTO>("mapping_api/Get_OrganismMappingData", ogm_Id);
return(OrganismMapping);
}
public async Task <OrganismMappingDataDTO> GetOrganismMappingDataByModelAsync(OrganismMappingDataDTO model)
{
OrganismMappingDataDTO objList = new OrganismMappingDataDTO();
objList = await _apiHelper.GetDataByModelAsync <OrganismMappingDataDTO, OrganismMappingDataDTO>("mapping_api/Get_OrganismMappingDataByModel", model);
return(objList);
}
public async Task <OrganismMappingDataDTO> SaveOrganismMappingDataAsync(OrganismMappingDataDTO model)
{
if (model.ogm_id.Equals(Guid.Empty))
{
model.ogm_id = Guid.NewGuid();
model.ogm_status = 'N';
model.ogm_flagdelete = false;
}
else
{
model.ogm_status = 'E';
}
model.ogm_updatedate = DateTime.Now;
var organismmapping = await _apiHelper.PostDataAsync <OrganismMappingDataDTO>("mapping_api/Post_SaveOrganismMappingData", model);
return(organismmapping);
}
public OrganismMappingDataDTO GetOrganismMappingDataWithModel(OrganismMappingDataDTO model)
{
log.MethodStart();
OrganismMappingDataDTO objModel = new OrganismMappingDataDTO();
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objReturn1 = _db.TROrganismMappings.FirstOrDefault(x => x.ogm_mappingid == model.ogm_mappingid
//&& x.ogm_whonetcode == model.ogm_whonetcode
&& x.ogm_localorganismcode.ToUpper() == model.ogm_localorganismcode.ToUpper()
//&& x.ogm_localorganismdesc == model.ogm_localorganismdesc
&& x.ogm_flagdelete == false);
if (objReturn1 != null)
{
objModel = _mapper.Map <OrganismMappingDataDTO>(objReturn1);
}
trans.Commit();
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objModel);
}
public OrganismMappingDataDTO Get_OrganismMappingDataByModel([FromBody] OrganismMappingDataDTO model)
{
var objReturn = _service.GetOrganismMappingDataWithModel(model);
return(objReturn);
}
public OrganismMappingDataDTO Post_SaveOrganismMappingData([FromBody] OrganismMappingDataDTO model)
{
var objReturn = _service.SaveOrganismMappingData(model);
return(objReturn);
}
public OrganismMappingDataDTO SaveOrganismMappingData(OrganismMappingDataDTO model)
{
log.MethodStart();
var currentDateTime = DateTime.Now;
OrganismMappingDataDTO objReturn = new OrganismMappingDataDTO();
bool chkUpdate = false;
using (var trans = _db.Database.BeginTransaction())
{
try
{
var objModel = new TROrganismMapping();
objModel = _db.TROrganismMappings.FirstOrDefault(x => x.ogm_id == model.ogm_id);
if (objModel == null)
{
objModel = _mapper.Map <TROrganismMapping>(model);
objModel.ogm_createdate = currentDateTime;
objModel.ogm_updatedate = currentDateTime;
chkUpdate = true;
_db.TROrganismMappings.Add(objModel);
}
else
{
if (
objModel.ogm_flagdelete != model.ogm_flagdelete ||
objModel.ogm_whonetcode != model.ogm_whonetcode ||
objModel.ogm_whonetdesc != model.ogm_whonetdesc ||
objModel.ogm_localorganismcode != model.ogm_localorganismcode ||
objModel.ogm_localorganismdesc != model.ogm_localorganismdesc)
{
objModel.ogm_status = model.ogm_status;
objModel.ogm_flagdelete = model.ogm_flagdelete;
objModel.ogm_whonetcode = model.ogm_whonetcode;
objModel.ogm_whonetdesc = model.ogm_whonetdesc;
objModel.ogm_localorganismcode = model.ogm_localorganismcode;
objModel.ogm_localorganismdesc = model.ogm_localorganismdesc;
objModel.ogm_updateuser = model.ogm_updateuser;
objModel.ogm_updatedate = currentDateTime;
chkUpdate = true;
}
}
if (chkUpdate == true)
{
#region Update Mapping Version..
var objMapping = _db.TRMappings.FirstOrDefault(x => x.mp_id == model.ogm_mappingid);
if (objMapping != null)
{
objMapping = PrepareMappingUpdateVersion(objMapping, model.ogm_updateuser, currentDateTime);
}
#endregion
#region Save Log Process ...
_db.LogProcesss.Add(new LogProcess()
{
log_usr_id = (objModel.ogm_updateuser ?? objModel.ogm_createuser),
log_mnu_id = "",
log_mnu_name = "OrganismMapping",
log_tran_id = objModel.ogm_id.ToString(),
log_action = (objModel.ogm_status == 'N' ? "New" : "Update"),
log_desc = "Update OrganismMapping ",
log_createuser = "******",
log_createdate = currentDateTime
});
#endregion
}
_db.SaveChanges();
trans.Commit();
objReturn = _mapper.Map <OrganismMappingDataDTO>(objModel);
}
catch (Exception ex)
{
// TODO: Handle failure
trans.Rollback();
}
finally
{
trans.Dispose();
}
}
log.MethodFinish();
return(objReturn);
}
