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