public int Insert(BLL.Cart c)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "INSERT INTO Cart (NAME, IMAGE, PRICE, QUANTITY,TOTAL,Username)" +
"VALUES (@paraName,@paraImage,@paraPrice,@paraQuantity,@paraTotal,@paraUsername)";
int result = 0; // Execute NonQuery return an integer value
SqlCommand sqlCmd = new SqlCommand(sqlStmt, myConn);
sqlCmd.Parameters.AddWithValue("@paraName", c.Name);
sqlCmd.Parameters.AddWithValue("@paraImage", c.Image);
sqlCmd.Parameters.AddWithValue("@paraPrice", c.Price);
sqlCmd.Parameters.AddWithValue("@paraQuantity", c.Quantity);
sqlCmd.Parameters.AddWithValue("@paraTotal", c.Total);
sqlCmd.Parameters.AddWithValue("@paraUsername", c.Username);
myConn.Open();
result = sqlCmd.ExecuteNonQuery();
myConn.Close();
return(result);
}
public int Delete(BLL.Cart c)
{
int result = 0;
SqlCommand sqlCmd = new SqlCommand();
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
// Step 2 - Instantiate SqlCommand instance to add record
// with INSERT statement
string sqlStmt = "DELETE Cart where Id = @paraID ";
sqlCmd = new SqlCommand(sqlStmt, myConn);
// Step 3 : Add each parameterised variable with value
sqlCmd.Parameters.AddWithValue("@paraID", c.Id);
//sqlCmd.Parameters.AddWithValue("@paraName", up.Name);
//sqlCmd.Parameters.AddWithValue("@paraDesc", up.Desc);
//sqlCmd.Parameters.AddWithValue("@paraPrice", up.Price);
// Step 4 Open connection the execute NonQuery of sql command
myConn.Open();
result = sqlCmd.ExecuteNonQuery();
// Step 5 :Close connection
myConn.Close();
return(result);
}
private void BindCartList()
{
List <Model.Cart> cartList = new BLL.Cart().GetModelList(CurrentUser.Id);
if (cartList.Count < 1)
{
Response.Redirect("/BookList.aspx");
return;
}
StringBuilder sb = new StringBuilder();
decimal totalMoney = 0;
foreach (Model.Cart cartModel in cartList)
{
sb.Append("<tr class=\"align_Center\">");
sb.Append("<td style=\"PADDING-BOTTOM: 5px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 5px\">" + cartModel.Book.Id + "</td>");
sb.Append("<td class=align_Left><a onmouseover=\"\" onmouseout=\"\" onclick=\"\" href='#' target=\"_blank\" >" + cartModel.Book.Title + "</a></td>");
sb.Append("<td><span class=\"price\">￥" + cartModel.Book.UnitPrice.ToString("0.00") + "</span></td>");
sb.Append("<td>" + cartModel.Count + "</td></tr>");
totalMoney = totalMoney + (cartModel.Count * cartModel.Book.UnitPrice);
}
StrHtml = sb.ToString();
TotalMoney = totalMoney;
}
override protected void OnLoad(EventArgs e)
{
// Create an instance of the cart controller
ProcessFlow.CartController cartController = new ProcessFlow.CartController();
// Fetch the cart state from the controller
myCart = cartController.GetCart(false);
// If there is something in the cart then show the continue button
link.Visible = myCart.Count > 0;
}
private void GetProductList(string products)
{
if (!string.IsNullOrEmpty(products))
{
BLL.Cart cart = new BLL.Cart();
string productInfoAppend = "";
string[] items = products.Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string item in items)
{
string[] subItems = item.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (string.IsNullOrEmpty(subItems[0]))
{
continue;
}
cart.Add(subItems[0]);
//nIdAppend += string.Format("'{0}',", subItems[0]);
//Model.CartItemInfo model = new Model.CartItemInfo();
//model.Quantity = int.Parse(subItems[1]);
//model.Subtotal = decimal.Parse(subItems[2]);
////productInfoAppend += string.Format("<td>{1}</td><td>{0}</td>", subItems[1], subItems[2]);
}
//if (!string.IsNullOrEmpty(nIdAppend))
//{
// nIdAppend = nIdAppend.Trim(',');
// if (bll == null) bll = new BLL.OrderInfo();
// List<Model.Product> list = bll.GetProductInIds(nIdAppend);
// if (list != null)
// {
// foreach (Model.Product model in list)
// {
// productInfoAppend += string.Format("<tr><td>{1}</td><td>{0}</td>{2}</tr>",model.ProductName,model.PNum,productInfoAppend);
// }
// }
//}
foreach (Model.CartItemInfo model in cart.CartItems)
{
productInfoAppend += string.Format("<tr><td><a href=\"../../Shares/ShowProduct.aspx?nId={3}\" target=\"_blank\">{0}</a> </td><td>{1}</td><td>{2}</td></tr>", model.ProductName, model.Subtotal, model.Quantity, model.ProductId);
}
if (rpData.Items.Count > 0)
{
Literal ltrProducts = rpData.Items[0].FindControl("ltrProducts") as Literal;
if (ltrProducts != null)
{
ltrProducts.Text = productInfoAppend;
}
}
}
}
public List <BLL.Cart> SelectAll()
{
//Step 1 - Define a connection to the database by getting
// the connection string from web.config
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
//Step 2 - Create a DataAdapter to retrieve data from the database table
string sqlStmt = "Select * from Cart";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
//Step 3 - Create a DataSet to store the data to be retrieved
DataSet ds = new DataSet();
//Step 4 - Use the DataAdapter to fill the DataSet with data retrieved
da.Fill(ds);
//Step 5 - Read data from DataSet to List
List <BLL.Cart> cList = new List <BLL.Cart>();
int rec_cnt = ds.Tables[0].Rows.Count;
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i]; // Sql command returns only one record
//string idStr = row["Id"].ToString();
//int id = Convert.ToInt32(idStr);
string name = row["NAME"].ToString();
string image = row["IMAGE"].ToString();
string quantityStr = row["QUANTITY"].ToString();
int quantity = Convert.ToInt32(quantityStr);
string price = row["PRICE"].ToString();
//double price = Convert.ToDouble(priceStr);
BLL.Cart obj = new BLL.Cart(name, image, quantity, price);
cList.Add(obj);
}
return(cList);
}
/// <summary>
/// A method to return the current state of the cart
/// </summary>
/// <param name="create">Specifies whether a cart should be created if one does not exist</param>
/// <returns>Cart object</returns>
public Cart GetCart(bool create)
{
// Fetch the cart object from session state
BLL.Cart myCart = (BLL.Cart)HttpContext.Current.Session[CART_KEY];
if (myCart == null)
{
if (create)
{
myCart = new BLL.Cart();
}
else
{
HttpContext.Current.Server.Transfer(URL_NOCART);
return(null);
}
}
return(myCart);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
//1.判断用户是否登陆
Model.Users userModel = new BLL.Users().GetModel(context.Request.Cookies["cp1"].Value);
if (Common.WebHelper.CheckCookie(userModel) == false)
{
context.Response.Write("no");
return;
}
//2.检查该商品数据库中是否存在
int bookId = int.Parse(context.Request["bookId"] ?? "0");
Model.Books book = new BLL.Books().GetModel(bookId);
if (book == null)
{
context.Response.Write("no");
return;
}
//3.将商品添加到购物车
Model.Users user = (Model.Users)context.Session["userInfo"];
BLL.Cart cartServer = new BLL.Cart();
Model.Cart cart = cartServer.GetCart(user.Id, bookId);
if (cart != null)
{
cart.Count++;
cartServer.Update(cart);
}
else
{
cart = new Model.Cart();
cart.Count = 1;
cart.Book = book;
cart.User = user;
cartServer.Add(cart);
}
context.Response.Write("OK");
}
/// <summary>
/// A method to purchase the contents of the cart
/// </summary>
/// <returns>Order object with information about the new Order</returns>
public OrderInfo PurchaseCart()
{
// Fetch the cart from session
BLL.Cart myCart = (BLL.Cart)HttpContext.Current.Session[CART_KEY];
// Make some checks on the cart
if ((myCart == null) || (myCart.Count == 0))
{
HttpContext.Current.Server.Transfer(URL_NOCART);
//HttpContext.Current.Response.Redirect(URL_NOCART, false);
return(null);
}
else
{
// Build up the order
OrderInfo newOrder = new OrderInfo();
newOrder.UserId = ((AccountInfo)HttpContext.Current.Session[ACCOUNT_KEY]).UserId;
newOrder.CreditCard = (CreditCardInfo)HttpContext.Current.Session[CREDITCARD_KEY];
newOrder.BillingAddress = (AddressInfo)HttpContext.Current.Session[BILLING_KEY];
newOrder.ShippingAddress = (AddressInfo)HttpContext.Current.Session[SHIPPING_KEY];
newOrder.LineItems = (LineItemInfo[])myCart.GetOrderLineItems().ToArray();
newOrder.OrderTotal = myCart.Total;
newOrder.Date = DateTime.Now;
// Send the order to the middle tier
OrderInsertBO order = new OrderInsertBO();
newOrder.OrderId = order.Insert(newOrder);
// clear the session objects used
HttpContext.Current.Session[CART_KEY] = null;
HttpContext.Current.Session[CREDITCARD_KEY] = null;
HttpContext.Current.Session[BILLING_KEY] = null;
HttpContext.Current.Session[SHIPPING_KEY] = null;
return(newOrder);
}
}
override protected void OnLoad(EventArgs e)
{
// Create an instance of the cart controller
ProcessFlow.CartController cartController = new ProcessFlow.CartController();
myCart = cartController.GetCart(true);
if (!Page.IsPostBack)
{
// Get the itemdId from the query string
string itemId = Request["itemId"];
if (itemId != null)
{
// Clean the input string
itemId = WebComponents.CleanString.InputText(itemId, 50);
myCart.Add(itemId);
cartController.StoreCart(myCart);
}
}
//Get an account controller
ProcessFlow.AccountController accountController = new ProcessFlow.AccountController();
//Get the user's favourite category
string favCategory = accountController.GetFavouriteCategory();
//If we have a favourite category, render the favourites list
if (favCategory != null)
{
favorites.Visible = true;
ViewState[KEY_CATEGORY] = favCategory;
}
Refresh();
}
/// <summary>
/// A method to return the current state of the cart
/// </summary>
/// <param name="create">Specifies whether a cart should be created if one does not exist</param>
/// <returns>Cart object</returns>
public void StoreCart(BLL.Cart cart)
{
// Store the cart object in session state
HttpContext.Current.Session[CART_KEY] = cart;
}
