/// <summary>
/// past de geselecteerde hulpvraag, review of reactie aan, aan de hand van het tekstvak
/// </summary>
private void btnEdit_Click(object sender, EventArgs e)
{
selectedRequest = lbHelpRequest.SelectedItem as HelpRequest;
if (selectedRequest != null)
{
if (selectedRequest != null)
{
DatabaseHandler.EditHelpRequest(selectedRequest.Id, tbEdit.Text);
selectedRequest.Problem = tbEdit.Text;
}
}
selectedReview = lbReview.SelectedItem as Review;
if (selectedReview != null)
{
if (selectedReview != null)
{
DatabaseHandler.EditReview(selectedReview.Id,tbEdit.Text);
selectedReview.Text = tbEdit.Text;
}
}
selectedAnswer = lbAnswer.SelectedItem as Answer;
if (selectedAnswer != null)
{
if (selectedAnswer != null)
{
DatabaseHandler.EditAnswer(selectedAnswer.Id,tbEdit.Text);
selectedAnswer.Text = tbEdit.Text;
}
}
UpdateLists();
}
/// <summary>
/// Verwijderd de geselecteerde hulpvraag, review of reactie
/// </summary>
private void btnRemove_Click(object sender, EventArgs e)
{
selectedRequest = lbHelpRequest.SelectedItem as HelpRequest;
if (selectedRequest != null)
{
if (selectedRequest != null)
{
DatabaseHandler.DelHelpRequest(selectedRequest.Id);
HelpHandler.DelHelpRequest(selectedRequest);
}
}
selectedReview = lbReview.SelectedItem as Review;
if (selectedReview != null)
{
if (selectedReview != null)
{
DatabaseHandler.DelReview(selectedReview.Id);
HelpHandler.DelReview(selectedReview);
}
}
selectedAnswer = lbAnswer.SelectedItem as Answer;
if (selectedAnswer != null)
{
if (selectedAnswer != null)
{
DatabaseHandler.DelAnswer(selectedAnswer.Id);
HelpHandler.DelAnswer(selectedAnswer);
}
}
UpdateLists();
}
/// <summary>
/// Toont de geselecteerde hulpvraag in het tekstvak
/// </summary>
private void lbHelpRequest_SelectedIndexChanged(object sender, EventArgs e)
{
if (lbHelpRequest.SelectedIndex != -1)
{
selectedRequest = lbHelpRequest.SelectedItem as HelpRequest;
if (selectedRequest != null)
{
tbEdit.Text = selectedRequest.ToString();
}
}
}
public static void GetHulpVraag()
{
Connect();
ReadData("SELECT * FROM HULPVRAAG");
try
{
while (dr.Read())
{
int hulpvraagID;
string tekstprobleem;
DateTime aanmaakdatum;
DateTime begindatum;
string duur;
string urgentie;
hulpvraagID = Convert.ToInt32(dr.GetValue(0));
tekstprobleem = dr.GetString(1);
aanmaakdatum = dr.GetDateTime(2);
begindatum = dr.GetDateTime(3);
duur = dr.GetString(4);
urgentie = dr.GetString(5);
HelpRequest helpRequest = new HelpRequest(hulpvraagID, tekstprobleem, aanmaakdatum, begindatum, duur, urgentie);
HelpHandler.AddHelpRequest(helpRequest);
}
}
catch (InvalidCastException ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
Disconnect();
}
}
public static HelpRequest GetAcceptedHelpRequest(int id)
{
Connect();
ReadData("SELECT * FROM HULPVRAAG WHERE ACCEPTER = " + id);
HelpRequest accepted = null;
try
{
while (dr.Read())
{
int helpId;
string problem;
DateTime dateOfCreation;
DateTime beginDate;
string duration;
string urgent;
helpId = Convert.ToInt32(dr["HULPVRAAGID"]);
problem = dr["TEKSTPROBLEEM"].ToString();
dateOfCreation = Convert.ToDateTime(dr["AANMAAKDATUM"]);
beginDate = Convert.ToDateTime(dr["BEGINDATUM"]);
duration = dr["DUUR"].ToString();
urgent = dr["URGENT"].ToString();
accepted = new HelpRequest(helpId, problem, dateOfCreation, beginDate, duration, urgent);
}
}
catch (InvalidCastException ex)
{
MessageBox.Show(ex.ToString());
return null;
}
finally
{
Disconnect();
}
return accepted;
}
public static void DelHelpRequest(HelpRequest helpRequest)
{
helpRequests.Remove(helpRequest);
}
public static void AddHelpRequest(HelpRequest helpRequest)
{
helpRequests.Add(helpRequest);
}
public static void EditHelpRequest(HelpRequest helpRequest)
{
}
