public List <Vraag> getVragen(int choice) { List <Vraag> returnlist = new List <Vraag>(); List <List <string> > returnstatement = new DBConnection().Send("SELECT * FROM projectcdb.vraag WHERE `WachtrijID` = '" + WachtrijID + "' and `isFAQ` = 0 and IsinProgress = '" + choice + "' and (AndwoordText is null or AndwoordText = '')"); foreach (List <string> returnstatement2 in returnstatement) { Vraag v = new Vraag(); v.VraagID = Convert.ToInt32(returnstatement2[0]); if (returnstatement2[1] != "") { v.UserID = Convert.ToInt32(returnstatement2[1]); } if (returnstatement2[2] != "") { v.VakID = Convert.ToInt32(returnstatement2[2]); } if (returnstatement2[3] != "") { v.VraagText = returnstatement2[3]; } if (returnstatement2[4] != "") { v.AndwoordText = returnstatement2[4]; } if (returnstatement2[5] != "") { if (returnstatement2[5] == "0") { v.IsFAQ = false; } else { v.IsFAQ = true; } } if (returnstatement2[6] != "") { v.DateAdded = Convert.ToDateTime(returnstatement2[6]); } if (returnstatement2[7] != "") { v.EndDate = Convert.ToDateTime(returnstatement2[7]); } if (returnstatement2[8] != "") { v.Locatie = returnstatement2[8]; } returnlist.Add(v); } return(returnlist); }
public static List <Vraag> SelectAll() { //geef vraagID mee List <Vraag> returnlist = new List <Vraag>(); List <List <string> > returnstatement = new DBConnection().Send("SELECT * FROM projectcdb.vraag;"); foreach (List <string> returnstatement2 in returnstatement) { Vraag v = new Vraag(); v.VraagID = Convert.ToInt32(returnstatement2[0]); if (returnstatement2[1] != "") { v.UserID = Convert.ToInt32(returnstatement2[1]); } if (returnstatement2[2] != "") { v.VakID = Convert.ToInt32(returnstatement2[2]); } if (returnstatement2[3] != "") { v.VraagText = returnstatement2[3]; } if (returnstatement2[4] != "") { v.AndwoordText = returnstatement2[4]; } if (returnstatement2[5] != "") { if (returnstatement2[5] == "0") { v.IsFAQ = false; } else { v.IsFAQ = true; } } if (returnstatement2[6] != "") { v.DateAdded = Convert.ToDateTime(returnstatement2[6]); } if (returnstatement2[7] != "") { v.EndDate = Convert.ToDateTime(returnstatement2[7]); } if (returnstatement2[7] != "") { v.Locatie = returnstatement2[7]; } if (returnstatement2[8] != "") { v.WachtrijID = Convert.ToInt32(returnstatement2[8]); } if (returnstatement2[9] != "") { if (returnstatement2[9] == "0") { v.isInProgress = false; } else { v.isInProgress = true; } } returnlist.Add(v); } return(returnlist); }