public Int32 UpdateRecord(AddJobPostEntity JobPostentity)
{
try
{
connection.Open();
SqlCommand cmd = new SqlCommand();
SqlParameter[] sqlparams ={
new SqlParameter("@JobTitle",JobPostentity.JobTitle),
new SqlParameter("@CompanyLevel",JobPostentity.CompanyLevel),
new SqlParameter("@Industry",JobPostentity.IndustryId),
new SqlParameter("@Department",JobPostentity.DepartmentId),
new SqlParameter("@FunctionalArea",JobPostentity.FunctionalAreaId),
new SqlParameter("@JobDescription",JobPostentity.JobDescription),
new SqlParameter("@KeywordsRoles",JobPostentity.KeywordsRoles),
new SqlParameter("@KeywordsTechnical",JobPostentity.KeywordsRoles),
//new SqlParameter("@WorkExperience",JobPostentity.WorkExperience),
new SqlParameter("@Gender",JobPostentity.Gender),
new SqlParameter("@OfferedAnnualSalary",JobPostentity.OfferedAnnualSalaryMin),
new SqlParameter("@OfferedAnnualSalary",JobPostentity.OfferedAnnualSalaryMax),
new SqlParameter("@OtherSalaryDetails",JobPostentity.OtherSalaryDetails),
new SqlParameter("@NumberOfVacancies",JobPostentity.NumberOfVacancies),
};
int result = SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "sp_RE_UpdateJobPost", sqlparams);
return result;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Insert technical skills dal
/// </summary>
/// <param name="jobpostEntity">AddJobPostEntity</param>
public void AddTechnicalSkillsDetailsDAL(AddJobPostEntity jobpostEntity)
{
try
{
Connection.Open();
SqlParameter[] sparams = { new SqlParameter("@SkillName", jobpostEntity.TechnicalSkill) };
SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, Constants.sp_JS_InsertTechnicalSkills, sparams);
}
catch (Exception)
{
throw;
}
}
public int UpdateJobPostDAL(AddJobPostEntity jobpostEntity)
{
int result = 0;
try
{
Connection.Open();
SqlParameter[] sqlparams ={
new SqlParameter("@jobId",jobpostEntity.JobId),
new SqlParameter("@RecruiterID",jobpostEntity.RecruiterID),
new SqlParameter("@JobTitle",jobpostEntity.JobTitle),
new SqlParameter("@JobLocationState",jobpostEntity.JobLocationState),
new SqlParameter("@JobLocationCity",jobpostEntity.JobLocationCity),
new SqlParameter("@JobLocationArea",jobpostEntity.JobLocationArea),
new SqlParameter("@CompanyLevel",jobpostEntity.CompanyLevel),
new SqlParameter("@JobIndustryId",jobpostEntity.IndustryId),
new SqlParameter("@DepartmentId",jobpostEntity.DepartmentId),
new SqlParameter("@FunctionalAreaId",jobpostEntity.FunctionalAreaId),
new SqlParameter("@JobDescription",jobpostEntity.JobDescription),
new SqlParameter("@KeywordsRoles",jobpostEntity.KeywordsRoles),
new SqlParameter("@KeywordsTechnical",jobpostEntity.KeywordsTechnical),
new SqlParameter("@WorkExperienceMin",jobpostEntity.WorkExperienceMin),
new SqlParameter("@WorkExperienceMax",jobpostEntity.WorkExperienceMax),
new SqlParameter("@Gender",jobpostEntity.Gender),
new SqlParameter("@OfferedAnnualSalaryMin",jobpostEntity.OfferedAnnualSalaryMin),
new SqlParameter("@OfferedAnnualSalaryMax",jobpostEntity.OfferedAnnualSalaryMax),
new SqlParameter("@OtherSalaryDetails",jobpostEntity.OtherSalaryDetails),
new SqlParameter("@NumberOfVacancies",jobpostEntity.NumberOfVacancies),
new SqlParameter("@JobType",jobpostEntity.JobType),
new SqlParameter("@EmploymentStatus",jobpostEntity.EmploymentStatus),
new SqlParameter("@RecruitmentType",jobpostEntity.RecruitmentType),
new SqlParameter("@CompanyName",jobpostEntity.CompanyName),
new SqlParameter("@ClientName",jobpostEntity.ClientName),
new SqlParameter("@Position",jobpostEntity.Position),
new SqlParameter("@requirementId",jobpostEntity.RequirementId),
new SqlParameter("@companyProfile",jobpostEntity.CompanyProfile),
new SqlParameter("@qualification",jobpostEntity.Qualification),
new SqlParameter("@questionnareId",jobpostEntity.QueationnareId),
new SqlParameter("@describeCandidateProfile",jobpostEntity.DescribeCandidateProfile)
};
result = SqlHelper.ExecuteNonQuery(Connection, CommandType.StoredProcedure, Constants.sp_RE_UpdateJobPost, sqlparams);
}
catch (Exception)
{
throw;
}
finally
{
Connection.Close();
}
return result;
}
/// <summary>
/// Handles the Click event of the btnPostjob control of current job details
/// </summary>
/// <param name="sender">The source of event</param>
/// <param name="e">The <cref="EventArgs">instance containing event data</param>
public void btnPostJob_Click(object sender, EventArgs e)
{
try
{
if (!isEdit)
{
PostNewJobBAL addJobPostBAL = new PostNewJobBAL();
AddJobPostEntity addJobPostEntity = new AddJobPostEntity();
addJobPostEntity.RecruiterID = "12";
addJobPostEntity.JobTitle = txtJobtitle.Text.Trim();
addJobPostEntity.JobLocationState = ddlState.SelectedItem.Value;
addJobPostEntity.JobLocationCity = ddlCity.SelectedItem.Value;
addJobPostEntity.JobLocationArea = ddllocation.SelectedItem.Value;
addJobPostEntity.CompanyLevel = ddlCompanytype.SelectedItem.Text.Trim();
addJobPostEntity.IndustryId = Convert.ToInt32(ddlIndustry.SelectedValue);
addJobPostEntity.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue);
addJobPostEntity.FunctionalAreaId = Convert.ToInt32(ddlFunArea.SelectedValue);
addJobPostEntity.JobDescription = txtJobDescription.Text.Trim();
addJobPostEntity.KeywordsRoles = txtKeyRoles.Text.Trim();
addJobPostEntity.KeywordsTechnical = txtKeyTechnical.Text.Trim();
addJobPostEntity.WorkExperienceMin = ddlWorkExperienceMin.SelectedItem.Text.Trim();
addJobPostEntity.WorkExperienceMax = ddlWorkExperienceMax.SelectedItem.Text.Trim();
addJobPostEntity.Gender = ddlgender.SelectedItem.Text.Trim();
addJobPostEntity.OfferedAnnualSalaryMin = Convert.ToString(ddlsalarymin.SelectedItem);
addJobPostEntity.OfferedAnnualSalaryMax = Convert.ToString(ddlsalarymax.SelectedItem);
addJobPostEntity.OtherSalaryDetails = txtsalarydetaills.Text.Trim();
addJobPostEntity.NumberOfVacancies = Convert.ToInt32(txtVacancies.Text.Trim());
addJobPostEntity.JobType = lblselectedjobtype.Text;
addJobPostEntity.EmploymentStatus = lblemploymentstatus.Text;
addJobPostEntity.RecruitmentType = rdbrecruitmenttype.SelectedItem.Text;
// Check if recruitmentType is In-House
if (addJobPostEntity.RecruitmentType == "In-House")
{
addJobPostEntity.CompanyName = rblCompanyName.SelectedItem.Text;
}
else
{
addJobPostEntity.CompanyName = "null";
}
addJobPostEntity.ClientName = lblClientName.Text.Trim();
addJobPostEntity.Position = lblPosition.Text.Trim();
addJobPostEntity.RequirementId = Convert.ToInt32(lblRequirementId.Text);
if (addJobPostEntity.CompanyName == "Logos Corporate Solutions")
{
addJobPostEntity.CompanyProfile = lblCompanyProfile.Text;
}
else
{
addJobPostEntity.CompanyProfile = lblCompanyProfileiTech.Text;
}
addJobPostEntity.Qualification = txtQualification.Text;
addJobPostEntity.QueationnareId = Convert.ToInt32(ddlquestionnaire.SelectedValue);
addJobPostEntity.DescribeCandidateProfile = txtCandidateProfile.Text;
int result = addJobPostBAL.JobPostBAL(addJobPostEntity);
if (result > 0)
{
Response.Write("<script language='javascript'>alert('JobPost Done ')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Sorry')</script>");
}
}
else
{
PostNewJobBAL addJobPostBAL = new PostNewJobBAL();
AddJobPostEntity addJobPostEntity = new AddJobPostEntity();
addJobPostEntity.JobId = jobPostId;
addJobPostEntity.RecruiterID = "12";
addJobPostEntity.JobTitle = txtJobtitle.Text.Trim();
addJobPostEntity.JobLocationState = ddlState.SelectedItem.Value;
addJobPostEntity.JobLocationCity = ddlCity.SelectedItem.Value;
addJobPostEntity.JobLocationArea = ddllocation.SelectedItem.Value;
addJobPostEntity.CompanyLevel = ddlCompanytype.SelectedItem.Text.Trim();
addJobPostEntity.IndustryId = Convert.ToInt32(ddlIndustry.SelectedValue);
addJobPostEntity.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue);
addJobPostEntity.FunctionalAreaId = Convert.ToInt32(ddlFunArea.SelectedValue);
addJobPostEntity.JobDescription = txtJobDescription.Text.Trim();
addJobPostEntity.KeywordsRoles = txtKeyRoles.Text.Trim();
addJobPostEntity.KeywordsTechnical = txtKeyTechnical.Text.Trim();
addJobPostEntity.WorkExperienceMin = ddlWorkExperienceMin.SelectedItem.Text.Trim();
addJobPostEntity.WorkExperienceMax = ddlWorkExperienceMax.SelectedItem.Text.Trim();
addJobPostEntity.Gender = ddlgender.SelectedItem.Text.Trim();
addJobPostEntity.OfferedAnnualSalaryMin = Convert.ToString(ddlsalarymin.SelectedItem);
addJobPostEntity.OfferedAnnualSalaryMax = Convert.ToString(ddlsalarymax.SelectedItem);
addJobPostEntity.OtherSalaryDetails = txtsalarydetaills.Text.Trim();
addJobPostEntity.NumberOfVacancies = Convert.ToInt32(txtVacancies.Text.Trim());
addJobPostEntity.JobType = lblselectedjobtype.Text;
addJobPostEntity.EmploymentStatus = lblemploymentstatus.Text;
addJobPostEntity.RecruitmentType = rdbrecruitmenttype.SelectedItem.Text;
// Check if recruitmentType is In-House
if (addJobPostEntity.RecruitmentType == "In-House")
{
addJobPostEntity.CompanyName = rblCompanyName.SelectedItem.Text;
}
else
{
addJobPostEntity.CompanyName = "null";
}
addJobPostEntity.ClientName = lblClientName.Text.Trim();
addJobPostEntity.Position = lblPosition.Text.Trim();
addJobPostEntity.RequirementId = Convert.ToInt32(lblRequirementId.Text);
if (addJobPostEntity.CompanyName == "Logos Corporate Solutions")
{
addJobPostEntity.CompanyProfile = lblCompanyProfile.Text;
}
else
{
addJobPostEntity.CompanyProfile = lblCompanyProfileiTech.Text;
}
addJobPostEntity.Qualification = txtQualification.Text;
addJobPostEntity.QueationnareId = Convert.ToInt32(ddlquestionnaire.SelectedValue);
addJobPostEntity.DescribeCandidateProfile = txtCandidateProfile.Text;
int result = addJobPostBAL.UpdateJobPostBAL(addJobPostEntity);
if (result > 0)
{
Response.Write("<script language='javascript'>alert('JobPost Updated ')</script>");
}
else
{
Response.Write("<script language='javascript'>alert('Sorry')</script>");
}
}
}
catch (Exception ex)
{
Label1.Text = ex.Message.ToString();
}
}
/// <summary>
/// Handles the Click event of the btnAddTechnicalSkill control
/// </summary>
/// <param name="sender">The source of event</param>
/// <param name="e">The <cref="EventArgs">instance containing event data</param>
protected void btnAddTechnicalSkill_Click(object sender, EventArgs e)
{
PostNewJobBAL postNewJobBAL = new PostNewJobBAL();
AddJobPostEntity addJobPostEntity = new AddJobPostEntity();
addJobPostEntity.TechnicalSkill = txtTechnicalSkill.Text.Trim();
postNewJobBAL.AddTechnicalSkillsDetailsBAL(addJobPostEntity);
Panel2.Visible = false;
}
/// <summary>
/// Handles the Click event of the btnAddRoles control
/// </summary>
/// <param name="sender">The source of event</param>
/// <param name="e">The <cref="EventArgs">instance containing event data</param>
protected void btnAddRoles_Click(object sender, EventArgs e)
{
PostNewJobBAL postNewJobBAL = new PostNewJobBAL();
AddJobPostEntity addJobPostEntity = new AddJobPostEntity();
addJobPostEntity.RoleSkill = txtRoleSkills.Text.Trim();
postNewJobBAL.AddRoleSkillsDetailsBAL(addJobPostEntity);
Panel1.Visible = false;
}
/// <summary>
/// Insert technical skills details bal
/// </summary>
/// <param name="jobpostEntity">AddJobPostEntity</param>
public void AddTechnicalSkillsDetailsBAL(AddJobPostEntity jobpostEntity)
{
PostNewJobDAL newjobpostDAL = new PostNewJobDAL();
newjobpostDAL.AddTechnicalSkillsDetailsDAL(jobpostEntity);
}
public int UpdateJobPostBAL(AddJobPostEntity jobpostEntity)
{
PostNewJobDAL newjobpostDAL = new PostNewJobDAL();
return newjobpostDAL.UpdateJobPostDAL(jobpostEntity);
}
/// <summary>
/// Insert job post bal
/// </summary>
/// <param name="jobpostEntity">AddJobPostEntity</param>
/// <returns>System.Int32</returns>
public int JobPostBAL(AddJobPostEntity jobpostEntity)
{
PostNewJobDAL JPDAL = new PostNewJobDAL();
return JPDAL.JobPostDAL(jobpostEntity);
}
