public List <ReviewModel2> getReview2ForCompany(string name) { List <ReviewModel2> RList = new List <ReviewModel2>(); String query = "SELECT * from reviews2 where company_name='" + name + "';"; try { if (this.openConnection()) { MySqlCommand command = new MySqlCommand(query, this.conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ReviewModel2 R1 = new ReviewModel2(reader.GetInt32("review_id"), reader.GetString("review"), reader.GetString("user"), reader.GetInt32("rating"), reader.GetInt64("timestamp"), reader.GetString("company_name")); RList.Add(R1); } this.closeConnection(); return(RList); } else { return(RList); } } catch (Exception err) { System.Diagnostics.Debug.WriteLine(err.Message); return(RList); } }
public void addReview2(ReviewModel2 review) { int timestamp = (Int32)(DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds; string query = string.Format("INSERT INTO reviews2 (review, user, rating, timestamp, company_name) values ('{0}', '{1}', {2}, '{3}', '{4}')", review.Review, review.User, review.Rating, timestamp, review.CompanyName); if (this.openConnection()) { MySqlCommand command = new MySqlCommand(query, this.conn); command.ExecuteNonQuery(); this.closeConnection(); } }