/// <summary>
/// Updates contributing columm in contributing table.
/// </summary>
/// <param name="actor"></param>
/// <returns></returns>
public static Contributing UpdateContributing(Contributing contributing)
{
string updateContributing = "UPDATE Contributing SET FID = @FID WHERE SID = @SID";
using (SqlConnection connection = new SqlConnection(cs))
{
connection.Open();
SqlCommand cmd = new SqlCommand(updateContributing, connection);
cmd.Parameters.AddWithValue("@FID", contributing.FID);
cmd.Parameters.AddWithValue("@SID", contributing.SID);
cmd.ExecuteNonQuery();
}
return(contributing);
}
/// <summary>
/// Insert a FID and SID to contributing table
/// </summary>
/// <param name="movie"></param>
/// <returns></returns>
public static Contributing InsertContributing(Contributing contributing)
{
string insertContributing = "INSERT INTO Contributing(FID, SID) VALUES (@FID, @SID)";
using (SqlConnection connection = new SqlConnection(cs))
{
connection.Open();
SqlCommand cmd = new SqlCommand(insertContributing, connection);
//Adds contributing values to table
cmd.Parameters.Add(new SqlParameter("@FID", contributing.FID));
cmd.Parameters.Add(new SqlParameter("@SID", contributing.SID));
//Execute variable cmd
cmd.ExecuteNonQuery();
}
return(contributing);
}
public static Contributing UpdateContributing(Contributing contributing)
{
return(Dalmanager.UpdateContributing(contributing));
}
public static Contributing InsertContributing(Contributing contributing)
{
return(Dalmanager.InsertContributing(contributing));
}
static void Main(string[] args)
{
#region Objects
Actor actor = new Actor("Bob", "Marley");
Actor updateActor = new Actor(2, "JOE", "Mamma");
//Parameter takes the actor SID you want to delete
Actor deleteActor = new Actor(13);
Movie movie = new Movie("Harry Potter", 2005, "04:00", "Eventyr");
Movie UpdateMovie = new Movie(1, "Harry Potter", 2005, "11:00", "Eventyr");
//Parameter takes the movie FID you want to delete
Movie deleteMovie = new Movie(19);
// FID = Which movie the actors is in
//SID = Actors ID
// FID SID
Contributing contributing = new Contributing(5, 5);
//Set FID to a value
//SID Must be a valid id.
// FID SID
Contributing updateContributing = new Contributing(19, 6);
#endregion
#region Insert data to table in database
//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}");
#endregion
#region Update data in table to database
//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}");
#endregion
#region Delete row in table database
//Deletes also in contributing if id is valid
//Console.WriteLine("\nDelete Actor in database");
//MovieManager.DeleteActor(deleteActor);
//Console.WriteLine($"SID: {deleteActor.Id}");
//Deletes in contributing if id is valid
//Console.WriteLine("\nDelete movie in database");
//MovieManager.DeleteMovie(deleteMovie);
//Console.WriteLine($"FID: {deleteMovie.Id}");
#endregion
}
