Battery Distribution Management System
During my Summer Internship ,the task was given to me that make one web application about battery distribution.
This project is based on distribution of different company’s Batteries in one click. customer can easily find out which types of batteries or which model of batteries with specific company they want to buy.in that customer have one benefit that they see when them battery has expired ,what is capacity of battery and also inform to what is warranty or guarantee of battery.
This project has divided into 3 parts and this parts are include 3 type of users.
- Customer.
- Distributor.
- Admin
The 1st page is login page.
In this page there 3 types of login are included and also one option if are you distributor then select that check box.
- if you are already a customer then write mobile number and password and click sign in .you are able go to next page.
- if you are new user and want to login in this page then click register a new membership and this page is looks as below page.
3.if you are distributor then click on admin Panel.
In the project whatever we add, submit,login all information are stored in database .for that i used SQL bulk database.i have made is web application using asp.net(C#) and also used Admin LTE as a framework.
What is sql server bulk database?
SQL Server supports exporting data in bulk (bulk data) from a SQL Server table and importing bulk data into a SQL Server table or non partitioned view.
- Bulk exporting refers to copying data from a SQL Server table to a data file.
- Bulk importing refers to loading data from a data file into a SQL Server table. For example, you can export data from a Microsoft Excel application to a data file and then bulk import that data into a SQL Server table.
I have made 5 tables to store data about battery, product history ,user login, admin and distributor details. I also add more than 3 excel files of battery information and combine those all file and made one master excel sheet and connect with sql bulk database.
Admin panel
This panel is also known as owner of service. this panel is only use for owner, There is full access for owner he can add or remove distributor. In Admin panel there are major 2 pages.
In this page if owner want to add distributor then he can easily add details once he fills up this from and submit details then he can see if data inserted or not. This is secure panel we write password but when we click on submit, he can’t able to see password it displays data inserted or not.
When we click on show button it will go to next page that is distributor history.in this we can see distributor name and number.it is fetch from the database. we can’t able to see password but it is available on database.
Distributor’s Panel
When distributor login, then they can observe customer’s list. There are few functionalities of distributor. this functionality is shown at sidebar and look like below figure.
Add new battery:
In this page if distributor want to add new batteries of any product, they have to 1st fill up one basic form.in this form there are such information about battery like company name, model name, model number, category, price of battery and at last warranty of battery. once you fill up form and add battery then these details are upload in database. for that we wrote SQL query for battery details and add in specific table.
Add New Purchase details:
When customer want to purchase any battery then distributor fill this form and also generate bill slip.in this there one specialty if distributor write customer number and customer name will automatically enter from database. likewise, when distributor fill model number of battery then price of battery and warranty of battery will automatically generate using database.
In addition, we make it user adaptive it means if distributor want to add multiple batteries details Then there is one button add new using this distributor add as much as batteries he wants. In this form there are also button new when distributor submit above details then get one Invoice it is automatically generated and also, they can easily download that invoice in pdf file. for bill slip we do not worry about to fill all information. for this automation we made one function using that function we convert auto generated bill slip into pdf file.
Show Purchase:
In this page we can watch all purchase history of every battery of their customers.
Add Stock:
This is one type of dashboard.in this distributor observes all stock of products.in dashboard There are many blocks for each and every battery with their specific company.in this blocks there only display total stock of product. if distributor want to know how much amount of batteries with different models then he has to click on specific block in this he can easily observe their stock. if distributor want to add new stock then they can easily add stock and these all are cerebrating on dashboard. Correspondingly, when customer buy any product and distributor generate bill slip then this modification also cogitates to that dashboard.
Software Requirement:
Fronted: ASP.NET (C#), HTML,CSS.
Backed: MsSQL.
Flow chart of the project:
What I learn During internship?
During this internship , i learned so many interesting things and also learned how to handle task and complete during specific time period. there are so many Technics like how to make dynamic website?, how to make database? how to login with goggle and Facebook with there authentication?
Github link of my project
“ Do not wait for things to happen - make them happen.”
— Sadhguru
