static void Main(string[] args)
{
var context = new StagingEntities();
PropertyData prop = context.PropertyDatas
.Where(x => x.Status.Equals("success"))
.FirstOrDefault();
RootObject result = JsonConvert.DeserializeObject <RootObject>(prop.results);
}
static void UpdateTable(string acct, string stat, string res)
{
int i = Int32.Parse(acct);
var context = new StagingEntities();
var result = context.PropertyDatas.Single(x => x.Account_Number == i);
result.results = res;
result.Status = stat;
context.SaveChanges();
}
static List <string> getAccountIDs(int ct)
{
var context = new StagingEntities();
var i = context.PropertyDatas
.Where(x => x.Status.Equals(null))
.OrderBy(x => Guid.NewGuid())
.Take(ct);
return(i.Select(x => x.AcctNumStr)
.ToList());
}
static void nonAsync()
{
string sURL;
WebRequest wrGETURL;
Stream objStream;
string results;
for (int i = 0; i < 100000; i++)
{
Console.WriteLine(i + ") ");
var context = new StagingEntities();
var a = context.PropertyDatas
.Where(x => x.Status.Equals("failed"))
.OrderBy(x => Guid.NewGuid())
.Take(1);
string acct = a.First().AcctNumStr;
try
{
sURL = "http://api.phila.gov/opa/v1.1/account/" + acct + "?format=json";
wrGETURL = WebRequest.Create(sURL);
wrGETURL.Timeout = 10000;
objStream = wrGETURL.GetResponse().GetResponseStream();
StreamReader objReader = new StreamReader(objStream);
results = objReader.ReadLine();
Console.WriteLine("Success: " + sURL);
UpdateTable(acct, "success", results);
results = null;
}
catch (WebException e)
{
using (WebResponse response = e.Response)
{
// Console.WriteLine("Failed Response: " + response.ResponseUri.AbsoluteUri);
Console.WriteLine("Failed Response: ");
UpdateTable(acct, "failed", null);
}
}
}
}