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