//Checkout Button (only visible if gridview has data) protected void btnCheckout_Click(object sender, EventArgs e) { shoppingCart = (ArrayList)Session["ShoppingCart"]; JavaScriptSerializer js = new JavaScriptSerializer(); APICalls api = new APICalls(); SPCaller spc = new SPCaller(); Customer c = new Customer(); c.Email = Session["Username"].ToString(); c.CustomerID = spc.GetCustomerIDByEmail(c.Email); //Adding each product into the database foreach (Product p in shoppingCart) { //String jsonCheckout = js.Serialize(p); try { bool data = api.RecordPurchase(url, p.ID.ToString(), p.Quantity, "1", "0", DateTime.Now.ToString(), DateTime.Now.TimeOfDay.ToString(), c); if (data == true) { Response.Redirect("Confirmation.aspx", false); } else { lblMessage.Text = "A problem occurred while checking out."; } } catch (Exception ex) { lblMessage.Text = "Error: " + ex.Message; } } }
protected void Session_End(object sender, EventArgs e) { if (Session["ShoppingCart"] != null) { ArrayList cart = (ArrayList)Session["ShoppingCart"]; BinaryFormatter serializer = new BinaryFormatter(); MemoryStream memStream = new MemoryStream(); serializer.Serialize(memStream, cart); byte[] cartBytes = memStream.ToArray(); SPCaller spc = new SPCaller(); DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_StoreCart"; int custID = spc.GetCustomerIDByEmail(Session["Username"].ToString()); objCommand.Parameters.AddWithValue("@CustomerID", custID); objCommand.Parameters.AddWithValue("@Cart", cartBytes); objDB.DoUpdateUsingCmdObj(objCommand); } if (Session["WishList"] != null) { ArrayList wishList = (ArrayList)Session["WishList"]; BinaryFormatter serializer = new BinaryFormatter(); MemoryStream memStream = new MemoryStream(); serializer.Serialize(memStream, wishList); byte[] wlBytes = memStream.ToArray(); SPCaller spc = new SPCaller(); DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_StoreWishList"; int custID = spc.GetCustomerIDByEmail(Session["Username"].ToString()); objCommand.Parameters.AddWithValue("@CustomerID", custID); objCommand.Parameters.AddWithValue("@WishList", wlBytes); objDB.DoUpdateUsingCmdObj(objCommand); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["Username"] == null) { Response.Redirect("Login.aspx"); return; } string email = Session["Username"].ToString(); customerID = spc.GetCustomerIDByEmail(email); ddlMonth.SelectedValue = currMonth; ddlYear.SelectedValue = currYear; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Username"] == null) { Response.Redirect("Login.aspx"); return; } else { string username = Session["Username"].ToString(); customerID = spc.GetCustomerIDByEmail(username); if (!IsPostBack) { myDS = spc.GetCCByCustomerID(customerID); if (myDS.Tables[0].Rows.Count > 0) { for (int i = 0; i < myDS.Tables[0].Rows.Count; i++) { ddlCard.Items.Add(myDS.Tables[0].Rows[i][1].ToString()); } int cardID = int.Parse(ddlCard.SelectedValue); myDS = spc.GetCCInfoByCardID(cardID); if (myDS.Tables[0].Rows.Count > 0) { txtCardNumber.Text = myDS.Tables[0].Rows[0][0].ToString(); string expiration = myDS.Tables[0].Rows[0][1].ToString(); string[] arrExpiration = expiration.Split('/'); ddlMonth.SelectedValue = arrExpiration[0].Trim(); ddlYear.SelectedValue = arrExpiration[1].Trim(); } } } } }
protected void btnEmpty_Click(object sender, EventArgs e) { gvCart.DataSource = new DataTable(); gvCart.DataBind(); Session.Remove("WishList"); Response.Redirect("EmptyWishList.aspx", false); DBConnect objDB = new DBConnect(); SPCaller spc = new SPCaller(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_EmptyWishList"; int custID = spc.GetCustomerIDByEmail(Session["Username"].ToString()); objCommand.Parameters.AddWithValue("@CustomerID", custID); objCommand.Parameters.Add("@New", SqlDbType.VarBinary, -1); objCommand.Parameters["@New"].Value = DBNull.Value; objDB.DoUpdateUsingCmdObj(objCommand); }
protected void btnLogin_Click(object sender, EventArgs e) { string username; string password; username = txtEmail.Text; password = txtPassword.Text; DBConnect db = new DBConnect(); DataSet ds = new DataSet(); SqlCommand objcommand = new SqlCommand(); //if dropdown selection is Customer if (ddlLoginType.Text == "Customer") { objcommand.CommandType = CommandType.StoredProcedure; objcommand.CommandText = "TP_CustomerLogin"; objcommand.Parameters.AddWithValue("@username", username); objcommand.Parameters.AddWithValue("@password", password); ds = db.GetDataSetUsingCmdObj(objcommand); if (ds.Tables[0].Rows.Count == 0) { lblLoginErrorMessage.Text = "Incorrect username or password"; } else { if (chkbxRememberMe.Checked == true) { Response.Cookies["Username"].Value = txtEmail.Text; Response.Cookies["Password"].Value = txtPassword.Text; Response.Cookies["Username"].Expires = DateTime.Now.AddDays(15); Response.Cookies["Password"].Expires = DateTime.Now.AddDays(15); } else { Response.Cookies["Username"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1); } Session["AccountType"] = 0; Session["Username"] = username; Session["Password"] = password; //check if customer already has cart in db SPCaller spc = new SPCaller(); DBConnect objDB = new DBConnect(); SqlCommand objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_GetCart"; int custID = spc.GetCustomerIDByEmail(Session["Username"].ToString()); objCommand.Parameters.AddWithValue("@CustomerID", custID); DataSet myDS = objDB.GetDataSetUsingCmdObj(objCommand); if (myDS.Tables[0].Rows[0][0] != System.DBNull.Value) { byte[] cartBytes = (byte[])myDS.Tables[0].Rows[0][0]; BinaryFormatter deserializer = new BinaryFormatter(); MemoryStream ms = new MemoryStream(cartBytes); ArrayList shoppingCart = (ArrayList)deserializer.Deserialize(ms); Session["ShoppingCart"] = shoppingCart; } objCommand = new SqlCommand(); objCommand.CommandType = CommandType.StoredProcedure; objCommand.CommandText = "TP_GetWishList"; objCommand.Parameters.AddWithValue("@CustomerID", custID); myDS = objDB.GetDataSetUsingCmdObj(objCommand); if (myDS.Tables[0].Rows[0][0] != System.DBNull.Value) { byte[] wlBytes = (byte[])myDS.Tables[0].Rows[0][0]; BinaryFormatter deserializer = new BinaryFormatter(); MemoryStream ms = new MemoryStream(wlBytes); ArrayList wishList = (ArrayList)deserializer.Deserialize(ms); Session["WishList"] = wishList; } Response.Redirect("CustomerHome.aspx"); } } //if dropdown selection is Merchant if (ddlLoginType.Text == "Merchant") { objcommand.CommandType = CommandType.StoredProcedure; objcommand.CommandText = "TP_MerchantLogin"; objcommand.Parameters.AddWithValue("@username", username); objcommand.Parameters.AddWithValue("@password", password); ds = db.GetDataSetUsingCmdObj(objcommand); if (ds.Tables[0].Rows.Count == 0) { lblLoginErrorMessage.Text = "Incorrect username or password"; } else { if (chkbxRememberMe.Checked == true) { Response.Cookies["Username"].Value = txtEmail.Text; Response.Cookies["Password"].Value = txtPassword.Text; Response.Cookies["Username"].Expires = DateTime.Now.AddDays(15); Response.Cookies["Password"].Expires = DateTime.Now.AddDays(15); } else { Response.Cookies["Username"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1); } Session["AccountType"] = 1; Session["Username"] = username; Session["Password"] = password; Response.Redirect("MerchantHome.aspx", false); } } }