C# (CSharp) Incremental.Kick.Dal UserAlertMessageViewCollectionの例

コード例 #1

ファイル: User.cs プロジェクト: bsimser/dotnetkicks

        /// <summary>
        /// Returns a collection of alerts for the user
        /// </summary>
        /// <returns></returns>
        public UserAlertMessageViewCollection AlertMessages()
        {
            Query query = UserAlertMessageView.Query();

            query.WHERE(UserAlertMessageView.Columns.UserId, this.UserID);
            query.ORDER_BY(UserAlertMessageView.Columns.AlertOrder, "ASC");

            UserAlertMessageViewCollection alerts = new UserAlertMessageViewCollection();

            alerts.LoadAndCloseReader(query.ExecuteReader());

            return(alerts);
        }

コード例 #2

ファイル: User.cs プロジェクト: Letractively/dotnetkicks

        /// <summary>
        /// Returns a collection of alerts for the user
        /// </summary>
        /// <returns></returns>
        public UserAlertMessageViewCollection AlertMessages()
        {
            Query query = UserAlertMessageView.Query();
            query.WHERE(UserAlertMessageView.Columns.UserId, this.UserID);
            query.ORDER_BY(UserAlertMessageView.Columns.AlertOrder, "ASC");

            UserAlertMessageViewCollection alerts = new UserAlertMessageViewCollection();
            alerts.LoadAndCloseReader(query.ExecuteReader());

            return alerts;
        }