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