public ActionResult AddEmployment(Prior_Employments model)
        {
            cvId = GetId();

            Prior_Employments empl = new Prior_Employments();

            if (!db.Prior_Employments.Any())
            {
                empl.Id = 0;
            }
            else
            {
                int lastId = int.Parse(db.Prior_Employments.OrderByDescending(x => x.Id).Select(x => x.Id).First().ToString());
                empl.Id = lastId + 1;
            }
            empl.Company      = model.Company;
            empl.Position     = model.Position;
            empl.EmployerDesc = model.EmployerDesc;
            empl.DateHired    = model.DateHired;
            empl.DateLeft     = model.DateLeft;
            empl.DateCreated  = DateTime.Now;
            empl.CVId         = cvId;


            if (ModelState.IsValid)
            {
                db.Prior_Employments.Add(empl);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View());
        }
        public ActionResult _PriorEmploymentsPartialView()
        {
            cvId = GetId();

            Prior_Employments pemp = new Prior_Employments();
            var pemps = db.Prior_Employments.Where(p => p.CVId == cvId);

            ViewBag.Emps = pemps;


            return(PartialView("_PriorEmploymentsPartialView", pemp));
        }
        public ActionResult _FlowPartialView()
        {
            var f = new List <Freelancer>();


            var edu  = new Education();
            var emp  = new Prior_Employments();
            var lang = new Language();
            var qual = new Core_Qualification();

            var emps  = new List <Prior_Employments>();
            var edus  = new List <Education>();
            var quals = new List <Core_Qualification>();
            var langs = new List <Language>();

            foreach (var x in db.Freelancer)
            {
                var cv  = new CV();
                var cvn = new List <CV>();
                cv = db.CV.FirstOrDefault(c => c.FreelancerId == x.Id);
                cvn.Add(cv);

                var fl = new Freelancer()
                {
                    Firstname   = x.Firstname,
                    Lastname    = x.Lastname,
                    Phone       = x.Phone,
                    Email       = x.Email,
                    Adress      = x.Adress,
                    City        = x.City,
                    Postalnr    = x.Postalnr,
                    Nationality = x.Nationality,
                    Conumber    = x.Conumber,
                    Id          = x.Id,
                    CV          = cvn
                };
                var free = fl.Id;
                f.Add(fl);
            }

            PopulateList();
            var qualFields = qualificationFields;

            ViewBag.QualFields = qualFields;

            ViewBag.Edu  = edus;
            ViewBag.Emp  = emps;
            ViewBag.Lang = langs;
            ViewBag.Qual = quals;

            return(PartialView("_FlowPartialView", f));
        }
        public ActionResult _FreelancerEmpPartialView(int?id)
        {
            var f   = db.Freelancer.Find(id);
            var c   = db.CV.SingleOrDefault(cf => cf.FreelancerId == f.Id);
            var cid = db.Prior_Employments.FirstOrDefault(cf => cf.CVId == c.FreelancerId);
            var emp = new List <Prior_Employments>();

            foreach (var x in c.Prior_Employments)
            {
                var e = new Prior_Employments()
                {
                    EmployerDesc = x.EmployerDesc,
                    Company      = x.Company,
                    DateHired    = x.DateHired,
                    DateLeft     = x.DateLeft,
                    Position     = x.Position
                };
                emp.Add(e);
            }
            return(PartialView("_FreelancerEmpPartialView", emp));
        }
        public ActionResult EditEmployment(Prior_Employments model)
        {
            cvId = GetId();

            Prior_Employments empl = new Prior_Employments();

            empl.Company      = model.Company;
            empl.Position     = model.Position;
            empl.EmployerDesc = model.EmployerDesc;
            empl.DateHired    = model.DateHired;
            empl.DateLeft     = model.DateLeft;
            empl.DateCreated  = DateTime.Now;
            empl.CVId         = cvId;
            empl.Id           = model.Id;
            if (ModelState.IsValid)
            {
                db.Entry(empl).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View());
        }