private bool AddItemToCart(int title_id, string sku, int quantity, out AddResponse result)
{
result = AddResponse.Failure;
bool success = false; //Duncan Working
CartDB db = new CartDB();
DataSet ds = db.CartProductGetBySKU(sku);
if (ds == null) return false;
bool is_bulk = false, is_student = false;
using (DataTableReader data = ds.CreateDataReader())
{
while (data.Read())
{
is_bulk = data.GetInt32(data.GetOrdinal("IsBulk")) == 1;
is_student = data.GetInt32(data.GetOrdinal("IsStudent")) == 1;
break;
}
}
if (is_bulk)
{
result |= AddResponse.Bulk;
return false;
}
success = db.CartAddSKU(CurrentCart.CartId, sku, quantity);
if (success)
{
result = AddResponse.Success;
}
if (is_student)
{
result |= AddResponse.Student;
}
return success;
}
private DataTable BuildDataSource(CartItem[] items)
{
DataTable dt = CreateDataSource();
CartDB db = new CartDB();
foreach (CartItem item in items)
{
string title = "", pubname = "", puburl = "";
DataSet ds = db.CartProductGetBySKU(item.ProductSKU);
if (ds != null)
{
using (DataTableReader dtr = ds.CreateDataReader())
{
while (dtr.Read())
{
title = Helper.IsString(dtr.GetValue(dtr.GetOrdinal("Title")), "");
pubname = Helper.IsString(dtr.GetValue(dtr.GetOrdinal("PubName")), "");
puburl = Helper.IsString(dtr.GetValue(dtr.GetOrdinal("PubUrl")), "");
}
dtr.Close();
}
}
DataRow row = dt.NewRow();
row["CartItemId"] = item.CartItemId;
row["ProductTitleId"] = item.ProductTitleId;
row["ProductSKU"] = item.ProductSKU;
row["Title"] = "<a href=\"product.aspx?p=" + item.ProductTitleId + "&s=" + item.ProductSKU + "\">" + title + "</a>";
completeNames += title + "|";
row["PubName"] = pubname;
row["PubURL"] = puburl;
row["Quantity"] = item.Quantity;
completeQty += item.Quantity.ToString()+"|";
row["UnitPrice"] = item.UnitPrice;
row["SubTotal"] = item.SubTotal;
row["UnitPriceDollar"] = Helper.Dollar(item.UnitPrice);
row["SubTotalDollar"] = Helper.Dollar(item.SubTotal);
dt.Rows.Add(row);
}
dt.AcceptChanges();
return dt;
}