public int Add(Orderbo O)
{
SqlConnection con = new SqlConnection("server= intvmsql01; user id= pj01tms55_1718;password=tcstvm ; database=db01tms55_1718");
con.Open();
SqlCommand cmd = new SqlCommand("sp_insert1349205_2", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@itemname", O.Itemname);
cmd.Parameters.AddWithValue("@qn", O.Quantityneeded);
cmd.Parameters.AddWithValue("@tp", O.Total);
cmd.Parameters.AddWithValue("@cname", O.Customername);
cmd.Parameters.AddWithValue("@con", O.Contact);
cmd.Parameters.AddWithValue("@e", O.Email);
cmd.Parameters.AddWithValue("@od", DateTime.Now);
cmd.Parameters.AddWithValue("@oid", 0);
cmd.Parameters["@oid"].Direction = ParameterDirection.Output;
int ra = cmd.ExecuteNonQuery();
if (ra > 0)
{
int oid = Convert.ToInt32(cmd.Parameters["@oid"].Value);
return(oid);
}
else
{
return(0);
}
}
public List <Orderbo> View()
{
SqlConnection con = new SqlConnection("server= intvmsql01; user id= pj01tms55_1718;password=tcstvm ; database=db01tms55_1718");
con.Open();
SqlCommand cmd = new SqlCommand("sp_view1349205", con);
cmd.CommandType = CommandType.StoredProcedure;
List <Orderbo> list = new List <Orderbo>();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Orderbo O = new Orderbo();
O.Orderid = Convert.ToInt32(reader["orderid"]);
O.Itemname = reader["ItemName"].ToString();
O.Quantityneeded = Convert.ToInt32(reader["QuantityNeeded"]);
O.Total = Convert.ToInt32(reader["TotalPrice"]);
O.Customername = reader["CustomerName"].ToString();
O.Contact = Convert.ToInt64(reader["Contact"]);
O.Email = reader["Email"].ToString();
O.Orderdate = Convert.ToDateTime(reader["OrderDate"]);
O.Mandate = Convert.ToDateTime(reader["ManufacturingDate"]);
list.Add(O);
}
return(list);
}
protected void Button1_Click(object sender, EventArgs e)
{
string itemname = TextBox1.Text;
int qn = Convert.ToInt32(TextBox2.Text);
string custname = TextBox3.Text;
long mobno = Convert.ToInt64(TextBox4.Text);
string email = TextBox5.Text;
int total = 0;
Orderdal d = new Orderdal();
Item iobj = d.itemDetails(itemname);
Response.Write("<script>alert('Item Price is" + iobj.ItemPrice + "')</script>");
total = (Convert.ToInt32(iobj.ItemPrice) * qn);
if (iobj.Quantity < qn)
{
Response.Write("<script>alert('This quantity is not available for this item. Max available is " + iobj.Quantity + "')</script>");
}
else
{
tp.Text = "" + total;
Orderbo o = new Orderbo(itemname, qn, custname, mobno, email, total);
int o_id = d.Add(o);
if (o_id > 0)
{
oid.Text = "" + o_id;
}
}
}
