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