public int CheckIfRoomAvailable(HostelRooms room, string currentTerm, string usercode, double ratio)
{
var bookings = _context.HostelBooking.Count(b => b.Hostel == room.Names && b.Term == currentTerm);
if (room.Maxacc == null)
{
return(0);
}
var initials = _context.SysSetup.FirstOrDefault()?.SubTitle;
if (initials.ToUpper().Equals("PCKTTI"))
{
room.Maxacc = room.Maxacc == null ? 0 : room.Maxacc;
var maxAcc = Math.Round((double)room.Maxacc * ratio, MidpointRounding.AwayFromZero);
room.Maxacc = (int)maxAcc;
var sponsor = _context.Register.FirstOrDefault(r => r.AdmnNo.ToUpper().Equals(usercode.ToUpper()))?.Sponsor;
var students = _context.Register.Where(r => r.Sponsor.ToUpper().Equals(sponsor.ToUpper())).Select(r => r.AdmnNo.ToUpper()).ToList();
bookings = _context.HostelBooking.Count(b => b.Hostel == room.Names && b.Term == currentTerm && students.Contains(b.AdmnNo.ToUpper()));
}
return((int)room.Maxacc - bookings);
}
public bool CheckHostelForSpace(HostelRooms hostelRoom)
{
var bookings = _context.HostelBooking.Where(h => h.Hostel == hostelRoom.Names).ToList();
return(true);
}
