/// <summary>
/// Pesonal Details of job seeker
/// </summary>
/// <param name="personalDetailsEntity">Object for inserting data into database</param>
/// <returns>System.Int32</returns>
public int SavePersonalDetails(PersonalDetailsJSEntity personalDetailsEntity)
{
int result = 0;
try
{
connection.Open();
SqlCommand cmd = new SqlCommand();
SqlParameter[] sqlparams = {
new SqlParameter("@candidateId",personalDetailsEntity.candidateId),
new SqlParameter("@permantAddress",personalDetailsEntity.permantAddress),
new SqlParameter("@permantCountryId",personalDetailsEntity.permantCountryId),
new SqlParameter("@permantStateId",personalDetailsEntity.permantStateId),
new SqlParameter("@permantCityId",personalDetailsEntity.permantCityId),
new SqlParameter("@permantArea",personalDetailsEntity.permantArea),
new SqlParameter("@permantPincode",personalDetailsEntity.permantPincode),
new SqlParameter("@dateOfBirth", personalDetailsEntity.dateOfBirth.Date),
new SqlParameter("@maritialStatus",personalDetailsEntity.maritialStatus),
new SqlParameter("@passportNumber", personalDetailsEntity.passportNumber),
new SqlParameter("@passportValidity",personalDetailsEntity.passportValidity),
new SqlParameter("@photo", "~/UploadImages/"+personalDetailsEntity.photo)
};
result = SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, Constants.sp_JS_InsertPersonalDetails, sqlparams);
}
catch (Exception)
{
// throw ;
}
finally
{
connection.Close();
}
return result;
}
/// <summary>
/// Update personal details bal
/// </summary>
/// <param name="personalDetailsEntity">PersonalDetailsJSEntity</param>
/// <returns>System.Int32</returns>
public int UpdatePersonalDetailsBAL(PersonalDetailsJSEntity personalDetailsEntity)
{
PersonalDetailsJSDAL pdDAL = new PersonalDetailsJSDAL();
return pdDAL.UpdatePersonalDetailsDAL(personalDetailsEntity);
}
/// <summary>
/// Personal Details of job seeker bal.
/// </summary>
/// <param name="personalDetailsEntity">The Personal Details entity.</param>
/// <returns>System.Int32</returns>
public int SavePersonalDetailsBAL(PersonalDetailsJSEntity personalDetailsEntity)
{
PersonalDetailsJSDAL pdDAL = new PersonalDetailsJSDAL();
return pdDAL.SavePersonalDetails(personalDetailsEntity);
}
/// <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;
}
}
