commondataprovider.cs

本系统是在asp版《在线文件管理器》的基础上设计制作

            exception.HttpPathAndQuery  = (string) reader["PathAndQuery"];
            exception.DateCreated       = (DateTime) reader["DateCreated"];
            exception.DateLastOccurred  = (DateTime) reader["DateLastOccurred"];
            exception.Frequency         = (int) reader["Frequency"];
            exception.ExceptionID       = (int) reader["ExceptionID"];

            return exception;
        }
        #endregion

		#region Audit
        public abstract AuditSet GetAuditHistoryForPost (int postID, int pageIndex, int pageSize, bool returnRecordCount);
        public abstract AuditSet GetAuditHistoryForUser (int userID, ModeratorActions action, int pageIndex, int pageSize, bool returnRecordCount); 
        public abstract AuditSummary GetAuditSummary (int postID, int userID);
        public abstract void SaveUserAuditEvent (ModerateUserSetting auditFlag, User user, int moderatorID);

		public static AuditItem PopulateAuditItemFromIDataReader (IDataReader reader) {

			AuditItem auditItem = new AuditItem();

            auditItem.Action = (ModeratorActions) Convert.ToInt32( reader["ModerationAction"] );
            auditItem.DateModerated = Convert.ToDateTime( reader["ModeratedOn"] );
            
            try {
                auditItem.PostID = Convert.ToInt32( reader["PostID"] );
            } catch { }

            try {
                auditItem.SectionID = Convert.ToInt32( reader["SectionID"] );
            } catch { }

            try {
                auditItem.UserID = Convert.ToInt32( reader["UserID"] );
            } catch { }
            
            try {
                auditItem.UserName = Convert.ToString( reader["UserName"] );
            } catch { }

            try {
                auditItem.ModeratorID = Convert.ToInt32( reader["ModeratorID"] );
            } catch { }
            
            try {
                auditItem.ModeratorName = Convert.ToString( reader["ModeratorName"] );
            } catch { }

            try {
                auditItem.Notes = Convert.ToString( reader["Notes"] );
            } catch { }

			return auditItem;
		}

        public static AuditSummary PopulateAuditSummaryFromIDataReader (IDataReader reader) {
            AuditSummary summary = new AuditSummary();

            try {
                summary[ModeratorActions.ApprovePost] = (reader["ApprovePost"] != DBNull.Value) ? (int) reader["ApprovePost"] : 0;
                summary[ModeratorActions.BanUser] = (reader["BanUser"] != DBNull.Value) ? (int) reader["BanUser"] : 0;
                summary[ModeratorActions.ChangePassword] = (reader["ChangePassword"] != DBNull.Value) ? (int) reader["ChangePassword"] : 0;
                summary[ModeratorActions.DeletePost] = (reader["DeletePost"] != DBNull.Value) ? (int) reader["DeletePost"] : 0;
                summary[ModeratorActions.EditPost] = (reader["EditPost"] != DBNull.Value) ? (int) reader["EditPost"] : 0;
                summary[ModeratorActions.EditUser] = (reader["EditUser"] != DBNull.Value) ? (int) reader["EditUser"] : 0;
                summary[ModeratorActions.LockPost] = (reader["LockPost"] != DBNull.Value) ? (int) reader["LockPost"] : 0;
                summary[ModeratorActions.MergePost] = (reader["MergePost"] != DBNull.Value) ? (int) reader["MergePost"] : 0;
                summary[ModeratorActions.ModerateUser] = (reader["ModerateUser"] != DBNull.Value) ? (int) reader["ModerateUser"] : 0;
                summary[ModeratorActions.MovePost] = (reader["MovePost"] != DBNull.Value) ? (int) reader["MovePost"] : 0;
                summary[ModeratorActions.PostIsAnnouncement] = (reader["PostIsAnnouncement"] != DBNull.Value) ? (int) reader["PostIsAnnouncement"] : 0;
                summary[ModeratorActions.PostIsNotAnnoucement] = (reader["PostIsNotAnnoucement"] != DBNull.Value) ? (int) reader["PostIsNotAnnoucement"] : 0;
                summary[ModeratorActions.ResetPassword] = (reader["ResetPassword"] != DBNull.Value) ? (int) reader["ResetPassword"] : 0;
                summary[ModeratorActions.SplitPost] = (reader["SplitPost"] != DBNull.Value) ? (int) reader["SplitPost"] : 0;
                summary[ModeratorActions.UnApprovePost] = (reader["UnApprovePost"] != DBNull.Value) ? (int) reader["UnApprovePost"] : 0;
                summary[ModeratorActions.UnbanUser] = (reader["UnbanUser"] != DBNull.Value) ? (int) reader["UnbanUser"] : 0;
                summary[ModeratorActions.UnlockPost] = (reader["UnlockPost"] != DBNull.Value) ? (int) reader["UnlockPost"] : 0;
                summary[ModeratorActions.UnmoderateUser] = (reader["UnmoderateUser"] != DBNull.Value) ? (int) reader["UnmoderateUser"] : 0;
            } 
            catch { 
                // this should happen if one of the query column is missing
                //
                summary = null;
            }

            return summary;
        }
		#endregion

        #region Censorship
        public abstract ArrayList GetCensors();
		public abstract int CreateUpdateDeleteCensor( Censor censor, DataProviderAction action );
		public static Censor PopulateCenshorFromIDataReader( IDataReader dr ) {
			Censor censorship = new Censor();

			censorship.Replacement	= Convert.ToString(dr["Replacement"]);
			censorship.Word			= Convert.ToString(dr["Word"]);

			return censorship;
		}
        #endregion

        #region Disallowed Names
        public abstract ArrayList GetDisallowedNames();
        public abstract int CreateUpdateDeleteDisallowedName(string name, string replacement, DataProviderAction action);
        #endregion
        
        #region Resources
        public abstract void CreateUpdateDeleteImage (int userID, Avatar avatar, DataProviderAction action);
        #endregion

        #region Categories
            
            public abstract Hashtable GetCategories(int forumID);
            public abstract void DeleteCategory(int categoryID, int forumID);
            public abstract bool UpdateCategory(PostCategory category);
            public abstract int CreateCategory(PostCategory category);

        #endregion

		#region Blog Links

		public abstract Int32 CreateLink( Link link );
		public abstract Boolean UpdateLink( Link link );
		public abstract void DeleteLink( Int32 linkID );
		public abstract Hashtable GetLinks( Int32 linkCategoryID );
		public abstract void ChangeLinkSortOrder( Int32 linkID, Boolean moveUp );

		public abstract Int32 CreateLinkCategory( LinkCategory linkCategory );
		public abstract Boolean UpdateLinkCategory( LinkCategory linkCategory );
		public abstract void DeleteLinkCategory( Int32 linkCategoryID, Int32 ForumID );
		public abstract Hashtable GetLinkCategories( Int32 forumID );
		public abstract void ChangeLinkCategorySortOrder( Int32 linkCategoryID, Boolean moveUp );

		#endregion

		#region Blog Feedback

		public abstract ArrayList GetFeedback( Int32 forumID );
		public abstract ArrayList GetFeedback( Int32 forumID, Int32 pageIndex, Int32 pageSize, out Int32 totalRecords );

		#endregion

        #region RANKS FUNCTIONS
		/************************ RANKS FUNCTIONS *****************************/
		public abstract ArrayList GetRanks();
		public abstract int CreateUpdateDeleteRank( Rank rank, DataProviderAction action );
		public static Rank PopulateRankFromIDataReader( IDataReader dr ) {
			Rank rank = new Rank();
			
			rank.PostingCountMaximum	= Convert.ToInt32(dr["PostingCountMax"]);
			rank.PostingCountMinimum	= Convert.ToInt32(dr["PostingCountMin"]);
			rank.RankIconUrl			= Convert.ToString(dr["RankIconUrl"]);
			rank.RankId					= Convert.ToInt32(dr["RankId"]);
			rank.RankName				= Convert.ToString(dr["RankName"]);

			return rank;
		}
       

		/**********************************************************************/

         #endregion

        #region REPORTS FUNCTIONS
		/************************ REPORTS FUNCTIONS ***************************/
		public abstract ArrayList GetReports(int userID, bool ignorePermissions);
		public abstract int CreateUpdateDeleteReport( Report report, DataProviderAction action );
		public static Report PopulateReportFromIDataReader( IDataReader dr ) {
			Report report = new Report();

			report.IsActive			= Convert.ToBoolean(dr["Active"]);
			report.ReportCommand	= Convert.ToString(dr["ReportCommand"]);
			report.ReportId			= Convert.ToInt32(dr["ReportId"]);
			report.ReportName		= Convert.ToString(dr["ReportName"]);
			report.ReportScript		= Convert.ToString(dr["ReportScript"]);

			return report;
		}
		
		/**********************************************************************/

        #endregion

        #region SERVICES FUNCTIONS

		/************************* SERVICES FUNCTIONS *************************/
		public abstract ArrayList GetServices(int userID, bool ignorePermissions);
		public abstract int CreateUpdateDeleteService( Service service, DataProviderAction action );
		public static Service PopulateServiceFromIDataReader( IDataReader dr ) {
			Service service = new Service();

			service.ServiceAssemblyPath		= Convert.ToString(dr["ServiceAssemblyPath"]);
			service.ServiceCode				= (Service.ServiceCodeType)Convert.ToInt32(dr["ServiceCode"]);
			service.ServiceFullClassName	= Convert.ToString(dr["ServiceFullClassName"]);
			service.ServiceId				= Convert.ToInt32(dr["ServiceId"]);
			service.ServiceName				= Convert.ToString(dr["ServiceName"]);
			service.ServiceWorkingDirectory	= Convert.ToString(dr["ServiceWorkingDirectory"]);

			return service;
		}

		/**********************************************************************/

        #endregion

        #region SMILIES FUNCTIONS

		/************************ SMILIES FUNCTIONS ***************************/
		public abstract ArrayList GetSmilies();
		public abstract int CreateUpdateDeleteSmiley( Smiley smiley, DataProviderAction action );
		public static Smiley PopulateSmileyFromIDataReader( IDataReader dr ) {
			Smiley smiley = new Smiley( Convert.ToInt32(dr["SmileyID"])
										, Convert.ToString( dr["SmileyCode"])
										, Convert.ToString( dr["SmileyUrl"])
										, Convert.ToString( dr["SmileyText"])
										, Convert.ToBoolean( dr["BracketSafe"]) );

//			smiley.SmileyCode	= Convert.ToString(dr["SmileyCode"]);
//			smiley.SmileyId		= Convert.ToInt32(dr["SmileyId"]);
//			smiley.SmileyText	= Convert.ToString(dr["SmileyText"]);
//			smiley.SmileyUrl	= Convert.ToString(dr["SmileyUrl"]);

			return smiley;
		}
		
		/**********************************************************************/

        #endregion

        #region STYLE FUNCTIONS
		/********************** STYLE FUNCTIONS *******************************/
		public abstract ArrayList GetStyles(int userID, bool ignorePermissions);
		public abstract int CreateUpdateDeleteStyle( Style style, DataProviderAction action );
		public static Style PopulateStyleFromIDataReader( IDataReader dr ) {
			Style style = new Style();

			style.StyleId				= Convert.ToInt32(dr["StyleId"]);
			style.StyleName				= Convert.ToString(dr["StyleName"]);
			style.StyleSheetTemplate	= Convert.ToString(dr["StyleSheetTemplate"]);
			style.BodyBackgroundColor	= Convert.ToString(dr["BodyBackgroundColor"]);
			style.BodyTextColor			= Convert.ToString(dr["BodyTextColor"]);
			style.LinkVisited			= Convert.ToString(dr["LinkVisited"]);
			style.LinkHover				= Convert.ToString(dr["LinkHover"]);
			style.LinkActive			= Convert.ToString(dr["LinkActive"]);
			style.RowColorPrimary		= Convert.ToString(dr["RowColorPrimary"]);
			style.RowColorSecondary		= Convert.ToString(dr["RowColorSecondary"]);
			style.RowColorTertiary		= Convert.ToString(dr["RowColorTertiary"]);
			style.RowClassPrimary		= Convert.ToString(dr["RowClassPrimary"]);
			style.RowClassSecondary		= Convert.ToString(dr["RowClassSecondary"]);
			style.RowClassTertiary		= Convert.ToString(dr["RowClassTertiary"]);
			style.HeaderColorPrimary	= Convert.ToString(dr["HeaderColorPrimary"]);
			style.HeaderColorSecondary	= Convert.ToString(dr["HeaderColorSecondary"]);
			style.HeaderColorTertiary	= Convert.ToString(dr["HeaderColorTertiary"]);
			style.HeaderStylePrimary	= Convert.ToString(dr["HeaderStylePrimary"]);
			style.HeaderStyleSecondary	= Convert.ToString(dr["HeaderStyleSecondary"]);
			style.HeaderStyleTertiary	= Convert.ToString(dr["HeaderStyleTertiary"]);
			style.CellColorPrimary		= Convert.ToString(dr["CellColorPrimary"]);
			style.CellColorSecondary	= Convert.ToString(dr["CellColorSecondary"]);
			style.CellColorTertiary		= Convert.ToString(dr["CellColorTertiary"]);
			style.CellClassPrimary		= Convert.ToString(dr["CellClassPrimary"]);
			style.CellClassSecondary	= Convert.ToString(dr["CellClassSecondary"]);
			style.CellClassTertiary		= Convert.ToString(dr["CellClassTertiary"]);
			style.FontFacePrimary		= Convert.ToString(dr["FontFacePrimary"]);
			style.FontFaceSecondary		= Convert.ToString(dr["FontFaceSecondary"]);
			style.FontFaceTertiary		= Convert.ToString(dr["FontFaceTertiary"]);
			style.FontSizePrimary		= Convert.ToInt16(dr["FontSizePrimary"]);
			style.FontSizeSecondary		= Convert.ToInt16(dr["FontSizeSecondary"]);
			style.FontSizeTertiary		= Convert.ToInt16(dr["FontSizeTertiary"]);
			style.FontColorPrimary		= Convert.ToString(dr["FontColorPrimary"]);
			style.FontColorSecondary	= Convert.ToString(dr["FontColorSecondary"]);
			style.FontColorTertiary		= Convert.ToString(dr["FontColorTertiary"]);
			style.SpanClassPrimary		= Convert.ToString(dr["SpanClassPrimary"]);
			style.SpanClassSecondary	= Convert.ToString(dr["SpanClassSecondary"]);
			style.SpanClassTertiary		= Convert.ToString(dr["SpanClassTertiary"]);

			return style;
		}
		
		/**********************************************************************/
	
        #endregion

        #region Post  FUNCTIONS



        public static Rating PopulateRatingFromIDataReader(IDataReader dr) {
            Rating rating = new Rating();

            rating.User = PopulateUserFromIDataReader(dr,PopulateMembershipUserFromIDataReader(dr,null),false);
            rating.Value = (int) dr["Rating"];

            return rating;
        }


		public static void PopulateIndexPostFromIDataReader(IDataReader dr, Post post) {

			// Populate Post
			//
			post.PostID             = Convert.ToInt32(dr["PostID"]);
			post.ParentID           = Convert.ToInt32(dr["ParentID"]);
			post.FormattedBody      = Convert.ToString(dr["FormattedBody"]).Trim();
			post.Body               = Convert.ToString(dr["Body"]).Trim();
			post.SectionID            = Convert.ToInt32(dr["SectionID"]);
			post.PostDate           = Convert.ToDateTime(dr["PostDate"]);