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(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);
}
}