/// <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) { }