StrataFrame Forum » Updates and Information » StrataFrame Users Contributed Samples » Date Range Selector user control

Date Range Selector user control

Edhy Rijo — Sat, 19 Nov 2011 11:57:52 GMT

Hi All,

I am very exited with recent announcement of the StrataFrame Team for the 2012 Roadmap so with that in mind I would like to share with the community my first ever workable :D user control, it is a VB.

This DateRangeSelector user controls allows you to select a pre-defined date periods like Today, This Week-To-Date, This Year, Last Year and many more as well as a Custom Date that will allow the end user to select Start and End dates.

Useful features:

Selected date will used StrataFrame functionality to store that selection in the Registry if the Form's RegistryRepositoryKey is filled.
Public properties to pre-select a date range or each Start and End date values. Look at the "+Progytech: Actions" group in the property sheet.
A SelectedValueChanged event is triggered whenever the date range period has changed. Use this event to fill your BOs or requery your listviews.
The StrataFrame custom error provider is used to validate that the date range is good before passing the values to any method.
Internally we are expecting the based class used as MicroFour.StrataFrame.UI.Windows.Forms.StandardForm but feel free to use your own base class.

For learning purpose, I tried to keep this sample project as simple as possible, but in the bizOrders.vb business object I am using a Custom Field Property to show the Customer Name and this field is filled from the FillByDateRange() method in this BO which uses a SQL Query with a JOIN condition to grab the Customer Name as cfp_CustomerName and take advantage of StrataFrame Custom Field Properties functinality.

I hope this sample can be useful to the community and please, feel free to exchange your comments, suggestions and any enhancements to make this User Control better.

Enjoy!!!

RE: Date Range Selector user control

Ivan George Borges — Sat, 19 Nov 2011 11:57:52 GMT

Life to Date would be everything from the past till today.

Life to Future would be everything from the past till everything in the future. So, everything. :D

And Today to Future, of course, from Today onwards.

RE: Date Range Selector user control

Edhy Rijo — Sat, 19 Nov 2011 10:23:22 GMT

Thanks Ivan, Russell,

Ivan, about your Enum, there are some like LifeToDate which I don't quite understand, but i believe these are specific to your application, right?
For now I just implemented the ones I needed so the end user would not be overwhelm with options not applicable to the application.

RE: Date Range Selector user control

Russell Scott Brown — Sat, 19 Nov 2011 08:22:48 GMT

Very slick and useful.

Thanks Edhy!

RE: Date Range Selector user control

Ivan George Borges — Fri, 18 Nov 2011 16:25:05 GMT

Well done Edhy! ;)

Here is the Enum I populate mine with, there are some you might want to implement:

[codesnippet]''' <summary>
''' Pre-defined Dates Interval
''' </summary>
''' <remarks></remarks>
Public Enum PreDefinedPeriods As Integer
    <EnumDisplayValue("PFNTEnum - DefinedBelow", True)> _
    DefinedBelow = 1
    <EnumDisplayValue("PFNTEnum - Today", True)> _
    Today = 2
    <EnumDisplayValue("PFNTEnum - LifeToDate", True)> _
    LifeToDate = 3
    <EnumDisplayValue("PFNTEnum - LifeToFuture", True)> _
    LifeToFuture = 4
    <EnumDisplayValue("PFNTEnum - TodayToFuture", True)> _
    TodayToFuture = 5
    <EnumDisplayValue("PFNTEnum - CurrentWeek", True)> _
    CurrentWeek = 6
    <EnumDisplayValue("PFNTEnum - CurrentMonth", True)> _
    CurrentMonth = 7
    <EnumDisplayValue("PFNTEnum - CurrentQuarter", True)> _
    CurrentQuarter = 8
    <EnumDisplayValue("PFNTEnum - CurrentYear", True)> _
    CurrentYear = 9
    <EnumDisplayValue("PFNTEnum - MonthToDate", True)> _
    MonthToDate = 10
    <EnumDisplayValue("PFNTEnum - QuarterToDate", True)> _
    QuarterToDate = 11
    <EnumDisplayValue("PFNTEnum - YearToDate", True)> _
    YearToDate = 12
    <EnumDisplayValue("PFNTEnum - LastWeek", True)> _
    LastWeek = 13
    <EnumDisplayValue("PFNTEnum - LastMonth", True)> _
    LastMonth = 14
    <EnumDisplayValue("PFNTEnum - LastQuarter", True)> _
    LastQuarter = 15
    <EnumDisplayValue("PFNTEnum - LastYear", True)> _
    LastYear = 16
    <EnumDisplayValue("PFNTEnum - NextWeek", True)> _
    NextWeek = 17
    <EnumDisplayValue("PFNTEnum - NextMonth", True)> _
    NextMonth = 18
End Enum[/codesnippet]