public void Insert(PirateAnimalModel pirateAnimal)
{
SqlConnection connection = new SqlConnection(GetConnectionString());
try
{
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "PirateAnimals_Insert";
command.Parameters.AddWithValue("@Name", pirateAnimal.name);
command.Parameters.AddWithValue("@AnimalType", pirateAnimal.animalType);
command.Parameters.AddWithValue("@Age", pirateAnimal.age);
command.Parameters.AddWithValue("@SpeaksEnglish", pirateAnimal.speaksEnglish);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
connection.Close();
}
}
public IActionResult Insert(PirateAnimalModel pirateAnimal)
{
if (!ModelState.IsValid)
{
return(View("Create", pirateAnimal));
}
//Insert pirate yarrrr
pirateAnimalRepository.Insert(pirateAnimal);
return(RedirectToAction("Index", "PirateAnimal"));
}
public IActionResult Create()
{
PirateAnimalModel pirateAnimal = new PirateAnimalModel();
IConfigurationBuilder builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json");
var configuration = builder.Build();
pirateAnimal.name = configuration["DefaultPirateAnimalName"];
pirateAnimal.animalType = configuration["DefaultAnimalSpecies"];
return(View(pirateAnimal));
}
