private bool SaveBoutsAll(int count) { ArrayList arrUrl = new ArrayList(); for (int i = 0; i < count; i++) { arrUrl.Add(WebProvider.GetBoutUrl(i, federationUrl)); } DataModels.Imports.Rinxter.RBouts[] bouts = new DataModels.Imports.Rinxter.RBouts[arrUrl.Count]; var db = new ManagementContext(); { for (int i = 1; i < bouts.Length; i++) // { bouts[i] = WebProvider.Download_serialized_json_data<DataModels.Imports.Rinxter.RBouts>(arrUrl[i].ToString()); try { var item = bouts[i]; if (item != null && item.ID != 0) { var queryB = (from b in db.RBouts where b.ID == item.ID select b).FirstOrDefault(); var queryT1 = (from t in db.RTeams where t.ID == item.Team1ID select t).FirstOrDefault(); var queryT2 = (from t in db.RTeams where t.ID == item.Team2ID select t).FirstOrDefault(); bool isOk = true; if (queryB == null) { if (queryT1 == null) { isOk = SaveTeam(item.Team1ID); } if (isOk && queryT2 == null) { isOk = SaveTeam(item.Team2ID); } if (isOk) { item.IsFemale = IsFemale; db.RBouts.Add(item); int c = db.SaveChanges(); } } } } catch (Exception ex) { ErrorDatabaseManager.AddException(ex, GetType()); return false; } } } return true; }
public bool SaveBoutsData(string boutsJsonUrl) { ArrayList arrUrl = WebProvider.GetBoutUrl(boutsJsonUrl, federationUrl); DataModels.Imports.Rinxter.RBouts[] bouts = new DataModels.Imports.Rinxter.RBouts[arrUrl.Count]; try { var db = new ManagementContext(); for (int i = 0; i < bouts.Length; i++) { bouts[i] = WebProvider.Download_serialized_json_data<DataModels.Imports.Rinxter.RBouts>(arrUrl[i].ToString()); var item = bouts[i]; if (item.ID == 0) continue; var getBouts = (from b in db.RBouts where b.ID == item.ID && b.IsFemale == IsFemale select b).FirstOrDefault(); var getTeam1 = (from t in db.RTeams where t.ID == item.Team1ID && t.IsFemale == IsFemale select t).FirstOrDefault(); var getTeam2 = (from t in db.RTeams where t.ID == item.Team2ID && t.IsFemale == IsFemale select t).FirstOrDefault(); bool isOk = true; if (getBouts == null) { if (getTeam1 == null) { isOk = SaveTeam(item.Team1ID); } if (isOk && getTeam2 == null) { isOk = SaveTeam(item.Team2ID); } if (isOk) { item.IsFemale = IsFemale; item.LastModified = DateTime.UtcNow; db.RBouts.Add(item); int c = db.SaveChanges(); } } else { getBouts.TournamentsID = item.TournamentsID; getBouts.Date = item.Date; getBouts.Location = item.Location; getBouts.Sanction = item.Sanction; getBouts.Season = item.Season; getBouts.State = item.State; getBouts.Status = item.Status; getBouts.TimeStart = item.TimeStart; getBouts.LastModified = DateTime.UtcNow; getBouts.IsFemale = IsFemale; int c = db.SaveChanges(); } } } catch (Exception ex) { ErrorDatabaseManager.AddException(ex, GetType()); return false; ; } // SaveBoutsAll(5000); return true; }