public ActionResult DeleteConfirmed(int id)
        {
            EmployeeInTraining employeeInTraining = db.EmployeeInTrainings.Find(id);

            db.EmployeeInTrainings.Remove(employeeInTraining);
            db.SaveChanges();
            return(RedirectToAction("EmployeesInTraining", new { id = employeeInTraining.TrainingID }));
        }
        // GET: EmployeeInTraining/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmployeeInTraining employeeInTraining = db.EmployeeInTrainings.Find(id);

            if (employeeInTraining == null)
            {
                return(HttpNotFound());
            }
            ViewBag.id = id;
            return(View(employeeInTraining));
        }
        // GET: EmployeeInTraining/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmployeeInTraining employeeInTraining = db.EmployeeInTrainings.Find(id);

            if (employeeInTraining == null)
            {
                return(HttpNotFound());
            }
            ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "LastName", employeeInTraining.EmployeeID);
            ViewBag.TrainingID = new SelectList(db.Trainings, "TrainingID", "Name", employeeInTraining.TrainingID);
            ViewBag.id         = id;
            return(View(employeeInTraining));
        }
        public ActionResult Create([Bind(Include = "EmployeeInTrainingID,TrainingID")] EmployeeInTraining employeeInTraining, int[] EmployeeIDs)
        {
            if (ModelState.IsValid)
            {
                foreach (var id in EmployeeIDs)
                {
                    EmployeeInTraining emp = new EmployeeInTraining();
                    emp.TrainingID = employeeInTraining.TrainingID;
                    emp.EmployeeID = id;
                    db.EmployeeInTrainings.Add(emp);
                    db.SaveChanges();
                }
            }

            return(RedirectToAction("EmployeesInTraining", new { id = employeeInTraining.TrainingID }));
            //ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "LastName", employeeInTraining.EmployeeID);
            //ViewBag.TrainingID = new SelectList(db.Trainings, "TrainingID", "Name", employeeInTraining.TrainingID);
            //return View(employeeInTraining);
        }
        public ActionResult Edit([Bind(Include = "EmployeeInTrainingID,EmployeeID,TrainingID,IfPass")] EmployeeInTraining employeeInTraining)
        {
            if (ModelState.IsValid)
            {
                if (employeeInTraining.IfPass)
                {
                    var training = db.Trainings.Find(employeeInTraining.TrainingID);
                    // Find employee qualification
                    var empQualification = db.EmployeeQualification.Where(empQual => empQual.EmployeeID == employeeInTraining.EmployeeID && empQual.QualificationID == training.QualificationID).FirstOrDefault();

                    if (empQualification == null)
                    {
                        empQualification = new EmployeeQualification()
                        {
                            EmployeeID      = employeeInTraining.EmployeeID,
                            QualificationID = training.QualificationID,
                            ExpirationDate  = training.ExpirationDate
                        };
                        db.EmployeeQualification.Add(empQualification);
                    }
                    else
                    {
                        if (empQualification.ExpirationDate < training.ExpirationDate)
                        {
                            empQualification.ExpirationDate = training.ExpirationDate;
                        }
                    }
                }
                db.Entry(employeeInTraining).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("EmployeesInTraining", new { id = employeeInTraining.TrainingID }));
            }
            ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "LastName", employeeInTraining.EmployeeID);
            ViewBag.TrainingID = new SelectList(db.Trainings, "TrainingID", "Name", employeeInTraining.TrainingID);
            return(View(employeeInTraining));
        }
        public ActionResult Diploma(int?id)
        {
            EmployeeInTraining employeeInTraining = db.EmployeeInTrainings.Find(id);

            return(View(employeeInTraining));
        }