private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_EDUCATION_HISTORY("UPDATE_GUARD_EDUCATION_HISTORY", txt_guard_number.Text, txt_school_1_name.Text, txt_school_1_year.Text != String.Empty? Convert.ToInt32(txt_school_1_year.Text):-1, cbo_school_1_leve.Text, txt_school_1_qualification.Text != String.Empty?txt_school_1_qualification.Text:String.Empty,
txt_school_2_name.Text != String.Empty?txt_school_2_name.Text:String.Empty, txt_school_2_year.Text != String.Empty?Convert.ToInt32(txt_school_2_year.Text):-1, cbo_school_2_leve.Text, txt_school_2_qualification.Text != String.Empty?txt_school_2_qualification.Text:String.Empty,
txt_school_3_name.Text != String.Empty? txt_school_3_name.Text:String.Empty, txt_school_3_year.Text != String.Empty?Convert.ToInt32(txt_school_3_year.Text):-1, cbo_school_3_leve.Text, txt_school_3_qualification.Text != String.Empty?txt_school_3_qualification.Text:String.Empty,
txt_school_4_name.Text != String.Empty?txt_school_4_name.Text:String.Empty, txt_school_4_year.Text != String.Empty? Convert.ToInt32(txt_school_4_year.Text):-1, cbo_school_4_leve.Text != String.Empty?cbo_school_4_leve.Text:"", txt_school_4_qualification.Text != String.Empty?txt_school_4_qualification.Text:String.Empty);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_OR_INSERT_GUARD_EMP_RECORD_HEADER("UPDATE_OR_INSERT_GUARD_EMP_RECORD_HEADER", txt_guard_number.Text, cbo_nationality.Text, cbo_tribe.Text,
txt_phone_primary.Text, txt_phone_secondary.Text, txt_national_id_number.Text, txt_partner_birth_place.Text, txt_partner_parents_names.Text,
txt_partners_residential_adres.Text, txt_partner_phone.Text);
MessageBox.Show("Guard profile has been updated");
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_PREVIOUS_EMPLOYER_DETAILS("UPDATE_GUARD_PREVIOUS_EMPLOYER_DETAILS", txt_guard_number.Text, txt_employer_name.Text, txt_employer_adress.Text, //function updates father details...although arguments remain unchanged
cbo_departure_reason.Text);
RETURN_GUARD_DETAILS(txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_REFFERENCES("UPDATE_GUARD_REFFERENCES", txt_guard_number.Text, txt_ref_1.Text, txt_ref_2.Text, //function updates father details...although arguments remain unchanged
txt_ref_3.Text);
RETURN_GUARD_DETAILS(txt_guard_number.Text);
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
txt_guard_number.Text = dtRow["guard_number"] != DBNull.Value ? (String)dtRow["guard_number"] : String.Empty;
txt_name.Text = dtRow["full_name"] != DBNull.Value ? (String)dtRow["full_name"] : String.Empty;
cbo_religion.Text = dtRow["religion"] != DBNull.Value ? (String)dtRow["religion"] : String.Empty;
cbo_gender.Text = dtRow["gender"] != DBNull.Value ? (String)dtRow["gender"] : String.Empty;
dt_birthdate.Value = dtRow["dob"] != DBNull.Value? Convert.ToDateTime(dtRow["dob"]):DateTime.Today;
txt_birth_place.Text = dtRow["birth_place"] != DBNull.Value ? (String)dtRow["birth_place"] : String.Empty;
cbo_nationality.Text = dtRow["nationality"] != DBNull.Value ? (String)dtRow["nationality"] : String.Empty;
cbo_tribe.Text = dtRow["tribe"] != DBNull.Value ? (String)dtRow["tribe"] : String.Empty;
txt_phone_primary.Text = dtRow["phone_primary"] != DBNull.Value ? (String)dtRow["phone_primary"] : String.Empty;
txt_phone_secondary.Text = dtRow["phone_secondary"] != DBNull.Value ? (String)dtRow["phone_secondary"] : String.Empty;
txt_national_id_number.Text = dtRow["national_id"] != DBNull.Value ? (String)dtRow["national_id"] : String.Empty;
txt_partner_birth_place.Text = dtRow["partner_birth_place"] != DBNull.Value ? (String)dtRow["partner_birth_place"] : String.Empty;
txt_partner_parents_names.Text = dtRow["partner_parents_names"] != DBNull.Value ? (String)dtRow["partner_parents_names"] : String.Empty;
txt_partners_residential_adres.Text = dtRow["partner_parents_resident_adress"] != DBNull.Value ? (String)dtRow["partner_parents_resident_adress"] : String.Empty;
txt_partner_phone.Text = dtRow["partner_contact"] != DBNull.Value ? (String)dtRow["partner_contact"] : String.Empty;
txt_record_guid.Text = dtRow["record_guid"] != DBNull.Value ? (String)dtRow["record_guid"] : String.Empty;
cbo_marital_status.Text = dtRow["marital_status"] != DBNull.Value ? (String)dtRow["marital_status"] : String.Empty;
txt_partner_name.Text = dtRow["partners_name"] != DBNull.Value ? (String)dtRow["partners_name"] : String.Empty;
panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
chk_illness.Checked = dtRow["serious_illness_or_accident"] != DBNull.Value? (Boolean)dtRow["serious_illness_or_accident"] : false;
txt_illness_name.Text = dtRow["nature_of_illness"] != DBNull.Value ? (String)dtRow["nature_of_illness"] : String.Empty;
dt_illness_date.Value = dtRow["illness_or_accident_date"] != DBNull.Value ? Convert.ToDateTime(dtRow["illness_or_accident_date"]) : DateTime.Today;
chk_premonia.Checked = dtRow["premonia_or_athma_incident"] != DBNull.Value? (Boolean)dtRow["premonia_or_athma_incident"] : false;
chk_epilipsy.Checked = dtRow["epilipsy_incident"] != DBNull.Value? (Boolean)dtRow["epilipsy_incident"]:false;
chk_TB.Checked = dtRow["tb_incident"] != DBNull.Value? (Boolean)dtRow["tb_incident"]:false;
dt_employment_date.Value = dtRow["date_employed"] != DBNull.Value ?Convert.ToDateTime(dtRow["date_employed"]) : DateTime.Today;
txt_recruitment_officer.Text = dtRow["recruiting_officer_name"] != DBNull.Value ? (String)dtRow["recruiting_officer_name"] : String.Empty;
txt_salary.Text = dtRow["commence_salary"] != DBNull.Value ? (String)dtRow["commence_salary"] : String.Empty;
txt_nssf_no.Text = dtRow["nssf_number"] != DBNull.Value ? (String)dtRow["nssf_number"] : String.Empty;
cbo_bank_name.Text = dtRow["bank_name"] != DBNull.Value ? (String)dtRow["bank_name"] : String.Empty;
txt_acc_no.Text = dtRow["account_number"] != DBNull.Value ? (String)dtRow["account_number"] : String.Empty;
cbo_position.Text = dtRow["position_held_at_discharge"] != DBNull.Value ? (String)dtRow["position_held_at_discharge"] : String.Empty;
txt_general_conduct.Text = dtRow["general_conduct"] != DBNull.Value ? (String)dtRow["general_conduct"] : String.Empty;
panel_details.Enabled = false;
}
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_HOME_ADRESS_OF_ORIGIN("UPDATE_GUARD_HOME_ADRESS_OF_ORIGIN", txt_guard_number.Text, txt_guard_adress.Text, cbo_district.Text,
txt_county.Text, txt_sub_county.Text, txt_parish.Text, txt_village.Text, txt_zone.Text,
txt_lc1_chairperson_name.Text, txt_lc1_chairperson_phone.Text, txt_neighbor_name.Text, txt_neighbor_phone.Text);
RETURN_GUARD_DETAILS(txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_RELATIVE_DETAILS("UPDATE_GUARD_RELATIVE_DETAILS", txt_guard_number.Text, txt_relative_1_name.Text, txt_relative_1_phone.Text, //function updates father details...although arguments remain unchanged
txt_relative_1_occupation.Text, txt_relative_2_name.Text, txt_relative_2_phone.Text, txt_relative_2_occupation.Text, txt_next_kin_name.Text,
txt_next_kin_adress.Text, cbo_next_kin_relationship.Text, txt_next_kin_phone.Text, txt_next_kin_national_id.Text);
RETURN_GUARD_DETAILS(txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_FATHER_DETAILS("UPDATE_GUARD_FATHER_DETAILS", txt_guard_number.Text, txt_adress.Text, cbo_district.Text, //function updates father details...although arguments remain unchanged
txt_county.Text, txt_sub_county.Text, txt_parish.Text, txt_village.Text, txt_zone.Text,
txt_lc1_chairperson_name.Text, txt_lc1_chairperson_phone.Text, txt_neighbor_name.Text, txt_neighbor_phone.Text);
RETURN_GUARD_DETAILS(txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_CHILDREN_DETAILS("UPDATE_GUARD_CHILDREN_DETAILS", txt_guard_number.Text, txt_child_1_name.Text, txt_child_1_contact.Text, //function updates father details...although arguments remain unchanged
txt_child_2_name.Text, txt_child_2_contact.Text, txt_child_3_name.Text, txt_child_3_contact.Text, txt_child_4_name.Text,
txt_child_4_contact.Text);
RETURN_GUARD_DETAILS(txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_CURRENT_RESIDENTIAL_ADRESS_DETAILS("UPDATE_CURRENT_RESIDENTIAL_ADRESS_DETAILS", txt_guard_number.Text, txt_adress.Text, cbo_dstrict.Text,
txt_county.Text, txt_sub_county.Text, txt_parish.Text, txt_village.Text, txt_zone.Text,
txt_landlord_name.Text, txt_lc_1_chairperson_name.Text, txt_lc_1_chairperson_phone.Text);
RETURN_GUARD_DETAILS(txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_OTHER_GUARD_DETAILS_AND_OFFICIAL_DATA("UPDATE_OTHER_GUARD_DETAILS_AND_OFFICIAL_DATA", txt_guard_number.Text, chk_illness.Checked ? true : false, txt_illness_name.Text != String.Empty?txt_illness_name.Text:String.Empty, dt,
chk_premonia.Checked ? true : false, chk_epilipsy.Checked ? true : false, chk_TB.Checked ? true : false, dt_employment_date.Value.Date, txt_recruitment_officer.Text != String.Empty?txt_recruitment_officer.Text:String.Empty, txt_salary.Text != String.Empty?txt_salary.Text:String.Empty,
txt_nssf_no.Text, cbo_bank_name.Text, txt_acc_no.Text, cbo_position.Text, txt_general_conduct.Text);
panel_details.Enabled = false;
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
this.txt_employer_name.Text = (dtRow["previous_employer_name"] != DBNull.Value ? (string)dtRow["previous_employer_name"] : string.Empty);
this.txt_employer_adress.Text = (dtRow["previous_employer_postal_adress"] != DBNull.Value ? (string)dtRow["previous_employer_postal_adress"] : string.Empty);
this.cbo_departure_reason.Text = (dtRow["cause_of_departure"] != DBNull.Value ? (string)dtRow["cause_of_departure"] : string.Empty);
this.panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
this.txt_ref_1.Text = (dtRow["reference1_name"] != DBNull.Value ? (string)dtRow["reference1_name"] : string.Empty);
this.txt_ref_2.Text = (dtRow["reference2_name"] != DBNull.Value ? (string)dtRow["reference2_name"] : string.Empty);
this.txt_ref_3.Text = (dtRow["reference3_name"] != DBNull.Value ? (string)dtRow["reference3_name"] : string.Empty);
this.panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
this.txt_child_1_name.Text = (dtRow["child_one_name"] != DBNull.Value ? (string)dtRow["child_one_name"] : string.Empty);
this.txt_child_1_contact.Text = (dtRow["child_one_contact"] != DBNull.Value ? (string)dtRow["child_one_contact"] : string.Empty);
this.txt_child_2_name.Text = (dtRow["child_two_name"] != DBNull.Value ? (string)dtRow["child_two_name"] : string.Empty);
this.txt_child_2_contact.Text = (dtRow["child_two_contact"] != DBNull.Value ? (string)dtRow["child_two_contact"] : string.Empty);
this.txt_child_3_name.Text = (dtRow["child_three_name"] != DBNull.Value ? (string)dtRow["child_three_name"] : string.Empty);
this.txt_child_3_contact.Text = (dtRow["child_three_contact"] != DBNull.Value ? (string)dtRow["child_three_contact"] : string.Empty);
this.txt_child_4_name.Text = (dtRow["child_four_name"] != DBNull.Value ? (string)dtRow["child_four_name"] : string.Empty);
this.txt_child_4_contact.Text = (dtRow["child_four_contact"] != DBNull.Value ? (string)dtRow["child_four_contact"] : string.Empty);
this.panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
this.txt_adress.Text = (dtRow["current_adress"] != DBNull.Value ? (string)dtRow["current_adress"] : string.Empty);
this.cbo_dstrict.Text = (dtRow["current_district"] != DBNull.Value ? (string)dtRow["current_district"] : string.Empty);
this.txt_county.Text = (dtRow["current_county"] != DBNull.Value ? (string)dtRow["current_county"] : string.Empty);
this.txt_sub_county.Text = (dtRow["current_sub_county"] != DBNull.Value ? (string)dtRow["current_sub_county"] : string.Empty);
this.txt_parish.Text = (dtRow["current_parish"] != DBNull.Value ? (string)dtRow["current_parish"] : string.Empty);
this.txt_village.Text = (dtRow["current_village"] != DBNull.Value ? (string)dtRow["current_village"] : string.Empty);
this.txt_zone.Text = (dtRow["current_zone"] != DBNull.Value ? (string)dtRow["current_zone"] : string.Empty);
this.txt_landlord_name.Text = (dtRow["landlord_name"] != DBNull.Value ? (string)dtRow["landlord_name"] : string.Empty);
this.txt_lc_1_chairperson_name.Text = (dtRow["lc1_chairperson_name"] != DBNull.Value ? (string)dtRow["lc1_chairperson_name"] : string.Empty);
this.txt_lc_1_chairperson_phone.Text = (dtRow["lc1_chairperson_phone"] != DBNull.Value ? (string)dtRow["lc1_chairperson_phone"] : string.Empty);
this.panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
this.txt_relative_1_name.Text = (dtRow["relative_one_name"] != DBNull.Value ? (string)dtRow["relative_one_name"] : string.Empty);
this.txt_relative_1_phone.Text = (dtRow["relative_one_phone"] != DBNull.Value ? (string)dtRow["relative_one_phone"] : string.Empty);
this.txt_relative_1_occupation.Text = (dtRow["relative_one_occupation"] != DBNull.Value ? (string)dtRow["relative_one_occupation"] : string.Empty);
this.txt_relative_2_name.Text = (dtRow["relative_two_name"] != DBNull.Value ? (string)dtRow["relative_two_name"] : string.Empty);
this.txt_relative_2_phone.Text = (dtRow["relative_two_phone"] != DBNull.Value ? (string)dtRow["relative_two_phone"] : string.Empty);
this.txt_relative_2_occupation.Text = (dtRow["relative_two_occupation"] != DBNull.Value ? (string)dtRow["relative_two_occupation"] : string.Empty);
this.txt_next_kin_name.Text = (dtRow["next_of_kin_name"] != DBNull.Value ? (string)dtRow["next_of_kin_name"] : string.Empty);
this.txt_next_kin_adress.Text = (dtRow["next_of_kin_adress"] != DBNull.Value ? (string)dtRow["next_of_kin_adress"] : string.Empty);
this.cbo_next_kin_relationship.Text = (dtRow["next_of_kin_relationship"] != DBNull.Value ? (string)dtRow["next_of_kin_relationship"] : string.Empty);
this.txt_next_kin_phone.Text = (dtRow["next_of_kin_phone"] != DBNull.Value ? (string)dtRow["next_of_kin_phone"] : string.Empty);
this.txt_next_kin_national_id.Text = (dtRow["next_of_kin_national_id_number"] != DBNull.Value ? (string)dtRow["next_of_kin_national_id_number"] : string.Empty);
this.panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
txt_adress.Text = dtRow["father_name_and_adress"] != DBNull.Value ? (String)dtRow["father_name_and_adress"] : String.Empty;
cbo_district.Text = dtRow["father_district"] != DBNull.Value ? (String)dtRow["father_district"] : String.Empty;
txt_county.Text = dtRow["father_county"] != DBNull.Value ? (String)dtRow["father_county"] : String.Empty;
txt_sub_county.Text = dtRow["father_sub_county"] != DBNull.Value ? (String)dtRow["father_sub_county"] : String.Empty;
txt_parish.Text = dtRow["father_parish"] != DBNull.Value ? (String)dtRow["father_parish"] : String.Empty;
txt_village.Text = dtRow["father_village"] != DBNull.Value ? (String)dtRow["father_village"] : String.Empty;
txt_zone.Text = dtRow["father_zone"] != DBNull.Value ? (String)dtRow["father_zone"] : String.Empty;
txt_lc1_chairperson_name.Text = dtRow["father_lc1_chairperson"] != DBNull.Value ? (String)dtRow["father_lc1_chairperson"] : String.Empty;
txt_lc1_chairperson_phone.Text = dtRow["father_lc1_chairperson_phone"] != DBNull.Value ? (String)dtRow["father_lc1_chairperson_phone"] : String.Empty;
txt_neighbor_name.Text = dtRow["father_village_neighbor_name"] != DBNull.Value ? (String)dtRow["father_village_neighbor_name"] : String.Empty;
txt_neighbor_phone.Text = dtRow["father_village_neighbor_phone"] != DBNull.Value ? (String)dtRow["father_village_neighbor_phone"] : String.Empty;
panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
int dummy_year = -1;
txt_school_1_name.Text = dtRow["school_1_name"] != DBNull.Value ? (String)dtRow["school_1_name"] : String.Empty;
txt_school_1_year.Text = dtRow["school_1_year"] != DBNull.Value ?Convert.ToInt32(dtRow["school_1_year"]) != dummy_year?Convert.ToInt32(dtRow["school_1_year"]).ToString(): String.Empty : String.Empty;
cbo_school_1_leve.Text = dtRow["school_1_level"] != DBNull.Value ? (String)dtRow["school_1_level"] : String.Empty;
txt_school_1_qualification.Text = dtRow["school_1_qualification"] != DBNull.Value ? (String)dtRow["school_1_qualification"] : String.Empty;
txt_school_2_name.Text = dtRow["school_2_name"] != DBNull.Value ? (String)dtRow["school_2_name"] : String.Empty;
txt_school_2_year.Text = dtRow["school_2_year"] != DBNull.Value ? Convert.ToInt32(dtRow["school_2_year"]) != dummy_year?Convert.ToInt32(dtRow["school_2_year"]).ToString():String.Empty : String.Empty;
cbo_school_2_leve.Text = dtRow["school_2_level"] != DBNull.Value ? (String)dtRow["school_2_level"] : String.Empty;
txt_school_2_qualification.Text = dtRow["school_2_qualification"] != DBNull.Value ? (String)dtRow["school_2_qualification"] : String.Empty;
txt_school_3_name.Text = dtRow["school_3_name"] != DBNull.Value ? (String)dtRow["school_3_name"] : String.Empty;
txt_school_3_year.Text = dtRow["school_3_year"] != DBNull.Value? Convert.ToInt32(dtRow["school_3_year"]) != dummy_year?Convert.ToInt32(dtRow["school_3_year"]).ToString() : String.Empty : String.Empty;
cbo_school_3_leve.Text = dtRow["school_3_level"] != DBNull.Value ? (String)dtRow["school_3_level"] : String.Empty;
txt_school_3_qualification.Text = dtRow["school_3_qualification"] != DBNull.Value ? (String)dtRow["school_3_qualification"] : String.Empty;
txt_school_4_name.Text = dtRow["school_4_name"] != DBNull.Value ? (String)dtRow["school_4_name"] : String.Empty;
txt_school_4_year.Text = dtRow["school_4_year"] != DBNull.Value ? Convert.ToInt32(dtRow["school_4_year"]) != dummy_year?Convert.ToInt32(dtRow["school_4_year"]).ToString():String.Empty : String.Empty;
cbo_school_4_leve.Text = dtRow["school_4_level"] != DBNull.Value ? (String)dtRow["school_4_level"] : String.Empty;
txt_school_4_qualification.Text = dtRow["school_4_qualification"] != DBNull.Value ? (String)dtRow["school_4_qualification"] : String.Empty;
panel_details.Enabled = false;
}
}
protected void RETURN_GUARD_DETAILS(string guard_number)
{
string empty;
string str;
string empty1;
string str1;
DataTable dt = Guard_Employment_Records.SELECT_OFFICER_DETAILS("SELECT_OFFICER_DETAILS", guard_number);
if (dt.Rows.Count != 0)
{
DataRow dtRow = dt.Rows[0];
int dummy_year = -1;
this.txt_school_1_name.Text = (dtRow["school_1_name"] != DBNull.Value ? (string)dtRow["school_1_name"] : string.Empty);
TextBox txtSchool1Year = this.txt_school_1_year;
if (dtRow["school_1_year"] == DBNull.Value)
{
empty = string.Empty;
}
else if (Convert.ToInt32(dtRow["school_1_year"]) != dummy_year)
{
int num = Convert.ToInt32(dtRow["school_1_year"]);
empty = num.ToString();
}
else
{
empty = string.Empty;
}
txtSchool1Year.Text = empty;
this.cbo_school_1_leve.Text = (dtRow["school_1_level"] != DBNull.Value ? (string)dtRow["school_1_level"] : string.Empty);
this.txt_school_1_qualification.Text = (dtRow["school_1_qualification"] != DBNull.Value ? (string)dtRow["school_1_qualification"] : string.Empty);
this.txt_school_2_name.Text = (dtRow["school_2_name"] != DBNull.Value ? (string)dtRow["school_2_name"] : string.Empty);
TextBox txtSchool2Year = this.txt_school_2_year;
if (dtRow["school_2_year"] == DBNull.Value)
{
str = string.Empty;
}
else if (Convert.ToInt32(dtRow["school_2_year"]) != dummy_year)
{
int num1 = Convert.ToInt32(dtRow["school_2_year"]);
str = num1.ToString();
}
else
{
str = string.Empty;
}
txtSchool2Year.Text = str;
this.cbo_school_2_leve.Text = (dtRow["school_2_level"] != DBNull.Value ? (string)dtRow["school_2_level"] : string.Empty);
this.txt_school_2_qualification.Text = (dtRow["school_2_qualification"] != DBNull.Value ? (string)dtRow["school_2_qualification"] : string.Empty);
this.txt_school_3_name.Text = (dtRow["school_3_name"] != DBNull.Value ? (string)dtRow["school_3_name"] : string.Empty);
TextBox txtSchool3Year = this.txt_school_3_year;
if (dtRow["school_3_year"] == DBNull.Value)
{
empty1 = string.Empty;
}
else if (Convert.ToInt32(dtRow["school_3_year"]) != dummy_year)
{
int num2 = Convert.ToInt32(dtRow["school_3_year"]);
empty1 = num2.ToString();
}
else
{
empty1 = string.Empty;
}
txtSchool3Year.Text = empty1;
this.cbo_school_3_leve.Text = (dtRow["school_3_level"] != DBNull.Value ? (string)dtRow["school_3_level"] : string.Empty);
this.txt_school_3_qualification.Text = (dtRow["school_3_qualification"] != DBNull.Value ? (string)dtRow["school_3_qualification"] : string.Empty);
this.txt_school_4_name.Text = (dtRow["school_4_name"] != DBNull.Value ? (string)dtRow["school_4_name"] : string.Empty);
TextBox txtSchool4Year = this.txt_school_4_year;
if (dtRow["school_4_year"] == DBNull.Value)
{
str1 = string.Empty;
}
else if (Convert.ToInt32(dtRow["school_4_year"]) != dummy_year)
{
int num3 = Convert.ToInt32(dtRow["school_4_year"]);
str1 = num3.ToString();
}
else
{
str1 = string.Empty;
}
txtSchool4Year.Text = str1;
this.cbo_school_4_leve.Text = (dtRow["school_4_level"] != DBNull.Value ? (string)dtRow["school_4_level"] : string.Empty);
this.txt_school_4_qualification.Text = (dtRow["school_4_qualification"] != DBNull.Value ? (string)dtRow["school_4_qualification"] : string.Empty);
this.panel_details.Enabled = false;
}
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_PREVIOUS_EMPLOYER_DETAILS("UPDATE_GUARD_PREVIOUS_EMPLOYER_DETAILS", this.txt_guard_number.Text, this.txt_employer_name.Text, this.txt_employer_adress.Text, this.cbo_departure_reason.Text);
this.RETURN_GUARD_DETAILS(this.txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_CHILDREN_DETAILS("UPDATE_GUARD_CHILDREN_DETAILS", this.txt_guard_number.Text, this.txt_child_1_name.Text, this.txt_child_1_contact.Text, this.txt_child_2_name.Text, this.txt_child_2_contact.Text, this.txt_child_3_name.Text, this.txt_child_3_contact.Text, this.txt_child_4_name.Text, this.txt_child_4_contact.Text);
this.RETURN_GUARD_DETAILS(this.txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_FATHER_DETAILS("UPDATE_GUARD_FATHER_DETAILS", this.txt_guard_number.Text, this.txt_adress.Text, this.cbo_district.Text, this.txt_county.Text, this.txt_sub_county.Text, this.txt_parish.Text, this.txt_village.Text, this.txt_zone.Text, this.txt_lc1_chairperson_name.Text, this.txt_lc1_chairperson_phone.Text, this.txt_neighbor_name.Text, this.txt_neighbor_phone.Text);
this.RETURN_GUARD_DETAILS(this.txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_REFFERENCES("UPDATE_GUARD_REFFERENCES", this.txt_guard_number.Text, this.txt_ref_1.Text, this.txt_ref_2.Text, this.txt_ref_3.Text);
this.RETURN_GUARD_DETAILS(this.txt_guard_number.Text);
}
private void btnsave_Click(object sender, EventArgs e)
{
Guard_Employment_Records.UPDATE_GUARD_RELATIVE_DETAILS("UPDATE_GUARD_RELATIVE_DETAILS", this.txt_guard_number.Text, this.txt_relative_1_name.Text, this.txt_relative_1_phone.Text, this.txt_relative_1_occupation.Text, this.txt_relative_2_name.Text, this.txt_relative_2_phone.Text, this.txt_relative_2_occupation.Text, this.txt_next_kin_name.Text, this.txt_next_kin_adress.Text, this.cbo_next_kin_relationship.Text, this.txt_next_kin_phone.Text, this.txt_next_kin_national_id.Text);
this.RETURN_GUARD_DETAILS(this.txt_guard_number.Text);
}
