/// <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;
}
}
protected void ddlCityPresent_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
PersonalDetailsJSBAL personalDetailsBAL = new PersonalDetailsJSBAL();
int cityId = Convert.ToInt32(ddlCityPresent.SelectedValue);
DataSet dsAreaPresent = new DataSet();
dsAreaPresent = personalDetailsBAL.GetArea(cityId);
// Check if dataset is not null
if (dsAreaPresent != null)
{
ddlAreaPresent.DataSource = dsAreaPresent;
ddlAreaPresent.DataTextField = "AreaName";
ddlAreaPresent.DataValueField = "AreaID";
ddlAreaPresent.DataBind();
ddlAreaPresent.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
catch (Exception)
{
// throw;
}
}
