private void RefreshData()
{
if (_attendance.GetAttendance_View().Rows.Count > 0)
{
foreach (DataRow row in _attendance.GetAttendance().Rows)
{
DaysGRD.Rows.Add(row[0], row[2], row[5].ToString().Split(':')[0], ":",
row[5].ToString().Split(':')[1].Split(' ')[0], row[5].ToString().Split(':')[1].Split(' ')[1],
row[6].ToString().Split(':')[0], ":", row[6].ToString().Split(':')[1].Split(' ')[0],
row[6].ToString().Split(':')[1].Split(' ')[1], "0");
}
DaysGRD.CurrentCell = DaysGRD.Rows[0].Cells[1];
}
try {
CertifiedByCMBX.Items.Clear();
var dv = Client.GetCertifiers(_attendance.CID);
for (var i = 0; i < dv.Rows.Count; i++)
{
CertifiedByCMBX.Items.Add(
new ComboBoxItem(dv.Rows[i][4] + ", " + dv.Rows[i][2] + " " + dv.Rows[i][3], dv.Rows[i][0].ToString()));
}
if (CertifiedByCMBX.Items.Count == 0)
{
RylMessageBox.ShowDialog(
"There are no certifiers added for this client. Please add a certifier before adding an attendance.",
"No Certifiers Found", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Close();
}
}
catch (Exception ex) {
Console.Write(ex.Message);
}
CertifiedByCMBX.Text = _attendance.GetCertifiedBy();
}
public void RefreshAttendance()
{
try {
if (!Name.Equals("Archived"))
{
AttendanceGRD.DataSource = _attendance.GetAttendance_View(
((ComboBoxDays)PeriodCMBX.SelectedItem).Month,
((ComboBoxDays)PeriodCMBX.SelectedItem).Period, ((ComboBoxDays)PeriodCMBX.SelectedItem).Year);
AttendanceGRD.Columns[8].Visible = false;
AttendanceGRD.Columns[9].Visible = false;
AttendanceGRD.Columns[10].Visible = false;
AttendanceGRD.Columns[11].Visible = false;
}
else
{
AttendanceGRD.DataSource = Archiver.GetAttendance(Gid,
((ComboBoxDays)PeriodCMBX.SelectedItem).Month,
((ComboBoxDays)PeriodCMBX.SelectedItem).Period, ((ComboBoxDays)PeriodCMBX.SelectedItem).Year);
}
AttendanceGRD.Columns[0].Visible = false;
AttendanceGRD.Columns[1].Visible = false;
AttendanceGRD.Columns[2].Width = 140;
AttendanceGRD.Sort(AttendanceGRD.Columns[2], ListSortDirection.Ascending);
AttendanceGRD.Columns[2].HeaderText = "DAY / SCHEDULE";
AttendanceGRD.Columns[3].Width = 120;
AttendanceGRD.Columns[3].HeaderText = "IN-OUT";
AttendanceGRD.Columns[3].SortMode = DataGridViewColumnSortMode.NotSortable;
AttendanceGRD.Columns[4].Width = 50;
AttendanceGRD.Columns[4].HeaderText = "RD";
AttendanceGRD.Columns[4].SortMode = DataGridViewColumnSortMode.NotSortable;
AttendanceGRD.Columns[5].Width = 50;
AttendanceGRD.Columns[5].HeaderText = "RN";
AttendanceGRD.Columns[5].SortMode = DataGridViewColumnSortMode.NotSortable;
AttendanceGRD.Columns[6].Width = 50;
AttendanceGRD.Columns[6].HeaderText = "HD";
AttendanceGRD.Columns[6].SortMode = DataGridViewColumnSortMode.NotSortable;
AttendanceGRD.Columns[7].Width = 60;
AttendanceGRD.Columns[7].HeaderText = "HN";
AttendanceGRD.Columns[7].SortMode = DataGridViewColumnSortMode.NotSortable;
AttendanceGRD.Columns[7].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
if (!Name.Equals("Archived"))
{
var attendance = new Attendance(Aid, ((ComboBoxDays)PeriodCMBX.SelectedItem).Month,
((ComboBoxDays)PeriodCMBX.SelectedItem).Period, ((ComboBoxDays)PeriodCMBX.SelectedItem).Year);
var hrs = attendance.GetAttendanceSummary();
AShiftLBL.Text = hrs.GetNormalDay() + " hrs";
ANightLBL.Text = hrs.GetNormalNight() + " hrs";
AHShiftLBL.Text = hrs.GetHolidayDay() + " hrs";
AHNightLBL.Text = hrs.GetHolidayNight() + " hrs";
ACertifiedLBL.Text = attendance.GetCertifiedBy().Equals("")
? "Unedited Attendance"
: attendance.GetCertifiedBy();
try {
string[] tooltip = attendance.GetAttendanceTooltip();
OrdinaryDay.Items[3].Text = tooltip[0];
OrdinaryDay.Items[4].Text = tooltip[1];
OrdinaryDay.Items[6].Text = tooltip[2];
OrdinaryDay.Items[7].Text = tooltip[3];
OrdinaryNight.Items[3].Text = tooltip[4];
OrdinaryNight.Items[4].Text = tooltip[5];
OrdinaryNight.Items[6].Text = tooltip[6];
OrdinaryNight.Items[7].Text = tooltip[7];
HolidayDay.Items[3].Text = tooltip[8];
HolidayDay.Items[4].Text = tooltip[9];
HolidayDay.Items[6].Text = tooltip[10];
HolidayDay.Items[7].Text = tooltip[11];
HolidayDay.Items[11].Text = tooltip[12];
HolidayDay.Items[12].Text = tooltip[13];
HolidayDay.Items[14].Text = tooltip[14];
HolidayDay.Items[15].Text = tooltip[15];
HolidayNight.Items[3].Text = tooltip[16];
HolidayNight.Items[4].Text = tooltip[17];
HolidayNight.Items[6].Text = tooltip[18];
HolidayNight.Items[7].Text = tooltip[19];
HolidayNight.Items[11].Text = tooltip[20];
HolidayNight.Items[12].Text = tooltip[21];
HolidayNight.Items[14].Text = tooltip[22];
HolidayNight.Items[15].Text = tooltip[23];
}
catch (Exception exception) {
Console.WriteLine(exception);
}
}
else
{
var attendance = Archiver.GetAttendanceSummary(((ComboBoxDays)PeriodCMBX.SelectedItem).Year,
((ComboBoxDays)PeriodCMBX.SelectedItem).Month,
((ComboBoxDays)PeriodCMBX.SelectedItem).Period, Gid);
AShiftLBL.Text = attendance.Rows[0][4] + " hrs";
ANightLBL.Text = attendance.Rows[0][5] + " hrs";
AHShiftLBL.Text = attendance.Rows[0][2] + " hrs";
AHNightLBL.Text = attendance.Rows[0][3] + " hrs";
ACertifiedLBL.Text = attendance.Rows[0][1].ToString();
try {
string[] tooltip = Archiver.GetAttendanceTooltip(Gid, ((ComboBoxDays)PeriodCMBX.SelectedItem).Period, ((ComboBoxDays)PeriodCMBX.SelectedItem).Month, ((ComboBoxDays)PeriodCMBX.SelectedItem).Year);
OrdinaryDay.Items[3].Text = tooltip[0];
OrdinaryDay.Items[4].Text = tooltip[1];
OrdinaryDay.Items[6].Text = tooltip[2];
OrdinaryDay.Items[7].Text = tooltip[3];
OrdinaryNight.Items[3].Text = tooltip[4];
OrdinaryNight.Items[4].Text = tooltip[5];
OrdinaryNight.Items[6].Text = tooltip[6];
OrdinaryNight.Items[7].Text = tooltip[7];
HolidayDay.Items[3].Text = tooltip[8];
HolidayDay.Items[4].Text = tooltip[9];
HolidayDay.Items[6].Text = tooltip[10];
HolidayDay.Items[7].Text = tooltip[11];
HolidayDay.Items[11].Text = tooltip[12];
HolidayDay.Items[12].Text = tooltip[13];
HolidayDay.Items[14].Text = tooltip[14];
HolidayDay.Items[15].Text = tooltip[15];
HolidayNight.Items[3].Text = tooltip[16];
HolidayNight.Items[4].Text = tooltip[17];
HolidayNight.Items[6].Text = tooltip[18];
HolidayNight.Items[7].Text = tooltip[19];
HolidayNight.Items[11].Text = tooltip[20];
HolidayNight.Items[12].Text = tooltip[21];
HolidayNight.Items[14].Text = tooltip[22];
HolidayNight.Items[15].Text = tooltip[23];
}
catch (Exception exception) {
Console.WriteLine(exception);
}
}
} catch (Exception e) {
Console.WriteLine(e.Message);
}
}