public void addCinemaHall(String name, String capacity, String location) { if (name == "") { throw new Exception("name can't be empty "); } if (capacity == "") { throw new Exception("capacity can't be empty "); } if (location == "") { throw new Exception("location can't be empty "); } int cap; if (!int.TryParse(capacity, out cap)) { throw new Exception("capacity must be a number"); } Models.CinemaHall cinemaHall = new Models.CinemaHall(name, cap, location); try { dbC.addCinemaHall(cinemaHall); } catch (Exception err) { throw err; } }
public void updateCinemaHall(Models.CinemaHall cinemaHall) { String query = "UPDATE `cinema_hall` SET `name` = '" + cinemaHall.name + "', `capacity` = '" + cinemaHall.capacity + " ', `location` = '" + cinemaHall.location + "' WHERE `cinema_hall`.`id` = " + cinemaHall.id + ""; MySqlConnection databaseConnection = new MySqlConnection(MysqlConnetionString); MySqlCommand comandDatabase = new MySqlCommand(query, databaseConnection); comandDatabase.CommandTimeout = 60; try { databaseConnection.Open(); MySqlDataReader myReader = comandDatabase.ExecuteReader(); } catch (Exception e) { throw e; } }
public void addCinemaHall(Models.CinemaHall cinemaHall) { String query = "INSERT INTO `cinema_hall` (`id`, `name`, `capacity`, `location`) VALUES (NULL, '" + cinemaHall.name + "', '" + cinemaHall.capacity + "', '" + cinemaHall.location + "')"; MySqlConnection databaseConnection = new MySqlConnection(MysqlConnetionString); MySqlCommand comandDatabase = new MySqlCommand(query, databaseConnection); comandDatabase.CommandTimeout = 60; try { databaseConnection.Open(); MySqlDataReader myReader = comandDatabase.ExecuteReader(); } catch (Exception e) { throw e; } }
public Models.CinemaHall findCinemaHall(int id) { String query = "SELECT * FROM `cinema_hall` WHERE id = " + id; MySqlConnection databaseConnection = new MySqlConnection(MysqlConnetionString); MySqlCommand comandDatabase = new MySqlCommand(query, databaseConnection); comandDatabase.CommandTimeout = 60; try { databaseConnection.Open(); MySqlDataReader myReader = comandDatabase.ExecuteReader(); if (myReader.HasRows) { if (myReader.Read()) { Console.WriteLine("found"); Models.CinemaHall cinemaHall = new Models.CinemaHall(int.Parse(myReader[0].ToString()), myReader[1].ToString(), int.Parse(myReader[2].ToString()), myReader[3].ToString()); cinemaHall.showCinemaHall(); return(cinemaHall); } throw new Exception("Reader can't read"); } else { throw new Exception("CinemaHall not found "); } } catch (Exception e) { throw e; } }
//cinema hall //cinema hall //cinema hall //cinema hall public List <Models.CinemaHall> getCinemaHall() { List <Models.CinemaHall> cinemaHalls = new List <Models.CinemaHall>(); String query = "SELECT * FROM cinema_hall"; MySqlConnection databaseConnection = new MySqlConnection(MysqlConnetionString); MySqlCommand comandDatabase = new MySqlCommand(query, databaseConnection); comandDatabase.CommandTimeout = 60; try { databaseConnection.Open(); MySqlDataReader myReader = comandDatabase.ExecuteReader(); if (myReader.HasRows) { while (myReader.Read()) { Models.CinemaHall cinemaHall = new Models.CinemaHall(int.Parse(myReader[0].ToString()), myReader[1].ToString(), int.Parse(myReader[2].ToString()), myReader[3].ToString()); // cinemaHall.showCinemaHall(); cinemaHalls.Add(cinemaHall); } return(cinemaHalls); } else { return(cinemaHalls); } } catch (Exception e) { throw e; } }