Employee Info Starter Kit

NEW POST: Any documentation/tutorial ?

elxany — Thu, 21 Aug 2008 12:15:11 GMT

Hi, thanks for quick reply.

Is it possible to place a "quick start" steps that will made this project better understandable for mid-level guys?

NEW POST: Any documentation/tutorial ?

joycsc — Thu, 21 Aug 2008 10:38:27 GMT

Thanks for your input. We'll write articles/books/read-me very soon about it and will provide links for those documentation. Stay tuned!

elxany wrote:
Hi,

Thank you for the job that you have done!
It is interesting project that have good stuff to share.

It is interesting to me, did you guys create any simple documentation/tutorial for new starters?
Because, personally i find it difficult to figure out, what you exactly did, and how properly install and use this kit?

Is this kit a stable release?
I mean, does all pages are connected?

Please, put a clear and simple document so that interested people can properly set up this starter kit.

Regards

NEW POST: Any documentation/tutorial ?

elxany — Wed, 20 Aug 2008 22:09:03 GMT

Hi,

Thank you for the job that you have done!
It is interesting project that have good stuff to share.

It is interesting to me, did you guys create any simple documentation/tutorial for new starters?
Because, personally i find it difficult to figure out, what you exactly did, and how properly install and use this kit?

Is this kit a stable release?
I mean, does all pages are connected?

Please, put a clear and simple document so that interested people can properly set up this starter kit.

Regards

NEW POST: Opening Employee Info Starter Kit with VWD

jjafer — Fri, 15 Aug 2008 05:07:04 GMT

Hi-
1. I have both Visual Web developer and VS 2005 installed on my machine. Basically I have problem VS 2005 (debugging doesn't work even after several attempts to
reinstall VS 2005) and decided to use Visual web developer. I want to know how to open the Employee Info Project in Visual Web Developer. The sln files by default use
VS 2005.

2. How a data connection was automatically created for "TESTEMPLOYEEINFOSK.MDF" provided along with starter kit?

Regards,
Jafer

NEW POST: Install

joycsc — Wed, 23 Jul 2008 13:59:07 GMT

You can comment that line, otherwise you have to use VS.NET 2005/2008.

gwtech wrote:
Line 20 in the Global can't find Utilities. I'm using Visual Web Dev. Made the db and ran the scripts. What am I missing?

NEW POST: Starter Database for the Kit

joycsc — Wed, 23 Jul 2008 13:51:55 GMT

Although database file/scripts are included with source code, for your convenience we have also included a seperate download of database script. Download it from here: http://code.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=eisk&DownloadId=2584

Please setup the database using the given script if you find any problem to attach the database.

bmc410 wrote:
Can't even attach the database. I'm not a newbie, I've done this plenty of times. I receive a "Cannot find row in sysindexes for database ID..."
I'm trying to attach using SQL 2005. Was this database successfully detached?

NEW POST: Starter Database for the Kit

bmc410 — Wed, 23 Jul 2008 12:28:40 GMT

Can't even attach the database. I'm not a newbie, I've done this plenty of times. I receive a "Cannot find row in sysindexes for database ID..."
I'm trying to attach using SQL 2005. Was this database successfully detached?

NEW POST: Install

gwtech — Tue, 22 Jul 2008 16:50:57 GMT

Line 20 in the Global can't find Utilities. I'm using Visual Web Dev. Made the db and ran the scripts. What am I missing?

NEW POST: Starter Database for the Kit

joycsc — Fri, 18 Jul 2008 06:09:30 GMT

Although database file/scripts are includes with source code, for your convenience we have also included a seperate download of database script. Download it from here: http://code.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=eisk&DownloadId=2584

pnkjk wrote:
Are you guys also planning to ship a sample database for the starter kit? I couldn't find one in this section of the site...

UPDATED RELEASE: v1.2.1 (Apr 09, 2008)

Thu, 17 Jul 2008 09:51:40 GMT

===============================================
Technology Features :-
===============================================

- .net 2.0 generic type
- .net 2.0 nullable type
- asp.net 2.0 object data source
- asp.net 2.0 grid view
- asp.net 2.0 form view
- asp.net 2.0 skin
- asp.net 2.0 theme
- asp.net 2.0 master (nested)
- sql server 2005 xml type
- sql server 2005 paging support

===============================================
Validation :-
===============================================

Validation -- XHTML 1.1, CSS level 2.1, WCAG 1, ABS 508
Validation -- MS Guideline (except CA1058)

===============================================
Basic Features :-
===============================================

------- ******* User Interface ****** --------

- Design template (MS SIMPLE)
- Client side calender control
- Grid view client side select all feature
- Grid view delete confirmation feature
- Form view data pre-fill feature
- Databound dropdown with 'All'/'None' selector field
- Print page
- Context parameter based listing/details page
- Client end validations
- Content upload in SQL Server

------- ******* Utility Class ****** --------

- Error reporting
- Friedly error page
- Email functionality
- Html formatter
- Login utility
- File upload utility
- Role based (cache based) security
- Session expire base page
- Session manager
- Keys
- Enumeration

------- ******* Cache Layer ****** --------

CRUD Methods :-

- Get All Entity
- Get By Primary Key
- Create New Entity
- Update Entity

Utility Methods :-

- Get cache key
- Get cache item
- Add cache item
- Invalidate cache

------- ******* Command Wrapper ****** --------

Methods :-
- Scalar Value
- Custom Entity Single Record
- Custom Entity Tabular
- Custom Entity Tabular Collection
- Generic DataTable
- Generic DataSet
- Write Return Success
- Write Return PrimaryKey

------- ******* Data Access Layer (Entity Level) --------

- System.Data.SqlTypes for data property fields
- Create and Update Method with primitive type paramaters for Object Data Source Support
- Design time support for Object Data Source
- Works for only auto-generated primary key
- .Net 2.0 Generic Collection Support
- Isolation for Stored Procedure Name Constants
- XML Comments (useful for nDoc utility)
- Validation for method parameters

Database Utility Methods :-

* Generate collection for reader delegate
* Add parameter to sql command method
* Execute scalar command method
* Execute reader method
* Format xml for id array method

CRUD Methods :-

CREATE METHODS
* Statis method with data fileds as method parameter
* Statis method with business entity as method parameter
* Instance method, without any parameter

UPDATE METHODS
* Statis method with data fileds as method parameter
* Statis method with business entity as method parameter
* Instance method, without any parameter

GET BY PRIMARY KEY METHOD
* Method that gets a single record

GET BY FOREIGN KEY METHOD
* Method that returns a collection of records based on the foreign key

GET BY FOREIGN KEY - PAGED
* Method that returns paged result for the provided foreign key
* Count method being used when using paging method

GET ALL
* Gets all of the records for the corresponding entity

GET ALL PAGED (USING SQL SERVER 2005 PAGING SUPPORT)
* Method that returns paged result for the provided foreign key
* Count method being used when using paging method

DELETE BY ID
* Deletes a record using the primary key

BATCH DELETE (USING SQL SERVER 2005 XML TYPE)
* Deletes a set of records, based on the passed paramter of list of Id's as xml data

Major Version Features :-

1. Auto-increment primary key (integer type)
2. Container class with System.Data.SqlTypes data fields

UPDATED RELEASE: v1.2.1 (Apr 09, 2008)

Thu, 17 Jul 2008 09:13:46 GMT

UPDATED RELEASE: v1.2.1 (Apr 09, 2008)

Thu, 17 Jul 2008 09:11:50 GMT

UPDATED RELEASE: v1.2.1 (Apr 09, 2008)

Thu, 17 Jul 2008 08:41:46 GMT

UPDATED RELEASE: v1.2.1 (Apr 09, 2008)

Thu, 17 Jul 2008 08:37:32 GMT

UPDATED RELEASE: v1.2.1 (Apr 09, 2008)

Thu, 17 Jul 2008 06:03:14 GMT

NEW POST: Starter Database for the Kit

joycsc — Wed, 02 Jul 2008 12:49:09 GMT

The starter database is there. If you run the script, please make sure you are SQL Server 2005.

ks wrote:
I also could not find the database.
Downloaded the zip file and there is no App_Data folder in the solution.
Carried out a search and no mdf exists.
Also the script does not create any tables. Just seems to drop and re-create procedures.

NEW POST: Starter Database for the Kit

ks — Thu, 26 Jun 2008 07:57:46 GMT

I also could not find the database.
Downloaded the zip file and there is no App_Data folder in the solution.
Carried out a search and no mdf exists.
Also the script does not create any tables. Just seems to drop and re-create procedures.

NEW POST: Starter Database for the Kit

joycsc — Sat, 26 Apr 2008 05:02:35 GMT

Hi Thanks to ask.
You will find the mdf file in App_Data folder for "vs.net-2005-employee-info-starter-kit-installer" file.
Also for "employee-info-starter-kit-v1.2.1 " zip content you will find the database script in "\doc\db\script" location in the website.
In later versions we'll put more help instructions and easy deployment stuffs.
Thanks again.

NEW POST: Starter Database for the Kit

pnkjk — Wed, 23 Apr 2008 06:33:14 GMT

Are you guys also planning to ship a sample database for the starter kit? I couldn't find one in this section of the site...

COMMENTED FEATURE: create a sample for guid primary key

topmcsd — Sat, 12 Apr 2008 05:26:24 GMT

we'll be shipping next version which will include create a sample for guid primary key
Comments: Please don't start using GUIDs, they are not a good practice in large tables. A GUIDs 128 bit does not fit in a 32 bit register.