public dynamic GetProductCategories(GetProductsCategoriesInputModel data) { using (var con = new SqlConnection(configuration.GetValue <string>("ConnectionString:SQLConnection"))) { try { var dbParams = new DynamicParameters(); con.Open(); dbParams.Add("@Id", data.Id); var reader = con.Query <dynamic>( sql: "[dbo].[GetProductCategoriesById]", param: dbParams, commandType: CommandType.StoredProcedure); return(reader); } catch (Exception ex) { throw ex; } finally { con.Close(); } } }
public dynamic GetProductCategoriesService(GetProductsCategoriesInputModel data) { return(_ProductRepository.GetProductCategories(data)); }
public IActionResult GetProductCategories(GetProductsCategoriesInputModel data) { return(Ok(_productService.GetProductCategoriesService(data))); }