private static void BuildDB()
{
UserRecord u = new UserRecord();
u.Drop(); u.Create();
AllianceRecord a = new AllianceRecord();
a.Drop(); a.Create();
PlanetRecord p = new PlanetRecord();
p.Drop(); p.Create();
ReportRecord r = new ReportRecord();
r.Drop(); r.Create();
ResourceRecord res = new ResourceRecord();
res.Drop(); res.Create();
BuildingRecord b = new BuildingRecord();
b.Drop(); b.Create();
ResearchRecord re = new ResearchRecord();
re.Drop(); re.Create();
FleetRecord f = new FleetRecord();
f.Drop(); f.Create();
DefenceRecord d = new DefenceRecord();
d.Drop(); d.Create();
}
public OldScannedPlanet(Planet planet, PlanetRecord history)
{
this.planet = planet;
this.Timestamp = history.Time;
if (history.OwnerId.HasValue)
{
Settlement = new OldSettlement(history);
}
}
private void ParseSystem(string text)
{
Console.WriteLine("Parsing system {0} ...", _system);
string[] planets = text.Split(new string[] { "*|*|*" }, StringSplitOptions.RemoveEmptyEntries);
try
{
foreach (string pl in planets)
{
string[] values = pl.Split(new string[] { "*|*" }, StringSplitOptions.RemoveEmptyEntries);
if (values.Length == 16)
{
string pnr = values[4].Trim(), pname = values[7].Trim(), ploc = values[8], info = values[9], uname = "", status = "", aname = "";
string pid = values[15].Trim(), uid = "", aid = "";
int points = 0;
Alliance a = null;
User u = null;
Planet p = new Planet {
Id = pid, Name = pname.Trim(), User = null, Report = null
};
//Report r = null;
if (!pname.Contains("Niezamieszkane"))
{
if (ParseAlliance(info, out aid, out aname))
{
//AllianceRecord alliance = new AllianceRecord{ Id = int.Parse(aid), Name = aname.Trim() };
//if(alliance.Select() == null) alliance.Insert();
a = new Alliance {
Id = aid, Name = aname
};
if (!Alliances.ContainsKey(aid))
{
Alliances.Add(aid, a);
}
else
{
Alliances[aid] = a;
}
}
if (ParseUser(info, out uid, out uname))
{
UserRecord user = new UserRecord();
ParsePoints(info, out points);
ParseStatus(info, out status);
//user.Id = int.Parse(uid);
user.Name = uname.Trim();
user.Points = points;
user.Status = status.Trim();
//user.Alliance = int.Parse(aid);
//ObjectDumper.Dump(user);
u = new User {
Id = uid
};
u.Name = uname.Trim(); u.Points = points; u.Status = status.Trim(); u.Alliance = a;
if (Users.ContainsKey(uid))
{
Users[uid] = u;
}
else
{
Users.Add(uid, u);
}
p.User = u;
}
}
else
{
pname = "";
}
int galaxy = 0, system = 0, nr = 0;
ParseLocation(ploc, out galaxy, out system, out nr);
PlanetRecord planet = new PlanetRecord();
//planet.Id = int.Parse(pid);
planet.Name = pname.Trim();
planet.Galaxy = galaxy;
planet.System = system;
planet.Planet = nr;
p.Galaxy = galaxy; p.System = system; p.Number = nr; p.Name = pname.Trim();
//Planet p = new Planet { Id = pid, Name = pname.Trim(), Galaxy = galaxy, System = system, Number = nr };
//Console.WriteLine("planet {0}", pid);
//ReportRecord report = new ReportRecord { Id = int.Parse(pid) };
//ParseReport(html, report);
/*if(report != null)
* {
* report.Id = int.Parse(pid);
* //ObjectDumper.Dump(report);
* }else
* Console.WriteLine("Brak raportu.");
*/
//ObjectDumper.Dump(planet);
//if(Planets.ContainsKey(pid))
p.UpdateReport();
Planets[pid] = p;
//u.Planets[pid] = p;
}
}
}catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public OldSettlement(PlanetRecord history)
{
this.history = history;
}
