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 cleanToolStripMenuItem_Click(object sender, EventArgs e) { SelectDateForm selectDateForm = new SelectDateForm(); selectDateForm.SelectionRange.Start = monthCalendar1.SelectionStart.AddDays(-1); selectDateForm.SelectionRange.End = selectDateForm.SelectionRange.Start; if (selectDateForm.ShowDialog(this) == DialogResult.OK) { Cursor.Current = Cursors.WaitCursor; try { ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Connection.Open(); SqlCommand cmd = scheduleAdapter.Connection.CreateCommand(); cmd.CommandText = "update [Schedule] set [IsActive]='false' where [Date] < @Date"; cmd.Parameters.Add("@Date", SqlDbType.DateTime); cmd.Parameters[0].Value = DateTime.Now.Date; cmd.ExecuteNonQuery(); scheduleAdapter.Connection.Close(); } catch (Exception ex) { ReportError(ex); } Cursor.Current = Cursors.Default; LoadDataSet(); } }
private void SaveDataSet() { Cursor.Current = Cursors.WaitCursor; DateTime date = monthCalendar1.SelectionStart; try { adaScheduleDataSet1.EnforceConstraints = false; Activity_ReminderTableAdapter arAdapter = new Activity_ReminderTableAdapter(); arAdapter.Update(adaScheduleDataSet1.Activity_Reminder.Select("", "", DataViewRowState.Deleted)); ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Update(adaScheduleDataSet1); ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Update(adaScheduleDataSet1); ReminderTableAdapter reminderAdapter = new ReminderTableAdapter(); reminderAdapter.Update(adaScheduleDataSet1); arAdapter.Update(adaScheduleDataSet1); adaScheduleDataSet1.EnforceConstraints = true; adaScheduleDataSet1.AcceptChanges(); } catch (Exception ex) { ReportError(ex); } Cursor.Current = Cursors.Default; }
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; }
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 UpdateWorkSystemInstance() { Cursor.Current = Cursors.WaitCursor; if (_scheduleRow != null) { try { _scheduleRow.IsActive = false; ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); int ret = scheduleAdapter.Update(adaScheduleDataSet1.Schedule); RefreshViews(); } catch (Exception ex) { ReportError(ex); } Cursor.Current = Cursors.Default; } }
private void UpdateSchedule() { Cursor.Current = Cursors.WaitCursor; if (adaScheduleDataSet1.Schedule.Rows.Count > 0) { try { ADAMobileDataSet.ScheduleRow scheduleRow = adaScheduleDataSet1.Schedule.Rows[0] as ADAMobileDataSet.ScheduleRow; scheduleRow.IsActive = false; ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); int ret = scheduleAdapter.Update(adaScheduleDataSet1.Schedule); } catch (Exception ex) { ReportError(ex); } Cursor.Current = Cursors.Default; } }
private bool AddWorkSystemInstance(ADAMobileDataSet.ActivityRow activityRow) { bool result = true; Cursor.Current = Cursors.WaitCursor; try { //ADAMobileDataSet.UserDataTable userTable = adaScheduleDataSet1.User; //if (userTable.Count > 0 && _userName != null // && _userName.Length > 0 && userTable.Rows[0]["Name"] != _userName) //{ // userTable.Rows[0]["Name"] = _userName; // UserTableAdapter userAdapter = new UserTableAdapter(); // int number = userAdapter.Update(adaScheduleDataSet1.User); //} adaScheduleDataSet1.EnforceConstraints = false; ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Init(); int ret = scheduleAdapter.Update(adaScheduleDataSet1.Schedule); ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Init(); ret = activityAdapter.Update(adaScheduleDataSet1.Activity); adaScheduleDataSet1.EnforceConstraints = true; } catch (Exception ex) { ReportError(ex); result = false; } Cursor.Current = Cursors.Default; return(result); }
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 SaveDataSet() { Cursor.Current = Cursors.WaitCursor; try { adaWorkSystemDataSet1.EnforceConstraints = false; ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); scheduleAdapter.Update(adaWorkSystemDataSet1); ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Update(adaWorkSystemDataSet1); adaWorkSystemDataSet1.EnforceConstraints = true; adaWorkSystemDataSet1.AcceptChanges(); } catch (Exception ex) { ReportError(ex); } Cursor.Current = Cursors.Default; }
private void copyToolStripMenuItem_Click(object sender, EventArgs e) { SelectDateForm selectDateForm = new SelectDateForm(); if (selectDateForm.ShowDialog(this) == DialogResult.OK) { for (DateTime copyToDate = selectDateForm.SelectionRange.Start; copyToDate.CompareTo(selectDateForm.SelectionRange.End) <= 0; copyToDate = copyToDate.AddDays(1)) { Cursor.Current = Cursors.WaitCursor; ADAScheduleDataSet dataSet = new ADAScheduleDataSet(); try { LoadDataSet(dataSet, copyToDate, false); DataRow[] scheduleRows = dataSet.Schedule.Select("Type <= " + 1); foreach (ADAScheduleDataSet.ScheduleRow scheduleRow in scheduleRows) { scheduleRow.Delete(); } ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter(); ActivityTableAdapter activityAdapter = new ActivityTableAdapter(); activityAdapter.Update(dataSet); scheduleAdapter.Update(dataSet); scheduleRows = adaScheduleDataSet1.Schedule.Select("Type <= " + 1); foreach (ADAScheduleDataSet.ScheduleRow scheduleRow in scheduleRows) { ADAScheduleDataSet.ScheduleRow newScheduleRow; newScheduleRow = dataSet.Schedule.NewScheduleRow(); newScheduleRow.Date = copyToDate; newScheduleRow.UserId = scheduleRow.UserId; newScheduleRow.Type = scheduleRow.Type; newScheduleRow.IsActive = true; dataSet.Schedule.AddScheduleRow(newScheduleRow); scheduleAdapter.Update(dataSet); foreach (ADAScheduleDataSet.ActivityRow activityRow in scheduleRow.GetActivityRowsByFK_Activity_Schedule()) { ADAScheduleDataSet.ActivityRow newActivityRow; newActivityRow = dataSet.Activity.NewActivityRow(); newActivityRow.ScheduleId = newScheduleRow.ScheduleId; if (!activityRow.IsStartTimeNull()) { TimeSpan timeSpan = copyToDate.Subtract(activityRow.StartTime.Date); newActivityRow.StartTime = activityRow.StartTime.AddDays(timeSpan.Days); } if (!activityRow.IsEndTimeNull()) { TimeSpan timeSpan = copyToDate.Subtract(activityRow.EndTime.Date); newActivityRow.EndTime = activityRow.EndTime.AddDays(timeSpan.Days); } if (!activityRow.IsSymbolIdNull()) { newActivityRow.SymbolId = activityRow.SymbolId; } if (!activityRow.IsNameNull()) { newActivityRow.Name = activityRow.Name; } if (!activityRow.IsSequenceNull()) { newActivityRow.Sequence = activityRow.Sequence; } dataSet.Activity.AddActivityRow(newActivityRow); activityAdapter.Update(dataSet); } } } catch (Exception ex) { ReportError(ex); } } Cursor.Current = Cursors.Default; monthCalendar1.SetDate(selectDateForm.SelectionRange.Start); LoadDataSet(); } }