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