public bool ConditionDeleteOffice() { IEnumerable <ClassTerm> query = from elem in ClassSqlCalendar.ListOfTerms() where elem.Office.OfficeId == ((ClassOffice)DataGridListOfOffice.SelectedItem).OfficeId select elem; if (query.Any()) { string data = "This office cannot be removed because at this days meetings are being hosted in said of it: \n"; foreach (ClassTerm queryResult in query) { data += queryResult.Date.ToShortDateString() + "\n"; } MessageBox.Show(data); return(false); } IEnumerable <ClassDoctor> query2 = from elem in ClassSQLConnections.DoctorList() where elem.OfficeNumber == ((ClassOffice)DataGridListOfOffice.SelectedItem).OfficeId select elem; if (query2.Any()) { MessageBox.Show("This Office is currently occupied by " + query2.First().Name + " " + query2.First().Surname); return(false); } return(true); }
private void LoadDataToDataGrid() { //Load data to DataGrid try { DataGridListOfDoctors.ItemsSource = ClassSQLConnections.DoctorList(); } catch (Exception ex) { MessageBox.Show(ex.Message + "\n Try again later", "Error"); } }
private static List <ClassDoctor> ListOfActiveDoctors() { List <ClassDoctor> allDoctorList = ClassSQLConnections.DoctorList(); List <ClassDoctor> DoctorList = new List <ClassDoctor>(); foreach (ClassDoctor item in allDoctorList) { if (item.Active == true) { DoctorList.Add(item); } } return(DoctorList); }
public List <ClassDoctor> DoctorList() { return(ClassSQLConnections.DoctorList()); }