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