Search results matching tag 'design'

Re: Project Architecture Guidance Please

aquaren — Sun, 29 Nov 2009 05:00:00 GMT

By your description, it is clear that you understand what behavior is expected. It is also clear, however, that you are thinking about the application from a data-centric point of view. This can lead to several problems including business logic in the database, tight coupling between your repository and UI, and testability. If you have worked with MVVM, then you understand the benefits of "separation of concerns". I would suggest altering your vantage point a little and spend some time thinking through the domain model. Think about and imagine object behaviors and interaction. Think about the design as if there were no database. How would your perspective change? What considerations would you have then?

Re: online test with multiple correct answers

MadhavRao — Tue, 03 Nov 2009 05:00:00 GMT

In case one has to design Online Test Database with only one correct answer,

He should opt for two tables "Questions" and "Answers".
In "Answers" table there would be a foreign key pointing to entry in "Questions" table.
And in "Questions" table there could be field indicating correct answers. (Field pointing to primary id of "Answers" table)

Other way of designing same problem could be

He should opt for two tables "Questions" and "Answers".
In "Answers" table there would be a foreign key pointing to entry in "Questions" table.
And in "Answers" table there could be field indicating correct answer. (Bit field either true or false)

If we use second design, then we can also use it for multiple correct answers, whereas first design can only help for Questions with single answers.

Other way of addressing Multiple Answers to single Questions is to come up third table i.e. "QuestionsAnswers" relation ship table between Questions and Answers. This would be required in case you are sharing "Answers" table entries with multiple entries in "Questions" table.

I hope this helped.

Re: Rewriting an Access Project (ADP) - Web or WPF - Suggestions and Tips please

dministrator — Fri, 25 Sep 2009 04:00:00 GMT

Thank you for taking time for writing such an involved response. Very helpful. Thank you.

Some more points about this application:

Technical expertise is not an issue as we have people, myself included, working on everything from BizTalk, WCF, WWF and many other Microsoft technologies.

I do not know the full history behind this Access application which I inherited, but one of the clincher in favor of using Access + Citrix seems to be that, Access had everything they needed within one platform: Reporting, UI forms, interface to SQL Server Database etc.

The terminals are all windows dumb-terminals, or as we like to call them - 'unwise terminals'. The application is represented by a short cut on the desktop; when dbl-clicked will launch the Access ADP project via Citrix. I don't think any of the terminals have IE installed right now.

If you have more to add on this topic, please do so. Thanks again for your response.

I need to have a password strength indicator is there any way to do this ? without using an ajax plugin

URBY — Tue, 01 Sep 2009 04:00:00 GMT

Im using the create user wizard and i'd like to have a password strengeth indicator, how do i do this without an ajax plugin ?

Image Slider Control

sarthaks — Wed, 12 Aug 2009 04:00:00 GMT

Hi All,

I need help in creating an Image Slider Control in my ASP.NET 2.0(Ajax) application.Here is a link that has this control , but it is done in silerlight 2.0,(http://www.silverlightshow.net/items/Image-slider-control-in-Silverlight-1.1.aspx) but i need it in ASP.NET/ Javascript.

So that on click of each image it will take me to another new page.

Please give some idea/pointer of how to achieve this in ASP.NET 2.0.

Thank in Advance

Sarthak

DB before the egg?

JJHayter — Thu, 23 Jul 2009 04:00:00 GMT

Having built a few small DBless sites before I decided to get into SQL Server especially since we use it at my work. I came to notice almost all of the tutorials use Northwind, AdventureWorks or a small pre-built DB of some kind.

I decided to check out the many data access tutorials and spent a good deal of time watching the SQL server videos (Thansk Joe!). I noticed however since I am using 2008 that a lot must have changed. My general rule of thumb when something like that happens means that is no longer the way to do things (out of the 7,000 plus .Net Objects I am sure some are depricated/oblosete)

This lead me to ask the vets of ASP Development:

Do you create your database data directly via inserts or do you create your site to do your inserts? Opinions/what you have done please.
Do you keep your db local to your projects and move it later (if at all) or do you leave it within your default directory of SQL Server?
What is your determinants for how complex you make your archetecture? What criteria do you use to better manage your time on projects?
How much time do you invest on schema designs? (resources on this are greatly appreciated [especially on inheritance tables])
Finally what approach do you use to managing your site's SQL Server interaction? Ad-hoc queries from Code behinds? Storage procedures (seems to be very popular although in MySQL I was told to never use them; insight on that would be great.)? LINQ? None of the above (share your experiences; as they say more than one way to skin a cat)

Thanks everyone.

Is [Flags]Enumeration the propper solution

trondaron — Tue, 19 May 2009 04:00:00 GMT

I am planning on have an unknown number of permissions. My intial estimate is roughly 20-30. These permissions will cover a variety of things related to whether a user can create/edit/view various items reports/limits/data etc.

The questions is what is the best practice for this scenerio?

My thoughts below feel free to ignore and just make suggestions:

- A Permissions class that controls the whole mess and can be used in subsequent User Derivative classes. Then checked using something like User.Permissions.ReportsView

- A single [Flag] type enumeration with all the permissions that can be stored in a hex field in a database

- A system of [Flag] type enumerations; so that a user will be flagged for report permissions and then have those permissions defined using a second enumeration. These will be stored in set of database fields mirroring the same structure.

Re: Membership logout control

xyz789 — Thu, 09 Apr 2009 04:00:00 GMT

Thanks guys, but this is still not solving my problem with the browser's back button. I have no problem with the controls logging out "Supposedly" and redirecting back to my login page.

Instead of using this piece of code in the client side 'LogoutAction="RedirectToLoginPage', I just replaced it programmatically with the advice you guys gave me like this:

Protected Sub LoginStatus2_LoggedOut(ByVal sender As Object, ByVal e As System.EventArgs) Handles LoginStatus2.LoggedOut
        FormsAuthentication.SignOut()
        Response.Redirect("~/login.aspx")
    End Sub

I also used the 'Session.Abandon()' instead of 'FormsAuthentication.SignOut()', and it does not solve the issue. Let me give a better example of what I am looking for, maybe I did not explain my situation well enough.

When a user log's into the application he or she can add data to the database. I capture the user's login name when they add data to the database. When the user clicks the logout control or link he or she is redirect back to the login page. Now after being logged out the user can go on top of his or her browser and click the back button and get right back to the previous page. The user at this point is technically logged out, or his or her session has ended. However, after clicking the browser's back button the page can still be displayed with all of the fields that are still functional. When the user enters in data the page will accept the data, but of course the user's name is no longer being stored because they are logged out. I understand this and the application is doing exactly what it should do for the exception that I want the page to be timed out when the user clicks the browser's back button. I guess what I am looking for is to force the user to use the navigation that the application had supplied and eliminate the browser's back button. Is that possible. Sorry for the confusion!

Thanks,

xyz789

Querying tables for books, tapes, articles, movies

sluker — Tue, 24 Mar 2009 04:00:00 GMT

I am going to do a site that would search different types of media.

Books
DVDs
Series of DVDs
Articles
Series of articles
Speeches
Lectures
Whole courses made up of individual classes
YouTube videos

Would you make a Book class with all of the attributes of a book, an Article class with all of the attributes of an article, a DVD class with all of the attributes of a DVD,etc.?

I know that I didn't give any code, so I am not looking for specifics. Just advice as to the way I am thinking about going at it.

How would you query different types of item and then display the contents of one?

Design modules based architecture!

sonmacmat — Thu, 19 Mar 2009 04:00:00 GMT

Hi all!

I need design a module based architecture and integrate into my exist framework so that:

User define Module definition: Module Name; View Action; View Control; Edit Action; Edit Control; Del Action; Del Control; Custom Action; Custom Control ... etc.
System security applied to module level: Can View; Can Edit; Can Del; and Custom Action; etc.
Based on requested action system display correlative module: user request View action -> framework display View Control....

I found that DNN have similar architecture but I can't found the design theory of DNN. So in my situation, how we design, which patterns should be applied etc. Thanks.