public IEnumerable <SelectListItem> SavedQueries()
{
if (!SavedQueryVisible)
{
return(null);
}
string uname = Util.UserName;
var g = new Guid();
if (SavedQuery.HasValue() && SavedQuery.Contains(":"))
{
var lines = SavedQuery.Split(":".ToCharArray(), 2);
Guid.TryParse(lines[0], out g);
}
var q1 = from qb in Db.Queries
where qb.Owner == uname
orderby qb.Name
select new SelectListItem
{
Value = qb.QueryId + ":" + qb.Name,
Selected = qb.QueryId == g,
Text = qb.Name
};
var q2 = from qb in Db.Queries
where qb.Owner != uname && qb.Ispublic
orderby qb.Owner, qb.Name
select new SelectListItem
{
Value = qb.QueryId + ":" + qb.Name,
Selected = qb.QueryId == g,
Text = qb.Owner + ":" + qb.Name,
};
return(q1.Union(q2));
}
private void WriteAttributes(XmlWriter w, bool newGuids = false)
{
if (newGuids)
{
w.WriteAttributeString("Id", Guid.NewGuid().ToString());
}
else
{
w.WriteAttributeString("Id", Id.ToString());
}
w.WriteAttributeString("Order", Order.ToString());
w.WriteAttributeString("Field", ConditionName);
w.WriteAttributeString("Comparison", Comparison);
if (Description.HasValue())
{
w.WriteAttributeString("Description", Description);
}
if (PreviousName.HasValue())
{
w.WriteAttributeString("PreviousName", Description);
}
if (TextValue.HasValue())
{
w.WriteAttributeString("TextValue", TextValue);
}
if (DateValue.HasValue)
{
w.WriteAttributeString("DateValue", DateValue.ToString());
}
if (CodeIdValue.HasValue())
{
w.WriteAttributeString("CodeIdValue", CodeIdValue);
}
if (StartDate.HasValue)
{
w.WriteAttributeString("StartDate", StartDate.ToString());
}
if (EndDate.HasValue)
{
w.WriteAttributeString("EndDate", EndDate.ToString());
}
if (Program > 0)
{
w.WriteAttributeString("Program", Program.ToString());
}
if (Division > 0)
{
w.WriteAttributeString("Division", Division.ToString());
}
if (Organization > 0)
{
w.WriteAttributeString("Organization", Organization.ToString());
}
if (OrgType > 0)
{
w.WriteAttributeString("OrgType", OrgType.ToString());
}
if (Days > 0)
{
w.WriteAttributeString("Days", Days.ToString());
}
if (Quarters.HasValue())
{
w.WriteAttributeString("Quarters", Quarters);
}
if (Tags.HasValue())
{
w.WriteAttributeString("Tags", Tags);
}
if (Schedule != 0)
{
w.WriteAttributeString("Schedule", Schedule.ToString());
}
if (Campus > 0)
{
w.WriteAttributeString("Campus", Campus.ToString());
}
if (ConditionName != "FamilyHasChildrenAged")
{
Age = null;
}
if (Age.HasValue)
{
w.WriteAttributeString("Age", Age.ToString());
}
if (SavedQuery.HasValue())
{
w.WriteAttributeString("SavedQueryIdDesc", SavedQuery);
}
if (OnlineReg.HasValue)
{
w.WriteAttributeString("OnlineReg", OnlineReg.ToString());
}
if (OrgStatus.HasValue)
{
w.WriteAttributeString("OrgStatus", OrgStatus.ToString());
}
if (OrgType2.HasValue)
{
w.WriteAttributeString("OrgType2", OrgType2.ToString());
}
if (OrgName.HasValue())
{
w.WriteAttributeString("OrgName", OrgName);
}
}
