C# STORE MANAGEMENT SYSTEM - PART I

GROCERY STORE - STORE MANAGEMENT SYSTEM

v  The goal of this project

      Sharing knowledge with others

v  Tools

      Microsoft Visual Studio 2013

      MSSQL 2012

Grocery Store Part I

    1.Splash Screen

Splash Screen will appear while application lunching.

2.Login

Login form that allows the user to login to the system

3. Forget Password

By security question form

by email form

3.Main Form

C# - PASSWORD

C# Simple Windows Form Application for Password with Source Code

Since I use multiple passwords for multiple resources like web application, social media it is hard to remember the entire list in mind. So I decide to develop a small application to keep my passwords in some kind of order including data encryption and decryption.

CLICK HERE FOR THE SOURCE CODE

Password : 08092018

BCS PGD PROJECT -INVENTORY AND SALES MANAGEMENT SYSTEM

INVENTORY AND SALES MANAGEMENT SYSTEM - BCS PGD Professional Project

Project Proposal

Background

Sasip Bookshop is a part of the Sasip Institute (http://sasip.lk/) which is one of the leading GCE Advanced Level Examination course providers in Sri Lanka. Sasip Bookshop is the place for where Institute students can purchase their educational materials such as textbooks, educational resources and pass papers. I have chosen this entity to propose the automated solution to deliver the work effectiveness and efficiency in their business functions. 

Existing System

Sasip Bookshop carries out the business operation manually at present and following are the functions they carry out and prevailing challenges.

Current process	Challenges
Manual hand written purchase order raised to suppliers in order to procure merchandize to the shop	Real-time stock status is not available, hence facing a risk in proper understanding of the existing inventory.
Good receive note is issued against the items received that stock receiving point	The complete business functions are manages using manual forms and passed from one point of business to another creating delays and mis-management of the documents.
Invoices are maintained manually at the point of sales counters.	The stock counts are maintained in ad-hoc manner while there were incidents of data duplication and missing of essential information.
Daily reconciliation of invoices are carried out manually	Not be able to keep track of the stock-at-hand and inability to generate daily inventory reports and sales reports.
	Procedure of daily invoice reconciliation of stocks, revenue management and profitability calculations are repeated several times as the information is scattered over the manual documents.

Objectives

The proposed Inventory and Sales Management System is expected to the improve their work efficiency and faster by;

• Validate all data entries to minimize data redundancy to the system.

• Quick search facility in all merchandise and look up for all history data and trends of sales.

• Increase efficiency by system generating purchase order note and goods received note and enable real time tallying of stock of sales and stock at hand

• Replace all challenging manual business activities with effective and integrated system while enabling the organization to enjoy the rapid total-cost of ownership (TCO).

• MIS report generation that fulfils the management expectations and assist in making strategic decisions with up-to-date information decisions with up-to-date information

Scope/Functionalities

The proposed Inventory and Sales Management System is intended to cover the following functional aspects;

v  User Management and access level controls

§  Registering new user

§  Managing user information

§  Manage user access privileges and credentials

v  Supplier/Vendor Management

§  Adding and maintaining supplier/vendor information

v  Stock Monitoring

§  Adding and maintaining stock details by assigning unique code and unit price.

v  Inventory Control

§  Manage inventory by assigning stock.

§  Controlling stock input and output.

v  Issue PO and GRN

§  Issue system generated PO and GRN.

v  MIS Report Generation

§  Generating reports for all necessary business functions and analytics for real-time decision support

Deliverables

• AS-IS process and proposed business processes 

• Design documentation including high level UML diagrams and ER diagram.

• Executable Code.

• Test Plan, test cases and Reports.

• Software implementation approach 

Time Schedule and the work plan

Resources

Minimum Hardware Requirements

• Intel Core i5
• 2 GB RAM
• 500 GB Hard Disk Drive
• Printer

System Requirements and tools

·         Microsoft Windows 7 Ultimate

·         .net frame work 4.5

·         Tools

§   C#.net

§   Microsoft SQL Server 2008

§   Microsoft Visual Studio 2013

§   Crystal Report 2013 

BCS PGD Project Documentation

Click here for the report

Object Oriented Programming (OOP)

Object Oriented Programming 

Programming is a set of instruction given to the computer to do a particular job. In generally program can be organized as what is happening (Code) and what is being affected (Data). Object Oriented Programming (OOP) is a powerful way to approach that job. When the computer was first invented programming was done by using binary machine instruction. As long as the program has fewer instructions like hundred this approach worked. As programs growth and increasing complexity assembly language was invented. It’s helped programmers to handle large programs using symbolic representations. As the complexity of programs increase high level languages were introduced. When these high level languages began to reach their breaking point structured programming language such as C invented.

Object Oriented Programming Concept

Objects

OOP is based on the concept of ‘objects’. The object is the real life thing which has characteristics and behaviors. In programming that called attributes (variables/data members) and methods (functions).

Class

Class is a specification of an object or template for creation of object.

Using above class lets create object call sam,

Person sam = new Person();

sam is a variable type of class Person. It is a instances of class Person. Using new keyword we can create an end number of objects in the Person class.

Abstraction

Abstraction is a filter out the unnecessary details and capture only the essential features about the object in order to simplify and increase efficiency.

Encapsulation

Encapsulation is binds the member function and data member into a single class. In another point it is hiding and protect several data from outside when it's necessary.

Inheritance

Inheritance is a class can ‘Inherit’ properties from another base class and define a new class with added features.

Polymorphism

The concept of polymorphism which means many (poly) forms (morphs).There is a two type of polymorphism,

1. Dynamic polymorphism - runtime time. (Overiding)

2. Static polymorphism - compile time. (Overloading)

C# - Product Master

C# Simple Product Mater Windows Form Application with Source Code

This simple C# product master WinForm application has been designed according to the Object Oriented Programming (OOP) concepts with C# as the main programming language and Microsoft SQL Server as the database server.I used Crystal Report for the report generation.

CLICK HERE FOR SOURCE CODE

Password : PRODUCT13092018