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); }