protected void DesignGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label Did = DesignGrid.Rows[e.RowIndex].FindControl("lblDesignId") as Label;
Label Dname = DesignGrid.Rows[e.RowIndex].FindControl("lblDesignName") as Label;
TextBox Dstylename = DesignGrid.Rows[e.RowIndex].FindControl("txtStyleName") as TextBox;
TextBox Pprice = DesignGrid.Rows[e.RowIndex].FindControl("txtPrice") as TextBox;
FileUpload fuPhoto = DesignGrid.Rows[e.RowIndex].FindControl("image") as FileUpload;
if (fuPhoto.FileName != "")
{
SqlCommand cmd = new SqlCommand("Update Design set DesignName=@Dname,StyleName=@Dstylename, Images=@img, Price=@price where DesignId=@Did", con);
cmd.Parameters.AddWithValue("@Did", Did.Text);
cmd.Parameters.AddWithValue("@Dname", Dname.Text);
cmd.Parameters.AddWithValue("@Dstylename", Dstylename.Text);
cmd.Parameters.AddWithValue("@price", Pprice.Text);
fuPhoto.SaveAs(Server.MapPath("~/images/") + Path.GetFileName(fuPhoto.FileName));
String Image = "../images/" + Path.GetFileName(fuPhoto.FileName);
cmd.Parameters.AddWithValue("@img", Image);
con.Open();
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
DesignGrid.EditIndex = -1;
DesignGrid.DataSource = dt;
DesignGrid.DataBind();
con.Close();
}
else
{
SqlCommand cmd = new SqlCommand("Update Design set DesignName=@Dname,StyleName=@Dstylename, Price=@price where DesignId=@Did", con);
cmd.Parameters.AddWithValue("@Did", Did.Text);
cmd.Parameters.AddWithValue("@Dname", Dname.Text);
cmd.Parameters.AddWithValue("@Dstylename", Dstylename.Text);
cmd.Parameters.AddWithValue("@price", Pprice.Text);
con.Open();
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
DesignGrid.EditIndex = -1;
DesignGrid.DataSource = dt;
DesignGrid.DataBind();
con.Close();
}
FillGridView();
}
protected void DesignGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label DesignId = DesignGrid.Rows[e.RowIndex].FindControl("lblDesignId") as Label;
SqlCommand cmd = new SqlCommand("delete from Design where DesignId= @DesignId", con);
cmd.Parameters.AddWithValue("@DesignId", DesignId.Text);
con.Open();
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
DesignGrid.EditIndex = -1;
DesignGrid.DataSource = dt;
DesignGrid.DataBind();
con.Close();
FillGridView();
}
public void FillGridView()
{
SqlCommand cmd = new SqlCommand("SELECT Design.DesignId,Product.ProductId,Design.DesignName,Design.StyleName,Design.Price,Design.Images FROM Design LEFT JOIN Product ON Design.ProductId = Product.ProductId where Design.DesignName=@DesignName And Product.ProductId=@ProductId", con);
con.Open();
cmd.Parameters.AddWithValue("@ProductId", drpModel.SelectedValue);
cmd.Parameters.AddWithValue("@DesignName", drpSubModel.SelectedValue);
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
DesignGrid.DataSource = dt;
DesignGrid.DataBind();
con.Close();
}
