A

MICROPROJECT
On

“Sore Management Application”

Submitted By
Patil Harsh Dnyaneshwar
Enrollment No: 2200300081 Class: CM4

Under The Guidance

Mr. A. A. Shaikh

DEPARTMENT OF COMPUTERTECHNOLOGY
Padmashri Dr. Vitthalrao Vikhe Patil Institute of Technology and
Engineering (Polytechnic) Pravaranagar-413736.
(2023-2024)
 Padmashri Dr. Vitthalrao Vikhe Patil Institute of Technology and
Engineering (Polytechnic) Pravaranagar-413736

CERTIFICATE
This is to certify that

Patil Harsh Dnyaneshwar

Enrollment No: 2200300085 Class: CM4I

Has successfully submitted the Micro Project on

“Store Management Application”

Towards the partial fulfillment of
Diploma in Computer Technology affiliated to Maharashtra State Board of
Technical Education, Mumbai during academic year 2023-2024.

(Mr. A. A. Shaikh) ( Mr.R.S.Kakade)

Guide HOD

Place: Loni
Date:
 Micro Project Evaluation Sheet

Academic Year: 2023-2024 Name of Faculty: Mr. A. A. Shaikh

Course: GAD Course: Code: 22034 Semester: CM-4I

Title of Micro Project: Store Management Application

Cos addressed by the Micro Project:

1. Use Visual Studio IDE to design application.

2. Develop GUI application using form control and its events.
3. Use data access controls to store data in database and retrieve it.
4. Use data binding in GUI application.

Major Learning Outcomes achieved by students by doing the project:

a)Practical Outcomes:

Prepare a menu driven application to maintain Academic Record of Students from multiple streams

b) Outcomes in Cognitive domain:

Able to plan and perform expriments and Practices With its Result.

c) Outcomes in Affective domain:

We follow Ethical Practices, and safety measures.

Comments /Suggestions about team work / leadership/inter-personal communication

Marks out of 6 Marks out of 4 for Total

Roll Enrollment for Performance Performance in out of
Full Name of Student
No. No. in group activity oral/ presentation
(D5) (D5) 10

56 PATHARE VAIBHV MACHHINDRA 2200300077

57 MHASKE KALYANI SANTOSH 2200300078

58 SADAPHAL SAI RAMDAS 2200300079

59 NIMBALKAR ADITYA UDAYSINH 2200300080

60 PATIL HARSH DNYANESHWAR 2200300081

Name & Sign of Faculty

Micro Project Evaluation Sheet
 Micro-Project Proposal

Title of Micro Project: Store Management Application

1.0 Aims/Benefits of Micro Project

1. Use Visual Studio IDE for design application.

2. By use of form controls and its events develop GUI application.
3. Storing a data in database use data access controls.
4. In GUI application use data binding

2.0 Course Outcome(s) Addressed:

1. Use Visual Studio IDE to design application.
2. Develop GUI application using form control and its events.
3. Use data access controls to store data in database and retrieve it.
4. Use data binding in GUI application

3.0 Proposed Methodology

Study the concept of VB.Net programming.

Study various syntax and functions of VB.Net.
Study to create Windows Form application.
Study to connect Windows Form application to Database.
Study to create application to store and retrieve data from database.
Make program for given criteria.
Make a Final Report
 4.0Action Plan

Sr. Details of Activity Planned Planned Name of

No. Start Date Finish Date Responsible
Team Member
01 Title Selection 08/01/2024 12/01/2024 All Member
02 Prepare Proposal 15/01/2024 19/01/2024 All Member
03 Literature Review 22/01/2024 31/01/2024 All Member
04 Data Collection 05/02/2024 29/02/2024 All Member
05 Verification and Validation of work 04/03/2024 07/03/2024 All Member
06 Report Preparation 11/03/2024 20/03/2024 All Member
07 Presentation Viva 20/03/2024 29/03/2024 All Member

5.0 Resources Required

Sr.
Name of resource/material Specifications Qty. Remark
No.

laptop with core i3

1 Computer 1
processor, windows 10

2 Software Visual Studio 2015 1

3 Printer Any printer 1

Name of Team Members:

Roll
Name of Student
No.
61 PATHARE VAIBHV MACHHINDRA

62 MHASKE KALYANI SANTOSH

63 SADAPHAL SAI RAMDAS

64 NIMBALKAR ADITYA UDAYSINH

65 PATIL HARSH DNYANESHWAR

Name & Sign of Faculty

 Micro-Project Report

1.0 Rationale
In this micro project we study different module of student record system. We study
functions of specified topic. We also study to apply different GUI forms. Also apply same
VB.NET concept like form controls, events. We also study vb.net coding in project.

2.0 Aims/Benefits of the Micro Project:

a) Use Visual Studio IDE for design application.

b) By use of form controls and its events develop GUI application.
c) Storing a data in database use data access controls.
d) In GUI application use data binding.

3.0 Course Outcome(s) Achieved:

a) Use Visual Studio IDE to design application.
b) Develop GUI application using form control and its events.
c) Use data access controls to store data in database and retrieve it.
d) Use data binding in GUI application.

4.0 Literature Review:

First, we create group as per teacher guide. Then we select project title for our
project. Then in next week all team members discussed on topic store management
system.In successive week we all team member discussed about to make micro project
report

5.0 Actual Methodology Followed

 Store Management Application

Introduction:

The project Store Management Application is a complete desktop based

application designed on .Net technology using Visual Studio Software. The main
aim of the project is to develop Store management system Model software in
which all the information regarding the stock of the organization will be
presented. It is an intranet based desktop application which has admin
component to manage the inventory and maintenance of the inventory system.

The primary objectives of the project are mentioned below:

➢ To fulfill the requirement for achieving the Bachelor’s degree of
Computer
Information System.
➢ To know the fundamentals of the .Net Technology and Visual Studio
with the
.Net Framework

Features of Project
This application is used to show the stock remaining and details about the
sales and purchase. It gives the details about the stock on daily based and
weekly based. The details components are described below:
Login page: As application starts the login page appears. Admin login is
determined by the username and password that has all the authority to add,
update and delete the stock of the organization as per the requirement.

Create Godwom: We can create godwom if we need to extend or we have

more than one godwom. We can create the godwom along with the date.
Sales details: It show the details about the sales and the remaining
stock of sales. It also show the details about the sales in return.
Purchase details: It shows the details about the purchase made by the
organization along with the price and dates.

This desktop based application is based on 3-tier architecture of .Net

Framework. The 3-tier includes the three hierarchy of the flow of
programming logic from user interface to database and again database to
user interface with the desired information requested by the clients. In
between there involves the logic layer for effectively and correctly
manipulating the request. The 3-tier includes the following:
Client tier
The visual part is implemented using all kinds of swing components, which
does not make database calls. The main function of this tier is to display
information to the user upon user’s request generated by user’s inputs such
as firing button events. For example, inventory list will display when user
click “display” button if he or she wants to know the list of stock remaining
in the organization
Business tier
The middle tier, business logic, is called by the client to make database
queries. It provides core function of the system as well as connectivity to
the data tier, which simplify tasks that were done by the clients tier.
Data tier
Data layer is also the class which gets the data from the business tier
and sends it to the database or gets the data from the database and sends it
to business tier. This is the actual DBMS access layer or object layer also
called the business object. The database backend stores information which
can be retrieved by using the mysql database Connectivity. Mysql

database connectivity is used to manage the communication between the

middle tier and the backend database by issuing complex database queries
 Source code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace InventoryManagementSystem
{
public partial class frmLogin : Form
{
public frmLogin()
{
InitializeComponent();
}

private void txtUserName_KeyDown(object sender, KeyEventArgs e)

{
clsGlobalFunction.Tab_Function(e);
clsGlobalFunction.Escape_Function(e, btnCancel);
}
clsGlobalFunction.Tab_Function(e); clsGlobalFunction.Escape_Function(e, btnCancel);
}

private void txtFiscalYear_KeyDown(object sender, KeyEventArgs e)

clsGlobalFunction.Tab_Function(e); clsGlobalFunction.Escape_Function(e, btnCancel);
}

private void btnCancel_Click(object sender, EventArgs e)

{
Application.Exit();
}

private void btnCancel_KeyDown(object sender, KeyEventArgs e)

{
if (e.KeyCode == Keys.Escape) { Application.Exit(); }
}

private void btnOK_Click(object sender, EventArgs e)

{
{private clsGlobalFunction.temp_text = "Select * from user_login
where user_name='" + txtUserName.Text + "' and password='" +
clsGlobalFunction.Encrypt(txtPassword.Text) + "'";
SqlDataAdapter da = new SqlDataAdapter(clsGlobalFunction.temp_text,
clsGlobalFunction.cn);
DataSet ds = new DataSet();
da.Fill(ds, "table0");
if (ds.Tables[0].Rows.Count > 0)
{}
else
{

}
this.Hide();

MessageBox.Show("User Name or Password is not Correct");txtUserName.Focus();

void txtPassword_KeyDown(object sender, KeyEventArgs e
private void txtUserName_Validated(object sender, EventArgs e)
{
}

private void txtPassword_Validated(object sender, EventArgs e)

{

private void txtFiscalYear_Validated(object sender, EventArgs e)

{

private void frmLogin_Load(object sender, EventArgs e)

{
try
{
clsGlobalFunction.temp_text = "select * from fiscal_year";

SqlDataAdapter da = new
SqlDataAdapter(clsGlobalFunction.temp_text, clsGlobalFunction.cn);
DataSet ds = new DataSet();
da.Fill(ds, "table0");
txtFiscalYear.Items.Clear();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{

txtFiscalYear.Items.Add(ds.Tables[0].Rows[i]["fyear"].ToString());
txtFiscalYear.Text =
ds.Tables[0].Rows[i]["fyear"].ToString();
}
}
catch { }

private void txtUserName_Validating(object sender, CancelEventArgs e)

{
if (txtUserName.Text == "") { MessageBox.Show("Please Enter User
Name", "Inventory Management System", MessageBoxButtons.OK,
MessageBoxIcon.Information); txtUserName.Focus(); return; }
}

private void txtFiscalYear_SelectedIndexChanged(object sender,

EventArgs e)
{

private void label3_Click(object sender, EventArgs e)

{

}
}
}
SaveFileDialog saveBACKUP = new SaveFileDialog();
try
{
DialogResult Dr;
saveBACKUP.Filter = "File format (*.bak)|*.bak";
saveBACKUP.FileName = "INVENTORY ( BACKUP ) " +
DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" +
DateTime.Now.Day.ToString();
Dr = saveBACKUP.ShowDialog();
if (Dr == DialogResult.OK)
{
string s = null;
s = saveBACKUP.FileName;
SqlCommand cmd = new SqlCommand("Backup database " +
clsGlobalFunction.DatabaseName + " to disk='" + s + "' WITH STATS",
clsGlobalFunction.cnMaster);
cmd.ExecuteNonQuery();
clsGlobalFunction.MessageBoxDisplay("Sucussfully Created
Backup !!!");
}
}
ca{
clsGlobalFunction.MessageBoxDisplay(ex.Message);
}

OpenFileDialog RestoreBACKUP = new

OpenFileDialog();try
{
DialogResult Dr;
RestoreBACKUP.Filter = "File format (*.bak)|*.bak";
Dr = RestoreBACKUP.ShowDialog();
if (Dr == DialogResult.OK)
{
string s = null;
s = RestoreBACKUP.FileName;
SqlCommand cmd = new SqlCommand();
cmd.Connection = clsGlobalFunction.cnMaster;

try
{
cmd.CommandText = "Alter Database " +
clsGlobalFunction.DatabaseName + " SET SINGLE_USER With ROLLBACK IMMEDIATE";
cmd.ExecuteNonQuery();
cmd.CommandText = "RESTORE DATABASE " +
clsGlobalFunction.DatabaseName + " FROM DISK = '" + s + "' WITH REPLACE";
cmd.ExecuteNonQuery();
cmd.CommandText = "Alter Database " +
clsGlobalFunction.DatabaseName + " SET MULTI_USER";
cmd.ExecuteNonQuery();
clsGlobalFunction.MessageBoxDisplay("Sucussfully
Created Restored.Application is Restarted !!!");
Application.Restart();
}
catch (Exception ex)
{clsGlobalFunction.MessageBoxDisplay(ex.Message); }

tch (Exception ex)

6.0 Actual Resources Used

Sr. Name of Specifications Qty Remark

No. resource/material
1 Computer laptop with 1
core i3
processor,
windows 10
2 Software Visual Studio 1
2015
3 Printer Any 1
Printer
4 Internet Web browser
7.0 Outputs of the Micro project:

Figure 1: Admin or login page

Figure 2: Company/Shop details

Figure 3: Store Entry System

Figure 4: Back up and Restore Menu

 Figure 5: Report Menu

Figure 6: Creating Godwom

Figure 7: Creating Units

Figure 8: Creating Product Type

 Figure 9: Creating Product

Figure 10: Inserting Opening Stock

11: Purchasing product form vendor

12 Sales product to Customer

Figure 13: Purchase Return

Figure 14: Sales Return

Figure: 15 Report of Current Stock

Figure 16: Back-up Data

8.0 Skill(s) developed / Learning outcome of this Micro Project:

In this micro project we study different module of Store management system.

We study functions of specified topic. We also study to apply different GUI forms.
Also apply same VB.NET concept like form controls, events. We also study vb.net
coding in project.

In this microproject, we add different Product facilities. We use MS-access database to

store Product data.

9.0 Application(s) of this Micro project:

1) Easy and Fast.

2) All Process done properly