/*************************
*
*
* End of Actor Methods
*
*
*
* *******************************/
public static List <Movies> GetAllMovies()
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
List <Movies> movies = new List <Movies>();
command.CommandText = "SELECT * FROM Movies";
command.Connection = cn;
var reader = command.ExecuteReader();
while (reader.Read())
{
try
{
var Movie = new Movies();
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));
movies.Add(Movie);
}
catch (Exception)
{
continue;
}
}
cn.Close();
return(movies);
}
public static List <Actors> GetAllActors()
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
List <Actors> actors = new List <Actors>();
command.CommandText = "SELECT * FROM Actors";
command.Connection = cn;
var reader = command.ExecuteReader();
while (reader.Read())
{
try
{
var Actor = new Actors();
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();
actors.Add(Actor);
}
catch (Exception)
{
continue;
}
}
cn.Close();
return(actors);
}
public static void DeleteMovie(int id)
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
command.CommandText = $"DELETE FROM Movies WHERE Id= {id}";
command.Connection = cn;
var closer = command.ExecuteNonQuery();
cn.Close();
}
public static void AddMovie(Movies movie)
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
command.CommandText = $"INSERT INTO Movies(Title, Genero, ReleaseDate) VALUES('{movie.Title}', '{movie.Genero}', '{movie.ReleaseDate}')";
command.Connection = cn;
var inserter = command.ExecuteNonQuery();
cn.Close();
}
public static void AddActor(Actors actor)
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
command.CommandText = $"INSERT INTO Actors(FullName, BirthDate, Sex) VALUES('{actor.FullName}', '{actor.BirthDate}', '{actor.Sex}')";
command.Connection = cn;
var inserter = command.ExecuteNonQuery();
cn.Close();
}
public static void UpdateActor(Actors actor)
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
command.CommandText = $"UPDATE Actors SET FullName = '{actor.FullName}', " +
$"BirthDate = '{actor.BirthDate}', Sex = '{actor.Sex}' WHERE Id like '{actor.Id}'";
command.Connection = cn;
var updater = command.ExecuteNonQuery();
cn.Close();
}
public static void UpdateMovie(Movies movie)
{
var commander = new DBHandler();
var command = commander.Commands();
var cn = DBHandler.Connection();
command.CommandText = $"UPDATE Movies SET title= '{movie.Title}', " +
$"Genero = '{movie.Genero}', ReleaseDate = '{movie.ReleaseDate}' WHERE Id like '{movie.Id}'";
command.Connection = cn;
var updater = command.ExecuteNonQuery();
cn.Close();
}
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);
}
