public List <AntibioticDTO> GetListWithModel(AntibioticDTO searchModel) { log.MethodStart(); List <AntibioticDTO> objList = new List <AntibioticDTO>(); //var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param); using (var trans = _db.Database.BeginTransaction()) { try { objList = _db.AntibioticDTOs.FromSqlRaw <AntibioticDTO>("sp_GET_TCAntibiotic {0}", searchModel.ant_mst_code).ToList(); //objList = _mapper.Map<List<AntibioticDTO>>(objDataList); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objList); }
public AntibioticDTO GetDataById(int ant_code) { log.MethodStart(); AntibioticDTO objModel = new AntibioticDTO(); using (var trans = _db.Database.BeginTransaction()) { try { var objReturn1 = _db.TCAntibiotics.FirstOrDefault(x => x.ant_id == ant_code); objModel = _mapper.Map <AntibioticDTO>(objReturn1); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objModel); }
public string CheckDuplicate(AntibioticDTO model) { log.MethodStart(); string objReturn = ""; using (var trans = _db.Database.BeginTransaction()) { try { var objResult = _db.TCAntibiotics.Any(x => x.ant_code == model.ant_code); if (objResult == true) { objReturn = "Dup"; } trans.Commit(); } catch (Exception ex) { // TODO: Handle failure log.Error(ex.Message); trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objReturn); }
public async Task <AntibioticDTO> GetDataAsyncById(int mst_code) { AntibioticDTO menu = new AntibioticDTO(); menu = await _apiHelper.GetDataByIdAsync <AntibioticDTO>("antibiotic_api/Get_DataById", mst_code.ToString()); return(menu); }
public async Task <List <AntibioticDTO> > GetListByModelActiveAsync(AntibioticDTO searchData) { List <AntibioticDTO> objList = new List <AntibioticDTO>(); objList = await _apiHelper.GetDataListByModelAsync <AntibioticDTO, AntibioticDTO>("antibiotic_api/Get_List_Active_ByModel", searchData); return(objList); }
public async Task <List <AntibioticDTO> > GetListByParamAsync(AntibioticDTO searchData) { List <AntibioticDTO> objList = new List <AntibioticDTO>(); var searchJson = JsonSerializer.Serialize(searchData); objList = await _apiHelper.GetDataListByParamsAsync <AntibioticDTO>("antibiotic_api/Get_List", searchJson); return(objList); }
public async Task <AntibioticDTO> SaveDataAsync(AntibioticDTO 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 <AntibioticDTO>("antibiotic_api/Post_SaveData", model); return(menua); }
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 AntibioticDTO Post_SaveData([FromBody] AntibioticDTO model) { var objReturn = _service.SaveData(model); return(objReturn); }
public IEnumerable <AntibioticDTO> Get_List_Active_ByModel([FromBody] AntibioticDTO searchModel) { var objReturn = _service.GetList_Active_WithModel(searchModel); return(objReturn); }