public static void Load()
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"select * from tip_iznajmljivanja";
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet ds = new DataSet();
sqlDA.Fill(ds, "tipoviIznajmljivanja");
//Console.WriteLine(ds.GetXml());
foreach (DataRow row in ds.Tables["tipoviIznajmljivanja"].Rows)
{
TipIznajmljivanja ti = new TipIznajmljivanja();
ti.Id = (long)row["ID"];
ti.Naziv = (string)row["NAZIV"];
Aplikacija.Instanca.hotel.tipoviIznajmljivanja.Add(ti);
}
}
}
public void PretragaPoTipu(TipIznajmljivanja ti)
{
using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"select * from iznajmljivanje where tip_iznajmljivanja_id = @id";
cmd.Parameters.Add(new SqlParameter("@id", ti.Id));
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet ds = new DataSet();
sqlDA.Fill(ds, "iznajmljivanja");
}
}