public List <QuoteDataCsv> GetQuoteCsv() { List <QuoteDataCsv> listReponse = new List <QuoteDataCsv>(); try { using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("SPQuoteGetCsv", con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { QuoteDataCsv quote = new QuoteDataCsv(); quote.date = Convert.ToDateTime(reader["DTQuote"]); quote.symbol = reader["CDQuote"].ToString(); quote.value = Convert.ToDouble(reader["VLQuote"]); listReponse.Add(quote); } } } } } catch (Exception ex) { } return(listReponse); }
public void AddQuoteCsv(QuoteDataCsv values) { try { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SPQuoteAddCsv", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CDQuote", values.symbol); cmd.Parameters.AddWithValue("@VLQuote", values.value); cmd.Parameters.AddWithValue("@DTQuote", values.date); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } catch (Exception ex) { } }
void CarregaArquivoCsv(string myLocalFilePath) { int cont = 0; using (var reader = new StreamReader(myLocalFilePath)) { string data = null; string openValue = null; List <string> listB = new List <string>(); while (!reader.EndOfStream) { var line = reader.ReadLine(); if (cont > 0) { var values = line.Split(','); if (!string.IsNullOrEmpty(values[0].ToString()) && values[0].ToString() != "null") { data = values[0].ToString(); } if (!string.IsNullOrEmpty(values[1].ToString()) && values[1].ToString() != "null") { openValue = values[1].ToString().Replace(".", ",");; } if (!string.IsNullOrEmpty(data) && !string.IsNullOrEmpty(openValue)) { QuoteDataCsv quote = new QuoteDataCsv(); quote.symbol = "PETR4"; quote.date = Convert.ToDateTime(data); quote.value = Convert.ToDouble(openValue); _quote.AddQuoteCsv(quote); } } cont++; } } }