protected void InsertRecord(object sender, EventArgs e) { SqlDataSource2.Insert(); //Response.Redirect("CreateOrder.aspx"); string connStr = ConfigurationManager.ConnectionStrings["myConnectionAd"].ConnectionString; SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand("Select_Orders_Staging", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); GrdTransaction_Staging.DataSource = dt; GrdTransaction_Staging.DataBind(); if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } }
protected void CompleteTransaction(object sender, EventArgs e) { if (ChekBoxCONFIRM.Checked == false) { //Alert Box Script Code Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please Confirm Your Order is Correct by clicking the Check Box!');</script>"); } else if (ChekBoxCONFIRM.Checked == true) { string connStr = ConfigurationManager.ConnectionStrings["myConnectionAd"].ConnectionString; SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand("Complete_Transaction", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); GrdTransaction_Staging.DataSource = dt; GrdTransaction_Staging.DataBind(); if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } //Alert Box Script Code Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Order Entry Complete!');</script>"); //Clear Both Gridviews Create Data Refresh Function and call at PageLoad, Add to Cart, and Comp0lete transaction // call function Response.Redirect("CreateOrder.aspx"); } }
protected void BtnClearCart_Click(object sender, EventArgs e) { //Call Clear_Shopping_Cart PROCEDURE string connStr = ConfigurationManager.ConnectionStrings["myConnectionAd"].ConnectionString; SqlConnection conn = new SqlConnection(connStr); conn.Open(); SqlCommand cmd = new SqlCommand("Clear_All_Cart_Staging", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); GrdTransaction_Staging.DataSource = dt; GrdTransaction_Staging.DataBind(); if (conn != null && conn.State == System.Data.ConnectionState.Open) { conn.Close(); } //Call Refresg Gridviews Methods for both Gridviews // RefreshGridviewData(); Response.Redirect("CreateOrder.aspx"); }