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)); }