public ActionResult Edit(int id, TrainingProgramEditViewModel viewModel) { TrainingProgram trainingProgram = viewModel.TrainingProgram; try { var updatedTrainingProgram = viewModel.TrainingProgram; using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"UPDATE TrainingProgram SET Name = @name, StartDate = @startDate, EndDate = @endDate, MaxAttendees = @maxAttendees WHERE Id = @id"; cmd.Parameters.Add(new SqlParameter("@name", updatedTrainingProgram.Name)); cmd.Parameters.Add(new SqlParameter("@startDate", updatedTrainingProgram.StartDate)); cmd.Parameters.Add(new SqlParameter("@endDate", updatedTrainingProgram.EndDate)); cmd.Parameters.Add(new SqlParameter("@maxAttendees", updatedTrainingProgram.MaxAttendees)); cmd.Parameters.Add(new SqlParameter("@id", id)); cmd.ExecuteNonQuery(); } } return(RedirectToAction(nameof(Index))); } catch { return(View()); } }
public ActionResult Edit(int id, TrainingProgramEditViewModel viewModel) { try { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"UPDATE trainingprogram SET [name] = @trainName, startDate = @startDate, endDate = @endDate, maxattendees = @max WHERE id = @id"; cmd.Parameters.Add(new SqlParameter("@trainName", viewModel.TrainingProgram.Name)); cmd.Parameters.Add(new SqlParameter("@startDate", viewModel.TrainingProgram.StartDate)); cmd.Parameters.Add(new SqlParameter("@endDate", viewModel.TrainingProgram.EndDate)); cmd.Parameters.Add(new SqlParameter("@max", viewModel.TrainingProgram.MaxAttendees)); cmd.Parameters.Add(new SqlParameter("@id", id)); cmd.ExecuteNonQuery(); return(RedirectToAction(nameof(Index))); } } } catch { return(View()); } }
// GET: TrainingProgram/Edit/5 public ActionResult Edit(int id) { TrainingProgram trainingProgram = GetTrainingProgramById(id); DateTime currentDate = DateTime.Now; if (trainingProgram.StartDate > currentDate) { TrainingProgramEditViewModel viewModel = new TrainingProgramEditViewModel { TrainingProgram = trainingProgram }; return(View(viewModel)); } return(Ok("You are not allowed to edit past training programs. Please use the browser's back button to continue.")); }
// GET: TrainingPrograms/Edit/5 public ActionResult Edit(int id) { TrainingProgram program = GetProgramById(id); if (program == null) { return(NotFound()); } TrainingProgramEditViewModel viewModel = new TrainingProgramEditViewModel { TrainingProgram = program }; return(View(viewModel)); }