// GET: Employee/Assign/5
public ActionResult Assign(int id)
{
AssignEmployeeViewModel assignView = new AssignEmployeeViewModel(_config.GetConnectionString("DefaultConnection"), id);
return(View(assignView));
}
public ActionResult Assign(int id, AssignEmployeeViewModel model)
{
using (SqlConnection conn = Connection)
try
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO EmployeeTraining (EmployeeId, TrainingProgramId) VALUES (@employeeId, @trainingProgramId)";
cmd.Parameters.Add(new SqlParameter("@employeeId", id));
cmd.Parameters.Add(new SqlParameter("@trainingProgramId", model.selectedTrainingProgramId));
cmd.ExecuteNonQuery();
return(RedirectToAction("Details", new { id }));
}
}
catch
{
return(View());
}
}
