Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- namespace Login_Screen
- {
- public partial class AddMovie : Form
- {
- public AddMovie()
- {
- InitializeComponent();
- placeGenre();
- placeActor();
- placeDirector();
- placeRating();
- }
- public void placeGenre()
- {
- dbClass db = new dbClass();
- db.getGenre();
- List<string> aantalGenres = new List<string>();
- foreach (int i = 0; i < aantalGenres ; i++)
- {
- aantalGenres.Add(cbGenre.Items.Add(db.getGenre().Rows[i][1].ToString());
- }
- /*
- string genre1 = db.getGenre().Rows[0][1].ToString();
- cbGenre.Items.Add(genre1);
- string genre2 = db.getGenre().Rows[1][1].ToString();
- cbGenre.Items.Add(genre2);
- string genre3 = db.getGenre().Rows[2][1].ToString();
- cbGenre.Items.Add(genre3);
- string genre4 = db.getGenre().Rows[3][1].ToString();
- cbGenre.Items.Add(genre4);
- string genre5 = db.getGenre().Rows[4][1].ToString();
- cbGenre.Items.Add(genre5);
- */
- }
- public void placeActor()
- {
- dbClass db = new dbClass();
- db.getActor();
- string actor1 = db.getActor().Rows[0][1].ToString();
- cbActor.Items.Add(actor1);
- string actor2 = db.getActor().Rows[1][1].ToString();
- cbActor.Items.Add(actor2);
- string actor3 = db.getActor().Rows[2][1].ToString();
- cbActor.Items.Add(actor3);
- string actor4 = db.getActor().Rows[3][1].ToString();
- cbActor.Items.Add(actor4);
- string actor5 = db.getActor().Rows[4][1].ToString();
- cbActor.Items.Add(actor5);
- }
- public void placeDirector()
- {
- dbClass db = new dbClass();
- db.getDirector();
- string d1 = db.getDirector().Rows[0][1].ToString();
- cbDirector.Items.Add(d1);
- string d2 = db.getDirector().Rows[1][1].ToString();
- cbDirector.Items.Add(d2);
- string d3 = db.getDirector().Rows[2][1].ToString();
- cbDirector.Items.Add(d3);
- string d4 = db.getDirector().Rows[3][1].ToString();
- cbDirector.Items.Add(d4);
- string d5 = db.getDirector().Rows[4][1].ToString();
- cbDirector.Items.Add(d5);
- }
- public void placeRating()
- {
- dbClass db = new dbClass();
- db.getRating();
- string r1 = db.getRating().Rows[0][1].ToString();
- cbRating.Items.Add(r1);
- string r2 = db.getRating().Rows[1][1].ToString();
- cbRating.Items.Add(r2);
- string r3 = db.getRating().Rows[2][1].ToString();
- cbRating.Items.Add(r3);
- string r4 = db.getRating().Rows[3][1].ToString();
- cbRating.Items.Add(r4);
- string r5 = db.getRating().Rows[4][1].ToString();
- cbRating.Items.Add(r5);
- string r6 = db.getRating().Rows[5][1].ToString();
- cbRating.Items.Add(r6);
- string r7 = db.getRating().Rows[6][1].ToString();
- cbRating.Items.Add(r7);
- string r8 = db.getRating().Rows[7][1].ToString();
- cbRating.Items.Add(r8);
- string r9 = db.getRating().Rows[8][1].ToString();
- cbRating.Items.Add(r9);
- string r10 = db.getRating().Rows[9][1].ToString();
- cbRating.Items.Add(r10);
- }
- private void button1_Click(object sender, EventArgs e)
- {
- dbClass db = new dbClass();
- if (tbMovieTitle.Text == "" || cbActor.SelectedItem == null || cbDirector.SelectedItem == null || cbGenre.SelectedItem == null || cbRating.SelectedItem == null || tbReleasedate.Text == "")
- {
- MessageBox.Show("Not all fields are filled in");
- }
- else
- {
- // db.addMovie(tbMovieTitle.Text, Int32.Parse(tbReleasedate.Text), Int32.Parse(cbActor.SelectedItem.ToString()), Int32.Parse(cbDirector.SelectedItem.ToString()), Int32.Parse(cbGenre.SelectedItem.ToString()), Int32.Parse(cbRating.SelectedItem.ToString()));
- }
- }
- private void btnAddNew_Click(object sender, EventArgs e)
- {
- this.Hide();
- AddNewInfo addNewForm = new AddNewInfo();
- addNewForm.Show();
- }
- private void btnRefresh_Click(object sender, EventArgs e)
- {
- this.Close();
- AddMovie addMovie = new AddMovie();
- addMovie.Show();
- }
- }
- }
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Data.SqlClient;
- using MySql.Data.MySqlClient;
- using MySql.Data;
- using Microsoft.SqlServer.Server;
- using System.Data;
- namespace Login_Screen
- {
- class dbClass
- {
- MySqlConnection connection = new MySqlConnection(@"Server=localhost; Uid=root; Database=moviedb; Pwd=;SslMode=");
- public bool inloggen(string username, string password)
- {
- // using (GetConnection())
- connection.Open();
- MySqlCommand command = connection.CreateCommand();
- command.CommandText = "select * from user where username ='" + username + "' and password ='" + password + "';";
- MySqlDataReader reader = command.ExecuteReader();
- int count = 0;
- while (reader.Read())
- {
- count = count + 1;
- }
- if (count == 1)
- {
- System.Windows.Forms.MessageBox.Show("Username and password is correct");
- return true;
- }
- else if (count != 1)
- {
- System.Windows.Forms.MessageBox.Show("Username / password is NOT correct");
- return false;
- }
- else
- {
- return false;
- }
- }
- public bool register (string name, string city, int age, string username, string password)
- {
- connection.Open();
- MySqlCommand command = connection.CreateCommand();
- command.CommandText = "INSERT INTO user (name, username, password, age, city) VALUE (@name, @username , @password, @age , @city)";
- command.Parameters.Add("@name", name);
- command.Parameters.Add("@username", username);
- command.Parameters.Add("@password", password);
- command.Parameters.Add("@age", age);
- command.Parameters.Add("@city", city);
- command.ExecuteNonQuery();
- return true;
- }
- /* public bool addMovie(string title, int releaseDate, int directorName, int actorName, int genre, int rating)
- {
- connection.Open();
- MySqlCommand command = connection.CreateCommand();
- command.CommandText = "INSERT INTO movie (title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE (@title, @releasedate , @iddirector, @idacteur , @idgenre, @idrating)";
- command.Parameters.Add("@title", title);
- command.Parameters.Add("@releasedate", releaseDate);
- command.Parameters.Add("@iddirector", directorName);
- command.Parameters.Add("@idacteur", actorName);
- command.Parameters.Add("@idgenre", genre);
- command.Parameters.Add("@idrating", rating);
- command.ExecuteNonQuery();
- //INSERT INTO movie (title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE (@title, @releasedate , @iddirector, @idacteur, @idgenre , @idrating)
- // INSERT INTO movie(title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE(@title, @releasedate, @iddirector, @idgenre, @idrating)
- //INSERT INTO movie (title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE (@title, @releasedate , @iddirector, @idacteur, @idgenre , @idrating)
- return true;
- }
- */
- public DataTable getGenre()
- {
- MySqlCommand command = connection.CreateCommand();
- MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT idgenre, genre FROM `genre`", connection);
- DataTable Genre = new DataTable();
- adapter.Fill(Genre);
- return Genre;
- }
- public DataTable getActor()
- {
- MySqlCommand command = connection.CreateCommand();
- MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT idacteur, name, age, city FROM `acteur`", connection);
- DataTable Actor = new DataTable();
- adapter.Fill(Actor);
- return Actor;
- }
- public DataTable getDirector()
- {
- MySqlCommand command = connection.CreateCommand();
- MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT iddirector, name, age, city FROM `director`", connection);
- //command.CommandText = "SELECT idgenre, genre FROM `genre`;";
- DataTable director = new DataTable();
- adapter.Fill(director);
- return director;
- }
- public DataTable getRating()
- {
- MySqlCommand command = connection.CreateCommand();
- MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT idrating, aantalsterren FROM `rating`", connection);
- //command.CommandText = "SELECT idgenre, genre FROM `genre`;";
- DataTable rating = new DataTable();
- adapter.Fill(rating);
- return rating;
- }
- public bool addGenre(string genre)
- {
- MySqlCommand command = connection.CreateCommand();
- command.CommandText = "INSERT INTO `genre` (genre) VALUES (@genre)";
- command.Parameters.Add("@genre", genre);
- command.ExecuteNonQuery();
- return true;
- }
- public bool addDirector(string name)
- {
- MySqlCommand command = connection.CreateCommand();
- command.CommandText = "INSERT INTO `director` (name) VALUES (@name)";
- command.Parameters.Add("@name", name);
- command.ExecuteNonQuery();
- return true;
- }
- public bool addActor(string name)
- {
- connection.Open();
- MySqlCommand command = connection.CreateCommand();
- command.CommandText = "INSERT INTO `acteur` (name) VALUES (@name)";
- command.Parameters.Add("@name", name);
- command.ExecuteNonQuery();
- return true;
- }
- // public bool insertMovie()
- // {
- // MySqlCommand command = connection.CreateCommand();
- // MySqlDataAdapter adapter = new MySqlDataAdapter("INSERT INTO 'movie' (idmovie, title, releasdate, iddirector, idacteur, idgenre, idrating) VALUES(NULL, 'naam', 30-06-1993, NULL, NULL, NULL, NULL)", connection);
- // }
- // INSERT INTO 'movie' idmovie, title, releasdate, iddirector, idacteur, idgenre, idrating
- // SELECT idmovie, title, releasdate, iddirector, idacteur, idgenre, idrating FROM `movie` WHERE 1
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement