protected void btnSearch_Click(object sender, EventArgs e)
{
DataAccessUsingProc dac = new DataAccessUsingProc();
DataTable dt1 = dac.selectProducts();
GridView1.DataSource = dt1;
GridView1.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
int sd = Convert.ToInt32(txtSupl.Text);
string nam = txtName.Text;
int qt = Convert.ToInt32(txtQty.Text);
decimal pric = Convert.ToDecimal(txtPrice.Text);
DataAccessUsingProc dac = new DataAccessUsingProc();
if (dac.InsertProducts(nam, pric, qt, sd))
lblMsg.Text = "New Product Inserted into Inventory..";
else
lblMsg.Text = "Product Not Inserted..";
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int pid = Convert.ToInt32(txtID.Text);
DataAccessUsingProc dac = new DataAccessUsingProc();
if (dac.DeleteProducts(pid))
{
lblMsg.Text="Product Removed for list..";
}
else
{
lblMsg.Text = "Product Not Removed,,, check your connection.!!!";
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
int pid = Convert.ToInt32(txtPid.Text);
DataAccessUsingProc dac = new DataAccessUsingProc();
SqlDataReader reader= dac.EditProductForUpdate(pid);
while (reader.Read())
{
txtName.Text = reader.GetString(1);
txtPrice.Text = reader.GetValue(2).ToString();
txtQty.Text = reader.GetInt32(3).ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int pid = Convert.ToInt32(txtPid.Text);
string nam = txtName.Text;
decimal pric = Convert.ToDecimal(txtPrice.Text);
int qt = Convert.ToInt32(txtQty.Text);
DataAccessUsingProc dac = new DataAccessUsingProc();
if (dac.UpdateProducts(pid, nam, pric, qt))
{
lblMsg.Text="Data Update Successfully..";
}
else
{
lblMsg.Text = "Fail.!!!,,,,, Not Updated..";
}
}
