Ejemplo n.º 1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string Jobid = Request.QueryString["id"];
            string Empid = Request.QueryString["empId"];

                int JobidParsed = int.Parse(Jobid);
                int EmpidParsed = int.Parse(Empid);

                Job GotJobDetails = new Job();

               BLL.BLLRecruiterWebsiteManager GettingJobDetailsMethod = new BLLRecruiterWebsiteManager();

               GotJobDetails = GettingJobDetailsMethod.GetJobDetails(JobidParsed, EmpidParsed);

            lblGetJobTitle.Text = GotJobDetails.Title.ToString();
            lblGetCompany.Text = GotJobDetails.Company.ToString();
            lblGetLocation.Text = GotJobDetails.Location.ToString();
            lblGetDescription.Text = GotJobDetails.Description.ToString();
            lblGetJobType.Text = GotJobDetails.Type.ToString();
            lblGetSalary.Text = GotJobDetails.Salary.ToString();
            lblGetDataCreated.Text = GotJobDetails.DateCreated.ToString();
        }
Ejemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string JobType = Request.QueryString["Type"];
            string Location = Request.QueryString["loc"];

            lblJobCategory.Text = JobType.ToString();
            lblLocationSearch.Text = Location.ToString();

            Job SearchJobRequest = new Job();

            List<Job> JobList = new List<Job>();

            BLLRecruiterWebsiteManager RequestJobSearch = new BLLRecruiterWebsiteManager();

            JobList = RequestJobSearch.SearchJob(JobType, Location);

               // List<Job> EditJobList = new List<Job>();

            GridView1.DataSource = from t in JobList
                                   orderby t.DateCreated ascending
                                   select new
                                   {
                                       t.JobID,
                                       t.EmpID,
                                       t.Category,
                                       t.Title,
                                       t.Company,
                                       t.Location,
                                       t.Description,
                                       t.Type,
                                       t.Terms,
                                       t.Salary,
                                       t.DateCreated
                                   };

               // GridView1.DataBound();

            GridView1.DataBind();
        }
 // method for entering job into database
 public bool InsertJob(Job job)
 {
     bool result = false;
     
     try
     {
         DALRecruiterWebsiteManager DALMngr = new DALRecruiterWebsiteManager();
         result = DALMngr.InsertJobDetails(job);
     }
     catch (Exception ex)
     {
         throw;
     }
     return result;
 }
        // Get job details for apply job page. 

        public Job GetJobDetails(int Jobid, int Empid)
        {

            DALRecruiterWebsiteManager RequestingJobDetails = new DALRecruiterWebsiteManager();

            Job GotJobDetails = new Job();

            GotJobDetails = RequestingJobDetails.GetJobDetails(Jobid, Empid);

            return GotJobDetails;
        }
Ejemplo n.º 5
0
        public void CreateJob()
        {
            string jobCategory;
            string company;
            string title;
            string location;
            string description;
            string requirements ;
            string type;
            string terms;
            decimal salary;
            string link = string.Empty;
            
            jobCategory = drplstCreateJobCategory.SelectedItem.ToString();
            company = txtCompany.Text;
            title = txtCreateJobTitle.Text;
            location = drplstCreateJobLocation.SelectedItem.ToString();
            description = txtCreateJobDescription.Text;
            requirements = txtCreateJobRequirements.Text;
            type = drplstCreateJobType.SelectedItem.ToString();
            terms = drplstCreateJobTerms.SelectedItem.ToString();
            bool isValid = decimal.TryParse(txtCreateJobSalary.Text, out salary);

            if (!IsValid)
            {
                txtCreateJobSalary.Text = "Invalid entry";
            }
            if(isValid)
            {
                Job job = new Job(jobCategory, company, title, location, description, requirements, type, terms, salary, link);

                job.EmpID = (int)Session["EmployerID"];

                // job.Link = string.Format(("~/Job.aspx?id={0}&empId={1}"), job.JobID.ToString(), job.EmpID.ToString());

                job.DateCreated = DateTime.Now;

                try
                {
                    BLLRecruiterWebsiteManager BLLMngr = new BLLRecruiterWebsiteManager();
                    job.Link = string.Format(("~/Job.aspx?id={0}&empId={1}"), job.JobID.ToString(), job.EmpID.ToString());
                    bool result = BLLMngr.InsertJob(job);
                    if (result == true)
                    {

                        job.Link = string.Format(("~/Job.aspx?id={0}&empId={1}"), job.JobID.ToString(), job.EmpID.ToString());


                        //NEW CODE I'VE ENTERED FOR EMAILER
                        List<WatchedJob> watchJobList = BLLMngr.GetListOfWatchedJobsFromDAL();
                        List<Jobseeker> jobseekerList = BLLMngr.ListOfJobseekers();
                        Jobseeker getJobsseeker = null;

                        foreach (WatchedJob wj in watchJobList)
                        {
                            foreach (Jobseeker j in jobseekerList)
                            {
                                if (j.JobseekerID == wj.JobseekerID)
                                {
                                    getJobsseeker = j;
                                }
                            }
                            if (jobCategory == "Finance")
                            {
                                if (wj.Finance == true)
                                {

                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                            else if (jobCategory == "Computing")
                            {
                                if (wj.Computing == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                            else if (jobCategory == "Retail")
                            {
                                if (wj.Retail == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);
                                    ;
                                }
                            }
                            else if (jobCategory == "Sales")
                            {
                                if (wj.Sales == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                            else if (jobCategory == "Engineering")
                            {
                                if (wj.Engineering == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);


                                }
                            }
                            else if (jobCategory == "Legal")
                            {
                                if (wj.Legal == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                            else if (jobCategory == "Tourism")
                            {
                                if (wj.Tourism == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                            else if (jobCategory == "Publishing")
                            {
                                if (wj.Publishing == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                            else if (jobCategory == "Telecoms")
                            {
                                if (wj.Telecoms == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                            else if (jobCategory == "Manufacturing")
                            {
                                if (wj.Manufacturing == true)
                                {
                                    SendNotificationOfNewJobMail(getJobsseeker.JobseekerEmail, getJobsseeker.JobseekerUsername, jobCategory, title, description);

                                }
                            }
                        }
                        /*
                         Computing
                    Retail
                    Sales
                    Engineering
                    Legal
                    Tourism
                    Publishing
                    Telecoms
                    Manufacturing
                         * */

                        //END OF NEW CODE
                        DataRow row = dt.NewRow();
                        /*
                         dt.Columns.Add("jobID");
                        dt.Columns.Add("empID");  
                         * */
                        row["jobID"] = job.JobID;
                        job.Link = string.Format(("~/JobApply.aspx?id={0}&empId={1}"), job.JobID.ToString(), job.EmpID.ToString());
                        row["empID"] = job.EmpID;
                        row["jobCategory"] = job.Category;
                        row["company"] = job.Company;
                        row["title"] = job.Title;
                        row["location"] = job.Location;
                        row["description"] = job.Description;
                        row["requirements"] = job.Requirements;
                        row["terms"] = job.Terms;
                        row["salary"] = job.Salary;
                        row["link"] = job.Link;
                        row["dateCreated"] = job.DateCreated;


                        dt.Rows.Add(row);
                        ds.AcceptChanges();

                        ds.WriteXml(Server.MapPath("~/XML/Jobs.xml"));

                        Response.Redirect("~/JobSearch.aspx?Type=" + job.Category.ToString() + "&loc=" + job.Location.ToString() + "");
                    }
                }
                catch (Exception ex)
                {
                    throw;
                }
            }
            
            
   

            
            
            /*
            Validations validate = new Validations();
            string isValid = validate.ValidateXMLUsingXSD();
            if(isValid == string.Empty)
            {

            }*/
        }
        // Gets all the current live jobs for Employer profile. 

        public List<Job>GetJobListForEmployerProfile(int EmployerID)
        {
            List<Job> JobsList = new List<Job>();
            

            try
            {
                using (SqlConnection Cxn = new SqlConnection(CxnString))
                {
                    using (SqlCommand Cmd = new SqlCommand("spGetJobListEmployerProfile",Cxn))
                    {
                        Cmd.CommandType = CommandType.StoredProcedure;

                        SqlParameter EmpIdParam = new SqlParameter("@EmpId", SqlDbType.Int);

                        EmpIdParam.Value = EmployerID;

                        Cmd.Parameters.Add(EmpIdParam);

                        Cxn.Open();
                        dr = Cmd.ExecuteReader();

                       

                        while (dr.Read())
                        {
                            Job JobObject = new Job();

                            int JobID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobID)));
                            int EmpID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetEmpID)));
                            string Category = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetCategory)).ToString());
                            string Company = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_Company)).ToString());
                            string Title = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTitle)).ToString());
                            string Location = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetLocation)).ToString());
                            string JobDesc = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobDesc)).ToString());
                            string Requirements = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetRequirements)).ToString());
                            string JobType = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobType)).ToString());
                            string Terms = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTerms)).ToString());
                            decimal Salary = Convert.ToDecimal(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetSalary)));
                            DateTime Date = Convert.ToDateTime(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetDateCreated)));

                            JobObject.JobID = JobID;
                            JobObject.EmpID = EmpID;
                            JobObject.Category = Category;
                            JobObject.Company = Company;
                            JobObject.Title = Title;
                            JobObject.Location = Location;
                            JobObject.Description = JobDesc;
                            JobObject.Requirements = Requirements;
                            JobObject.Type = JobType;
                            JobObject.Terms = Terms;
                            JobObject.Salary = Salary;
                            JobObject.DateCreated = Date;


                         

                            JobsList.Add(JobObject);

                       
                           

                        }

                    }
                }
            }
            catch (SqlException ex)
            {

                throw;
            }
            return JobsList;
        }
        // gets jobs details for people applying for a role. 

        public Job GetJobDetails(int Jobid, int Empid)
        {
            Job GetJobDetail = new Job();

            try
            {
                using (SqlConnection Cxn = new SqlConnection(CxnString))
                {
                    using (SqlCommand Cmd = new SqlCommand("GetJobDetails",Cxn))
                    {
                        Cmd.CommandType = CommandType.StoredProcedure;

                        SqlParameter JobidParam = new SqlParameter("@Jobid", SqlDbType.Int);
                        SqlParameter EmpidParam = new SqlParameter("@Empid", SqlDbType.Int);

                        JobidParam.Value = Jobid;
                        EmpidParam.Value = Empid;

                        Cmd.Parameters.Add(JobidParam);
                        Cmd.Parameters.Add(EmpidParam);

                        Cxn.Open();
                        dr = Cmd.ExecuteReader();

                        while (dr.Read())
                        {
                            int JobID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobID)));
                            int EmpID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetEmpID)));
                            string Category = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetCategory)).ToString());
                            string Company = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_Company)).ToString());
                            string Title = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTitle)).ToString());
                            string Location = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetLocation)).ToString());
                            string JobDesc = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobDesc)).ToString());
                            string Requirements = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetRequirements)).ToString());
                            string JobType = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobType)).ToString());
                            string Terms = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTerms)).ToString());
                            DateTime Date = Convert.ToDateTime(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetDateCreated)));
                            decimal Salary = Convert.ToDecimal(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetSalary)));

                            GetJobDetail.JobID = JobID;
                            GetJobDetail.EmpID = EmpID;
                            GetJobDetail.Category = Category;
                            GetJobDetail.Company = Company;
                            GetJobDetail.Title = Title;
                            GetJobDetail.Location = Location;
                            GetJobDetail.Description = JobDesc;
                            GetJobDetail.Requirements = Requirements;
                            GetJobDetail.Type = JobType;
                            GetJobDetail.Terms = Terms;
                            GetJobDetail.Salary = Salary;
                            GetJobDetail.DateCreated = Date;
                            
                        }

                        dr.Close();
                        Cxn.Close();

                    }
                    
                }

                return GetJobDetail;

                

            }
            catch (SqlException ex)
            {
                
                throw;
            }

            
        }
        // This controls the search option, takes two parameters. 

        public List<Job> SearchJobsList(string JobType, string Location)
        {
            List<Job> JobList = new List<Job>();

            try
            {
                using (SqlConnection Cxn = new SqlConnection(CxnString))
                {
                    using (SqlCommand Cmd = new SqlCommand("spSearchJob", Cxn))
                    {
                        Cmd.CommandType = CommandType.StoredProcedure;

                        SqlParameter JobTypeParam = new SqlParameter("@JobType", SqlDbType.NVarChar, 50);
                        SqlParameter LocationParam = new SqlParameter("@Location", SqlDbType.NVarChar, 50);

                        JobTypeParam.Value = JobType;
                        LocationParam.Value = Location;

                        Cmd.Parameters.Add(JobTypeParam);
                        Cmd.Parameters.Add(LocationParam);

                     //   SqlDataReader testingSqlDataReader;

                        Cxn.Open();
                        dr = Cmd.ExecuteReader();
                        

                        while (dr.Read())
                        {
                            Job SearchJob = new Job();
                            int JobID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobID)));
                            int EmpID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetEmpID)));
                            string Category = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetCategory)).ToString());
                            string Company = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_Company)).ToString());
                            string Title = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTitle)).ToString());
                            string Location1 = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetLocation)).ToString());
                            string JobDesc = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobDesc)).ToString());
                            string Requirements = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetRequirements)).ToString());
                            string JobType1 = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobType)).ToString());
                            string Terms = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTerms)).ToString());
                            decimal Salary = Convert.ToDecimal(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetSalary)));
                            DateTime Date = Convert.ToDateTime(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetDateCreated)));

                            SearchJob.JobID = JobID;
                            SearchJob.EmpID = EmpID;
                            SearchJob.Category = Category;
                            SearchJob.Company = Company;
                            SearchJob.Title = Title;
                            SearchJob.Location = Location1;
                            SearchJob.Description = JobDesc;
                            SearchJob.Requirements = Requirements;
                            SearchJob.Type = JobType1;
                            SearchJob.Terms = Terms;
                            SearchJob.Salary = Salary;
                            SearchJob.DateCreated = Date;

                            JobList.Add(SearchJob);

                        }

                        dr.Close();
                        Cxn.Close();

                    }
                }

            }
                
            catch (SqlException ex)
            {
                
                throw;
            }

            return JobList;
        }
        // Get a list of all the jobs for the Admin section 

        public List<Job> GetAllJobsForAdminSection()
        {
            List<Job> ListOfAllActiveJobs = new List<Job>();

            try
            {
                using (SqlConnection Cxn = new SqlConnection(CxnString))
                {
                    using (SqlCommand Cmd = new SqlCommand("spGetAllJobsForAdmin", Cxn))
                    {

                        Cxn.Open();

                        dr = Cmd.ExecuteReader();

                        while (dr.Read())
                        {

                            Job JobAdminProfile = new Job();
                            int JobID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobID)));
                            int EmpID = Convert.ToInt32(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetEmpID)));
                            string Category = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetCategory)).ToString());
                            string Company = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_Company)).ToString());
                            string Title = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTitle)).ToString());
                            string Location1 = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetLocation)).ToString());
                            string JobDesc = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobDesc)).ToString());
                            string Requirements = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetRequirements)).ToString());
                            string JobType1 = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetJobType)).ToString());
                            string Terms = (dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetTerms)).ToString());
                            decimal Salary = Convert.ToDecimal(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetSalary)));
                            DateTime Date = Convert.ToDateTime(dr.GetValue(Convert.ToInt32(Job_GetJobDetail.SP_GetDateCreated)));

                            JobAdminProfile.JobID = JobID;
                            JobAdminProfile.EmpID = EmpID;
                            JobAdminProfile.Category = Category;
                            JobAdminProfile.Company = Company;
                            JobAdminProfile.Title = Title;
                            JobAdminProfile.Location = Location1;
                            JobAdminProfile.Description = JobDesc;
                            JobAdminProfile.Requirements = Requirements;
                            JobAdminProfile.Type = JobType1;
                            JobAdminProfile.Terms = Terms;
                            JobAdminProfile.Salary = Salary;
                            JobAdminProfile.DateCreated = Date;

                            ListOfAllActiveJobs.Add(JobAdminProfile);

                        }

                        dr.Close();
                        Cxn.Close();

                    }
                }

            }
            catch (SqlException ex)
            {

                throw;
            }

            return ListOfAllActiveJobs;

        }
        // method for entering job details in database
        public bool InsertJobDetails(Job job)
        {
            bool result = false;
            try 
            {
                using (SqlConnection Cxn = new SqlConnection(CxnString))
                {
                    using (SqlCommand Cmd = new SqlCommand("spCreateJob", Cxn))
                    {
                        Cmd.CommandType = CommandType.StoredProcedure;
                        /*
                    (EmpID, Category, Company, Title, Location, JobDescription, Requirements, JobType, Terms, Salary, DateCreated)
                    OUTPUT inserted.JobID INTO @IdInserted ///@jobid
                    VALUES
                    (@empid @type, @terms, @salary, @date)
*/
                        SqlParameter InsertEmpIDParam = new SqlParameter("@empid", SqlDbType.Int, 4);
                        SqlParameter InsertJobCategoryParam = new SqlParameter("@category", SqlDbType.NVarChar, 50);
                        SqlParameter InsertCompanyParam = new SqlParameter("@company", SqlDbType.NVarChar, 50);
                        SqlParameter InsertJobTitleParam = new SqlParameter("@title", SqlDbType.NVarChar, 50);
                        SqlParameter InsertLocationParam = new SqlParameter("@location", SqlDbType.NVarChar, 50);
                        SqlParameter InsertJobDescriptionParam = new SqlParameter("@description", SqlDbType.NVarChar, 50);
                        SqlParameter InsertRequirementsParam = new SqlParameter("@requirements", SqlDbType.NVarChar, 50);
                        SqlParameter InsertJobTypeParam = new SqlParameter("@type", SqlDbType.NVarChar, 50);
                        SqlParameter InsertJobTermsParam = new SqlParameter("@terms", SqlDbType.NVarChar, 50);
                        SqlParameter InsertSalaryParam = new SqlParameter("@salary", SqlDbType.Decimal);
                        SqlParameter InsertDateCreatedParam = new SqlParameter("@date", SqlDbType.DateTime);
                        SqlParameter OutputJobIDParam = new SqlParameter("@jobid", SqlDbType.Int, 4);
                        SqlParameter InsertLinkParam = new SqlParameter("@Link", SqlDbType.NVarChar, 50);


                        InsertEmpIDParam.Value = job.EmpID;
                        InsertJobCategoryParam.Value = job.Category;
                        InsertCompanyParam.Value = job.Company;
                        InsertJobTitleParam.Value = job.Title;
                        InsertLocationParam.Value = job.Location;
                        InsertJobDescriptionParam.Value = job.Description;
                        InsertRequirementsParam.Value = job.Requirements;
                        InsertJobTypeParam.Value = job.Type;
                        InsertJobTermsParam.Value = job.Terms;
                        InsertSalaryParam.Value = job.Salary;
                        InsertDateCreatedParam.Value = job.DateCreated;
                        InsertLinkParam.Value = job.Link;
                        OutputJobIDParam.Direction = ParameterDirection.Output;

                        Cmd.Parameters.Add(InsertEmpIDParam);
                        Cmd.Parameters.Add(InsertJobCategoryParam);
                        Cmd.Parameters.Add(InsertCompanyParam);
                        Cmd.Parameters.Add(InsertJobTitleParam);
                        Cmd.Parameters.Add(InsertLocationParam);
                        Cmd.Parameters.Add(InsertJobDescriptionParam);
                        Cmd.Parameters.Add(InsertRequirementsParam);
                        Cmd.Parameters.Add(InsertJobTypeParam);
                        Cmd.Parameters.Add(InsertJobTermsParam);
                        Cmd.Parameters.Add(InsertSalaryParam);
                        Cmd.Parameters.Add(InsertDateCreatedParam);
                        Cmd.Parameters.Add(InsertLinkParam);

                        Cmd.Parameters.Add(OutputJobIDParam);

                        Cxn.Open();
                        int i = Cmd.ExecuteNonQuery();
                        if(i > 0)
                        {
                            job.JobID = Convert.ToInt32(OutputJobIDParam.Value);
                            result = true;
                        }
                        else 
                        {
                            result = false;
                        }
                        Cxn.Close();

                    
                    }
                }
            }
            catch (SqlException ex)
            {
                throw;
            }
            return result;
        }