private void LoadDataSet() { Cursor = Cursors.WaitCursor; try { _dataSet.EnforceConstraints = false; UserTableAdapter UserAdapter = new UserTableAdapter(); UserAdapter.Fill(_dataSet.User); ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Fill(_dataSet.Schedule); ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Fill(_dataSet.Activity); _dataSet.EnforceConstraints = true; FillUserList(); } catch (Exception ex) { ReportError(ex); } Cursor = Cursors.Default; }
private void LoadDataSet() { Cursor.Current = Cursors.WaitCursor; try { adaScheduleDataSet1.EnforceConstraints = false; UserTableAdapter userAdapter = new UserTableAdapter(); userAdapter.Fill(adaScheduleDataSet1.User); ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Fill(adaScheduleDataSet1.Schedule); SymbolTableAdapter symbolAdapter = new SymbolTableAdapter(); symbolAdapter.Fill(adaScheduleDataSet1.Symbol); ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Fill(adaScheduleDataSet1.Activity); adaScheduleDataSet1.EnforceConstraints = true; } catch (Exception ex) { ReportError(ex); } RefreshViews(); Cursor.Current = Cursors.Default; }
private void LoadDataSet(ADAScheduleDataSet dataSet, DateTime date, bool loadSymbol) { try { dataSet.EnforceConstraints = false; UserTableAdapter userAdapter = new UserTableAdapter(); userAdapter.Fill(dataSet.User); ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Fill(dataSet.Schedule, date); if (loadSymbol) { SymbolTableAdapter symbolAdapter = new SymbolTableAdapter(); symbolAdapter.Fill(dataSet.Symbol, date); } ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Fill(dataSet.Activity, date); ReminderTableAdapter reminderAdapter = new ReminderTableAdapter(); reminderAdapter.Fill(dataSet.Reminder); Activity_ReminderTableAdapter arAdapter = new Activity_ReminderTableAdapter(); arAdapter.Fill(dataSet.Activity_Reminder, date); if (loadSymbol) { dataSet.EnforceConstraints = true; foreach (ADAScheduleDataSet.ActivityRow activityRow in dataSet.Activity.Rows) { if (!activityRow.IsSymbolIdNull() && !activityRow.SymbolRow.IsImageNull()) { activityRow.Image = activityRow.SymbolRow.Image; } } } dataSet.AcceptChanges(); } catch (Exception ex) { ReportError(ex); } }
private void LoadDataSet(ADAWorkSystemDataSet dataSet, bool loadSymbol) { try { dataSet.EnforceConstraints = false; ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Fill(dataSet.Schedule); if (loadSymbol) { SymbolTableAdapter symbolAdapter = new SymbolTableAdapter(); symbolAdapter.Fill(dataSet.Symbol); } ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Fill(dataSet.Activity); if (loadSymbol) { dataSet.EnforceConstraints = true; foreach (ADAWorkSystemDataSet.ActivityRow activityRow in dataSet.Activity.Rows) { if (!activityRow.IsSymbolIdNull() && !activityRow.SymbolRow.IsImageNull()) { activityRow.Image = activityRow.SymbolRow.Image; } } } dataSet.AcceptChanges(); } catch (Exception ex) { ReportError(ex); } }
private void LoadDataSet() { Cursor.Current = Cursors.WaitCursor; DateTime date = DateTime.Now.Date; string userName = (string)ReadRegistry(Registry.CurrentUser, "Name", "ControlPanel", "Owner"); try { adaScheduleDataSet1.EnforceConstraints = false; UserTableAdapter userAdapter = new UserTableAdapter(); userAdapter.Fill(adaScheduleDataSet1.User, userName); ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Fill(adaScheduleDataSet1.Schedule, date, userName); SymbolTableAdapter symbolAdapter = new SymbolTableAdapter(); symbolAdapter.Fill(adaScheduleDataSet1.Symbol, date, userName); ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Fill(adaScheduleDataSet1.Activity, date, userName); adaScheduleDataSet1.EnforceConstraints = true; } catch (Exception ex) { ReportError(ex); } _activityRows = adaScheduleDataSet1.Activity.Select("", "Sequence ASC"); RefreshViews(); Cursor.Current = Cursors.Default; }