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