public RESERVATION Add(RESERVATION entity)
        {
            RESERVATION insertedReservation = null;

            if (CheckHelper.IsFilled(entity))
            {
                using (ctx = new ReadingRoomsEntities())
                {
                    entity.RES_ID = 1;

                    RESERVATION maxReservation = ctx.RESERVATIONs.OrderByDescending(s => s.RES_ID).FirstOrDefault();
                    if (CheckHelper.IsFilled(maxReservation))
                    {
                        entity.RES_ID = maxReservation.RES_ID + 1;
                    }

                    if (CheckHelper.IsFilled(entity.SEATs))
                    {
                        foreach (SEAT seat in entity.SEATs)
                        {
                            ctx.Entry(seat).State = EntityState.Unchanged;
                        }
                    }

                    insertedReservation = ctx.RESERVATIONs.Add(entity);
                    ctx.SaveChanges();
                }
            }

            return(insertedReservation);
        }
        public USER Update(USER entity)
        {
            USER updatedUser = null;

            using (ctx = new ReadingRoomsEntities())
            {
                updatedUser             = ctx.USERs.Attach(entity);
                ctx.Entry(entity).State = EntityState.Modified;
                ctx.SaveChanges();
            }

            return(updatedUser);
        }
        public READING_ROOM Update(READING_ROOM entity)
        {
            READING_ROOM updatedReadingRoom = null;

            using (ctx = new ReadingRoomsEntities())
            {
                updatedReadingRoom      = ctx.READING_ROOM.Attach(entity);
                ctx.Entry(entity).State = EntityState.Modified;
                ctx.SaveChanges();
            }

            return(updatedReadingRoom);
        }
        public SEAT Update(SEAT entity)
        {
            SEAT updatedSeat = null;

            using (ctx = new ReadingRoomsEntities())
            {
                updatedSeat             = ctx.SEATs.Attach(entity);
                ctx.Entry(entity).State = EntityState.Modified;
                ctx.SaveChanges();
            }

            return(updatedSeat);
        }
        public UNIVERSITY Update(UNIVERSITY entity)
        {
            UNIVERSITY updatedUni = null;

            using (ctx = new ReadingRoomsEntities())
            {
                updatedUni = ctx.UNIVERSITies.Attach(entity);
                ctx.Entry(entity).State = EntityState.Modified;
                ctx.SaveChanges();
            }

            return(updatedUni);
        }
        public FACULTY Update(FACULTY entity)
        {
            FACULTY updatedFaculty = null;

            using (ctx = new ReadingRoomsEntities())
            {
                updatedFaculty          = ctx.FACULTies.Attach(entity);
                ctx.Entry(entity).State = EntityState.Modified;
                ctx.SaveChanges();
            }

            return(updatedFaculty);
        }
        public RESERVATION Update(RESERVATION entity)
        {
            RESERVATION updatedReservation = null;

            using (ctx = new ReadingRoomsEntities())
            {
                updatedReservation      = ctx.RESERVATIONs.Attach(entity);
                ctx.Entry(entity).State = EntityState.Modified;
                ctx.SaveChanges();
            }

            return(updatedReservation);
        }