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