private void btnEditMovie_Click(object sender, EventArgs e)
{
string id = idMovie.Text;
string name = editNameMovie.Text;
string genres = editGenres.Text;
string dir = editDirector.Text;
string act = editActor.Text;
string dur = editDuration.Text;
string rel = editReleaseDay.Text;
string lan = editLanguage.Text;
string cou = editCountry.Text;
string rated = editRated.Text;
Movie_DTO movie = new Movie_DTO(id, name, genres, dir, act, dur, rel, lan, cou, rated);
Movie_BUS.EditMovie(movie);
this.Close();
}
private void btnAddMovie_Click(object sender, EventArgs e)
{
string id = addIdMovie.Text;
string name = addNameMovie.Text;
string genres = addGenres.Text;
string director = addDirector.Text;
string actor = addActor.Text;
string duration = addDuration.Text;
string releaseDay = addReleaseDay.Value.ToString();
string language = addLanguage.Text;
string country = addCountry.Text;
string rated = addRated.Text;
Movie_DTO movie = new Movie_DTO(id, name, genres, director, actor, duration, releaseDay.Substring(0, 10), language, country, rated);
BUS.Movie_BUS.AddMovie(movie);
MessageBox.Show("Complete", "Add a movie", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
//Add movie
public static void AddMovie(Movie_DTO movie)
{
SqlConnection connecter = sqlConnectionData.Connecter();
SqlCommand commander = new SqlCommand("AddMovie", connecter);
commander.CommandType = CommandType.StoredProcedure;
commander.Parameters.Add("@id", SqlDbType.Char, 10).Value = movie.IdMovie;
commander.Parameters.Add("@name", SqlDbType.NVarChar, 1000).Value = movie.Name;
commander.Parameters.Add("@genres", SqlDbType.NVarChar, 1000).Value = movie.Genres;
commander.Parameters.Add("@director", SqlDbType.NVarChar, 1000).Value = movie.Director;
commander.Parameters.Add("@actor", SqlDbType.NVarChar, 1000).Value = movie.Actor;
commander.Parameters.Add("@duration", SqlDbType.NVarChar, 20).Value = movie.Duration;
commander.Parameters.Add("@releaseDay", SqlDbType.Date).Value = movie.ReleaseDay;
commander.Parameters.Add("@languages", SqlDbType.NVarChar, 1000).Value = movie.Language;
commander.Parameters.Add("@country", SqlDbType.NVarChar, 1000).Value = movie.Country;
commander.Parameters.Add("@rated", SqlDbType.NVarChar, 100).Value = movie.Rated;
connecter.Open();
commander.ExecuteNonQuery();
connecter.Close();
}
//Edit info movie
public static void EditMovie(Movie_DTO movie)
{
Movie_DAO.EditMovie(movie);
}
//Add Movie
public static void AddMovie(Movie_DTO movie)
{
Movie_DAO.AddMovie(movie);
}
