private static void PrepareCommand(SqlCommand command, Rezervace Rezervace)
{
command.Parameters.AddWithValue("@idRez", Rezervace.idRez);
command.Parameters.AddWithValue("@datumVytvoreni", Rezervace.datumVytvoreni);
command.Parameters.AddWithValue("@datumStrelby", Rezervace.datumStrelby);
command.Parameters.AddWithValue("@Zakaznik_idZak", Rezervace.Zakaznik_idZak);
command.Parameters.AddWithValue("@Prostor_idSpr", Rezervace.Prostor_idSpr);
command.Parameters.AddWithValue("@Zbran_idZbr", Rezervace.Zbran_idZbr);
}
public static int update(Rezervace Rezervace)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_UPDATE);
PrepareCommand(command, Rezervace);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
public static int insert(Rezervace Rezervace) // procedura 6.f. kontrola dostupnosti ybrane a strelneho prostoru
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_INSERT);
PrepareCommand(command, Rezervace);
int ret = db.ExecuteNonQuery(command);
db.Close();
return(ret);
}
static void RezTest()
{
Rezervace rez = new Rezervace
{
idRez = 1,
datumVytvoreni = DateTime.Today,
datumStrelby = new DateTime(2014, 10, 10),
Zakaznik_idZak = 2,
Zbran_idZbr = 2,
Prostor_idSpr = 2
};
Console.WriteLine("Testovani funkce Rezervace Insert - Vypis poctu prvku - update - select - delete - Vypis poctu prvku.\n"
+ rez.datumStrelby);
RezervaceTable.insert(rez);
int count = RezervaceTable.select().Count;
rez.datumStrelby = rez.datumStrelby.AddDays(3);
RezervaceTable.update(rez);
rez.datumStrelby = rez.datumStrelby.AddDays(3);
Console.WriteLine("#C: " + count);
rez = RezervaceTable.select(1);
RezervaceTable.StrelbaDleRezervace(1, 20, 2);
Console.WriteLine(rez.datumStrelby);
RezervaceTable.clean();
count = RezervaceTable.select().Count;
Console.WriteLine("#C: " + count + "\n" + "Test pro tabulku rezervace ukoncen, stisknutim libovolne klavesy pokracujte k dalsimu testu.");
Console.ReadKey();
}
private static Collection <Rezervace> Read(SqlDataReader reader, bool withItemsCount = false)
{
Collection <Rezervace> mrezervace = new Collection <Rezervace>();
while (reader.Read())
{
Rezervace rezervace = new Rezervace();
int i = -1;
rezervace.idRez = reader.GetInt32(++i);
rezervace.datumVytvoreni = reader.GetDateTime(++i);
rezervace.datumStrelby = reader.GetDateTime(++i);
rezervace.Zakaznik_idZak = reader.GetInt32(++i);
rezervace.Prostor_idSpr = reader.GetInt32(++i);
rezervace.Zbran_idZbr = reader.GetInt32(++i);
mrezervace.Add(rezervace);
}
return(mrezervace);;
}
public static Rezervace select(int idRez)
{
Database db = new Database();
db.Connect();
SqlCommand command = db.CreateCommand(SQL_SELECT_ID);
command.Parameters.AddWithValue("@idRez", idRez);
SqlDataReader reader = db.Select(command);
Collection <Rezervace> mrezervace = Read(reader);
Rezervace rezervace = null;
if (mrezervace.Count == 1)
{
rezervace = mrezervace[0];
}
reader.Close();
db.Close();
return(rezervace);
}