//Får data fra mange-mange tablet mellem Film og skuespiller public static List <ActorInMovie> GetActorInMovies() { List <ActorInMovie> actorInMovies = new List <ActorInMovie>(); using (SqlConnection connection = new SqlConnection(cs)) { connection.Open(); SqlCommand cmd = new SqlCommand("select movie_id, actor_id from movie_actor", connection); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //henter data fra readeren og "caster" //til den rigtige datatype int movie_id = (int)rdr["movie_id"]; int actor_id = (int)rdr["actor_id"]; //Opretter et ny ActorInMovie objekt ActorInMovie a = new ActorInMovie(movie_id, actor_id); //tilføjer ActorInMovie til listen actorInMovies.Add(a); } } return(actorInMovies); }
public static void DeleteActorInMovie(ActorInMovie a) { using (SqlConnection connection = new SqlConnection(cs)) { //Opretter en forbindelse til databasen connection.Open(); //update data SqlCommand cmd = new SqlCommand ("Delete from movie_actor where movie_id = @m_id and actor_id = @a_id", connection); //tilføjer parametre cmd.Parameters.Add(new SqlParameter("@m_id", a.Movie_id)); cmd.Parameters.Add(new SqlParameter("@a_id", a.Actor_id)); cmd.ExecuteNonQuery(); //Id sættes ind i a } }
public static void InsertActorInMovie(ActorInMovie a) { using (SqlConnection connection = new SqlConnection(cs)) { //Opretter en forbindelse til databasen connection.Open(); //update data SqlCommand cmd = new SqlCommand ("insert into movie_actor(movie_id, actor_id) values (@m_id, @a_id)", connection); //tilføjer parametre cmd.Parameters.Add(new SqlParameter("@m_id", a.Movie_id)); cmd.Parameters.Add(new SqlParameter("@a_id", a.Actor_id)); cmd.ExecuteNonQuery(); //Id sættes ind i a } }
public static void DeleteActorInMovie(ActorInMovie a) { DalManager.DeleteActorInMovie(a); }
public static void InsertActorInMovie(ActorInMovie a) { DalManager.InsertActorInMovie(a); }