C# (CSharp) StaffForReviewQuery Examples

Example #1

File: 3.QueryHandlerConsumer.cs Project: trailmax/CQRS.Talk

        public ActionResult EligibleForReview()
        {
            var query = new StaffForReviewQuery();
            var people = reviewHandler.Handle(query);

            return View(people);
        }

Example #2

        public ActionResult EligibleForReview()
        {
            var query  = new StaffForReviewQuery();
            var people = reviewHandler.Handle(query);

            return(View(people));
        }

Example #3

File: 2.QueryHandlersImpl.cs Project: trailmax/CQRS.Talk

        public IEnumerable <Person> Handle(StaffForReviewQuery query)
        {
            const string sql = @"where 
                                    isCurrentlyEmployed = 1 
                                    and datediff(Year, DateOfJoin, GetDate()) >= 3 
                                    and isNewPensionScheme = 1";

            var people = database.Query <Person>(sql);

            return(people);
        }