public APP_INS_PROD GetProductByID([FromBody] JObject _objData)
{
APP_INS_PROD result = new APP_INS_PROD();
try
{
using (var dbConn = Pixel.Core.Dapper.My.ConnectionFactory())
{
dbConn.ConnectionString = connectionSQL;
dbConn.Open();
result = dbConn.QueryFirstOrDefault <APP_INS_PROD>("SELECT * FROM APP_INS_PROD WHERE ID = " + _objData["ID"]);
return(result);
}
}
catch (Exception)
{
return(result);
}
}
public string SaveProduct([FromBody] JObject _objData)
{
string _result = "";
try
{
APP_INS_PROD product = _objData["ProductData"].ToObject <APP_INS_PROD>();
using (var dbConn = Pixel.Core.Dapper.My.ConnectionFactory())
{
dbConn.ConnectionString = connectionSQL;
dbConn.Open();
if (product.id > 0)
{
_result = product.id.ToString();
dbConn.Execute(@"UPDATE APP_INS_PROD SET
INS_ID = @INS_ID,
PROD_BACK_COLOR = @PROD_BACK_COLOR,
PROD_DESC_AR = @PROD_DESC_AR,
PROD_DESC_COLOR = @PROD_DESC_COLOR,
PROD_DESC_EN = @PROD_DESC_EN,
PROD_DESC_FONT_SIZE = @PROD_DESC_FONT_SIZE,
PROD_DESC_FR = @PROD_DESC_FR,
PROD_ID = @PROD_ID,
PROD_ORDER = @PROD_ORDER,
BOX_HEIGHT = @BOX_HEIGHT,
FULL_INFO_PATH = @FULL_INFO_PATH,
PROD_TEXT_AR = @PROD_TEXT_AR,
PROD_TEXT_COLOR = @PROD_TEXT_COLOR,
PROD_TEXT_EN = @PROD_TEXT_EN,
PROD_TEXT_FONT_SIZE = @PROD_TEXT_FONT_SIZE,
PROD_TEXT_FR = @PROD_TEXT_FR
WHERE ID = @ID",
new
{
product.id,
product.ins_id,
product.prod_back_color,
product.prod_desc_ar,
product.prod_desc_color,
product.prod_desc_en,
product.prod_desc_font_size,
product.prod_desc_fr,
product.prod_id,
product.prod_order,
product.box_height,
product.full_info_path,
product.prod_text_ar,
product.prod_text_color,
product.prod_text_en,
product.prod_text_font_size,
product.prod_text_fr
});
}
else
{
_result = dbConn.Insert(new APP_INS_PROD
{
ins_id = product.ins_id,
prod_back_color = product.prod_back_color,
prod_desc_ar = product.prod_desc_ar,
prod_desc_color = product.prod_desc_color,
prod_desc_en = product.prod_desc_en,
prod_desc_font_size = product.prod_desc_font_size,
prod_desc_fr = product.prod_desc_fr,
prod_id = product.prod_id,
prod_order = product.prod_order,
box_height = product.box_height,
full_info_path = product.full_info_path,
prod_text_ar = product.prod_text_ar,
prod_text_color = product.prod_text_color,
prod_text_en = product.prod_text_en,
prod_text_font_size = product.prod_text_font_size,
prod_text_fr = product.prod_text_fr
}).ToString();
}
}
return(_result);
}
catch (Exception ex)
{
return(DataHelper.GetDataErrorMessage(-1, ex.Message, ex.InnerException));
}
}
