public cylinder_class extract() { if (get_count() != 0) { cylinder_class cyl = new cylinder_class(); SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=egas;Integrated Security=True;Pooling=False"); SqlDataAdapter da = new SqlDataAdapter("select * from cylinder_at_company", con); DataSet ds = new DataSet(); da.Fill(ds, "cylinder_at_company"); int ct = 0; foreach (DataRow dr in ds.Tables[0].Rows) { if ((dr[2].ToString() == "FULL") && (int.Parse(dr[4].ToString()) == 0)) { cyl._id = int.Parse(dr[0].ToString()); cyl._status = dr[2].ToString(); cyl._use_count = int.Parse(dr[3].ToString()); cyl._dealer_id = 0; ct++; if (ct == 1) break; } } return cyl; } else { return new cylinder_class(); } }
public void insert(cylinder_class c,int id) { SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=egas;Integrated Security=True;Pooling=False"); SqlCommand cmd = new SqlCommand("insert into cylinder_at_dealer values (@var1,@var2,@var3,@var4,@var5)", con); con.Open(); cmd.Parameters.AddWithValue("@var1", c._id ); cmd.Parameters.AddWithValue("@var2", DateTime.Today); cmd.Parameters.AddWithValue("@var3", "FULL"); cmd.Parameters.AddWithValue("@var4", c._use_count); cmd.Parameters.AddWithValue("@var5", id); cmd.ExecuteNonQuery(); con.Close(); }