} // 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;
}
