private void ClearPremium()
{
var prem = DbG.premium.Single(p => p.user_id == GameUserService.Id);
prem.endTime = UnixTime.UtcNow();
prem.data = "{}";
prem.finished = true;
DbG.SubmitChanges();
}
private void DeleteSectors()
{
var systemGeometry = DbG.g_sectors.Select(ss => ss);
if (systemGeometry.Any())
{
DbG.g_sectors.DeleteAllOnSubmit(systemGeometry);
DbG.ExecuteCommand("DBCC CHECKIDENT('[dbo].[g_sectors]', RESEED, 0);");
DbG.SubmitChanges();
}
}
private void DeleteDetailSystem()
{
var systemData = DbG.g_detail_system.Select(ss => ss);
if (systemData.Any())
{
DbG.g_detail_system.DeleteAllOnSubmit(systemData);
// db.ExecuteCommand("DBCC CHECKIDENT('[dbo].[g_detail_system]', RESEED, 0);");
DbG.SubmitChanges();
}
}
private void DeleteSystem()
{
var system = DbG.g_system.Select(ss => ss);
if (system.Any())
{
DbG.g_system.DeleteAllOnSubmit(system);
DbG.ExecuteCommand("DBCC CHECKIDENT('[dbo].[g_system]', RESEED, 0);");
DbG.SubmitChanges();
}
}
private void DeleteMoonDetail()
{
var moonsDetail = DbG.g_detail_moon.Select(ss => ss);
if (!moonsDetail.Any())
{
return;
}
DbG.g_detail_moon.DeleteAllOnSubmit(moonsDetail);
//Db.ExecuteCommand("DBCC CHECKIDENT('[dbo].[g_detail_moon]', RESEED, 0);");
DbG.SubmitChanges();
}
private void DeleteMoonGeometry()
{
var moons = DbG.g_geometry_moon.Select(ss => ss);
if (!moons.Any())
{
return;
}
DbG.g_geometry_moon.DeleteAllOnSubmit(moons);
DbG.ExecuteCommand("DBCC CHECKIDENT('[dbo].[g_geometry_moon]', RESEED, 0);");
DbG.SubmitChanges();
}
private void SetNewPremiumData()
{
var prem = DbG.premium.Single(p => p.user_id == GameUserService.Id);
var data = EmulatePremiumData();
var time = UnixTime.UtcNow();
var lastItem = data.Last().Value;
prem.data = JsonConvert.SerializeObject(data);
prem.finished = !(time < lastItem.DateEndTime);
prem.endTime = lastItem.DateEndTime;
DbG.SubmitChanges();
}
public IHttpActionResult UnitTurn()
{
SetNewPremiumData();
var units = SetUnitProgress();
DbG.user_mothership.Single(m => m.user_id == GameUserService.Id).unitProgress = JsonConvert.SerializeObject(units);
DbG.SubmitChanges();
var unitBefore = DbG.user_mothership.Single(m => m.user_id == GameUserService.Id).unitProgress;
new Synchronizer().UserMothership(GameUserService, true);
var result = new
{
UnitsBefore = JsonConvert.DeserializeObject <Dictionary <string, TurnedUnit> >(unitBefore),
Unitsafter = GetUnitsAfter()
};
return(Json(result));
}
