public IActionResult Assign(int id, TrainingAssignViewModel assign)
{
using (SqlConnection conn = Connection)
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO EmployeeTraining (EmployeeId, TrainingProgramId)
VALUES (@employeeId, @trainingProgramId)";
cmd.Parameters.AddWithValue("@employeeId", id);
cmd.Parameters.AddWithValue("@trainingProgramId", assign.TrainingProgramId);
cmd.ExecuteNonQuery();
}
}
return(RedirectToAction(nameof(Details), new { id = id }));
}
// GET: Employee/Assign/2
public ActionResult Assign(int id)
{
var viewModel = new TrainingAssignViewModel();
var allPrograms = new TrainingAssignViewModel();
allPrograms.TrainingPrograms = CreateTrainingSelections(GetAllPrograms());
viewModel.TrainingPrograms = CreateTrainingSelections(GetEligibleTrainingPrograms(id));
viewModel.EmployeeId = id;
allPrograms.EmployeeId = id;
if (viewModel.TrainingPrograms.Count > 0)
{
return(View(viewModel));
}
else
{
return(View(allPrograms));
}
return(View(allPrograms));
}
