/// <summary> /// Get at list of schedulers, specified by a movie ID /// </summary> /// <param name="movieID">ID of the movie</param> /// <returns>A list of scheduler objects</returns> public List <Scheduler> GetSchedulerListByMovieID(int movieID) { var db = new ConnectToDatabaseDataContext(); List <Scheduler> SchList = db.Schedulers.Select(x => x).Where(x => x.MovieID == movieID).ToList(); return(SchList); }
/// <summary> /// Selects the customer with the given phonenumber /// </summary> /// <param name="phone">The phonenumber which to search for</param> /// <returns>returns the customer with the phonernumber, if one exists</returns> public Customer GetByPhone(string phone) { var db = new ConnectToDatabaseDataContext(); Customer customer = db.Customers.Single(x => x.phoneNumber.Equals(phone)); return(customer); }
public void UpdateSchedulers(int schID, DateTime date, TimeSpan time, int movieID, int hallID) { var db = new ConnectToDatabaseDataContext(); db.Connection.Open(); db.Transaction = db.Connection.BeginTransaction(IsolationLevel.RepeatableRead); Scheduler scheduler = db.Schedulers.Single(x => x.SchID == schID); scheduler.Date = date; scheduler.Starttime = time; scheduler.MovieID = movieID; scheduler.HallID = hallID; try { db.Transaction.Commit(); db.Transaction.Dispose(); db.Connection.Close(); } catch (Exception e) { db.Transaction.Rollback(); Console.WriteLine(e.Message); db.Connection.Close(); } }
/// <summary> /// Update a customer /// </summary> /// <param name="customerID">The ID of the customer you want to edit</param> /// <param name="name">Name of the customer</param> /// <param name="email">Email of the customer</param> /// <param name="phone">Phone number of the customer</param> /// <param name="password">The new password for the customer</param> public void UpdateCustomer(int customerID, string name, string email, string phone, string password) { ConnectToDatabaseDataContext db = new ConnectToDatabaseDataContext(); db.Connection.Open(); db.Transaction = db.Connection.BeginTransaction(IsolationLevel.RepeatableRead); Customer customer = db.Customers.Single(x => x.CusID == customerID); customer.mail = email; customer.name = name; customer.phoneNumber = phone; customer.password = password; try { db.Transaction.Commit(); db.Transaction.Dispose(); db.Connection.Close(); } catch (Exception e) { db.Transaction.Rollback(); Console.WriteLine(e.Message); db.Connection.Close(); } }
/// <summary> /// Gets a seat object by it's scheduler ID and row /// </summary> /// <param name="schID">The scheduler ID of the seats</param> /// <param name="row">The row of the seats</param> /// <returns>A list of the seats with that row (should only be 1 though)</returns> public List <Seat> GetSeatsBySchIDAndRow(int schID, int row) { ConnectToDatabaseDataContext db = new ConnectToDatabaseDataContext(); List <Seat> record = db.Seats.Where(x => x.SchedulerID == schID && x.Row == row).ToList(); return(record); }
/// <summary> /// Inserts a scheduler into the database /// </summary> /// <param name="date"></param> /// <param name="time"></param> /// <param name="movieID">The ID of the movie that is to be scheduled</param> /// <param name="hallID">The ID of the hall in which the movie will be shown</param> public void InsertScheduler(DateTime date, TimeSpan time, int movieID, int hallID) { var db = new ConnectToDatabaseDataContext(); Scheduler sch = new Scheduler(); sch.Date = date; sch.Starttime = time; sch.MovieID = movieID; sch.HallID = hallID; db.Schedulers.InsertOnSubmit(sch); var result = (from t in db.Schedulers orderby t.SchID descending select t.SchID).First(); var HallSeatList = db.HallSeats.Select(x => x).Where(x => x.HallID == hallID); foreach (HallSeat hallSeat in HallSeatList) { Seat seat = new Seat(); seat.Row = hallSeat.Row; seat.ColumnArray = hallSeat.seatNumbers; seat.SchedulerID = result; db.Seats.InsertOnSubmit(seat); } }
/// <summary> /// /// </summary> /// <param name="resID">The reservation ID, of the reservation that has to be edited</param> /// <param name="customerID">Customer ID, if it needs to be changes to a new customer</param> /// <param name="row">The rows the reservation has made</param> /// <param name="seat">The seats the reservation has made</param> /// <param name="schID">Scheduler ID for the reservation, if it needs to be changed</param> public void UpdateReservation(int resID, int customerID, string row, string seat, int schID) { ConnectToDatabaseDataContext db = new ConnectToDatabaseDataContext(); db.Connection.Open(); db.Transaction = db.Connection.BeginTransaction(IsolationLevel.RepeatableRead); Reservation reservation = db.Reservations.First(r => r.ResID == resID); reservation.CustomerID = customerID; reservation.Row = row; reservation.Seat = seat; reservation.SchedulerID = schID; try { db.Transaction.Commit(); db.Transaction.Dispose(); db.Connection.Close(); } catch (Exception e) { db.Transaction.Rollback(); Console.WriteLine(e); db.Connection.Close(); } }
/// <summary> /// Deletes a movie from the database /// </summary> /// <param name="movie">The movie to delete, of type movie object</param> /// <returns>A control int to check for success</returns> public int DeleteMovie(Movie movie) { int controlInt = -1; var db = new ConnectToDatabaseDataContext(); Movie movieToDelete = new Movie(); movieToDelete.name = movie.name; movieToDelete.MovieID = movie.MovieID; movieToDelete.Playtime = movie.Playtime; movieToDelete.Image = movie.Image; movieToDelete.Price = movie.Price; db.Movies.Attach(movieToDelete); db.Movies.DeleteOnSubmit(movieToDelete); try { controlInt = 1; } catch (Exception e) { Console.WriteLine(e); } return(controlInt); }
/// <summary> /// Selects all customers with a given name /// </summary> /// <param name="name">The name which to search for</param> /// <returns>Returns a list of all customers with the name</returns> public IEnumerable GetCustomerByName(string name) { var db = new ConnectToDatabaseDataContext(); var customer = db.Customers.Select(x => x).AsEnumerable().Where(x => x.name.Equals(name)); return(customer); }
/// <summary> /// Creates a list with all customers /// </summary> /// <returns>The list of customers</returns> public IEnumerable GetAllCustomers() { var db = new ConnectToDatabaseDataContext(); var customer = db.Customers.Select(x => x).AsEnumerable(); return(customer); }
/// <summary> /// Gets a movie by it's name /// </summary> /// <param name="name">Name of the movie</param> /// <returns>A movie of a movie object</returns> public Movie GetByMovieName(string name) { var db = new ConnectToDatabaseDataContext(); Movie movie = db.Movies.Single(x => x.name.Equals(name)); return(movie); }
/// <summary> /// Gets a hall by it's ID /// </summary> /// <param name="hallID">The ID of the hall</param> /// <returns>Returns a hall of type hall object</returns> public Hall GetByHallID(int hallID) { var db = new ConnectToDatabaseDataContext(); Hall hall = db.Halls.Single(x => x.HallID == hallID); return(hall); }
/// <summary> /// Gets all movies /// </summary> /// <returns>Returns an List of all the movies</returns> public List <Movie> GetAllMovies() { var db = new ConnectToDatabaseDataContext(); var movies = db.Movies.Select(x => x).ToList(); return(movies); }
// public Customer CustomerLogin(string userMail, string passWord) /// <summary> /// Find a customer by e-mail /// </summary> /// <param name="email">The e-mail of the customer</param> /// <returns>The customer object</returns> public Customer GetCustomerByEmail(string email) { var db = new ConnectToDatabaseDataContext(); var customer = db.Customers.Select(x => x).AsEnumerable().Single(x => x.mail == email); return(customer); }
/// <summary> /// Find a scheduler by movie /// </summary> /// <param name="movieID">The ID of the movie</param> /// <returns>Returns the scheduler as a scheduler object</returns> public Scheduler GetSchedulerByMovieID(int movieID) { var db = new ConnectToDatabaseDataContext(); Scheduler scheduler = db.Schedulers.Single(dbScheduler => dbScheduler.MovieID == movieID); return(scheduler); }
//Use LINQ to get the schedulers where the schedulerID is x. (See inside SchedulerController.cs) /// <summary> /// Gets a scheduler by ID /// </summary> /// <param name="schedulerID">The ID of the scheduler</param> /// <returns>Returns the scheduler</returns> public Scheduler GetSchedulerByID(int schedulerID) { var db = new ConnectToDatabaseDataContext(); Scheduler scheduler = db.Schedulers.Single(x => x.SchID == schedulerID); return(scheduler); }
/// <summary> /// Finds a customer by the customer ID /// </summary> /// <param name="customerID">The customer ID you want to search for</param> /// <returns>The customer, if it's found</returns> public Customer GetCustomerByID(int customerID) { var db = new ConnectToDatabaseDataContext(); Customer customer = db.Customers.Single(x => x.CusID == customerID); return(customer); }
/// <summary> /// Gets all schedulers /// </summary> /// <returns>A list of schedulers</returns> public List <Scheduler> GetAllSchedulers() { var db = new ConnectToDatabaseDataContext(); var schedulerList = db.Schedulers.Select(x => x); return(schedulerList.ToList()); }
/// <summary> /// Gets a movie by the ID of a movie /// </summary> /// <param name="movieID">The ID of the movie</param> /// <returns>A movie of a movie object</returns> public Movie GetMovieByID(int movieID) { var db = new ConnectToDatabaseDataContext(); // Movie movie = db.Movies.Single(x => x.MovieID == movieID); Movie movie = db.Movies.Single(x => x.MovieID == movieID); return(movie); }
/// <summary> /// Gets all halls with a given name (in case some have the same name) /// </summary> /// <param name="name">Name of the hall</param> /// <returns>Returns an IEnumerable with all the halls with the name</returns> public IEnumerable GetHallByName(string name) { ArrayList hallList = new ArrayList(); var db = new ConnectToDatabaseDataContext(); var hall = db.Halls.Select(x => x).AsEnumerable().Where(x => x.name.Equals(name)); return(hall); }
/// <summary> /// Gets all halls /// </summary> /// <returns>An IEnumerable with all halls</returns> public IEnumerable GetAllHalls() { ArrayList hallList = new ArrayList(); var db = new ConnectToDatabaseDataContext(); var hall = db.Halls.Select(x => x).AsEnumerable(); return(hall); }
/// <summary> /// Gets a scheduler by date and time /// </summary> /// <param name="date">Date and time writen as yyyyMMdd hhMMss</param> /// <returns>A list of schedulers</returns> public List <Scheduler> GetByDate(DateTime date) { var db = new ConnectToDatabaseDataContext(); var Schedulerlist = db.Schedulers.Select(x => x).Where(x => x.Date == date); List <Scheduler> Sch = new List <Scheduler>(); Sch = Schedulerlist.ToList(); return(Sch); }
/// <summary> /// A method to reset the database with an SQL script /// </summary> public void ResetDatabase() { var db = new ConnectToDatabaseDataContext(); FileInfo file = new FileInfo("SQLscriptCinema.sql"); string script = file.OpenText().ReadToEnd(); db.ExecuteCommand(script); }
/// <summary> /// Gets a list reservations by phone number of the customer /// </summary> /// <param name="phone">The customers phone number</param> /// <returns>Returns the list of the reservations</returns> public List <Reservation> GetReservationByCusPhone(string phone) { DBCustomer dbC = new DBCustomer(); Customer cus = dbC.GetByPhone(phone); int id = cus.CusID; List <Reservation> list = new List <Reservation>(); var db = new ConnectToDatabaseDataContext(); list = db.Reservations.Select(x => x).Where(x => x.CustomerID == id).ToList(); return(list); }
public IEnumerable GetReservation() { ConnectToDatabaseDataContext db = new ConnectToDatabaseDataContext(); DBCustomer dbCustomer = new DBCustomer(); List <Customer> customers = dbCustomer.GetAllCustomers().Cast <Customer>().ToList(); List <Reservation> reservation = db.Reservations.Select(x => x).AsEnumerable().ToList(); var cusResJoin = from res in reservation join cust in customers on res.CustomerID equals cust.CusID select res; return(cusResJoin); }
/// <summary> /// Inserts a scheduler into the database /// </summary> /// <param name="sch">The object to insert</param> public void InsertScheduler(Scheduler sch) { var db = new ConnectToDatabaseDataContext(); db.Schedulers.InsertOnSubmit(sch); try { } catch (Exception e) { Console.WriteLine(e); } }
//Innerjoin som joiner tabellerne scheduler, movie og hall public IEnumerable GetScheduler() { var db = new ConnectToDatabaseDataContext(); DBMovie dbMovie = new DBMovie(); List <Movie> movie = dbMovie.GetAllMovies().Cast <Movie>().ToList(); List <Scheduler> scheduler = db.Schedulers.Select(x => x).AsEnumerable().ToList(); var InnerJoin = from sch in scheduler join mov in movie on sch.MovieID equals mov.MovieID select sch; return(InnerJoin); }
/// <summary> /// Gets all seats in a given scheduler /// </summary> /// <param name="schID">The ID of the scheduler</param> /// <returns>Returns a list of the seats</returns> public List <Seat> GetSeats(int schID) { ConnectToDatabaseDataContext db = new ConnectToDatabaseDataContext(); List <Seat> seat = db.Seats.Where(x => x.SchedulerID == schID).ToList(); return(seat); // Testing translater //Console.WriteLine(count); //for (int column = 0; column < count; column++) //{ // for (int number = 0; number < jagged[column].Count(); number++) // { // Console.WriteLine(jagged[column][number]); // } // Console.ReadLine(); //} }
public void DeleteSch(int schID) { var db = new ConnectToDatabaseDataContext(); Scheduler scheduler = db.Schedulers.Single(x => x.SchID == schID); //Scheduler DelScheduler = new Scheduler(); //DelScheduler.SchID = scheduler.SchID; db.Schedulers.DeleteOnSubmit(scheduler); try { } catch { Console.Write("Delete scheduler failed"); } }
/// <summary> /// A login method for a user /// </summary> /// <param name="userMail">The user e-mail</param> /// <param name="passWord">The user password</param> /// <returns>Returns true if the user logged in successfully, false if not</returns> public Customer CustomerLogin(string userMail, string passWord) { try { var db = new ConnectToDatabaseDataContext(); Customer user = (from c in db.Customers where c.mail.ToLower() == userMail.ToLower() && c.password == passWord select c).SingleOrDefault(); if (user.CusID > 0) { return(user); } } catch (Exception ex) { System.Diagnostics.Trace.WriteLine("[ValidateUser] Exception " + ex.Message); } return(null); }