/// <summary>
/// Update personal details dal
/// </summary>
/// <param name="objPersonalDetailsEntity">PersonalDetailsEntity</param>
/// <returns>System.Int32</returns>
public int UpdatePersonalDetailsDAL(PersonalDetailsEntity objPersonalDetailsEntity)
{
int result = 0;
try
{
connection.Open();
SqlCommand cmd = new SqlCommand();
SqlParameter[] sqlparams = {
new SqlParameter("@recruiterId",objPersonalDetailsEntity.recruiterId),
new SqlParameter("@presentAddress",objPersonalDetailsEntity.presentAddress),
new SqlParameter("@presentCountryId",objPersonalDetailsEntity.presentCountryId),
new SqlParameter("@presentStateId",objPersonalDetailsEntity.presentStateId),
new SqlParameter("@presentCityId",objPersonalDetailsEntity.presentCityId),
new SqlParameter("@presentArea",objPersonalDetailsEntity.presentArea),
new SqlParameter("@presentPincode",objPersonalDetailsEntity.presentPincode),
new SqlParameter("@permantAddress",objPersonalDetailsEntity.permantAddress),
new SqlParameter("@permantCountryId",objPersonalDetailsEntity.permantCountryId),
new SqlParameter("@permantStateId",objPersonalDetailsEntity.permantStateId),
new SqlParameter("@permantCityId",objPersonalDetailsEntity.permantCityId),
new SqlParameter("@permantArea",objPersonalDetailsEntity.permantArea),
new SqlParameter("@permantPincode",objPersonalDetailsEntity.permantPincode),
new SqlParameter("@dateOfBirth", objPersonalDetailsEntity.dateOfBirth.Date),
new SqlParameter("@maritalStatus",objPersonalDetailsEntity.maritialStatus),
new SqlParameter("@passportNumber", objPersonalDetailsEntity.passportNumber),
new SqlParameter("@passportValidity",objPersonalDetailsEntity.passportValidity)
};
result = SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, Constants.sp_RE_UpdatePersonalDetails, sqlparams);
}
catch (Exception)
{
throw;
}
return result;
}
/// <summary>
/// Update personal details bal
/// </summary>
/// <param name="objPersonalDetailsEntity">objPersonalDetailsEntity</param>
/// <returns>System.Int32</returns>
public int UpdatePersonalDetailsBAL(PersonalDetailsEntity objPersonalDetailsEntity)
{
PersonalDetailsREDAL pdDAL = new PersonalDetailsREDAL();
return pdDAL.UpdatePersonalDetailsDAL(objPersonalDetailsEntity);
}
/// <summary>
/// Personal Details of recruiter bal.
/// </summary>
/// <param name="personalDetailsEntity">The Personal Details entity.</param>
/// <returns>System.Int32</returns>
public int SavePersonalDetailsBAL(PersonalDetailsEntity personalDetailsEntity)
{
PersonalDetailsREDAL personalDetailsDAL = new PersonalDetailsREDAL();
return personalDetailsDAL.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 if is Edit for update
if (isEdit)
{
PersonalDetailsEntity objPersonalDetailsEntity = new PersonalDetailsEntity();
PersonalDetailsREBAL personalDetailsBAL = new PersonalDetailsREBAL();
// Set value to PersonalDetails for recruiter entity
objPersonalDetailsEntity.recruiterId = recruiterId;
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 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
{
PersonalDetailsEntity personalDetailsEntity = new PersonalDetailsEntity();
PersonalDetailsREBAL personalDetailsBAL = new PersonalDetailsREBAL();
// Set value to PersonalDetails of recruiter entity
personalDetailsEntity.recruiterId = recruiterId;
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 radio button checked
if (rbtPassportYes.Checked)
{
string validity = ddlMonth.SelectedItem.Text + '/' + ddlYear.SelectedItem.Text;
personalDetailsEntity.passportNumber = Convert.ToInt32(txtPassportNo.Text);
personalDetailsEntity.passportValidity = validity;
personalDetailsEntity.passportIssue = "Yes";
}
else
{
personalDetailsEntity.passportNumber = Convert.ToInt32(null);
personalDetailsEntity.passportValidity = "null";
personalDetailsEntity.passportIssue = "No";
}
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)
{
throw;
}
}
