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()));
}
}
private void RemoveFirefighter()
{
using (con = new SQLiteConnection(connectionString))
{
try
{
con.Open();
SQLiteCommand command = new SQLiteCommand(con);
command.CommandText = "DELETE FROM Strazacy WHERE IdStraz='" + SelectedFirefighter.Id + "'";
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Błąd połączenia z bazą: " + ex);
}
finally
{
con.Close();
}
}
Firefighters.Remove(SelectedFirefighter);
}
