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