hey, im working on this code for an assignment and cant seem to get it to work, can anyone help me? Its full of intentional errors, but i cant seem to work them all outI've got half of them, just the otha half. Just a pain cos im learning C# while i do this.
Source below:
Code:<%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Data" %> <html> <head> <title>I170 Ecommerce Shopping Cart</title> <script runat="server" language="c#"> OleDbConnection objConn = new OleDbConnection(""); OleDbDataAdapter objDA; DataSet objDS = newDataSet(); DataRow objCartDT; void Page_Load() { if (!IsPostBack) { objDA = new OleDbDataAdapter("SELECT * FROM EmployeeStore", objConn); objDA.Fill(objDS, "Store"); dlItems.DataSource = objDS; dlItems.DataBind(); pnlShowCart.Visible = false; } objCartDT = (DataTable)Session["Cart"]; if (objCartDT == null) { objCartDT = new DataTable("Cart"); objCartDT.Columns.Add("CartID", typeof(Int32)); objCartDT.Columns["CartID"].AutoIncrement = true; objCartDT.Columns["CartID"].AutoIncrementSeed = 1; objCartDT.Columns.Add("ItemID", typeof(Int32)); objCartDT.Columns.Add("Quantity", typeof(Int32)); objCartDT.Columns.Add("Item", typeof(string)); objCartDT.Columns.Add("Cost", typeof(Decimal)); Session["Cart"] = objCartDT; } } } void AddToCart(Object s, DataListCommandEventArgs e) { pnlShowItems.Visible = false; pnlShowCart.Visible = true; int ItemID = Convert.ToInt32( dlItems.DataKeys[e.Item.ItemIndex]); DataSet objItemInfo = FindItem(ItemID); objDR = objCartDT.NewRow(); objDR["ItemID"] = ItemID; objDR["Item"] = objItemInfo.Tables["ItemInfo"].Rows[0]["ItemName"]; objDR["Quantity"] = 1; objDR["Cost"] = objItemInfo.Tables["ItemInfo"].Rows[0]["Cost"]; objCartDT.Rows.Add(objDR); dgCart.DataSource = objCartDT; dgCart.DataBind(); } } if (!blnMatch){ objDR = objCartDT.NewRow(); objDR["ItemID"] = ItemID; objDR["Item"] = objItemInfo.Tables["ItemInfo"].Rows[0]["ItemName"]; objDR["Quantity"] = 1; objDR["Cost"] = objItemInfo.Tables["ItemInfo"].Rows[0]["Cost"]; objCartDT.Rows.Add(objDR); } dgCart.DataSource = objCartDT; dgCart.DataBind(); lblTotal.Text = "$" + GetItemTotal(); } DataSet FindItem(int ItemID){ DataSet objItemInfo = new DataSet(); objDA = new OleDbDataAdapter("SELECT * FROM products WHERE ItemID=" + ItemID, objConn); objDA.Fill(objItemInfo, "ItemInfo"); return objItemInfo; } Decimal GetItemTotal() { decimal decRunningTotal = 0; foreach (DataRow objDR in objCartDT.Rows) { decRunningTotal += Decimal.Round(Convert.ToDecimal(objDR["Cost"]) * Convert.ToInt32(objDR["Quantity"]), 2); } return decRunningTotal; } void dgCart_Edit(Object s, DataGridCommandEventArgs e) { dgCart.EditItemIndex = e.Item.ItemIndex; dgCart.DataSource = objCartDT; dgCart.DataBind(); } void dgCart_Cancel(Object s, DataGridCommandEventArgs e) { dgCart.EditItemIndex = -1; dgCart.DataSource = objCartDT; dgCart.DataBind(); } void dgCart_Update(object s, DataGridCommandEventArgs e) { TextBox txtQuantity; int intCartID; intCartID = Convert.ToInt32(dgCart.DataKeys[e.Item.ItemIndex]); txtQuantity = (TextBox)e.Item.FindControl("txtQuantity"); foreach (DataRow objDR in objCartDT.Rows){ if (intCartID == (int)objDR["CartID"]){ objDR["Quantity"] = Convert.ToInt32(txtQuantity.Text); break; } } lblTotal.Text = "$" + GetItemTotal(); dgCart.EditItemIndex = -1; dgCart.DataSource = objCartDT; dgCart.DataBind(); } void dgCart_Delete(Object s, DataGridCommandEventArgs e){ objCartDT.Rows[e.Item.ItemIndex].Delete(); dgCart.DataSource = objCartDT; dgCart.DataBind(); lblTotal.Text = "$" + GetItemTotal(); } void ContinueShopping(Object s, EventArgs e){ pnlShowCart.Visible = false; pnlShowCart.Visible = true; } void CheckOut(Object s, EventArgs e){ String cartBusiness = "[email protected]"; String cartProduct; int cartQuantity; Decimal cartCost; int itemNumber = 1; cartBusiness = Server.UrlEncode(cartBusiness); String strPayPal = "https://www.paypal.com/cgi-bin/webscr?cmd=_cart&upload=1&business=" + cartBusiness; foreach (DataRow objDR in objCartDT.Rows){ cartProduct = Server.UrlEncode((String)objDR["Item"]); cartQuantity = (int)objDR["Quantity"]; cartCost = (Decimal)objDR["Cost"]; strPayPal += "&Item_name_" + itemNumber + "=" + cartProduct; strPayPal += "&Item_number_" + itemNumber + "=" + cartQuantity; strPayPal += "&amount_" + itemNumber + "=" + Decimal.Round(cartQuantity * cartCost, 2); itemNumber++; } Response.Redirect(strPayPal); } </script> </head> <body> <form runat="server"> <table width="100%" border="0" cellspacing="0" cellpadding="10"> <tr> <td valign="top" width="160"> <td valign="top"> <asp:Panel id="pnlShowItems" runat="server"> <h1>I170 Shopping Cart Assignment</h1> <asp:DataList id="dlItems" runat="server" DataKeyField="ItemID" OnEditCommand="AddToCart"> <ItemTemplate> <table width="400" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="200" valign="top" align="center"> <img src='<%# DataBinder.Eval(Container.DataItem, "ImageURL") %>' /> </td> <td width="200"> <strong><%# DataBinder.Eval(Container.DataItem, "ItemName") %></strong><br /> Cost: $<%# DataBinder.Eval(COntainer.DataItem, "Cost") %><br /><br /> <asp:Button id="btnAddToCart" runat="server" Text="Add To Cart" CommandName="Edit" /> </td> </tr> <tr> <td colspan="2" width="400"><hr noshade height="1" /></td> </tr> </table> </ItemTemplate> </asp:DataList> </asp:Panel> <asp:Panel id="pnlShowCart" runat="server"> <h1>View Cart</h1> <asp:DataGrid id="dgCart" runat="server" AutoGenerateColumns="false" GridLines="None" CellPadding="3" Width="100%" DataKeyField="CartID" OnCancelCommand="dgCart_Cancel" OnDeleteCommand="dgCart_Delete" OnEditCommand="dgCart_Edit" OnUpdateCommand="dgCart_Update"> <HeaderStyle Font-Name="arial" Backcolor="#003366" Forecolor="#FFFFFF" Font-Bold="true" Font-Size="10" /> <ItemStyle Font-Name="arial" Font-Size="10" /> <Columns> <asp:EditCommandColumn EditText="Change Quantity" CancelText="Cancel" UpdateText="Update" /> <asp:ButtonColumn ButtonType="LinkButton" CommandName="Delete" Text="Remove" /> <asp:BoundColumn DataField="Item" HeaderText="Product Name" ReadOnly="true" /> <asp:TemplateColumn HeaderText="Quantity"> <ItemTemplate> <%# DataBinder.Eval(container.DataItem, "Quantity") %> </ItemTemplate> <EditItemTemplate> <asp:TextBox id="txtQuantity" Text='<%# DataBinder.Eval(Container.DataItem, "Quantity") %>' runat="server" Width="50" /> </EditItemTemplate> </asp:TemplateColumn> </Columns> </asp:DataGrid> <p align="right"><strong>Total: <asp:Label id="lblTotal" runat="server" /></strong></p> <p align="right"><asp:LinkButton id="lbContinue" Text="Continue Shopping" runat="server" OnClick="Continue Shopping" /> <asp:LinkButton id="lbCheckOut" Text="Checkout" runat="server" OnClick="CheckOut" /></p> </asp:Panel> </td> </tr> </table> </form> </html>
