Civil Food supply and allotment management system

The Civil Food supply and allotment management system is the Ration Card software application to reduce the clerical work and time in fair price shop. This software will keep allotment reports of each month up-to-date so this may helps in reports generations. This is the student project developed using VB.NET and SQL Server.

Modules of Civil Food supply and allotment management system :

Login Module: There are two types of users:

Admin
Clerk

Select the user type, enter the user name and password. Click on Login . If it is valid user then home page will be displayed. If you click on Close the application will be closed.

Admin Home: In the home page we have following modules.

Configuration
Stock
Search
Reports
Logout

Add Branch.

It allows adding or deleting the branches. It will also used to update the branch name.

This form contains the following fields

Branch number : Each branch has a unique number. Which is specified by Admin.

Branch name : It allows Admin to enter the Branch name.

Place : It allows Admin to enter the place of new Branch.

User name : It tells about the name of clerk in that Branch.

User password : It gives a unique password for particular Branch.

User type : It tells whether Master or Branch. It is used to give writes.

This form contains the following buttons:

SAVE: Enter the details of the Branch and click on SAVE to save the details.

UPDATE: To Edit click the row in the grid u want to edit then make changes and click on Edit.

DELETE: To Delete click the row in the grid u want to delete then click on Delete.

CLEAR: It is used to clear the all fields

CLOSE: It is used to close the form

This page displays details of Branch in the grid.

It also allows to search the Branch details by the fields available in the dropdownlist and the value to be entered in the textbox depending on the fields opted. The result is displayed in the grid.

Account configuration.

Each and every Branch can change their password. But for security it is only possible for Admin.

This form contains the following fields

Enter Branch : It Allows you to enter the Branch number to change password.

Old Password : It allows you to enter the old password.

New Password : Here Admin can enter the new password.

Confirm new Password : It is just used to confirm new Password.

Food price.

Here admin can change the price of food grain or can update the price of existing plan.

This form contains the following fields

Tariff : It allows admin to select the plan

Rice : It is used to set new price list for Rice.

Wheat : It is used to set new price list for Wheat.

Sugar : It is used to set new price list for Sugar.

Kerosene : It is used to set new price list for Kerosene.

This form contains the following buttons:

SAVE: Enter the price of the items and click on SAVE to save the details.

UPDATE: To Edit click the row in the grid u want to edit then make changes and click on Edit.

DELETE: To Delete click the row in the grid u want to delete then click on Delete.

CLEAR: It is used to clear the all fields

CLOSE: It is used to close the form

Food quantity.

Here admin can change the quantity of food grain or can update the quantity of existing plan.

This form contains the following fields

Tariff :It allows admin to select the tariff

Rice : It is used to set quantity of Rice.

Wheat :It is used to set quantity of wheat..

Sugar : It is used to set quantity of Sugar.

Kerosene :It is used to set quantity of Kerosene.

This form contains the following buttons:

SAVE: Enter the quantity of the items and click on SAVE to save the details.

UPDATE: To Edit click the row in the grid u want to edit then make changes and click on Edit.

DELETE: To Delete click the row in the grid u want to delete then click on Delete.

CLEAR: It is used to clear the all fields

CLOSE: It is used to close the form

Add customer.

Here admin can add or delete new customer to their correspondent fair price shop.

This form contains the following fields

Branch code : Each branch has a unique number. Which is specified by Admin.

Card number : Here Admin gives the card number to the new customer.

Name : It allows Admin to enter the Customer name.

Address : It allows Admin to enter the Customer Address.

Income : It allows Admin to enter the Customer income.

No of person : It allows Admin to enter the number of person.

Plan : It allows Admin to enter the customer plan.

Date of reg : It allows Admin to enter the date of registration.

Gas : It allows Admin to enter the Gas is true or false.

This form contains the following buttons:

SAVE: Enter the details of the Customer and click on SAVE to save the details.

UPDATE: To Edit click the row in the grid u want to edit then make changes and click on Edit.

DELETE: To Delete click the row in the grid u want to delete then click on Delete.

CLEAR: It is used to clear the all fields

CLOSE: It is used to close the form

This page displays details of Customer in the grid.

It also allows to search the Customer details by the fields available in the dropdownlist and the value to be entered in the textbox depending on the fields opted. The result is displayed in the grid.

Add plan

Here admin can add or delete new plan.

This form contains the following fields

plan name:It allows Admin to enter the new plan name

This form contains the following buttons:

SAVE: Enter the plan name and click on SAVE to save the plan.

UPDATE: To Edit click the row in the grid u want to edit then make changes and click on Edit.

DELETE: To Delete click the row in the grid u want to delete then click on Delete.

CLEAR: It is used to clear the fields

CLOSE: It is used to close the form

Stock decide

Here admin can decide the stock to particular branch and supply stock to the particular branch

This form contains the following fields

Select Branch :Here Admin can select a particular branch to supply stock.

Rice : Here automatically particular branch of required stock,current stock and needed stock of rice will be displayed.

Wheat : Here automatically particular branch of required stock,current stock and needed stock of wheat will be displayed

Sugar : Here automatically particular branch of required stock,current stock and needed stock of sugar will be displayed

Kerosene : Here automatically particular branch of required stock,current stock and needed stock of kerosene will be displayed

This form contains the following buttons:

SUPPLY: To click supply button items will be supplied to the selected branch.

CLEAR: It is used to clear the fields

CLOSE: It is used to close the form

Login details

Here admin can view the login details of selected branch

This form contains the following fields

Select Branch :Here Admin can select a particular branch to view login details.

Stock

View stock

Here admin can view the stock of all branch for clerk while login it is automatically loaded..

This form contains the following fields

Select Branch :Here Admin can select a particular branch to view stock but for clerk while login it is automatically loaded.

Search

Search is one of the important features in many software. Here also Search is used by both Admin and Clerk. Admin can search the all branches. But clerk can search only his branch. .

This form contains the following fields

Select Branch : This is used only by Admin to select the Branch.for clerk while login it is automatically loaded.

Select Tariff : Here Admin or Clerk can select plan for searching.

Total number of customer :Here it will displays search result.

It also allows to search the details by the fields available in the dropdownlist and the value to be entered in the textbox depending on the fields opted. The result is displayed in the grid.

Report

There will be two users how can use this reports one is admin and another is branch clerk. Here the admin can view the reports of all fair price shops. It may be monthly report or it may be the daily reports. But branch Clerk can only view the reports of his fair price shop only..

This module contains the following reports

Daily allotment
Monthly allotment
Current stock
Supply stock
Logout

Clerk Home

In the home page we have following modules.

1. Allotment

2. Stock

3. Search

4. Reports

5. Logout

Allotment

This form is used to allot the food grains to the customers.

This form contains the following fields

Enter cardnumber :Here clerk can enter a cardnumber to allot items to the customer.

Save :if all fields are enterd correctly then save button is allow to save the details

Stock

View stock

Here admin can view the stock of all branch for clerk while login it is automatically loaded..

This form contains the following fields

Select Branch :Here Admin can select a particular branch to view stock but for clerk while login it is automatically loaded.

Search

Search is one of the important features in many software. Here also Search is used by both Admin and Clerk. Admin can search the all branches. But clerk can search only his branch. .

This form contains the following fields

Select Branch : This is used only by Admin to select the Branch.for clerk while login it is automatically loaded.

Select Tariff : Here Admin or Clerk can select plan for searching.

Total number of customer :Here it will displays search result.

It also allows to search the details by the fields available in the dropdownlist and the value to be entered in the textbox depending on the fields opted. The result is displayed in the grid.