Subject: Building my own ticket tracker
Posted By: cf2006 Post Date: 8/31/2006 10:33:00 AM
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

Reply By: Imar Reply Date: 8/31/2006 10:43:18 AM
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.
Reply By: cf2006 Reply Date: 8/31/2006 10:58:22 AM
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...

Reply By: Imar Reply Date: 8/31/2006 11:04:46 AM
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.

Go to topic 39369

Return to index page 188
Return to index page 187
Return to index page 186
Return to index page 185
Return to index page 184
Return to index page 183
Return to index page 182
Return to index page 181
Return to index page 180
Return to index page 179