public MainWindow() { InitializeComponent(); DoorsDS DoorsDS = ((DoorsDS)(this.FindResource("DoorsDS"))); DoorsDSTableAdapters.departmentTableAdapter DoorsDSdepartmentTableAdapter = new DoorsDSTableAdapters.departmentTableAdapter(); // Загрузить данные в таблицу department. DoorsDSdepartmentTableAdapter = new DoorsDSTableAdapters.departmentTableAdapter(); DoorsDSdepartmentTableAdapter.Fill(DoorsDS.department); // Загрузить данные в таблицу workers. DoorsDSTableAdapters.workersTableAdapter DoorsDSworkersTableAdapter = new DoorsDSTableAdapters.workersTableAdapter(); DoorsDSworkersTableAdapter.Fill(DoorsDS.workers); // Загрузить данные в таблицу rooms. DoorsDSTableAdapters.roomsTableAdapter DoorsDSroomsTableAdapter = new DoorsDSTableAdapters.roomsTableAdapter(); DoorsDSroomsTableAdapter.Fill(DoorsDS.rooms); // Загрузить данные в таблицу access_department. DoorsDSTableAdapters.access_departmentTableAdapter DoorsDSaccess_departmentTableAdapter = new DoorsDSTableAdapters.access_departmentTableAdapter(); DoorsDSaccess_departmentTableAdapter.Fill(DoorsDS.access_department); // Загрузить данные в таблицу access_workers. DoorsDSTableAdapters.access_workersTableAdapter DoorsDSaccess_workersTableAdapter = new DoorsDSTableAdapters.access_workersTableAdapter(); DoorsDSaccess_workersTableAdapter.Fill(DoorsDS.access_workers); }
private void Window_Loaded(object sender, RoutedEventArgs e) { DoorsDS DoorsDS = ((DoorsDS)(this.FindResource("DoorsDS"))); // Загрузить данные в таблицу access_department. Doors.DoorsDSTableAdapters.access_departmentTableAdapter DoorsDSaccess_departmentTableAdapter = new Doors.DoorsDSTableAdapters.access_departmentTableAdapter(); DoorsDSaccess_departmentTableAdapter.Fill(DoorsDS.access_department); System.Windows.Data.CollectionViewSource access_departmentViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("access_departmentViewSource"))); access_departmentViewSource.View.MoveCurrentToFirst(); }
private void Give_Access(object sender, RoutedEventArgs e) { DoorsDS DoorsDS = ((DoorsDS)(this.FindResource("DoorsDS"))); List <int> roomsList = listID(st1); List <int> departamentList = listID(st2); List <int> workersList = listID(st3); GiveAccess x = new GiveAccess(); string message = x.Give_Access(roomsList, departamentList, workersList, DoorsDS); MessageBox.Show(message); }
private void addComboBox(StackPanel stn, string table) { DoorsDS DoorsDS = ((DoorsDS)(this.FindResource("DoorsDS"))); ComboBox combobox = new ComboBox(); combobox.IsDropDownOpen = true; combobox.ItemsSource = DoorsDS.Tables[table].DefaultView; combobox.DisplayMemberPath = "name"; combobox.SelectedValuePath = "id"; int stnl = stn.Children.Count - 1; Button buttonAdd = (Button)stn.Children[stnl]; stn.Children.RemoveAt(stnl); stn.Children.Add(combobox); stn.Children.Add(buttonAdd); }
private void Check_Access(object sender, RoutedEventArgs e) { DoorsDS DoorsDS = ((DoorsDS)(this.FindResource("DoorsDS"))); List <int> roomsList = listID(st1); List <int> departamentList = listID(st2); List <int> workersList = listID(st3); List <string> roomsListItem = listItem(st1); List <string> departamentListItem = listItem(st2); List <string> workersListItem = listItem(st3); CheckAccess x = new CheckAccess(); string message = x.Check_Access(roomsList, departamentList, workersList, roomsListItem, departamentListItem, workersListItem, DoorsDS); MessageBox.Show(message); }
public string Give_Access(List <int> roomsList, List <int> departamentList, List <int> workersList, DoorsDS DoorsDS) { DoorsDSTableAdapters.access_departmentTableAdapter DoorsDSaccess_departmentTableAdapter = new DoorsDSTableAdapters.access_departmentTableAdapter(); DoorsDSaccess_departmentTableAdapter.Fill(DoorsDS.access_department); DoorsDSTableAdapters.access_workersTableAdapter DoorsDSaccess_workersTableAdapter = new DoorsDSTableAdapters.access_workersTableAdapter(); DoorsDSaccess_workersTableAdapter.Fill(DoorsDS.access_workers); DoorsDS.access_departmentRow newAccess_departmentRow; DoorsDS.access_workersRow newAccess_workersRow; string message = ""; try { for (int i = 0; i < roomsList.Count; i++) { for (int j = 0; j < workersList.Count; j++) { newAccess_workersRow = DoorsDS.access_workers.Newaccess_workersRow(); newAccess_workersRow.id_workers = workersList[j]; newAccess_workersRow.id_rooms = roomsList[i]; DoorsDS.access_workers.Rows.Add(newAccess_workersRow); } } DoorsDSaccess_workersTableAdapter.Update(DoorsDS.access_workers); message += "Доступ работникам пердоствлен\n"; } catch { message += "Доступ работникам не пердоствлен\n"; } //Save the new row to the database try { for (int i = 0; i < roomsList.Count; i++) { for (int j = 0; j < departamentList.Count; j++) { newAccess_departmentRow = DoorsDS.access_department.Newaccess_departmentRow(); newAccess_departmentRow.id_department = departamentList[j]; newAccess_departmentRow.id_rooms = roomsList[i]; DoorsDS.access_department.Rows.Add(newAccess_departmentRow); } } DoorsDSaccess_departmentTableAdapter.Update(DoorsDS.access_department); message += "Доступ отделам пердоствлен\n"; } catch { message += "Доступ отделам не пердоствлен\n"; } return(message); }
public string Check_Access(List <int> roomsList, List <int> departamentList, List <int> workersList, List <string> roomsListItem, List <string> departamentListItem, List <string> workersListItem, DoorsDS DoorsDS) { List <int> departamentAccessList = new List <int>(); string messageDepartament = ""; for (int i = 0; i < roomsList.Count; i++) { for (int j = 0; j < departamentList.Count; j++) { object[] key = new object[2]; key[0] = departamentList[j]; key[1] = roomsList[i]; try { string dr = DoorsDS.access_department.Rows.Find(key).ToString(); messageDepartament += " + " + departamentListItem[j] + " " + roomsListItem[i] + "\n"; departamentAccessList.Add(departamentList[j]); } catch { messageDepartament += " – " + departamentListItem[j] + " " + roomsListItem[i] + "\n"; } } } string messageWorker = ""; for (int i = 0; i < roomsList.Count; i++) { for (int j = 0; j < workersList.Count; j++) { object[] key = new object[2]; key[0] = workersList[j]; key[1] = roomsList[i]; try { string dr = DoorsDS.access_department.Rows.Find(key).ToString(); messageWorker += " + " + workersListItem[j] + " " + roomsListItem[i] + "\n"; } catch { messageWorker += " – " + workersListItem[j] + " " + roomsListItem[i] + "\n"; } } } string messageWorkerFromDepartament = ""; for (int i = 0; i < roomsList.Count; i++) { for (int j = 0; j < workersList.Count; j++) { try { DataRow dr = DoorsDS.workers.Rows.Find(workersList[j]); int fd = Convert.ToInt32(dr["id_department"]); for (int k = 0; k < departamentAccessList.Count; k++) { if (departamentAccessList[k] == fd) { messageWorkerFromDepartament += " + " + workersListItem[j] + " " + roomsListItem[i] + "\n"; } } } catch { } } } string message = ""; if (messageDepartament != "") { message += "Доступ отделам:\n" + messageDepartament + "\n"; } if (messageWorker != "") { message += "Доступ работникам:\n" + messageWorker + "\n"; } if (messageWorkerFromDepartament != "") { message += "Доступ работникам по отделу:\n" + messageWorkerFromDepartament; } if (message == "") { message = "Заполните поля для проверки"; } return(message); }