void dgRoom_CellClick(object sender, DataGridViewCellEventArgs e) { SystemProperties.Cleared(this, false, true, true); if (dgRoom.Rows.Count > 0) { using (Maintenance _maintain = new Maintenance()) { var value = _maintain.GetRoom().Where(x => x.ID == Convert.ToInt64(dgRoom.SelectedRows[0].Cells[0].Value)).FirstOrDefault(); if (value != null) { cmbRoomType.Text = value.RoomType; txtRoomCode.Text = value.RoomCode; txtDescription.Text = value.Description; cmbBuildingCode.Text = value.BuildingCode; txtLocationAddress.Text = _maintain.GetBuildingCode().Where(x => x.BuildingCode == value.BuildingCode).FirstOrDefault().BuildingName; txtCapacity.Value = value.Capacity.Value; cbActive.Checked = value.Active.Value; LoadTime(value.RoomCode); btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString()); btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString()); GetRoomDevice(value.RoomCode); } } } }
void GetRoomDescription(string RoomCode) { txtRoomDesc.Text = ""; using (Maintenance maintain = new Maintenance()) { txtRoomDesc.Text = maintain.GetRoom().Where(x => x.Active == true && x.RoomCode == RoomCode).FirstOrDefault().Description; } }
private int GetCapacity(string RoomCode) { using (Maintenance maintain = new Maintenance()) { int retCap = 0; retCap = maintain.GetRoom().Where(x => x.RoomCode == RoomCode).FirstOrDefault().Capacity.Value; lblMessageCheckRecord.Text = string.Format("Room capacity: {0} ", retCap); return(retCap); } }
void LoadRoom() { cmbRoomCode.Items.Clear(); using (Maintenance maintain = new Maintenance()) { maintain.GetRoom().Where(x => x.Active == true).OrderBy(o => o.RoomCode).ToList().ForEach(f => { cmbRoomCode.Items.Add(f.RoomCode); }); } }
void LoadRoomCode() { cmbRoomCode.Items.Clear(); using (Maintenance maintain = new Maintenance()) { maintain.GetRoom().ForEach(x => { cmbRoomCode.Items.Add(x.RoomCode); }); } }
void loadRoom() { int i = 1; dgRoom.Rows.Clear(); using (Maintenance _maintain = new Maintenance()) { _maintain.GetRoom().OrderBy(o => o.RoomCode).ToList().ForEach(x => { dgRoom.Rows.Add(x.ID, i, x.RoomCode, x.Description, x.RoomType, x.BuildingCode, x.Capacity, x.Active); i++; }); } ObjEnable(false); dgTime.Enabled = 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 GetRoomSubjectMessage() { cmbMessage.Items.Clear(); cmbRoomCode.Items.Clear(); cmbSubjectCode.Items.Clear(); using (Maintenance maintain = new Maintenance()) { maintain.GetRoom().Where(x => x.Active == true).OrderBy(o => o.RoomCode).ToList().ForEach(y => { cmbRoomCode.Items.Add(y.RoomCode); }); maintain.GetSubject().Where(x => x.Active == true).OrderBy(o => o.Code).ToList().ForEach(y => { cmbSubjectCode.Items.Add(y.Code); }); } using (SMSNotification smsNotify = new SMSNotification()) { smsNotify.GetSMS().Where(x => x.Active == true).ToList().ForEach(s => { cmbMessage.Items.Add(s.Code); }); } }
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++; }); } } } } } }