Advertisement
Guest User

DB

a guest
Dec 13th, 2018
255
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.58 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10.  
  11. namespace Login_Screen
  12. {
  13. public partial class AddMovie : Form
  14. {
  15.  
  16. public AddMovie()
  17. {
  18. InitializeComponent();
  19.  
  20. placeGenre();
  21. placeActor();
  22. placeDirector();
  23. placeRating();
  24.  
  25.  
  26. }
  27.  
  28. public void placeGenre()
  29. {
  30. dbClass db = new dbClass();
  31. db.getGenre();
  32. List<string> aantalGenres = new List<string>();
  33.  
  34. foreach (int i = 0; i < aantalGenres ; i++)
  35. {
  36. aantalGenres.Add(cbGenre.Items.Add(db.getGenre().Rows[i][1].ToString());
  37. }
  38.  
  39.  
  40. /*
  41. string genre1 = db.getGenre().Rows[0][1].ToString();
  42. cbGenre.Items.Add(genre1);
  43. string genre2 = db.getGenre().Rows[1][1].ToString();
  44. cbGenre.Items.Add(genre2);
  45. string genre3 = db.getGenre().Rows[2][1].ToString();
  46. cbGenre.Items.Add(genre3);
  47. string genre4 = db.getGenre().Rows[3][1].ToString();
  48. cbGenre.Items.Add(genre4);
  49. string genre5 = db.getGenre().Rows[4][1].ToString();
  50. cbGenre.Items.Add(genre5);
  51. */
  52. }
  53.  
  54. public void placeActor()
  55. {
  56. dbClass db = new dbClass();
  57. db.getActor();
  58. string actor1 = db.getActor().Rows[0][1].ToString();
  59. cbActor.Items.Add(actor1);
  60. string actor2 = db.getActor().Rows[1][1].ToString();
  61. cbActor.Items.Add(actor2);
  62. string actor3 = db.getActor().Rows[2][1].ToString();
  63. cbActor.Items.Add(actor3);
  64. string actor4 = db.getActor().Rows[3][1].ToString();
  65. cbActor.Items.Add(actor4);
  66. string actor5 = db.getActor().Rows[4][1].ToString();
  67. cbActor.Items.Add(actor5);
  68. }
  69.  
  70. public void placeDirector()
  71. {
  72. dbClass db = new dbClass();
  73. db.getDirector();
  74. string d1 = db.getDirector().Rows[0][1].ToString();
  75. cbDirector.Items.Add(d1);
  76. string d2 = db.getDirector().Rows[1][1].ToString();
  77. cbDirector.Items.Add(d2);
  78. string d3 = db.getDirector().Rows[2][1].ToString();
  79. cbDirector.Items.Add(d3);
  80. string d4 = db.getDirector().Rows[3][1].ToString();
  81. cbDirector.Items.Add(d4);
  82. string d5 = db.getDirector().Rows[4][1].ToString();
  83. cbDirector.Items.Add(d5);
  84.  
  85. }
  86.  
  87. public void placeRating()
  88. {
  89. dbClass db = new dbClass();
  90. db.getRating();
  91. string r1 = db.getRating().Rows[0][1].ToString();
  92. cbRating.Items.Add(r1);
  93. string r2 = db.getRating().Rows[1][1].ToString();
  94. cbRating.Items.Add(r2);
  95. string r3 = db.getRating().Rows[2][1].ToString();
  96. cbRating.Items.Add(r3);
  97. string r4 = db.getRating().Rows[3][1].ToString();
  98. cbRating.Items.Add(r4);
  99. string r5 = db.getRating().Rows[4][1].ToString();
  100. cbRating.Items.Add(r5);
  101. string r6 = db.getRating().Rows[5][1].ToString();
  102. cbRating.Items.Add(r6);
  103. string r7 = db.getRating().Rows[6][1].ToString();
  104. cbRating.Items.Add(r7);
  105. string r8 = db.getRating().Rows[7][1].ToString();
  106. cbRating.Items.Add(r8);
  107. string r9 = db.getRating().Rows[8][1].ToString();
  108. cbRating.Items.Add(r9);
  109. string r10 = db.getRating().Rows[9][1].ToString();
  110. cbRating.Items.Add(r10);
  111.  
  112. }
  113.  
  114. private void button1_Click(object sender, EventArgs e)
  115. {
  116. dbClass db = new dbClass();
  117. if (tbMovieTitle.Text == "" || cbActor.SelectedItem == null || cbDirector.SelectedItem == null || cbGenre.SelectedItem == null || cbRating.SelectedItem == null || tbReleasedate.Text == "")
  118. {
  119. MessageBox.Show("Not all fields are filled in");
  120. }
  121. else
  122. {
  123. // 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()));
  124. }
  125. }
  126.  
  127. private void btnAddNew_Click(object sender, EventArgs e)
  128. {
  129. this.Hide();
  130. AddNewInfo addNewForm = new AddNewInfo();
  131. addNewForm.Show();
  132.  
  133.  
  134. }
  135.  
  136. private void btnRefresh_Click(object sender, EventArgs e)
  137. {
  138. this.Close();
  139. AddMovie addMovie = new AddMovie();
  140. addMovie.Show();
  141. }
  142. }
  143. }
  144.  
  145.  
  146.  
  147. using System;
  148. using System.Collections.Generic;
  149. using System.Linq;
  150. using System.Text;
  151. using System.Threading.Tasks;
  152. using System.Data.SqlClient;
  153. using MySql.Data.MySqlClient;
  154. using MySql.Data;
  155. using Microsoft.SqlServer.Server;
  156. using System.Data;
  157.  
  158. namespace Login_Screen
  159. {
  160. class dbClass
  161. {
  162.  
  163. MySqlConnection connection = new MySqlConnection(@"Server=localhost; Uid=root; Database=moviedb; Pwd=;SslMode=");
  164.  
  165. public bool inloggen(string username, string password)
  166. {
  167.  
  168. // using (GetConnection())
  169. connection.Open();
  170. MySqlCommand command = connection.CreateCommand();
  171. command.CommandText = "select * from user where username ='" + username + "' and password ='" + password + "';";
  172. MySqlDataReader reader = command.ExecuteReader();
  173. int count = 0;
  174.  
  175. while (reader.Read())
  176. {
  177. count = count + 1;
  178. }
  179. if (count == 1)
  180. {
  181. System.Windows.Forms.MessageBox.Show("Username and password is correct");
  182.  
  183. return true;
  184. }
  185. else if (count != 1)
  186. {
  187. System.Windows.Forms.MessageBox.Show("Username / password is NOT correct");
  188. return false;
  189. }
  190. else
  191. {
  192. return false;
  193. }
  194. }
  195.  
  196. public bool register (string name, string city, int age, string username, string password)
  197. {
  198. connection.Open();
  199. MySqlCommand command = connection.CreateCommand();
  200. command.CommandText = "INSERT INTO user (name, username, password, age, city) VALUE (@name, @username , @password, @age , @city)";
  201. command.Parameters.Add("@name", name);
  202. command.Parameters.Add("@username", username);
  203. command.Parameters.Add("@password", password);
  204. command.Parameters.Add("@age", age);
  205. command.Parameters.Add("@city", city);
  206. command.ExecuteNonQuery();
  207.  
  208. return true;
  209.  
  210.  
  211. }
  212.  
  213.  
  214. /* public bool addMovie(string title, int releaseDate, int directorName, int actorName, int genre, int rating)
  215. {
  216. connection.Open();
  217. MySqlCommand command = connection.CreateCommand();
  218. command.CommandText = "INSERT INTO movie (title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE (@title, @releasedate , @iddirector, @idacteur , @idgenre, @idrating)";
  219. command.Parameters.Add("@title", title);
  220. command.Parameters.Add("@releasedate", releaseDate);
  221. command.Parameters.Add("@iddirector", directorName);
  222. command.Parameters.Add("@idacteur", actorName);
  223. command.Parameters.Add("@idgenre", genre);
  224. command.Parameters.Add("@idrating", rating);
  225. command.ExecuteNonQuery();
  226. //INSERT INTO movie (title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE (@title, @releasedate , @iddirector, @idacteur, @idgenre , @idrating)
  227. // INSERT INTO movie(title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE(@title, @releasedate, @iddirector, @idgenre, @idrating)
  228. //INSERT INTO movie (title, releasedate, iddirector, idacteur, idgenre, idrating) VALUE (@title, @releasedate , @iddirector, @idacteur, @idgenre , @idrating)
  229. return true;
  230. }
  231. */
  232.  
  233.  
  234. public DataTable getGenre()
  235. {
  236. MySqlCommand command = connection.CreateCommand();
  237. MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT idgenre, genre FROM `genre`", connection);
  238. DataTable Genre = new DataTable();
  239. adapter.Fill(Genre);
  240.  
  241. return Genre;
  242. }
  243.  
  244. public DataTable getActor()
  245. {
  246. MySqlCommand command = connection.CreateCommand();
  247. MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT idacteur, name, age, city FROM `acteur`", connection);
  248. DataTable Actor = new DataTable();
  249. adapter.Fill(Actor);
  250.  
  251. return Actor;
  252. }
  253.  
  254. public DataTable getDirector()
  255. {
  256. MySqlCommand command = connection.CreateCommand();
  257. MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT iddirector, name, age, city FROM `director`", connection);
  258. //command.CommandText = "SELECT idgenre, genre FROM `genre`;";
  259. DataTable director = new DataTable();
  260. adapter.Fill(director);
  261.  
  262. return director;
  263. }
  264.  
  265. public DataTable getRating()
  266. {
  267. MySqlCommand command = connection.CreateCommand();
  268. MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT idrating, aantalsterren FROM `rating`", connection);
  269. //command.CommandText = "SELECT idgenre, genre FROM `genre`;";
  270. DataTable rating = new DataTable();
  271. adapter.Fill(rating);
  272.  
  273. return rating;
  274. }
  275.  
  276. public bool addGenre(string genre)
  277. {
  278.  
  279. MySqlCommand command = connection.CreateCommand();
  280. command.CommandText = "INSERT INTO `genre` (genre) VALUES (@genre)";
  281. command.Parameters.Add("@genre", genre);
  282.  
  283. command.ExecuteNonQuery();
  284.  
  285. return true;
  286. }
  287.  
  288.  
  289. public bool addDirector(string name)
  290. {
  291.  
  292. MySqlCommand command = connection.CreateCommand();
  293. command.CommandText = "INSERT INTO `director` (name) VALUES (@name)";
  294. command.Parameters.Add("@name", name);
  295.  
  296. command.ExecuteNonQuery();
  297.  
  298. return true;
  299. }
  300.  
  301. public bool addActor(string name)
  302. {
  303. connection.Open();
  304. MySqlCommand command = connection.CreateCommand();
  305. command.CommandText = "INSERT INTO `acteur` (name) VALUES (@name)";
  306. command.Parameters.Add("@name", name);
  307.  
  308. command.ExecuteNonQuery();
  309.  
  310. return true;
  311. }
  312.  
  313.  
  314. // public bool insertMovie()
  315. // {
  316. // MySqlCommand command = connection.CreateCommand();
  317. // 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);
  318.  
  319. // }
  320. // INSERT INTO 'movie' idmovie, title, releasdate, iddirector, idacteur, idgenre, idrating
  321. // SELECT idmovie, title, releasdate, iddirector, idacteur, idgenre, idrating FROM `movie` WHERE 1
  322.  
  323.  
  324. }
  325. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement