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