public APP_INS GetInsByID([FromBody] JObject _objData)
{
APP_INS result = new APP_INS();
try
{
using (var dbConn = Pixel.Core.Dapper.My.ConnectionFactory())
{
dbConn.ConnectionString = connectionSQL;
dbConn.Open();
result = dbConn.QueryFirstOrDefault <APP_INS>("SELECT * FROM APP_INS WHERE ID = " + _objData["ID"]);
return(result);
}
}
catch (Exception)
{
return(result);
}
}
public string SaveIns([FromBody] JObject _objData)
{
string _result = "";
try
{
APP_INS ins = _objData["InsData"].ToObject <APP_INS>();
using (var dbConn = Pixel.Core.Dapper.My.ConnectionFactory())
{
dbConn.ConnectionString = connectionSQL;
dbConn.Open();
if (ins.id > 0)
{
_result = ins.id.ToString();
dbConn.Execute(@"UPDATE APP_INS SET
IMAGE_HEIGHT = @IMAGE_HEIGHT,
IMAGE_PATH = @IMAGE_PATH,
IMAGE_WIDTH = @IMAGE_WIDTH,
INS_BACK_COLOR = @INS_BACK_COLOR,
INS_DESC_AR = @INS_DESC_AR,
INS_DESC_COLOR = @INS_DESC_COLOR,
INS_DESC_EN = @INS_DESC_EN,
INS_DESC_FONT_SIZE = @INS_DESC_FONT_SIZE,
INS_DESC_FR = @INS_DESC_FR,
INS_ORDER = @INS_ORDER,
INS_TEXT_AR = @INS_TEXT_AR,
INS_TEXT_COLOR = @INS_TEXT_COLOR,
INS_TEXT_EN = @INS_TEXT_EN,
INS_TEXT_FONT_SIZE = @INS_TEXT_FONT_SIZE,
INS_TEXT_FR = @INS_TEXT_FR
WHERE ID = @ID",
new
{
ins.id,
ins.image_height,
ins.image_path,
ins.image_width,
ins.ins_back_color,
ins.ins_desc_ar,
ins.ins_desc_color,
ins.ins_desc_en,
ins.ins_desc_font_size,
ins.ins_desc_fr,
ins.ins_order,
ins.ins_text_ar,
ins.ins_text_color,
ins.ins_text_en,
ins.ins_text_font_size,
ins.ins_text_fr
});
}
else
{
_result = dbConn.Insert(new APP_INS
{
image_height = ins.image_height,
image_path = ins.image_path,
image_width = ins.image_width,
ins_back_color = ins.ins_back_color,
ins_desc_ar = ins.ins_desc_ar,
ins_desc_color = ins.ins_desc_color,
ins_desc_en = ins.ins_desc_en,
ins_desc_font_size = ins.ins_desc_font_size,
ins_desc_fr = ins.ins_desc_fr,
ins_order = ins.ins_order,
ins_text_ar = ins.ins_text_ar,
ins_text_color = ins.ins_text_color,
ins_text_en = ins.ins_text_en,
ins_text_font_size = ins.ins_text_font_size,
ins_text_fr = ins.ins_text_fr
}).ToString();
}
}
return(_result);
}
catch (Exception ex)
{
return(DataHelper.GetDataErrorMessage(-1, ex.Message, ex.InnerException));
}
}
