private MapObject GetMapObject()
        {
            MapObject toReturn = null;

            if (this.cbType.SelectedIndex == 1 && !string.IsNullOrEmpty(this.tbName.Text))
            {
                toReturn = new MapObject();
                toReturn.TileMap = null;
                toReturn.Name = this.tbName.Text;
            }

            return toReturn;
        }
Example #2
0
        /// <summary>
        /// Gets a map object by ID
        /// </summary>
        /// <param name="id">The ID of the map object to get</param>
        /// <returns>Returns the map object with the given ID.  Null if none exists.</returns>
        public static MapObject GetMapObject(long id)
        {
            MapObject toReturn = null;
            DataTable dt = null;
            SqlCommand cmd = new SqlCommand();
            string query = "SELECT * FROM [MapObject] WHERE ID = @ID";

            cmd.CommandType = CommandType.Text;
            cmd.CommandText = query;

            cmd.Parameters.Add("@Parent", SqlDbType.BigInt).Value = id;
            dt = DatabaseHelper.ExecuteQuery(GetConnectionString(), cmd);

            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    toReturn = new MapObject();
                    toReturn.ID = DatabaseHelper.GetValidValueFromObject(dr["ID"], (long)0);
                    toReturn.Name = DatabaseHelper.GetValidValueFromObject(dr["Name"], string.Empty);
                    if (dr["Structure"] != null)
                    {
                        toReturn.TileMap = TileMap.CreateTileMapFromByteArray((byte[])dr["Structure"]);
                    }
                    else
                    {
                        toReturn.TileMap = null;
                    }
                }
            }

            return toReturn;
        }
Example #3
0
        /// <summary>
        /// Inserts or Updates a map object, based on the given map object's ID
        /// </summary>
        /// <param name="o">The map object to insert/update</param>
        /// <param name="parent">The parent of the map object</param>
        private static void InsertUpdateMapObject(MapObject o, long parent)
        {
            SqlCommand cmd = new SqlCommand();
            string query = string.Empty;

            cmd.CommandType = CommandType.Text;
            cmd.CommandText = query;

            if (o != null)
            {
                //Update
                if (o.ID > 0)
                {
                    query = "UPDATE [MapObject] SET Name = @Name, Structure = @Structure, Parent = @Parent WHERE ID = @ID";
                    cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = o.ID;
                }
                //Insert
                else
                {
                    query = "INSERT INTO [MapObject] (Name, Structure, Parent) VALUES (@Name, @Structure, @Parent)";
                }

                cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = o.Name;
                cmd.Parameters.Add("@Structure", SqlDbType.VarBinary).Value = o.TileMap != null ? o.TileMap.GetBytesFromTileMap() : (object)DBNull.Value;
                cmd.Parameters.Add("@Parent", SqlDbType.BigInt).Value = parent;

                cmd.CommandText = query;
                DatabaseHelper.ExecuteCommand(GetConnectionString(), cmd);
            }
        }