Web application created using .NET & MySql (Apr-May 20)
Hi!! My name is Vishwas Dhanwani, studying in CSPIT — CHARUSAT UNI. (currently in 2nd-year). This my first industrial project with a reputed company NAVPAD INFOTECH. This company is in Vadodara, Gujarat and their domains are web development, android development, e-commerce, and many more. From the first day to the last project evaluation day, we were guided by Nirmit Sir.
The one month at navpadh infotech has taught me, what industry demands and how to work in a team to achieve goals. Our team was asked to create a web application. And then we came up with the idea of car purchase/sell.
I hope you are not bored ……. or are you?
Introduction
Has this ever happened to you that you want to sell your old bike or car but you don’t no where to sell it? And what price you must expect?
SELLBAY is a website created by our team(.com) where you can sell your vehicles at a satisfactory price.
What’s SELLBAY gonna do?
Users just have to create an account, which is free, and your work is done. When a new user is created it has some token amount (for purchase purpose). He/she will look for the vehicle they want to buy and with just a few clicks vehicle is purchased.
A user who wants to sell his/her vehicle has to fill up a form and that vehicle is available for purchase.
Product Functionality
- Users should be able to register through their already existing accounts.
- Unregistered users have to signup first and then they must log in.
- To see vehicles available on our website, one must have an account.
- In the homepage, all vehicles will get displayed including users vehicle
also, according to their specified model and 2/4 — wheeler search is modified. - Once the user clicks on the purchase button for their selected vehicle then the web page will be redirected to the transaction gateway and the user has to pay the token amount and that amount is transferred to the seller’s account.
Note: token amount is decided by the community. - For selling a vehicle, the user has to fill up a web form in which they must enter all specified information about their vehicle and the latest
photo of that vehicle. After submitting the form, the vehicle is available for purchase and can be viewed by other users. - Admin can monitor the purchase-check status, all account details, and transaction details too.
My Contribution to the project
Database
This is the database design for our website. This is created in Microsoft SQL Server. We have created 5 entities :
- UserDetails
This entity will store all the user details. These details are filled when a new user signs up to the website.
Note: By default, wallet attribute has some amount. - VehicleForSale
Stores all the vehicle which are sold or available for purchase. The image of vehicle is stored in photo as hexadecimal values. If the vehicle is sold then status attribute has value — ‘sold’ or else ‘pending’. The token amount is set by community-based on price, margin.
Note: type is either 2-wheeler or 4-wheeler. - Transactions
All the transactions are stored in this entity. The records timing are also saved for reference purpose. - Cinfo
This is used for saving all the admin credentials. - Admin
This entity can be accessed by admin only. It has all the transaction records. As well as the users’ account detail.
Note: Margin is the net profit of the company.
The database was created by me and my colleague Preetparikh. He created the admin side and the rest is done by me. And then we connected both of them so that admin can view all users and transaction details.
Sell Vehicle Page
After a user has logged in, then he/she can sell their vehicles by just filling up this form. The form’s UI and validation were done by my colleague — Dhruval.
The form asks for vehicle details and a photo, all these details are first validated. This code stores form details into the database.
Vehicles available
If some user wants to purchase a vehicle they are available at home page.
It displays all the vehicles which are available for purchase. For this, the data is directly retrieved from VehicleForSale Entity.
What if user want to purchase a vehicle…..let’s say that bike
After user chooses vehicle for himself, then user is transferred to Display page where all the details of that product is available.
Here all the data of a bike is printing out. Users can’t send whole amount to the seller, transaction is done for some token amount only. Token amount is calculated based on price, margin, etc. When a customer clicks on the TRANSFER TOKEN AMOUNT button, his wallet is deducted by token amount of product, and seller wallet is incremented. Both the seller and customer receive a mail regarding the successful transaction. Seller’s vehicle is removed from the HOME PAGE.
Transfer token amount button invokes this function. First, we check whether the transaction is possible or not by verifying customer’s number and checking sufficient balance or not.
After verification, we update customer and sellers’ wallet and mail them too. Then we will update the Transactions Entity.
Vehicles’ status (of VehicleForSale Entity) is changed from pending to sold.
Customers receive a mail regarding successful purchase.
All the transactions and details of customers should be accessible by Admin. For that, after a successful transaction, we update the Admin Entity too.
So, this was my contribution to the project. While working on this project, I learned how to develop a web application, practiced out a practical scenario of database & its design.
I would like to thank Nirmit Sir, Dr. Parth Shah (HOD-IT) and Mrs. Nehal Patel. And thanks to my teammates — Dhruval, Dishank, Meet and Preet, working with them was fun.
This blog only focuses on my work, if you want to see work of my friends then here is the link :
Dhruval | Dishank | Meet | Preet
Github link of our project :- SELLBAY
THANK YOU!
