public void Insert(TrickOrTreaterModel treater)
{
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
using (SqlCommand command = new SqlCommand("Treaters_Insert", connection))
{
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.AddWithValue("@Name", treater.Name);
command.Parameters.AddWithValue("@FavoriteCandy", treater.FavoriteCandy);
command.Parameters.AddWithValue("@Costume", treater.Costume);
command.ExecuteNonQuery();
}
}
}
public IActionResult Index(TrickOrTreaterModel model)
{
new TreaterDBRepository().Insert(model);
return(RedirectToAction("Index"));
}
