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); }
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); }