| Downloads | Support | Products | Purchase | Consulting | DBI |
> Special Product Upgrade Promotion - ending June 30th
> Staff Scheduler Pro v3.2 Upgrade
> Using LINQ Aggregate Functions
> Keyword and Key phrase automatic extraction
> Code Snippets
> Component-Based Consulting Services
> Quick Links
The Warehouse Shipments Scheduling Framework is a new developer product that brings together industry proven component software, standard shipping and warehousing business rules, a custom set of objects supporting those business rules along with integrated Databinding and packaged in a true N-Tier architecture. This is a source code solution replete with a complete developer toolset, custom objects, data bound sample application starting points, reporting and UI design layers.
http://www.dbi-tech.com/Frameworks/Products/dbiWSF-overview.aspx
The Warehouse Shipments Scheduling Framework is compatible with Visual Studio 2010 and is a Windows 7 certified product.
Upgrade a DBI component product, a competitive product or a Sedna components license and SAVE up to 40% !
Get the full details at :: https://www.dbi-tech.com/SpecialOffers.asp
https://www.dbi-tech.com/StaffSchedulerPro_SpecialUpgradeOffer.asp
Full details available at:
http://www.staff-scheduler.com
While working on an upcoming demo, we had a need to get a count of appointments of a particular type. In fleshing this concept out, we needed a few for-each-loops to determine what "apptTypes" were on a given day and then get a count of each. This sounded like it might be a good challenge for LINQ. Instead of making a hash table or key-pair dictionary we looked at some of the ways we could achieve what we were after. A quick test class to mimic a dbiAppointment with an apptType property and one LINQ statement to get the counts, then a second to get a total, and voila, we had all the information we needed in a very tidy code block.
VB6 Sample Code
Public StartDate As Date
Public EndDate As Date
Public ID As Guid
Public ApptType As Long
Public Sub New()
ID = Guid.NewGuid
End Sub
End Class
Public ApptColl As New System.Collections.Generic.List(Of PaulAppt)
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim curLINQ = From Appt In ApptColl _
Group Appt By Appt.ApptType Into Count() _
Select ApptType, TotalAppts = Count
For Each obj In curLINQ
Me.ListBox1.Items.Add(obj.ApptType.ToString + " | " + obj.TotalAppts.ToString)
Next
Dim sumLineTotal = (From curItem In curLINQ _
Select curItem.TotalAppts).Sum
Me.ListBox1.Items.Add(sumLineTotal.ToString)
End Sub
When you look under the covers of any DBi product, you'll find a bucket load of general and component specific code snippets. Open your DBi Product Manager, click on the Samples / Demo tab and your choice of IDE for a whole collection of feature specific code snippets.
advanced knowledge of DBI's component products.
Receive direct coding assistance with DBI Component-based products.
Start with DBI Component Services for:
> Appointment Scheduling
> Resource (Gantt style) Scheduling
> Integrating Extractor Document Summarization
> Building Reg Free COM applications
> Extending DBI .NET Controls
> Using the DBI Warehouse Scheduling Framework
Take advantage today!
http://dbi-tech.com/DBIComponentServices.aspx
http://www.dbi-tech.com/ProductPage_StudioControlsCOM.aspx
http://www.dbi-tech.com/ProductPage_StudioControls.NET.aspx
http://www.dbi-tech.com/ProductPage_SolutionsScheduleNET.aspx
http://www.dbi-tech.com/ProductPage_SolutionsSchedule.aspx
http://www.Staff-Scheduler.com
http://www.dbi-tech.com/productPage_Extractor.aspx
