protected void Grdproduct_Adding(object sender, GridViewCommandEventArgs e)
{
//int productid = int.Parse(e.Row.Cells[0].Text);
if (e.CommandName == "Select")
{
int rowindx = Convert.ToInt32(e.CommandArgument);
GridViewRow row = Grdproduct.Rows[rowindx];
int productid = int.Parse(row.Cells[0].Text);
string productname = row.Cells[1].Text;
var qua = row.FindControl("txtgrdqunty") as TextBox;
string quantity = qua.Text;
decimal price = decimal.Parse(row.Cells[3].Text);
//int rowindx = Convert.ToInt32(e.CommandArgument);
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
//SqlCommand cmd = new SqlCommand("insert into Ecart_Cart_h values (@productid,@productname,@quantiy,@price,@username)", con);
SqlCommand cmd = new SqlCommand("AddCart_devp", con);
cmd.Parameters.AddWithValue("@productid", productid);
cmd.Parameters.AddWithValue("@productname", productname);
cmd.Parameters.AddWithValue("@quantiy", qua.Text);
cmd.Parameters.AddWithValue("@price", price);
cmd.Parameters.AddWithValue("@username", Session["Username"]);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@city", txtcity.Text);
cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Added to cart')</script>");
//string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con1 = new SqlConnection(constr);
con1.Open();
SqlCommand cmd1 = new SqlCommand("CartDetails_devp", con1);
cmd1.Parameters.AddWithValue("@username", Session["Username"]);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
GridCart.DataSource = dt1;
GridCart.DataBind();
}
}
//string productname = (string)Grdproduct.DataKeys[index].values["ProductName"];
}
protected void Grdcart_delete(object sender, GridViewCommandEventArgs e)
{
//int productid = int.Parse(e.Row.Cells[0].Text);
if (e.CommandName == "Remove")
{
int rowindx = Convert.ToInt32(e.CommandArgument);
GridViewRow row = Grdproduct.Rows[rowindx];
int productid = int.Parse(row.Cells[0].Text);
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand("delete from Ecart_Cart_h where ProductId=@productid and Username=@username", con);
//SqlCommand cmd = new SqlCommand("AddCart_devp", con);
cmd.Parameters.AddWithValue("@productid", productid);
cmd.Parameters.AddWithValue("@username", Session["Username"]);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@city", txtcity.Text);
cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('Removed from cart successfully')</script>");
//string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con1 = new SqlConnection(constr);
con1.Open();
SqlCommand cmd1 = new SqlCommand("CartDetails_devp", con1);
cmd1.Parameters.AddWithValue("@username", Session["Username"]);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
GridCart.DataSource = dt1;
GridCart.DataBind();
}
else
{
DataTable empdt = new DataTable();
GridCart.DataSource = empdt;
GridCart.DataBind();
}
}
//string productname = (string)Grdproduct.DataKeys[index].values["ProductName"];
}
protected void Gridbind()
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand("select * from Ecart_Product_h", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Grdproduct.DataSource = dt;
Grdproduct.DataBind();
}
SqlConnection con1 = new SqlConnection(constr);
con1.Open();
SqlCommand cmd1 = new SqlCommand("CartDetails_devp", con1);
cmd1.Parameters.AddWithValue("@username", Session["Username"]);
cmd1.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataTable dt1 = new DataTable();
da1.Fill(dt1);
if (dt1.Rows.Count > 0)
{
GridCart.DataSource = dt1;
GridCart.DataBind();
}
else
{
DataTable empdt = new DataTable();
GridCart.DataSource = empdt;
GridCart.DataBind();
}
}