static void Main(string[] args) { Contributing contributing = new Contributing(5, 5); Contributing updateContributing = new Contributing(19, 6); Actor actor = new Actor("Phillip", "Jepsen"); Actor updateActor = new Actor(2, "Kim", "Larsen"); Actor deleteActor = new Actor(13); Movie movie = new Movie("The Internship", 2013, "Comedy", "Sjov film"); Movie UpdateMovie = new Movie(1, "Iron man", 2002, "SciFi", "Avengers"); Movie deleteMovie = new Movie(10); //Console.WriteLine("Insert new actor to database"); //MovieManager.InsertActor(actor); //Console.WriteLine($"{actor.FirstName} {actor.LastName}"); //Console.WriteLine("\nInsert new movie to database"); //MovieManager.InsertMovie(movie); //Console.WriteLine($"{movie.Title} {movie.Year} {movie.Showtime} {movie.Genre}"); //Console.WriteLine("Insert IDs to contributing table"); //MovieManager.InsertContributing(contributing); //Console.WriteLine($"FID: {contributing.FID}\nSID: {contributing.SID}"); //Console.WriteLine("\nDelete Actor in database"); //MovieManager.DeleteActor(deleteActor); //Console.WriteLine($"SID: {deleteActor.Id}"); //Console.WriteLine("\nDelete movie in database"); //MovieManager.DeleteMovie(deleteMovie); //Console.WriteLine($"FID: {deleteMovie.Id}"); //Console.WriteLine("\nUpdate Actor in database"); //MovieManager.UpdateActor(updateActor); //Console.WriteLine($"{updateActor.FirstName} {updateActor.LastName}"); //Console.WriteLine("\nUpdate movie in database"); //MovieManager.UpdateMovie(UpdateMovie); //Console.WriteLine($"{UpdateMovie.Title} {UpdateMovie.Year} {UpdateMovie.Showtime} {UpdateMovie.Genre}"); //Console.WriteLine("\nUpdate contributing in table"); //MovieManager.UpdateContributing(updateContributing); //Console.WriteLine($"Updates FID: {updateContributing.FID}\nWHERE SID: {updateContributing.SID}"); }
public static Contributing UpdateContributing(Contributing contributing) { string updateContributing = "UPDATE Contributing SET FID = @FID WHERE SID = @SID"; using (SqlConnection connection = new SqlConnection(connstring)) { connection.Open(); SqlCommand cmd = new SqlCommand(updateContributing, connection); cmd.Parameters.AddWithValue("@FID", contributing.Fid); cmd.Parameters.AddWithValue("@SID", contributing.Sid); cmd.ExecuteNonQuery(); } return(contributing); }
public static Contributing InsertContributing(Contributing contributing) { string insertData = "INSERT INTO Contributing(FID,SID) VALUES(@FID, @SID)"; using (SqlConnection connection = new SqlConnection(connstring)) { connection.Open(); SqlCommand cmd = new SqlCommand(insertData, connection); //Adds data cmd.Parameters.Add(new SqlParameter("@FID", contributing.Fid)); cmd.Parameters.Add(new SqlParameter("@SID", contributing.Sid)); cmd.ExecuteNonQuery(); } return(contributing); }
public static Contributing UpdataContributing(Contributing contributing) { return(DalManager.UpdateContributing(contributing)); }
public static Contributing InsertData(Contributing contributing) { return(DalManager.InsertContributing(contributing)); }