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