15 MCA058 Shilpa
15 MCA058 Shilpa
15 MCA058 Shilpa
INTRODUCTION
The Organization
Within the first year of its operations, Creation InfoTech has carved a
niche for itself in the IT industry and has increased its business by
The Mission
Philosophy
The existing system is very slow and needs more time to search
and maintain each and every detail.
Hardware requirement
Software requirement
Hardware requirement
Software requirement
The .Net framework has come a long way since then, and the current
version is 4.7.1.
Class Library
b) MVC 5:
The MVC pattern helps you create application that separate the
different aspects of the application (input logic, business logic, UI
logic), while providing a loose coupling between these elements.
The UI logic belongs in the view. Input logic belongs in the controller.
Business logic belongs in the model.
This separation helps you manage the complexity when you build an
application, because it enables you to focus on one aspect of the
implementation at a time.
C# 7.2
C# is a simple, modern, general-purpose, object-oriented
programming language developed by Microsoft within its .NET
initiative led by Anders Hejlsberg. It is a multi-paradigm programming
language encompassing strong
HTML 5:
CSS:
Cascading Style Sheet is a style sheet language used for describing the
presentation of a document written in a language. Although most often
used to set the visual style of web pages and user interfaces written in
HTML and XHTML, the language can be applied to any XML
JS:
JavaScript is a high-level, interpreted programming language. It is a
language which is also characterized as dynamic, weakly typed,
prototype-based and multi-paradigm. Alongside HTML and CSS,
JavaScript is one of the three core technologies of World Wide
Webcontent engineering. It is used to make WebPages interactive and
provide online programs, including video games. The majority of
websites employ it, and all modern web browsers support it without the
need for plug-ins by means of a built-in JavaScript engine.
Bootstrap 4.0
Bootstrapping usually refers to a self-starting process that is supposed
to proceed without external input. In computer technology the term
(usually shortened to booting) usually refers to the process of loading
the basic software into the memory of a computer after power-on or
general reset, especially the operating system which will then take care
of loading other software as needed.
Ms SQL 2008
Microsoft SQL Server is a relational database management system
developed by Microsoft. As a database server, it is a software product
with the primary function of storing and retrieving data as requested by
other software applications—which may run either on the same
computer or on another computer across a network (including the
Internet).Microsoft SQL Server is a relational database management
system developed by Microsoft. As a database server, it is a software
product with the primary function of storing and retrieving data as
requested by other software applications—which may run either on the
same computer or on another computer across a network (including the
Internet).
The first module of Super admin will consist of adding admins into the
Application, adding new affordable plans and offers for their
customers, adding new customers into their data. This module will also
help them to check their daily payments made, check how many new
registrations have been made and also generate reports accordingly.
The last module of Customer is to purchase any plan from us, renew
their existing plan, the customers can also check their order history and
their profile and also send any inquiries.
We basically focus to the customer they can easily use this application
to buy the Plan very easily and also send notification them about their
plan and it is easy way to the customer to use this application for their
different plans and offers.
cshtml HTML
Javascri
pt
CSS
cs
Web
MsSQL
config
JQuery Ajax
1. Customer Module:
2. Admin Module:
Super Admin can add the customer or admin into the system
they can also add the different plans or offers.
USER TABLE:
TABLE NO. 1
NAME USER
Sr.
Field Name Data type Constraint Description
No.
It stores
Primary
1 UserID Int user register
Key
id
It stores
2 First Name Varchar Not null first name
of customer
It stores last
3 Last Name Varchar Not null name of
customer
It stores
4 Email Varchar Not null
email Id
Unique
5 Password Varchar Not null
password
Store
6 Mobile Varchar Not null
mobile no
It stores
7 Location Varchar Not null user
location
It stores id
8 IDProof Varchar Not null
proof name
It stores Id
IDProof
9 Varchar Not null proof
Number
number
TABLE NO. 2
NAME PLAN
Sr.
Field Name Data type Constraint Description
No.
Primary It stores
1 PlanID Int
Key email Id
It stores
2 Name Varchar Not null
plan name
It stores
3 Type Varchar Not null
type of plan
It stores
4 Duration Varchar Not null plan
duration
It stores
5 Price Varchar Not null
plan price
TABLE NO. 3
NAME OFFER
Sr.
Field Name Data type Constraint Description
No.
Primary It store
1 Offers ID Int
key offers id
It stores
2 Name Varchar Not null
offer name
It stores
3 Offer Code Varchar Not null
offer code
It stores
4 Offer Price Varchar Not null different
offer price
TABLE NO. 4
NAME OFFER_PLAN
Sr.
Field Name Data type Constraint Description
No.
It stores
Primary
1 Offer_PlanID Int Offer_plan
key
Id
Foreign It stores
2 OfferID Int
key offer id
Foreign It stores
3 PlanID Int
key plans id
TABLE NO. 5
NAME CUSTOMER_PLAN
Sr.
Field Name Data type Constraint Description
No.
It stores
Primary
1 Customer_PlanID Int customer-
key
plan id
Foreign It stores
2 CustomerID Int
key customer id
It stores
Foreign
3 Offer_PlanID Int offer-plan
key
id
TABLE NO. 6
NAME ORDERS
Sr.
Field Name Data type Constraint Description
No.
Primary It stores
1 OrderID Int
key Order Id
Foreign It stores
2 Customer_ID Int
key customer id
Foreign It stores
3 Plan_ID Int
key plan id
Foreign It stores
4 Location_ID Int
key location id
It stores of
5 Date Varchar Not null
order date
It stores
6 CouponCode Varchar Not null coupon
code
It stores
5 FinalPrice Varchar Not null
final price
TABLE NO. 7
NAME BILL
Sr.
Field Name Data type Constraint Description
No.
Primary It stores bill
1 BillID Int
key Id
It stores
Foreign
2 CustomerID Int location
key
name
It stores
total
3 Total Amount Varchar Not null
amount of
plan
It stores
total
4 Months Varchar Not null
months of
plan
TABLE NO. 8
NAME BILL_PLAN
Sr.
Field Name Data type Constraint Description
No.
Primary It stores
1 Bill_PlanID Int
key bill-plan Id
Foreign It stores
2 CustomerID Int
key customer id
It stores
Foreign
3 Customer_PlanID Int customer-
key
plan id
It stores
4 Total Amount varchar Not null amount of
bill
It stores
total
5 Months varchar Not null
months of
plan
The term error is used to refer the difference between actual output of
the software and the current output.
UNIT TESTING
The unit testing defines that test each individual module/unit for
different test criteria. Here the goal was to assure that each program
module functioning properly as a unit. Different techniques are used to
carry out unit testing.
White box testing is the test case designed method that uses the control
structure of the procedural design. When the program was translated
into programming language source code, it was likely some typing
mistakes were corrected which were removed in syntax testing.
System testing verifies that all the elements meet properly and the
overall system function and performance is achieved.
STRESS TESTING
PERFORMANCE TESTING
Performance test is often coupled with stress testing and often requires
both hardware and software.
VALIDATION TESTING
no.
no.
User 1. Enter empty Click on the An error
Signup value for first button message should
Name be displayed
Submit saying ‘Name
Required’
The User Manual contains all essential information for the user to
make full use of the information system. This manual includes a
description of the system functions and capabilities, contingencies and
alternate modes of operation, and step-by-step procedures for system
access and use.
First users see the home page of the sites which gives the site
description there is Registration link for new user. The existing system
includes following users:
Customer
Admin
Super Admin
Customer:
Create an account: He/she needs to go through
registration process before login to the system
Login: He/she can login through login id and
password
Chang password: Customer can able to change
password.
Plan: He/she can buy plan or renew plan
Payment: he/she can check the mode of payment
and Make a payment
Admin:
Super Admin:
Login: Super Admin login through login id and
password.
Add Admin: Add admin into the system.
Add customer: super admin can add the customer.
Add offers: Add different offers related to the plans.
Payment : check a payment
Acknowledgment: Send Acknowledgment of
payment.
Registration : check the registration of a customer
Logout : Logout from super admin account
Websites:
http://www.tutorialspoint.com
http:// www.getbootstrup.com
http:// www.javapoint.com
Login:
Signup:
Buy Plan
Location Details:
Offer Details:
@model MVC_Customer.Models.Customer
@{
ViewBag.Title = "SignUp";
Layout = "~/Views/Shared/Main_Layout.cshtml";
@{
item2.Text = "Kothrud";
item2.Value = "Kothrud";
item3.Text = "Shivaji-Nagar";
item3.Value = "Shivaji-Nagar";
item4.Text = "VishrantWadi";
item4.Value = "vishrantwadi";
item5.Text = "Camp";
item5.Value = "Camp";
Location.Add(item1);
Location.Add(item2);
Location.Add(item3);
Location.Add(item4);
Location.Add(item5);
<!DOCTYPE html>
<html>
<head>
<style>
body {
background-attachment: fixed;
</style>
</head>
<body>
</body>
</html>
<div class="row">
<div class="col-md-8">
@using (Html.BeginForm())
<div class="card-header">
</div>
<div class="form-row">
</div>
</div>
</div>
<div class="form-row">
</div>
</div>
</div>
<div class="form-row">
</div>
@Html.LabelFor(Model =>
Model.RE_EnterPassword)
@Html.TextBoxFor(Model =>
Model.RE_EnterPassword, null, new { @class = "form-control",
@placeholder = "ReEnterPassword", @type = "Password" })
</div>
</div>
<div class="form-row">
</div>
</div>
</div>
</div>
<div class="card-footer">
</div>
</div>
</div>
</div>