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; } } }