public GetProductList(PeriodFilter timeFilter, int pageNo, int pageSize, string searchText) { TimeFilter = timeFilter; PageNo = pageNo; PageSize = pageSize; SearchText = searchText; }
public static PeriodFilter GetPeriodFilter(HttpRequest request) { if (HasYearFilter(request)) { PeriodFilter filter = new PeriodFilter(); filter.StartYear = toInt(request.QueryString[STARTYEAR]); filter.EndYear = toInt(request.QueryString[ENDYEAR]); return(filter); } return(null); }
private static string SerializeToUrl(PeriodFilter filter) { string result = String.Empty; if (filter != null) { result += addParameter(STARTYEAR, filter.StartYear); result += addParameter(ENDYEAR, filter.EndYear); } return(result); }
private static string GetDateFilter(PeriodFilter filter) { switch (filter) { case PeriodFilter.Upcoming: return("AND (getutcdate() < SellStartDate)\r\n"); case PeriodFilter.Current: return("AND (getutcdate() > SellStartDate AND getutcdate() < SellEndDate)\r\n"); case PeriodFilter.Past: return("AND (getutcdate() > SellEndDate)\r\n"); case PeriodFilter.All: return(string.Empty); default: throw new ArgumentOutOfRangeException(nameof(filter), filter, null); } }
public ListResponse <Period> GetPeriodByFilter([FromQuery] PeriodFilter periodFilter) { if (periodFilter == null) { return(new ListResponse <Period>()); } List <Period> cycles = PeriodService.Current.GetPeriodByFilter(periodFilter); ListResponse <Period> response = new ListResponse <Period>(); if (cycles != null && cycles.Count > 0) { response.Data = cycles; } return(response); }
internal List <Period> GetPeriodByFilter(PeriodFilter periodFilter) { List <Period> list = new List <Period>(); StringBuilder queryStr = new StringBuilder($@"select a.id,a.name,a.parentid,a.starttime,a.endtime,a.typeid, b.code as typecode, b.name as typename ,a.periodsetid,c.name as periodsetname, a.alias from period a inner join periodtype b on b.id = a.typeid inner join periodset c on c.id = a.periodsetid where (a.tenantid = '0' or a.tenantid = '{Utils.GetTenantId()}') "); if (!string.IsNullOrEmpty(periodFilter.PeriodID)) { queryStr.Append($@" and a.id='{periodFilter.PeriodID}'"); } if (!string.IsNullOrEmpty(periodFilter.PeriodSetID)) { queryStr.Append($@" and a.periodsetid='{periodFilter.PeriodSetID}'"); } if (!string.IsNullOrEmpty(periodFilter.PeriodTypeID)) { queryStr.Append($@" and a.typeid='{periodFilter.PeriodTypeID}'"); } else if (!string.IsNullOrEmpty(periodFilter.PeriodTypeCode)) { queryStr.Append($@" and b.code='{periodFilter.PeriodTypeCode}'"); } DateTime defaultDateTime = new DateTime(); if (periodFilter.Time != null && !periodFilter.Time.Equals(defaultDateTime)) { queryStr.Append($@" and a.starttime <= '{periodFilter.Time}'"); queryStr.Append($@" and a.endtime >= '{periodFilter.Time}'"); } queryStr.Append($@" Order by a.name"); var ds = db.ExecuteDataSet(queryStr.ToString()); if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { list.Add(AssamblyPeriod(row)); } } return(list); }
public ReportsViewModel() { PeriodFilter = new PeriodFilter(); PeriodFilter.Periods.ForEach(p => p.IsActive = true); RefreshReports = ReactiveCommand.CreateFromTask(async() => { await loadDataAsync(); calcSummary(); }); RefreshReports.ThrownExceptions.Subscribe(async ex => await Interactions.ShowError(ex.Message)); PeriodFilter.PeriodChanged.Subscribe(p => { RefreshReports.Execute().Subscribe(); }); TimelineDayViewModel = new TimelineDayViewModel(); }
public PeriodSelectorControl() { InitializeComponent(); // init commands PrevDateRangeCommand = new Command(() => PeriodFilter.PrevDateRange()); NextDateRangeCommand = new Command(() => PeriodFilter.NextDateRange()); SelectDateRangeCommand = new Command(() => { var dateFrom = PeriodFilter.DateFrom; var dateUntil = PeriodFilter.DateUntil; if (this.ShowDateRangeSelector(ref dateFrom, ref dateUntil)) { PeriodFilter.DateFrom = dateFrom; PeriodFilter.DateUntil = dateUntil; } }); MainPanel.DataContext = this; }
/// <summary> /// Generates from & to filter dates /// </summary> /// <param name="fromDate">Output from date</param> /// <param name="toDate">Output to date</param> /// <param name="period">Period filter</param> /// <param name="from">Input from date</param> /// <param name="to">Input to date</param> /// <returns></returns> public static void GenerateFilterDates(out DateTime?fromDate, out DateTime?toDate, PeriodFilter period = PeriodFilter.ThisMonth, DateTime?from = null, DateTime?to = null) { if (period == PeriodFilter.Custom) { fromDate = from.MinTime(); toDate = to.MaxTime(); } else if (period == PeriodFilter.Today) { fromDate = DateTime.Today.MinTime(); toDate = DateTime.Today.MaxTime(); } else if (period == PeriodFilter.ThisWeek) { fromDate = DateTime.Now.StartOfWeek(DayOfWeek.Monday); toDate = DateTime.Now; } else if (period == PeriodFilter.ThisMonth) { fromDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1); toDate = DateTime.Now.Date.MaxTime(); } else if (period == PeriodFilter.LastMonth) { fromDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddMonths(-1); toDate = fromDate.Value.AddMonths(1).AddTicks(-1); } else if (period == PeriodFilter.ThisYear) { fromDate = new DateTime(DateTime.Today.Year, 1, 1); toDate = DateTime.Now; } else if (period == PeriodFilter.LastYear) { fromDate = new DateTime(DateTime.Today.Year - 1, 1, 1); toDate = (new DateTime(DateTime.Today.Year - 1, 12, 31)).MaxTime(); } else if (period == PeriodFilter.LastTwoYears) { fromDate = new DateTime(DateTime.Today.Year - 1, 1, 1); toDate = DateTime.Now; } else if (period == PeriodFilter.LastFiveYears) { fromDate = new DateTime(DateTime.Today.Year - 4, 1, 1); toDate = DateTime.Now; } else { fromDate = (DateTime?)null; toDate = (DateTime?)null; } }
public OrdersViewModel() { PeriodFilter = new PeriodFilter(); PeriodFilter.Periods.ForEach(p => p.IsActive = true); PeriodFilter.PeriodChanged.Select(p => 0).InvokeCommand(LoadItems); Items.ShapeView().OrderBy(p => p.InTime).Apply(); Items.ShapeView().GroupBy(p => p.InTime.Date).Apply(); EditorViewModel = new OrderEditorViewModel(); EditorViewModel.Save.Subscribe(id => { if (EditorViewModel.EditingItem.InDate < PeriodFilter.StartDate || EditorViewModel.EditingItem.InDate > PeriodFilter.EndDate) { PeriodFilter.SetManualDate(EditorViewModel.EditingItem.InTime.Date); } LoadItems.Execute(id).Subscribe(); }); SetReady = ReactiveCommand.Create(() => { using (var db = DbService.GetDb()) { var manager = new OrderManager(db); if (IsMultiSelect == false) { manager.ValidateAndSetReadiness(SelectedItem, true); } else { db.BeginTransaction(); manager.SetReadiness(Items.OnlySelected(), true); db.CommitTransaction(); } } }, canMultiEdit); SetReady.Select(p => 0).InvokeCommand(LoadItems); SetReady.ThrownExceptions.Subscribe(async ex => await Interactions.ShowError(ex.Message)); SetUnready = ReactiveCommand.Create(() => { using (var db = DbService.GetDb()) { var manager = new OrderManager(db); if (IsMultiSelect == false) { manager.ValidateAndSetReadiness(SelectedItem, false); } else { db.BeginTransaction(); manager.SetReadiness(Items.OnlySelected(), false); db.CommitTransaction(); } } }, canMultiEdit); SetUnready.Select(p => 0).InvokeCommand(LoadItems); SwitchReadiness = ReactiveCommand.Create(() => { EntityManagerService.DefaultOrderManager.ValidateAndSetReadiness(SelectedItem, !SelectedItem.IsClosed); }, canEdit); SwitchReadiness.Select(p => 0).InvokeCommand(LoadItems); SwitchReadiness.ThrownExceptions.Subscribe(async ex => await Interactions.ShowError(ex.Message)); DaySummaryViewModel = new DaySummaryViewModel(); ShowDaySummary = ReactiveCommand.Create <DateTime>((day) => { DaySummaryViewModel.Init(day); }); Print = ReactiveCommand.CreateFromTask(async() => { if (SelectedItem.IsClosed == false) { await Interactions.ShowError("Заезд не закрыт!"); return; } var report = new OrderForClientReport("Reports/ReportResources/OrderForClient.frx"); report.ShowReport(SelectedItem.ID); }, canEdit); }
public List <Period> GetPeriodByFilter(PeriodFilter periodFilter) { return(manager.GetPeriodByFilter(periodFilter)); }
internal List <Period> GetPeriodByFilter(PeriodFilter periodFilter) { List <Period> cycles = dac.GetPeriodByFilter(periodFilter); return(cycles); }