コード例 #1
0
        protected void odsCMNEvent_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
        {
            String fe1 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_EventIdentityCategoryID, OverviewEventIdentityCategoryID.ToString(), SQLMatchType.Equal);
            String fe2 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_CreatedByMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal);
            String fe  = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);

            String fe_invitation = SqlExpressionBuilder.PrepareFilterExpression(CMNEventInvitationInformationEntity.FLD_NAME_InitationGivenToMemberID, CurrentMember.MemberID.ToString(), SQLMatchType.Equal);
            IList <CMNEventInvitationInformationEntity> lstCMNEventInvitationInformationEntity = FCCCMNEventInvitationInformation.GetFacadeCreate().GetIL(null, null, String.Empty, fe_invitation, DatabaseOperationType.LoadWithFilterExpression);

            if (lstCMNEventInvitationInformationEntity != null && lstCMNEventInvitationInformationEntity.Count > 0)
            {
                String compositeEventID = String.Empty;

                foreach (CMNEventInvitationInformationEntity ent in lstCMNEventInvitationInformationEntity)
                {
                    compositeEventID += ent.EventID + ",";
                }
                compositeEventID = compositeEventID.Substring(0, compositeEventID.Length - 1);

                String fe_compsite = "EventID In(" + compositeEventID + ")";

                fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe_compsite);
            }

            if (chbxFilter.Checked)
            {
                String fe3 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_Title, txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
                String fe4 = SqlExpressionBuilder.PrepareFilterExpression(CMNEventEntity.FLD_NAME_EventReferenceNo, txtSearchText.Text.ToString(), SQLMatchType.LikeWithBothMath);
                String fe5 = SqlExpressionBuilder.PrepareFilterExpression(fe3, SQLJoinType.OR, fe4);
                fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe5);
            }

            e.InputParameters["filterExpression"] = fe;
        }
コード例 #2
0
        private void PrepareInitialView()
        {
            BuildDropDownList();

            txtEventReferenceNo.Text             = MasterDataConstants.AutoAssigned.DEFAULT_AUTO_ASSIGNED;
            txtTitle.Text                        = String.Empty;
            txtDetails.Text                      = String.Empty;
            txtLocation.Text                     = String.Empty;
            txtWebsiteURL.Text                   = String.Empty;
            txtTicketSellerURL.Text              = String.Empty;
            txtYoutubeURL.Text                   = String.Empty;
            txtTransitAndParkingInformation.Text = String.Empty;
            txtDuration.Text                     = String.Empty;
            txtExpectedStartDate.Text            = System.DateTime.Now.ToString("MM/dd/yyyy hh:mm");
            txtExpectedEndDate.Text              = System.DateTime.Now.AddHours(1).ToString("MM/dd/yyyy hh:mm");
            txtActualStartDate.Text              = String.Empty;
            txtActualEndDate.Text                = String.Empty;
            chkIsAllDay.Checked                  = false;
            txtNotifyBeforeMin.Text              = String.Empty;
            txtRemarks.Text                      = String.Empty;

            if (OverviewEventID > 0)
            {
                _EventID = OverviewEventID;
            }

            hypEventSchedule.NavigateUrl = UrlHelper.BuildSecureUrl("~/Common/CMNEventSchedule.aspx", string.Empty, UrlConstants.OVERVIEW_EVENT_IDENTITY_CATEGORY_ID, OverviewEventIdentityCategoryID.ToString()).ToString();

            hypEventSchedule.Target = "_blank";

            btnSubmit.Text    = "Add";
            btnAddNew.Visible = false;
        }