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();
}
private void OnMouseDown()
{
designGrid = transform.parent.gameObject.transform.parent.gameObject.GetComponent <DesignGrid>();
submarine = GameObject.Find("submarine");
designGrid.current_cell = this.gameObject;
Debug.Log("Putting down a block: " + designGrid.current_block);
if (designGrid.current_block == null || (this_current_block != null && this_current_block == designGrid.current_block))
{
Destroy(block);
this_current_block = null;
}
else
{
if (block != null)
{
Destroy(block);
}
block = (GameObject)Instantiate(Resources.Load("prefab/" + designGrid.current_block + "_part"), GetComponent <Transform>().position, GetComponent <Transform>().rotation);
block.transform.parent = submarine.transform;
this_current_block = designGrid.current_block;
targetRotation = block.transform.rotation;
}
}
void Start()
{
designGrid = GetComponentInParent <Pallet>().designGrid;
}
