Esempio n. 1
0
        private void LoadDataSet()
        {
            Cursor.Current = Cursors.WaitCursor;

            try
            {
                communicatorDataSet.EnforceConstraints = false;

                SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
                symbolAdapter.Fill(communicatorDataSet.Symbol);

                ScenarioTableAdapter scenarioAdapter = new ScenarioTableAdapter();
                scenarioAdapter.Fill(communicatorDataSet.Scenario);

                TextTableAdapter textAdapter = new TextTableAdapter();
                textAdapter.Fill(communicatorDataSet.Text);

                communicatorDataSet.EnforceConstraints = true;
                communicatorDataSet.AcceptChanges();
            }
            catch (Exception ex)
            {
                ReportError(ex.Message.ToString());
            }

            RefreshScenarioListView();

            this.EnableButtons();

            Cursor.Current = Cursors.Default;
        }
Esempio n. 2
0
        private void LoadDataSet()
        {
            Cursor.Current = Cursors.WaitCursor;

            try
            {
                adaScenarioDataSet1.EnforceConstraints = false;

                SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
                symbolAdapter.Fill(adaScenarioDataSet1.Symbol);

                ScenarioTableAdapter scenarioAdapter = new ScenarioTableAdapter();
                scenarioAdapter.Fill(adaScenarioDataSet1.Scenario);

                TextTableAdapter textAdapter = new TextTableAdapter();
                textAdapter.Fill(adaScenarioDataSet1.Text);

                adaScenarioDataSet1.EnforceConstraints = true;
            }
            catch (Exception ex)
            {
                ReportError(ex);
            }

            RefreshViews();

            Cursor.Current = Cursors.Default;
        }
Esempio n. 3
0
        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;
        }
Esempio n. 4
0
        private void SymbolDetailForm_Load(object sender, EventArgs e)
        {
            try
            {
                LocalizedSymbolNameTableAdapter localizedSymbolNameAdapter = new LocalizedSymbolNameTableAdapter();
                localizedSymbolNameAdapter.Fill(this.symbolDetailDataSet.LocalizedSymbolName, symbolId, cultureName);

                if (symbolId > 0)
                {
                    SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
                    symbolAdapter.Fill(this.symbolDetailDataSet.Symbol, symbolId);
                }

                byte[] image = this.symbolDetailDataSet.Symbol.Rows[0]["Image"] as byte[];
                if (image != null)
                {
                    this.pictureBoxImage.Image = ImageEngine.Resize(ImageEngine.FromArray(image), this.pictureBoxImage.Size);
                }

                EnableButtons();
            }
            catch (Exception ex)
            {
                ReportError(ex.Message.ToString());
                this.DialogResult = DialogResult.Abort;
                this.Close();
            }
        }
Esempio n. 5
0
        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);
            }
        }
Esempio n. 6
0
        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);
            }
        }
Esempio n. 7
0
        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;
        }