public ActionResult Create(ExerciseCreateViewModel viewModel) { try { using (SqlConnection conn = Connection) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = @"INSERT INTO Exercise (ExerciseName, ExerciseLanguage) VALUES (@exerciseName, @exerciseLanguage)"; cmd.Parameters.Add(new SqlParameter("@exerciseName", viewModel.Exercise.ExerciseName)); cmd.Parameters.Add(new SqlParameter("@exerciseLanguage", viewModel.Exercise.ExerciseLanguage)); cmd.ExecuteNonQuery(); return(RedirectToAction(nameof(Index))); } } } catch { return(View()); } }
// GET: Exercise/Create public ActionResult Create() { ExerciseCreateViewModel viewModel = new ExerciseCreateViewModel(); return(View(viewModel)); }
// GET: Student/Create public ActionResult Create() { var viewModel = new ExerciseCreateViewModel( _config.GetConnectionString("DefaultConnection")); return(View(viewModel)); }
public async Task <ActionResult> Create(ExerciseCreateViewModel model) { string sql = $@"INSERT INTO Exercise (Name, Language) VALUES ( '{model.Exercise.Name}', '{model.Exercise.Language}' );"; using (IDbConnection conn = Connection) { await conn.ExecuteAsync(sql); return(RedirectToAction(nameof(Index))); } }
// GET: Exercises/Create public ActionResult Create() { var model = new ExerciseCreateViewModel(_config); return(View(model)); }