public void RefreshData() { PeriodCMBX.Items.Clear(); if (!Name.Equals("Archived")) { var dt = Scheduling.GetAllAssignmentDetails(Aid); NameLBL.Text = dt.Rows[0][2].ToString().Split(',')[0] + ","; FirstNameLBL.Text = dt.Rows[0][2].ToString().Split(',')[1]; ClientLBL.Text = dt.Rows[0][3].ToString(); foreach (DataRow row in Attendance.GetPeriods(Gid).Rows) { PeriodCMBX.Items.Add(new ComboBoxDays(int.Parse(row["month"].ToString()), int.Parse(row["period"].ToString()), int.Parse(row["year"].ToString()))); } if (PeriodCMBX.Items.Count > 0) { PeriodCMBX.SelectedIndex = 0; } } else { var dt = Archiver.GetAllAssignmentDetails(Aid); NameLBL.Text = dt.Rows[0][2].ToString().Split(',')[0] + ","; FirstNameLBL.Text = dt.Rows[0][2].ToString().Split(',')[1]; ClientLBL.Text = dt.Rows[0][3].ToString(); foreach (DataRow row in Archiver.GetPeriods(Gid).Rows) { PeriodCMBX.Items.Add(new ComboBoxDays(int.Parse(row["month"].ToString()), int.Parse(row["period"].ToString()), int.Parse(row["year"].ToString()))); } if (PeriodCMBX.Items.Count > 0) { PeriodCMBX.SelectedIndex = 0; } } if (DutyDetailsGRD.Rows.Count == 0) { ErrorPNL.Visible = true; ErrorPNL.BringToFront(); } else { ErrorPNL.Visible = false; } }
private void RefreshData() { try { var dataTable = Archiver.GetGuardsBasicData(Gid); GIDLBL.Text = Gid.ToString(); LNLBL.Text = dataTable.Rows[0]["fn"] + " " + dataTable.Rows[0]["mn"]; LLBL.Text = dataTable.Rows[0]["ln"] + ", "; ContactNoLBL.Text = dataTable.Rows[0]["CellNo"].ToString(); TelNoLBL.Text = dataTable.Rows[0]["TelNo"].ToString(); ContactLBL.Text = dataTable.Rows[0]["EmergencyContact"].ToString(); EmergencyLBL.Text = dataTable.Rows[0]["EmergencyNo"].ToString(); } catch (Exception ex) { ShowErrorBox("Archive Guard - Loading", ex.Message); } }
public void RefreshCurrent() { if (!Name.Equals("Archived")) { var dt = Scheduling.GetAssignmentDetails(Aid); LocationLBL.Text = dt.Rows[0][0].ToString(); StartLBL.Text = dt.Rows[0][1].ToString().Split(' ')[0]; EndLBL.Text = dt.Rows[0][2].ToString().Split(' ')[0]; } else { var dt = Archiver.GetAssignmentDetails(Aid); LocationLBL.Text = dt.Rows[0][0].ToString(); StartLBL.Text = dt.Rows[0][1].ToString().Split(' ')[0]; EndLBL.Text = dt.Rows[0][2].ToString().Split(' ')[0]; } }
public void RefreshDutyDetails() { DutyDetailsGRD.DataSource = Name.Equals("Archived") ? Archiver.GetDutyDetailsSummary(Aid) : Name.Equals("History") ? Scheduling.GetDutyDetailsSummaryHistory(Aid): Scheduling.GetDutyDetailsSummary(Aid); DutyDetailsGRD.Columns[0].Visible = false; DutyDetailsGRD.Columns[1].HeaderText = "TIME-IN"; DutyDetailsGRD.Columns[2].HeaderText = "TIME-OUT"; DutyDetailsGRD.Columns[3].HeaderText = "DAYS"; DutyDetailsGRD.Columns[4].HeaderText = "EFFECTIVE"; DutyDetailsGRD.Columns[5].HeaderText = "DISMISSED"; DutyDetailsGRD.Columns[1].Width = 95; DutyDetailsGRD.Columns[2].Width = 95; DutyDetailsGRD.Columns[3].Width = 95; DutyDetailsGRD.Columns[4].Width = 100; DutyDetailsGRD.Columns[5].Width = 100; DutyDetailsGRD.Select(); }
private void LoadDetails() { try { PeriodCMBX.Items.Clear(); if (!Name.Equals("Archived")) { foreach (DataRow row in Attendance.GetPeriods(Gid).Rows) { PeriodCMBX.Items.Add(new ComboBoxDays(int.Parse(row["month"].ToString()), int.Parse(row["period"].ToString()), int.Parse(row["year"].ToString()))); } } else { foreach (DataRow row in Archiver.GetPeriods(Gid).Rows) { PeriodCMBX.Items.Add(new ComboBoxDays(int.Parse(row["month"].ToString()), int.Parse(row["period"].ToString()), int.Parse(row["year"].ToString()))); } } if (PeriodCMBX.Items.Count > 0) { PeriodCMBX.SelectedIndex = 0; NoPayrollPNL.Visible = false; } else { NoPayrollPNL.BringToFront(); NoPayrollPNL.Visible = true; } if (OverviewPNL.Visible == false) { ChangePanel(OverviewLBL, OverviewPNL); } } catch (Exception ex) { ShowErrorBox("Payroll Period Details", ex.Message); } }
public void LoadComputations() { try { if (PeriodCMBX.Items.Count > 0) { if (!Name.Equals("Archived")) { _pay = new Payroll(Gid, ((ComboBoxDays)PeriodCMBX.SelectedItem).Month, ((ComboBoxDays)PeriodCMBX.SelectedItem).Period, ((ComboBoxDays)PeriodCMBX.SelectedItem).Year); } else { _pay = Archiver.GetPayroll(Gid, ((ComboBoxDays)PeriodCMBX.SelectedItem).Month, ((ComboBoxDays)PeriodCMBX.SelectedItem).Period, ((ComboBoxDays)PeriodCMBX.SelectedItem).Year); } UpdatePopUp("nsu_proper_day_normal", "nsu_overtime_day_normal", "nsu_proper_night_normal", "nsu_overtime_night_normal", MondaySaturday); UpdatePopUp("sun_proper_day_normal", "sun_overtime_day_normal", "sun_proper_night_normal", "sun_overtime_night_normal", Sundays); UpdatePopUp("nsu_proper_day_special", "nsu_overtime_day_special", "nsu_proper_night_special", "nsu_overtime_night_special", SMond); UpdatePopUp("sun_proper_day_special", "sun_overtime_day_special", "sun_proper_night_special", "sun_overtime_night_special", SSunds); UpdatePopUp("nsu_proper_day_regular", "nsu_overtime_day_regular", "nsu_proper_night_regular", "nsu_overtime_night_regular", RMond); UpdatePopUp("sun_proper_day_regular", "sun_overtime_day_regular", "sun_proper_night_regular", "sun_overtime_night_regular", RSunds); UpdateLbl("normal_nsu", OMLBL); UpdateLbl("normal_sun", OSLBL); UpdateLbl("regular_nsu", RMLBL); UpdateLbl("regular_sun", RSLBL); UpdateLbl("special_nsu", SMLBL); UpdateLbl("special_sun", SSLBL); UpdateLbl("normal", OTLBL); UpdateLbl("regular", RTLBL); UpdateLbl("special", STLBL); UpdateLbl("total", WorkTotalLBL); B13LBL.Text = CurrencyFormat(_pay.ThirteenthMonthPay); BAllowanceLBL.Text = CurrencyFormat(_pay.EmergencyAllowance); BBondsLBL.Text = CurrencyFormat(_pay.CashBond); BColaLBL.Text = CurrencyFormat(_pay.Cola); BTotalLBL.Text = CurrencyFormat(_pay.Bonuses); DCashAdvanceLBL.Text = CurrencyFormatNegative(_pay.CashAdvance); DPagIbigLBL.Text = CurrencyFormatNegative(_pay.PagIbig); DPhilHealthLBL.Text = CurrencyFormatNegative(_pay.PhilHealth); DSSSLBL.Text = CurrencyFormatNegative(_pay.Sss); DTotalLBL.Text = CurrencyFormatNegative(_pay.Deductions); NetPayLBL.Text = CurrencyFormat(_pay.NetPay); var wt = _pay.GetWithholdingTax(); TaxPop.Items[1].Text = CurrencyFormat(wt.TaxbaseD); TaxPop.Items[3].Text = CurrencyFormat(wt.ExcessTax); TaxPop.Items[5].Text = CurrencyFormat(wt.total); string[] sssdetails = _pay.GetSSSDetails(); SSSPop.Items[1].Text = sssdetails[0]; SSSPop.Items[3].Text = sssdetails[1]; SSSPop.Items[5].Text = sssdetails[2]; DWithLBL.Text = CurrencyFormatNegative(wt.total); } } catch (Exception ex) { rylui.RylMessageBox.ShowDialog("This guard has no Approved payrolls archived.", "Payroll Calculations", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
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); } }
public void RefreshData() { try { if (!Name.Equals("Archived")) { try { _dataTable = Guard.GetGuardsBasicData(Gid); GIDLBL.Text = _dataTable.Rows[0]["gtype"].ToString().Equals("0") ? "Regular" : "Officer"; LNLBL.Text = _dataTable.Rows[0]["fn"] + " " + _dataTable.Rows[0]["mn"]; LLBL.Text = _dataTable.Rows[0]["ln"] + ", "; StatusLBL.Text = GetStatus(_dataTable); BdateLBL.Text = _dataTable.Rows[0]["Bdate"].ToString(); GenderLBL.Text = GetGender(_dataTable); HeightLBL.Text = _dataTable.Rows[0]["Height"].ToString(); WeightLBL.Text = _dataTable.Rows[0]["Weight"].ToString(); ReligionLBL.Text = _dataTable.Rows[0]["Religion"].ToString(); CivilStatusLBL.Text = GetCivilStatus(_dataTable); ContactNoLBL.Text = _dataTable.Rows[0]["CellNo"].ToString(); TelNoLBL.Text = _dataTable.Rows[0]["TelNo"].ToString(); LicenseNoLBL.Text = _dataTable.Rows[0]["LicenseNo"].ToString(); SSSLBL.Text = _dataTable.Rows[0]["SSS"].ToString(); TINLBL.Text = _dataTable.Rows[0]["TIN"].ToString(); PhilHealthLBL.Text = _dataTable.Rows[0]["PhilHealth"].ToString(); PrevAgencyLBL.Text = _dataTable.Rows[0]["PrevAgency"].ToString(); PrevAssLVL.Text = _dataTable.Rows[0]["PrevAss"].ToString(); EdAtLBL.Text = GetEducationalAttainment(_dataTable); CourseLBL.Text = _dataTable.Rows[0]["Course"].ToString(); TrainLBL.Text = _dataTable.Rows[0]["MilitaryTrainings"].ToString(); ContactLBL.Text = _dataTable.Rows[0]["EmergencyContact"].ToString(); EmergencyLBL.Text = _dataTable.Rows[0]["EmergencyNo"].ToString(); } catch (Exception ex) { Console.WriteLine(ex); } try { _dataTable = Guard.GetGuardsAddresses(Gid); BirthplaceLBL.Text = BuildStreet(_dataTable, 0); PermAddLBL.Text = BuildStreet(_dataTable, 1); TempAddLBL.Text = BuildStreet(_dataTable, 2); } catch (Exception ex) { Console.WriteLine(ex); } try { _dataTable = Guard.GetGuardsParents(Gid); MotherLBL.Text = BuildName(_dataTable, 1); FatherLBL.Text = BuildName(_dataTable, 0); try { SpouseLBL.Text = BuildName(_dataTable, 2); } catch (Exception ex) { Console.WriteLine(ex); } } catch (Exception ex) { Console.WriteLine(ex); } try { DependentsGRD.DataSource = Guard.GetGuardsDependentsView(Gid); DependentsGRD.Columns[0].Visible = false; DependentsGRD.Columns[1].Width = 250; DependentsGRD.Columns[2].Width = 150; if (DependentsGRD.Rows.Count == 0) { ErrorPNL.BringToFront(); ErrorPNL.Visible = true; } else { ErrorPNL.Visible = false; } } catch (Exception ex) { Console.WriteLine(ex); } } else { try { _dataTable = Archiver.GetGuardsBasicData(Gid); GIDLBL.Text = _dataTable.Rows[0]["gtype"].Equals("0") ? "Regular" : "Officer"; LNLBL.Text = _dataTable.Rows[0]["fn"] + " " + _dataTable.Rows[0]["mn"]; LLBL.Text = _dataTable.Rows[0]["ln"] + ", "; StatusLBL.Text = "Archived"; BdateLBL.Text = _dataTable.Rows[0]["Bdate"].ToString(); GenderLBL.Text = GetGender(_dataTable); HeightLBL.Text = _dataTable.Rows[0]["Height"].ToString(); WeightLBL.Text = _dataTable.Rows[0]["Weight"].ToString(); ReligionLBL.Text = _dataTable.Rows[0]["Religion"].ToString(); CivilStatusLBL.Text = GetCivilStatus(_dataTable); ContactNoLBL.Text = _dataTable.Rows[0]["CellNo"].ToString(); TelNoLBL.Text = _dataTable.Rows[0]["TelNo"].ToString(); LicenseNoLBL.Text = _dataTable.Rows[0]["LicenseNo"].ToString(); SSSLBL.Text = _dataTable.Rows[0]["SSS"].ToString(); TINLBL.Text = _dataTable.Rows[0]["TIN"].ToString(); PhilHealthLBL.Text = _dataTable.Rows[0]["PhilHealth"].ToString(); PrevAgencyLBL.Text = _dataTable.Rows[0]["PrevAgency"].ToString(); PrevAssLVL.Text = _dataTable.Rows[0]["PrevAss"].ToString(); EdAtLBL.Text = GetEducationalAttainment(_dataTable); CourseLBL.Text = _dataTable.Rows[0]["Course"].ToString(); TrainLBL.Text = _dataTable.Rows[0]["MilitaryTrainings"].ToString(); ContactLBL.Text = _dataTable.Rows[0]["EmergencyContact"].ToString(); EmergencyLBL.Text = _dataTable.Rows[0]["EmergencyNo"].ToString(); } catch (Exception ex) { Console.WriteLine(ex); } try { _dataTable = Archiver.GetGuardsAddresses(Gid); BirthplaceLBL.Text = BuildStreet(_dataTable, 0); PermAddLBL.Text = BuildStreet(_dataTable, 1); TempAddLBL.Text = BuildStreet(_dataTable, 2); } catch (Exception ex) { Console.WriteLine(ex); } try { _dataTable = Archiver.GetGuardsParents(Gid); MotherLBL.Text = BuildName(_dataTable, 1); FatherLBL.Text = BuildName(_dataTable, 0); try { SpouseLBL.Text = BuildName(_dataTable, 2); } catch (Exception ex) { Console.WriteLine(ex); } } catch (Exception ex) { Console.WriteLine(ex); } try { DependentsGRD.DataSource = Archiver.GetGuardsDependentsView(Gid); DependentsGRD.Columns[0].Visible = false; DependentsGRD.Columns[1].Width = 250; DependentsGRD.Columns[2].Width = 150; if (DependentsGRD.Rows.Count == 0) { ErrorPNL.BringToFront(); ErrorPNL.Visible = true; } else { ErrorPNL.Visible = false; } } catch (Exception ex) { Console.WriteLine(ex); } } } catch (Exception ex) { ShowErrorBox("Laoding Guards", ex.Message); } }