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;
}
}
}
