public string SaveMenu([FromBody] JObject _objData) { string _result = ""; try { APP_MENU menu = _objData["MenuData"].ToObject <APP_MENU>(); using (var dbConn = Pixel.Core.Dapper.My.ConnectionFactory()) { dbConn.ConnectionString = connectionSQL; dbConn.Open(); dbConn.Execute(@"UPDATE APP_MENU SET IMAGE_HEIGHT = @IMAGE_HEIGHT, IMAGE_PATH = @IMAGE_PATH, IMAGE_WIDTH = @IMAGE_WIDTH, MENU_BACK_COLOR = @MENU_BACK_COLOR, MENU_DESC_AR = @MENU_DESC_AR, MENU_DESC_COLOR = @MENU_DESC_COLOR, MENU_DESC_EN = @MENU_DESC_EN, MENU_DESC_FONT_SIZE = @MENU_DESC_FONT_SIZE, MENU_DESC_FR = @MENU_DESC_FR, MENU_TEXT_AR = @MENU_TEXT_AR, MENU_TEXT_COLOR = @MENU_TEXT_COLOR, MENU_TEXT_EN = @MENU_TEXT_EN, MENU_TEXT_FONT_SIZE = @MENU_TEXT_FONT_SIZE, MENU_TEXT_FR = @MENU_TEXT_FR, NEED_OTP = @NEED_OTP WHERE ID = @ID", new { menu.id, menu.image_height, menu.image_path, menu.image_width, menu.menu_back_color, menu.menu_desc_ar, menu.menu_desc_color, menu.menu_desc_en, menu.menu_desc_font_size, menu.menu_desc_fr, menu.menu_text_ar, menu.menu_text_color, menu.menu_text_en, menu.menu_text_font_size, menu.menu_text_fr, menu.need_otp }); } return(_result); } catch (Exception ex) { return(DataHelper.GetDataErrorMessage(-1, ex.Message, ex.InnerException)); } }
public APP_MENU GetMenuByID([FromBody] JObject _objData) { APP_MENU result = new APP_MENU(); try { using (var dbConn = Pixel.Core.Dapper.My.ConnectionFactory()) { dbConn.ConnectionString = connectionSQL; dbConn.Open(); result = dbConn.QueryFirstOrDefault <APP_MENU>("SELECT * FROM APP_MENU WHERE ID = " + _objData["ID"]); return(result); } } catch (Exception) { return(result); } }
private void FixupAPP_MENU(APP_MENU previousValue) { if (previousValue != null && previousValue.APP_ROL_MENU.Contains(this)) { previousValue.APP_ROL_MENU.Remove(this); } if (APP_MENU != null) { if (!APP_MENU.APP_ROL_MENU.Contains(this)) { APP_MENU.APP_ROL_MENU.Add(this); } if (IdMenu != APP_MENU.IdMenu) { IdMenu = APP_MENU.IdMenu; } } }