//Removes doctor from Doctors table in DataBase private void ButtonRemove_Click(object sender, RoutedEventArgs e) { //Check if user selected doctor if (DataGridListOfEmployee.SelectedIndex == -1) { MessageBox.Show("Select the row corresponding to the employee", "No row selected"); return; } foreach (int index in ClassSQLConnections.EmployeesThatAreDoctors()) { if (((ClassEmployee)DataGridListOfEmployee.SelectedItem).EmployeeId == index) { MessageBox.Show("Doctor cannot be removed. Choose another empolyee", "Choose another employee"); return; } } try { ClassSQLConnections.DeleteEmployee(((ClassEmployee)DataGridListOfEmployee.SelectedItem).EmployeeId); LoadDataToDataGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ButtonRemove_Click(object sender, RoutedEventArgs e) { if (DataGridListOfUser.SelectedIndex == -1) { MessageBox.Show("Select the row corresponding to the user", "No row selected"); return; } try { if (!CheckIfSelectedUserIsNotAssigned(((ClassUser)DataGridListOfUser.SelectedItem))) { MessageBox.Show("To remove user he can't be assigned to any employee"); return; } ClassSQLConnections.DeleteUser(((ClassUser)DataGridListOfUser.SelectedItem).User_id); LoadDataToDataGridListOfUser(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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 Button_Click_1(object sender, RoutedEventArgs e) { if (DataGridListOfPermission.SelectedIndex == -1) { MessageBox.Show("Select the row corresponding to the permission", "No row selected"); return; } int permissionId = ((ClassPermission)DataGridListOfPermission.SelectedItem).PermissionId; try { if (!CheckIfPermissionIsNotAssigned(permissionId)) { MessageBox.Show("To remove permission it can't be assigned to any user"); return; } ClassSQLConnections.DeletePermission(permissionId); LoadDataToDataGridListOfPermission(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private bool CheckIfPermissionIsNotAssigned(int permissionId) { foreach (int index in ClassSQLConnections.NotAssignedPermission()) { if (permissionId == index) { return(true); } } return(false); }
private void LoadDataToDataGrid() { //Load data to DataGrid try { DataGridListOfOffice.ItemsSource = ClassSQLConnections.OfficeList(); } catch (Exception ex) { MessageBox.Show(ex.Message + "\n Try again later", "Error"); } }
private void Button_Click(object sender, RoutedEventArgs e) { if (TextBoxPermission.Text.Equals("")) { MessageBox.Show("To add new permission textbox must not be empty"); return; } ClassPermission permission = new ClassPermission(TextBoxPermission.Text); ClassSQLConnections.AddPermission(permission); LoadDataToDataGridListOfPermission(); }
private bool CheckIfSelectedUserIsNotAssigned(ClassUser user) { foreach (ClassUser notAssignedUser in ClassSQLConnections.NotSpecifiedUsers()) { if (user.User_id == notAssignedUser.User_id) { return(true); } } return(false); }
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); }
private void UpdateDoctor(ClassDoctor doctor, bool AddNewDoctor) { //try { if (!AddNewDoctor) { ClassSQLConnections.UpdateDoctor(doctor); return; } ClassSQLConnections.AddDoctor(doctor); } //catch (Exception ex) { //MessageBox.Show(ex.Message + "\n Try again later", "Error"); } }
private void UpdateUser(ClassUser user, bool AddNew) { try { if (!AddNew) { ClassSQLConnections.UpdateUser(user); return; } ClassSQLConnections.AddUser(user); } catch (Exception ex) { MessageBox.Show(ex.Message + "\n Try again later", "Error"); } }
private void UpdateOffice(ClassOffice office, bool AddNew) { //Update doctor info in data base try { //If user choose edit if (!AddNew) { ClassSQLConnections.UpdateOffice(office); return; } //If user choose add ClassSQLConnections.AddNewOffice(office); } catch (Exception ex) { MessageBox.Show(ex.Message + "\n Try again later", "Error"); } }
private void ButtonRemove_Click(object sender, RoutedEventArgs e) { //Check if user selected doctor if (DataGridListOfOffice.SelectedIndex == -1) { MessageBox.Show("Select the row corresponding to the office", "No row selected"); return; } try { if (ConditionDeleteOffice()) { ClassSQLConnections.DeleteOffice(((ClassOffice)DataGridListOfOffice.SelectedItem).OfficeId); } LoadDataToDataGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Button_AcceptCalendarClick(object sender, RoutedEventArgs e) { ClassCalendar calendar = GetCalendarForSelectedCalendarInComboboxFromDataBase(); foreach (ClassCalendarDay day in days) { if (day.IsWorkingDay == true) { int dayId = ClassSqlCalendar.GetDayIdForCalendarDate(calendar.CalendarId, day.DateInDateTime.Day); ClassSqlCalendar.CreateTerm(day.StartTime, day.EndTime, ClassSqlCalendar.GetCalendarIdForDoctor(ClassLoggedDoctor.Doctor_Id, calendar.CalendarId), dayId, ClassSQLConnections.GetOfficeIdForDoctor(ClassLoggedDoctor.Doctor_Id), ClassLoggedDoctor.Doctor_Id, day.Date); } } ClassSqlCalendar.UpdateCalendarStatus(ClassSqlCalendar.SelectStatusId(EnumStatus.AcceptedByTheDoctor), calendar.CalendarId); NavigationService.Navigate(new WindowDoctorNewCalendarEmpty()); }
public List <ClassDoctor> DoctorList() { return(ClassSQLConnections.DoctorList()); }
private void ButtonAdd_Click(object sender, RoutedEventArgs e) { if (workingDayFrom.SelectedItem == null || workingDayTo.SelectedItem == null || AvailableDate.SelectedItem == null) { MessageBox.Show("You cannot leave any empty combobox!"); return; } ClassCalendar calendar = GetCalendarForCurrentDate(); int dayId = ClassSqlCalendar.GetDayIdForCalendarDate(calendar.CalendarId, ((ClassCalendarDay)AvailableDate.SelectedItem).DateInDateTime.Day); ClassSqlCalendar.CreateTerm((TimeSpan)workingDayFrom.SelectedItem, (TimeSpan)workingDayTo.SelectedItem, ClassSqlCalendar.GetCalendarIdForDoctor(ClassLoggedDoctor.Doctor_Id, calendar.CalendarId), dayId, ClassSQLConnections.GetOfficeIdForDoctor(ClassLoggedDoctor.Doctor_Id), ClassLoggedDoctor.Doctor_Id, ((ClassCalendarDay)AvailableDate.SelectedItem).Date); this.DialogResult = true; this.Close(); }
private void ButtonLogging_Click(object sender, RoutedEventArgs e) { //Getting data from the form string login = TextBoxLogin.Text; string password = PasswordBoxPassword.Password; bool correctData; try { correctData = ClassSQLConnection.CheckLoginDetails(login, password); } catch (Exception ex) { MessageBox.Show(ex.Message + "\nTry again later", "Error"); return; } //Invalid data if (!correctData) { failedAttempts++; string message = "Incorrect password or login"; if (failedAttempts == 2) { message += "\nNext unsuccessful attempt will block the login for five minutes"; } MessageBox.Show(message, "Incorrect data"); if (failedAttempts < 3) { return; } //Block app ButtonLogging.IsEnabled = false; TextBlockNextTry.Visibility = Visibility.Visible; TextBoxLogin.IsEnabled = false; PasswordBoxPassword.IsEnabled = false; TextBoxLogin.Text = ""; PasswordBoxPassword.Password = ""; //Time counting ClassTimer ct = new ClassTimer(5, 0, this); ct.StartTimer(); return; } try { ClassPermission permission = ClassSQLConnections.GetUserType(login, password); if (permission.Permission == "Administrator") { //Opening MainWindow Main.OpenAdministratorWindow(); return; } if (permission.Permission == "Doctor") { ClassLoggedDoctor.Doctor_Id = ClassSQLConnections.GetLoggedDoctorId(login, password); Main.OpenDoctorWindow(); return; } Main.OpenMainWindow(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }