public ColumnConfigDTO GetData(string tbc_code) { log.MethodStart(); ColumnConfigDTO objModel = new ColumnConfigDTO(); using (var trans = _db.Database.BeginTransaction()) { try { var objReturn1 = _db.TBConfigs.FirstOrDefault(x => x.tbc_mnu_code == tbc_code); if (objReturn1 != null) { objModel = _mapper.Map <ColumnConfigDTO>(objReturn1); } trans.Commit(); } catch (Exception ex) { // TODO: Handle failure trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objModel); }
public async Task <ColumnConfigDTO> GetDataAsync(string mnu_Id) { ColumnConfigDTO objModel = new ColumnConfigDTO(); objModel = await _apiHelper.GetDataByIdAsync <ColumnConfigDTO>("columnconfig_api/Get_Data", mnu_Id); return(objModel); }
public async Task <ColumnConfigDTO> SaveDataAsync(ColumnConfigDTO model) { ColumnConfigDTO objModel = new ColumnConfigDTO(); objModel = await _apiHelper.PostDataAsync <ColumnConfigDTO>("columnconfig_api/Post_SaveData", model); return(objModel); }
public ColumnConfigDTO SaveData(ColumnConfigDTO model) { log.MethodStart(); var currentDateTime = DateTime.Now; var currentUser = ""; ColumnConfigDTO objReturn = new ColumnConfigDTO(); using (var trans = _db.Database.BeginTransaction()) { try { var objModel = new TBConfig(); if (model.tbc_status == "E") { objModel = _db.TBConfigs.FirstOrDefault(x => x.tbc_id == model.tbc_id); } if (model.tbc_status == "N") { objModel = _mapper.Map <TBConfig>(model); objModel.tbc_status = objModel.tbc_active == true ? "A" : "I"; objModel.tbc_createdate = currentDateTime; currentUser = objModel.tbc_createuser; _db.TBConfigs.Add(objModel); } else if (model.tbc_status == "E") { objModel.tbc_column_name = model.tbc_column_name; objModel.tbc_column_label = model.tbc_column_label; objModel.tbc_column_placeholder = model.tbc_column_placeholder; objModel.tbc_required_field = model.tbc_required_field; objModel.tbc_edit = model.tbc_edit; objModel.tbc_active = model.tbc_active; objModel.tbc_status = objModel.tbc_active == true ? "A" : "I"; objModel.tbc_updateuser = model.tbc_updateuser; objModel.tbc_updatedate = currentDateTime; currentUser = objModel.tbc_updateuser; //_db.TCMenus.Update(objModel); } #region Save Log Process ... _db.LogProcesss.Add(new LogProcess() { log_usr_id = currentUser, log_mnu_id = "", log_mnu_name = "ColumnConfig", log_tran_id = objModel.tbc_mnu_code, log_action = (model.tbc_status == "N" ? "New" : "Update"), log_desc = (model.tbc_status == "N" ? "New" : "Update") + " ColumnConfig " + objModel.tbc_mnu_code + ":" + objModel.tbc_column_name, log_createuser = currentUser, log_createdate = currentDateTime }); #endregion _db.SaveChanges(); trans.Commit(); } catch (Exception ex) { // TODO: Handle failure log.Error(ex); trans.Rollback(); } finally { trans.Dispose(); } } log.MethodFinish(); return(objReturn); }
public ColumnConfigDTO Post_SaveData([FromBody] ColumnConfigDTO model) { var objReturn = _service.SaveData(model); return(objReturn); }