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