Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6
This is the forum to discuss the Wrox book ASP.NET 2.0 Instant Results by Imar Spaanjaars, Paul Wilton, Shawn Livermore; ISBN: 9780471749516
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 31st, 2006, 10:33 AM
Authorized User
 
Join Date: Jul 2006
Location: , , .
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default Building my own ticket tracker

Imar,

I'm using the bug base as an example to build off of. Im creating a web application for the company I work for, a work ticket system for the IT department which allows users to create tickets and see their open tickets and allows IT dept. personnel to see the tickets and to edit them, serach them. In building this do you suggest I work at the backend, creating the stored procedures and database then the data access layer, then the business layer, then finally the presentation layer?

thanks justin

  #2 (permalink)  
Old August 31st, 2006, 10:43 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

I think it depends on your preferences.

Personally, I like to start looking at things from the business side. Once I understand what it's all about, I can design business classes. From there, I can see what data my business objects needs so I can design and create the DAL, stored procedures and database.

But, whatever works best for you is the best way to go.... ;)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
  #3 (permalink)  
Old August 31st, 2006, 10:58 AM
Authorized User
 
Join Date: Jul 2006
Location: , , .
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That is sort of the way i was leaning. thanks.
When you built this app what was the first thing you did?


Before I bought this book, the wall I hit was how to deal with objects
or information like lookup tables, and the nature of having an ID and a description. The description is needed for the user and useless to the database, and vce versa with the ID or value key. The problem is translating that into something that works in the user interface...gridview and controls like that did not work and didnt fit the problem. I was really struggling with this till I came upon the solution that you created. To use a class, Namevalue, which stores both...Im still going through the code and trying to get a real grasp of everything thats going on, but I think this is exactly what I needed...

  #4 (permalink)  
Old August 31st, 2006, 11:04 AM
Imar's Avatar
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

I started looking at objects like Bug. From there, I saw I needed stuff like Severity, so I came up with the NameValue class.

But, in reality it's a bit more complicated than that. Often when you're building the DAL, you realize you need stuff in the business layer and vice versa. So, all in all, it's not a linear process.

This will be my last post for a while, so I won't be able to answer any follow up questions.

Cheers and have fun with the book,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help - How to create a Login tracker? melvados Visual Basic 2005 Basics 3 August 4th, 2008 09:07 AM
Error Creating Project Time Tracker Database flashmanTom SQL Language 0 January 15th, 2008 04:09 PM
Automatically expire authorization ticket LarryB ASP.NET 1.0 and 1.1 Basics 1 October 16th, 2007 12:30 PM
Problem with creating SQL Project Time Tracker Jim Dean BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 5 August 31st, 2006 12:23 PM
Retrieving a ticket number from spl database Calibus Classic ASP Databases 16 June 29th, 2004 03:49 PM



All times are GMT -4. The time now is 03:48 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.