private void CreatePersonen(List<String> TypListToSelect,
DocumentPrintOut FileToWriteTo)
{
String TypSelectPart = Data.DbServer3.WordUp.Typen.TypSelectionString(TypListToSelect, "PersonenTypID");
String PersonenSelectStatement = "Select * from PersonenOrganisationenOrte where ID in "
+ "(Select PersonenID from PersonenZuWordUpID where WordUpID = '"
+ Basics.Instance.WordUpID + "') and " + TypSelectPart +
" order by FamilienName";
DataTable PersonenTable =
WordUpWCFAccess.GetCommonDataSet(PersonenSelectStatement).Tables["PersonenOrganisationenOrte"];
foreach (DataRow PersonenRow in PersonenTable.Rows)
{
//List<String> Elements = new List<string> ();
//Elements.Add (PersonenRow ["NameID"].ToString ());
//Elements.Add (PersonenRow ["Beschreibung"].ToString ());
//Elements.Add (PersonenRow ["eMail"].ToString ());
//Elements.Add (PersonenRow ["Telefon"].ToString ());
FileToWriteTo.WriteData(PersonenRow, DocumentPrintOut.ElementType.FullPersonenDaten);
}
}
private void ProcessOneProjectToPrintout(DocumentPrintOut Writer, String ProjectID,
DocumentPrintOut.ElementType TypeOfProjectPrintout,
bool WithOrWithoutPlakate = true, bool WithOrWithoutActivities = true,
bool WithOrWithoutTermine = false, bool WithOrWithoutProjektUebersicht = false)
{
DataSet ProjektGesamtschau = DataWrapper.Instance.GetAllDataBelongingToOneProject
(ProjectID, WithOrWithoutPlakate, WithOrWithoutActivities, WithOrWithoutTermine,
WithOrWithoutProjektUebersicht);
Writer.WithOrWithoutPlakate = WithOrWithoutPlakate;
Writer.WriteData(ProjektGesamtschau, TypeOfProjectPrintout);
}
private void CreatePersonenTermineAlsAttachments(List<String> TypListToSelect,
String FileName)
{
String TypSelectPart = Data.DbServer3.WordUp.Typen.TypSelectionString(TypListToSelect, "PersonenTypID");
String PersonenSelectStatement = "Select * from PersonenOrganisationenOrte where ID in "
+ "(Select PersonenID from PersonenZuWordUpID where WordUpID = '"
+ Basics.Instance.WordUpID + "') and " + TypSelectPart +
" order by FamilienName";
DataTable PersonenTable =
WordUpWCFAccess.GetCommonDataSet(PersonenSelectStatement).Tables["PersonenOrganisationenOrte"];
List<System.Guid> AllPersonen = GetAllPersonenIDs(TypListToSelect);
foreach (DataRow PersonenRow in PersonenTable.Rows)
{
DataTable TermineProPerson = WordUpWCFAccess.GetCommonDataSet
("Select * from TermineZuFullPersonen where PersonenID = '"
+ PersonenRow["ID"].ToString() + "' and WordUpRootID = '" + Basics.Instance.WordUpID
+ "' order by Von").Tables["TermineZuFullPersonen"];
if (TermineProPerson.Rows.Count == 0)
continue;
String PersonenFileName = FileName.Replace
(".txt", "_eMailTo_" + PersonenRow["eMail"].ToString().Replace(" ", "_") + ".txt");
DocumentPrintOut PersonenWriter = new DocumentPrintOut(PersonenFileName, false);
PersonenWriter.WriteLine(DocumentPrintOut.ElementType.Heading1,
"Terminübersicht mit Stand " + DateTime.Now.ToString("dd. MMM yyyy") + " für:");
PersonenWriter.InsertEmptyLine();
PersonenWriter.WriteData(PersonenRow, DocumentPrintOut.ElementType.FullPersonenDaten);
PersonenWriter.InsertEmptyLine();
foreach (DataRow TerminRow in TermineProPerson.Rows)
{
PersonenWriter.WriteData(TerminRow, DocumentPrintOut.ElementType.SimpleTerminDaten);
CreateParticipantsList(PersonenWriter, TerminRow["TermineID"].ToString(), false, AllPersonen);
}
PersonenWriter.InsertEmptyLine();
PersonenWriter.WriteLine(DocumentPrintOut.ElementType.Heading1, "Kontaktdaten aller Beteiligten");
PersonenWriter.InsertEmptyLine();
CreatePersonen(TypListToSelect, PersonenWriter);
PersonenWriter.Close();
}
}
