public AtomData DeployFormationFromTree(DeployedFormation deployFormation) { SessionManager m = (SessionManager)GlobalHost.DependencyResolver.GetService(typeof(SessionManager)); AtomData atom = m.gameManager.m_GameObject.DeployFormationFromTree(deployFormation); return(atom); }
private static AtomData GetAtomBySql(string sql) { try { AtomData atom = new AtomData(); using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection)) using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, connection)) { DataSet dsPol = new DataSet(); DataTable dtPol = new DataTable(); dsPol.Reset(); da.Fill(dsPol); dtPol = dsPol.Tables[0]; if (dtPol == null || dtPol.Rows == null || dtPol.Rows.Count == 0) { return null; } foreach (DataRow row in dtPol.Rows) { atom.UnitGuid = row["atom_guid"].ToString(); atom.UnitName = row["atom_name"].ToString(); atom.Location = new DPoint(); atom.Location.x = System.Convert.ToDouble(row["pointX"]); atom.Location.y = System.Convert.ToDouble(row["pointY"]); } } return atom; } catch (Exception ex) { } return null; }
public IEnumerable <GeneralActivityDTO> GetActivitesByAtomName(string AtomName) { IEnumerable <GeneralActivityDTO> Activites = null; AtomData atom = TDS.DAL.AtomsDB.GetAtomByName(AtomName); // GetAtomByName(string Name) if (atom != null) { Activites = TDS.DAL.ActivityDB.GetActivitesByAtom(atom.UnitGuid); if (Activites != null) { foreach (GeneralActivityDTO ActivityDTO in Activites) { ActivityDTO.Atom = atom; } } } return(Activites); }
public AtomData DeployFormationFromTree(DeployedFormation deployFormation) { if (GroundAtomObjectCollection.ContainsKey(deployFormation.formation.GUID)) return null; AtomData atom = new AtomData(); atom.Location = new DPoint(deployFormation.x, deployFormation.y); atom.UnitGuid = deployFormation.formation.GUID; atom.UnitName = deployFormation.formation.Identification; TDS.DAL.AtomsDB.AddAtom(atom); clsGroundAtom GroundAtom = new clsGroundAtom(this); GroundAtom.MyName = atom.UnitName; GroundAtom.GUID = atom.UnitGuid; GroundAtom.curr_X = atom.Location.x; GroundAtom.curr_Y = atom.Location.y; GroundAtomObjectCollection.TryAdd(GroundAtom.GUID, GroundAtom); m_GameManager.QuadTreeGroundAtom.PositionUpdate(GroundAtom); NotifyClientsEndCycleArgs args = new NotifyClientsEndCycleArgs(); args = new NotifyClientsEndCycleArgs(); args.Transport2Client.Ex_clockDate = Ex_clockDate; // args.Transport2Client.ExClockRatioSpeed = m_GameManager.ExClockRatioSpeed; args.Transport2Client.AtomObjectType = 2; args.Transport2Client.AtomObjectCollection = PrepareGroundCommonProperty(); args.Transport2Client.ManagerStatus = m_GameManager.ManagerStatus; m_GameManager.NotifyClientsEndCycle(args); return atom; }
public static IEnumerable<AtomData> GetAllAtoms() { try { List<AtomData> atoms = new List<AtomData>(); string sql = "select * from AtomObjects"; using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection)) using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, connection)) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); ds.Reset(); da.Fill(ds); dt = ds.Tables[0]; if (dt == null || dt.Rows == null || dt.Rows.Count == 0) { return null; } foreach (DataRow row in dt.Rows) { AtomData atom = new AtomData(); atom.UnitGuid = row["atom_guid"].ToString(); atom.UnitName = row["atom_name"].ToString(); atom.Location = new DPoint(); atom.Location.x = System.Convert.ToDouble(row["pointX"]); atom.Location.y = System.Convert.ToDouble(row["pointY"]); atoms.Add(atom); } } return atoms; } catch (Exception ex) { } return null; }
public static void AddAtom(AtomData Atom) { try { string sql; using (NpgsqlConnection connection = new NpgsqlConnection(strPostGISConnection)) { connection.Open(); sql = "insert into AtomObjects (atom_guid,atom_name,CountryId,pointX,pointY)" + "values ('" + Atom.UnitGuid + "','" + Atom.UnitName + "'," + 0 + "," + Atom.Location.x + "," + Atom.Location.y + " ) "; using (NpgsqlCommand command = new NpgsqlCommand(sql, connection)) { command.ExecuteNonQuery(); } } } catch(Exception ex) { } }