public static Poll[] GetAnswers(Guid SoldatID, SQLInterface SI)
{
List <Poll> PP = new List <Poll>();
string Frage, Antwort;
Guid id;
Guid AntwortID;
SQLRow[] Answers = SI.ExecReader(@"
SELECT
Fragen.FragenID,Fragen.Frage,SoldatAntwort.AntwortID,
SoldatAntwort.TextAntwort
FROM
Fragen
LEFT JOIN
SoldatAntwort ON SoldatAntwort.FragenID=Fragen.FragenID
WHERE
SoldatAntwort.SoldatID=?
ORDER BY Fragen.Sort ASC", SoldatID);
for (int i = 0; i < Answers.Length; i++)
{
AntwortID = Guid.Empty;
SQLRow Answer = Answers[i];
Frage = (string)Answer["Frage"];
id = (Guid)Answer["FragenID"];
int curr = IndexOfPoll(PP, id);
if (Answer["TextAntwort"] == null)
{
AntwortID = (Guid)Answer["AntwortID"];
Antwort = (string)(SI.ExecReader("SELECT MöglicheAntwort AS Antwort FROM Antworten WHERE AntwortID=?", (Guid)Answer["AntwortID"])[0]["Antwort"]);
}
else
{
Antwort = (string)Answer["TextAntwort"];
}
//ignore empty answers
if (!string.IsNullOrEmpty(Antwort))
{
if (curr >= 0)
{
PP[curr].Antwort += "\r\n" + Antwort;
}
else
{
Poll P = new Poll();
P.Frage = Frage;
P.Antwort = Antwort;
P.FragenID = id;
P.AntwortID = AntwortID;
PP.Add(P);
}
}
}
return(PP.ToArray());
}
public static Soldat GetSoldat(Guid SoldatID, SQLInterface SI)
{
SQLRow R = SI.ExecReader(@"
SELECT
Vorname,SVNummer,Nachname,SoldatID,AnlassID
FROM
Soldat
WHERE
Soldat.SoldatID=?", SoldatID)[0];
Soldat S = new Soldat();
S.Anlass = (Guid)R["AnlassID"];
S.Vorname = (string)R["Vorname"];
S.Nachname = (string)R["Nachname"];
S.ID = (Guid)R["SoldatID"];
S.SVNummer = (string)R["SVNummer"];
return(S);
}
