public Projection Delete(int projId) { var dbProjection = db.Projections.FirstOrDefault(t => t.Id == projId); if (dbProjection == null) { return(null); } else { db.Projections.Remove(dbProjection); db.SaveChanges(); return(ToModel(dbProjection)); } }
public Film Delete(int filmId) { var dbFilm = db.Films.FirstOrDefault(f => f.Id == filmId); if (dbFilm == null) { return(null); } else { db.Films.Remove(dbFilm); db.SaveChanges(); return(ToModel(dbFilm)); } }
public Viewer Delete(int viewerId) { var dbViewer = db.Viewers.FirstOrDefault(t => t.Id == viewerId); if (dbViewer == null) { return(null); } else { db.Viewers.Remove(dbViewer); db.SaveChanges(); return(ToModel(dbViewer)); } }
public Room Delete(int roomId) { var dbRoom = db.Rooms.FirstOrDefault(r => r.Id == roomId); if (dbRoom == null) { return(null); } else { db.Rooms.Remove(dbRoom); db.SaveChanges(); return(ToModel(dbRoom)); } }
public Order Delete(int orderId) { var dbOrder = db.Orders.FirstOrDefault(o => o.Id == orderId); if (dbOrder == null) { return(null); } else { db.Orders.Remove(dbOrder); db.SaveChanges(); return(ToModel(dbOrder)); } }
public Seat Delete(int seatId) { var dbSeat = db.Seats.FirstOrDefault(t => t.Id == seatId); if (dbSeat == null) { return(null); } else { db.Seats.Remove(dbSeat); db.SaveChanges(); return(ToModel(dbSeat)); } }
public bool InsertSeats(int projid, int viewerid, int seats, int r, int c) { int maxRow = 6; int maxCol = 5; bool result = false; using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.RepeatableRead)) { for (int i = 0; i < seats; i++) { c++; if (c > maxCol) { c = 1; r++; } if (r > maxRow) { result = false; tran.Rollback(); } var toInsert = new DbSeatReservation() { ProjectionId = projid, ViewerId = viewerid, Row = r, Column = c }; db.Reservations.Add(toInsert); } result = true; db.SaveChanges(); tran.Commit(); } return(result); }