private static void PrepareCommand(OracleCommand command, Reviewer_review Review) { command.BindByName = true; command.Parameters.AddWithValue(":title", Review.Title); command.Parameters.AddWithValue(":text_of_review", Review.Text_of_review); command.Parameters.AddWithValue(":score", Review.Score); command.Parameters.AddWithValue(":reviewer_reviewer_id", Review.ReviewerId); command.Parameters.AddWithValue(":game_game_id", Review.GameId); command.Parameters.AddWithValue(":datee", Review.Date); command.Parameters.AddWithValue(":order_of_review", Review.Order_of_review); }
// Methods public int insertNew(Reviewer_review review) { Database db = new Database(); db.Connect(); OracleCommand command = db.CreateCommand(SQL_INSERT_NEW); PrepareCommand(command, review); int ret = db.ExecuteNonQuery(command); db.Close(); return(ret); }
private static List <Reviewer_review> Read(OracleDataReader reader) { List <Reviewer_review> Reviewer_reviews = new List <Reviewer_review>(); while (reader.Read()) { int i = -1; Reviewer_review reviewer_review = new Reviewer_review(); reviewer_review.Title = reader.GetString(++i); reviewer_review.Text_of_review = reader.GetString(++i); reviewer_review.Score = reader.GetInt32(++i); reviewer_review.ReviewerId = reader.GetInt32(++i); reviewer_review.GameId = reader.GetInt32(++i); reviewer_review.Date = reader.GetDateTime(++i); reviewer_review.Order_of_review = reader.GetInt32(++i); Reviewer_reviews.Add(reviewer_review); } return(Reviewer_reviews); }