internal void GetByMovie(int movie, Lists.PosterList posterList)
{
//Open connection
if (dh.OpenConnection() == true)
{
string q = "SELECT ROWID,Movie,URL,Path, Width,Height FROM Posters p\n";
q += "Where p.Movie = " + movie;
//Create Command
SQLiteCommand cmd = new SQLiteCommand(q, dh.connection);
//Create a data reader and Execute the command
SQLiteDataReader dataReader = cmd.ExecuteReader();
posterList.Clear();
while (dataReader.Read())
{
Poster poster = new Poster();
if (dh.HasColumn(dataReader, "ROWID"))
poster.ID = Convert.ToInt32(dataReader["ROWID"]);
if (dh.HasColumn(dataReader, "Movie"))
poster.Movie = Convert.ToInt32(dataReader["Movie"]);
if (dh.HasColumn(dataReader, "URL"))
poster.URL = dataReader["URL"].ToString();
if (dh.HasColumn(dataReader, "Path"))
poster.Path = dataReader["Path"].ToString();
if (dh.HasColumn(dataReader, "Width"))
poster.Width = Convert.ToInt32(dataReader["Width"]);
if (dh.HasColumn(dataReader, "Height"))
poster.Height = Convert.ToInt32(dataReader["Height"]);
poster.RecordExists = true;
posterList.Add(poster);
}
//close Data Reader
dataReader.Close();
//close Connection
dh.CloseConnection();
}
}
