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");
}
