public static void Add(string name)
{
using var db = new DbCinema();
db.Halls
.Value(hall => hall.Name, name)
.Insert();
}
public static void Delete(int id)
{
using var db = new DbCinema();
db.Reservations
.Where(reservation => reservation.Id == id)
.Delete();
}
public static void Add(string name)
{
using var db = new DbCinema();
db.Roles
.Value(role => role.Name, name)
.Insert();
}
public static void Delete(int id)
{
using var db = new DbCinema();
db.Roles
.Where(role => role.Id == id)
.Delete();
}
public static void Delete(int id)
{
using var db = new DbCinema();
db.Halls
.Where(hall => hall.Id == id)
.Delete();
}
public ActionResult DoUpload(IFormFile file)
{
using (var stream = file.OpenReadStream())
{
var xs = new XmlSerializer(typeof(Cinema));
var cinema = (Cinema)xs.Deserialize(stream);
using (var db = new CinemaDbContext())
{
var dbs = new DbCinema()
{
Name = cinema.Name,
Adress = cinema.Adress,
};
dbs.Films = new Collection <DbFilm>();
foreach (var film in cinema.Films)
{
dbs.Films.Add(new DbFilm()
{
Name = film.Name,
Seats = film.Seats,
Time = film.Time,
});
}
db.Cinemas.Add(dbs);
db.SaveChanges();
}
return(View(cinema));
}
}
public static void Delete(int id)
{
using var db = new DbCinema();
db.Users
.Where(user => user.Id == id)
.Delete();
}
public static void Delete(int id)
{
using var db = new DbCinema();
db.Seances
.Where(seance => seance.Id == id)
.Delete();
}
public static void Delete(int id)
{
using var db = new DbCinema();
db.Movies
.Where(movie => movie.Id == id)
.Delete();
}
public static void Add(string name, double length)
{
using var db = new DbCinema();
db.Movies
.Value(movie => movie.Name, name)
.Value(movie => movie.Length, length)
.Insert();
}
public static void Add(string login, string password, int roleId = 3)
{
using var db = new DbCinema();
db.Users
.Value(user => user.Login, login)
.Value(user => user.Password, PasswordCipher.ConvertPassword(password))
.Value(user => user.RoleId, roleId)
.Insert();
}
public static void Add(int movieId, int hallId, DateTime time)
{
using var db = new DbCinema();
db.Seances
.Value(seance => seance.MovieId, movieId)
.Value(seance => seance.HallId, hallId)
.Value(seance => seance.Time, time)
.Insert();
}
public static Role Get(int id)
{
using var db = new DbCinema();
var query = from role in db.Roles
where role.Id == id
select role;
var singleRole = query.ToList()[0];
return(singleRole);
}
public static List <Role> All()
{
using var db = new DbCinema();
var query = from role in db.Roles
orderby role.Name descending
select role;
var roles = query.ToList();
return(roles);
}
public static List <Movie> All()
{
using var db = new DbCinema();
var query = from movie in db.Movies
orderby movie.Name descending
select movie;
var movies = query.ToList();
return(movies);
}
public static Hall GetByName(string name)
{
using var db = new DbCinema();
var query = from hall in db.Halls
where hall.Name == name
select hall;
var singleHall = query.ToList()[0];
return(singleHall);
}
public static Movie GetByName(string name)
{
using var db = new DbCinema();
var query = from movie in db.Movies
where movie.Name == name
select movie;
var singleMovie = query.ToList()[0];
return(singleMovie);
}
public static List <User> All()
{
using var db = new DbCinema();
var query = from user in db.Users
orderby user.Login descending
select user;
var users = query.ToList();
return(users);
}
public static Role GetByName(string name)
{
using var db = new DbCinema();
var query = from role in db.Roles
where role.Name == name
select role;
var singleRole = query.ToList()[0];
return(singleRole);
}
public static bool Login(string login, string password)
{
using var db = new DbCinema();
string encodedPassword = PasswordCipher.ConvertPassword(password);
var queryable = from user in db.Users
where user.Login == login && user.Password == encodedPassword
select user;
return(queryable.ToList().Count > 0);
}
public static List <Hall> All()
{
using var db = new DbCinema();
var query = from hall in db.Halls
orderby hall.Name descending
select hall;
var halls = query.ToList();
return(halls);
}
public static Movie Get(int id)
{
using var db = new DbCinema();
var query = from movie in db.Movies
where movie.Id == id
select movie;
var singleMovie = query.ToList()[0];
return(singleMovie);
}
public static Hall Get(int id)
{
using var db = new DbCinema();
var query = from hall in db.Halls
where hall.Id == id
select hall;
var singleHall = query.ToList()[0];
return(singleHall);
}
public static List <Reservation> GetReservations(int id)
{
using var db = new DbCinema();
var queryable = from reservation in db.Reservations
where reservation.UserId == id
join user in db.Users on reservation.UserId equals user.Id
select reservation;
return(queryable.ToList().Select(reservation => ReservationController.Get(reservation.Id)).ToList());
}
public static void Add(int userId, int seanceId, int seat, DateTime time, bool isConfirmed = false)
{
using var db = new DbCinema();
db.Reservations
.Value(reservation => reservation.UserId, userId)
.Value(reservation => reservation.SeanceId, seanceId)
.Value(reservation => reservation.Seat, seat)
.Value(reservation => reservation.IsConfirmed, isConfirmed)
.Value(reservation => reservation.Time, time)
.Insert();
}
public static void Update(int id, string?name)
{
using var db = new DbCinema();
var hall = Get(id);
if (name != null)
{
hall.Name = name;
}
db.Update(hall);
}
public static List <Seance> All()
{
using var db = new DbCinema();
var query = from seance in db.Seances
join movie in db.Movies on seance.MovieId equals movie.Id
join hall in db.Halls on seance.HallId equals hall.Id
select Seance.Build(seance, movie, hall);
var seances = query.ToList();
return(seances);
}
public static User GetByLogin(string login)
{
using var db = new DbCinema();
var queryable = from user in db.Users
where user.Login == login
join role in db.Roles on user.RoleId equals role.Id
select User.Build(user, role);
var singleUser = queryable.ToList()[0];
return(singleUser);
}
public static List <Reservation> GetBySeanceId(int seanceId)
{
using var db = new DbCinema();
var queryable = from reservation in db.Reservations
join seance in db.Seances on reservation.SeanceId equals seance.Id
where reservation.SeanceId == seanceId
select Reservation.Build(reservation, seance);
var reservations = queryable.ToList();
return(reservations);
}
public static void Update(int id, string?name)
{
using var db = new DbCinema();
var role = Get(id);
if (name != null)
{
role.Name = name;
}
db.Update(role);
}
