public ActionResult Inserir(CarroUsuario usuario)
{
try
{
CadastrarUsuario(usuario);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
private void CadastrarUsuario(CarroUsuario usuario)
{
var Conexao = new SqlConnection
{
ConnectionString = "Server=thanos-web.database.windows.net;user id=andrelivee;pwd=@andre123;Database=Carros"
};
Conexao.Open();
using (SqlCommand command = Conexao.CreateCommand())
{
command.CommandText = "INSERT INTO cliente (nome, email) VALUES(@param1,@param2)";
command.Parameters.AddWithValue("@param1", usuario.nome);
command.Parameters.AddWithValue("@param2", usuario.email);
command.ExecuteNonQuery();
}
Conexao.Close();
}
