// Methodes public bool AddReview(Review review) { if (DatabaseHandler.AddReview(review)) return true; else return false; }
public bool DeleteReview(Review review) { if (DatabaseHandler.DeleteReview(review.ReviewID)) return true; else return false; }
public bool AddReview(Review review) { if (reviewhandler.AddReview(review)) { return true; } return false; }
public Form_Review(Review review) { InitializeComponent(); cbox_Rating.SelectedIndex = review.Rating - 1; tbox_ReviewContent.Text = review.Content; cbox_Rating.Enabled = false; tbox_ReviewContent.Enabled = false; btn_SendReview.Visible = false; lbl_ReviewUserInfo.Text = string.Format("Review van {0} op {1}", review.Client.Name, review.Targetuser.Name); lbl_ReviewUserInfo.Visible = true; }
// Constructor public Form_QuestionDetails(Question questiontoshow, Client currentuser, Review reviewtoshow) { InitializeComponent(); this.currentuser = currentuser; currentreview = reviewtoshow; this.currentreview = reviewtoshow; clienthandler = new ClientHandler(this.currentuser as Client); currentquestion = questiontoshow; RefreshInterface(); this.ActiveControl = lbl_Info1; isChanged = false; }
private void btn_SendReview_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(cbox_Rating.SelectedText)) { Review newReview = new Review(DateTime.Now, currentquestion.Client, currentquestion.Volunteer, Convert.ToInt32(cbox_Rating.SelectedItem), tbox_ReviewContent.Text); DatabaseHandler.AddReview(newReview); MessageBox.Show("Review verzonden"); this.Close(); } else { MessageBox.Show("U moet een waardering opgegeven hebben"); } }
public bool DeleteReview(Review review) { return reviewhandler.DeleteReview(review); }
public static bool AddReview(Review newreview) { try { Connect(); cmd = new OracleCommand(); cmd.Connection = con; cmd.CommandText = "Insert into TREVIEW(DATUM, VOLUNTEER, CLIENT, RATING, TEKST) VALUES (:NewDATUM, :NewVOLUNTEER, :NewCLIENT, :NewRATING, :NewTEKST)"; cmd.Parameters.Add("NewDATUM", OracleDbType.Date).Value = newreview.Date.ToString("dd-MMM-yy"); cmd.Parameters.Add("NewVOLUNTEER", OracleDbType.Int32).Value = newreview.Targetuser.UserID; cmd.Parameters.Add("NewCLIENT", OracleDbType.Int32).Value = newreview.Client.UserID; cmd.Parameters.Add("NewRATING", OracleDbType.Int32).Value = newreview.Rating; cmd.Parameters.Add("NewTEKST", OracleDbType.Varchar2).Value = newreview.Content; cmd.ExecuteNonQuery(); return true; } catch (Exception ex) { MessageBox.Show(ex.Message); return false; } finally { Disconnect(); } }