} // ProcessDailyAdjustments private List <Row> getAdjustmentsFromWeb(DateTime GameDate, string LeagueName) { string QueryAdjustmentsSql = "" + "SELECT * FROM Adjustments " + $" WHERE LeagueName = '{LeagueName}' " + $" AND ((Type = 'L' AND StartDate <= #{GameDate}# AND (EndDate IS NULL or EndDate >= #{GameDate}#) ) " + $" Or (StartDate <= #{GameDate}# AND (EndDate IS NULL or EndDate >= #{GameDate}#) ) AND AdjAmt <> 0 ) " + " ORDER BY Type DESC ;" ; string QueryString = "SqlCommand=Select&SQL=" + VBFunctions.URLEncode(QueryAdjustmentsSql); String url = "http://bball.com.violet.arvixe.com/ExecSql2.aspx"; WebPageGet oWebPageGet = new WebPageGet(); oWebPageGet.NewWebPagePost(url, QueryString); if (oWebPageGet.ReturnCode != 0) { throw new Exception($"Error getting Adjustments from server - RC: {oWebPageGet.ReturnCode} - {oWebPageGet.ErrorMsg}"); } string xmlString = oWebPageGet.Html; // Simple deserialization of XML to C# object - http://www.janholinka.net/Blog/Article/11 StringReader stringReader = new StringReader(xmlString); XmlSerializer serializer = new XmlSerializer(typeof(List <Row>), new XmlRootAttribute("SQLrows")); List <Row> adjList = (List <Row>)serializer.Deserialize(stringReader); List <Row> SortedAdjList = adjList.OrderBy(o => o.Team).ToList(); return(SortedAdjList); }
public BoxScoresLast5Min(string url) { WebPageGet oWebPageGet = new WebPageGet(); oWebPageGet.NewWebPageGet(url); if (oWebPageGet.ReturnCode != 0) { throw new Exception("BoxScoresLast5Min WebPageGet Error: \n" + oWebPageGet.ToString()); } _html = oWebPageGet.Html; }