/// <summary>
/// Bind Country to ddlCountryPresent list
/// </summary>
private void GetCountryPresent()
{
try
{
PersonalDetailsJSBAL personalDetailsBAL = new PersonalDetailsJSBAL();
dsCountry = personalDetailsBAL.GetCountry();
// Check dataset is not null
if (dsCountry != null)
{
ddlCountryPresent.DataSource = dsCountry;
ddlCountryPresent.DataTextField = "CountryName";
ddlCountryPresent.DataValueField = "CountryId";
ddlCountryPresent.DataBind();
ddlCountryPresent.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
catch (Exception)
{
// throw;
}
}
/// <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 ddlStatePresent control.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddlStatePresent_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
PersonalDetailsJSBAL personalDetailsBAL = new PersonalDetailsJSBAL();
int StateId = Convert.ToInt32(ddlStatePresent.SelectedValue);
DataSet dsCityPresent = new DataSet();
dsCityPresent = personalDetailsBAL.GetCity(StateId);
// Check if dataset is not null
if (dsCityPresent != null)
{
ddlCityPresent.DataSource = dsCityPresent;
ddlCityPresent.DataTextField = "cityName";
ddlCityPresent.DataValueField = "cityID";
ddlCityPresent.DataBind();
ddlCityPresent.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
catch (Exception)
{
// throw;
}
}
/// <summary>
/// Handles the Click event of the btnSubmit control.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
// Check isEdit is true for update personal details
if (isEdit)
{
PersonalDetailsJSEntity objPersonalDetailsEntity = new PersonalDetailsJSEntity();
PersonalDetailsJSBAL personalDetailsBAL = new PersonalDetailsJSBAL();
// Set value to PersonalDetails job seeker entity
objPersonalDetailsEntity.candidateId = candidateId;
objPersonalDetailsEntity.presentAddress = txtPresentAddress.Text.Trim();
objPersonalDetailsEntity.presentCountryId = Convert.ToInt32(ddlCountryPresent.SelectedValue);
objPersonalDetailsEntity.presentStateId = Convert.ToInt32(ddlStatePresent.SelectedValue);
objPersonalDetailsEntity.presentCityId = Convert.ToInt32(ddlCityPresent.SelectedValue);
objPersonalDetailsEntity.presentArea = Convert.ToInt32(ddlAreaPresent.SelectedValue);
objPersonalDetailsEntity.presentPincode = Convert.ToInt32(txtPincodePresent.Text);
objPersonalDetailsEntity.permantAddress = txtAddressPerm.Text.Trim();
objPersonalDetailsEntity.permantCountryId = Convert.ToInt32(ddlCountryPerm.SelectedValue);
objPersonalDetailsEntity.permantStateId = Convert.ToInt32(ddlStatePerm.SelectedValue);
objPersonalDetailsEntity.permantCityId = Convert.ToInt32(ddlCityPerm.SelectedValue);
objPersonalDetailsEntity.permantArea = Convert.ToInt32(ddlAreaPerm.SelectedValue);
objPersonalDetailsEntity.permantPincode = Convert.ToInt32(txtPincodePerm.Text);
objPersonalDetailsEntity.dateOfBirth = Convert.ToDateTime(txtDOB.Text);
// Check if fileupload control has a file.
if (FileUploadPhoto.PostedFile != null)
{
objPersonalDetailsEntity.photo = Path.GetFileName(FileUploadPhoto.PostedFile.FileName);
FileUploadPhoto.SaveAs(Server.MapPath("~/UploadImages/" + objPersonalDetailsEntity.photo));
}
else
{
objPersonalDetailsEntity.photo = Path.GetFileName(imgPersonalPhoto.ImageUrl);
}
// Check if radio button checked
if (rbtPassportYes.Checked)
{
string validity = ddlMonth.SelectedItem.Text + '/' + ddlYear.SelectedItem.Text;
objPersonalDetailsEntity.passportNumber = Convert.ToInt32(txtPassportNo.Text);
objPersonalDetailsEntity.passportValidity = validity;
}
else
{
objPersonalDetailsEntity.passportNumber = Convert.ToInt32(null);
objPersonalDetailsEntity.passportValidity = "null";
}
objPersonalDetailsEntity.maritialStatus = ddlMaritalStatus.SelectedItem.Text;
int result = personalDetailsBAL.UpdatePersonalDetailsBAL(objPersonalDetailsEntity);
// Check if result is greater than zero or not
if (result > 0)
{
Response.Write("<script language='javascript'>alert('Personal Details Updated')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Sorry')</script>");
}
}
else
{
PersonalDetailsJSEntity personalDetailsEntity = new PersonalDetailsJSEntity();
PersonalDetailsJSBAL personalDetailsBAL = new PersonalDetailsJSBAL();
// Set value to PersonalDetails job seeker entity
personalDetailsEntity.candidateId = candidateId;
personalDetailsEntity.permantAddress = txtAddressPerm.Text.Trim();
personalDetailsEntity.permantCountryId = Convert.ToInt32(ddlCountryPerm.SelectedValue);
personalDetailsEntity.permantStateId = Convert.ToInt32(ddlStatePerm.SelectedValue);
personalDetailsEntity.permantCityId = Convert.ToInt32(ddlCityPerm.SelectedValue);
personalDetailsEntity.permantArea = Convert.ToInt32(ddlAreaPerm.SelectedValue);
personalDetailsEntity.permantPincode = Convert.ToInt32(txtPincodePerm.Text);
personalDetailsEntity.dateOfBirth = Convert.ToDateTime(txtDOB.Text);
// Check if fileupload control has a file.
if (FileUploadPhoto.PostedFile != null)
{
personalDetailsEntity.photo = Path.GetFileName(FileUploadPhoto.PostedFile.FileName);
FileUploadPhoto.SaveAs(Server.MapPath("~/UploadImages/" + personalDetailsEntity.photo));
}
// Check if radio button checked
if (rbtPassportYes.Checked)
{
string validity = ddlMonth.SelectedItem.Text + '/' + ddlYear.SelectedItem.Text;
personalDetailsEntity.passportNumber = Convert.ToInt32(txtPassportNo.Text);
personalDetailsEntity.passportValidity = validity;
}
else
{
personalDetailsEntity.passportNumber = Convert.ToInt32(null);
personalDetailsEntity.passportValidity = "null";
}
personalDetailsEntity.maritialStatus = ddlMaritalStatus.SelectedItem.Text;
int result = personalDetailsBAL.SavePersonalDetailsBAL(personalDetailsEntity);
// Check if result is greater than zero or not
if (result > 0)
{
Response.Write("<script language='javascript'>alert('Personal Details Inserted')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Sorry')</script>");
}
}
}
catch (Exception ex)
{
// throw;
}
}
/// <summary>
/// Handles the SelectedIndexChanged event of the ddlCountryPerm control.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddlCountryPerm_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
PersonalDetailsJSBAL personalDetailsBAL = new PersonalDetailsJSBAL();
int CountryId = Convert.ToInt32(ddlCountryPerm.SelectedValue);
DataSet dsStatePerm = new DataSet();
dsStatePerm = personalDetailsBAL.GetState(CountryId);
// Check if dataset is not null
if (dsStatePerm != null)
{
ddlStatePerm.DataSource = dsStatePerm;
ddlStatePerm.DataTextField = "StateName";
ddlStatePerm.DataValueField = "StateId";
ddlStatePerm.DataBind();
ddlStatePerm.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
catch (Exception)
{
// throw;
}
}