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