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