public static int ActualizarCotizarPorId(Cotizar vehiculo)
{
int filasAfectadas = 0;
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
SqlCommand sqlCommand = new SqlCommand(null, sqlConnection);
sqlCommand.CommandText = "UPDATE Cotizar SET RutUsuario = @rut, IdVehiculo = @auto WHERE IdCotizar = @IdCotizar";
sqlCommand.Parameters.AddWithValue("@rut", vehiculo.RutUsuario);
sqlCommand.Parameters.AddWithValue("@auto", vehiculo.IdVehiculo);
sqlCommand.Parameters.AddWithValue("@IdCotizar", vehiculo.IdCotizar);
try
{
sqlConnection.Open();
filasAfectadas = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(filasAfectadas);
}
}
public static int AgregarCotizar(Cotizar vehiculo)
{
int filasAfectadas = 0;
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
SqlCommand sqlCommand = new SqlCommand(null, sqlConnection);
sqlCommand.CommandText = "INSERT INTO Cotizar (RutUsuario,IdVehiculo) values (@rut,@auto)";
sqlCommand.Parameters.AddWithValue("@rut", vehiculo.RutUsuario);
sqlCommand.Parameters.AddWithValue("@auto", vehiculo.IdVehiculo);
try
{
sqlConnection.Open();
filasAfectadas = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(filasAfectadas);
}
}
private static List <Cotizar> ListarCotizar(DataTable dataTable)
{
vehiculos = new List <Cotizar>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
Cotizar vehiculo = new Cotizar();
vehiculo.IdCotizar = int.Parse(dataTable.Rows[i]["IdCotizar"].ToString());
vehiculo.RutUsuario = dataTable.Rows[i]["RutUsuario"].ToString();
vehiculo.IdVehiculo = int.Parse(dataTable.Rows[i]["IdVehiculo"].ToString());
vehiculos.Add(vehiculo);
}
return(vehiculos);
}
private static Cotizar CreacionCotizar(DataTable dataTable)
{
if (dataTable != null && dataTable.Rows.Count > 0)
{
Cotizar vehiculo = new Cotizar();
vehiculo.IdCotizar = int.Parse(dataTable.Rows[0]["IdCotizar"].ToString());
vehiculo.RutUsuario = dataTable.Rows[0]["RutUsuario"].ToString();
vehiculo.IdVehiculo = int.Parse(dataTable.Rows[0]["IdVehiculo"].ToString());
return(vehiculo);
}
else
{
return(null);
}
}
public async Task <Cotizar> GetTasa(HttpClient httpClient)
{
string requestEndpoint = $"BRL/{Parametro.claveApi}";
Cotizar cotizar = null;
HttpResponseMessage response = await httpClient.GetAsync(requestEndpoint);
if (response.IsSuccessStatusCode)
{
ResultJson resultado = await response.Content.ReadAsAsync <ResultJson>();
cotizar = new Cotizar {
Moneda = Parametro.monedaReal, Precio = (Math.Round(resultado.Result.Value, 1))
};
}
return(cotizar);
}
