/// <summary> /// Fetch Posts from server to our SQL DB /// </summary> /// <returns> /// Number of rows that changed /// </returns> private static async Task <int> FetchPosts() { List <Posts> posts = JsonConvert.DeserializeObject <List <Posts> >(await HttpRequestsManager.ExecuteRequestAsync(POSTS_URL)); using (SiteDBEntities db = new SiteDBEntities()) { foreach (Posts post in posts) { if (!db.Posts.Any(u => u.id == post.id)) { db.Posts.Add(post); } } return(db.SaveChanges()); } }
/// <summary> /// Fetch Users from server to our SQL DB /// </summary> /// <returns> /// Number of rows that changed /// </returns> private static async Task <int> FetchUsers() { List <JToken> tokens = JArray.Parse(await HttpRequestsManager.ExecuteRequestAsync(USERS_URL)).ToList(); using (SiteDBEntities db = new SiteDBEntities()) { foreach (JToken token in tokens) { int id = (int)token["id"]; if (!db.Users.Any(u => u.Id == id)) { db.Users.Add(Users.CreateUser(token)); } } return(db.SaveChanges()); } }