|
Have you come up with any good ideas?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Dear All,
I've designed the basic retail management solution. Now my client is asking me include the promotion management into the system by each product or all. I hoping some guidance from whoever have already designed before. Mostly I'm looking at the database perspective (table design). the design should be flexible, it should cater for the following conditions:
* Buy X at a Discount (% or value)
* Buy X, Get Y at a Discount (% or Value) or for Free
* Buy N Qty X, Get Y at a Discount (% or Value) or for Free
* Buy X &Y, Get X at a Discount (% or Value) or for Free
* Buy X, Get X, Y & Z for Free
Hope somebody will give flexible design for the above mentioned combinations, there can be many more combinations, but i can only think of this for the moment.. If i missed out, kindly add up for my knowledge.
Regards
Yamiho
|
|
|
|
|
Have you come up with any good ideas?
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
plz can someone help me to get a FREE version of infragistics NetAdbantage for .Net from onother source of "www.infragistics.com" ?
|
|
|
|
|
Have you tried "infragistics.com"?
|
|
|
|
|
hi how are you
im name RAJA
where are you live
|
|
|
|
|
He wants it free ... i.e. warez.
Not only that but a cross post hehe.
|
|
|
|
|
While running my service i got Fault Exception Error "An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail."
Any one can help me pls.....
|
|
|
|
|
If anybody can send me State Machine Diagram for client-server communication,please send me as soon as possible.
Thanks
|
|
|
|
|
You're joking, right? Why should anyone send you the documentaion they wrote for their own systems?? Considering that this is a security risk in any organization, I seriously doubt you'll ever get someone to hand over their doc's...
|
|
|
|
|
Hi
I have been pondering this "problem" for a while now and thought I'd submit it here for some more ideas. (Hope I chose the right message board.)
Scenario: an application that allows users to generate quotes, obviously the quotes need some sort of sequential numbering. The problem is that it is a semi-connected application so the user could be generating the quote offline.
Question: What is the best way to go about generating a quote (reference) number?
Some of my ideas: the 1st would be something like a date-time stamp (including miliseconds) but this makes the number to long. You don't want the client reading a 16 digit number for reference purposes. I also though of including a type of employee code to increate the uniqueness but I don't think it will help too much.
Am I missing something or is this fairly impossible to do? Your comments will be great.
Thanks
Francois
|
|
|
|
|
In a semi connected environment its going to be extremely difficult to pull off sequential numbering at all. I'm assuming this is the scenario:
1. Your field guys may disconnect
2. Create an arbitary number of quotes
3. Give the client their quote number on the spot
4. Return and resync.
Point 2 can be solved if you can get them to create a pending quote on the way out for all their appointments, this might be a workaround. Point 3 prevents you from ever changing the quote number on resync, so you need to be certain its good.
I'd question the need for exact sequential numbering. Typically accountanty people like their invoice numbers to be sequential, but this doesnt prevent you from giving a reference number that can be generated on the spot. Generation would depend on your environment, something like field guy id dash, sequence number.
|
|
|
|
|
Thanks for your input Mark
I will definitely interrogate the reasoning behind HAVE TO HAVE a sequential numbering.
I thought of a workaround similar to your pending quote and that is that the field guy prerequests a few seq-reference numbers which is then allocated to him. No more allocated numbers left = can't create quote.
|
|
|
|
|
Does the quote ID have to be numeric or could you use a string? Does it have to be sequential or just unique within the system?
How about a combination of unique employee ID and time? Assuming it takes longer than a second to generate a quote then you would only need the date-time stamp with seconds. You could then encode this as a string in base 36 (all 26 letters and 10 numbers)
|
|
|
|
|
I am unable to install ODP.Net 2 version.
Does anybody have its installation steps
Thanx,
Mini
|
|
|
|
|
Have you looked into their documentation?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I'm looking at using RDL to define flat file exports, being the sections of the file and the record layout of the sections. It seems quite appropriate as many of the RDL elements already cater for grouping and totalling etc. I would just like a few pointers to resources on generating the RDL and maybe extending it slightly, to cater for fixed length fields etc. if anyone can steer me in the right direction.
"Once in Africa I lost the corkscrew and we were forced to live off food and water for weeks." - Ernest Hemingway
My New Blog
|
|
|
|
|
Hi all,
I am newbie here.
My Tech. environment: .Net and Sql Server
Problem:
Manyatimes, we need to return data from different tables in the database to the UI (for example, search results) whose schema wouldnt match with any of the domain objects.
In this case, one option is to transfer the data using the datasets/datatables feature provided by .Net.
The other option I could think of is to create business (DTO?) objects to just pass on the data from the DB to the UI.
I prefer the second approach. However, I need suggestions on how do I implement it? Will this DTO contain a reference of all the domain objects involved or Can I just include only the desired columns?
Or, do we have any other solution?
Thanks in advance,
AGL
|
|
|
|
|
I would suggest a seperate layer for the Data Definition.
passing of Data between the layers is required in almost all the cases. There are two different ways of doing this in .NET. One option you pointed-out.. using Generic Dataset. There is another way of handling this. By using Strongly Typed DataSet. A Typed-Dataset is similar to a Generic Dataset because it is derived from the Dataset class and inherits all the members of a dataset. But the only difference is the Typed dataset is created with the XML Schema representation of the Database Table and the corressponding class file. So it provides type-safe operation and all the methods, properties, events are defined and also it provides an excellent way to access the tables and columns using the names. The only disadvantage of using typed dataset is that it put slightly higher overload on the application.
We can have a seperate layer named DataDefinition and we can have all the database table's in the form of .xsd files which is the XML schema representation of the database tables.
Regards John
|
|
|
|
|
If you are looking at using an object-oriented data layer then you should read this article[^].
|
|
|
|
|
Hi
What do you recomend to populate custom objects from the database?
Let's say i have a "Product" object, and i have a Products table, each product has a "name", "Id","Stock","Type" etc.
Some times i need to get a couple of products while other times i need a large list of them,
So i build a Singleton "Products" class that has a "GetProduct(id)" method and a private Dictionary of products, each time a product is requested it first check if the product is in the dictionary, and if its not it calls a New Product(id) and add it to the dictionary.
Class Products
Public Shared Function GetProduct(id as integer) as product
if Cache.containskey(id) then return Cache(id)
return new product(id)
end function
End class
Then i have a constructor in the "product" Class that looks like this:
Sub New(id as integer)
Dim Comm as new sqlcommand("Select * from products where id=@id",ConnString)
comm.parameters.addwithvalue("@id",id)
Dim Reader as sqldatareader=comm.executereader
reader.read
idvalue=reader("Id")
Namevalue=reader("Name")
end sub
The problem i think is that when i need to get a large number of products i am making a lot of querys to the database, so i thougt of doing somenthing like this:
Class Product
Private Sub PopulateFromReader(r as datareader)
idvalue=reader("Id")
Namevalue=reader("Name")
end sub
Sub New(r as datareader)
me.PopulateFromReader(r)
end sub
Sub New(id as integer)
Dim Comm as new sqlcommand("Select * from products where id=@id",ConnString)
comm.parameters.addwithvalue("@id",id)
Dim Reader as sqldatareader=comm.executereader
me.PopulateFromReader(r)
end sub
End class
And then in the private constructor of the Singleton "Products" class i do somenthing like this:
Class Products
Private Cache as dictionary(of Integer,Product)
Private Sub New
Dim Comm as new sqlcommand("Select * from products",ConnString)
Dim Reader as sqldatareader=comm.executereader
do while reader.read
Cache.add(reader("id"),new product(reader)
loop
end sub
end class
So, what do you think i should do? is it ok? is there a "Correct" way to do it?
Thanks in advance
PS: Sorry my english!
|
|
|
|
|
You could try the free edition of Diamond Binding by following the link in my signature. This will pretty much do what you are after, without you having to write any code.
If you are really insistant on DIY you could tag all your fields with attributes and then write a templated base class that uses reflection to populate the fields. If you only have a few tables, it will probably be easier to not use a data layer at all to be honest.
What you've written will work, but you'll need to remember to keep your cache up to date when you insert/update records.
|
|
|
|
|
Mark Churchill wrote: If you are really insistant on DIY you could tag all your fields with attributes and then write a templated base class that uses reflection to populate the fields. If you only have a few tables, it will probably be easier to not use a data layer at all to be honest.
You might be interested an article here on CP, the Tale of the Three Monkeys or something like that, basically outlining pros and cons of using hand-written DALs, Reflection generated DALs and thirdly (whole point of the article) generated custom code using Reflection.Emit and DynamicMethod s. Just search google with monkey site:codeproject.com and it should be first link.
|
|
|
|
|
Hi
Does anyone know if there is any available (or up coming) seminar about Design Patterns in Europe.(In English language).
Thanks in advance
|
|
|
|
|
I don't know of any, but I can arrange one if you wish.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|