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; }
public MainWindow() { InitializeComponent(); AllTutorsTableAdapter tutorTableAdapt = new AllTutorsTableAdapter(); tutorTableAdapt.Fill(tutorTable); ScheduleTableAdapter scheduleAdapt = new ScheduleTableAdapter(); scheduleAdapt.Fill(scheduleTable); SubjectTableAdapter subjectAdapt = new SubjectTableAdapter(); subjectAdapt.Fill(subjectTable); tutorTableAdapt.Dispose(); scheduleAdapt.Dispose(); subjectAdapt.Dispose(); strImagePath = ConfigurationManager.AppSettings["ImagePath"]; strPPPath = ConfigurationManager.AppSettings["PPPath"]; DirectoryInfo dir = new DirectoryInfo(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, strImagePath)); foreach (FileInfo file in dir.EnumerateFiles()) { file.Delete(); } int numberVisibleSlides = 0; for (int i = 1; i < objSlides.Count; i++) { if (objSlides[i].SlideShowTransition.Hidden == MsoTriState.msoFalse) { objSlides[i].Export(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, strImagePath, i.ToString("D2", CultureInfo.CurrentCulture) + "_" + DateTime.Now.ToString("HH-mm-ss") + ".jpg"), "JPG"); numberVisibleSlides++; } } updateSlide = numberVisibleSlides; //Initialize Image control, Image directory path and Image timer. IntervalTimer = Convert.ToInt32(ConfigurationManager.AppSettings["IntervalTime"], CultureInfo.CurrentCulture); ImageControls = new[] { myImage, myImage2 }; timerImageChange = new DispatcherTimer { Interval = new TimeSpan(0, 0, IntervalTimer) }; timerImageChange.Tick += new EventHandler(TimerImageChange_Tick); clockUpdate = new DispatcherTimer() { Interval = new TimeSpan(0, 0, 1) }; clockUpdate.Tick += new EventHandler(ClockUpdate_Tick); }
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); } }
static void Init() { TutorDataSet db = new TutorDataSet(); db.Clear(); application.Visible = Microsoft.Office.Core.MsoTriState.msoTrue; objSSS.Run(); AllTutorsTableAdapter tutorTableAdapt = new AllTutorsTableAdapter(); tutorTableAdapt.Fill(tutorTable); ScheduleTableAdapter scheduleAdapt = new ScheduleTableAdapter(); scheduleAdapt.Fill(scheduleTable); SubjectTableAdapter subjectAdapt = new SubjectTableAdapter(); subjectAdapt.Fill(subjectTable); }
public Form() { AllTutorsTableAdapter tutorTableAdapt = new AllTutorsTableAdapter(); tutorTableAdapt.Fill(tutorTable); ScheduleTableAdapter scheduleAdapt = new ScheduleTableAdapter(); scheduleAdapt.Fill(scheduleTable); SubjectTableAdapter subjectAdapt = new SubjectTableAdapter(); subjectAdapt.Fill(subjectTable); tutorTableAdapt.Dispose(); scheduleAdapt.Dispose(); subjectAdapt.Dispose(); InitializeComponent(); Topmost = true; }
public MainWindow() { InitializeComponent(); AllTutorsTableAdapter tutorTableAdapt = new AllTutorsTableAdapter(); tutorTableAdapt.Fill(tutorTable); ScheduleTableAdapter scheduleAdapt = new ScheduleTableAdapter(); scheduleAdapt.Fill(scheduleTable); SubjectTableAdapter subjectAdapt = new SubjectTableAdapter(); subjectAdapt.Fill(subjectTable); tutorTableAdapt.Dispose(); scheduleAdapt.Dispose(); subjectAdapt.Dispose(); DirectoryInfo dir = new DirectoryInfo(AppDomain.CurrentDomain.BaseDirectory + "\\Images"); foreach (FileInfo file in dir.EnumerateFiles()) { file.Delete(); } for (int i = 1; i < objSlides.Count; i++) { objSlides[i].Export(AppDomain.CurrentDomain.BaseDirectory + "\\Images\\" + (i).ToString(CultureInfo.CurrentCulture) + ".jpg", "JPG"); } //Initialize Image control, Image directory path and Image timer. IntervalTimer = Convert.ToInt32(ConfigurationManager.AppSettings["IntervalTime"], CultureInfo.CurrentCulture); strImagePath = ConfigurationManager.AppSettings["ImagePath"]; ImageControls = new[] { myImage, myImage2 }; //LoadImageFolder(strImagePath); timerImageChange = new DispatcherTimer { Interval = new TimeSpan(0, 0, IntervalTimer) }; timerImageChange.Tick += new EventHandler(TimerImageChange_Tick); clockUpdate = new DispatcherTimer() { Interval = new TimeSpan(0, 0, 1) }; clockUpdate.Tick += new EventHandler(ClockUpdate_Tick); }
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; }
private void ShowFace_Invoked(StaffOutputInfo staffInfo, int ttl, bool enterExit) { if (staffInfo == null) { FlushFields(); return; } try { pic_face.Image = new Bitmap(staffInfo.PicturePath); } catch (Exception e) { MessageBox.Show(null, e.Message, "Ошибка"); } bool notInTime = true; #region CheckingTime _shAdapter.Fill(_shTable, staffInfo.Shedule); DateTime start; DateTime fin; DateTime.TryParse(_shTable.Rows[0][0].ToString(), out start); DateTime.TryParse(_shTable.Rows[0][1].ToString(), out fin); if (CompareHoursAndMinutes(DateTime.Now, fin) == 1 && CompareHoursAndMinutes(DateTime.Now, start) == -1) { notInTime = false; } #endregion l_fio.Text = staffInfo.Fio; l_division.Text = staffInfo.Division; l_number.Text = staffInfo.Number; l_profession.Text = staffInfo.Profession; l_shedule.Text = staffInfo.Shedule; l_uidType.Text = staffInfo.UidType; l_actionTime.Text = DateTime.Now.ToString(); if (enterExit) { //l_action.Text = "Выход"; pB_vihod.Visible = true; pB_vihod.BringToFront(); } else { pB_enter.Visible = true; pB_enter.BringToFront(); //l_action.Text = "Проход"; } pB_notInTime.Visible = notInTime; l_blocked.Visible = staffInfo.Blocked; this.WindowState = FormWindowState.Minimized; this.WindowState = FormWindowState.Normal; this.Show(); this.WindowState = FormWindowState.Normal; this.Focus(); this.CenterToScreen(); if (ttl > 0) { Timer tmr = new Timer { Interval = ttl }; tmr.Start(); tmr.Tick += tmr_Tick; } }