public Actors GetActorsById(int id) { Actors actor = null; string query = $"SELECT * FROM actors where id={id}"; try { conn.Open(); NpgsqlCommand cmd = new NpgsqlCommand(query, conn); var reader = cmd.ExecuteReader(); if (reader.Read()) { actor = new Actors { ID = Convert.ToInt32(reader["id"]), Name = reader["name"].ToString(), BirtDate = reader["birth_date"].ToString() }; } cmd.Connection.Close(); my_logger.Info($"get actor with id= {id} "); } catch (Exception ex) { my_logger.Error($"Failed to get actor. Error : {ex}"); my_logger.Error($"GetActorsById: [{query}]"); } conn.Close(); return(actor); }
static void Main(string[] args) { my_logger.Info("******************** System startup"); m_config = new PostgresSQL_AppConfig(); string m_conn = m_config.ConnectionString; Console.WriteLine($"-- Hello App {m_config.AppName}"); Actors actor1 = new Actors { ID = 11, Name = "adi chen", BirtDate = "13.04.1956" }; Actors actor2 = new Actors { ID = 12, Name = "adi levi", BirtDate = "13.04.1966" }; Geners gener1 = new Geners { ID = 9, Name = "horror" }; Geners gener2 = new Geners { ID = 9, Name = "france" }; Movies movie1 = new Movies { Name = "fast and angery", genre_ID = 1, ID = 9, releaseDate = "12.05.2000" }; Movies movie2 = new Movies { Name = "rain man", genre_ID = 2, ID = 19, releaseDate = "12.05.2011" }; Movies_Actors movies_actors1 = new Movies_Actors { ID = 33, Actor_ID = 21, Movie_ID = 1 }; Movies_Actors movies_actors2 = new Movies_Actors { ID = 34, Actor_ID = 14, Movie_ID = 2 }; DAO dAO = new DAO(); dAO.AddActors(actor1); dAO.AddGeneres(gener1); dAO.AddMovies(movie1); dAO.AddMoviesWithActors(movies_actors1); Console.WriteLine("GetActorsById: "); Console.WriteLine(dAO.GetActorsById(3).ToString()); Console.WriteLine(); Console.WriteLine("GetMoviesById: "); Console.WriteLine(dAO.GetMoviesById(3).ToString()); Console.WriteLine(); Console.WriteLine("GetMoviesWithActorsById: "); Console.WriteLine(dAO.GetMoviesWithActorsById(51).ToString()); Console.WriteLine(); Console.WriteLine("GetGeneresById: "); Console.WriteLine(dAO.GetGeneresById(3).ToString()); Console.WriteLine(); Console.WriteLine("GetAllGeneres: "); dAO.GetAllGeneres().ForEach(s => Console.WriteLine(s.ToString())); Console.WriteLine(); Console.WriteLine("GetAllActors: "); dAO.GetAllActors().ForEach(s => Console.WriteLine(s.ToString())); Console.WriteLine(); Console.WriteLine("GetAllMovies: "); dAO.GetAllMovies().ForEach(s => Console.WriteLine(s.ToString())); Console.WriteLine(); Console.WriteLine("GetAllMoviesWithActors: "); dAO.GetAllMoviesWithActors().ForEach(s => Console.WriteLine(s.ToString())); Console.WriteLine(); Console.WriteLine("GetAllMoviesWithActorBornBefore1972: "); dAO.GetAllMoviesWithActorBornBefore1972().ForEach(s => Console.WriteLine(s.ToString())); Console.WriteLine(); Console.WriteLine("GetActorWithMaxMovies: "); dAO.GetActorWithMaxMovies().ForEach(s => Console.WriteLine(s.ToString()));; Console.WriteLine(); Console.WriteLine("GetFristMoviesInEveryYesr: "); dAO.GetFristMoviesInEveryYesr().ForEach(s => Console.WriteLine(s.ToString()));; Console.WriteLine(); Console.ReadLine(); /* dAO.UpdateActors(11, actor2); * dAO.UpdateGeneres(11, gener2); * dAO.UpdateMovies(11, movie2); * dAO.UpdateMoviesWithActors(11,movies_actors2); * * * dAO.DeleteActors(5); * dAO.DeleteGeneres(5); * dAO.DeleteMovies(5); * dAO.DeleteMoviesWithActors(5);*/ my_logger.Info("******************** System shutdown"); }