Ejemplo n.º 1
0
        public ActionResult AddRoom(FormCollection f)
        {
            Room room = new Room();
            room.RoomName = f["RoomName"];
            room.LodgeID = int.Parse(f["lodgeId"]);
            room.TotalSlots = int.Parse(f["TotalSlots"]);
            room.AvailableSlots = room.TotalSlots;

            Lodge lodge = db.Lodges.SingleOrDefault(r => r.LodgeID == room.LodgeID);
            lodge.TotalSlots += room.TotalSlots;
            lodge.AvailableSlots += room.TotalSlots;
            lodge.TotalSlotsInUsed += room.TotalSlots;
            //lodge.AvailableSlots += room.AvailableSlots;
            //ChairitiesExam ce = lodge.ChairitiesExam;
            //ce.TotalSlotsLodges += room.TotalSlots;
            //ce.AvailableSlotsLodges += room.AvailableSlots;

            db.Rooms.Add(room);
            db.SaveChanges();

            return RedirectToAction("DetailsLodge", new { id = room.LodgeID });
        }
Ejemplo n.º 2
0
        public void ChooseRoomsForCe(int eId, string roomId, int lodgeId, int cId)
        {
            string[] listStringId = roomId.Split('-');

            int[] listIntId = new int[listStringId.Length - 1];

            for (int i = 0; i < listStringId.Length - 1; i++)
            {
                listIntId[i] = int.Parse(listStringId[i]);
            }
            Lodge lodgeNew = new Lodge();
            Lodge lodge = db.Lodges.SingleOrDefault(r => r.LodgeID == lodgeId);
            lodgeNew = lodge;
            ChairitiesExam cExam = new ChairitiesExam();
            cExam = db.ChairitiesExams.FirstOrDefault(c => c.CharityExamID == eId && c.CharityID == cId);
            lodgeNew.CharityExamID = cExam.CharityExamID;
            lodgeNew.CharityID = cId;
            lodgeNew.TotalSlotsInUsed = 0;
            lodgeNew.AvailableSlots = 0;
            db.Lodges.Add(lodgeNew);
            db.SaveChanges();
            Lodge lodgeNewest = db.Lodges.FirstOrDefault(l => l.Address == lodgeNew.Address && l.CharityExamID == cExam.CharityExamID);
            foreach (var i in listIntId)
            {
                Room roomNew = new Room();
                Room room = db.Rooms.SingleOrDefault(r => r.RoomID == i);
                roomNew = room;
                roomNew.LodgeID = lodgeNewest.LodgeID;
                roomNew.CharityExamID = cExam.CharityExamID;

                cExam.TotalSlotsLodges += room.TotalSlots;
                cExam.AvailableSlotsLodges += room.AvailableSlots;
                lodgeNewest.TotalSlotsInUsed += room.TotalSlots;
                lodgeNewest.AvailableSlots += room.AvailableSlots;
                db.Rooms.Add(roomNew);
                db.SaveChanges();
            }
        }
Ejemplo n.º 3
0
        protected bool rg2r(List<ExaminationsPaper> eps, int lodgeID, bool gender)
        {
            Room r = new Room();
            var rooms = getRooms(lodgeID, gender); // get list of rooms suitable (gender, available slots, ...)
            foreach (int rID in rooms)
            {
                r = db.Rooms.SingleOrDefault(re => re.RoomID == rID);
                if (r.AvailableSlots > 0) // possible to use
                {
                    // split into 02 groups:
                    // group 1: number of members equal to room's available slots.
                    List<ExaminationsPaper> eps01 = new List<ExaminationsPaper>();
                    for (int i = 0; i < r.AvailableSlots; ++i) eps01.Add(eps[i]);
                    // group 2: the rest.
                    List<ExaminationsPaper> eps02 = new List<ExaminationsPaper>();
                    for (int i = r.AvailableSlots; i < eps.Count; ++i) eps02.Add(eps[i]);

                    if (!g2r(eps01, lodgeID, gender))  // cannot fit this small group
                    {
                        // try split the group more
                        if (!rg2r(eps01, lodgeID, gender)) return false;
                    }

                    if (!g2r(eps02, lodgeID, gender)) // cannot fit this small group
                    {
                        // try split the group more
                        if (!rg2r(eps02, lodgeID, gender)) return false;
                    }

                    return true;
                }
            }
            return false;
        }
Ejemplo n.º 4
0
 protected bool g2r(List<ExaminationsPaper> eps, int lodgeID, bool gender)
 {
     Room r = new Room();
     var rooms = getRooms(lodgeID, gender); // get list of rooms suitable (gender, available slots, ...)
     foreach (int rID in rooms)
     {
         r = db.Rooms.SingleOrDefault(re => re.RoomID == rID);
         if (r.AvailableSlots >= eps.Count) // fit it all
         {
             foreach (ExaminationsPaper ep in eps) ep.RoomID = rID;
             r.Gender = gender;
             r.AvailableSlots -= eps.Count;
             return true;
         }
     }
     return false;
 }
Ejemplo n.º 5
0
 protected List<int> sortRooms(List<int> rooms, bool gender) // lodgeID
 {
     Room r1 = new Room();
     Room r2 = new Room();
     int tmp;
     for (int i = 0; i < rooms.Count - 1; ++i)
     {
         tmp = rooms[i];
         r1 = db.Rooms.SingleOrDefault(r => r.RoomID == tmp);
         for (int j = i + 1; j < rooms.Count; ++j)
         {
             tmp = rooms[j];
             r2 = db.Rooms.SingleOrDefault(r => r.RoomID == tmp);
             if (r1.Gender == gender && r2.Gender == gender) // both are same gender
             {
                 // order by available slots
                 if (r1.AvailableSlots < r2.AvailableSlots) swapRoom(rooms, i, j);
             }
             else if (r1.Gender != gender && r2.Gender != gender) // no rooms matched gender 
             {
                 // order by available slots
                 if (r1.AvailableSlots < r2.AvailableSlots) swapRoom(rooms, i, j);
             }
             else // only one room matched gender
             {
                 // r1 does not matched gender --> put it behind
                 if (r1.Gender != gender) swapRoom(rooms, i, j);
             }
         }
     }
     return rooms;
 }
Ejemplo n.º 6
0
        public void EditLodge(int ceId, string roomId, int lodgeId, int cId)
        {
            string[] listStringId = roomId.Split('-');

            int[] listIntId = new int[listStringId.Length - 1];

            for (int i = 0; i < listStringId.Length - 1; i++)
            {
                listIntId[i] = int.Parse(listStringId[i]);
            }
            Lodge lodgeNew = new Lodge();
            Lodge lodge = db.Lodges.SingleOrDefault(r => r.LodgeID == lodgeId);
            lodgeNew = lodge;
            lodgeNew.AvailableSlots = 0;
            lodgeNew.TotalSlotsInUsed = 0;
            //List<Room> listRoom = new List<Room>();
            //listRoom = lodge.Rooms.ToList();
            //foreach (var room in listRoom)
            //{
            //    room.CharityExamID = null;
            //    db.SaveChanges();
            //}
            lodgeNew.CharityExamID = ceId;
            lodgeNew.CharityID = cId;
            db.Lodges.Add(lodgeNew);
            db.SaveChanges();
            Lodge lodgeNewest = db.Lodges.FirstOrDefault(l => l.Address == lodgeNew.Address && l.CharityExamID == lodgeNew.CharityExamID);
            foreach (var i in listIntId)
            {
                Room roomNew = new Room();
                Room room = db.Rooms.SingleOrDefault(r => r.RoomID == i);

                roomNew = room;
                roomNew.LodgeID = lodgeNewest.LodgeID;
                roomNew.CharityExamID = lodgeNewest.CharityExamID;

                lodgeNewest.TotalSlotsInUsed += room.TotalSlots;
                lodgeNewest.AvailableSlots += room.TotalSlots;
                db.Rooms.Add(roomNew);
                db.SaveChanges();
            }
        }