public static List <MovieClass> getMovieTitles(SqlCommand command, int lastRefreshedId)
{
command.Parameters.Clear();
command.CommandText = "SELECT TOP 50 * FROM MOVIES WHERE ID > @LASTREFRESHEDID ORDER BY ID ASC ";
command.Parameters.Add("@LASTREFRESHEDID", SqlDbType.Int);
command.Prepare();
command.Parameters["@LASTREFRESHEDID"].Value = lastRefreshedId;
List <MovieClass> list = new List <MovieClass>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
MovieClass movie = new MovieClass();
movie.i = DBTypesEvaluator.ToInteger(reader["ID"]);
movie.t = DBTypesEvaluator.ToString(reader["TITLE"]);
list.Add(movie);
}
reader.Close();
return(list);
}
public static MovieClass getMovie(SqlCommand command, string title)
{
MovieClass result = null;
command.Parameters.Clear();
command.CommandText = "SELECT TOP 1 * FROM MOVIES WHERE TITLE LIKE @TITLE ";
command.Parameters.Add("@TITLE", SqlDbType.VarChar, 100);
command.Prepare();
command.Parameters["@TITLE"].Value = "%" + title + "%";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
result = new MovieClass();
result.i = DBTypesEvaluator.ToInteger(reader["ID"]);
result.t = DBTypesEvaluator.ToString(reader["TITLE"]);
result.rd = DBTypesEvaluator.ToFullTimeStr(reader["RELEASEDATE"]);
result.g = DBTypesEvaluator.ToInteger(reader["GENRE"]);
result.s = DBTypesEvaluator.ToString(reader["SUMMARY"]);
}
reader.Close();
if (result != null)
{
/* read movie director names */
command.Parameters.Clear();
command.CommandText = "SELECT * FROM MOVIEDIRECTORS WHERE MOVIEID = @MOVIEID ";
command.Parameters.Add("@MOVIEID", SqlDbType.Int);
command.Prepare();
command.Parameters["@MOVIEID"].Value = result.i;
List <string> directorList = new List <string>();
reader = command.ExecuteReader();
while (reader.Read())
{
directorList.Add(DBTypesEvaluator.ToString(reader["DIRECTOR"]));
}
reader.Close();
result.md = directorList;
/* read movie actor names */
command.Parameters.Clear();
command.CommandText = "SELECT * FROM MOVIEACTORS WHERE MOVIEID = @MOVIEID ";
command.Parameters.Add("@MOVIEID", SqlDbType.Int);
command.Prepare();
command.Parameters["@MOVIEID"].Value = result.i;
List <string> actorList = new List <string>();
reader = command.ExecuteReader();
while (reader.Read())
{
actorList.Add(DBTypesEvaluator.ToString(reader["ACTOR"]));
}
reader.Close();
result.ma = actorList;
}
return(result);
}
