Click here to Skip to main content
15,867,308 members
Articles / Programming Languages / Visual Basic

TeamVision

Rate me:
Please Sign up or sign in to vote.
3.08/5 (11 votes)
16 Nov 2009CPL3 min read 83.6K   5.4K   69   25
A simple project task management application. A managed approach to help keep on top of your projects.
Sample Image - maximum width is 600 pixels

Version 3.0

  • Upgraded to SQLExpress datasource
  • Removed references to Interop.Excel
  • Updated Data Access Framework

Technologies and Design Approaches Demonstrated

  • Application offline and online model
  • Authorization to control user access to application features
  • Printing and Print Preview
  • Windows XP Themes
  • Dynamic properties
  • Localization support
  • Accessibility support (limited)
  • Forms authentication using a database for user names/passwords
  • Asynchronous XML service class
  • ADO.NET data access using Microsoft Access SQLExpress 2008 database
  • Graphics development using GDI+
  • Integration between .NET Framework-based code and COM applications (COM interop)
  • The interop assemblies are available from Microsoft as a free download (obsolete)
  • Microsoft Visual Studio 2008

What is the TeamVision Solution?

TeamVision was originally based upon the TaskVision code sample offered via the WindowsForms website. TeamVision is a simple task management application built using the Windows Forms classes of the Microsoft® .NET Framework—an integral Windows® component that supports building and running the next generation of applications. TeamVision allows authenticated users to view, modify, and add projects and tasks that are shared with other users. It may be used in any number of scenarios, from bug tracking to managing work orders or customer service requests. Its primary purpose is to provide quality, sample source code to developers interested in building data-centric applications with ADO.NET using the .NET Framework.

Solution Architecture

Database

All of the shared data is stored in the database. This does not include application specific data or configuration settings. This allows developers to create custom applications, each pulling from a single unique data store. This article provides an overview of the database used in the TeamVision solution.

Models

The TeamVision model schema, is fairly simple, yet ample enough to support this task management solution. Each Concrete Model class derives from a base Model class and must implement at least two properties, PrimaryID and Name.
From there, we get a business class which holds other related class information, and acts as a proxy to that info.

Image 2

Figure 1 - Model class diagram

Data Managers

The data layer includes Management (Manager) classes that act as an information services wrapper to retrieve and fill all request for data.

Image 3

Figure 2 - Project Data Manager

Data Access Layer

The DAL provides the functionality for client applications to retrieve and change data, and, with the help of the Data Layer Component, is able to send each request back to a user. The DAL runs in a separate application space which allows for easy changes to the database schema. Every public DAL method is a CLS supported method and allows data to be easily passed within the call.

Using the Code

Image 4

Figure 3 - Example Load All

Image 5

Figure 4 - Get by PrimaryID

Image 6

Figure 5 - Insert example

User Interface

As the Main form handles events such as opening the Search form, the DataLayer object is passed to the new form, providing access to the same data that the Main form is privileged to.

Lessons Learned

TeamVision is a simple solution intended to demonstrate many of the powerful capabilities of smart client applications built using the .NET Framework. Like many projects, TeamVision had its share of growth and opportunities throughout the development phase. However, I hope that through examination of the code you will gain valuable insight in your next development project.

Notes

To log-in to the application, use the following credentials:

  • username: "jdoe"
  • password: "welcome"

License

This article, along with any associated source code and files, is licensed under The Common Public License Version 1.0 (CPL)


Written By
Founder Arkitech EBC Corporation
United States United States
MS, BBA, software developer, consultant, and trainer. Specializing in building data-centric applications designed for business, university, community & faith based organizations. Started developing Excel VBA macros and never looked back. Freelance developer utilizing VB.Net, SQL Server, Microsoft Access, and ASP.Net.

Comments and Discussions

 
QuestionIncorrect Username & Passsword Pin
Crimson1st19-Nov-20 7:35
Crimson1st19-Nov-20 7:35 
Questioncorrect Username and password Pin
ahamedgad22-Nov-14 10:17
ahamedgad22-Nov-14 10:17 
QuestionHow can I make my Framework source? Pin
linwenhai14-Oct-14 20:14
linwenhai14-Oct-14 20:14 
AnswerRe: How can I make my Framework source? Pin
Terence Wallace17-Oct-14 4:35
Terence Wallace17-Oct-14 4:35 
AnswerRe: How can I make my Framework source? Pin
Terence Wallace22-Jan-15 8:14
Terence Wallace22-Jan-15 8:14 
QuestionUsername & Password ? Pin
maq221-Sep-13 10:10
maq221-Sep-13 10:10 
AnswerRe: Username & Password ? Pin
Terence Wallace23-Sep-13 15:13
Terence Wallace23-Sep-13 15:13 
This project sample was completed 4yrs ago. I'm not sure what the password is.
"If you feel the urge to add complexity, just go home early. You ain't gonna need it." - YAGNI

GeneralRe: Username & Password ? Pin
Terence Wallace23-Sep-13 15:16
Terence Wallace23-Sep-13 15:16 
SuggestionRe: Username & Password ? Pin
maq226-Sep-13 10:54
maq226-Sep-13 10:54 
GeneralRe: Username & Password ? Pin
Terence Wallace2-Oct-13 6:14
Terence Wallace2-Oct-13 6:14 
AnswerRe: Username & Password ? Pin
ahamedgad22-Nov-14 10:15
ahamedgad22-Nov-14 10:15 
QuestionI Can Not Open Data Pin
pooyasamaneh29-Oct-12 0:11
pooyasamaneh29-Oct-12 0:11 
QuestionHow to setup this project in visual studio ? Pin
thegame4518-Sep-12 19:42
thegame4518-Sep-12 19:42 
AnswerRe: How to setup this project in visual studio ? Pin
Terence Wallace24-Sep-12 7:27
Terence Wallace24-Sep-12 7:27 
GeneralUsername and Password Pin
pilly99-Feb-11 11:45
pilly99-Feb-11 11:45 
GeneralFor NR Pin
konikula28-Dec-09 13:37
konikula28-Dec-09 13:37 
General[Message Deleted] Pin
konikula20-Dec-09 13:07
konikula20-Dec-09 13:07 
GeneralRe: Nope Pin
Terence Wallace20-Dec-09 14:56
Terence Wallace20-Dec-09 14:56 
QuestionWhat if you don't have Office 2003 installed? Pin
DJ Matthews2-Jun-09 10:17
DJ Matthews2-Jun-09 10:17 
AnswerRe: What if you don't have Office 2003 installed? Pin
Terence Wallace2-Jun-09 10:21
Terence Wallace2-Jun-09 10:21 
GeneralRe: What if you don't have Office 2003 installed? Pin
DJ Matthews3-Jun-09 2:59
DJ Matthews3-Jun-09 2:59 
GeneralRe: What if you don't have Office 2003 installed? Pin
DJ Matthews3-Jun-09 5:09
DJ Matthews3-Jun-09 5:09 
GeneralRe: What if you don't have Office 2003 installed? Pin
Terence Wallace3-Jun-09 5:18
Terence Wallace3-Jun-09 5:18 
QuestionRelease build? Pin
J. Veurink20-Aug-06 20:25
J. Veurink20-Aug-06 20:25 
GeneralArticle formatting suggestion Pin
The_Mega_ZZTer20-Aug-06 14:24
The_Mega_ZZTer20-Aug-06 14:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.