public string FamilyMembers(int familyid) { try { var q = from p in Db.People where p.FamilyId == familyid select p; var w = new APIWriter(); w.Start("Family"); w.Attr("Id", familyid); foreach (var m in q) { w.Start("Member"); w.Add("peopleid", m.PeopleId); w.Add("first", m.FirstName); w.Add("last", m.LastName); w.Add("goesby", m.NickName); w.Add("birthday", m.BDate); w.Add("position", m.PositionInFamilyId); w.Add("marital", m.MaritalStatusId); w.Add("suffix", m.SuffixCode); w.Add("title", m.TitleCode); w.End(); } w.End(); return(w.ToString()); } catch (Exception ex) { return(ex.Message); } }
public string ExtraValues(int orgid, string fields) { try { var a = (fields ?? "").Split(','); var nofields = !fields.HasValue(); var q = from v in Db.OrganizationExtras where nofields || a.Contains(v.Field) where v.OrganizationId == orgid select v; var w = new APIWriter(); w.Start("ExtraOrgValues"); w.Attr("Id", orgid); foreach (var v in q) { w.Add(v.Field, v.Data); } w.End(); return(w.ToString()); } catch (Exception ex) { return(ex.Message); } }
public string ExtraValues(int peopleid, string fields) { try { var a = (fields ?? "").Split(','); var nofields = !fields.HasValue(); var q = from v in Db.PeopleExtras where nofields || a.Contains(v.Field) where v.PeopleId == peopleid select v; var w = new APIWriter(); w.Start("ExtraValues"); w.Attr("Id", peopleid); foreach (var v in q) { w.Add(v.Field, v.StrValue ?? v.Data ?? v.DateValue.FormatDate() ?? v.IntValue.ToString()); } w.End(); return(w.ToString()); } catch (Exception ex) { return(ex.Message); } }
// public string OrgMembersPython(int orgid) // { // var list = OrgMembersData(orgid); // var script = Db.Content("API-OrgMembers"); // if (script == null) // { // script = new Content(); // script.Body = @" //from System import * //from System.Text import * // //class OrgMembers(object): // // def Run(self, m, w, q): // w.Start('OrgMembers') // for i in q: // w.Start('Member') // w.Attr('PeopleId', i.member.PeopleId) // w.Attr('Name', i.member.Person.Name) // w.Attr('PreferredName', i.member.Person.PreferredName) // w.Attr('LastName', i.member.Person.LastName) // w.Attr('Email', i.member.Person.EmailAddress) // w.Attr('Enrolled', i.member.EnrollmentDate) // w.Attr('MemberType', i.member.MemberType.Description) // for t in i.tags: // w.Add('Group', t) // w.End() // w.End() // return w.ToString() //"; // } // if (script == null) // return "<login error=\"no API-OrgMembers script\" />"; // var engine = Python.CreateEngine(); // var sc = engine.CreateScriptSourceFromString(script.Body); // try // { // var code = sc.Compile(); // var scope = engine.CreateScope(); // code.Execute(scope); // // dynamic LoginInfo = scope.GetVariable("OrgMembers"); // dynamic m = LoginInfo(); // var w = new APIWriter(); // return m.Run(this, w, list); // } // catch (Exception ex, // { // return $"<login error=\"API-OrgMembers script error: {ex.Message}\" />"; // } // } public string OrgMembers2(int orgid, string search) { search = search ?? ""; var nosearch = !search.HasValue(); var qm = from m in Db.OrganizationMembers where m.OrganizationId == orgid where nosearch || m.Person.Name2.StartsWith(search) select new { m.PeopleId, m.Person.Name, First = m.Person.PreferredName, Last = m.Person.LastName, m.Person.EmailAddress, m.EnrollmentDate, MemberType = m.MemberType.Description, IsLeaderType = (m.MemberType.AttendanceTypeId ?? 0) == CmsData.Codes.AttendTypeCode.Leader, }; var mt = from m in Db.OrgMemMemTags where m.OrganizationMember.OrganizationId == orgid where m.OrganizationMember.MemberTypeId != Codes.MemberTypeCode.InActive select new { m.OrganizationMember.PeopleId, m.MemberTag.Name }; var mtags = mt.ToList(); var w = new APIWriter(); w.Start("OrgMembers"); foreach (var m in qm.ToList()) { w.Start("Member"); w.Attr("PeopleId", m.PeopleId); w.Attr("Name", m.Name); w.Attr("PreferredName", m.First); w.Attr("LastName", m.Last); w.Attr("Email", m.EmailAddress); w.Attr("Enrolled", m.EnrollmentDate); w.Attr("MemberType", m.MemberType); if (m.IsLeaderType) { w.Attr("IsLeader", m.IsLeaderType); } var qt = from t in mtags where t.PeopleId == m.PeopleId select t.Name; foreach (var group in qt) { w.Add("Group", group); } w.End(); } w.End(); return(w.ToString()); }
private bool WriteDropdownOptions(bool optionsAdded, APIWriter w) { if (option != null && option.Count > 0 && !optionsAdded) foreach (var o in option) w.Add("option", o); optionsAdded = true; return optionsAdded; }
public override void WriteXml(APIWriter w) { if (list.Count == 0) return; w.Start(Type); foreach (var q in list) w.Add("Question", q.Question); w.End(); }
public override void WriteXml(APIWriter w) { if (list.Count == 0) return; w.Start(Type); w.Add("Label", Label); foreach (var g in list) g.WriteXml(w); w.End(); }
private static string WriteXmlFromReader(IDataReader rd) { var w = new APIWriter(); w.Start("SqlScriptXml"); while (rd.Read()) { w.Start("Row"); for (var i = 0; i < rd.FieldCount; i++) { var name = rd.GetName(i); var value = rd.GetValue(i); w.Add(name, value); } w.End(); } w.End(); return(w.ToString()); }
public string ExtraValues(int meetingid, string fields) { try { var a = (fields ?? "").Split(','); var nofields = !fields.HasValue(); var q = from v in Db.MeetingExtras where nofields || a.Contains(v.Field) where v.MeetingId == meetingid select v; var w = new APIWriter(); w.Start("ExtraMeetingValues"); w.Attr("Id", meetingid); foreach (var v in q) w.Add(v.Field, v.Data); w.End(); return w.ToString(); } catch (Exception ex) { return ex.Message; } }
public void WriteXml(XmlWriter writer) { var w = new APIWriter(writer); writer.WriteComment(DateTime.Now.ToString()); foreach (var pi in typeof(OnlineRegModel).GetProperties(BindingFlags.Public | BindingFlags.Instance) .Where(vv => vv.CanRead && vv.CanWrite)) { switch (pi.Name) { case "List": w.Start("List"); foreach (var i in _list) Util.Serialize(i, writer); w.End(); break; case "History": w.Start("History"); foreach (var i in History) w.Add("item", i); w.End(); break; case "password": break; case "testing": if (testing == true) w.Add(pi.Name, testing); break; case "FromMobile": if (FromMobile.HasValue()) w.Add(pi.Name, FromMobile); else if (MobileAppMenuController.Source.HasValue()) w.Add(pi.Name, MobileAppMenuController.Source); break; case "prospect": if (prospect) w.Add(pi.Name, prospect); break; default: w.Add(pi.Name, pi.GetValue(this, null)); break; } } }
private static string WriteXmlFromReader(IDataReader rd) { var w = new APIWriter(); w.Start("SqlScriptXml"); while (rd.Read()) { w.Start("Row"); for (var i = 0; i < rd.FieldCount; i++) { var name = rd.GetName(i); var value = rd.GetValue(i); w.Add(name, value); } w.End(); } w.End(); return w.ToString(); }
public string FamilyMembers(int familyid) { try { var q = from p in Db.People where p.FamilyId == familyid select p; var w = new APIWriter(); w.Start("Family"); w.Attr("Id", familyid); foreach (var m in q) { w.Start("Member"); w.Add("peopleid", m.PeopleId); w.Add("first", m.FirstName); w.Add("last", m.LastName); w.Add("goesby", m.NickName); w.Add("birthday", m.BDate); w.Add("position", m.PositionInFamilyId); w.Add("marital", m.MaritalStatusId); w.Add("suffix", m.SuffixCode); w.Add("title", m.TitleCode); w.End(); } w.End(); return w.ToString(); } catch (Exception ex) { return ex.Message; } }
public string ExtraValues(int peopleid, string fields) { try { var a = (fields ?? "").Split(','); var nofields = !fields.HasValue(); var q = from v in Db.PeopleExtras where nofields || a.Contains(v.Field) where v.PeopleId == peopleid select v; var w = new APIWriter(); w.Start("ExtraValues"); w.Attr("Id", peopleid); foreach (var v in q) w.Add(v.Field, v.StrValue ?? v.Data ?? v.DateValue.FormatDate() ?? v.IntValue.ToString()); w.End(); return w.ToString(); } catch (Exception ex) { return ex.Message; } }
public override void WriteXml(APIWriter w) { if (!Label.HasValue()) Label = "Request"; w.Add("AskRequest", Label); }
private bool WriteCheckboxChoices(bool checkoxesAdded, APIWriter w) { if (Checkbox != null && Checkbox.Count > 0 && !checkoxesAdded) foreach (var c in Checkbox) w.Add("Checkbox", c); checkoxesAdded = true; return checkoxesAdded; }
public void WriteXml(XmlWriter writer) { var optionsAdded = false; var checkoxesAdded = false; var w = new APIWriter(writer); foreach (PropertyInfo pi in typeof(OnlineRegPersonModel).GetProperties(BindingFlags.Public | BindingFlags.Instance) .Where(vv => vv.CanRead && vv.CanWrite)) { switch (pi.Name) { case "SpecialTest": WriteSpecialTest(w); break; case "FundItem": WriteFundItems(w); break; case "FamilyAttend": WriteFamilyAttend(w); break; case "ExtraQuestion": WriteExtraAnswers(w); break; case "Text": WriteText(w); break; case "YesNoQuestion": WriteYesNoChoices(w); break; case "option": optionsAdded = WriteDropdownOptions(optionsAdded, w); break; case "Checkbox": checkoxesAdded = WriteCheckboxChoices(checkoxesAdded, w); break; case "MenuItem": WriteMenuChoices(w); break; case "MissionTripGoerId": if (Parent.SupportMissionTrip) w.Add(pi.Name, MissionTripGoerId); break; case "IsFilled": if (IsFilled) w.Add(pi.Name, IsFilled); break; case "CreatingAccount": if (CreatingAccount) w.Add(pi.Name, CreatingAccount); break; case "MissionTripNoNoticeToGoer": if (MissionTripNoNoticeToGoer) w.Add(pi.Name, MissionTripNoNoticeToGoer); break; case "memberus": if (memberus) w.Add(pi.Name, memberus); break; case "otherchurch": if (otherchurch) w.Add(pi.Name, otherchurch); break; default: w.Add(pi.Name, pi.GetValue(this, null)); break; } } }
public string OrgMembers(int orgid, string search) { search = search ?? ""; var nosearch = !search.HasValue(); var qm = from m in Db.OrganizationMembers where m.OrganizationId == orgid where nosearch || m.Person.Name2.StartsWith(search) select new { m.PeopleId, First = m.Person.PreferredName, Last = m.Person.LastName, m.Person.EmailAddress, m.EnrollmentDate, MemberType = m.MemberType.Description, IsLeaderType = (m.MemberType.AttendanceTypeId ?? 0) == CmsData.Codes.AttendTypeCode.Leader, }; var mt = from m in Db.OrgMemMemTags where m.OrganizationMember.OrganizationId == orgid where m.OrganizationMember.MemberTypeId != Codes.MemberTypeCode.InActive select new { m.OrganizationMember.PeopleId, m.MemberTag.Name }; var mtags = mt.ToList(); var w = new APIWriter(); w.Start("OrgMembers"); foreach (var m in qm.ToList()) { w.Start("Member"); w.Attr("PreferredName", m.First); w.Attr("LastName", m.Last); w.Attr("Email", m.EmailAddress); w.Attr("Enrolled", m.EnrollmentDate); w.Attr("MemberType", m.MemberType); if (m.IsLeaderType) w.Attr("IsLeader", m.IsLeaderType); var qt = from t in mtags where t.PeopleId == m.PeopleId select t.Name; foreach (var group in qt) w.Add("Group", group); w.End(); } w.End(); return w.ToString(); }
public void WriteXml(XmlWriter writer) { var optionsAdded = false; var checkoxesAdded = false; var menuitemsAdded = false; var w = new APIWriter(writer); foreach (PropertyInfo pi in typeof(OnlineRegPersonModel).GetProperties(BindingFlags.Public | BindingFlags.Instance) .Where(vv => vv.CanRead && vv.CanWrite)) { switch (pi.Name) { case "FundItem": if (FundItem != null && FundItem.Count > 0) foreach (var f in FundItem.Where(ff => ff.Value > 0)) { w.Start("FundItem"); w.Attr("fund", f.Key); w.AddText(f.Value.Value.ToString()); w.End(); } break; case "ExtraQuestion": if(ExtraQuestion != null) for (var i = 0; i < ExtraQuestion.Count; i++) if (ExtraQuestion[i] != null && ExtraQuestion[i].Count > 0) foreach (var q in ExtraQuestion[i]) { w.Start("ExtraQuestion"); w.Attr("set", i); w.Attr("question", q.Key); w.AddText(q.Value); w.End(); } break; case "YesNoQuestion": if (YesNoQuestion != null && YesNoQuestion.Count > 0) foreach (var q in YesNoQuestion) { w.Start("YesNoQuestion"); w.Attr("question", q.Key); w.AddText(q.Value.ToString()); w.End(); } break; case "option": if (option != null && option.Count > 0 && !optionsAdded) foreach(var o in option) w.Add("option", o); optionsAdded = true; break; case "Checkbox": if (Checkbox != null && Checkbox.Count > 0 && !checkoxesAdded) foreach (var c in Checkbox) w.Add("Checkbox", c); checkoxesAdded = true; break; case "MenuItem": if(MenuItem != null) for (var i = 0; i < MenuItem.Count; i++) if (MenuItem[i] != null && MenuItem[i].Count > 0) foreach (var q in MenuItem[i]) { w.Start("MenuItem"); w.Attr("set", i); w.Attr("name", q.Key); w.Attr("number", q.Value); w.End(); } break; default: w.Add(pi.Name, pi.GetValue(this, null)); break; } } }
public string WriteXml() { var optionsAdded = false; var checkoxesAdded = false; var w = new APIWriter(); w.Start("OnlineRegPersonModel"); foreach (PropertyInfo pi in typeof(OnlineRegPersonModel0).GetProperties(BindingFlags.Public | BindingFlags.Instance) .Where(vv => vv.CanRead && vv.CanWrite)) { switch (pi.Name) { case "ExtraQuestion": WriteExtraAnswers(w); break; case "Text": WriteText(w); break; case "YesNoQuestion": WriteYesNoChoices(w); break; case "option": optionsAdded = WriteDropdownOptions(optionsAdded, w); break; case "Checkbox": checkoxesAdded = WriteCheckboxChoices(checkoxesAdded, w); break; case "MenuItem": WriteMenuChoices(w); break; default: w.Add(pi.Name, pi.GetValue(this, null)); break; } } w.End(); return w.ToString(); }
public void WriteXml(XmlWriter writer) { var w = new APIWriter(writer); writer.WriteComment(DateTime.Now.ToString()); foreach ( PropertyInfo pi in typeof (OnlineRegModel).GetProperties(BindingFlags.Public | BindingFlags.Instance) .Where(vv => vv.CanRead && vv.CanWrite)) { Debug.WriteLine(pi.Name); switch (pi.Name) { case "List": w.Start("List"); foreach (var i in list) Util.Serialize(i, writer); w.End(); break; case "History": w.Start("History"); foreach (var i in History) w.Add("item", i); w.End(); break; case "password": break; default: w.Add(pi.Name, pi.GetValue(this, null)); break; } } }
public void WriteXml(XmlWriter writer) { var optionsAdded = false; var checkoxesAdded = false; var w = new APIWriter(writer); foreach (PropertyInfo pi in typeof(OnlineRegPersonModel).GetProperties(BindingFlags.Public | BindingFlags.Instance) .Where(vv => vv.CanRead && vv.CanWrite)) { switch (pi.Name) { case "FundItem": if (FundItem != null && FundItem.Count > 0) foreach (var f in FundItem.Where(ff => ff.Value > 0)) { w.Start("FundItem"); w.Attr("fund", f.Key); w.AddText(f.Value.Value.ToString()); w.End(); } break; case "FamilyAttend": if (FamilyAttend != null && FamilyAttend.Count > 0) foreach (var f in FamilyAttend) { w.Start("FamilyAttend"); w.Attr("PeopleId", f.PeopleId); w.Attr("Name", f.Name); w.Attr("Attend", f.Attend); w.Attr("Birthday", f.Birthday); w.Attr("GenderId", f.GenderId); w.Attr("MaritalId", f.MaritalId); w.End(); } break; case "ExtraQuestion": if (ExtraQuestion != null) for (var i = 0; i < ExtraQuestion.Count; i++) if (ExtraQuestion[i] != null && ExtraQuestion[i].Count > 0) foreach (var q in ExtraQuestion[i]) { w.Start("ExtraQuestion"); w.Attr("set", i); w.Attr("question", q.Key); w.AddText(q.Value); w.End(); } break; case "YesNoQuestion": if (YesNoQuestion != null && YesNoQuestion.Count > 0) foreach (var q in YesNoQuestion) { w.Start("YesNoQuestion"); w.Attr("question", q.Key); w.AddText(q.Value.ToString()); w.End(); } break; case "option": if (option != null && option.Count > 0 && !optionsAdded) foreach (var o in option) w.Add("option", o); optionsAdded = true; break; case "Checkbox": if (Checkbox != null && Checkbox.Count > 0 && !checkoxesAdded) foreach (var c in Checkbox) w.Add("Checkbox", c); checkoxesAdded = true; break; case "MenuItem": if (MenuItem != null) for (var i = 0; i < MenuItem.Count; i++) if (MenuItem[i] != null && MenuItem[i].Count > 0) foreach (var q in MenuItem[i]) { w.Start("MenuItem"); w.Attr("set", i); w.Attr("name", q.Key); w.Attr("number", q.Value); w.End(); } break; case "MissionTripPray": if (Parent.SupportMissionTrip) w.Add(pi.Name, MissionTripPray); break; case "MissionTripGoerId": if (Parent.SupportMissionTrip) w.Add(pi.Name, MissionTripGoerId); break; case "IsFilled": if (IsFilled) w.Add(pi.Name, IsFilled); break; case "CreatingAccount": if (CreatingAccount) w.Add(pi.Name, CreatingAccount); break; case "MissionTripNoNoticeToGoer": if (MissionTripNoNoticeToGoer) w.Add(pi.Name, MissionTripNoNoticeToGoer); break; case "memberus": if (memberus) w.Add(pi.Name, memberus); break; case "otherchurch": if (otherchurch) w.Add(pi.Name, otherchurch); break; default: w.Add(pi.Name, pi.GetValue(this, null)); break; } } }