private ObjectDirectory GetObjectDirectory()
        {
            ObjectDirectory toReturn = null;

            if (this.cbType.SelectedIndex == 0 && !string.IsNullOrEmpty(this.tbName.Text))
            {
                toReturn = new ObjectDirectory();
                toReturn.MapObjects = new Collections.MapObjects();
                toReturn.ObjectDirectories = new Collections.ObjectDirectories();
                toReturn.Name = this.tbName.Text;
            }

            return toReturn;
        }
Example #2
0
        /// <summary>
        /// Gets the object directory with the given ID.
        /// </summary>
        /// <param name="id">The ID of the object directory to get.</param>
        /// <returns>The object directory with the given ID</returns>
        public static ObjectDirectory GetObjectDirectory(long id)
        {
            ObjectDirectory toReturn = null;
            DataTable dt = null;
            SqlCommand cmd = new SqlCommand();
            string query = "SELECT * FROM [ObjectDirectory] WHERE ID = @ID";

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

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

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

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

            if (o != null)
            {
                cmd = new SqlCommand();
                cmd.CommandType = CommandType.Text;

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

                cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = o.Name;
                cmd.Parameters.Add("@Parent", SqlDbType.BigInt).Value = parent;

                cmd.CommandText = query;
                id = DatabaseHelper.ExecuteCommandContainingGetIdentity(GetConnectionString(), cmd);

                if (id > 0)
                {
                    InsertUpdateObjectDirectories(o.ObjectDirectories, id);
                    InsertUpdateMapObjects(o.MapObjects, id);
                }
            }
        }
Example #4
0
        /// <summary>
        /// Gets all object directores with the given parent
        /// </summary>
        /// <param name="parent">The parent id of the object directories to get</param>
        /// <returns>All object directories with the given parent</returns>
        public static ObjectDirectories GetObjectDirectories(long parent)
        {
            ObjectDirectories toReturn = new ObjectDirectories();
            SqlCommand cmd = new SqlCommand();
            ObjectDirectory temp = null;
            DataTable dt = null;
            string query = "SELECT * FROM [ObjectDirectory] WHERE Parent = @Parent";

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

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

            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    temp = new ObjectDirectory();
                    temp.ID = DatabaseHelper.GetValidValueFromObject(dr["ID"], (long)0);
                    temp.Name = DatabaseHelper.GetValidValueFromObject(dr["Name"], string.Empty);

                    toReturn.Add(temp);
                }
            }

            return toReturn;
        }