public ProductsDS.CategoriesRow GetCategory(string CategoryName, int ParentId)
{
ProductsDS.CategoriesDataTable cats = _GetCategories(string.Format("Name='{0}' and ParentId={1}",
StringUtils.SQLEncode(CategoryName), ParentId));
if (cats.Count > 0)
{
return((ProductsDS.CategoriesRow)cats.Rows[0]);
}
return(null);
}
public ProductsDS.CategoriesRow GetCategory(string CategoryName)
{
ProductsDS.CategoriesDataTable cats = _GetCategories(string.Format("Name='{0}' or Title='{0}'", StringUtils.SQLEncode(CategoryName)));
if (cats.Count > 0)
{
DataView dv = cats.DefaultView;
dv.Sort = "SortingOrder ASC";
return((ProductsDS.CategoriesRow)dv[0].Row);
}
return(null);
}
public ProductsDS.CategoriesRow GetCategory(int CategoryId)
{
ProductsDS.CategoriesDataTable cats = _GetCategories(string.Format("CategoryId={0}", CategoryId));
if (cats.Rows.Count > 0)
{
DataView dv = cats.DefaultView;
dv.Sort = "SortingOrder ASC";
return((ProductsDS.CategoriesRow)dv[0].Row);
}
return(null);
}
