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;
            }
        }
Exemple #2
0
 /// <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;
     }
 }
Exemple #3
0
        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;
 }
Exemple #7
0
 /// <summary>
 /// Insert technical skills details bal
 /// </summary>
 /// <param name="jobpostEntity">AddJobPostEntity</param>
 public void AddTechnicalSkillsDetailsBAL(AddJobPostEntity jobpostEntity)
 {
     PostNewJobDAL newjobpostDAL = new PostNewJobDAL();
     newjobpostDAL.AddTechnicalSkillsDetailsDAL(jobpostEntity);
 }
Exemple #8
0
 public int UpdateJobPostBAL(AddJobPostEntity jobpostEntity)
 {
     PostNewJobDAL newjobpostDAL = new PostNewJobDAL();
     return newjobpostDAL.UpdateJobPostDAL(jobpostEntity);
 }
Exemple #9
0
 /// <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);
 }