public static CartItem[] GetCartItemsByCartID(int cart_id)
{
List<CartItem> items = new List<CartItem>();
CartDB db = new CartDB();
DataSet ds = db.CartGetAllItems(cart_id);
if (ds != null)
{
using (DataTableReader data = ds.CreateDataReader())
{
while (data.Read())
{
int cartitemid = data.GetInt32(data.GetOrdinal("CartContentsId"));
int cartid = data.GetInt32(data.GetOrdinal("CartId"));
int producttitleid = data.GetInt32(data.GetOrdinal("ProductTitleId"));
string productsku = data.GetString(data.GetOrdinal("ProductSKU"));
int quantity = data.GetInt32(data.GetOrdinal("Quantity"));
decimal unitprice = data.GetDecimal(data.GetOrdinal("UnitPrice"));
decimal subtotal = data.GetDecimal(data.GetOrdinal("SubTotal"));
int linenumber = data.GetInt32(data.GetOrdinal("LineNumber"));
bool is_student = (int)data.GetValue(data.GetOrdinal("IsStudent")) == 1;
bool is_bulk = (int)data.GetValue(data.GetOrdinal("IsBulk")) == 1;
DateTime datecreated = data.GetDateTime(data.GetOrdinal("DateCreated"));
DateTime lastupdated = data.GetDateTime(data.GetOrdinal("LastUpdated"));
CartItem item = new CartItem(cartitemid, cartid, producttitleid, productsku, quantity, unitprice, subtotal, linenumber,is_bulk, is_student, datecreated, lastupdated);
items.Add(item);
}
}
}
return items.ToArray();
}
