private static Quote ParseLine(string line)
{
string[] values = line.Split(',');
string title = values[0];
Console.WriteLine("title: " + title);
var quote = new Quote { Title = title };
var body = values[1];
Console.WriteLine("body: " + body);
quote.Body = body;
return quote;
}
private static void SaveToDatabase(Quote quote)
{
var connectionString = GetConnectionString();
// TODOx: insert into database if doesn't exist already ie title not there
using (var connection = new SqlConnection(connectionString))
{
using (var cmd = new SqlCommand("INSERT INTO Quotes (Title, Text) VALUES (@Title, @Quote)", connection))
{
cmd.Parameters.AddWithValue("@Title", quote.Title);
cmd.Parameters.AddWithValue("@Quote", quote.Body);
connection.Open();
cmd.ExecuteNonQuery();
}
}
}