/// <summary>
/// Удаление зала
/// </summary>
/// <param name="ID"></param>
public void Delete(int ID)
{
List <Session> h = (db.HallSet.Find(ID)).Session.ToList();
foreach (Session x in h)
{//удаляем все сеансы
SessionRepository c = new SessionRepository(db);
c.Delete(x.ID);
}
db.HallSet.Find(ID).Deleted = true;
db.SaveChanges();
}
public DataManager()
{
cont = new Model1Container();
BR = new BookingRepository(cont);
CShR = new CashierRepository(cont);
CR = new CinemaRepository(cont);
FR = new FilmRepository(cont);
HR = new HallRepository(cont);
SR = new SeatRepository(cont);
SsR = new SessionRepository(cont);
TR = new TicketRepository(cont);
}
/// <summary>
/// Удаление фильма
/// </summary>
/// <param name="ID"></param>
public void Delete(int ID)
{
Film s = db.FilmSet.Find(ID);
List <Session> ses = s.Session.ToList();
foreach (Session x in ses)
{//удаляем все сеансы данного фильма
SessionRepository c = new SessionRepository(db);
c.Delete(x.ID);
}
db.FilmSet.Remove(s);
db.SaveChanges();
}
public List <Ticket> Find(List <Ticket> f, string ent, string atr, string sign, string eqv, string eqv2)
{
List <Ticket> result = new List <Ticket>();
switch (ent)
{
case "Место":
{
switch (atr)
{
case "Ряд":
{
switch (sign)
{
case "=": { result = (from d in f where d.Seat.NumberOfRow == int.Parse(eqv) select d).ToList(); break; }
case "!=": { result = (from d in f where d.Seat.NumberOfRow != int.Parse(eqv) select d).ToList(); break; }
case ">": { result = (from d in f where d.Seat.NumberOfRow > int.Parse(eqv) select d).ToList(); break; }
case "<": { result = (from d in f where d.Seat.NumberOfRow < int.Parse(eqv) select d).ToList(); break; }
case ">=": { result = (from d in f where d.Seat.NumberOfRow >= int.Parse(eqv) select d).ToList(); break; }
case "<=": { result = (from d in f where d.Seat.NumberOfRow <= int.Parse(eqv) select d).ToList(); break; }
}
break;
}
case "Номер в ряду":
{
switch (sign)
{
case "=": { result = (from d in f where d.Seat.NumberOfSeat == int.Parse(eqv) select d).ToList(); break; }
case "!=": { result = (from d in f where d.Seat.NumberOfSeat != int.Parse(eqv) select d).ToList(); break; }
case ">": { result = (from d in f where d.Seat.NumberOfSeat > int.Parse(eqv) select d).ToList(); break; }
case "<": { result = (from d in f where d.Seat.NumberOfSeat < int.Parse(eqv) select d).ToList(); break; }
case ">=": { result = (from d in f where d.Seat.NumberOfSeat >= int.Parse(eqv) select d).ToList(); break; }
case "<=": { result = (from d in f where d.Seat.NumberOfSeat <= int.Parse(eqv) select d).ToList(); break; }
}
break;
}
}
break;
}
case "Билет":
{
switch (sign)
{
case "=": { result = (from d in f where d.Number == int.Parse(eqv) select d).ToList(); break; }
case "!=": { result = (from d in f where d.Number != int.Parse(eqv) select d).ToList(); break; }
case ">": { result = (from d in f where d.Number > int.Parse(eqv) select d).ToList(); break; }
case "<": { result = (from d in f where d.Number < int.Parse(eqv) select d).ToList(); break; }
case ">=": { result = (from d in f where d.Number >= int.Parse(eqv) select d).ToList(); break; }
case "<=": { result = (from d in f where d.Number <= int.Parse(eqv) select d).ToList(); break; }
}
break;
}
default:
{
SessionRepository c = new SessionRepository(db);
List <Session> cin = c.Find(db.SessionSet.ToList(), ent, atr, sign, eqv, eqv2);
List <Ticket> cash = new List <Ticket>();
foreach (Session x in cin)
{
foreach (Seat y in x.Seat)
{
if (y.Ticket != null)
{
cash.Add(y.Ticket);
}
}
}
result = (from d in f select d).Intersect(from a in cash select a).ToList();
break;
}
}
return(result);
}
