public List <Category> GetCategories()
{
DataTable dtbl = GetDataTable("spGetCategory");
List <Category> categories = dtbl.DataTableToList <Category>();
return(categories);
}
public List <ShoppingCart> GetShoppingCart(string username)
{
List <SqlParameter> sqlParams = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@Username", username);
sqlParams.Add(param);
DataTable dtbl = GetDataTable("spGetShoppingCart", sqlParams);
List <ShoppingCart> shoppingCarts = dtbl.DataTableToList <ShoppingCart>();
return(shoppingCarts);
}
public List <Product> GetProducts(int categoryID, string sortColumn)
{
string sql = "select * from Products where CategoryID=" + categoryID;
if (!string.IsNullOrEmpty(sortColumn))
{
sql += " Order by " + sortColumn;
}
DataTable dtbl = GetDataTable(sql);
List <Product> products = dtbl.DataTableToList <Product>();
return(products);
}