public int AddProduct(Product123 P)
{
SqlConnection con = new SqlConnection("server=intvmsql01;user id=pj01test01;password=tcstvm;database=db01test01");
con.Open();
SqlCommand cmd = new SqlCommand("sp_insertproduct1349205_1", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pn", P.Pname);
cmd.Parameters.AddWithValue("@c", P.Cat);
cmd.Parameters.AddWithValue("@u", P.Up);
cmd.Parameters.AddWithValue("@t", P.Tna);
cmd.Parameters.AddWithValue("@desc", P.Desc);
cmd.Parameters.AddWithValue("@sid", 0);
cmd.Parameters["@sid"].Direction = ParameterDirection.Output;
int rowaffected = cmd.ExecuteNonQuery();
if (rowaffected > 0)
{
int pid = Convert.ToInt32(cmd.Parameters["@sid"].Value);
return(pid);
}
else
{
return(0);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string pname = TextBox1.Text;
string cat = DropDownList1.SelectedItem.Value;
double up = Double.Parse(TextBox2.Text);
int tna = Convert.ToInt32(TextBox3.Text);
string desc = TextBox4.Text;
Product123 P = new Product123(pname, up, tna, cat, desc);
Productado pado = new Productado();
int sid = pado.AddProduct(P);
Label1.Text = "Your Product Id is-" + sid;
GridView1.DataSource = pado.ViewProduct();
GridView1.DataBind();
}
