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