Exemple #1
0
        public ActionResult AddMyTecgnologies(technology_resume objectTechnology)
        {
            if (objectTechnology.rank == null && objectTechnology.core_technology == null)
            {
                objectTechnology.rank            = 0;
                objectTechnology.core_technology = false;
            }
            else if (objectTechnology.rank == null)
            {
                objectTechnology.rank = 0;
            }
            else if (objectTechnology.core_technology == null)
            {
                objectTechnology.core_technology = false;
            }

            FullResumeOperations resumeOperations = new FullResumeOperations();

            resumeOperations.AddMyTechnologies(objectTechnology.technology_id, objectTechnology.resume_id,
                                               objectTechnology.core_technology, objectTechnology.rank);
            // CV:t hämtas för att listan med kompetenser ska uppdateras
            FullResume fullResume = resumeOperations.GetFullResumeById(objectTechnology.resume_id);

            int num = db.SaveChanges();

            return(Json(num));
        }
Exemple #2
0
        private void GetEducationsListByResume(FullResume fullResume)
        {
            //fullResume.MyEducations = new List<education>();

            try {
                var list = (from ed in db.education
                            join re in db.resume on ed.resume_id equals re.resume_id
                            where ed.resume_id == fullResume.Resume_id
                            select new { ed.resume_id, ed.title, ed.description, ed.date, ed.education_id, ed.resume }).ToList();

                foreach (var item in list)
                {
                    education edu = new education();
                    edu.date         = item.date;
                    edu.description  = item.description;
                    edu.education_id = item.education_id;
                    edu.resume       = item.resume;
                    edu.resume_id    = item.resume_id;
                    edu.title        = item.title;
                    fullResume.MyEducations.Add(edu);
                }
            }
            catch (SqlException ex)
            {
                //TODO: gör något med felmeddelandet
                throw;
            }
        }
Exemple #3
0
        private void GetCompetenceList(FullResume fullResume) //Metod för att hämta teknologier på inskickad freelancerVM och lagra dessa i en lista
        {
            string     sql = "SELECT competence_id, name FROM competence";
            competence c;

            try
            {
                using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString))
                {
                    conn.Open();
                    using (SqlCommand command = new SqlCommand(sql, conn))
                    {
                        command.Parameters.AddWithValue("resume_id", fullResume.Resume_id);
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                c = new competence()
                                {
                                    competence_id = (reader.GetInt32(0)),
                                    name          = (reader.GetString(1))
                                };
                                fullResume.Competences.Add(c);
                            }
                        }
                    }
                }
            }
            catch (Exception)
            {
                // gör något med felmeddelandet
                throw;
            }
        }
Exemple #4
0
        public ActionResult RemoveMyCompetences(competence competence)
        {
            FullResumeOperations resumeOperations = new FullResumeOperations();

            resumeOperations.RemoveMyCompetences(competence.competence_id, competence.resume_id);
            // CV:t hämtas för att listan med kompetenser ska uppdateras
            FullResume fullResume = resumeOperations.GetFullResumeById(competence.resume_id);

            int num = db.SaveChanges();

            return(Json(num));
        }
Exemple #5
0
        public ActionResult RemoveMyTecgnologies(technology_resume objectTechnology)
        {
            FullResumeOperations resumeOperations = new FullResumeOperations();

            resumeOperations.RemoveMyTechnologies(objectTechnology.technology_id, objectTechnology.resume_id);
            // CV:t hämtas för att listan med kompetenser ska uppdateras
            FullResume fullResume = resumeOperations.GetFullResumeById(objectTechnology.resume_id);

            int num = db.SaveChanges();

            return(Json(num));
        }
Exemple #6
0
        public IActionResult Resume(FullResume model, char Separator)
        {
            //ViewData["Message"] = "Your application description page.";
            ViewData["Message"] = "Submitted!! You can get a result in Analysis Tab";
            int splitUnit = 5;

            if (Separator.Equals("."))
            {
                Separator = '.';
                splitUnit = 5;
            }
            else if (Separator.Equals("blank"))
            {
                Separator = ' ';
                splitUnit = 30;
            }
            else
            {
                Separator = '\n';
                splitUnit = 5;
            }
            // int splitUnit = 30;
            String[] word    = model.Context.Split(Separator);
            int      wordLen = word.Length;
            int      arrSize = wordLen / splitUnit + 1;

            PartialResume[] wordArr = new PartialResume[arrSize];
            StringBuilder   sb      = null;

            for (int i = 0; i < arrSize - 1; i++)
            {
                sb = new StringBuilder();
                for (int j = i * splitUnit; j < (i + 1) * splitUnit; j++)
                {
                    sb.AppendLine(word[j]);
                }
                wordArr[i]         = new PartialResume();
                wordArr[i].Context = sb.ToString();
                sb = null;
            }
            sb = new StringBuilder();
            for (int i = (arrSize - 1) * splitUnit; i < wordLen; i++)
            {
                sb.AppendLine(word[i]);
            }
            wordArr[arrSize - 1]         = new PartialResume();
            wordArr[arrSize - 1].Context = sb.ToString();
            sb = null;
            ViewBag.partialContext = wordArr;

            return(View());
        }
Exemple #7
0
        //FreelancerProfileOperations fp = new FreelancerProfileOperations();

        public FullResume GetFullResumeById(int?id)  //Metod för att hämta information om en freelancer
        {
            FullResume fullResume = new FullResume();

            string sql = "SELECT freelancer.freelancer_id, firstname, lastname, resume_id, profile, driving_license from resume INNER JOIN freelancer on resume.freelancer_id = freelancer.freelancer_id WHERE resume.resume_id = @resume_id";

            try
            {
                using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString))
                {
                    conn.Open();
                    using (SqlCommand command = new SqlCommand(sql, conn))
                    {
                        command.Parameters.AddWithValue("resume_id", id);
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                fullResume.Freelancer_id   = reader.GetInt32(0);
                                fullResume.Firstname       = reader.GetString(1);
                                fullResume.Lastname        = reader.GetString(2);
                                fullResume.Resume_id       = reader.GetInt32(3);
                                fullResume.Profile         = reader.GetString(4);
                                fullResume.Driving_license = reader.GetString(5).Trim();
                            }
                        }
                    }
                }
                GetMyCompetences(fullResume);
                GetMyTechnologies(fullResume);
                GetCompetenceList(fullResume);
                GetTechnologyList(fullResume);
                GetEducationsListByResume(fullResume);
            }
            catch (Exception)
            {
                // gör något med felmeddelandet
                throw;
            }

            return(fullResume);
        }
Exemple #8
0
        public void GetMyTechnologies(FullResume fullResume) //Metod för att hämta teknologier på inskickad freelancerVM och lagra dessa i en lista
        {
            fullResume.MyTechnologies.Clear();
            string sql = "SELECT technology.technology_id, technology.name, technology_resume.rank, " +
                         "technology_resume.core_technology, technology.competence_id from technology_resume " +
                         "INNER JOIN technology on technology_resume.technology_id = technology.technology_id " +
                         "WHERE resume_id = @resume_id";
            FullTechnology t;

            try
            {
                using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString))
                {
                    conn.Open();
                    using (SqlCommand command = new SqlCommand(sql, conn))
                    {
                        command.Parameters.AddWithValue("resume_id", fullResume.Resume_id);
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                t = new FullTechnology()
                                {
                                    technology_id   = (reader.GetInt32(0)),
                                    name            = (reader.GetString(1)),
                                    rank            = (reader.GetInt32(2)),
                                    core_technology = (reader.GetBoolean(3)),
                                    competence_id   = (reader.GetInt32(4)),
                                };
                                fullResume.MyTechnologies.Add(t);
                            }
                        }
                    }
                }
            }
            catch (Exception)
            {
                // gör något med felmeddelandet
                throw;
            }
        }
Exemple #9
0
        public ActionResult Edit([Bind(Include = "resume_id,freelancer_id,driving_license,profile")] FullResume fullResume)
        {
            resume resume = new resume();

            resume.resume_id       = fullResume.Resume_id;
            resume.freelancer_id   = fullResume.Freelancer_id;
            resume.driving_license = fullResume.Driving_license;
            resume.profile         = fullResume.Profile.Trim();



            if (ModelState.IsValid)
            {
                db.Entry(resume).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Details", "freelancers", new { id = resume.freelancer_id }));
                //return RedirectToAction("Index");
            }
            //ViewBag.freelancer_id = new SelectList(db.freelancer, "freelancer_id", "firstname", resume.freelancer_id);
            return(View(resume));
        }
Exemple #10
0
        private void GetMyCompetences(FullResume fullResume)//Metod för att hämta kompetenser på inskickad freelancerVM och lagra dessa i en lista
        {
            fullResume.MyCompetences.Clear();
            competence c;
            string     sql = "SELECT competence.competence_id, resume_id, name from competence_resume " +
                             "INNER JOIN competence on competence_resume.competence_id = competence.competence_id " +
                             "WHERE resume_id = @resume_id";

            try
            {
                using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString))
                {
                    conn.Open();
                    using (SqlCommand command = new SqlCommand(sql, conn))
                    {
                        command.Parameters.AddWithValue("resume_id", fullResume.Resume_id);
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            while (reader.Read())
                            {
                                c = new competence()
                                {
                                    competence_id = (reader.GetInt32(0)),
                                    resume_id     = (reader.GetInt32(1)),
                                    name          = (reader.GetString(2))
                                };
                                fullResume.MyCompetences.Add(c);
                            }
                        }
                    }
                }
            }
            catch (Exception)
            {
                //gör något med felmeddelandet
                throw;
            }
        }
Exemple #11
0
 public void GetTechnologyList(FullResume fullResume) //Metod för att hämta teknologier med inskickad ResumeVM och lagra dessa i en lista
 {
     fullResume.Technologies.Clear();
     foreach (competence competence in fullResume.MyCompetences)
     {
         string     sql = "SELECT name, technology_id FROM technology WHERE competence_id = @competenceID";
         technology t;
         try
         {
             using (SqlConnection conn = new SqlConnection(GetBuilder().ConnectionString))
             {
                 conn.Open();
                 using (SqlCommand command = new SqlCommand(sql, conn))
                 {
                     command.Parameters.AddWithValue("competenceID", competence.competence_id);
                     using (SqlDataReader reader = command.ExecuteReader())
                     {
                         while (reader.Read())
                         {
                             t = new technology()
                             {
                                 name          = (reader.GetString(0)),
                                 technology_id = (reader.GetInt32(1))
                             };
                             fullResume.Technologies.Add(t);
                         }
                     }
                 }
             }
         }
         catch (Exception)
         {
             // gör något med felmeddelandet
             throw;
         }
     }
 }