public ContentResult Get() { var query = Request.QueryString.Value; if (query.IndexOf("?") == 0) { query = query.Substring(1); } var db = Database.GetTimeSeriesDatabase(); var w = new InventoryReport(db, query); var x = w.Run(); return(Content(x, "text/html")); }
/// <summary> /// PiscesWebServices contains several CGI programs in support /// of migrating from the Legacy Hydromet System. /// Longer term the PiscesAPI (.net core) project can replace this program /// </summary> /// <param name="args"></param> public static void Main(string[] args) { var siteType = ""; // agrimet, hydromet (blank means all) var cgi = ""; var json_property_stubs = ""; var payload = ""; var p = new OptionSet(); var format = "json"; var verbose = false; p.Add("cgi=", "required cgi to execute cgi=help|sites|series|instant|daily|monthly|wyreport|inventory", x => cgi = x); p.Add("json_property_stubs=", "comma separated list of properties (i.e. 'region,url,') to created empty stubs if neeed ", x => json_property_stubs = x); p.Add("site-type=", "filter agrimet sites", x => siteType = BasicDBServer.SafeSqlLikeClauseLiteral(x)); p.Add("payload=", "test query data for a CGI", x => payload = System.Uri.EscapeDataString(x)); p.Add("format=", "format json(default) | csv ", x => format = x); p.Add("verbose", " get more details", x => verbose = true); p.Add("debug", " get more details", x => verbose = true); try { p.Parse(args); } catch (OptionException e) { Console.WriteLine(e.Message); return; } Database.InitDB(args); var db = Database.DB(); if (cgi == "") { ShowHelp(p); return; } if (verbose) { Console.Write("Content-type: text/html\n\n"); Logger.EnableLogger(); var ev = Environment.GetEnvironmentVariables(); foreach (DictionaryEntry item in ev) { Console.WriteLine(item.Key + ": " + item.Value + "<br/>"); } Logger.WriteLine("verbose=true"); Logger.WriteLine("payload = " + payload); } if (cgi == "help") { if (!verbose) { Console.Write("Content-type: text/html\n\n"); } Help.Print(); return; } if (cgi == "inventory") { try { InventoryReport r = new InventoryReport(db, payload); r.Run(); } catch (Exception e) { Logger.WriteLine(e.Message); } } else if (cgi == "sites") { if (format == "json") { JSONSites d = new JSONSites(db); d.Execute(json_property_stubs.Split(','), siteType); } else if (format == "csv") { SiteCsvTable c = new SiteCsvTable(db); c.Execute(siteType); } else if (format == "test") { SiteCsvTable c = new SiteCsvTable(db); c.Execute(siteType, "jck"); } } else if (cgi == "instant" || cgi == "daily" || cgi == "monthly") { try { WebTimeSeriesWriter c = null; if (cgi == "instant") { c = new WebTimeSeriesWriter(db, TimeInterval.Irregular, payload); } else if (cgi == "daily") { c = new WebTimeSeriesWriter(db, TimeInterval.Daily, payload); } if (cgi == "monthly") { c = new WebTimeSeriesWriter(db, TimeInterval.Monthly, payload); } c.Run(); } catch (Exception e) { Logger.WriteLine("Error: " + e.Message); } } else if (cgi == "wyreport") { try { WaterYearReport wy = new WaterYearReport(db, payload); wy.Run(); } catch (Exception e) { Logger.WriteLine("Error: " + e.Message); } } else if (cgi == "site") { SiteInfoCGI si = new SiteInfoCGI(db); si.Run(payload); } else { Console.WriteLine("invalid cgi: " + cgi); } }