public ActionResult Assign(int id, [FromForm] AddEmployeeToTPViewModel employeeTraining) { foreach (var item in employeeTraining.TrainingProgramIds) { try { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"INSERT INTO EmployeeTraining (EmployeeId, TrainingProgramId) OUTPUT INSERTED.Id VALUES (@employeeId, @trainingProgramId)"; cmd.Parameters.Add(new SqlParameter("@employeeId", id)); cmd.Parameters.Add(new SqlParameter("@trainingProgramId", item)); var EtId = (int)cmd.ExecuteScalar(); //employeeTraining.TrainingProgramIds.Add(employeeTraining.TrainingProgramId); } } } catch (Exception ex) { return(View()); } } return(RedirectToAction("Details", new { Id = id })); }
// GET: Employees/AssignTP public ActionResult Assign(int id) { var employee = GetEmployeeById(id); var trainingProgramOptions = GetAvailableTrainingPrograms(id); var registeredTrainingPrograms = GetAssignedTrainingPrograms(id); trainingProgramOptions.AddRange(registeredTrainingPrograms); var viewModel = new AddEmployeeToTPViewModel() { EmployeeId = employee.Id, TrainingProgramOptions = trainingProgramOptions, TrainingProgramIds = GetTrainingProgramIds(id) }; return(View(viewModel)); }