Visual Studio C# Windows Project
Table of Project Design Content :-
1. Login Design
a) Login Form Module
b) Login Form Property
2. Admin Dashboard Design
I)Designing Process of Admin Dashboard
Step 1.
Open Visual Studio 2015
↓
New Project
↓
Visual C #
↓
Windows Form Application
↓
Name ----------> Shashiraj Group of Company (Company Name)
↓
Location ---------> C:\Users\supper20-20classes\Desktop\
↓
Solution Name ----------> Shashiraj Group of Company
↓
OK
Syntex :-
Step 2. [ Change Properties in Windows form using Visual Studio]
Solution Explores [Select]
↓
Form1.cs [Right Click]
↓
Rename------> FrmAdminDashboard.cs [Form1.cs = FrmAdminDashboard.cs]
↓
Properties [FrmAdminDashboard.cs]
↓
Text ---------> Admin Dashboard
↓
Start Position ------> CenterScreen
↓
Window State -------> maximized
↓
START
Syntex :-
OUTPUT Project 1.2
Step 3. Design the Windows Form Footer Panel
Toolbox
↓
Panel |__________________________________
↓ |_All Windowa From _________________|
↓ |_All Windowa From _________________|
[panel ] Properties
↓
Name ...........> pnlFooter
↓
Dock ........> Bottom
↓
BackColor..........> Web ..........> Teal
↓
START
Syntex ;-
OUTPUT Project 1.3
Step 4. Design Windows Form footer Label
Toolbox
↓
Label
↓
Properties
↓
Name ............> lblFooter
↓
Text ............> Developed By : Narsingh Yadav
↓
Fore Color ..........> Web .........> white
↓
Font .....> Segoe ui ..........> Regular .........> 10 .......> OK
↓
START
Syntex :-
OUTPUT Project 1.4
Step 5. Design Windows Form MenuStrip
Toolbox
↓
Menu
↓
MenuStrip [All Windows Form]
↓
Type Here .....> Users Category Dealer and Customer Inventory Transactions
↓
Properties
↓
Name.........> menuStripTop
↓
START
Syntex :-
OUTPUT Project 1.5
Step 6. Design Admin Dashboard Windows form Counter Label
Toolbox
↓
Label
↓
Properties
↓
Name ....... > lbluser
↓
Text .............> User :
↓
Font ......> Segoe UI ......> Regular ........> 10 .......> OK
↓
START
Syntex :-
OUTPUT
Step 7. Design Login User Label in windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ...... > lblLoggedInUser
↓
Text .............> Narsingh yadav
↓
ForeColor .............> web ...........> Lime Green
↓
Font ......> Segoe UI ........> Bold .........> 10 .............> OK
↓
START
Syntex :-
OUTPUT
Step 8. Design Company fist Name Label In Windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ...............> lblAppFName
↓
Text .................> Shashiraj Group of
↓
Font ............> Segoe UI ........ > Regular ...........> 20 ..............> OK
↓
START
Syntex :-
OUTPUT
Step 9. Design Company Last Name Label in Windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ........... > lblLName
↓
Text ..............> Company
↓
Font .......> Segoe UI ........>Bold ..........> 20 ..........> OK
↓
START
Syntex :-
OUTPUT
Step 10. Design software head Name Label in Windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ............> lblSHead
↓
Text ..........> Billing and Inventory Management System
↓
ForeColor .......> web .........> Medium sea green
↓
Font ...........> Segoe UI ...........> Sami bold ..........> 14 ............> OK
↓
START
Syntex :-
OUTPUT
a) Admin Dashboard Module
b) Admin Dashboard Property
3. User Dashboard Design
I) Design Process of User Dashboard
Step 1.
Solution Explorer
↓
Shashiraj Group of Company [ Solution Name]
↓
Add
↓
New Item
↓
Visual C# Item
↓
Windows Form
↓
Name ............> FrmUserDashboard
↓
Add
↓
Properties
↓
Text ---------> User Dashboard
↓
Start Position ------> CenterScreen
↓
Window State -------> maximized
↓
START
Syntex :-
OUTPUT
Step 2. Design the Windows Form Footer Panel
Toolbox
↓
Panel |__________________________________
↓ |_All Windowa From _________________|
↓ |_All Windowa From _________________|
[panel ] Properties
↓
Name ...........> pnlFooter
↓
Dock ........> Bottom
↓
BackColor..........> Web ..........> Teal
↓
START
Syntex :-
OUTPUT
Step 3. Design Windows Form footer Label
Toolbox
↓
Label
↓
Properties
↓
Name ............> lblFooter
↓
Text ............> Developed By : Narsingh Yadav
↓
Fore Color ..........> Web .........> white
↓
Font .....> Segoe ui ..........> Regular .........> 10 .......> OK
↓
START
Syntex :-
OUTPUT
Step 4. Design Windows Form MenuStrip
Toolbox
↓
Menu
↓
MenuStrip [All Windows Form]
↓
Type Here .....> Purchase Sale Dealer and Customer Inventory
↓
Properties
↓
Name.........> menuStripTop
↓
START
Syntex :-
OUTPUT
Step 5. Design Admin Dashboard Windows form Counter Label
Toolbox
↓
Label
↓
Properties
↓
Name ....... > lbluser
↓
Text .............> User :
↓
Font ......> Segoe UI ......> Regular ........> 10 .......> OK
↓
START
Syntex :-
OUTPUT
Step 6. Design Login User Label in windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ...... > lblLoggedInUser
↓
Text .............> Narsingh yadav
↓
ForeColor .............> web ...........> Lime Green
↓
Font ......> Segoe UI ........> Bold .........> 10 .............> OK
↓
START
Syntex :-
OUTPUT
Step 7. Design Company fist Name Label In Windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ...............> lblAppFName
↓
Text .................> Shashiraj Group of
↓
Font ............> Segoe UI ........ > Regular ...........> 20 ..............> OK
↓
START
Syntex :-
OUTPUT
Step 8. Design Company Last Name Label in Windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ........... > lblLName
↓
Text ..............> Company
↓
Font .......> Segoe UI ........>Bold ..........> 20 ..........> OK
↓
START
Syntex :-
OUTPUT
Step 9. Design software head Name Label in Windows Form
Toolbox
↓
Label
↓
Properties
↓
Name ............> lblSHead
↓
Text ..........> Billing and Inventory Management System
↓
ForeColor .......> web .........> Medium sea green
↓
Font ...........> Segoe UI ...........> Sami bold ..........> 14 ............> OK
↓
START
Syntex :-
OUTPUT
a) User Dashboard Module
b) User Dashboard Property
I) Sale Form Design
a) Sale form Module
b) Sale Form Property
II) Purchase Form Design
a) Purchase Form Module
b) Purchase Form Property
III) Category Form Design
a) Category Form Module
b) Category Form Property
Table of Project Class Content :-
1. Login Form Class Module
2. Admin Dashboard Class Module
3. User Dashboard Class Module
a) Sale Form Class Module
b) Purchase Form Class Module
c) Category Form Class Module
MY SQL SERVER (DATABASE DESIGN)
Table of Project Database Content :-
Step 1. [ Create Database for Billing System]
Open microsaft SQL Server 2014
↓
Server Type ............> Database Engine
↓
Server Name ..........> Local
↓
Autcherlocation .........> Windows Application
↓
Connect
↓
Database [ Right Click]
↓
New Database
↓
Database Name ...........> Shashiraj Group of Company
↓
OK
↓
USER TABLE
Step 2. [Create User Table in Database]
Shashiraj Group Of Company
↓
Tables [Right Click]
↓
New
Column Name Data Type Allow Nulls
.................................................................................................................
☑ id int ✔
..................................................................................................................
fist_name varchar(50) ✔
...................................................................................................................
last_name varchar(50) ✔
...................................................................................................................
email varchar(150) ✔
...................................................................................................................
username varchar(50) ✔
....................................................................................................................
password text ✔
....................................................................................................................
contact varchar(15) ✔
.....................................................................................................................
address text ✔
.....................................................................................................................
gender varchar(10) ✔
.....................................................................................................................
user_type varchar(15) ✔
......................................................................................................................
added_date datetime ✔
......................................................................................................................
added_by int ✔
.....................................................................................................................
Step 3. [set as tbl_user Primary Key]
id [Salect]
↓
Column ☑ [Right Click]
↓
Set Primary Key
↓
[column Properties]
↓
Identity Specification ............. ☑ [YES]
↓
double click
↓
(is identity) ..........> ☑ yes
↓
[CTRL + S]
↓
Enter a Name for the table .........> tbl_categories
↓
OK
↓
Tables [Right Click]
↓
Refresh
CATEGORIES TABLE
Step 4. [Create Categories Table in Database]
Tables [Right Click]
↓
New
↓
Table
Column Name Data Type Allow Nulls
.................................................................................................................
☑ id int ✔
.................................................................................................................
title varchar ✔
.................................................................................................................
description text ✔
.................................................................................................................
added_date datetime ✔
.................................................................................................................
added_by int ✔
.................................................................................................................
Step 5. [Set as tbl_categories Primary key]
id [Salect]
↓
Column ☑ [Right Click]
↓
Set Primary Key
↓
[column Properties]
↓
Identity Specification ............. ☑ [YES]
↓
double click
↓
(is identity) ..........> ☑ yes
↓
[CTRL + S]
↓
Enter a Name for the table .........> tbl_categories
↓
OK
↓
Tables [Right Click]
↓
Refresh
PRODUCT TABLE
Step 6.[Create Products Table in Database]
Tables [Right Click]
↓
New
↓
Table
Column Name Data Type Allow Nulls
.................................................................................................................
☑ id int ✔
.................................................................................................................
name varchar(50) ✔
.................................................................................................................
category varchar(50) ✔
.................................................................................................................
description text ✔
.................................................................................................................
rate decimal(18,2) ✔
.................................................................................................................
qty decimal(18,2) ✔
................................................................................................................
added_date datetime ✔ .................................................................................................................
added_by int ✔
.................................................................................................................
Step 7. [Set as tbl_products Primary key]
id [Salect]
↓
Column ☑ [Right Click]
↓
Set Primary Key
↓
[column Properties]
↓
Identity Specification ............. ☑ [YES]
↓
double click
↓
(is identity) ..........> ☑ yes
↓
[CTRL + S]
↓
Enter a Name for the table .........> tbl_products
↓
OK
↓
Tables [Right Click]
↓
Refresh
DEALER TABLE
Step 7.[Create Dealer Table in Database]
Tables [Right Click]
↓
New
↓
Table
Column Name Data Type Allow Nulls
.................................................................................................................
☑ id int ✔
.................................................................................................................
type varchar(50) ✔
.................................................................................................................
name varchar(150) ✔
.................................................................................................................
email varchar(150) ✔
.................................................................................................................
contact varchar(15) ✔
.................................................................................................................
address text ✔
.................................................................................................................
added_date datetime ✔
.................................................................................................................
added_by int ✔
.................................................................................................................
Step 8. [Set as tbl_dea_cust Primary key]
id [Salect]
↓
Column ☑ [Right Click]
↓
Set Primary Key
↓
[column Properties]
↓
Identity Specification ............. ☑ [YES]
↓
double click
↓
(is identity) ..........> ☑ yes
↓
[CTRL + S]
↓
Enter a Name for the table .........> tbl_dea_cust
↓
OK
↓
Tables [Right Click]
↓
Refresh
TRANSACTIONS TABLE
Step 9.[Create Transactions Table in Database]
Tables [Right Click]
↓
New
↓
Table
Column Name Data Type Allow Nulls
.................................................................................................................
☑ id int ✔
.................................................................................................................
type varchar(50) ✔
.................................................................................................................
dea_cust_id int ✔
.................................................................................................................
grandTotal decimal(18,2) ✔
.................................................................................................................
transaction_date datetime ✔
.................................................................................................................
tax decimal(18,2) ✔
.................................................................................................................
discount decimal(18,2) ✔
.................................................................................................................
added_by int ✔
.................................................................................................................
Step 10. [Set as tbl_transactions Primary key]
id [Salect]
↓
Column ☑ [Right Click]
↓
Set Primary Key
↓
[column Properties]
↓
Identity Specification ............. ☑ [YES]
↓
double click
↓
(is identity) ..........> ☑ yes
↓
[CTRL + S]
↓
Enter a Name for the table .........> tbl_transactions
↓
OK
↓
Tables [Right Click]
↓
Refresh
TRANSACTION DETAIL TABLE
Step 11. [Create Transactions Detail Table in Database]
Tables [Right Click]
↓
New
↓
Table
Column Name Data Type Allow Nulls
.................................................................................................................
☑ id int ✔
.................................................................................................................
product_id int ✔
.................................................................................................................
rate decimal(18,2) ✔
.................................................................................................................
qty decimal(18,2) ✔
.................................................................................................................
total decimal(18,2) ✔
.................................................................................................................
dea_cust_id int ✔
.................................................................................................................
added_date datetime ✔
.................................................................................................................
added_by int ✔
.................................................................................................................
Step 12.[Set as tbl_transaction_detail Primary key]
id [Salect]
↓
Column ☑ [Right Click]
↓
Set Primary Key
↓
[column Properties]
↓
Identity Specification ............. ☑ [YES]
↓
double click
↓
(is identity) ..........> ☑ yes
↓
[CTRL + S]
↓
Enter a Name for the table .........> tbl_transaction_detail
↓
OK
↓
Tables [Right Click]
↓
Refresh
↓↓↓↓ ↓
1. Login Form Database Design
2. Admin Dashboard Database Design
3. User Dashboard Database Design
a) Sale form Database Design
b) Purchase Form Database Design
c) Category Form Database Design
Some other topics:-
