private static void PrepareCommand(OracleCommand command, User_review Review)
{
command.BindByName = true;
command.Parameters.AddWithValue(":title", Review.Title);
command.Parameters.AddWithValue(":score", Review.Score);
command.Parameters.AddWithValue(":user_user_id", Review.UserId);
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(User_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 <User_review> Read(OracleDataReader reader)
{
List <User_review> User_reviews = new List <User_review>();
while (reader.Read())
{
int i = -1;
User_review User_review = new User_review();
User_review.Title = reader.GetString(++i);
User_review.Score = reader.GetInt32(++i);
User_review.UserId = reader.GetInt32(++i);
User_review.GameId = reader.GetInt32(++i);
User_review.Date = reader.GetDateTime(++i);
User_review.Order_of_review = reader.GetInt32(++i);
User_reviews.Add(User_review);
}
return(User_reviews);
}
private void Button1_Click(object sender, EventArgs e)
{
bool hasTitle = false;
if (!(string.IsNullOrEmpty(textBox1.Text) || string.IsNullOrWhiteSpace(textBox1.Text)))
{
hasTitle = true;
}
int score = comboBox1.SelectedIndex + 1;
int order = comboBox2.SelectedIndex + 1;
int rows = 0;
if (hasTitle && order > 0)
{
UserReviewTable userReviewTable = new UserReviewTable();
User_review userReview = new User_review(textBox1.Text, score, userId, gameId, DateTime.Now, order);
try
{
rows = userReviewTable.insertNew(userReview);
}
catch
{
MessageBox.Show("Something went wrong");
}
}
else
{
MessageBox.Show("Title or order is empty");
}
if (rows > 0)
{
MessageBox.Show("Review successfully submitted");
}
}
