// returns the newly created SeatMovie seatMovieID or 0 if Error internal static int insertNewSeatMovie(SeatMovie aSeatMovie) { //throw new NotImplementedException(); if (checkNoDuplicate(aSeatMovie)) { SeatMovie newSeatMovie; var context = new MovieTheaterEntities(); newSeatMovie = context.SeatMovie.Add(aSeatMovie); context.SaveChanges(); System.Diagnostics.Debug.WriteLine(">>> insertNewSeatMovie newSeatMovie.SeatMovie_ID=" + newSeatMovie.SeatMovie_ID); if (newSeatMovie != null) return newSeatMovie.SeatMovie_ID; else return 0; } else { return 0; } }
private static bool checkNoDuplicate(SeatMovie aSeatMovie) { //throw new NotImplementedException(); List<SeatMovie> seatMovieList = getSeatMovieListByJustRoomMovie(aSeatMovie.RoomMovie_ID); if (seatMovieList.Count > 0) { foreach (SeatMovie aSeatMovie2 in seatMovieList) { if (aSeatMovie.Seat_ID == aSeatMovie2.Seat_ID) { // duplicate found return false; } } return true; } else { return true; } }
public static int publishRoomMovie(int rmid) { var context = new MovieTheaterEntities(); RoomMovie rm = context.RoomMovie.Where(s => s.RoomMovie_ID == rmid).First(); if (rm.Publish == false) { rm.Publish = true; Room ro = rm.Room; List<Seat> listSt = context.Seat.Where(s => s.Room_ID == ro.Room_ID && s.Active_Indicator == true).ToList(); foreach(Seat st in listSt){ SeatMovie sm = new SeatMovie(); sm.RoomMovie_ID = rm.RoomMovie_ID; sm.Seat_ID = st.Seat_ID; sm.Occupied = false; sm.Active_Indicator = true; sm.Update_Datetime = DateTime.Today; context.SeatMovie.Add(sm); } context.SaveChanges(); return 1; } return 0; }