private void AddFirefighter(Firefighter firefighter) { Firefighters.Add(firefighter); using (con = new SQLiteConnection(connectionString)) { con.Open(); try { using (SQLiteCommand insertSQL = con.CreateCommand()) { insertSQL.CommandText = "INSERT INTO Strazacy(IdStraz, NazwiskoStraz, ImieStraz, PeselStraz, TelefonStraz, StopienStraz, DataUrodzenia, DataDolaczenia) VALUES (@id,@lastname,@firstname,@pesel,@phone,@degree,@birthdate,@joindate)"; insertSQL.Parameters.Add(new SQLiteParameter("@id", SqlDbType.Int) { Value = firefighter.Id }); insertSQL.Parameters.AddWithValue("@lastname", firefighter.LastName); insertSQL.Parameters.AddWithValue("@firstname", firefighter.FirstName); insertSQL.Parameters.AddWithValue("@pesel", firefighter.Pesel); insertSQL.Parameters.AddWithValue("@phone", firefighter.Phone); insertSQL.Parameters.AddWithValue("@degree", firefighter.Degree); insertSQL.Parameters.AddWithValue("@birthdate", firefighter.BirthDate); insertSQL.Parameters.AddWithValue("@joindate", firefighter.JoinDate); insertSQL.ExecuteNonQuery(); } con.Close(); } catch (Exception ex) { MessageBox.Show("Błąd połączenia z bazą: " + ex); } } }
private void LoadFirefighters() { SQLiteCommand sql_cmd; sql_cmd = con.CreateCommand(); sql_cmd.CommandText = "SELECT * FROM Strazacy"; sql_cmd.CommandType = CommandType.Text; SQLiteDataReader r = sql_cmd.ExecuteReader(); while (r.Read()) { Firefighters.Add(new Firefighter(Int32.Parse(r["IdStraz"].ToString()), r["NazwiskoStraz"].ToString(), r["ImieStraz"].ToString(), r["PeselStraz"].ToString(), r["TelefonStraz"].ToString(), r["StopienStraz"].ToString(), r["DataUrodzenia"].ToString(), r["DataDolaczenia"].ToString())); } }