private bool CheckCapacity(T_RegisteredStudentSemester value)
{
using (SMSNotification nofity = new SMSNotification())
{
var cap = nofity.GetRegisterStudent().Where(x => x.Day == value.Day && x.TImeEnd.ToShortTimeString() == value.TImeEnd.ToShortTimeString() && x.TimeStart.ToShortTimeString() == value.TimeStart.ToShortTimeString() && x.Semester == value.Semester && x.SemEndDate.ToShortDateString() == value.SemEndDate.ToShortDateString() && x.SemStartDate.ToShortDateString() == value.SemStartDate.ToShortDateString() && x.YearClass == value.YearClass && x.Active == true).ToList().Count;
//lblSelected.Text = string.Format("Selected",cap);
return(cap <= GetCapacity(value.RoomCode)?true:false);
}
}
void LoadRoomRecord()
{
int i = 1;
dgRoomRecord.Rows.Clear();
using (SMSNotification notify = new SMSNotification())
{
notify.GetRegisterStudent().OrderBy(o => o.TimeStart).ToList().ForEach(x =>
{
using (Maintenance maintain = new Maintenance())
{
using (Students stud = new Students())
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
}
}
});
}
}
void LoadSearch(bool Year, bool Semester, bool Room, bool Subject)
{
dgRoomRecord.Rows.Clear();
int i = 1;
using (SMSNotification notify = new SMSNotification())
{
using (Maintenance maintain = new Maintenance())
{
using (Students stud = new Students())
{
if (!Year && !Semester && !Room && !Subject)
{
LoadRoomRecord();
}
if (Year && Semester && Room && Subject)//four
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Year) //four
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Semester) //four
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Room) //four
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Subject)//four
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Year && Semester && Room)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Year && Semester && Subject)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Semester && Room && Subject)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Year && Room && Subject)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Year && Semester)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Year && Room)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Year && Subject)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Semester && Room)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Semester && Subject)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
if (Room && Subject)
{
dgRoomRecord.Rows.Clear();
var value = notify.GetRegisterStudent().Where(x => x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList();
if (value.Count > 0)
{
value.ForEach(x =>
{
var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault();
var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault();
dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString());
i++;
});
}
}
}
}
}
}