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