public ActionResult Create([Bind(Include = "ID,Name,Surname,Email,PhoneNr,RegistrationDate,EnterpriseID")] Employee employee)
        {
            if (ModelState.IsValid)
            {
                int?result           = ToNullableInt32(Request.Form["CompetenceID"]);
                var competenceRating = new CompetenceRating
                {
                    CompetenceID = result,
                    EmployeeID   = employee.ID
                };
                db.CompetencesRatings.Add(competenceRating);

                db.Employees.Add(employee);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.EnterpriseID = new SelectList(db.Enterprises, "ID", "Name", employee.EnterpriseID);
            return(View(employee));
        }
        public ActionResult Edit([Bind(Include = "ID,Name,Surname,Email,PhoneNr,RegistrationDate,EnterpriseID")] Employee employee)
        {
            if (ModelState.IsValid)
            {
                int?result = ToNullableInt32(Request.Form["CompetenceID"]);
                if (result != db.CompetencesRatings.Where(c => c.EmployeeID == employee.ID).First().CompetenceID)
                {
                    var competenceRating = new CompetenceRating
                    {
                        CompetenceID = result,
                        EmployeeID   = employee.ID
                    };
                    db.CompetencesRatings.Add(competenceRating);
                }

                db.Entry(employee).State = EntityState.Modified;
                db.Entry(employee).Property(e => e.RegistrationDate).IsModified = false;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            ViewBag.EnterpriseID = new SelectList(db.Enterprises, "ID", "Name", employee.EnterpriseID);
            return(View(employee));
        }
        public ActionResult Create([Bind(Include = "ID,EmployeeID,CompetenceID,Grade,DateCreated")] CompetenceRating competenceRating)
        {
            if (ModelState.IsValid)
            {
                var temp = db.CompetencesRatings.Where(e => e.EmployeeID == competenceRating.EmployeeID).FirstOrDefault();
                //if (temp != null )
                //{
                //    temp.CompetenceID = competenceRating.CompetenceID;
                //    temp.Grade = competenceRating.Grade;
                //    db.Entry(temp).State = EntityState.Modified;
                //    db.SaveChanges();
                //} else
                //{
                competenceRating.DateCreated = DateTime.Now;
                db.CompetencesRatings.Add(competenceRating);
                db.SaveChanges();
                // }
                return(RedirectToAction("Index"));
            }

            ViewBag.CompetenceID = new SelectList(db.Competences, "ID", "Name", competenceRating.CompetenceID);
            ViewBag.EmployeeID   = new SelectList(db.Employees, "ID", "Name", competenceRating.EmployeeID);
            return(View(competenceRating));
        }