internal static bool ApproveRequestQuote(int quoteId, ulong approvedBy, ulong approvedIn)
{
(MySqlDataReader dr, MySqlConnection conn)reader =
DatabaseActivity.ExecuteReader("SELECT * FROM requested_quotes WHERE requestQuoteId = " + quoteId +
" LIMIT 1");
var quote = new RequestQuote();
while (reader.dr.Read())
{
quote.RequestId = reader.dr.GetInt32("requestQuoteId");
quote.CreatedBy = reader.dr.GetUInt64("requestedBy");
quote.QuoteText = reader.dr.GetString("quoteText");
quote.QCreatedTimestamp = reader.dr.GetDateTime("dateCreated");
quote.CreatedIn = reader.dr.GetUInt64("requestedIn");
}
reader.dr.Close();
reader.conn.Close();
var added = Quote.AddQuote(quote.QuoteText, quote.CreatedBy, quote.CreatedIn, approvedBy, approvedIn,
quote.QCreatedTimestamp);
RemoveRequestQuote(quote.RequestId);
return(added);
}
internal static List <RequestQuote> LoadAll()
{
var requests = new List <RequestQuote>();
(MySqlDataReader dr, MySqlConnection conn)reader =
DatabaseActivity.ExecuteReader("SELECT * FROM requested_quotes;");
while (reader.dr.Read())
{
var q = new RequestQuote
{
RequestId = reader.dr.GetInt32("requestQuoteId"),
CreatedBy = reader.dr.GetUInt64("requestedBy"),
QuoteText = reader.dr.GetString("quoteText"),
QCreatedTimestamp = reader.dr.GetDateTime("dateCreated"),
CreatedIn = reader.dr.GetUInt64("requestedIn")
};
requests.Add(q);
}
reader.dr.Close();
reader.conn.Close();
return(requests);
}
