/// <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; } }