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