public static DataView GetTreeByItem(int ItemID, int UserID)
 {
     return(SqlClient.Run(HCMIS.Repository.Queries.Activity.SelectTreeByItem(ItemID, UserID)));
 }
 public static DataView GetActivitiesForItem(int itemID, int unitID, int userID)
 {
     return(SqlClient.Run(HCMIS.Repository.Queries.Activity.SelectByItemAndUnit(itemID, unitID, userID)));
 }
        /// <summary>
        /// Gets the account tree.
        /// </summary>
        /// <param name="userID">The user ID.</param>
        /// <returns></returns>

        public static DataView GetAccountTree(int userID)
        {
            var query = HCMIS.Repository.Queries.Activity.SelectGetAccountTree(userID);

            return(SqlClient.Run(query));
        }