public Cart LoadCart(long cart_id)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetCMEDShopShoppingCart";
cmd.Parameters.AddWithValue("@cart_id", cart_id);
DataTable dt = db.Execute(cmd);
DataRow dr = dt.Rows[0];
Cart cart = new Cart
{
cart_id = long.Parse(dr["cart_id"].ToString()),
customer_id = long.Parse(dr["customer_id"].ToString()),
order_status = dr["order_status"].ToString(),
email = dr["email"].ToString(),
first_name = dr["first_name"].ToString(),
last_name = dr["last_name"].ToString(),
order_amount = double.Parse(dr["order_amount"].ToString()),
ip_address = dr["ip_address"].ToString(),
ip_address_country_code = dr["ip_address_country_code"].ToString(),
active = Boolean.Parse(dr["active"].ToString()),
date_created = DateTime.Parse(dr["date_created"].ToString()),
created_by = dr["created_by"].ToString(),
date_updated = DateTime.Parse(dr["date_updated"].ToString()),
updated_by = dr["updated_by"].ToString(),
};
DB dbItems = new DB();
SqlCommand cmdItems = new SqlCommand();
cmdItems.CommandType = CommandType.StoredProcedure;
cmdItems.CommandText = "GetCMEDShopCartItems";
cmdItems.Parameters.AddWithValue("@cart_id", cart_id);
DataTable dtItems = dbItems.Execute(cmdItems);
foreach (DataRow drItems in dtItems.Rows)
{
CartItem cartitem = new CartItem
{
cart_item_id = long.Parse(drItems["cart_item_id"].ToString()),
cart_id = long.Parse(drItems["cart_id"].ToString()),
product_id = long.Parse(drItems["product_id"].ToString()),
product_title = drItems["product_title"].ToString(),
quantity = Int32.Parse(drItems["quantity"].ToString()),
price = double.Parse(drItems["price"].ToString()),
final_price = double.Parse(drItems["final_price"].ToString()),
discount_code = drItems["discount_code"].ToString(),
date_created = DateTime.Parse(drItems["date_created"].ToString()),
created_by = drItems["created_by"].ToString(),
date_updated = DateTime.Parse(drItems["date_updated"].ToString()),
updated_by = drItems["updated_by"].ToString(),
};
cart.CartItems.Add(cartitem);
cart.order_amount = cart.order_amount + cartitem.final_price;
}
return cart;
}
private void CartDataBind()
{
try
{
cart = controller.LoadCart(ShoppingCartID);
gvShoppingCart.DataSource = cart.CartItems;
gvShoppingCart.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
