private static void PrepareCommand(SqlCommand command, Strelba Strelba) { command.Parameters.AddWithValue("@idStr", Strelba.idStr); command.Parameters.AddWithValue("@Zacatek", Strelba.Zacatek); command.Parameters.AddWithValue("@Konec", Strelba.Konec); command.Parameters.AddWithValue("@Zbran_idZbr", Strelba.Zbran_idZbr); command.Parameters.AddWithValue("@Zamestnanec_idZam", Strelba.Zamestnanec_idZam); command.Parameters.AddWithValue("@Zakaznik_idZak", Strelba.Zakaznik_idZak); command.Parameters.AddWithValue("@Prostor_idSpr", Strelba.Prostor_idSpr); }
public static int update(Strelba Strelba) { Database db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_UPDATE); PrepareCommand(command, Strelba); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
private static Collection <Strelba> Read(SqlDataReader reader, bool withItemsCount = false) { Collection <Strelba> strelby = new Collection <Strelba>(); while (reader.Read()) { Strelba strelba = new Strelba(); int i = -1; strelba.idStr = reader.GetInt32(++i); strelba.Zacatek = reader.GetDateTime(++i); strelba.Konec = reader.GetDateTime(++i); strelba.Zbran_idZbr = reader.GetInt32(++i); strelba.Zamestnanec_idZam = reader.GetInt32(++i); strelba.Zakaznik_idZak = reader.GetInt32(++i); strelba.Prostor_idSpr = reader.GetInt32(++i); strelby.Add(strelba); } return(strelby); }
public static Strelba select(int idStr) { Database db = new Database(); db.Connect(); SqlCommand command = db.CreateCommand(SQL_SELECT_ID); command.Parameters.AddWithValue("@idStr", idStr); SqlDataReader reader = db.Select(command); Collection <Strelba> strelby = Read(reader); Strelba strelba = null; if (strelby.Count == 1) { strelba = strelby[0]; } reader.Close(); db.Close(); return(strelba); }
static void StrTest() { Strelba str = new Strelba { idStr = 1, Zacatek = new DateTime(2018, 10, 10, 16, 10, 0), Konec = new DateTime(2018, 10, 10, 17, 30, 0), Zamestnanec_idZam = 2, Zakaznik_idZak = 2, Zbran_idZbr = 2, Prostor_idSpr = 2 }; Console.WriteLine("Testovani funkce Strelba Insert - Vypis poctu prvku - update - select - delete - Vypis poctu prvku.\n" + str.Zacatek); StrelbaTable.insert(str); int count = StrelbaTable.select().Count; str.Zacatek = str.Zacatek.AddMinutes(10); StrelbaTable.update(str); str.Zacatek = str.Zacatek.AddMinutes(10); Console.WriteLine("#C: " + count); str = StrelbaTable.select(1); Console.WriteLine(str.Zacatek); StrelbaTable.clean(); count = StrelbaTable.select().Count; Console.WriteLine("#C: " + count + "\n" + "Test pro tabulku Strelba ukoncen, stisknutim libovolne klavesy ukoncite aplikaci."); Console.ReadKey(); }