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