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