public List <ExpertRuleDTO> GetListWithModel(ExpertRuleDTO searchModel) { log.MethodStart(); List <ExpertRuleDTO> objList = new List <ExpertRuleDTO>(); //var searchModel = JsonSerializer.Deserialize<MenuSearchDTO>(param); using (var trans = _db.Database.BeginTransaction()) { try { objList = _db.ExpertRuleDTOs.FromSqlRaw <ExpertRuleDTO>("sp_GET_TCExpertRule {0}", searchModel.exr_mst_code).ToList(); //objList = _mapper.Map<List<ExpertRuleDTO>>(objDataList); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objList); }
public string CheckDuplicate(ExpertRuleDTO model) { log.MethodStart(); string objReturn = ""; using (var trans = _db.Database.BeginTransaction()) { try { var objResult = _db.TCExpertRoles.Any(x => x.exr_code == model.exr_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 ExpertRuleDTO GetData(string exr_code) { log.MethodStart(); ExpertRuleDTO objModel = new ExpertRuleDTO(); using (var trans = _db.Database.BeginTransaction()) { try { var objReturn1 = _db.TCExpertRoles.FirstOrDefault(x => x.exr_code == exr_code); objModel = _mapper.Map <ExpertRuleDTO>(objReturn1); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objModel); }
public ExpertRuleDTO Post_SaveData([FromBody] ExpertRuleDTO model) { var objReturn = _service.SaveData(model); //var objReturn = _service.GetList(); return(objReturn); }
public async Task <ExpertRuleDTO> GetDataAsync(string mst_code) { ExpertRuleDTO menu = new ExpertRuleDTO(); menu = await _apiHelper.GetDataByIdAsync <ExpertRuleDTO>("expertrule_api/Get_Data", mst_code); return(menu); }
public async Task <List <ExpertRuleDTO> > GetListByModelActiveAsync(ExpertRuleDTO searchData) { List <ExpertRuleDTO> objList = new List <ExpertRuleDTO>(); objList = await _apiHelper.GetDataListByModelAsync <ExpertRuleDTO, ExpertRuleDTO>("expertrule_api/Get_List_Active_ByModel", searchData); return(objList); }
public async Task <List <ExpertRuleDTO> > GetListByParamAsync(ExpertRuleDTO searchData) { List <ExpertRuleDTO> objList = new List <ExpertRuleDTO>(); var searchJson = JsonSerializer.Serialize(searchData); objList = await _apiHelper.GetDataListByParamsAsync <ExpertRuleDTO>("expertrule_api/Get_List", searchJson); return(objList); }
public async Task <ExpertRuleDTO> SaveDataAsync(ExpertRuleDTO 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 <ExpertRuleDTO>("expertrule_api/Post_SaveData", model); return(menua); }
public IEnumerable <ExpertRuleDTO> Get_List_Active_ByModel([FromBody] ExpertRuleDTO searchModel) { var objReturn = _service.GetList_Active_WithModel(searchModel); 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); }