public SecurityForm() { _staffTable = new Access_control_in_OneWire.StaffDataTable(); _staffTableAdapter = new StaffTableAdapter(); _staffTableAdapter.ClearBeforeFill = true; _staffTableAdapter.Fill(_staffTable); _eventLogAdapter = new JoinedEventLogAdapter(); _eventLogAdapter.ClearBeforeFill = true; _eventLogAdapter.Adapter.InsertCommand.Connection = _eventLogAdapter.Connection; _shAdapter.ClearBeforeFill = true; _shTable = new Access_control_in_OneWire.ScheduleDataTable(); //try{ _dialog = new UIDCOMDialog(Properties.Settings.Default.COMName, Properties.Settings.Default.BaudRate, 8, _listener_UIDReceived); //} //catch(Exception) //{ // MessageBox.Show(this, "Не удалось получить доступ к COM-порту.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error); // this.Close(); /// return; //} InitializeComponent(); this.CenterToScreen(); }
private void Form1_Load(object sender, EventArgs e) { ITODataSet.StaffDataTable staffTbl = new ITODataSet.StaffDataTable(); StaffTableAdapter dAdapt = new StaffTableAdapter(); dAdapt.Fill(staffTbl); dataGridView1.DataSource = staffTbl; }
public static void LoadData() { var userAdapter = new UserTableAdapter(); var userData = userAdapter.GetData(); foreach (var row in userData) { var newRow = DataSet.User.NewUserRow(); newRow.ID = row.ID; newRow.LastName = row.LastName; newRow.FirstName = row.FirstName; newRow.MiddleName = row.IsMiddleNameNull() ? "" : row.MiddleName; newRow.Type = row.Type; DataSet.User.AddUserRow(newRow); } var machineAdapter = new MachineTableAdapter(); var machineData = machineAdapter.GetData(); foreach (var row in machineData) { var newRow = DataSet.Machine.NewMachineRow(); newRow.ID = row.ID; newRow.IsFinalized = row.IsFinalized; newRow.IsResultsViewed = row.IsResultsViewed; newRow.Name = row.IsNameNull() ? "" : row.Name; DataSet.Machine.AddMachineRow(newRow); } var staffAdapter = new StaffTableAdapter(); var staffData = staffAdapter.GetData(); foreach (var row in staffData) { var newRow = DataSet.Staff.NewStaffRow(); newRow.UserRow = DataSet.User.FindByID(row.UserID); newRow.Username = row.Username; newRow.Password = row.Password; DataSet.Staff.AddStaffRow(newRow); } var voterAdapter = new VoterTableAdapter(); var voterData = voterAdapter.GetData(); foreach (var row in voterData) { var newRow = DataSet.Voter.NewVoterRow(); newRow.ID = row.ID; newRow.GradeLevel = row.GradeLevel; newRow.StrandSection = row.StrandSection; newRow.IsMale = row.IsMale; newRow.Birthday = row.Birthday; newRow.VoterID = row.VoterID; newRow.IsForeign = row.IsForeign; newRow.MachineRow = DataSet.Machine.FindByID(row.MachineID); DataSet.Voter.AddVoterRow(newRow); } }
public void FilllbStaff(string DepID) { lbStaff.Items.Clear(); StaffTableAdapter dAdapt = new StaffTableAdapter(); ITO_DAL.dsITO.StaffDataTable staffTbl = new dsITO.StaffDataTable(); dAdapt.Fill(staffTbl); string filterString = "DepartmentID=" + DepID; DataRow[] staff = staffTbl.Select(filterString); //Отбражаем организационные единицы верхнего уровня UpDepID NULL for (int i = 0; i < staff.Length; i++) { ListElement le = new ListElement(staff[i]["UserID"].ToString(), staff[i]["LastName"].ToString() + " " + staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString()); lbStaff.Items.Add(le); //lbStaff.Items // lvStaff.Items.Add(staff[i]["UserID"].ToString(), staff[i]["LastName"].ToString() + " " + // staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString(),0); } }
private void button1_Click(object sender, EventArgs e) { listBox1.Items.Clear(); checkedListBox1.Items.Clear(); ADMethodsAccountManagement ADcon = new ADMethodsAccountManagement(); StaffTableAdapter dAdapt = new StaffTableAdapter(); ITO_DAL.dsITO.StaffDataTable staffTbl = new dsITO.StaffDataTable(); dAdapt.Fill(staffTbl); string filterString = "State > 0"; // DataRow[] staff = staffTbl.Select(filterString); DataRow[] staff = staffTbl.Select(filterString); //Отбражаем организационные единицы верхнего уровня UpDepID NULL for (int i = 0; i < staff.Length; i++) { if (!ADcon.IsUserExisiting(staff[i]["Login"].ToString())) { listBox1.Items.Add(staff[i]["Login"].ToString() + " " + staff[i]["LastName"].ToString() + " " + staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString() + " not exist"); checkedListBox1.Items.Add(staff[i]["Login"].ToString()); } // staff[i]["Login"].ToString() //lbStaff.Items // lvStaff.Items.Add(staff[i]["UserID"].ToString(), staff[i]["LastName"].ToString() + " " + // staff[i]["Name"].ToString() + " " + staff[i]["SecondName"].ToString(),0); } }
public EmployeeModelController(MainForm mainForm) { this.mainForm = mainForm; staffTableAdapter = new StaffTableAdapter(); }