|
I wanted to put some simple example code here to show how I am doing Data I/O between the BLL and the DL. Any comments would be great!
Data Layer DAO object:
public class CMItemDAO
{
public CMItemDAO()
{
//
// TODO: Add constructor logic here
//
}
public static IDataReader GetItems(int quantity, ItemManager.Item type)
{
string itemType = (type == ItemManager.Item.Document ? "SW" : "DOC");
String sSql = "SELECT CMLib_Key, CM_Number, Item_Name ";
sSql += "FROM ccdb.cclib WHERE Item_Type = :pITEMTYPE AND ROWNUM <= 10";
Database db = DatabaseFactory.CreateDatabase();
UserDBLogon(db, "xxxxxxxxx@xxxxxxxx.xxx", "WNhc(#111111111");
DbCommand cmd = db.GetSqlStringCommand(sSql);
db.AddInParameter(cmd, "pITEMTYPE", DbType.String, itemType);
return db.ExecuteReader(cmd);
}
------------How this is being called from the Business Layer:
public class ItemManager
{
public enum Item
{
Document,
Software
}
public ItemManager()
{
//
// TODO: Add constructor logic here
//
}
public static List<ICMItem> GetItems(int quantity, Item type)
{
Cache listCache = HttpRuntime.Cache;
List<ICMItem> list = new List<ICMItem>();
ICMItem iCMItem;
if (HttpRuntime.Cache["Item" + type.ToString()] != null &&
(HttpRuntime.Cache["Item" + type.ToString()] as List<ICMItem>).Count <= quantity)
{
list = ((HttpRuntime.Cache.Get("Item" + type.ToString()))) as List<ICMItem>;
list.RemoveRange(quantity, (list.Count - quantity));
}
else
{
using (IDataReader reader = CMItemDAO.GetItems(quantity, type))
{
while (reader.Read())
{
if (type == Item.Document)
iCMItem = new Document() as Document;
else
iCMItem = new Software();
iCMItem.CMLibraryKey = reader.GetInt32(0);
iCMItem.CMNumber = (string)reader[1];
if (reader.GetValue(2) != DBNull.Value)
iCMItem.ItemName = (string)reader.GetValue(2);
else
iCMItem.ItemName = "";
list.Add(iCMItem);
}
}
HttpRuntime.Cache.Insert("Item" + type.ToString(), list);
}
return list;
}
I hope this is not too much simple example code; however, any comments on how I am doing things would be great!
Thanks,
Steve
|
|
|
|
|
Business layer shouldn't know anything about the data layer internals. I mean data layer might be using database or some other data store. Business layer should be isolated. You are returning IDataReader instance and it tells your business layer knows about the data store. You should take a look at DTO (Data transfer object) for passing values between layers. (Information got from colin  )
|
|
|
|
|
Hello all ,
I have developed a ecommerce web site, for which i want to integrate the payment gateway using paypal.
I want to accept the credit card details, user details such as Shipping, and billing and the contact details in my website. And process the payment using the Direct Payment API.
I tried since 5 to 6 days in the internet to search the solution to this problem, but i didn't got a single resource.
Also in paypal developer community and in paypal website, they have mentioned that, the Direct Payment API method will be applicable only to the US Customers. So it is not possible me to download any resources for this method.
Can any body help me regarding this problem. if any one has the solution this problem, please reply, or please provide any links, or some sample code for this problem in Asp.Net with C#.
Thank you,
regards,
|
|
|
|
|
Your best bet is to talk to the PayPal support folks and see if there are any other options opened to you.
Life, family, faith: Give me a visit.
From my latest post: "And you think, 'To keep my anti-Judaic theology alive I must reinterpret this verse too as being a blessing for Christians and not for Jews. I know it strains all manner of principles of interpretation. I don’t read the newspaper this sloppily, but, man, I have a theology to defend.'"
Judah Himango
|
|
|
|
|
You have not google it correctly.............. google it u will find code for it ,, with hidden tags in it ..and runat="server" to those and supply the values dynamically
It is simple .. i will fwd the complete code if possible
If You win You need not Explain............
But If You Loose You Should not be there to Explain......
|
|
|
|
|
Use Google, I like their API better and use it for my purposes. Plus the TOS is so much better and the payment terms are more competitive. It is akin to having my own merchant account. (Google really should pay me for lauding their services so)
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
I have added a NotifyIcon in Console application, but I am having a hard time disposing off the icon when the application exits.
Can anyone tell me the way ?
Thanks.
|
|
|
|
|
What do you mean? Are you talking about the way the icon stays in the tray, even after tha application exits until you hover over it, at which time it finally goes?
Because if you are it happens with everything. Before you exit you need to set the NotifyIcon'svisible property to false, then it will dissapear.
My current favourite word is: I'm starting to run out of fav. words!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
He is running a NotifyIcon in Console app without a message pump...
|
|
|
|
|
Actually i think we resolved that, a few people gave answers and Ed Poor gave some example code.
My current favourite word is: I'm starting to run out of fav. words!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
ptr2void wrote: I have added a NotifyIcon in Console application, but I am having a hard time disposing off the icon when the application exits.
You will have a hard time for the rest of your life with that design, I have tried to offer alternatives, but you are just to stubborn to trust another's opinion.
ptr2void wrote: Can anyone tell me the way ?
THERE IS NO WAY.
|
|
|
|
|
Your in a good mood, i can tell. 
My current favourite word is: I'm starting to run out of fav. words!
-SK Genius
Game Programming articles start - here[ ^]-
|
|
|
|
|
SK Genius wrote: Your in a good mood, i can tell.
I just feel sorry for the square peg and the round hole ... 
|
|
|
|
|
Hello everyone,
If we use foreach to iterate a Dictionary, it is only restricted that we can not insert new elements and remove exsting elements of the Dictionary.
And we are free (allowed) to change the content (mmber fields) of object pointed by the "value" reference of a key, right? Example,
foreach (KeyCollection<> k in someDictionary)
{
someDictionary[k].someOperation();
}
thanks in advance,
George
|
|
|
|
|
George_George wrote: And we are free (allowed) to change the content (mmber fields) of object pointed by the "value" reference of a key, right?
hard to say, since I'm not sure what you mean. your foreach syntax is wrong. why not try out using your favorite ide?
|
|
|
|
|
|
As long as you only read the value from the collection, you can do anything you like with it. It's only when you change anything that the dictionary itself is aware of that the enumerator is invalidated.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
|
George, Your questions are pretty much great. You usually give good info, usually show some code, and you're definately polite....however some of your questions can be answered by just opening an IDE and trying things out. Thats how you learn and how you learn to not need help.
Just my 0.02
|
|
|
|
|
|
Yes, you're absolutely correct.
The only thing I'd like to add to your list of things we cannot do is: changing the order of the elements (by changing the key or whatever the elements are sorted on).
Everything else is fine.
Notes:
1. It is possible for someone to create an enumerable class (such as a dictionary) that supports all these operations from within a foreach loop. It all depends on how the enumerator and the rest of the class is implemented.
2. For performance reasons, enumerable classes are generally not thread-safe (unless the docs say they are). This means you have to think about not only what you do in the foreach loop, but also what other threads may be doing.
3. Testing this in the IDE (as someone suggested) may not help you much. It may work sometimes, and sometimes not, depending on how the dictionary is implemented, what it contains and exactly what you do. So the results may fool you.
Peter the small turnip
(1) It Has To Work. --RFC 1925[^]
|
|
|
|
|
Thanks PeterTheSwede,
Your reply is really great! I have a further question, why in current design of Dictionary, it is not allowed to add/remove elements or change the value of key (reorder factor is key)?
regards,
George
|
|
|
|
|
George_George wrote: why in current design of Dictionary, it is not allowed to add/remove elements
You can not change the dictionary while you are looping through it. If the dictionary would be able to handle that, it would have to be a lot more complex.
George_George wrote: or change the value of key
You can't change a key of an entry, as the key decides where the entry is stored. To store a value under a different key, you have to remove the entry and add the value using the new key.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Thanks Guffa,
I totally agree with you. Sorry I have not made myself understood. My question is, how Dictionary is designed internally so that we do not allow to insert/remove elements during foreach loop?
I want to know the basic idea about why the design of Dictionary is restricted to such operation.
regards,
George
|
|
|
|
|
There are some things that would be complicated, impractical, or even impossible, to handle correctly if a dictionary would allow adding and removing items during enumeration. For example:
If the dictionary would allow adding of items, it would have to always add the items at the end of the collection, so that the new items would always be handled at the end of the loop. This means that the dictionary can not reuse any previously released entries.
The enumerator contains a reference to the current item. If that item would be removed, the reference would point to an item that no longer is a part of the collection.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
