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); }