1 / 22

Networked Software Systems Laboratory DEPARTMENT OF ELECTRICAL ENGINNERING, TECHNION

Networked Software Systems Laboratory DEPARTMENT OF ELECTRICAL ENGINNERING, TECHNION. Warehouse Management System. Final Presentation WINTER 2009 – SUMMER 2009 PRESENTED BY: George Kour Hany Danial SUPERVISOR: Victor Kulikov. Abstract.

morse
Download Presentation

Networked Software Systems Laboratory DEPARTMENT OF ELECTRICAL ENGINNERING, TECHNION

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Networked Software Systems LaboratoryDEPARTMENT OF ELECTRICAL ENGINNERING, TECHNION Warehouse Management System Final Presentation WINTER 2009 – SUMMER 2009 PRESENTED BY: George Kour Hany Danial SUPERVISOR: Victor Kulikov

  2. Abstract Warehouse Management System is a multi-purpose solution enables full control of the warehouse assets, customers and users.

  3. Agenda • Requirements • Work Environment & Technologies • Application Design • Layer 0 – Database • Layer 1 – DAL • Layer 2 - BLL • Layer 3 – Web User Interface • Security • Project Management • Documents • Reading Material • Live Demonstration

  4. Project Requirements • System users management • Add a user to the system • Change user’s password • Components management • Report component shortage to the manager • Search for a component • Suppliers management • Find out which supplier supplies a component • Update supplier ‘s address • Dashboard • System admin receives real time updates. • And Monitor system alerts

  5. Project Requirements (Cont.) • Customer management • Delete a customer • Send a costumer an email • Lends management • Lend a component to a costumer • Send a loan notification to a customer • Delivery management • Browse the delivery history • Which user made a specific delivery • Reports Generators & Search Engines • Generate a report from search Results • In each section Users Can perform search with parameters.

  6. Work Environment & Technologies • Source Management • Google Code • Tortoise SVN • Database • Microsoft SQL Server 2005 • .Net Environment • Visual Studio 2008 • ASP .Net • C# • ADO .Net • AJAX Technologies

  7. Application Design Layer 3: Web User Interface Layer 2: C# classes. Layer 1: ADO.Net Datasets Layer 0: MSQL Server 2005

  8. Layer 0 - Database Entity Relationship Diagram

  9. Layer 0 – Database (Cont.) • Guid • In each table the primary key is of a type Guid which generated automatically by the database. • Foreign Keys: • Relationships between tables are only via the Guid fields. • SQL Server • Concurrency: optimistic. Managed by DAL.

  10. Data Structure Diagram - update (Cont.)

  11. Layer 1 - DAL

  12. Layer 2 - BLL • Written in C# • Separates the user Interface from the DAL layer • Enforces Business rules. • Exception handling.

  13. Layer 2 - BLL

  14. Layer 3 – Web User Interface • Asp.Net Pages • Master Pages • Asp.Net Components • Data Components - Data Grids, details View. • Standard Components - Button Links, DropDown Lists, checkBox,… • Site Map – using XML. • Navigation Menu. • Login Control • Export to excel.

  15. Layer 3 – Web User Interface (Cont.) • AJAX • Update Panel • Update Progress Panel • Combobox – Auto Complete • Animation. • Timers • Http Editor

  16. Security • Separating Users from Admin module. • Only Admin can perform Application metadata changes. • Session: The Application Manages the connected users by state full sessions. • Cookies: Used to remember information about the user. • Passwords: All passwords are hashed into the database using one way hashing functions (SHA-1)

  17. Project Management • Working Procedures. • Screen Recording - WebEx. • Google Code • Defects/Issues Handling. • Wiki Pages • Downloads Sections • SVN • Revisions Management • working simultaneously

  18. Project management demo Google Projects

  19. Documents Project Book User Manual

  20. Reading Material • www.asp.net • toturials • Data Access • Security • Design Pattern • Vidoes • Master Pages • Events and Postbacks • Web Application State • www.asp.net/ajax • Forums • Bytes • ASP.Net • ADO.Net • Social.msdn • C# Corner • EggHead • Stack Overflow

  21. Live Demonstration

  22. Thank you for listening We Need a grade before December 

More Related