public List<Serie> getAllSeries()
{
List<Serie> result = new List<Serie>();
/*
SQLiteDatabase db = getDb();
DataTable dt = db.GetDataTable("SELECT * FROM series");
foreach (DataRow row in dt.Rows)
{
Serie serie = new Serie();
serie.Id = row.Field<Int32>(0);
serie.Name = row.Field<String>("name");
serie.Overview = row.Field<String>("overview");
result.Add(serie);
}
*/
SQLiteDatabase db = getDb();
SQLiteDataReader reader = db.GetDataReader("SELECT * FROM series");
while (reader.Read())
{
Serie serie = new Serie();
serie.Id = reader.GetInt32(reader.GetOrdinal("id"));
serie.Name = reader.GetString(reader.GetOrdinal("name"));
serie.Overview = reader.GetString(reader.GetOrdinal("overview"));
result.Add(serie);
}
return result;
}
private void deleteSerie(Serie serie)
{
if (MessageBox.Show("Are you sure you want to delete the series?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SQLiteDatabase db = new SQLiteDatabase();
}
}
private void addSerie(Serie serie)
{
if (serie == null)
return;
if (!currentSeries.Items.Contains(serie))
{
currentSeries.Items.Add(serie);
newSeries.Items.Remove(serie);
serie.Save();
}
}
public List<Serie> getAllSeries()
{
List<Serie> result = new List<Serie>();
SQLiteDataReader reader;
try
{
SQLiteConnection cnn = new SQLiteConnection(dbConnection);
cnn.Open();
SQLiteCommand mycommand = new SQLiteCommand(cnn);
mycommand.CommandText = "SELECT * FROM series";
reader = mycommand.ExecuteReader();
while (reader.Read())
{
Serie serie = new Serie();
serie.Id = reader.GetInt32(reader.GetOrdinal("id"));
serie.Name = reader.GetString(reader.GetOrdinal("name"));
serie.Overview = reader.GetString(reader.GetOrdinal("overview"));
result.Add(serie);
}
reader.Close();
cnn.Close();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return result;
}
