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