void client_GetAchievementTrendCompleted(object sender, GetAchievementTrendCompletedEventArgs e) { foreach (AchievementTrend item in e.Result) { AchievementTrendTable achievementTrendTable = new AchievementTrendTable() { Achievement = item.Achievement, Name = item.Name, Time = item.Time, UserId = item.UserId }; if (item.Achievement.Contains("NO")) { string index = item.Achievement.Substring(item.Achievement.IndexOf("NO.") + 3, 1); achievementTrendTable.ImageUri = "/Image_Friends/top/" + index + ".png"; achievementTrendTable.Category = ""; } else { achievementTrendTable.Achievement = "get a title of "; achievementTrendTable.ImageUri = "/Image_Friends/crown/" + item.Achievement + ".png"; achievementTrendTable.Category = item.Achievement + " baron"; }; db.AchievementTrends.InsertOnSubmit(achievementTrendTable); } db.SubmitChanges(); dealWithAchievement(); callback2(); }
private void dealWithAchievement(UserTable user) { // List<int> list_FriendId = db.FriendTables.Where(c => c.UserId == userId).Select(c => c.FriendId).ToList<int>(); // list_FriendId.Add(userId); //foreach (int j in list_FriendId) Console.WriteLine(j); int[] Num = new int[10]; //foreach (int friendId in list_FriendId) // { // { // // if (user.Id == friendId) // { if (user.NowRank <= 8 && user.LastRank > 8) { AchievementTrendTable achievementTable = new AchievementTrendTable() { Achievement = "rise to NO." + user.NowRank, Time = DateTime.Now.ToShortDateString(), UserId = user.Id }; db.AchievementTrendTables.AddObject(achievementTable); } if (user.NowRank == 1 && user.LastRank != 1) { foreach (ItemTable item in db.ItemTables.Where(c => c.UserId == user.Id)) { Num[item.CategoryId] += item.Amount; } int max = 0; int categotyId = 0; for (int j = 1; j <= 6; j++) { if (Num[j] > max) { max = Num[j]; categotyId = j; } } string categoryName = db.CategoryTables.SingleOrDefault(c => c.Id == categotyId).Name; AchievementTrendTable achievementTable = new AchievementTrendTable() { Achievement = categoryName, Time = DateTime.Now.ToShortDateString(), UserId = user.Id }; db.AchievementTrendTables.AddObject(achievementTable); } db.SaveChanges(); }