Click here to Skip to main content
15,942,934 members
Home / Discussions / C#
   

C#

 
GeneralRe: Collection within a Collection and "loading" advice Pin
James T. Johnson23-Oct-02 2:28
James T. Johnson23-Oct-02 2:28 
GeneralRe: Collection within a Collection and "loading" advice Pin
Paul Watson23-Oct-02 3:12
sitebuilderPaul Watson23-Oct-02 3:12 
GeneralRe: Collection within a Collection and "loading" advice Pin
James T. Johnson23-Oct-02 3:26
James T. Johnson23-Oct-02 3:26 
GeneralRe: Collection within a Collection and "loading" advice Pin
Daniel Turini23-Oct-02 1:23
Daniel Turini23-Oct-02 1:23 
GeneralRe: Collection within a Collection and "loading" advice Pin
Paul Watson23-Oct-02 2:05
sitebuilderPaul Watson23-Oct-02 2:05 
GeneralRe: Collection within a Collection and "loading" advice Pin
Daniel Turini23-Oct-02 2:22
Daniel Turini23-Oct-02 2:22 
GeneralRe: Collection within a Collection and "loading" advice Pin
Jon Rista23-Oct-02 18:33
Jon Rista23-Oct-02 18:33 
GeneralRe: Collection within a Collection and "loading" advice Pin
Paul Watson23-Oct-02 21:19
sitebuilderPaul Watson23-Oct-02 21:19 
Jon Rista wrote:
your client to upgrade to MS SQL Server

We are using MS SQL server and I am making use of views and stored procedures. First off views are a touch limited and I am no pro at stored procedures (where is the intellisense! Big Grin | :-D .)

For instance part of pulling the product out of the database involves checking the users delivery country, checking various special offers and special rules and then calculating the price. It gets complicated because each order can contain multiple delivery addresses (e.g. you buy three items, two for yourself and one for a friend) and each item is priced according to weight, type and time of year. There is also gift wrapping, gift tags and multiple VAT rules (including the fact that some products are exempt from VAT in certain countries due to their type.)

So basically there is a lot of "business logic" going on which is all calculated from the base data.

Now I thought that was the whole point of classes and a data abstraction layer. i.e. The database persists data. Store procedures and views provide the data (and to some extent stored procedures do business logic) to the classes and then the classes do various calculations and offer up that data in a nice usable way for the programmer to implement into a nice UI.

You mention DataSets (and so did Paul) but how is that going to improve things? Surely I am still going to have to encapsulate all the business logic somewhere and still then provide the DataSet data up for use to the front-end (or do DataSets allow for "complex" calculations to take place "inside" them in some way?)


Anyway thanks for the interest Smile | :)

Paul Watson
Bluegrass
Cape Town, South Africa

GeneralRe: Collection within a Collection and "loading" advice Pin
Jon Rista27-Oct-02 17:48
Jon Rista27-Oct-02 17:48 
Questionthread.Abort() doesn't work????? Pin
fftongzhi22-Oct-02 15:23
fftongzhi22-Oct-02 15:23 
AnswerRe: thread.Abort() doesn't work????? Pin
Paul Riley23-Oct-02 0:17
Paul Riley23-Oct-02 0:17 
GeneralRe: thread.Abort() doesn't work????? Pin
James T. Johnson23-Oct-02 0:58
James T. Johnson23-Oct-02 0:58 
GeneralRe: thread.Abort() doesn't work????? Pin
fftongzhi23-Oct-02 16:04
fftongzhi23-Oct-02 16:04 
GeneralRe: thread.Abort() doesn't work????? Pin
James T. Johnson23-Oct-02 16:57
James T. Johnson23-Oct-02 16:57 
GeneralRe: thread.Abort() doesn't work????? Pin
fftongzhi23-Oct-02 18:51
fftongzhi23-Oct-02 18:51 
GeneralRe: thread.Abort() doesn't work????? Pin
Jon Rista23-Oct-02 17:51
Jon Rista23-Oct-02 17:51 
GeneralRe: thread.Abort() doesn't work????? Pin
James T. Johnson23-Oct-02 18:39
James T. Johnson23-Oct-02 18:39 
GeneralHelp about .NET windows service solutions Pin
Member 13227322-Oct-02 5:07
Member 13227322-Oct-02 5:07 
Questionplease try it...see what happens...is it a bug? Pin
Atilla Selem22-Oct-02 4:36
Atilla Selem22-Oct-02 4:36 
AnswerRe: please try it...see what happens...is it a bug? Pin
Daniel Turini22-Oct-02 4:43
Daniel Turini22-Oct-02 4:43 
GeneralRe: please try it...see what happens...is it a bug? Pin
Atilla Selem22-Oct-02 5:51
Atilla Selem22-Oct-02 5:51 
Generalcoding conventions.... Pin
waleed riaz21-Oct-02 22:18
waleed riaz21-Oct-02 22:18 
GeneralRe: coding conventions.... Pin
Stephane Rodriguez.21-Oct-02 22:28
Stephane Rodriguez.21-Oct-02 22:28 
GeneralRe: coding conventions.... Pin
Daniel Turini21-Oct-02 22:30
Daniel Turini21-Oct-02 22:30 
GeneralRe: coding conventions.... Pin
waleed riaz22-Oct-02 9:35
waleed riaz22-Oct-02 9:35 

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.