Sunday, 14 September 2014

Clients Information Management | with free Asp.Net Source Codes

This web application allows a company to keep track of clients and interactions with clients.
The overall architecure is  ASP.NET MVC 4.0 (with C# and Razor) -> DAL (Data Access Layer) -> LINQ -> SQL Server Database.
  This website uses the following tools and technologies.
  • Asp.Net MVC 4.0
  • Razor engine for presentation
  • C# Language
  • SQL Server LocalDB
  • Visual Studio.NET 2012 Express for Web
  • Data Validation Attributes for validation using JQuery
  • LINQ
  • Forms Authentication
  • Layout and Stylesheets
  • Data Access Layer (DAL) to talk to Database through LINQ
The following are the major operations in this application.
  • Employee Login
  • Change password
  • Logout
  • Add Client
  • Search Clients
  • Getting details of Client
  • Deleting client
  • Listing recent interactions with client
  • Adding Interaction with client
  • Delete interaction

Steps to download, deploy and run this project

The following are the steps to be taken to run the existing part of the application. Sql Server database, which contains all required tables, is bundled along with this application.
  1. Download cim.rar below and unzip it into any directory in your system. For example, if you extract to c:\ then it will create a directory c:\cim.
  2. Start Visual Studio.NET 2012 Express for Web
  3. Open the project from the directory into which you extracted the .rar file. For example, c:\cim
  4. Database (clients.mdf) is placed in App_Data and it contains required tables. Tables contain some sample data for testing.
  5. I also provided tables.txt, which contains commands to create tables. Though not required now, it could be useful in some cases.
  6. Run project from Visual Studio.NET
  7. You should see login page
  8. Login with employee id 1 and password s and test options

No comments:

Post a comment

Note: only a member of this blog may post a comment.