Solved

Implementing Class Diagram  and design pattern for new module

Posted on 2010-08-26
6
521 Views
Last Modified: 2013-11-12
Hi,
Requirement :
------------
I have an asp.net web application that have a datagrid. Now the users wants a functionality exporting this grid to excel template. We will define the excel template. Once the grid is exported to the excel, the user can make changes to the numbers. Once done with the changes, the user will import back this excel sheet to the web app using the web app import screen. This import screen will have browse button and upload button. Once the import button is clicked, the import manager should first validate the template and start the rows import. Once improt is done the user should be prompted a message. If the import is unsuccessful, then the message box should tell user what all rows caused issues.

I have to come up with a quality class diagram as many senior architects will be reviewing this. Can any exprience architect review this and let me know his thoughts.
This is what all classes my attachment has
- DataManager - Abstract Class
 - DataExportManager - Derived class from DataManager
 - DataImportManager - Derived Class from DataManager
   - ExcelImportManager - Derived class from DataImportManager
   - XMLImportManager - Derived class from DataImportManager
***Wanted to make something like factory pattern
- DataImportUI
Please have a look at the attached document
Can anyone help me in building quality static diagram for this.

Thanks, DataManger-ClassDiag.docx
0
Comment
Question by:aspnetdev
  • 3
  • 3
6 Comments
 
LVL 15

Expert Comment

by:David L. Hansen
Comment Utility
There are many ways to skin a cat....this seems like one of the more difficult ways of doing it.  Really, spreadsheets are so often misused that it is frightening.  Your clients want to be able to view some data, make changes to that data and have the system remember the changes.  The fact that they want to do this through Excel concerns me.  I would present the user with a form, let them make changes in the form, then submit those changes.  They can always download the data in a spreadsheet format to view/analyze, but that should not be the default method of allowing the user to update or input data.  That being said, I understand why the clients want it that way...they are comfortable with Excel and they are the ones holding the money.  So, if you can't convince them to change their minds, I'd give your Class Diagram my stamp of approval, with one suggestion.  Add another class which inherits from DataExportManager named ExcelExportManager.
0
 

Author Comment

by:aspnetdev
Comment Utility
Thanks for your comments. I have modified the class diagram, let me know your comments on this.

DataManger-ClassDiag.docx
0
 
LVL 15

Accepted Solution

by:
David L. Hansen earned 250 total points
Comment Utility
I'd say you have a pretty good diagram.  Good luck with it.  If you've worked with VB to/from Excel a lot then you'll have a big project ahead of you but I think you'll be ok.  If, however, you have not programmed VB to/from Excel ever before then seriously consider doing the job another way.  Not only will you need to navigate the muddy waters of writing to excel but you'll also need to *guess* at what the user did to the data and format which you didn't expect.  Bottom line: the user will have too much flexibility and that will cause you a lot of headaches (just speaking from experience).
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:aspnetdev
Comment Utility
Actually i have another ASP.NET web app where we implemented this functionality. I do acknowledge your concern but i think this is what business want. Also, i will be adding more classes for validation. Thanks for your comment though :) .
I am trying to master the art of UML and OOAD and i dont find many people with good sense of it. Everyone knows how to implement this way or the other but very few know how to design it right.

I will grant you the points.
Thanks,
0
 
LVL 15

Expert Comment

by:David L. Hansen
Comment Utility
Yes, it IS an art -- that's for sure.  As far as mastering the implementation of UML/OOAD I'd just say this: Be a minimalist. At least while you are learning.  Beginners in UML tend to over do it.  For example, don't become "design patterns happy" treat them like perfume...use what you need and no more.
0
 

Author Closing Comment

by:aspnetdev
Comment Utility
Useful feed back but not that much of helpful
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

This article explores the difference between two entities: List and Category.   In part one,  we'll look at the basic concepts, and set some groundwork.  In part two, we'll get to some conclusions. I know that these two things are different, but…
Before You Read The Article Please make sure you understand these two concepts: Variable Scope (http://www.php.net/manual/en/language.variables.scope.php) and Property Visibility (http://www.php.net/manual/en/language.oop5.visibility.php).  And to …
This video discusses moving either the default database or any database to a new volume.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now