public PagerInfo <SaleDto> GetPagedList(GetSaleOrderQueryRequest request, int uid)
        {
            var filter       = Mapper.Map <GetSaleOrderQueryRequest, SaleOrderFilter>(request);
            var pagerRequest = new Domain.PagerRequest(request.Page ?? 1, request.PageSize ?? 10);

            if (request.EndDate != null || request.StartDate != null)
            {
                var daterange = new DateRangeFilter {
                    EndDateTime = request.EndDate, StartDateTime = request.StartDate
                };

                filter.DateRange = daterange;
            }

            int total;
            var datas = _saleOrderRepository.GetPagedList(pagerRequest, out total, filter, (SaleOrderSortOrder)(request.SortOrder ?? 0));
            var dto   = Mapper.Map <List <SalesOrderModel>, List <SaleDto> >(datas);

            var pagerdto = new PagerInfo <SaleDto>(pagerRequest, total)
            {
                Datas = dto
            };

            return(pagerdto);
        }
 public override void OnAttachToDataGridColumn(DependencyObject s, DependencyPropertyChangedEventArgs e)
 {
     if (Filter == null)
     {
         Filter = new DateRangeFilter(ColumnOwner.DataGridExt.ModelView.ItemType, ColumnOwner.Property());
     }
 }
        public async Task <IActionResult> Get(string terms, WorkflowStatus?status, string type, DateTime?createdFrom, DateTime?createdTo, int skip, int take = 10)
        {
            var filters = new List <SearchFilter>();

            if (status.HasValue)
            {
                filters.Add(StatusFilter.Equals(status.Value));
            }

            if (createdFrom.HasValue)
            {
                filters.Add(DateRangeFilter.After(x => x.CreateTime, createdFrom.Value));
            }

            if (createdTo.HasValue)
            {
                filters.Add(DateRangeFilter.Before(x => x.CreateTime, createdTo.Value));
            }

            if (!string.IsNullOrEmpty(type))
            {
                filters.Add(ScalarFilter.Equals(x => x.WorkflowDefinitionId, type));
            }

            var result = await _searchService.Search(terms, skip, take, filters.ToArray());

            return(Json(result));
        }
        public List <ContactRecord> PrayerRequests(int?memberId, int?ccgId,
                                                   DateRangeFilter dateRange, ContactsSort contactsSort,
                                                   bool getAll = false, string query = null, CCGAppUser appuser = null)
        {
            // Get principal user obj
            var user = unitOfWork.AppUserRepository.FindUserByEmail(appuser.UserName);

            DateTime dateTimeOffset;

            GetOffsetDate(dateRange, out dateTimeOffset);

            List <ContactRecord> prayerRequests;

            // determine if user is leadership, pastor or admin
            AppUserRole[] roles = new AppUserRole[] { AppUserRole.Admin,
                                                      AppUserRole.DeaconLeadership,
                                                      AppUserRole.Pastor };
            // get all if user is admin, leadership, or pastor
            getAll = AuthHelper.IsInRole(appuser.UserName, roles);

            // not leadership so only get prayer requests within ccg
            if (!getAll && ccgId == null)
            {
                ccgId = user.CcgId;
            }

            prayerRequests = GetPrayerRequests(memberId,
                                               dateTimeOffset, ccgId, getAll, user, query).ToList();

            // Sort prayer requests
            return(SortContactRecords(contactsSort, prayerRequests).ToList());
        }
        public IHttpActionResult GetList([FromUri] GetShippingSaleOrderRequest request, [UserId] int userId, [UserProfile] UserProfile userProfile)
        {
            var filter       = Mapper.Map <GetShippingSaleOrderRequest, ShippingOrderFilter>(request);
            var pagerRequest = new Domain.PagerRequest(request.Page ?? 1, request.PageSize ?? 10);

            request.ArrangeParams();
            if (request.EndDate != null || request.StartDate != null)
            {
                var daterange = new DateRangeFilter {
                    EndDateTime = request.EndDate, StartDateTime = request.StartDate
                };

                filter.DateRange = daterange;
            }

            int total;

            filter.StoreIds = userProfile.StoreIds == null ? null : userProfile.StoreIds.ToList();

            //按创建日期倒序
            var datas = _shippingOrderRepository.GetPagedList(pagerRequest, out total, filter,
                                                              (ShippingOrderSortOrder)(request.SortOrder ?? 0));

            var dto = Mapper.Map <List <ShippingOrderModel>, List <ShippingSaleDto> >(datas);

            var pagerdto = new PagerInfo <ShippingSaleDto>(pagerRequest, total)
            {
                Datas = dto
            };

            return(RetrunHttpActionResult(pagerdto));
        }
Example #6
0
 public DateRange(DateTime CurrentDate,DateRangeFilter filter )
 {
     if (filter == DateRangeFilter.ThisMonth)
     {
         StartDate = GetFirstDayOfMonth(CurrentDate);
         EndDate = GetLastDayOfMonth(CurrentDate);
     }
     else if (filter == DateRangeFilter.ThisYear)
     {
         StartDate = GetFirstDayOfYear(CurrentDate);
         EndDate = GetLastDayOfYear(CurrentDate);
     }
     else if (filter == DateRangeFilter.Last7Days)
     {
         EndDate = CurrentDate;
         StartDate = EndDate.AddDays(-7);
     }
     else if (filter == DateRangeFilter.Last3Month)
     {
         EndDate = CurrentDate;
         StartDate = EndDate.AddMonths(-3);
     }
     else if (filter == DateRangeFilter.Last365Days)
     {
         EndDate = CurrentDate;
         StartDate = EndDate.AddYears(-1);
     }
     else if (filter == DateRangeFilter.AnyTime)
     {
         StartDate = DateTime.MinValue;
         EndDate = GetLastDayOfYear(CurrentDate);
     }
 }
        public OperationsManagerViewModel(
            BusyIndicatorViewModel busyIndicator,
            IOperationsManager operationsManager,
            IImportManager importManager)
        {
            _busyIndicator     = busyIndicator;
            _operationsManager = operationsManager;
            _importManager     = importManager;
            BeginExportCommand = new RelayCommand(BeginExport);
            BeginDataQualityAnalysisCommand = new AsyncCommand(BeginDataQualityAnalysis);
            CommitExportCommand             = new AsyncCommand(CommitExport);
            CommitPendingChangesCommand     = new AsyncCommand(SaveChanges);
            _sfd = new SaveFileDialog
            {
                OverwritePrompt = true,
                Filter          = "csv files (*.csv)|*.csv|All Files (*.*)|*.*"
            };

            SelectTargetFileToExportCommand = new RelayCommand(SelectTargetFileToExport);
            MessengerInstance.Register <AccountViewModel>(this, OnAccountViewModelReceived);

            _asyncMessageReceiver = new AsyncMessageReceiver(MessengerInstance);
            _asyncMessageReceiver.RegisterAsync <AccountImportDataChanged>(this, data => ReplayImports(data.AccountId));

            DateFilter = new DateRangeFilter();
            NoteFilter = new TextFilter();
            _anyFilter = new CompositeFilter(DateFilter, NoteFilter);
            _anyFilter.FilterInvalidated += OnAnyFilterInvalidated;

            ResetFilterCommad = new RelayCommand(() => _anyFilter.Reset(), () => IsFiltering);
        }
Example #8
0
        public async void should_filter_on_alt_custom_data_with_conflicting_names()
        {
            var result1 = await Subject.Search(null, 0, 10, ScalarFilter.Equals <AltDataObject>(x => x.Value1, 9));

            var result2 = await Subject.Search(null, 0, 10, DateRangeFilter.Between <AltDataObject>(x => x.Value2, new DateTime(1999, 12, 31), new DateTime(2000, 1, 2)));

            result1.Data.Should().Contain(x => x.Id == "4");
            result2.Data.Should().Contain(x => x.Id == "4");
        }
Example #9
0
        public async void should_filter_on_date_range()
        {
            var start  = new DateTime(2000, 1, 1);
            var end    = new DateTime(2015, 1, 1);
            var result = await Subject.Search(null, 0, 10, DateRangeFilter.Between(x => x.CreateTime, start, end));

            result.Data.Should().NotContain(x => x.CreateTime <start || x.CreateTime> end);
            result.Data.Should().Contain(x => x.CreateTime > start && x.CreateTime < end);
        }
Example #10
0
        public void ApplyOn_MultipleMatchingOffence_ReturnAllMatchingOffences()
        {
            List <Offence> _offences = new List <Offence>
            {
                new Offence(DateTime.AddDays(-3), "", new Location(1.1, 1.1), OffenceCategories.Cybercrime),
                new Offence(DateTime.AddDays(-2), "", new Location(1.1, 1.1), OffenceCategories.Cybercrime)
            };
            DateRangeFilter filter = new DateRangeFilter(DateTime.AddDays(-4), DateTime.AddDays(-2));

            Assert.AreEqual(_offences.FindAll(x => x.DateTime.Date >= DateTime.AddDays(-4) && x.DateTime.Date <= DateTime.AddDays(-2)), filter.ApplyOn(_offences));
        }
        public DashboardFilterViewModel()
        {
            DateRangeFilter = new DateRangeFilter();
            NoteFilter      = new TextFilter();
            AccountsFilter  = new MultiSelectFilter();
            CategoryFilter  = new MultiSelectFilter();
            DirectionFilter = new DirectionFilter();
            _anyFilter      = new CompositeFilter(DateRangeFilter, NoteFilter, AccountsFilter, CategoryFilter, DirectionFilter);
            _anyFilter.FilterInvalidated += OnAnyFilterInvalidated;

            ResetFilterCommad = new RelayCommand(Reset, () => IsFiltering);
        }
Example #12
0
 /// <summary>
 /// Adds a DateRangeFilter to the filterlist using the dates from two datepickers.
 /// </summary>
 /// <param name="DatePickerFrom">Datepicker containing the lower bound of the date range.</param>
 /// <param name="DatePickerTo">Datepicker containing the upper bound of the date range.</param>
 /// <returns>Boolean based on whether the filter was added.</returns>
 private bool AddDateRangeFilter(DatePicker DatePickerFrom, DatePicker DatePickerTo)
 {
     if (DatePickerFrom != null && DatePickerFrom.SelectedDate.HasValue && DatePickerTo != null && DatePickerTo.SelectedDate.HasValue)
     {
         FilterList.RemoveFilter($"{typeof(DateFilter)}");
         DateTime        DateFrom = new DateTime(DatePickerFrom.SelectedDate.Value.Year, DatePickerFrom.SelectedDate.Value.Month, DatePickerFrom.SelectedDate.Value.Day);
         DateTime        DateTo   = new DateTime(DatePickerTo.SelectedDate.Value.Year, DatePickerTo.SelectedDate.Value.Month, DatePickerTo.SelectedDate.Value.Day);
         DateRangeFilter filter   = new DateRangeFilter(DateFrom, DateTo);
         FilterList.AddFilter(filter);
         return(true);
     }
     return(false);
 }
Example #13
0
        public void FilterContactsByDateRange(List <ContactRecord> records, DateRangeFilter dateRangeFilter)
        {
            if (records == null)
            {
                return;
            }

            DateTime dateTimeOffset;

            GetOffsetDate(dateRangeFilter, out dateTimeOffset);

            // Remove all that are older than the offset date
            // '<' means older. Eg, if the timestamp is 90 days
            // ago and the offset date is 60 days ago, the
            // contact will be removed. 3/15/17 > 3/15/16
            records.RemoveAll(cr => cr.Timestamp <= dateTimeOffset);
        }
Example #14
0
        public async Task <IEnumerable <SimpleTaskDTO> > GetTasks(DateRangeFilter dateRangeFilter, int managementUnitId = 0)
        {
            var returnList0 = new List <DataObjects.SimpleTaskDTO>();

            List <DataObjects.DAOS.Task> tasks = new List <DataObjects.DAOS.Task>();


            if (managementUnitId == 0)
            {
                tasks = await _sqLiteAsyncConnection.GetAllWithChildrenAsync <DataObjects.DAOS.Task>(
                    filter : p => (p.DeadlineDate >= dateRangeFilter.From &&
                                   p.DeadlineDate <= dateRangeFilter.To && p.Deleted == false && p.CompletedDate != null),
                    orderExpr : null,
                    limit : 25,
                    offset : 0,
                    recursive : 0);
            }
            else
            {
                tasks = await _sqLiteAsyncConnection.GetAllWithChildrenAsync <DataObjects.DAOS.Task>(
                    filter : p => (p.DeadlineDate >= dateRangeFilter.From && p.DeadlineDate <= dateRangeFilter.To) && p.ManagementUnitID == managementUnitId,
                    orderExpr : null,
                    limit : 25,
                    offset : 0,
                    recursive : 0);
            }

            returnList0.AddRange(tasks.Select(t => new DataObjects.SimpleTaskDTO()
            {
                Amount   = t.Amount ?? 0,
                Manager  = t.ManagementUnit.GetIFNull().WoodlandOfficer.DisplayName,
                Category = t.TaskCategory.Description,
                Notes    = t.Notes,
                Region   = t.ManagementUnit.GetIFNull().Region.Description,
                TaskId   = t.ID,
                Deadline = t.DeadlineDate
            }));


            return(returnList0);
        }
        public GmcManagerFilterViewModel()
        {
            FilterOnItemDateCommand = new RelayCommand <BasicTransactionModel>(FilterOnItemDate);

            var deltaFilterData = new Dictionary <string, IList <DeltaAction> >
            {
                { "to add", new[] { DeltaAction.Add } },
                { "to update", new[] { DeltaAction.UpdateMemo } },
                { "to remove", new[] { DeltaAction.Remove } },
                { "undeterministic status", new[] { DeltaAction.MultipleTargetsPossible, DeltaAction.NotUniqueKeyInTarget } },
                { "up to date", new[] { DeltaAction.Nothing } }
            };

            DeltaFilter = new MultiSelectFilter();
            DeltaFilter.Initialize(deltaFilterData, kv => kv.Key, kv => kv.Value);
            DateFilter = new DateRangeFilter();
            MemoFilter = new TextFilter();
            _anyFilter = new CompositeFilter(DeltaFilter, DateFilter, MemoFilter);
            _anyFilter.FilterInvalidated += OnAnyFilterInvalidated;

            ResetFilterCommad = new RelayCommand(Reset, () => IsFiltering);
        }
Example #16
0
        public async Task <SearchResult> SearchAsync(Status status, Student student, DateRangeFilter dateRange, SortingData sortData)
        {
            var books = await _studentRepository.SearchAsync(student, status, dateRange, sortData);

            List <object> rows = null;

            rows = books.Select(a => new
            {
                a.ID,
                a.StudentName,
                a.BranchID,
                a.BranchName,
                Gender = (a.Gender == "M")?"Male":"Female",
                a.Mobile,
                //a.DateOfBirth,
                DateOfBirth = a.DateOfBirth.ToString("dddd, dd MMMM yyyy"),
                a.City,
                a.Pincode,
                a.Email,
                a.Password,
                a.Address,
                a.CreatedBy,
                a.CreatedByName,
                a.CreatedDate,
                a.UpdatedBy,
                a.UpdatedByName,
                a.UpdatedDate,
                a.ApprovedBy,
                a.ApprovedByName,
                a.ApprovedDate,
            }).ToList <object>();

            return(new SearchResult
            {
                Rows = rows,
                TotalRows = books.FirstOrDefault() != null?books.FirstOrDefault().TotalCount : 0
            });
        }
Example #17
0
        public void GetOffsetDate(DateRangeFilter dateRangeFilter, out DateTime dateTimeOffset)
        {
            TimeSpan timespan = new TimeSpan(0, 0, 0);

            switch (dateRangeFilter)
            {
            case DateRangeFilter.TwoWeeks:
                timespan = TimeSpan.FromDays(14);
                break;

            case DateRangeFilter.LastMonth:
                timespan = TimeSpan.FromDays(30);
                break;

            case DateRangeFilter.LastTwoMonths:
                timespan = TimeSpan.FromDays(60);
                break;

            case DateRangeFilter.ThreeMonths:
                timespan = TimeSpan.FromDays(90);
                break;

            case DateRangeFilter.SixMonths:
                timespan = TimeSpan.FromDays(180);
                break;

            case DateRangeFilter.LastYear:
                timespan = TimeSpan.FromDays(365);
                break;

            case DateRangeFilter.None:
                dateTimeOffset = new DateTime(2000, 1, 1);
                return;
            }
            dateTimeOffset = DateTime.Now.Subtract(timespan);
        }
Example #18
0
        public async Task <List <Student> > SearchAsync(Student student, Status status, DateRangeFilter dateRange, SortingData sortData)
        {
            var publications = new List <Student>();

            try
            {
                var parameters = new DynamicParameters();
                parameters.Add("@in_DML", "Search", dbType: DbType.String, direction: ParameterDirection.Input, size: 10);
                if (student.ID > 0)
                {
                    parameters.Add("@in_ID", student.ID, dbType: DbType.Int32, direction: ParameterDirection.Input, size: 10);
                }
                if (!string.IsNullOrEmpty((student.StudentName)))
                {
                    parameters.Add("@in_StudentName", student.StudentName, dbType: DbType.String, direction: ParameterDirection.Input, size: 120);
                }

                if (student.BranchID > 0)
                {
                    parameters.Add("@in_BranchID", student.BranchID, dbType: DbType.Int32, direction: ParameterDirection.Input, size: 10);
                }

                if (student.CreatedBy > 0)
                {
                    parameters.Add("@in_CreatedBy", student.CreatedBy, dbType: DbType.Int32, direction: ParameterDirection.Input, size: 10);
                }

                if (dateRange.CreatedDateStart != null && dateRange.CreatedDateEnd != null)
                {
                    parameters.Add("@in_CreatedDateStart", dateRange.CreatedDateStart, dbType: DbType.DateTime, direction: ParameterDirection.Input, size: 20);
                    parameters.Add("@in_CreatedDateEnd", dateRange.CreatedDateEnd, dbType: DbType.DateTime, direction: ParameterDirection.Input, size: 20);
                }
                if (dateRange.UpdatedDateStart != null && dateRange.UpdatedDateEnd != null)
                {
                    parameters.Add("@in_UpdatedDateStart", dateRange.UpdatedDateStart, dbType: DbType.DateTime, direction: ParameterDirection.Input, size: 20);
                    parameters.Add("@in_UpdatedDateEnd", dateRange.UpdatedDateEnd, dbType: DbType.DateTime, direction: ParameterDirection.Input, size: 20);
                }

                if (sortData.PageNumber > 0)
                {
                    parameters.Add("@in_PageNumber", sortData.PageNumber, dbType: DbType.Int32, direction: ParameterDirection.Input, size: 10);
                }

                if (sortData.PageSize > 0)
                {
                    parameters.Add("@in_PageSize", sortData.PageSize, dbType: DbType.Int32, direction: ParameterDirection.Input, size: 10);
                }
                if (sortData.SortColumn != null && sortData.SortColumn != "")
                {
                    parameters.Add("@in_SortColumn", sortData.SortColumn, dbType: DbType.String, direction: ParameterDirection.Input, size: 20);
                }
                if (sortData.SortOrder != null && sortData.SortOrder != "")
                {
                    parameters.Add("@in_SortOrder", sortData.SortOrder, dbType: DbType.String, direction: ParameterDirection.Input, size: 20);
                }


                publications = (await _dataProvider.ExecuteReaderAsync <Student>("[LMS_USP_Student]", parameters)).ToList();

                status.Code    = parameters.Get <int>("@ou_ResultNo");
                status.Message = parameters.Get <string>("@ou_ResultMessage");
            }
            catch (Exception ex)
            {
                status.Code    = 500;
                status.Message = ex.Message;
            }
            return(publications);
        }
Example #19
0
        public async Task <IActionResult> SearchAsync(Status status, Student student, DateRangeFilter dateRange, SortingData sortData)
        {
            var results = await _studentService.SearchAsync(status, student, dateRange, sortData);

            _pagination = new Pagination()
            {
                PageSize   = (sortData.PageSize != 0) ? sortData.PageSize : DefaultPageSize.PageSize,
                PageNumber = (sortData.PageNumber != 0) ? sortData.PageNumber : 1,
                TotalRows  = results != null ? results.TotalRows : 0
            };
            return(CreateResponseWithStatus(status.Code, objResponse.ResponseModel(results.Rows, status, _pagination)));
        }
Example #20
0
 public static DateRange GetDateRange(DateTime CurrentDate, DateRangeFilter Filter)
 {
     return new DateRange(CurrentDate, Filter);
 }
        // To use a custom database schema with the Database Manager, you must define a custom MyPrepareSearch method
        // and assign it to the StorageDatabaseManager.PrepareSearch delegate. After doing this, the search fields in the Database Manager
        //will properly refine any database manager search.  The MyPrepareSearch() method gets the search fields specified in the database manager
        // by calling StorageDatabaseManager.GetDicomQueryParams().  This returns any query parameters specified.
        // The MyPrepareSearch() method then needs to create a MatchingParameterCollection that corresponds to the specified search.
        // Note that the database manager search fields correspond to items contained in the patient, study, and series tables only.
        // There are no search fields that correspond to the image table.
        // Therefore MyPrepareSearch() only needs to add MyPatient, MyStudy, and MySeries objects to the MatchingParameterList.
        // For more details, see the "Changing the LEAD Medical Storage Server to use a different database schema" tutorial.


        private void MyPrepareSearch(MatchingParameterCollection matchingCollection)
        {
            DicomQueryParams q = __DbManager.GetDicomQueryParams();

            try
            {
                MatchingParameterList matchingList = new MatchingParameterList();
                MyPatient             patient      = new MyPatient();
                MyStudy  study  = new MyStudy();
                MySeries series = new MySeries();

                matchingList.Add(patient);
                matchingList.Add(study);
                matchingList.Add(series);

                matchingCollection.Add(matchingList);
                study.StudyAccessionNumber    = q.AccessionNumber;
                patient.PatientIdentification = q.PatientId;

                if (!string.IsNullOrEmpty(q.PatientName.FamilyName))
                {
                    patient.PatientName = q.PatientName.FamilyName.TrimEnd('*') + "*";
                }

                if (!string.IsNullOrEmpty(q.PatientName.GivenName))
                {
                    patient.PatientName = q.PatientName.GivenName.TrimEnd('*') + "*";
                }

                if (!string.IsNullOrEmpty(q.Modalities))
                {
                    series.SeriesModality = q.Modalities.Replace(",", "\\");
                }
                ;

                if (!string.IsNullOrEmpty(q.SeriesDescription))
                {
                    series.SeriesSeriesDescription = q.SeriesDescription.TrimEnd('*') + "*";
                }

                if (!string.IsNullOrEmpty(q.ReferringPhysiciansName.FamilyName))
                {
                    study.StudyReferringPhysiciansName = q.ReferringPhysiciansName.FamilyName.TrimEnd('*') + "*";
                }
                ;

                if (!string.IsNullOrEmpty(q.ReferringPhysiciansName.GivenName))
                {
                    study.StudyReferringPhysiciansName = q.ReferringPhysiciansName.GivenName.TrimEnd('*') + "*";
                }
                ;

                if (q.StudyFromChecked || q.StudyToChecked)
                {
                    DateRange studyDateRange = new DateRange();

                    if (q.StudyFromChecked)
                    {
                        studyDateRange.StartDate = q.StudyFromDate;
                    }

                    if (q.StudyToChecked)
                    {
                        studyDateRange.EndDate = q.StudyToDate;
                    }

                    study.StudyStudyDate = studyDateRange;
                }

                if (q.StorageDateChecked)
                {
                    MyInstance      instance  = new MyInstance();
                    DateRange       dateRange = new DateRange();
                    DateRangeFilter StorageDateRangeFilter = q.StorageDateRange;
                    string          startDate = StorageDateRangeFilter.DateRangeFrom;
                    string          endDate   = StorageDateRangeFilter.DateRangeTo;

                    if (StorageDateRangeFilter.SelectedDateFilter == DateRangeFilter.RangeFilterType.DateRange)
                    {
                        if (!string.IsNullOrEmpty(startDate))
                        {
                            dateRange.StartDate = DateTime.Parse(startDate);
                        }

                        if (!string.IsNullOrEmpty(endDate))
                        {
                            dateRange.EndDate = DateTime.Parse(endDate);
                        }
                    }
                    else if (StorageDateRangeFilter.SelectedDateFilter == DateRangeFilter.RangeFilterType.Months)
                    {
                        DateTime lastMonthsDate = DateTime.Now.SubtractMonths(Convert.ToInt32(StorageDateRangeFilter.LastMonths));

                        dateRange.StartDate = lastMonthsDate;
                        dateRange.EndDate   = DateTime.Now;
                    }
                    else
                    {
                        TimeSpan subtractionDays = new TimeSpan(Convert.ToInt32(StorageDateRangeFilter.LastDays),
                                                                DateTime.Now.Hour,
                                                                DateTime.Now.Minute,
                                                                DateTime.Now.Second,
                                                                DateTime.Now.Millisecond);

                        dateRange.StartDate = DateTime.Now.Subtract(subtractionDays);
                        dateRange.EndDate   = DateTime.Now;
                    }

                    instance.ImageLastStoreDate = dateRange;
                    matchingList.Add(instance);
                }

                study.StudyStudyId = q.StudyId;
            }
            catch (Exception exception)
            {
                throw exception;
            }
            finally
            {
                // do nothing ;
            }
        }
        /// <summary>
        ///     Do date time search
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="items"></param>
        /// <param name="property"></param>
        /// <param name="filter"></param>
        /// <returns></returns>
        public static IQueryable <T> WithDateRangeSearch <T>(this IQueryable <T> items,
                                                             Expression <Func <T, DateTime> > property, DateRangeFilter filter)
        {
            if (filter == null || property == null)
            {
                return(items);
            }

            // Filter by from value.
            items = items.WithDateSearch(property, filter?.From);

            // Filter by to value.
            items = items.WithDateSearch(property, filter?.To);

            return(items);
        }
 private void DataGridOwner_Loaded(object sender, RoutedEventArgs e)
 {
     Filter = new DateRangeFilter(ColumnOwner.DataGridExt.ModelView.ItemType, ColumnOwner.Property());
 }
Example #24
0
        public IEnumerable <ContactRecord> GetContactRecords(int?memberId, int?ccgId, bool getAll,
                                                             bool archive, CCGAppUser user, DateRangeFilter dateRangeFilter,
                                                             string query, out ActionResult actionResult)
        {
            actionResult = null;
            DateTime dateTimeOffset;

            GetOffsetDate(dateRangeFilter, out dateTimeOffset);

            // Prevents having one query for search and one for no search.
            if (query == null)
            {
                query = "";
            }

            // Get contact records for specific member
            if (memberId != null)
            {
                return(unitOfWork.ContactRecordRepository
                       .GetContactRecords(c => c.CCGMemberId == memberId &&
                                          c.Archive == archive &&
                                          c.Timestamp > dateTimeOffset &&
                                          c.ContactType.Name != _prayerRequestName &&
                                          (c.Subject.Contains(query) || c.Comments.Contains(query))).ToList());
            }
            // Get all contact records for a CCG passed to parameter
            if (ccgId != null && ccgId != -1)
            {
                return(unitOfWork.ContactRecordRepository
                       .GetContactRecords(c => c.CCGMember.CcgId == ccgId &&
                                          c.Archive == archive &&
                                          c.Timestamp > dateTimeOffset &&
                                          c.ContactType.Name != _prayerRequestName &&
                                          (c.Subject.Contains(query) || c.Comments.Contains(query))).ToList());
            }
            // Get all contact records; admin or leadership only
            if (getAll)
            {
                if (!CanViewAllRecords(user.Email))
                {
                    // If denied permission, get all records for user's CCG only
                    return(GetContactRecordsForCcg(archive, user, dateTimeOffset,
                                                   query, out actionResult).ToList());
                }

                // Gets all contact records.
                return(unitOfWork.ContactRecordRepository
                       .GetContactRecords(c => c.Archive == archive &&
                                          c.Timestamp > dateTimeOffset &&
                                          c.ContactType.Name != _prayerRequestName &&
                                          (c.Subject.Contains(query) || c.Comments.Contains(query))).ToList());
            }

            // Get all contact records for the user's CCG only
            return(GetContactRecordsForCcg(archive, user, dateTimeOffset, query,
                                           out actionResult).ToList());
        }
Example #25
0
 public bool Equals_AllCases(DateRangeFilter filter1, DateRangeFilter filter2)
 {
     return(filter1.Equals(filter2));
 }
Example #26
0
        private void UpdatePropertiesPanel(XmlNode selectedItem)
        {
            if (selectedItem.Name == "input")
            {
                switch (selectedItem.Attributes["type"].Value)
                {
                case "MSMQ":
                    MyGrid = new MSMQIN(selectedItem, this.View);
                    break;

                case "MQ":
                    MyGrid = new MQIN(selectedItem, this.View);
                    break;

                case "FILE":
                    MyGrid = new FILEIN(selectedItem, this.View);
                    break;

                case "KAFKA":
                    MyGrid = new KAFKAIN(selectedItem, this.View);
                    break;

                case "HTTP":
                    MyGrid = new HTTPIN(selectedItem, this.View);
                    break;

                case "RABBITDEFEX":
                    MyGrid = new RABBITIN(selectedItem, this.View);
                    break;

                case "MQTT":
                    MyGrid = new MQTTIN(selectedItem, this.View);
                    break;

                case "TCPSERVER":
                    MyGrid = new TCPIN(selectedItem, this.View);
                    break;

                case "TESTSOURCE":
                    MyGrid = new TESTSOURCE(selectedItem, this.View);
                    break;
                }
            }
            else if (selectedItem.Name == "output" || selectedItem.Name == "altqueue")
            {
                switch (selectedItem.Attributes["type"].Value)
                {
                case "MSMQ":
                    MyGrid = new MSMQOUT(selectedItem, this.View);
                    break;

                case "MQ":
                    MyGrid = new MQOUT(selectedItem, this.View);
                    break;

                case "FILE":
                    MyGrid = new FILEOUT(selectedItem, this.View);
                    break;

                case "KAFKA":
                    MyGrid = new KAFKAOUT(selectedItem, this.View);
                    break;

                case "REST":
                    MyGrid = new RESTOUT(selectedItem, this.View);
                    break;

                case "HTTP":
                    MyGrid = new HTTPOUT(selectedItem, this.View);
                    break;

                case "TCPCLIENT":
                    MyGrid = new TCPOUT(selectedItem, this.View);
                    break;

                case "RABBITDEFEX":
                    MyGrid = new RABBITOUT(selectedItem, this.View);
                    break;

                case "MQTT":
                    MyGrid = new MQTTIN(selectedItem, this.View);
                    break;

                case "SMTP":
                    MyGrid = new SMTPOut(selectedItem, this.View);
                    break;

                case "FTP":
                    MyGrid = new FTPOut(selectedItem, this.View);
                    break;

                case "SINK":
                    MyGrid = new SINK(selectedItem, this.View);
                    break;
                }
            }
            else if (selectedItem.Name == "monitor")
            {
                MyGrid = new MonitorGrid(selectedItem, this.View);
            }
            else if (selectedItem.Name == "filter")
            {
                MyGrid = new Filter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "pipe")
            {
                MyGrid = new PIPE(selectedItem, this.View);
            }
            else if (selectedItem.Name == "namespace")
            {
                MyGrid = new NameSpaceGrid(selectedItem, this.View);
            }
            else if (selectedItem.Name == "service")
            {
                MyGrid = new ServiceSetting(selectedItem, this.View);
            }
            else if (selectedItem.Name == "and" || selectedItem.Name == "or" || selectedItem.Name == "xor" || selectedItem.Name == "not")
            {
                MyGrid = new BooleanExpression(selectedItem, this.View);
            }
            else if (selectedItem.Name == "contains")
            {
                MyGrid = new ContainsFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "equals")
            {
                MyGrid = new EqualsFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "matches")
            {
                MyGrid = new MatchesFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "length")
            {
                MyGrid = new LengthFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "xpexists")
            {
                MyGrid = new XPExistsFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "xpmatches")
            {
                MyGrid = new XPMatchesFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "xpequals")
            {
                MyGrid = new XPEqualsFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "dateRange")
            {
                MyGrid = new DateRangeFilter(selectedItem, this.View);
            }
            else if (selectedItem.Name == "contextContains")
            {
                MyGrid = new ContextFilter(selectedItem, this.View);
            }

            OnPropertyChanged("MyGrid");
        }