public ActionResult Lookups(string id)
{
var ret = AuthenticateDeveloper();
if (ret.StartsWith("!"))
{
return(Content($"<Lookups error=\"{ret.Substring(1)}\" />"));
}
if (!id.HasValue())
{
return(Content("Lookups error=\"not found\">"));
}
var q = DbUtil.Db.ExecuteQuery <LookupController.Row>("select * from lookup." + id);
var w = new APIWriter();
w.Start("Lookups");
w.Attr("name", id);
foreach (var i in q)
{
w.Start("Lookup");
w.Attr("Id", i.Id);
w.AddText(i.Description);
w.End();
}
w.End();
DbUtil.LogActivity("APIMeta Lookups");
return(Content(w.ToString(), "text/xml"));
}
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 ActionResult SQLView(string id)
{
var ret = AuthenticateDeveloper();
if (ret.StartsWith("!"))
{
return(Content($"<SQLView error=\"{ret.Substring(1)}\" />"));
}
if (!id.HasValue())
{
return(Content("<SQLView error\"no view name\" />"));
}
try
{
var cmd = new SqlCommand("select * from guest." + id.Replace(" ", ""));
cmd.Connection = new SqlConnection(Util.ConnectionString);
cmd.Connection.Open();
var rdr = cmd.ExecuteReader();
DbUtil.LogActivity("APIMeta SQLView " + id);
var w = new APIWriter();
w.Start("SQLView");
w.Attr("name", id);
var read = rdr.Read();
while (read)
{
w.Start("row");
for (var i = 0; i < rdr.FieldCount; i++)
{
w.Attr(rdr.GetName(i), rdr[i].ToString());
}
w.End();
read = rdr.Read();
}
w.End();
return(Content(w.ToString(), "text/xml"));
}
catch (Exception)
{
return(Content($"<SQLView error=\"cannot find view guest.{id}\" />"));
}
}
