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