public static Actors GetActorById(int id)
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
command.CommandText = $"SELECT * FROM Actors WHERE ID like '{id}'";
command.Connection = cn;
var reader = command.ExecuteReader();
var Actor = new Actors();
if (reader.Read())
{
Actor.Id = Convert.ToInt32(reader.GetValue(0));
Actor.FullName = reader.GetValue(1).ToString();
Actor.BirthDate = Convert.ToDateTime(reader.GetValue(2));
Actor.Sex = reader.GetValue(3).ToString();
}
cn.Close();
return(Actor);
}
public static Movies GetMoviesById(int id)
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
command.CommandText = $"SELECT * FROM Movies WHERE ID like '{id}'";
command.Connection = cn;
var reader = command.ExecuteReader();
var Movie = new Movies();
if (reader.Read())
{
Movie.Id = Convert.ToInt32(reader.GetValue(0));
Movie.Title = reader.GetValue(1).ToString();
Movie.Genero = reader.GetValue(2).ToString();
Movie.ReleaseDate = Convert.ToDateTime(reader.GetValue(3));
}
cn.Close();
return(Movie);
}
