public static List<string> GetTechnicalskill(string prefixText)
{
try
{
DataTable dt = new DataTable();
PostNewJobBAL postnewjobBAL = new PostNewJobBAL();
dt = postnewjobBAL.GetTechnicalskillBAL(prefixText);
List<string> skillname = new List<string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
skillname.Add(dt.Rows[i][1].ToString());
}
return skillname;
}
catch (Exception)
{
throw;
}
}
/// <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>
/// Bind state
/// </summary>
private void BindState()
{
try
{
DataSet ds = new DataSet();
PostNewJobBAL postnewjobBAL = new PostNewJobBAL();
ds = postnewjobBAL.GetState();
// Check if dataset is not null
if (ds != null)
{
ddlState.DataSource = ds;
ddlState.DataTextField = "StateName";
ddlState.DataValueField = "StateId";
ddlState.DataBind();
ddlState.Items.Insert(0, new ListItem("--Select--", "0"));
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Bind requirement name
/// </summary>
private void BindRequirementName()
{
try
{
PostNewJobBAL postNewJobBAL = new PostNewJobBAL();
DataSet dsRequirement = new DataSet();
dsRequirement = postNewJobBAL.GetRequirementBAL();
// Check if dataset is not null
if (dsRequirement != null)
{
ddlRequirementName.DataSource = dsRequirement;
ddlRequirementName.DataTextField = "Position";
ddlRequirementName.DataValueField = "ClientRequirementId";
ddlRequirementName.DataBind();
ddlRequirementName.Items.Insert(0, new ListItem("-----select--------", "0"));
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Binding dropdown with Questionaries
/// </summary>
private void BindQuestions()
{
try
{
PostNewJobBAL newJobPostBAL = new PostNewJobBAL();
ddlquestionnaire.DataSource = newJobPostBAL.GetQuestionsBAL();
ddlquestionnaire.DataTextField = "QuestionnaireName";
ddlquestionnaire.DataValueField = "QuestionnaireId";
ddlquestionnaire.DataBind();
ddlquestionnaire.Items.Insert(0, new ListItem("--Select--", "0"));
}
catch (Exception)
{
throw;
}
}
private void BindJobPost(int jobPostId, long recruiterId)
{
try
{
Int32 stateId, cityId;
DataSet dsViewJobPost = new DataSet();
PostNewJobBAL postNewJobBAL = new PostNewJobBAL();
dsViewJobPost = postNewJobBAL.ViewJobPostBAL(jobPostId, recruiterId);
if (dsViewJobPost != null)
{
DataSet dsCity = new DataSet();
stateId = Convert.ToInt32(dsViewJobPost.Tables[0].Rows[0]["JobLocationState"]);
dsCity = PostNewJobBAL.GetCity(stateId);
if (dsCity != null)
{
ddlCity.DataSource = dsCity;
ddlCity.DataTextField = "CityName";
ddlCity.DataValueField = "CityId";
ddlCity.DataBind();
}
DataSet dsArea = new DataSet();
cityId = Convert.ToInt32(dsViewJobPost.Tables[0].Rows[0]["JobLocationCity"]);
dsArea = PostNewJobBAL.GetArea(cityId);
if (dsArea != null)
{
ddllocation.DataSource = dsArea;
ddllocation.DataTextField = "AreaName";
ddllocation.DataValueField = "AreaId";
ddllocation.DataBind();
}
ddlRequirementName.Enabled = false;
lblClientName.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["ClientName"]);
lblPosition.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["Position"]);
lblRequirementId.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["RequirementId"]);
txtJobtitle.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobTitle"]);
ddlState.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobLocationState"]);
ddlCity.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobLocationCity"]);
ddllocation.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobLocationArea"]);
ddlCompanytype.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["CompanyLevel"]);
ddlIndustry.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobIndustryId"]);
ddlDepartment.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["DepartmentId"]);
ddlFunArea.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["FunctionalAreaId"]);
txtJobDescription.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobDescription"]);
txtKeyRoles.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["KeywordsRoles"]);
txtKeyTechnical.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["KeywordsTechnical"]);
ddlWorkExperienceMin.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["WorkExperienceMin"]);
ddlWorkExperienceMax.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["WorkExperienceMax"]);
ddlgender.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["Gender"]);
ddlsalarymin.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["OfferedAnnualSalaryMin"]);
ddlsalarymax.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["OfferedAnnualSalaryMax"]);
txtsalarydetaills.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["OtherSalaryDetails"]);
txtVacancies.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["NumberOfVacancies"]);
txtQualification.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["Qualification"]);
txtCandidateProfile.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["DescribeCandidateProfile"]);
ddlquestionnaire.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["QuestionnaireId"]);
chkjobtype.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobType"]);
lblselectedjobtype.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["JobType"]);
chkemploymenttype.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["EmploymentStatus"]);
lblemploymentstatus.Text = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["EmploymentStatus"]);
rdbrecruitmenttype.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["RecruitmentType"]);
if (rdbrecruitmenttype.SelectedValue == "In-House")
{
pnlInHouse.Visible = true;
pnlClient.Visible = false;
pnlCompanyProfile.Visible = false;
}
else
{
pnlInHouse.Visible = false;
pnlClient.Visible = true;
pnlCompanyProfile.Visible = false;
}
rblCompanyName.SelectedValue = Convert.ToString(dsViewJobPost.Tables[0].Rows[0]["CompanyName"]);
}
}
catch (Exception)
{
throw;
}
}
protected void ddlRequirementName_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
PostNewJobBAL postNewJobBAL = new PostNewJobBAL();
int requirementId = Convert.ToInt32(ddlRequirementName.SelectedValue);
ds = postNewJobBAL.GetRequirementDetailBAL(requirementId);
// Check if dataset is not null
if (ds != null)
{
lblClientName.Text = Convert.ToString(ds.Tables[0].Rows[0]["ClientName"]);
lblPosition.Text = Convert.ToString(ds.Tables[0].Rows[0]["Position"]);
lblRequirementId.Text = Convert.ToString(ds.Tables[0].Rows[0]["ClientRequirementId"]);
}
}
catch (Exception)
{
throw;
}
}
/// <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;
}
