public List <QuoteDM> Read(SqlParameter[] parameters, string statement)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(statement, connection))
{
command.CommandType = CommandType.StoredProcedure;
if (parameters != null)
{
command.Parameters.AddRange(parameters);
}
connection.Open();
SqlDataReader data = command.ExecuteReader();
List <QuoteDM> quotes = new List <QuoteDM>();
while (data.Read())
{
QuoteDM quote = new QuoteDM();
quote.QuoteId = data["QuoteId"].ToString();
quote.Phrase = data["Phrase"].ToString();
quote.Author = data["Author"].ToString();
quote.Category = data["Category"].ToString();
quote.Rating = data["Rating"].ToString();
quote.NumRatings = data["NumRatings"].ToString();
quote.RatingScore = data["RatingScore"].ToString();
quotes.Add(quote);
}
return(quotes);
}
}
}
public void CreateQuote(QuoteDM quote)
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@Phrase", quote.Phrase)
, new SqlParameter("@Author", quote.Author)
, new SqlParameter("@Category", quote.Category)
, new SqlParameter("@Rating", quote.Rating)
, new SqlParameter("@NumRatings", quote.NumRatings)
, new SqlParameter("@RatingScore", quote.RatingScore)
};
dataWriter.Write(parameters, "CreateQuote");
logs.LogError("Event", "A quote has been created", "Class:QuoteDAO, Method: CreateQuote");
}
