public void Update(TCWHONET_Antibiotics model) { log.MethodStart(); using (var trans = _db.Database.BeginTransaction()) { try { var objData = _db.TCWHONET_AntibioticsModel.FirstOrDefault(x => x.who_ant_id == model.who_ant_id); //if (objData != null) //{ // objData = _mapper.Map<TCWHONET_Antibiotics>(model); //} _db.SaveChanges(); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure log.Error(ex); trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); }
public List <TCWHONET_Antibiotics> GetList(TCWHONET_Antibiotics searchModel) { log.MethodStart(); var objList = new List <TCWHONET_Antibiotics>(); using (var trans = _db.Database.BeginTransaction()) { try { objList = _db.TCWHONET_AntibioticsModel.FromSqlRaw <TCWHONET_Antibiotics>("sp_GET_TCWHONET_Antibiotics {0}", searchModel).ToList(); _db.SaveChanges(); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure log.Error(ex); trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objList); }
public void Insert(TCWHONET_Antibiotics model) { log.MethodStart(); var objData = new TCWHONET_Antibiotics(); using (var trans = _db.Database.BeginTransaction()) { try { var result = _db.TCWHONET_AntibioticsModel.Add(model); _db.SaveChanges(); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure log.Error(ex); trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); }
public void Inactive(TCWHONET_Antibiotics model) { log.MethodStart(); model.who_ant_status = "I"; model.who_ant_active = false; try { Update(model); } catch (Exception ex) { // TODO: Handle failure log.Error(ex); } finally { } log.MethodFinish(); }
public TCWHONET_Antibiotics GetData(TCWHONET_Antibiotics searchModel) { log.MethodStart(); var objData = new TCWHONET_Antibiotics(); try { objData = GetList(searchModel)?.FirstOrDefault(); } catch (Exception ex) { // TODO: Handle failure log.Error(ex); } finally { } log.MethodFinish(); return(objData); }