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); }