internal static void CriarCorrida(CriarCorridaViewModel 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 Corridas (IdMotorista,IdPassageiro,DataCorrida,Valor)" +
$"VALUES('{model.IdMotorista}','{model.IdPassageiro}','{model.DataCorrida.ToString("yyyy-MM-dd")}',{model.Valor.ToString().Replace(",",".")})";
using (SqlCommand cmd = new SqlCommand(comando, conn))
{
conn.Open();
var teste = cmd.ExecuteScalar();
}
}
}
public IActionResult Criar(CriarCorridaViewModel model)
{
model.Valor /= 10;
CorridaData.CriarCorrida(model);
return(Redirect("Index"));
}