public dynamic UpdateProductCategories(ProductCategoriesUpdateInputModel 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].[ProductCategoriesUpdateProcedure]",
param: dbParams,
commandType: CommandType.StoredProcedure);
return(reader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
}
public dynamic UpdateProductCategoriesService(ProductCategoriesUpdateInputModel data)
{
return(_ProductRepository.UpdateProductCategories(data));
}
public IActionResult UpdateProductCategories(ProductCategoriesUpdateInputModel data)
{
return(Ok(_productService.UpdateProductCategoriesService(data)));
}
