/// <summary> /// Bind personal details for edit /// </summary> private void BindPersonalDetails() { try { string date, maritalStatus, format; int countryId, stateId, cityId, permCountryId, permStateId, permCityId, count = 0; DataSet dsPersonalDetails = new DataSet(); PersonalDetailsJSBAL personalDetailsJSBAL = new PersonalDetailsJSBAL(); dsPersonalDetails = personalDetailsJSBAL.ViewPersonalDetailsBAL(candidateId); // Check dataset is not null if (dsPersonalDetails != null) { // Check the count than zero if (dsPersonalDetails.Tables.Count > 0) { // Check rows greater than zero if (dsPersonalDetails.Tables[0].Rows.Count > 0) { FileUploadPhoto.Visible = false; imgPersonalPhoto.Visible = true; lnkbtnEdit.Visible = true; pnlPresentAdd.Visible = true; DataSet dsPersentState = new DataSet(); countryId = Convert.ToInt32(dsPersonalDetails.Tables[1].Rows[0]["CountryId"]); dsPersentState = personalDetailsJSBAL.GetState(countryId); // Check dsPresentState is not null if (dsPersentState != null) { ddlStatePresent.DataSource = dsPersentState; ddlStatePresent.DataTextField = "StateName"; ddlStatePresent.DataValueField = "StateId"; ddlStatePresent.DataBind(); } DataSet dsPersentCity = new DataSet(); stateId = Convert.ToInt32(dsPersonalDetails.Tables[1].Rows[0]["StateId"]); dsPersentCity = personalDetailsJSBAL.GetCity(stateId); // Check dsPresentCity is not null if (dsPersentCity != null) { ddlCityPresent.DataSource = dsPersentCity; ddlCityPresent.DataTextField = "CityName"; ddlCityPresent.DataValueField = "CityId"; ddlCityPresent.DataBind(); } DataSet dsPersentArea = new DataSet(); cityId = Convert.ToInt32(dsPersonalDetails.Tables[1].Rows[0]["CityId"]); dsPersentArea = personalDetailsJSBAL.GetArea(cityId); // Check dsPresentArea is not null if (dsPersentArea != null) { ddlAreaPresent.DataSource = dsPersentArea; ddlAreaPresent.DataTextField = "AreaName"; ddlAreaPresent.DataValueField = "AreaId"; ddlAreaPresent.DataBind(); } DataSet dsPermanentState = new DataSet(); permCountryId = Convert.ToInt32(dsPersonalDetails.Tables[0].Rows[0]["PermantCountryId"]); dsPermanentState = personalDetailsJSBAL.GetState(permCountryId); // Check dsPermanentState is not null if (dsPermanentState != null) { ddlStatePerm.DataSource = dsPermanentState; ddlStatePerm.DataTextField = "StateName"; ddlStatePerm.DataValueField = "StateId"; ddlStatePerm.DataBind(); } DataSet dsPermanentCity = new DataSet(); permStateId = Convert.ToInt32(dsPersonalDetails.Tables[0].Rows[0]["PermantStateId"]); dsPermanentCity = personalDetailsJSBAL.GetCity(permStateId); // Check dsPermanentCity is not null if (dsPermanentCity != null) { ddlCityPerm.DataSource = dsPermanentCity; ddlCityPerm.DataTextField = "CityName"; ddlCityPerm.DataValueField = "CityId"; ddlCityPerm.DataBind(); } DataSet dsPermanentArea = new DataSet(); permCityId = Convert.ToInt32(dsPersonalDetails.Tables[0].Rows[0]["PermantCityId"]); dsPermanentArea = personalDetailsJSBAL.GetArea(permCityId); // Check dsPermanentArea is not null if (dsPermanentArea != null) { ddlAreaPerm.DataSource = dsPermanentArea; ddlAreaPerm.DataTextField = "AreaName"; ddlAreaPerm.DataValueField = "AreaId"; ddlAreaPerm.DataBind(); } imgPersonalPhoto.ImageUrl = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["photo"]); txtPresentAddress.Text = Convert.ToString(dsPersonalDetails.Tables[1].Rows[0]["CurrentAddress"]); ddlCountryPresent.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[1].Rows[0]["CountryId"]); ddlStatePresent.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[1].Rows[0]["StateId"]); ddlCityPresent.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[1].Rows[0]["CityId"]); ddlAreaPresent.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[1].Rows[0]["CityAreaId"]); txtPincodePresent.Text = Convert.ToString(dsPersonalDetails.Tables[1].Rows[0]["PinCode"]); txtAddressPerm.Text = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PermantAddress"]); ddlCountryPerm.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PermantCountryId"]); ddlStatePerm.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PermantStateId"]); ddlCityPerm.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PermantCityId"]); ddlAreaPerm.SelectedValue = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PermantArea"]); txtPincodePerm.Text = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PermantPincode"]); date = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["DateOfBirth"]); txtDOB.Text = DateTime.Parse(date).ToShortDateString(); maritalStatus = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["MaritalStatus"]); ddlMaritalStatus.Items.FindByValue(maritalStatus).Selected = true; txtPassportNo.Text = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PassportNumber"]); format = Convert.ToString(dsPersonalDetails.Tables[0].Rows[0]["PassportValidity"]); ; string[] Words = format.Split(new char[] { '/' }); foreach (string Word in Words) { count += 1; if (count == 1) { ddlMonth.SelectedValue = Word; } if (count == 2) { ddlYear.SelectedValue = Word; } } } } } } catch (Exception) { // throw; } }
/// <summary> /// Handles the SelectedIndexChanged event of the ddlCountryPresent control. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ddlCountryPresent_SelectedIndexChanged(object sender, EventArgs e) { try { PersonalDetailsJSBAL personalDetailsBAL = new PersonalDetailsJSBAL(); int CountryId = Convert.ToInt32(ddlCountryPresent.SelectedValue); DataSet dsStatePresent = new DataSet(); dsStatePresent = personalDetailsBAL.GetState(CountryId); // Check if dataset is not null if (dsStatePresent != null) { ddlStatePresent.DataSource = dsStatePresent; ddlStatePresent.DataTextField = "StateName"; ddlStatePresent.DataValueField = "StateId"; ddlStatePresent.DataBind(); ddlStatePresent.Items.Insert(0, new ListItem("--Select--", "0")); } } catch (Exception) { // throw; } }