Architecture :: Handling Data From Two Tables?
Jul 17, 2010
I will try to explain my doubt and keep the code out, maybe for a second post. The greatest problem i am facing here is the logic :P.
At this point i have two tables: Empregado (Worker) and Cargo (Post). One post have many workers and one worker has only one post. In the database i think i am fine, a simple relationship one - many.
I've mapped the tables into classes with the same fields. As well i've created collections using generic lists. Each collection has a method that acess the bank and recover the data.
My worker class agregates one instance of post. I mainly use this to show the data i need. Basicaly i do a select, join the tables and fill the properties of the worker and the post.
The doubt: Is this a good pattern? Up to this moment i am not worried with blinding light performance, but in how to act in an good OOP pattern.
View 2 Replies
Similar Messages:
Jul 20, 2010
If an error happens in the DA_layer, how do I pass it do the code_bedhing to show the user?
[Code]....
View 3 Replies
May 28, 2010
I'm wondering what's the preferred way to manage exceptions in an MVP implemented with a Passive View.
There's a discussion in my company about putting try/catch blocks in the presenter or only in the view.
In my opinion the logical top level caller is the presenter (even if the actual one is the view).
Moreover I can test the presenter and not the view. This is the reason why I prefer to define a method in the view interface:
[Code]....
View 2 Replies
Jun 3, 2010
I devide my website on 3 layers :
DAL(Data Access) - simple extract data from DB using LINQ
BLL(Business Logic) -
cache data and in try/catch block call function from DAL and throw it to UI :
try
{
}
catch (Exception ex)
{
//Log error
throw ex
}
UI (User Interface) - simple working without handling any exception,
So if error occured in BLL i will be redirected to Error.aspx page with message that something wrong.
how and where handle exceptions, or may be exists common patter where handle and how to inform user about errors ? Can anybody share bes practice.
View 1 Replies
Jun 4, 2010
I need to design a good exception handling. That can include logging and user friendly error page etc I read more articles and got some ideas. I am not using Enterprise Library now.
View 4 Replies
Jun 17, 2010
I just can't wrap my head over this and don't have enough time to read long articles.
I already have an HTM Table on my form. I dynamically create New Roows and Cells and keep adding them to the Table .
The cells Contain Labels, Textboxes, Drop downs and Buttons. I also add Handlers to the dropdowns
The form loads perfectly the first time. But when I change the value in a drop down, on the postback, I get a msg saying that " There are multiple controls with the same name 'txtCheckin' . How do I handle this?
View 7 Replies
Apr 27, 2010
Even though I'm trying to implement exception handling in a multi-tiered Windows application, catching and throwing exceptions should be the same for Windows and Web (sans global.asax and web.config custom errors).
I have a webform with a texbox that displays exceptions. So my webform invokes a method in BusinessTier class which then invokes a method in DataTier class. How can I throw my DataTier method exception so it reaches my webform?
View 2 Replies
Nov 15, 2010
how do you treat situations where there is the need of storing collections of object belonging to an object not persisted on db (not yet). For example , suppose we have a web application for submitting orders. The user click on 'Create new order" , then insert order's data , choose items from a catalog and add them to the order. Finally he "submit" the order. I can see two different way to persiste data :
a) create on db an empty order instance when user click on "create new order" , so that the orderitems collection could be directly associated (saved) with that instance in the db.
b) keep all data in memory and finally save order and orderitem.
The b option imply storing (in session?) the orderitems collection till submit. Are there, probably, other solutions. Which are best practices in these situation?
View 4 Replies
Dec 29, 2010
Dynamic Exception handling in Saas application
View 3 Replies
Jan 20, 2011
Our site is expected to allow the user to do whatever they want from a number of different places. Except, that doing whatever they want really means firing off mini sequences of pages they must vist (or possibly abort from to go off to another task) before returning to their starting point. So, at any given time, the user has a list of pages they are allowed to go to, a list of pages they must go to in order to complete their task, and some end point they must eventually return to, all of which are constantly changing.
As an example, a user may choose to edit an order they placed, at which point they must step through a series of pages to edit the order. These pages to edit an order may be different based on the type of order they are editing, and they must return to whatever place they were at when they decided to start editing the order. They may also have certain options of other pages to visit during their order editing process.
I really need a good way to handle this for a large number of different scenarios, and allow it to be easily changed. Right now we are doing things like setting session variables when a user chooses an action and checking them within the page on button handlers to see what they are allowed to do or where they are allowed to go. I'd love to be able to abstract this out into something that can be easily examined in one place, or even data driven, and have some sort of navigation controller pointing them to the pages they can or must go.
View 6 Replies
Nov 12, 2010
I have a design question about whether to use sql tables or enums or both for a application I am developing for work.
Example - Gallery
Let say you have a database for displaying albums and photos. You want the ability to allow the user to set the display mode for the photos differnently in their albums i.e. LightBox, Scrolling, Single
Do you create an enum for DisplayModes so you can for example:
[Code]....
But then for reporting and admin you need to know the Album DisplayMode, so do you then have a SQL Table that just repeats the values of the enum?
View 3 Replies
Oct 20, 2010
I'm developing Web Desktop like Glide or Icloud. It's gonna be a web application that gives the real world desktop application functions.
The DBMS I'm goin' to use is SQL Server. Now, I'm designing the database schema, but having some problems with it. I've no idea what tables I've to include.
So far I've only Users, Folders, Files, RecycleBin, Contacts, ContactGroups tables, but it seems very few. May be I've missed something.
View 2 Replies
Aug 29, 2010
I am using ASP.NET (C# and sql server express 2005) for my web application project. I have three related tables. I want to do an insert using typed datasets,tableadapters and three tier architecture. I wish to know how to do simultaneous inserts in 3 tables. So i wish to insert a row in first table and get its primary key. Same with the second table. I will use the primary keys of those first two tables to do the insert in the third table. How can i accomplish this using formview control and what methods should i use??
View 3 Replies
Feb 2, 2011
I have been using Sql Server since 2003, and still encouter situations that are just hard to solve :)I know it's a an sql server question, but since it's from a methodology and architecture point of vue, I thought it fit in this forum I am facing a sort of conflict with my current customer :An old sql server database, migrated from sql server 2000 to sql server 2008 (2003 project), which serves an asp.net application and cubes.naming of tables are like the following : tbl_ and Vw and yet procedures have no underscores. The database contains no functions.All object names are abbreviated, without any dictionary to understand what they mean. We have to ask every time.We developed a new module, and followed Pascal Casing, with clear words for the tables meaning.The customer makes a code review and says, that object are not correctly named :) and the meaning of tables is not clear. Names like AnalyticsAxis, is simply not clear. We also are asked to follow tbl.
View 1 Replies
Mar 11, 2010
So this interface allows one server to request data from another server. The catch is that all xml for the interface is transmitted entirely over http posts followed by an empty status code 200 response. No data is sent in a response. So if my application wants to requests data, we send an http post with the xml request and receive a blank 200. Then, shortly after our request, we'll receive an http post to a predetermined URL with the xml data which we then send a blank 200. This data will then be stored in a SQL database. This interface cannot be altered.
The reason this is problematic is because our server is handling requests from clients that need that data in the response. If a user requests for data that isn't available in our database, it needs to be requested from the interface and then returned in the response. I'm just not sure how to get this to work out. I've thought about polling the database, but I'm worried about thread pool issues. I've also looked into using ManualResetEvent.WaitOne to halt the processing of the client request and then calling Set when the interface sends the data (as a request). I've read that wait threads are shared, but just don't know if this will scale well. Does anyone have any insight or I'm pretty much stumped on this one...
View 4 Replies
Dec 30, 2010
I am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
View 5 Replies
Jan 4, 2011
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
View 1 Replies
Apr 26, 2010
This is the basic question , but I am not sure how the HTML data is handled when submitted through any registration form.
Consider I am having a Registration form where I am entering new customer. And while entring the details of customer I have put some HTML data into the textboxes(simple textboxes ) provided for. Show should I handle this.
Do webstandards allows that?
View 7 Replies
May 3, 2010
I have a database of about 50 tables and some of the tables have more than 9999999 records. When I try to fetch some data on some SQL statements, sometimes it takes more then 5 minutes. I would like to know if there is good searching approach to get data from that much records in many tables.
View 6 Replies
Oct 4, 2010
I am looking details on the internal working of asp.net architecture. The topics need to include the following:
Asp.Net Thread/Application Pools HttpRuntime HttpApplication - When and how it is set up How HttpContext is set up How objects can passed along the pipeline using HttpContext.Current.Items Why does modification of static variables requires locks in ASP.NET (advanced)IIS 7 Integration Mode
View 1 Replies
Sep 22, 2010
i want to create a centralised business or Service authendication architecture in .net. for example, we have a clients like c1, c2, c3, c4, ... etc. everybody logins seperatly as well as grouply. ie, if client "C1" logins [with login authentication] he can access c2 , c3, c4 also without login authendication. So its like a google. if we enters gmail account, we can access orkut, picasa like that.. i need the cetralised architecture.
And, client "c1" seperately asks seperately how will be the authendication architecture.
so give me the single solution for both these two scenarios. how will be the architecture for these two and how is the Data Base (Login) Structure.
View 3 Replies
Dec 25, 2010
recently i've studied on ADO.NET's Entity Model Framework and say 'wow' as ORM is one of the fevourite pattern i practice..but suddenly i've come to an ambiguous situation when i'm going to start. i usually follow the following 3-tier architecture..
1. UI Layer
2. BLL - business logic layer
3. DAL - Data Access Layer
a. DTO / DAO
b. Gateway (contains the sql query/stored procedure and connection with DB)
now when i'm going to use the Entity Model Design,where the DBML/ .edmx File should be placed? Because many a times i'm using the DBML file as DTO because of the mapped objects.. in the same time, sometimes DBML ( .edmx file in .NET 4.0) contains CRUD methods and stored procedured method as well as methods with different selection operations,- which should be in Gateway. so where the .edmx file should be placed !?!! IN DTO namespace !? or in Gateway namespace!
moreover sometimes there is no need for the BLL which breaks the rules of inter-layer-communication (UI > BLL > DAL.Gateway)! what makes me confuse is, what should be the ideal n-tier architecture when i'll use the ADO.NET Entity Model Design Framework
View 4 Replies
Mar 15, 2010
I'm building an application that uses GridView controls to display data to a page.In my editemplate i have following control
<div class = "divBox">
<div>Beginn/Zeit 2</div>
<div>
<asp:TextBox ID="tbBeginn2" CssClass="fSelect"
runat="server" Text='<%# Bind("beginnDatum2") %>'/>
BeginnDatum2 has datetime-Format in SQL-Server.
For the update i use an objectDatasource with following updateparameter
<asp:Parameter Name="beginnDatum2" Type="datetime" />
Now i'm trying to update this field but i have a problem when BeginnDatum2 must be null.
I get following (german) Errormessage:
SqlDateTime-Überlauf; muss zwischen 1/1/1753 12:00:00 AM und 12/31/9999 11:59:59 PM liegen.
And this is my paramter
Public Function UpdateSeminar(ByVal kursid As Integer, ByVal id As Integer, _
ByVal beginnDatum2 As DateTime, _
ByVal endeDatum2 As DateTime, _
cmd.Parameters.Add(New SqlParameter("@beginnDatum2", SqlDbType.DateTime))
If beginnDatum2 = Nothing Then
cmd.Parameters("@beginnDatum2").Value = DBNull.Value
Else
cmd.Parameters("@beginnDatum2").Value = DateTime.Parse(beginnDatum2)
End If
View 5 Replies
Jan 5, 2011
i have a gridview which is binded to a dataset in the code-behind file
[Code]....
View 2 Replies
Jul 30, 2010
I am working on 3 tier architecture: UI, BL, DAL. In my UI i have following code for Asynchronous page processing:
[Code]....
But I want a database fetch operation to be performed in this asyncronous method. And due to 3 tier arch. i am unable to do this in UI Layer. Can anyone guide me that how can I implement Asynchronous processing in 3 tier architecture? Note: If you are going to place EndAsyncWork1 in DAL then show that how can I return a value back to UI layer from this function.
[Code]....
View 1 Replies
