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