// 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;
}
