public static void CriarMotorista(CriarMotoristaViewModel model)
{
string conexao = @"Data Source=tcp:testeaplicativo.database.windows.net,1433;Initial Catalog=TesteAplicativoBd;User [email protected];Password=087615Baldin;";
using (SqlConnection conn = new SqlConnection(conexao))
{
string comando = $"INSERT INTO Motoristas (Nome,DataNascimento,CPF,ModeloCarro,Sexo)" +
$"VALUES('{model.Nome}','{model.DataNascimento.ToString("yyyy-MM-dd")}','{model.CPF}','{model.ModeloCarro}','{model.Sexo}')";
using (SqlCommand cmd = new SqlCommand(comando, conn))
{
conn.Open();
var teste = cmd.ExecuteScalar();
}
}
}
public IActionResult Criar(CriarMotoristaViewModel viewModel)
{
MotoristaData.CriarMotorista(viewModel);
return(Redirect("Index"));
}
