public dynamic InsertProductCategories(ProductCategoriesInsertInputModel data) { using (var con = new SqlConnection(configuration.GetValue <string>("ConnectionString:SQLConnection"))) { try { var dbParams = new DynamicParameters(); con.Open(); dbParams.Add("@item", Newtonsoft.Json.JsonConvert.SerializeObject(data)); var reader = con.Query <dynamic>( sql: "[dbo].[ProductCategoriesInsertProcedure]", param: dbParams, commandType: CommandType.StoredProcedure); return(reader); } catch (Exception ex) { throw ex; } finally { con.Close(); } } }
public dynamic InsertProductCategoriesService(ProductCategoriesInsertInputModel data) { return(_ProductRepository.InsertProductCategories(data)); }
public IActionResult InsertProductCategories(ProductCategoriesInsertInputModel data) { return(Ok(_productService.InsertProductCategoriesService(data))); }