This document provides a summary of the system analysis for a project on a Nokia Mobile Shop Management System. It includes event tables describing interactions between users and the system, use case diagrams showing functions users can perform, and entity relationship diagrams, activity diagrams, class diagrams and object diagrams modeling the data and workflow. The analysis identifies customers, employees, orders, products, bills, suppliers, and stock as key entities and defines their attributes and relationships.
This document describes a mobile phone shop management system created by Khurram Shafique and Abdul Basit. The system allows customers to search accessories, buy a mobile phone, and easily manages accessories for the owner. It includes functionality for buying phones, buying stock, and reading and writing information to files. The core functions implemented are buying phones and generating bills, as well as a GUI module for buying phones. Stock can also be bought and saved by the admin to a file.
Project report On MSM (Mobile Shop Management)Dinesh Jogdand
This document provides an overview of a proposed mobile store management system for Mahalakshmi Communications. Key points:
- Mahalakshmi Communications is a mobile solution retailer with 2 stores and a vision to expand across India.
- The proposed system will computerize manual processes like inventory, customer, and employee data to increase efficiency and data accuracy over the current paper-based system.
- The system is designed to be easy to use, generate reports, and securely manage the store's data and operations through a database and user-friendly interface.
This document describes a mobile store management system. It outlines the objectives of providing an easy way for customers to get help and staff to view sales details. The system is built on .NET Windows applications using SQL Server as the backend database. It implements UML diagrams including use case, activity, sequence, and class diagrams. Screenshots show interfaces for customer information, sales reports, inventory management and other features. Future enhancements proposed include attendance tracking and expanding the database connection. The conclusion states the system is user-friendly and can be upgraded without affecting core functionality.
The document provides an introduction and overview of a mobile shop management system being developed. It discusses the purpose of the system, which is to computerize transactions and record keeping for a small business currently using paper-based processes. The system will allow storing of inventory, employee, purchase, and customer records in a database. It will automatically generate bills when customers make purchases. Reports can be generated based on different criteria. The system is being created for a company called Techno Pulse using Java, MS Access, and a relational database model.
The document presents a proposal for an Online Mobile Shop Management System. The system would allow a mobile store to computerize inventory, billing, and customer records. Key features would include storing customer, stock, sales and employee data in a database, automatically generating bills during purchases, and providing an easy way for customers to browse products and place orders online without visiting the store. The proposal outlines the objectives, existing paper-based system, software requirements including PHP, MySQL and Dreamweaver, user operations like registration, login and checkout, and includes context flow, ER diagrams and screenshots.
Software requirements specification of Library Management SystemSoumili Sen
The document provides requirements for a Library Management System. It includes 3 or less sentences:
The Library Management System aims to computerize library processes like book borrowing and maintain member and book details in a database. It will allow librarians and members to search for books, view member accounts, and generate reports. The system needs to be secure, fast, and compatible with common browsers and operating systems.
The document describes the development of a mobile shopping application called MobiShop. Key features include allowing users to shop on mobile devices from any location and accommodate a large number of products. A SWOT analysis was conducted, and implementation details were provided such as user registration via contacts, shopping cart functionality, and payment processing via SMS. Work completed includes frontend pages for login, admin, inventory lists, and product details. Further work involves developing the mobile application frontend to connect to the website and enable viewing products and completing transactions.
Medical Store Management System Software Engineering Projecthani2253
This document provides an overview of a medical store management system project. It describes the project title, objectives, features, scope, and deliverables. The project aims to automate the inventory, accounting, and customer management processes of a medical store to ease the workload. It will use a waterfall model and be developed in Java. Key features will include product, customer, sales, and payment management. The document outlines requirements, design, and implementation plans including user stories, data flow diagrams, and a work breakdown structure.
This document describes a mobile phone shop management system created by Khurram Shafique and Abdul Basit. The system allows customers to search accessories, buy a mobile phone, and easily manages accessories for the owner. It includes functionality for buying phones, buying stock, and reading and writing information to files. The core functions implemented are buying phones and generating bills, as well as a GUI module for buying phones. Stock can also be bought and saved by the admin to a file.
Project report On MSM (Mobile Shop Management)Dinesh Jogdand
This document provides an overview of a proposed mobile store management system for Mahalakshmi Communications. Key points:
- Mahalakshmi Communications is a mobile solution retailer with 2 stores and a vision to expand across India.
- The proposed system will computerize manual processes like inventory, customer, and employee data to increase efficiency and data accuracy over the current paper-based system.
- The system is designed to be easy to use, generate reports, and securely manage the store's data and operations through a database and user-friendly interface.
This document describes a mobile store management system. It outlines the objectives of providing an easy way for customers to get help and staff to view sales details. The system is built on .NET Windows applications using SQL Server as the backend database. It implements UML diagrams including use case, activity, sequence, and class diagrams. Screenshots show interfaces for customer information, sales reports, inventory management and other features. Future enhancements proposed include attendance tracking and expanding the database connection. The conclusion states the system is user-friendly and can be upgraded without affecting core functionality.
The document provides an introduction and overview of a mobile shop management system being developed. It discusses the purpose of the system, which is to computerize transactions and record keeping for a small business currently using paper-based processes. The system will allow storing of inventory, employee, purchase, and customer records in a database. It will automatically generate bills when customers make purchases. Reports can be generated based on different criteria. The system is being created for a company called Techno Pulse using Java, MS Access, and a relational database model.
The document presents a proposal for an Online Mobile Shop Management System. The system would allow a mobile store to computerize inventory, billing, and customer records. Key features would include storing customer, stock, sales and employee data in a database, automatically generating bills during purchases, and providing an easy way for customers to browse products and place orders online without visiting the store. The proposal outlines the objectives, existing paper-based system, software requirements including PHP, MySQL and Dreamweaver, user operations like registration, login and checkout, and includes context flow, ER diagrams and screenshots.
Software requirements specification of Library Management SystemSoumili Sen
The document provides requirements for a Library Management System. It includes 3 or less sentences:
The Library Management System aims to computerize library processes like book borrowing and maintain member and book details in a database. It will allow librarians and members to search for books, view member accounts, and generate reports. The system needs to be secure, fast, and compatible with common browsers and operating systems.
The document describes the development of a mobile shopping application called MobiShop. Key features include allowing users to shop on mobile devices from any location and accommodate a large number of products. A SWOT analysis was conducted, and implementation details were provided such as user registration via contacts, shopping cart functionality, and payment processing via SMS. Work completed includes frontend pages for login, admin, inventory lists, and product details. Further work involves developing the mobile application frontend to connect to the website and enable viewing products and completing transactions.
Medical Store Management System Software Engineering Projecthani2253
This document provides an overview of a medical store management system project. It describes the project title, objectives, features, scope, and deliverables. The project aims to automate the inventory, accounting, and customer management processes of a medical store to ease the workload. It will use a waterfall model and be developed in Java. Key features will include product, customer, sales, and payment management. The document outlines requirements, design, and implementation plans including user stories, data flow diagrams, and a work breakdown structure.
This document outlines a library management system project. The system aims to automate library tasks like entering new book records, retrieving book details, and managing an easy circulation system and member records using computers. It discusses the purposes of providing a user-friendly environment and easy reports. It also summarizes the drawbacks of existing manual systems like difficulty in data retrieval and redundancy. The proposed computerized system aims to address these issues through features like member ID cards for book check-in/out and eliminating human errors in record retrieval. It provides screenshots of the frontend and backend interfaces and outlines the hardware requirements of a Pentium processor and standard accessories and the software requirements including Windows OS, Java, MySQL, Tomcat, and Netbeans IDE.
The document describes a mobile store management system for Mahalakshmi Communications. It includes details about:
- The organization such as its name, address and business segments
- An overview of the current manual system and its limitations
- The proposed computerized system which aims to address the limitations and provide benefits like reduced time, improved data availability and reports
- System requirements including frontend and backend tools, operating system and hardware requirements
This document provides an overview of a proposed repair shop management system. It describes the current manual paper-based system that is time-consuming and prone to errors. The proposed system would automate the repair shop's processes using an Android app with a backend SQLite database. This would digitize record keeping, allow customers to manage appointments online, and help the shop owner track equipment repairs and customer interactions more efficiently. The system aims to reduce errors, save time, and improve services for both the repair shop and its customers.
This document outlines requirements for a library management system. It will automate tracking of book details, issues, and returns. The system has two user types - users can check availability and return books, while administrators manage user registration, book entry and issue, and returns. Functional requirements include modules for book entry, user registration, book issue, and return. The system aims to reduce manual work, provide reports, and accurately track book availability in real-time as books are issued or returned.
This document provides a software requirements specification for the E-Smart Shopping mobile application and backend server. It describes the purpose, scope, user classes and requirements of the system. The key features include a budget tracker, product navigation, product recommendations, barcode scanning, halal product identification, and translation capabilities. The interfaces and architecture are also specified, including interactions between the mobile app and backend server via APIs and a real-time database. Non-functional requirements around performance, security and quality are also outlined.
This document provides an overview and summary of a job portal web application project developed by students over a summer training period. The project uses Java technologies like servlets, JSP, and Hibernate to allow job seekers to search and apply for jobs, and employers to post jobs. Key features include modules for job seekers to create profiles and browse listings, employers to post and manage listings, and an administrator to oversee operations. The document outlines the project purpose, objectives, scope, modules, and team roles in developing the different components.
This document describes a project to develop a bank management system using Java. It includes sections on functional and non-functional requirements, code implementation with classes to handle new accounts, viewing details, deposits and withdrawals, and sample outputs/screenshots. The system allows customers to securely manage bank accounts online through a menu-driven interface that incorporates input validation, exception handling and other programming techniques.
The document summarizes an online marketplace website project created by Deoghare Priyanka Murlidhar, Moradiya Pavan Ganeshbhai, and Patil Pooja Bhagwat for their Bachelor of Engineering degree. The project uses ASP.NET with C# for the front-end and SQL Server 2008 for the back-end. It allows users to buy and sell products online through features such as user registration, product posting and authentication, online payments, and communication between buyers and sellers.
This document provides a project report for developing a Hospital Management System. It includes requirements for key functions like patient registration, assigning patient IDs, generating reports on patient and bed information, and updating patient records in the database. The system is intended to automate manual paper-based processes currently used by the hospital. It will utilize web-based and MySQL database technologies with a Windows development environment.
This document summarizes an inventory management system project created to fulfill requirements for a computer science degree. The project includes modules for authentication, adding/updating inventory, and a public interface to view products. It outlines the system's objectives to allow admin to manage inventory and customers to view products online. Database and interface designs are presented along with diagrams of the login, inventory, and relationship flows. Future enhancements could make the system more interactive and statistical.
This document describes a project for a mobile store management system. It includes sections on the scope, objectives, processing environment, system implementation using UML diagrams, and future enhancements. The system will allow a mobile store to manage customer details, mobile sales and repairs, employee information, and generate reports. It will be developed as a .NET Windows application using SQL Server and is intended to reduce costs compared to manual ledgers. UML diagrams including use case, activity, sequence, and class diagrams are included to model the system functionality and design.
This document provides a software requirements specification for a Library Management System being developed at the University of Education, Township Campus. It includes sections that describe the purpose and scope of the system, user requirements, system features, and technical specifications. The key functions of the system are to manage the checking in and out of books, track book loans, and generate reports. It is intended for use by both librarians and students to automate and improve library management and services.
This document provides an overview and outline of a banking management system project. It acknowledges the guidance provided by faculty members. The abstract describes the goals of defining and managing requirements to ensure customer needs are met. The introduction discusses the project objectives of authorizing users, locating accounts, and reducing clerical work. It also covers project benefits and scope such as accessing privileged banking and providing banking services. The system development life cycle stages are then outlined, including preliminary investigation, determining requirements, designing the system, development, testing, and implementation.
The document outlines the scope and design of a library management system. It includes sections on project purpose, scope, assumptions, functionality, specific requirements, tools/platform, resources used, design specification including entity relationship and data flow diagrams, database structure, module description, process logic, types of reports, and future scope. The system is intended to automate processes like membership registration, book issuing/returning, tracking book inventory and member records. It will leverage ASP.NET and SQL Server for development.
The document provides details about a project report on book store management submitted by Ms. Amrita Singh to S.K. College of Science and Commerce. The 3-page report includes an introduction, acknowledgements, index, and the start of the preliminary investigation section. It describes the objectives of developing a computerized management system for the book store to help with effective management of purchases and sales.
Final Year Projects (Computer Science 2013) - Syed Ubaid Ali JafriSyed Ubaid Ali Jafri
Final year project ideas and Aims related to computer science students, Students can get an idea and make their final year project belongs to the industry requirement.
This document describes an online real estate management system project. The system allows owners to list properties online and potential tenants or buyers to search listings. It provides a platform for owners and customers to communicate directly. The system is designed with separate modules for administrators, owners, and customers. It uses a three-tier architecture with ASP.NET for the front end, MS SQL Server for the back end, and is designed using an agile methodology. Tables were created to store user, property, and other relevant data. The system was tested to ensure requirements were met before launch.
In today’s busy world, people don’t have time for their personal needs. And the technology is so fast that anyone can do anything by just sitting in a room. The internet is the way that helps a person in all aspects. If someone wish to buy and view things, he can buy online with the help of internet.
Today there are very least organizations which are manual. Everything is going to be computerized and online whether it is banking, advertising or shopping. We are trying to help people to make their life easier by proving online Mobile shopping.
In this we have introduced many modules like admin module and customer module. The customer have to register for any enquiry related to Mobile . The unregistered person can’t access this application. The registered customer can view details of Mobile and he can buy of his choice and need. He has to pay the price of Mobile .
The admin module contains the access of admin on the application. The admin can change everything in the application. He has the ability to add, delete, update any information regarding the Mobile .
The project’s home page includes the registration link. The registered users can login to their account for their queries or buy new Mobile . And the unregistered users have first to register. The registration can be done by following the sign up link .
This document outlines a project to develop a Shop Management System. It describes the features of the system including login functionality, selling and purchasing items, stock monitoring, and generating reports. The system was created using C#, SQL Server, and Visual Studio following an incremental development model. It allows a shop owner to manage inventory, sales, vendors and generate invoices and reports to analyze the business.
This document provides a project report for the completion of a 4th semester mini project on online shopping. It includes an introduction to the project, existing system analysis and drawbacks, proposed system details, feasibility study, requirements analysis, system design specification, and planned testing. The project aims to develop an online shopping system that allows customers to shop from home, provides lower prices due to reduced overhead costs, and offers free home delivery. It will use JSP for the front end and MySQL for the back end.
The document discusses developing an online auction system using technologies like ASP.NET and SQL Server to allow sellers to list products and buyers to bid on products, with modules to handle administration, sellers, buyers, bidding, and online payments. It aims to provide a more efficient platform for auctions by allowing interdependent values and information sharing between bidders.
N. Sathish Kumar has over 10 years of experience in the IT industry. He has expertise in Java, Spring, Hibernate, Oracle, SQL Server, and legacy modernization tools like BluAge. Some of his projects include modernizing banking applications, developing web applications for failure analysis tracking and supply chain management, and migrating mainframe screens to new interfaces. He is skilled at all phases of the software development life cycle from analysis to deployment.
This document outlines a library management system project. The system aims to automate library tasks like entering new book records, retrieving book details, and managing an easy circulation system and member records using computers. It discusses the purposes of providing a user-friendly environment and easy reports. It also summarizes the drawbacks of existing manual systems like difficulty in data retrieval and redundancy. The proposed computerized system aims to address these issues through features like member ID cards for book check-in/out and eliminating human errors in record retrieval. It provides screenshots of the frontend and backend interfaces and outlines the hardware requirements of a Pentium processor and standard accessories and the software requirements including Windows OS, Java, MySQL, Tomcat, and Netbeans IDE.
The document describes a mobile store management system for Mahalakshmi Communications. It includes details about:
- The organization such as its name, address and business segments
- An overview of the current manual system and its limitations
- The proposed computerized system which aims to address the limitations and provide benefits like reduced time, improved data availability and reports
- System requirements including frontend and backend tools, operating system and hardware requirements
This document provides an overview of a proposed repair shop management system. It describes the current manual paper-based system that is time-consuming and prone to errors. The proposed system would automate the repair shop's processes using an Android app with a backend SQLite database. This would digitize record keeping, allow customers to manage appointments online, and help the shop owner track equipment repairs and customer interactions more efficiently. The system aims to reduce errors, save time, and improve services for both the repair shop and its customers.
This document outlines requirements for a library management system. It will automate tracking of book details, issues, and returns. The system has two user types - users can check availability and return books, while administrators manage user registration, book entry and issue, and returns. Functional requirements include modules for book entry, user registration, book issue, and return. The system aims to reduce manual work, provide reports, and accurately track book availability in real-time as books are issued or returned.
This document provides a software requirements specification for the E-Smart Shopping mobile application and backend server. It describes the purpose, scope, user classes and requirements of the system. The key features include a budget tracker, product navigation, product recommendations, barcode scanning, halal product identification, and translation capabilities. The interfaces and architecture are also specified, including interactions between the mobile app and backend server via APIs and a real-time database. Non-functional requirements around performance, security and quality are also outlined.
This document provides an overview and summary of a job portal web application project developed by students over a summer training period. The project uses Java technologies like servlets, JSP, and Hibernate to allow job seekers to search and apply for jobs, and employers to post jobs. Key features include modules for job seekers to create profiles and browse listings, employers to post and manage listings, and an administrator to oversee operations. The document outlines the project purpose, objectives, scope, modules, and team roles in developing the different components.
This document describes a project to develop a bank management system using Java. It includes sections on functional and non-functional requirements, code implementation with classes to handle new accounts, viewing details, deposits and withdrawals, and sample outputs/screenshots. The system allows customers to securely manage bank accounts online through a menu-driven interface that incorporates input validation, exception handling and other programming techniques.
The document summarizes an online marketplace website project created by Deoghare Priyanka Murlidhar, Moradiya Pavan Ganeshbhai, and Patil Pooja Bhagwat for their Bachelor of Engineering degree. The project uses ASP.NET with C# for the front-end and SQL Server 2008 for the back-end. It allows users to buy and sell products online through features such as user registration, product posting and authentication, online payments, and communication between buyers and sellers.
This document provides a project report for developing a Hospital Management System. It includes requirements for key functions like patient registration, assigning patient IDs, generating reports on patient and bed information, and updating patient records in the database. The system is intended to automate manual paper-based processes currently used by the hospital. It will utilize web-based and MySQL database technologies with a Windows development environment.
This document summarizes an inventory management system project created to fulfill requirements for a computer science degree. The project includes modules for authentication, adding/updating inventory, and a public interface to view products. It outlines the system's objectives to allow admin to manage inventory and customers to view products online. Database and interface designs are presented along with diagrams of the login, inventory, and relationship flows. Future enhancements could make the system more interactive and statistical.
This document describes a project for a mobile store management system. It includes sections on the scope, objectives, processing environment, system implementation using UML diagrams, and future enhancements. The system will allow a mobile store to manage customer details, mobile sales and repairs, employee information, and generate reports. It will be developed as a .NET Windows application using SQL Server and is intended to reduce costs compared to manual ledgers. UML diagrams including use case, activity, sequence, and class diagrams are included to model the system functionality and design.
This document provides a software requirements specification for a Library Management System being developed at the University of Education, Township Campus. It includes sections that describe the purpose and scope of the system, user requirements, system features, and technical specifications. The key functions of the system are to manage the checking in and out of books, track book loans, and generate reports. It is intended for use by both librarians and students to automate and improve library management and services.
This document provides an overview and outline of a banking management system project. It acknowledges the guidance provided by faculty members. The abstract describes the goals of defining and managing requirements to ensure customer needs are met. The introduction discusses the project objectives of authorizing users, locating accounts, and reducing clerical work. It also covers project benefits and scope such as accessing privileged banking and providing banking services. The system development life cycle stages are then outlined, including preliminary investigation, determining requirements, designing the system, development, testing, and implementation.
The document outlines the scope and design of a library management system. It includes sections on project purpose, scope, assumptions, functionality, specific requirements, tools/platform, resources used, design specification including entity relationship and data flow diagrams, database structure, module description, process logic, types of reports, and future scope. The system is intended to automate processes like membership registration, book issuing/returning, tracking book inventory and member records. It will leverage ASP.NET and SQL Server for development.
The document provides details about a project report on book store management submitted by Ms. Amrita Singh to S.K. College of Science and Commerce. The 3-page report includes an introduction, acknowledgements, index, and the start of the preliminary investigation section. It describes the objectives of developing a computerized management system for the book store to help with effective management of purchases and sales.
Final Year Projects (Computer Science 2013) - Syed Ubaid Ali JafriSyed Ubaid Ali Jafri
Final year project ideas and Aims related to computer science students, Students can get an idea and make their final year project belongs to the industry requirement.
This document describes an online real estate management system project. The system allows owners to list properties online and potential tenants or buyers to search listings. It provides a platform for owners and customers to communicate directly. The system is designed with separate modules for administrators, owners, and customers. It uses a three-tier architecture with ASP.NET for the front end, MS SQL Server for the back end, and is designed using an agile methodology. Tables were created to store user, property, and other relevant data. The system was tested to ensure requirements were met before launch.
In today’s busy world, people don’t have time for their personal needs. And the technology is so fast that anyone can do anything by just sitting in a room. The internet is the way that helps a person in all aspects. If someone wish to buy and view things, he can buy online with the help of internet.
Today there are very least organizations which are manual. Everything is going to be computerized and online whether it is banking, advertising or shopping. We are trying to help people to make their life easier by proving online Mobile shopping.
In this we have introduced many modules like admin module and customer module. The customer have to register for any enquiry related to Mobile . The unregistered person can’t access this application. The registered customer can view details of Mobile and he can buy of his choice and need. He has to pay the price of Mobile .
The admin module contains the access of admin on the application. The admin can change everything in the application. He has the ability to add, delete, update any information regarding the Mobile .
The project’s home page includes the registration link. The registered users can login to their account for their queries or buy new Mobile . And the unregistered users have first to register. The registration can be done by following the sign up link .
This document outlines a project to develop a Shop Management System. It describes the features of the system including login functionality, selling and purchasing items, stock monitoring, and generating reports. The system was created using C#, SQL Server, and Visual Studio following an incremental development model. It allows a shop owner to manage inventory, sales, vendors and generate invoices and reports to analyze the business.
This document provides a project report for the completion of a 4th semester mini project on online shopping. It includes an introduction to the project, existing system analysis and drawbacks, proposed system details, feasibility study, requirements analysis, system design specification, and planned testing. The project aims to develop an online shopping system that allows customers to shop from home, provides lower prices due to reduced overhead costs, and offers free home delivery. It will use JSP for the front end and MySQL for the back end.
The document discusses developing an online auction system using technologies like ASP.NET and SQL Server to allow sellers to list products and buyers to bid on products, with modules to handle administration, sellers, buyers, bidding, and online payments. It aims to provide a more efficient platform for auctions by allowing interdependent values and information sharing between bidders.
N. Sathish Kumar has over 10 years of experience in the IT industry. He has expertise in Java, Spring, Hibernate, Oracle, SQL Server, and legacy modernization tools like BluAge. Some of his projects include modernizing banking applications, developing web applications for failure analysis tracking and supply chain management, and migrating mainframe screens to new interfaces. He is skilled at all phases of the software development life cycle from analysis to deployment.
Fruit shop management system project report.pdfKamal Acharya
The export maintenance system is a fully featured application that can help we manage fruit delivery business and achieve more control and information at a very low cost of total ownership.
A fruit export maintains automatically monitors purchase, sales, supplier information. The system includes receiving fruit from the different supplier. Customer order is placed in the system, based on the order fruit has been sales to the customer.
The report contains the details about product, purchase, sales, stock, and invoice. The main objective of this project is to computerize the company activities and to provide details about the production process at the fruit export maintenance system.
The demand of fresh fruit fruits and processed food items in international and domestic market has shown a decent increase. This estimation is creating a necessity for growing more and more fruit fruits to cater the growing demand of domestic & international market.
The customers effectively and hence help for establishing good relation between customer and fruit shop organization. It contains various customized modules for effectively maintaining fruit and stock information accurately and safely.
When the fruits are sold to the customer, stock will be reduced automatically. When a new purchase is made, stock will be increased automatically. While selecting fruits for sale, the proposed software will automatically check for total number of available stock of that particular item, if the total stock of that particular item is less than 5, software will notify the user to purchase the particular item.
The proposed project is developed to manage the fruit shop in the fruits for shop. The first module is the login. The admin should login to the project for usage. The username and password are verified and if it is correct, next form opens. If the username and password are not correct, it shows the error message.
Supermarket Management System Project Report.pdfKamal Acharya
Supermarket management is a stand-alone J2EE using Eclipse Juno program.
This project contains all the necessary required information about maintaining
the supermarket billing system.
The core idea of this project to minimize the paper work and centralize the
data. Here all the communication is taken in secure manner. That is, in this
application the information will be stored in client itself. For further security the
data base is stored in the back-end oracle and so no intruders can access it.
The document describes the development of an online job portal system. The system allows job seekers to create profiles, upload resumes and apply for jobs posted by employers. Employers can post job listings, search resume databases and block candidates. The system aims to automate the manual job recruitment process and make it easier for job seekers and employers to connect. It was developed using PHP and MySQL on a LAMP stack with a distributed architecture and centralized database storage.
This document outlines a project proposal for developing a billing system. It includes sections on the project objectives, categories, reports, technologies, hardware requirements, future scope, analysis of the existing system, proposed system characteristics, feasibility analysis, data flow diagrams, entity relationship diagrams, database design, and screenshots of sample forms. The project aims to automate billing for a department store chain to allow for efficient management of customer and product data and generation of sales reports.
Dairy management system project report..pdfKamal Acharya
ASP.NET is the next version of Active Server Pages (ASP); it is a unified Web development platform that provides the services necessary for developers to build enterprise-class Web applications. While ASP.NET is largely syntax compatible, it also provides a new programming model and infrastructure for more secure, scalable, and stable applications. ASP.NET is a compiled, NET-based environment, we can author applications in any .NET compatible language, including Visual Basic .NET, C#, and JScript .NET. Additionally, the entire .NET Framework is available to any ASP.NET application. Developers can easily access the benefits of these technologies, which include the managed common language runtime environment (CLR), type safety, inheritance, and so on. ASP.NET has been designed to work seamlessly with WYSIWYG HTML editors and other programming tools, including Microsoft Visual Studio .NET. Not only does this make Web development easier, but it also provides all the benefits that these tools have to offer, including a GUI that developers can use to drop server controls onto a Web page and fully integrated debugging support.
This document provides details about an Electricity Bill Management System project, including:
- The project aims to partially computerize processes at an Electricity Board like generating bills and maintaining customer records.
- Visual Basic 6.0 is used as the front-end and MS Access 2000 as the back-end database.
- The objectives are to efficiently store and retrieve customer, billing, and employee information to improve record keeping.
- Hardware requirements include a PC and printer, and the software environment uses VB6, Access, and Windows.
- VB6 is used for its visual interface design capabilities and event-driven programming. Access is used as a relational database.
This document provides an overview of the Topic-Chat project, which aims to develop a chat application for students to discuss different topics and subjects. It includes sections on system analysis, software requirements, selected technologies, system design, and outputs. The key technologies used are Google Cloud Messaging for push notifications, PHP for the server, MySQL for the database, and Android for the client. Diagrams are provided showing the entity relationship, use cases, and system architecture. The outputs demonstrated include admin and student interfaces for registration, login, viewing topics and messages.
This document provides an overview and requirements for a marketplace application called Mingle Box. The application allows buyers to find and hire freelance coders for custom software projects. Coders can access work from buyers around the world. The document outlines functional requirements like registration, bidding, and payments. It also discusses technical requirements, feasibility, and includes a high-level data flow diagram. The goal is to connect buyers and coders in a safe, cost-effective manner through an online bidding system.
Policy management system project report.pdfKamal Acharya
The project entitled as “Policy Management System” is developed in a manner to help all the Policy Agency Members. It is developed using Visual Basic 6.0 as Front-End and MS Access as the Back-End tool.
The system is designed in such a way that it accepts and stores the input data, process and produce output under the direction of a detailed step by step stored programmed instruction. This system includes Client Dairy, Client Details, Add new Client, Policy Details and Payment Details information’s and gives details based on the policy Number of the client. This system is necessary for Storing Information, assessing Workload and hence their efficiency. The System provides the adequate information to the concern for its smooth run.
The document discusses the objectives, feasibility study, and implementation specifications for an Income Tax Department Management System project. The objectives are to overcome paper-based problems and easily manage records of PAN card holders and employees. A feasibility study assesses the technical, operational, and economic feasibility of the proposed system. The implementation will use ASP.NET on Windows with a SQL Server database. Hardware requirements include a Pentium PC with 512MB RAM and 80GB hard drive.
The document describes an employee management system developed for GEA Process Engineering (India) Private Limited. It includes sections on the existing system, requirements for a new system, hardware and software needs, project management, system users, analysis, design, implementation, testing, screenshots and future enhancements. The system allows administrators to add, edit and verify employee information, line managers to access reports on their department employees, and employees to access their own details. It aims to reduce workload and improve information management over the previous system.
This document contains the resume of Subbarao P, who has 3.5 years of experience working with WebMethods Integration Platform. He has expertise in building and maintaining B2B applications and EAI integrations using WebMethods, and experience with various adapters and protocols. The resume lists three projects he worked on, including maintaining Coca-Cola's global B2B integration infrastructure and developing new interfaces for an upgrade project.
The document describes an online examination system. It discusses the existing manual paper-based examination system and its drawbacks. The proposed system is an online examination system developed using ASP.Net and SQL Server that allows administrators to create exams and questions, and students to take exams online. Key features include exam and student administration, online question display and answering, automated result calculation and display.
The document contains details about the development of a bug tracking system as part of an industrial training program. It includes diagrams of the system architecture at different levels of abstraction, an entity relationship diagram, and descriptions of features, technologies used, and the development process. The training focused on analyzing requirements, designing data models and interfaces, implementing functionality, and testing the system to track bugs and monitor their resolution.
This document describes a proposed departmental store item search engine project. It discusses the need to computerize the store's manual record keeping system to reduce errors and improve efficiency. The proposed system would allow items to be added, deleted, updated and searched. It outlines advantages like improved data access and security. Hardware requirements include an i3 processor, 4GB RAM, and 500GB hard disk. The system would be developed using Visual Basic .NET and an MS Access backend database.
This document provides an overview of a banking system software project. The key points are:
1. The software will automate banking transactions like deposits, withdrawals, account searches and provide a user-friendly interface.
2. The objectives are to reduce clerical work, provide faster access to customer data and transactions, and increase the number of accounts and customers.
3. The software will be developed using Visual Basic for the front end interface and Microsoft Access for the back end database. It will run on Windows operating systems.
Research Inventy : International Journal of Engineering and Scienceinventy
Research Inventy : International Journal of Engineering and Science is published by the group of young academic and industrial researchers with 12 Issues per year. It is an online as well as print version open access journal that provides rapid publication (monthly) of articles in all areas of the subject such as: civil, mechanical, chemical, electronic and computer engineering as well as production and information technology. The Journal welcomes the submission of manuscripts that meet the general criteria of significance and scientific excellence. Papers will be published by rapid process within 20 days after acceptance and peer review process takes only 7 days. All articles published in Research Inventy will be peer-reviewed.
Similar to 127801976 mobile-shop-management-system-documentation (20)
Network Security and Cyber Laws (Complete Notes) for B.Tech/BCA/BSc. ITSarthak Sobti
Network Security and Cyber Laws
Detailed Course Content
Unit 1: Introduction to Network Security
- Introduction to Network Security
- Goals of Network Security
- ISO Security Architecture
- Attacks and Categories of Attacks
- Network Security Services & Mechanisms
- Authentication Applications: Kerberos, X.509 Directory Authentication Service
Unit 2: Application Layer Security
- Security Threats and Countermeasures
- SET Protocol
- Electronic Mail Security
- Pretty Good Privacy (PGP)
- S/MIME
- Transport Layer Security: Secure Socket Layer & Transport Layer Security
- Wireless Transport Layer Security
Unit 3: IP Security and System Security
- Authentication Header
- Encapsulating Security Payloads
- System Security: Intruders, Intrusion Detection System, Viruses
- Firewall Design Principles
- Trusted Systems
- OS Security
- Program Security
Unit 4: Introduction to Cyber Law
- Cyber Crime, Cyber Criminals, Cyber Law
- Object and Scope of the IT Act: Genesis, Object, Scope of the Act
- E-Governance and IT Act 2000
- Legal Recognition of Electronic Records
- Legal Recognition of Digital Signatures
- Use of Electronic Records and Digital Signatures in Government and its Agencies
- IT Act in Detail
- Basics of Network Security: IP Addresses, Port Numbers, and Sockets
- Hiding and Tracing IP Addresses
- Scanning: Traceroute, Ping Sweeping, Port Scanning, ICMP Scanning
- Fingerprinting: Active and Passive Email
Unit 5: Advanced Attacks
- Different Kinds of Buffer Overflow Attacks: Stack Overflows, String Overflows, Heap and Integer Overflows
- Internal Attacks: Emails, Mobile Phones, Instant Messengers, FTP Uploads, Dumpster Diving, Shoulder Surfing
- DOS Attacks: Ping of Death, Teardrop, SYN Flooding, Land Attacks, Smurf Attacks, UDP Flooding
- Hybrid DOS Attacks
- Application-Specific Distributed DOS Attacks
Cyber Crime with basics and knowledge to cyber sphereRISHIKCHAUDHARY2
In this ppt you will get to know about the cyber security basics as well as the paradigms that are important in the cyber world.
Also this can be helpful for study purpose in college and schools.
You will also get two case studies which can be helpful for better understand.
Decentralized Justice in Gaming and EsportsFederico Ast
Discover how Kleros is transforming the landscape of dispute resolution in the gaming and eSports industry through the power of decentralized justice.
This presentation, delivered by Federico Ast, CEO of Kleros, explores the innovative application of blockchain technology, crowdsourcing, and incentivized mechanisms to create fair and efficient arbitration processes.
Key Highlights:
- Introduction to Decentralized Justice: Learn about the foundational principles of Kleros and how it combines blockchain with crowdsourcing to develop a novel justice system.
- Challenges in Traditional Arbitration: Understand the limitations of conventional arbitration methods, such as high costs and long resolution times, particularly for small claims in the gaming sector.
- How Kleros Works: A step-by-step guide on the functioning of Kleros, from the initiation of a smart contract to the final decision by a jury of peers.
- Case Studies in eSports: Explore real-world scenarios where Kleros has been applied to resolve disputes in eSports, including issues like cheating, governance, player behavior, and contractual disagreements.
- Practical Implementation: Detailed walkthroughs of how disputes are handled in eSports tournaments, emphasizing speed, cost-efficiency, and fairness.
- Enhanced Transparency: The role of blockchain in providing an immutable and transparent record of proceedings, ensuring trust in the resolution process.
- Future Prospects: The potential expansion of decentralized justice mechanisms across various sectors within the gaming industry.
For more information, visit kleros.io or follow Federico Ast and Kleros on social media:
• Twitter: @federicoast
• Twitter: @kleros_io
Seizing the IPv6 Advantage: For a Bigger, Faster and Stronger InternetAPNIC
Paul Wilson, Director General of APNIC, presented on 'Seizing the IPv6 Advantage: For a Bigger, Faster and Stronger Internet' during the APAC IPv6 Council held in Hanoi, Viet Nam on 7 June 2024.
'Secure and Sustainable Internet Infrastructure for Emerging Technologies'APNIC
Paul Wilson, Director General of APNIC delivers keynote presentation titled 'Secure and Sustainable Internet Infrastructure for Emerging Technologies' at VNNIC Internet Conference 2024, held in Hanoi, Vietnam from 4 to 7 June 2024.
1. A
PROJECT REPORT ON
Nokia Mobile Shop Management System
Submitted toSubmitted to
University of MumbaiUniversity of Mumbai
2011-20122011-2012
BY
Miss. AARTI DEEPAK SHINDE
1
2. INDEX
2
Sr.No. Title Page
No.
1 Preliminary Investigation 6
Organizational Overview 7
Description Of System 8
Limitations Of Present System 9
Proposed System & its Advantage 10
Feasibility Study 12
Stakeholders 15
Gantt Chart 16
2 System Analysis 17
Fact Findings 18
Event Table 19
Use Case Diagram 20
Entity Relationship Diagram 21
Activity Diagram 22
Class Diagram 23
Object Diagram 24
Sequence Diagram 25
Collaboration Diagram 26
State Diagram 27
3 System Design 28
Converting ERD to Tables 29
Relationship Diagram 30
Component Diagram 31
Package Diagram 32
Deployment Diagram 33
System Flow Chart 34
Structure Chart 35
4 System Coding 36
Menu Tree 37
List of Tables with Attributes & Constraints 38
Program Description with naming Conventions
Program Listing
Validations
Test Cases, Test Data, Test Results
Screen Layouts & Report Layouts
41
5 System Implementation & Uploading 114
6 Future Enhancement 116
7 References & Bibliography 120
5. Description of System
In Nokia Mobile Store Management System use to maintain their sales
detail in files and folders. They use to keep the record of product sold,
Customers, Suppliers, etc in a register. A daily register is maintained to keep
track of complaints.
Preparing report is very time consuming and tedious task. For searching
of single record, whole register is to be searched which is very time consuming
task.
5
6. Limitations Of Present System
As mentioned above most of details are maintained
manually. Due to this the data retrieved is time
consuming. Due to human calculation errors occur.
Even when the data is maintained on spreadsheet
inconsistency occurs as an order might be missed or
wrongly entered or twice.
Data are stride an excel sheet which takes lot of time and
data may be corrupted.
As storage and exchange of data is achieved only by use
of excel sheets which lack validation capabilities, there is
always risk of invalid, inaccurate or incomplete data
being fed in computer.
Difficulty in managing multiple forms.
Lack of security.
6
7. Proposed System
The proposed system is computerized and has been
developed using advance language therefore it gives more facilities
than present system. It provides quick access to any data. In this system
user have to enter the data only once and then it get linked with all files.
This reduces the workload of user and it is also a time saving process.
The information about any Subscriber can be easily
retrieved. The system maintains all records easy.
7
8. Advantages of Proposed System:
All the information about sale, purchase will be maintain properly in
this system.
All manual calculation of sale or all the money management will be
performed by the computer automatically.
This system will provide timely report information.
It will produce report for sale, bill information.
The computer can hold amount of data in its storage device.
The operation and speed of the computer is very high.
We can calculate result and print any report within seconds.
Any difficulties we can solve easily.
A database application can be stored in computer effectively.
It is very user friendly and easy to handle.
So the computerized system is more suitable than the manual system.
8
9. Feasibility Of Study
1. Software Specification:-
Software requirements for this system are as listed follows:
FRONTEND : Microsoft Visual Basic 8.0
BACKEND : MS Access-2007
OPERATING SYSTEM : Windows XP
FOR DOCUMENTATION : Microsoft Office
2. Hardware Specifications
Minimum hardware requirements for this System are listed below:
Processor : Pentium-4
RAM : 256MB.
HARD DISK : 80GB.
CD-Rom Driver : Any.
9
10. FRONTEND: - MICROSOFT VISUAL STUDIO
2008
1. First of all, VB.NET provides managed code execution that runs under
the Common Language Runtime (CLR), resulting in robust, stable and
secure applications. All features of the .NET framework are readily
available in VB.NET.
2. VB.NET is totally object oriented. This is a major addition that VB6 and
other earlier releases didn't have.
3. The .NET framework comes with ADO.NET, which follows the
disconnected paradigm, i.e. once the required records are fetched the
connection no longer exists. It also retrieves the records that are expected
to be accessed in the immediate future. This enhances Scalability of the
application to a great extent.
4. VB.NET uses XML to transfer data between the various layers in the
DNA Architecture i.e. data are passed as simple text strings.
5. Error handling has changed in VB.NET. A new Try-Catch-Finally block
has been introduced to handle errors and exceptions as a unit, allowing
appropriate action to be taken at the place the error occurred thus
discouraging the use of ON ERROR GOTO statement. This again credits
to the maintainability of the code.
6. Another great feature added to VB.NET is free threading against the VB
single-threaded apartment feature. In many situations developers need
spawning of a new thread to run as a background process and increase
the usability of the application. VB.NET allows developers to spawn
threads wherever they feel like, hence giving freedom and better control
on the application.
7. Security has become more robust in VB.NET. In addition to the role-
based security in VB6, VB.NET comes with a new security model, Code
Access security. This security controls on what the code can access. For
example you can set the security to a component such that the
component cannot access the database. This type of security is important
because it allows building components that can be trusted to various
degrees.
8. The CLR takes care of garbage collection i.e. the CLR releases resources
as soon as an object is no more in use. This relieves the developer from
thinking of ways to manage memory. CLR does this for them.
10
11. BACKEND: MS-ACCESS 2007
Microsoft Office Access, previously known as Microsoft Access, is a
database management system from Microsoft that combines the relational
Microsoft Jet Database Engine with a graphical user interface and software-
development tools.
MS Access stores data in its own format based on the Access Jet
Database Engine. It can also import or link directly to data stored in other
applications and databases
Microsoft Access applications can adopt split-database architecture. The
database can be divided into a front-end database that contains the application
objects (queries, forms, reports, macros, and modules), and is linked to tables
stored in a back-end shared database containing the data. The "back-end"
database can be stored in a location shared by many users, such as a file server.
The "front-end" database is distributed to each user's desktop and linked to the
shared database.
Access includes an Upsizing Wizard that allows users to upsize their
databases to Microsoft SQL Server, an ODBC client–server database. An
additional solution, the SQL Server Migration Assistant for Access (SSMA), is
also available for download from
11
12. Stakeholders
Stakeholders are anyone who has an interest in the project. Project
stakeholders are individuals and organizations that are actively involved in the
project, or whose interests may be affected as a result of project execution or
project completion. They may also exert influence over the project’s objectives
and outcomes. The project management team must identify the stakeholders,
determine their requirements and expectations, and, to the extent possible,
manage their influence in relation to the requirements to ensure a successful
project.
The following are examples of project stakeholders:
1. Project Developers :-
Project Developers is one who develops software for customer. In
my project I am the first stakeholder i.e. Project Developer.
2. Project customer :-
Project Customer is one who pays for the developed software.
3. Project user Group :-
Project User group are those people who use the software on
daily basis for the Project Customer.
12
17. Fact Findings
Introduction
The Current System is the manual one, hence is not speedy, accurate,
efficient as well as time consuming. An essential part of the system analysis,
which enables the developer to understand & the system correctly. It is
undertaken to obtain details of the system. To understand the physical flow of
the information through the current system. Collect various information
through various fact finding techniques. Identify the procedural difficulties
experienced by the user. Study the bottlenecks find out the redundant work
being performed in the system.
Fact Finding Techniques Employed
1. Interviews
Information was obtained from the employees at the organization by
interviewing them at the location and time convention both.
2. Document Searching
An extensive study of existing document an official correspondence
was done to understand the present working status of organization.
17
18. Event Table
18
SR
NO EVENT TRIGGER SOURCE ACTIVITY RESPONSE DESTINATION
1 Enter new
customer
Add Admin Create new
record
New record
created
System
2 Customer
change in
personal
details
Update Customer Update
customer
details
Details
updated
Admin
3 Gives an
Order
New order Customer Create new
Order
New order
created
Employee
4 Enter new
supplier
Add
supplier
Admin Add new
supplier
record
New record
created
System
5 Supplier
change in
details
Update Supplier Update
supplier
details
Details
updated
Admin
6 Owner needs
supplier
details
Search Admin Search
supplier
details
Display
supplier
details
System
7 Enter new
employee
Add Admin Create new
employee
record
New record
created
System
8 Stock entry Add Admin Generating
receipt
Get receipt Customer
19. 19
9 Paying Bill Order
fulfillment
Customer Paying bill Get payment Admin
10 Generating
reports
New report Admin Generating
receipt
Get receipt System
11 Updating
records
Check
previous
records
Admin Updating
records
Record is
update
System
12 Delete record Delete admin Check
records
Delete
record
System
20. Use Case Diagram
Supplier:-
Supplier Admin
Product:-
Admin
20
Delete supplier
details
Display supplier
details
Search supplier
Update supplier
details
Create a new
supplier
Lookup for
supplier
Delete product
details
Display product
details
Update product
details
Create a new
product
Lookup for
product details
24. Activity Diagram
Customer
No
Yes
24
Nokia Mobile Shop System
Enter Customer information
Enter product information
Product
Supplier
Place purchase order
Check availability
Give payment
Add product
Request product for purchase
Create new order
Calculate total
Generate Bill
Enter order
Place Order
Initiate maintain customer
information
Display Customer information
Verify Customer information
28. Sequence Diagram
Supplier:-
Create Supplier:
Create new supplier information
New supplier created
Admin
Update Supplier:
Display supplier details
Update supplier details
Supplier Admin
Delete Supplier:
Display supplier details
Delete supplier
Admin
28
System
System
System
29. Product:-
Create Product:
Create new product details
New product created
Admin
Update Product:
Display product details
Update product details
Admin
Delete Product:
Display product details
Delete selected product
Admin
29
System
System
System
30. Stock:-
Create Stock:
Create new stock information
New stock created
Admin
Update Stock:
Display stock details
Update stock details
Admin
Delete Stock:
Display stock details
Delete stock
Admin
30
System
System
System
31. Customer:-
Create Customer:
Create new Customer information
New Customer created
Customer Admin
Update Customer:
Display Customer details
Update Customer details
Customer Admin
Delete Customer:
Display Customer details
Delete Customer
Admin
31
System
System
System
32. Order:-
Create Order:
Create new Order information
New Order created
Customer Admin
Update Order:
Display Order details
Update Order details
Customer Admin
Delete Order:
Display Order details
Delete Order
Admin
32
System
System
System
33. Bill:-
Create Bill:
Create new Bill information
New Bill created
Admin
Delete Delete:
Display Bill details
Delete Bill
Admin
33
System
System
34. Employee:-
Create Employee:
Create new Employee information
New Employee created
Admin
Update Employee:
Display Employee details
Update Employee details
Employee Admin
Delete Employee:
Display Employee details
Delete Employee
Admin
34
System
System
System
35. Collaboration Diagram
1. Customer enquiry
2. Get information
5. Place order
6. Get order
8. Pay bill 7. Order fulfillment
9. Generate receipt
10. Check availability 3. Customer
Of mobile
Registration
14. Update records
4. Check details
11. Order
13. Payment 12. Placed order
35
Customer
Supplier
Employee
36. State Diagram
Login
Customer enter
Order for mobile
Mobile not available
Mobile available
Check details
Order fulfillment
Paying bill
Generating receipt
36
Customer enquiry
Check availability of
mobile
Order for mobile
End
Check mobile details
Mobile provide to customer
Pay bill
Generate receipt
Idle
39. Converting ERD to Tables
Sr.No TABLE NAME PURPOSE
1 Cust_info
This table is use to store, retrieve and information about the
customer.
the fields are c_no,cname,cadd,gender,contactno,email
2 Employee
This table is use to store ,retrieve and information about the
employee. The fields is :
e_id,e_fname,e_mname,e_lname,e_add,e_city,e_contact.
3 Supplier
This table is use to store ,retrieve and information about the
supplier.The field are o_no,s_name,o_model,o_qty,o_prize,
o_totprize,o_tax,o_tot.
4 Order
This table is use to purchase , store , retrieve
& the information like p_no,p_name.
The field in the table are c_no,c_name,cadd,email,contactno,
o_no,p_no,p_name,p_qty,p_mrp,p_tot.
5 Salary This table is use store ,retrieve and information about the
employee salary.
The field are e_id, e_fname,e_mname,e_lname, e_add,
e_contact, msalary, advance.
39
42. Package Diagram
42
Nokia Mobile shop system
Supplier, Order,
Stock, Emp
Form
Availability
Cancel
Connection
Admin
Other Form
Emp form
Supplier form
Product form
Order form
Bill form
Cancel
Processing
And
Printing
44. 44
Nokia
Mobile store
management
Price Mobile
Purchase order
Customer
Supplier
Mobile bill
Employee
Paid
Maintain
customer
details
Mobile details
Transaction of
mobile
Maintain
employee
details
Paid details
Generate
mobile bill
Purchase order
details
Customer
bill report
Supplier
bill report
System flow
45. 45
Nokia Mobile Store System
Maintain
customer
details
Creation of
order
Bill
generation
Giving
purchase
order
Get
Customer
details
Save
customer
details
Checking of
product
Customer
details
Product
details
Get mobile
details
Report
generation
Order
fulfillment
Retrieve
mobile
details
Bill details
Structure chart
47. Menu Tree
47
MDI Form
Main
Customer information
Mobile Details
Customer Purchase order
Reports
Utility Calculator
About Us Help
Exit
Employee
Customer information
Mobile Details
Mobile Bill
Supplier Report
Transaction Transaction
48. Table List
1.Table name:-Cust_info
Sr.N
o.
Field Name Datatype Constraints Size Description
1 c_no Integer Primary key Stores the customer code
2 cname Varchar 10 Stores the customer name
3
4
cadd
gender
Varchar
Varchar
10
10
Stores the customer address
Store the customer gender
4 contactno Bigint Stores the customer contact.
5 email Varchar 25 Stores the customer email id
2.Table name:-Employee
Sr.
No.
Field Name Datatype Constraints Size Description
1 E_id Integer Primary key Stores the employee code
2
3
4
E_fname
E_mname
E_lname
Varchar
Varchar
varchar
15
15
15
Stores the employee name
Stores the employee middle
name
Stores the employee last name
5 E_add Varchar 20 Stores the employee address
6 Ph_no Bigint Stores the employee ph.no.
48
49. 3.Table name:-Supplier
Sr.
No.
Field Name Datatype Constraints Size Description
1 o_no Integer Primary key Stores the company code
2 S_name Varchar 20 Stores the company name
3
4
o_model
o_qty
Varchar
Integer
20 Stores the mobile model name
Stores the mobile qty
5 o_color varchar 20 Stores the mobile color
6
7
8
9
o_prize
o_totprize
o_tax
o_tot
Bigint
Bigint
Bigint
bigint
Stores the mobile prize
Stores the total prize
Stores the tax value
Stores the total amount
included tax
4. Table name:-Order
Sr.
No.
Field Name Datatype Constraints Size Description
1 c_no Integer Foreign key Stores the customer code
2 c_name Varchar 15 Stores the customer name
3 c_add Varchar 15 Stores the customer address
4 contactno Bigint Stores the customer contact
no
5 email varchar 20 Stores the customer email
6 o_no Integer Stores the order no
7 p_no integer Stores the product no
8 P_name Varchar 15 Stores the product name
9 P_q ty Integer Stores the product quantity
10 P_mrp integer Stores the product prize
11 P_tot bigint Stores the product total prize
49
50. 8. Table name:-Salary
Sr.
No.
Field Name Datatype Constraints Size Description
1 E_id Integer primary Stores the employee id
2
3
E_fname
e_mname
Varchar
varchar
15
15
Stores the employee name
Stores the employee middle
name
4 e_lname Varchar 15 Stores the employee last name
5 e_add varchar 20 Stores the employee address
6 e_contact Bigint Stores the employee contact no
7 msalary Bigint Stores the emp monthly salary
8 advance Bigint Stores the emp advance salary
50
51. Program List
NO FORM
NAME
PURPOSE
1 Loding.frm This form display the title of system name
of organization & copyright of the system
2 Loginform.frm This form is used for security with the help of
password
3 MdIForm.frm This is the multiple document interface for the all
of the form in the project
4 Cust_info.frm This form is use for store the customer information
5 Emp.frm This form is use for store the employee
information
6 Supplier.frm This form is use for store the Supplier information
7 Salary.frm This form use for store employee salary
51
52. Report List
NO. REPORT NAME PURPOSE
1 Crystalreport1.rpt This report is use for to
print and show the
customer bill
2 Crystalreport2.rpt
This report is use for to
print & show the
supplier bill
52
53. Program Description
Program Name: Loding.vb
Program Function: This is form is used to Load the
system.
Code:-
Public Class Loading
Dim i As Integer
Private Sub Timer1_Tick(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Timer1.Tick
ProgressBar1.PerformStep()
i = i + 1
Label2.Text = i
If ProgressBar1.Value = 100 Then
Me.Hide()
LoginForm1.Show()
Timer1.Enabled = False
End If
End Sub
53
54. Program Name: Login Form1.vb
Program Function: This is form is used to Login in the
system.
Code:-
Public Class LoginForm1
Private Sub OK_Click_1(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles OK.Click
If UsernameTextBox.Text = "arti" And
PasswordTextBox.Text = "123" Then
Me.Hide()
MDI.Show()
Else
MsgBox("error")
End If
End Sub
54
55. Program Name: MDI.vb
Program Function: This is form contains menus i.e. path
for other forms.
Code:-
Public Class MDI
Private Sub CustomerInfoToolStripMenuItem_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs) Handles
CustomerInfoToolStripMenuItem.Click
Cust_info.Show()
End Sub
Private Sub MobileDetailsToolStripMenuItem_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs) Handles
MobileDetailsToolStripMenuItem.Click
MobiAdd.Show()
End Sub
Private Sub MobileBillToolStripMenuItem_Click(ByVal sender
As System.Object, ByVal e As System.EventArgs)
Mobile_Bill.Show()
End Sub
Private Sub OrderToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
PurchaseOrderToolStripMenuItem.Click
55
56. Order.Show()
End Sub
Private Sub AboutToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
AboutToolStripMenuItem.Click
about.Show()
End Sub
Private Sub EmployeeDetailsToolStripMenuItem_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs) Handles
EmployeeDetailsToolStripMenuItem.Click
emp.Show()
End Sub
Private Sub ExitToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ExitToolStripMenuItem.Click
Me.Close()
End Sub
Private Sub MobileBillToolStripMenuItem1_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs) Handles
MobileBillToolStripMenuItem1.Click
Report_bill.Show()
End Sub
Private Sub CalculatorToolStripMenuItem_Click(ByVal sender
As System.Object, ByVal e As System.EventArgs) Handles
CalculatorToolStripMenuItem.Click
Process.Start("C:WINDOWSsystem32calc.exe")
End Sub
Private Sub SalaryToolStripMenuItem_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
SalaryToolStripMenuItem.Click
salary.Show()
End Sub
Private Sub ReceivedMobileToolStripMenuItem_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs) Handles
ReceivedMobileToolStripMenuItem.Click
supplier.Show()
End Sub
Private Sub ToolStripMenuItem1_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
ToolStripMenuItem1.Click
supplier_report.Show() End Sub
56
57. Program Name: Cust_info.vb
Program Function: This is form is used to add new
customer and its details
Data entry form:
Code:-
Imports System.Data.OleDb
Public Class Cust_Info
Dim cmd As OleDbCommand
Dim cn As New OleDbConnection
Dim ad As New OleDbDataAdapter
Dim SlotAdapter As New OleDb.OleDbDataAdapter
Dim ds As New DataSet
Dim dr As String
Dim dt As String
Dim i, f, a As Integer
Private Sub Cust_Info_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the
'_Database1_mdbDataSet14.Cust_info' table. You can move, or
remove it, as needed.
Me.Cust_infoTableAdapter1.Fill(Me._Database1_mdbDataSet14.Cust
_info)
57
58. cn = New
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|Database1.mdb.accdb")
ad = New OleDbDataAdapter("select * from Cust_info",
cn)
ds = New DataSet()
ad.Fill(ds)
End Sub
Private Sub exitbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles exitbtn.Click
Dim a As Integer
Dim OleDbYesNo As Integer
Dim OleDbQuestion As Integer
Dim OleDbYes As Integer
If a = OleDbYes Then
a = MsgBox(" you want to exit the Form?",
OleDbYesNo + OleDbQuestion, "confirm exit")
Me.Close()
End If
End Sub
Private Sub TextBox5_LostFocus(ByVal sender As Object, ByVal e
As System.EventArgs) Handles TextBox5.LostFocus
Dim bool As Boolean
Dim email As String = TextBox5.Text.Trim
bool = ((email.Contains("@") And email.Contains("."))
And (email.IndexOf("@") < email.IndexOf(".")) _
And (email.IndexOf("@") <> email.IndexOf(".")
- 1))
If bool = False Then
MsgBox("Enter Valid Email Address.",
MsgBoxStyle.Exclamation, "Invalid Email Address")
TextBox5.Text = ""
End If
End Sub
Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal e
As System.Windows.Forms.KeyPressEventArgs) Handles
TextBox2.KeyPress
Dim c As Char
c = e.KeyChar
If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then
e.Handled = True
MsgBox("enter only character")
58
59. End If
End Sub
Private Sub firstbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles firstbtn.Click
i = 0
Call add(i)
MsgBox("This is first Record")
End Sub
Private Sub previousbtn_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
previousbtn.Click
i = i - 1
If (i >= 0) Then
Call add(i)
Else
MsgBox("this is previous record")
End If
End Sub
Private Sub lastbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles lastbtn.Click
i = ds.Tables(0).Rows.Count - 1
Call add(i)
MsgBox("This is last Record")
End Sub
Private Sub nextbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles nextbtn.Click
i = i + 1
If (i < ds.Tables(0).Rows.Count) Then
Call add(i)
Else
MsgBox("this is next record")
End If
End Sub
Private Sub Button4_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button4.Click
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
59
60. ComboBox1.SelectedIndex = -1
TextBox4.Text = ""
TextBox5.Text = ""
End Sub
Private Sub Button3_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button3.Click
cn.Close()
cn.Open()
ds.Clear()
If TextBox1.Text = "" Then
MsgBox("Please Enter Cust_No")
ElseIf TextBox1.Text = "" Then
Else
ad = New OleDbDataAdapter("select * from Cust_info
where Cust_No=" & TextBox1.Text & "", cn)
ad.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
cn.Close()
End If
Dim cmd1 As New OleDbCommand
cn.Close()
cn.Open()
cmd1.Connection = cn
cmd1.CommandText = "select count(*) from Cust_info"
Dim m As Integer
m = cmd1.ExecuteScalar
a = Val(TextBox1.Text)
If a > m Then
MsgBox("No Record")
End If
End Sub
Private Sub Button2_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button2.Click
cn.Close()
cn.Open()
If (f = 0) Then
' dt = TextBox1.Text
' MsgBox(dt)
cmd = New OleDbCommand("Delete From Cust_info
where Cust_No=" & TextBox1.Text & "", cn)
60
61. cmd.ExecuteNonQuery()
End If
MsgBox("Record Deleted Successfully.")
End Sub
Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
cn.Close()
cn.Open()
If (f = 0) Then
If TextBox1.Text = "" Then
ElseIf TextBox2.Text = "" Then
ElseIf TextBox3.Text = "" Then
ElseIf ComboBox1.Text = "" Then
ElseIf TextBox4.Text = "" Then
ElseIf TextBox5.Text = "" Then
MsgBox("Please Enter Record")
Else
a = MsgBox("Are you want to save new
Customer?", vbYesNo + vbQuestion, "SAVE")
If a = vbYes Then
cmd = New OleDbCommand("insert into
Cust_info values('" & TextBox1.Text & "','" & TextBox2.Text &
"','" & TextBox3.Text & "','" & ComboBox1.Text & "','" &
TextBox4.Text & "','" & TextBox5.Text & "')", cn)
cmd.ExecuteNonQuery()
MsgBox("Record Save Successfully")
End If
End If
End If
End Sub
Sub add(ByVal i As Integer)
TextBox1.Text = ds.Tables(0).Rows(i).Item(0).ToString
TextBox2.Text = ds.Tables(0).Rows(i).Item(1).ToString
TextBox3.Text = ds.Tables(0).Rows(i).Item(2).ToString
ComboBox1.Text = ds.Tables(0).Rows(i).Item(3).ToString
TextBox4.Text = ds.Tables(0).Rows(i).Item(4).ToString
TextBox5.Text = ds.Tables(0).Rows(i).Item(5).ToString
End Sub
61
62. Private Sub Button5_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button5.Click
cn.Close()
cn.Open()
If (f = 0) Then
' dt = TextBox1.Text
' MsgBox(dt)
cmd = New OleDbCommand("Update Cust_info set Cust
No= ' " & TextBox1.Text & " ',Name= ' " & TextBox2.Text & "
' ,Address= ' " & TextBox3.Text & " ',Gender= ' " &
ComboBox1.Text & " ',Contact No=' " & TextBox5.Text & " ',E-
mail='" & TextBox6.Text & " 'where Cust_No=" & TextBox1.Text &
"", cn)
cmd.ExecuteNonQuery()
End If
MsgBox("Record Updated Successfully.")
End Sub
End Class
62
63. Program Name: emp.vb
Program Function: This is form is used to add new
employee and its details.
Test Data:-
Code:-
Imports System.Data.OleDb
Public Class emp
Dim cmd As OleDbCommand
Dim cn As New OleDbConnection
Dim ad As New OleDbDataAdapter
Dim ds As New DataSet
Dim dr As String
Dim dt As String
Dim i, f, a As Integer
Private Sub emp_Load(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the
'_Database1_mdbDataSet4.emp_details' table. You can move, or
remove it, as needed.
63
64. Me.Emp_detailsTableAdapter1.Fill(Me._Database1_mdbDataSet4.emp
_details)
cn = New
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|Database1.mdb.accdb")
ad = New OleDbDataAdapter("select * from emp_details",
cn)
ds = New DataSet()
ad.Fill(ds)
End Sub
Sub add(ByVal i As Integer)
TextBox1.Text = ds.Tables(0).Rows(i).Item(0).ToString
TextBox2.Text = ds.Tables(0).Rows(i).Item(1).ToString
TextBox3.Text = ds.Tables(0).Rows(i).Item(2).ToString
TextBox4.Text = ds.Tables(0).Rows(i).Item(3).ToString
TextBox5.Text = ds.Tables(0).Rows(i).Item(4).ToString
ComboBox1.Text = ds.Tables(0).Rows(i).Item(5).ToString
TextBox6.Text = ds.Tables(0).Rows(i).Item(6).ToString
TextBox7.Text = ds.Tables(0).Rows(i).Item(7).ToString
End Sub
Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal e
As System.Windows.Forms.KeyPressEventArgs) Handles
TextBox2.KeyPress
Dim c As Char
c = e.KeyChar
If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then
e.Handled = True
MsgBox("enter only character")
End If
End Sub
Private Sub TextBox3_KeyPress(ByVal sender As Object, ByVal e
As System.Windows.Forms.KeyPressEventArgs) Handles
TextBox3.KeyPress
Dim c As Char
c = e.KeyChar
If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then
e.Handled = True
MsgBox("enter only character")
End If
End Sub
64
65. Private Sub Btn_e_Save_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Save.Click
cn.Close()
cn.Open()
If (f = 0) Then
If TextBox1.Text = "" Then
ElseIf TextBox2.Text = "" Then
ElseIf TextBox3.Text = "" Then
ElseIf TextBox4.Text = "" Then
ElseIf TextBox5.Text = "" Then
ElseIf ComboBox1.Text = "" Then
ElseIf TextBox6.Text = "" Then
ElseIf TextBox7.Text = "" Then
MsgBox("Please Enter Record")
Else
a = MsgBox("Are you want to save new
Employee?", vbYesNo + vbQuestion, "SAVE")
If a = vbYes Then
cmd = New OleDbCommand("insert into
emp_details values('" & TextBox1.Text & "','" & TextBox2.Text
& "','" & TextBox3.Text & "','" & TextBox4.Text & "','" &
TextBox5.Text & "','" & ComboBox1.Text & "','" & TextBox6.Text
& "','" & TextBox7.Text & "' )", cn)
cmd.ExecuteNonQuery()
MsgBox("Record Save Successfully")
End If
End If
End If
End Sub
Private Sub Btn_e_Add_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Btn_e_Add.Click
TextBox1.Text = ""
TextBox2.Text = ""
TextBox3.Text = ""
TextBox4.Text = ""
ComboBox1.SelectedIndex = -1
TextBox5.Text = ""
TextBox6.Text = ""
TextBox7.Text = ""
End Sub
65
66. Private Sub Btn_e_Delete_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Delete.Click
cn.Close()
cn.Open()
If (f = 0) Then
If TextBox1.Text = "" Then
MsgBox("Please Enter Cust_No")
ElseIf TextBox1.Text = "" Then
Else
a = MsgBox("Are you want to Delete Employee?",
vbYesNo + vbQuestion, "Delete")
If a = vbYes Then
cmd = New OleDbCommand("Delete From
emp_details where Emp_ID=" & TextBox1.Text & "", cn)
cmd.ExecuteNonQuery()
MsgBox("Record Deleted Successfully.")
End If
End If
End If
End Sub
Private Sub Btn_e_Update_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Update.Click
cn.Close()
cn.Open()
a = "select * from emp_details where emp_ID = '" &
TextBox1.Text & "'"
cmd = New OleDbCommand("Update emp_details set Name= '
" & TextBox2.Text & " ',Address= ' " & TextBox3.Text & "
',Contact_No= ' " & TextBox4.Text & " ',Age=' " &
TextBox5.Text & " ', Gender= ' " & ComboBox1.Text & " '
,J_Date= ' " & TextBox6.Text & " ' ,Total_Sal= ' " &
TextBox7.Text & "' where emp_ID='" & TextBox1.Text & "')", cn)
cmd.ExecuteNonQuery()
MsgBox("Record Updated Successfully.")
End Sub
Private Sub Btn_e_First_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_First.Click
66
67. i = 0
Call add(i)
MsgBox("This is first Record")
End Sub
Private Sub Btn_e_Pre_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Btn_e_Pre.Click
i = i - 1
If (i >= 0) Then
Call add(i)
Else
MsgBox("this is previous record")
End If
End Sub
Private Sub Btn_e_Last_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Last.Click
i = ds.Tables(0).Rows.Count - 1
Call add(i)
MsgBox("This is last Record")
End Sub
Private Sub Btn_e_Next_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Next.Click
i = i + 1
If (i < ds.Tables(0).Rows.Count) Then
Call add(i)
Else
MsgBox("this is next record")
End If
End Sub
Private Sub Btn_e_Exit_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Exit.Click
Dim a As Integer
Dim OleDbYesNo As Integer
Dim OleDbQuestion As Integer
Dim OleDbYes As Integer
If a = OleDbYes Then
a = MsgBox(" you want to exit the Form?",
OleDbYesNo + OleDbQuestion, "confirm exit")
67
68. Me.Close()
End If
End Sub
Private Sub Btn_e_Search_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Search.Click
cn.Close()
cn.Open()
ds.Clear()
If TextBox1.Text = "" Then
MsgBox("Please Enter emp_details")
ElseIf TextBox1.Text = "" Then
Else
ad = New OleDbDataAdapter("select * from
emp_details where emp_ID=" & TextBox1.Text & "", cn)
ad.Fill(ds)
DataGridView1.DataSource = ds.Tables(0)
cn.Close()
End If
Dim cmd1 As New OleDbCommand
cn.Close()
cn.Open()
cmd1.Connection = cn
cmd1.CommandText = "select count(*) from emp_details"
Dim m As Integer
m = cmd1.ExecuteScalar
a = Val(TextBox1.Text)
If a > m Then
MsgBox("No Record")
End If
End Sub
End Class
68
69. Program Name: Supplier.vb
Program Function: This is form is used to add new
supplier and its details.
Test Data:-
Code:-
Imports System.Data.OleDb
Public Class supplier
Dim cmd As OleDbCommand
Dim cn As New OleDbConnection
Dim ad As New OleDbDataAdapter
Dim SlotAdapter As New OleDb.OleDbDataAdapter
Dim ds As New DataSet
Dim dr As String
Dim dt As String
Dim i, f, a As Integer
Private Sub supplier_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the
'_Database1_mdbDataSet12.supplier' table. You can move, or
remove it, as needed.
Me.SupplierTableAdapter1.Fill(Me._Database1_mdbDataSet12.suppl
ier)
69
70. cn = New
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|Database1.mdb.accdb")
ad = New OleDbDataAdapter("select * from Supplier",
cn)
ds = New DataSet()
ad.Fill(ds)
End Sub
Sub add(ByVal i As Integer)
Txt_bo_Ono.Text =
ds.Tables(0).Rows(i).Item(0).ToString
cmb_cm_sname.Text =
ds.Tables(0).Rows(i).Item(1).ToString
cmb_cm_model.Text =
ds.Tables(0).Rows(i).Item(2).ToString
Txt_bo_Qty.Text =
ds.Tables(0).Rows(i).Item(3).ToString
cmb_cm_color.Text =
ds.Tables(0).Rows(i).Item(4).ToString
Txt_bo_prize.Text =
ds.Tables(0).Rows(i).Item(5).ToString
txt_bo_total.Text =
ds.Tables(0).Rows(i).Item(6).ToString
Txt_bo_tax.Text =
ds.Tables(0).Rows(i).Item(7).ToString
txt_bo_totalprize.Text =
ds.Tables(0).Rows(i).Item(8).ToString
End Sub
Private Sub cal_btn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles cal_btn.Click
txt_bo_total.Text = Txt_bo_prize.Text *
Txt_bo_Qty.Text
Txt_bo_tax.Text = txt_bo_total.Text / 100
txt_bo_totalprize.Text = Val(txt_bo_total.Text) +
Val(Txt_bo_tax.Text)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
supplier_bill.Show()
End Sub
70
71. Private Sub Txt_bo_Qty_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Txt_bo_Qty.TextChanged
End Sub
Private Sub Btn_e_Save_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Save.Click
cn.Close()
cn.Open()
If (f = 0) Then
If Txt_bo_Ono.Text = "" Then
ElseIf cmb_cm_sname.Text = "" Then
ElseIf cmb_cm_model.Text = "" Then
ElseIf Txt_bo_Qty.Text = "" Then
ElseIf cmb_cm_color.Text = "" Then
ElseIf Txt_bo_prize.Text = "" Then
ElseIf txt_bo_total.Text = "" Then
ElseIf Txt_bo_tax.Text = "" Then
ElseIf txt_bo_totalprize.Text = "" Then
MsgBox("Please Enter Record")
Else
a = MsgBox("Are you want to save new
Supplier?", vbYesNo + vbQuestion, "SAVE")
If a = vbYes Then
cmd = New OleDbCommand("insert into
Supplier values('" & Txt_bo_Ono.Text & "','" &
cmb_cm_sname.Text & "','" & cmb_cm_model.Text & "','" &
Txt_bo_Qty.Text & "','" & cmb_cm_color.Text & "','" &
Txt_bo_prize.Text & "','" & txt_bo_total.Text & "','" &
Txt_bo_tax.Text & "','" & txt_bo_totalprize.Text & "')", cn)
cmd.ExecuteNonQuery()
MsgBox("Record Save Successfully")
End If
End If
End If
End Sub
71
72. Private Sub cmb_cm_model_SelectedIndexChanged(ByVal sender
As System.Object, ByVal e As System.EventArgs) Handles
cmb_cm_model.SelectedIndexChanged
If cmb_cm_model.SelectedIndex = "0" Then
Txt_bo_prize.Text = 25000
ElseIf cmb_cm_model.SelectedIndex = "1" Then
Txt_bo_prize.Text = 30000
ElseIf cmb_cm_model.SelectedIndex = "2" Then
Txt_bo_prize.Text = 27000
End If
End Sub
Private Sub Btn_e_Add_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Btn_e_Add.Click
Txt_bo_Ono.Text = ""
cmb_cm_sname.Text = ""
cmb_cm_model.Text = ""
Txt_bo_Qty.Text = ""
cmb_cm_color.Text = ""
Txt_bo_prize.Text = ""
txt_bo_total.Text = ""
Txt_bo_tax.Text = ""
txt_bo_totalprize.Text = ""
End Sub
Private Sub Btn_e_Delete_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Delete.Click
cn.Close()
cn.Open()
If (f = 0) Then
If Txt_bo_Ono.Text = "" Then
MsgBox("Please Enter Order no")
ElseIf Txt_bo_Ono.Text = "" Then
Else
a = MsgBox("Are you want to Delete Supplier?",
vbYesNo + vbQuestion, "Delete")
If a = vbYes Then
cmd = New OleDbCommand("Delete From
Supplier where O_no=" & Txt_bo_Ono.Text & "", cn)
cmd.ExecuteNonQuery()
MsgBox("Record Deleted Successfully.")
72
73. End If
End If
End If
End Sub
Private Sub Btn_e_Update_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Update.Click
End Sub
Private Sub Btn_e_First_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_First.Click
i = 0
Call add(i)
MsgBox("This is first Record")
End Sub
Private Sub Btn_e_Pre_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Btn_e_Pre.Click
i = i - 1
If (i >= 0) Then
Call add(i)
Else
MsgBox("this is previous record")
End If
End Sub
Private Sub Btn_e_Last_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Last.Click
i = ds.Tables(0).Rows.Count - 1
Call add(i)
MsgBox("This is last Record")
End Sub
Private Sub Btn_e_Next_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Next.Click
i = i + 1
If (i < ds.Tables(0).Rows.Count) Then
Call add(i)
Else
73
74. MsgBox("this is next record")
End If
End Sub
Private Sub Btn_e_Exit_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Exit.Click
Dim a As Integer
Dim OleDbYesNo As Integer
Dim OleDbQuestion As Integer
Dim OleDbYes As Integer
If a = OleDbYes Then
a = MsgBox(" you want to exit the Form?",
OleDbYesNo + OleDbQuestion, "confirm exit")
Me.Close()
End If
End Sub
Private Sub DataGridView1_CellContentClick(ByVal sender As
System.Object, ByVal e As
System.Windows.Forms.DataGridViewCellEventArgs) Handles
DataGridView1.CellContentClick
End Sub
End Class
74
75. Program Name: order.vb
Program Function: This is form is used to purchase
mobile.
Test Data:-
Code:-
Imports System.Data.OleDb
Public Class Order
Dim cmd As OleDbCommand
Dim cn As New OleDbConnection
Dim ad As New OleDbDataAdapter
Dim ds As New DataSet
Dim dr As String
Dim dt As String
Dim i, f, a As Integer
Private Sub purchase_order_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
'TODO: This line of code loads data into the
'_Database1_mdbDataSet15.Order' table. You can move, or remove
it, as needed.
Me.OrderTableAdapter.Fill(Me._Database1_mdbDataSet15.Order)
cn = New
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|Database1.mdb.accdb")
ad = New OleDbDataAdapter("select * from Order", cn)
75
76. ds = New DataSet()
End Sub
Sub add(ByVal i As Integer)
TextBox1.Text = ds.Tables(0).Rows(i).Item(0).ToString
TextBox2.Text = ds.Tables(0).Rows(i).Item(1).ToString
TextBox3.Text = ds.Tables(0).Rows(i).Item(2).ToString
TextBox4.Text = ds.Tables(0).Rows(i).Item(3).ToString
TextBox5.Text = ds.Tables(0).Rows(i).Item(4).ToString
cmb_pr_id.Text = ds.Tables(0).Rows(i).Item(6).ToString
txt_pr_name.Text =
ds.Tables(0).Rows(i).Item(7).ToString
TextBox6.Text = ds.Tables(0).Rows(i).Item(8).ToString
txt_mrp.Text = ds.Tables(0).Rows(i).Item(9).ToString
TextBox7.Text = ds.Tables(0).Rows(i).Item(10).ToString
End Sub
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal
e As System.Windows.Forms.KeyPressEventArgs) Handles
TextBox1.KeyPress
Dim c As Char
c = e.KeyChar
If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then
e.Handled = True
MsgBox("enter only character")
End If
End Sub
Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal
e As System.Windows.Forms.KeyPressEventArgs) Handles
TextBox2.KeyPress
Dim c As Char
c = e.KeyChar
If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then
e.Handled = True
MsgBox("enter only character")
End If
End Sub
Private Sub TextBox4_LostFocus(ByVal sender As Object, ByVal e
As System.EventArgs) Handles TextBox4.LostFocus
Dim bool As Boolean
Dim email As String = TextBox4.Text.Trim
bool = ((email.Contains("@") And email.Contains("."))
And (email.IndexOf("@") < email.IndexOf(".")) _
And (email.IndexOf("@") <> email.IndexOf(".")
- 1))
If bool = False Then
76
77. MsgBox("Enter Valid Email Address.",
MsgBoxStyle.Exclamation, "Invalid Email Address")
TextBox4.Text = ""
End If
End Sub
Private Sub cmb_pr_id_SelectedIndexChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
cmb_pr_id.SelectedIndexChanged
If cmb_pr_id.SelectedIndex = 0 Then
txt_pr_name.Text = "N8"
txt_mrp.Text = 25000
ElseIf cmb_pr_id.SelectedIndex = 1 Then
txt_pr_name.Text = "N900"
txt_mrp.Text = 30000
ElseIf cmb_pr_id.SelectedIndex = 2 Then
txt_pr_name.Text = "nokia 5233"
txt_mrp.Text = 6500
ElseIf cmb_pr_id.SelectedIndex = 3 Then
txt_pr_name.Text = "nokia E5"
txt_mrp.Text = 10519
ElseIf cmb_pr_id.SelectedIndex = 4 Then
txt_pr_name.Text = "nokia X5-01"
txt_mrp.Text = 9153
ElseIf cmb_pr_id.SelectedIndex = 5 Then
txt_pr_name.Text = "nokia X6"
txt_mrp.Text = 13839
ElseIf cmb_pr_id.SelectedIndex = 6 Then
txt_pr_name.Text = "nokia N97"
txt_mrp.Text = 23863
ElseIf cmb_pr_id.SelectedIndex = 7 Then
txt_pr_name.Text = "nokia N79"
txt_mrp.Text = 13355
ElseIf cmb_pr_id.SelectedIndex = 8 Then
txt_pr_name.Text = "nokia C3"
txt_mrp.Text = 5800
77
78. ElseIf cmb_pr_id.SelectedIndex = 9 Then
txt_pr_name.Text = "nokia 5800"
txt_mrp.Text = 13518
End If
End Sub
Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
Mobile_Bill.Show()
End Sub
Private Sub TextBox1_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
TextBox10.TextChanged
End Sub
Private Sub totalbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles totalbtn.Click
TextBox7.Text = TextBox6.Text * txt_mrp.Text
End Sub
Private Sub savebtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles savebtn.Click
cn.Close()
cn.Open()
If (f = 0) Then
If TextBox1.Text = "" Then
ElseIf TextBox2.Text = "" Then
ElseIf TextBox3.Text = "" Then
ElseIf TextBox4.Text = "" Then
ElseIf TextBox5.Text = "" Then
ElseIf cmb_pr_id.Text = "" Then
ElseIf txt_pr_name.Text = "" Then
ElseIf TextBox6.Text = "" Then
ElseIf txt_mrp.Text = "" Then
ElseIf TextBox7.Text = "" Then
Else
a = MsgBox("Are you want to save new Order?",
vbYesNo + vbQuestion, "SAVE")
If a = vbYes Then
cmd = New OleDbCommand("insert into Order
values('" & TextBox1.Text & "','" & TextBox2.Text & "' ,'" &
TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text
& "','" & cmb_pr_id.Text & "','" & txt_pr_name.Text & "','" &
TextBox6.Text & "','" & txt_mrp.Text & "','" & TextBox7.Text &
"')", cn)
78
79. cmd.ExecuteNonQuery()
MsgBox("Record Saved Successfully.")
End If
End If
End If
End Sub
Private Sub TextBox2_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
TextBox2.TextChanged
End Sub
Private Sub newbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles newbtn.Click
TextBox1.Text = " "
TextBox2.Text = " "
TextBox3.Text = " "
TextBox4.Text = " "
TextBox5.Text = " "
cmb_pr_id.Text = " "
txt_pr_name.Text = " "
TextBox6.Text = " "
txt_mrp.Text = ""
TextBox7.Text = " "
End Sub
Private Sub TextBox5_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
TextBox5.TextChanged
End Sub
Private Sub deletebtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles deletebtn.Click
cn.Close()
cn.Open()
If (f = 0) Then
If TextBox1.Text = "" Then
MsgBox("Please Enter Customer name",
vbInformation, "Enter")
ElseIf TextBox1.Text = "" Then
Else
a = MsgBox("Are you want to Order Bill?",
vbYesNo + vbQuestion, "Delete")
If a = vbYes Then
cmd = New OleDbCommand("Delete From Order
where Order_no=" & TextBox5.Text & "", cn)
cmd.ExecuteNonQuery()
79
80. MsgBox("Record Deleted Successfully.")
End If
End If
End If
End Sub
Private Sub firstbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles firstbtn.Click
i = 0
Call add(i)
MsgBox("This is first Record")
End Sub
Private Sub previousbtn_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
previousbtn.Click
i = i - 1
If (i >= 0) Then
Call add(i)
Else
MsgBox("this is previous record")
End If
End Sub
Private Sub lastbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles lastbtn.Click
i = i + 1
If (i < ds.Tables(0).Rows.Count) Then
Call add(i)
Else
MsgBox("this is next record")
End If
End Sub
Private Sub nextbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles nextbtn.Click
i = ds.Tables(0).Rows.Count - 1
Call add(i)
MsgBox("This is last Record")
End Sub
Private Sub exitbtn_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles exitbtn.Click
Dim a As Integer
Dim OleDbYesNo As Integer
Dim OleDbQuestion As Integer
Dim OleDbYes As Integer
If a = OleDbYes Then
a = MsgBox(" you want to exit the Form?",
OleDbYesNo + OleDbQuestion, "confirm exit")
Me.Close()
80
81. End If
End Sub
Private Sub TextBox7_TextChanged(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
TextBox7.TextChanged
End Sub
Private Sub Panel2_Paint(ByVal sender As System.Object,
ByVal e As System.Windows.Forms.PaintEventArgs) Handles
Panel2.Paint
End Sub
Private Sub DataGridView1_CellContentClick(ByVal sender As
System.Object, ByVal e As
System.Windows.Forms.DataGridViewCellEventArgs) Handles
DataGridView1.CellContentClick
End Sub
End Class
81
82. Program Name:-Salary.vb
Program Function: This is form is used to generate
salary of employee.
Test Data:-
Code:-
Imports System.Data.OleDb
Public Class salary
Dim cmd As OleDbCommand
Dim cn As New OleDbConnection
Dim ad As New OleDbDataAdapter
Dim ds As New DataSet
Dim dt As String
Dim a, i, f As Integer
Private Sub DataGridView1_CellContentClick(ByVal sender As
System.Object, ByVal e As
System.Windows.Forms.DataGridViewCellEventArgs)
End Sub
Private Sub emp_Load(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles MyBase.Load
82
83. 'TODO: This line of code loads data into the
'_Database1_mdbDataSet13.Salary' table. You can move, or
remove it, as needed.
Me.SalaryTableAdapter.Fill(Me._Database1_mdbDataSet13.Salary)
cn = New
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|Database1.mdb.accdb")
ad = New OleDbDataAdapter("select * from Salary", cn)
ds = New DataSet()
ad.Fill(ds)
End Sub
Sub add(ByVal i As Integer)
TextBox1.Text = ds.Tables(0).Rows(i).Item(0).ToString
TextBox2.Text = ds.Tables(0).Rows(i).Item(1).ToString
TextBox3.Text = ds.Tables(0).Rows(i).Item(2).ToString
TextBox4.Text = ds.Tables(0).Rows(i).Item(3).ToString
TextBox5.Text = ds.Tables(0).Rows(i).Item(4).ToString
TextBox6.Text = ds.Tables(0).Rows(i).Item(5).ToString
End Sub
Private Sub Btn_e_Save_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Save.Click
cn.Close()
cn.Open()
If (f = 0) Then
' dt = TextBox1.Text
' MsgBox(dt)
cmd = New OleDbCommand("insert into Salary
values('" & TextBox1.Text & "','" & TextBox2.Text & "' ,'" &
TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text
& "','" & TextBox6.Text & "')", cn)
cmd.ExecuteNonQuery()
End If
MsgBox("Record Saved Successfully.")
End Sub
Private Sub Btn_e_Add_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Btn_e_Add.Click
TextBox1.Text = " "
TextBox2.Text = " "
TextBox3.Text = " "
83
84. TextBox4.Text = " "
TextBox5.Text = " "
TextBox6.Text = " "
End Sub
Private Sub Btn_e_Delete_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Delete.Click
cn.Close()
cn.Open()
If (f = 0) Then
' dt = TextBox1.Text
' MsgBox(dt)
cmd = New OleDbCommand("Delete From Salary where
Emp_ID=" & TextBox1.Text & "", cn)
cmd.ExecuteNonQuery()
End If
MsgBox("Record Deleted Successfully.")
End Sub
Private Sub Btn_e_Update_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Update.Click
cn.Close()
cn.Open()
If (f = 0) Then
' dt = TextBox1.Text
' MsgBox(dt)
cmd = New OleDbCommand("Update Salary set Emp_ID=
' " & TextBox1.Text & " ',F_Name= ' " & TextBox2.Text & " '
,L_Name= ' " & TextBox3.Text & " ',D_o_sal= ' " &
TextBox4.Text & " ',Advance=' " & TextBox5.Text & " ',T_sal='"
& TextBox6.Text & " 'where Emp_ID=" & TextBox1.Text & "", cn)
cmd.ExecuteNonQuery()
End If
MsgBox("Record Updated Successfully.")
End Sub
Private Sub Btn_e_First_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_First.Click
i = 0
84
85. Call add(i)
MsgBox("This is first Record")
End Sub
Private Sub Btn_e_Pre_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Btn_e_Pre.Click
i = i - 1
If (i >= 0) Then
Call add(i)
Else
MsgBox("this is previous record")
End If
End Sub
Private Sub Btn_e_Last_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Last.Click
i = ds.Tables(0).Rows.Count - 1
Call add(i)
MsgBox("This is last Record")
End Sub
Private Sub Btn_e_Next_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Next.Click
i = i + 1
If (i < ds.Tables(0).Rows.Count) Then
Call add(i)
Else
MsgBox("this is next record")
End If
End Sub
Private Sub Btn_e_Exit_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Exit.Click
Dim a As Integer
Dim OleDbYesNo As Integer
Dim OleDbQuestion As Integer
Dim OleDbYes As Integer
If a = OleDbYes Then
a = MsgBox(" you want to exit the Form?",
OleDbYesNo + OleDbQuestion, "confirm exit")
Me.Close()
85
86. End If
End Sub
Private Sub Btn_e_Search_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
Btn_e_Search.Click
End Sub
Private Sub FillByToolStripButton_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs)
Try
Me.EmpTableAdapter1.FillBy(Me._Database1_mdbDataSet2.emp)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
End Sub
Private Sub TextBox2_KeyPress(ByVal sender As Object, ByVal
e As System.Windows.Forms.KeyPressEventArgs) Handles
TextBox2.KeyPress
Dim c As Char
c = e.KeyChar
If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then
e.Handled = True
MsgBox("enter only character")
End If
End Sub
Private Sub TextBox3_KeyPress(ByVal sender As Object, ByVal
e As System.Windows.Forms.KeyPressEventArgs) Handles
TextBox3.KeyPress
Dim c As Char
c = e.KeyChar
If Not (Char.IsLetter(c) Or Char.IsControl(c)) Then
e.Handled = True
MsgBox("enter only character")
End If
End Sub
End Class
86
87. Program Name: Mobile Details.vb
Program Function: This Form display the various
Mobile Details.
Test Result:
87
89. Program Name:-Mobile Bill.vb
Program Function: This is form is used to display
receipt of individual customer.
Test Result:-
Code:-
Imports System.Data.OleDb
Public Class Mobile_Bill
Dim cn As New OleDbConnection
Private Sub Mobile_Bill_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
cn = New
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|Database1.mdb.accdb")
Label2.Text = Order.TextBox1.Text
89
90. Lno.Text = Order.TextBox5.Text
Lname.Text = Order.txt_pr_name.Text
Lqty.Text = Order.TextBox6.Text
Lper_prize.Text = Order.txt_mrp.Text
Lammount.Text = Order.TextBox7.Text
End Sub
Private Sub btn_print_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles btn_print.Click
PrintForm1.Print(Me,
PowerPacks.Printing.PrintForm.PrintOption.CompatibleModeFullWi
ndow)
End Sub
End Class
90
91. Program Name:-Supplier Bill.vb
Program Function: This is form is used to display
receipt of supplier bill.
Test Result:-
Code:-
Imports System.Data.OleDb
Public Class supplier_bill
Dim cn As New OleDbConnection
Private Sub supplier_bill_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
cn = New
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|Database1.mdb.accdb")
Label2.Text = supplier.cmb_cm_sname.SelectedItem
Lno.Text = supplier.Txt_bo_Ono.Text
Lname.Text = supplier.cmb_cm_model.Text
Lqty.Text = supplier.Txt_bo_Qty.Text
Lper_prize.Text = supplier.Txt_bo_prize.Text
91
92. Lammount.Text = supplier.txt_bo_total.Text
End Sub
Private Sub btn_print_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles btn_print.Click
PrintForm1.Print(Me,
PowerPacks.Printing.PrintForm.PrintOption.CompatibleModeFullWi
ndow)
End Sub
End Class
Report Layouts
Report Name:- Report Bill.vb
Report function:- This form displays purchase order
Report of the supplier.
Test Result:-
92
93. Code:-
Imports CrystalDecisions.CrystalReports.Engine
Public Class Report_bill
Private Sub Report_bill_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
Dim cryRpt As New ReportDocument
cryRpt.Load("F:ImppppppppArtiCrystalReport1.rpt")
CrystalReportViewer1.ReportSource = cryRpt
CrystalReportViewer1.Update()
End Sub
End Class
93
94. Report Name:- Supplier_bill.vb
Report function:- This form displays all customers bill.
Test Result:-
Code:-
Imports CrystalDecisions.CrystalReports.Engine
Public Class supplier_report
Private Sub supplier_report_Load(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
MyBase.Load
Dim cryRpt As New ReportDocument
cryRpt.Load("F:ImppppppppArtiCrystalReport2.rpt")
CrystalReportViewer1.ReportSource = cryRpt
CrystalReportViewer1.Update()
End Sub
End Class
94
96. System Implementation
VARIABLE NAME DATA TYPE DESCRIPTION
Cn Connection To make the
connection between
application & database.
Cmd SqlCommand To execute sql query
on table
Reader SqlDataReader To read data retrieve
by sqlcommand.
CryRpt CrystalReport
To display crystal
report.
SYSTEM CONTROLS AND STANDARDS
1. Access control:-
System gives access by valid password.
2. Input control:-
System validates every textbox. It allows textual values for fields like customer
name. It also validates some numeric data only for fields like phone no.
3. System Generated control:-
In Order details it automatically calculates total price of the product. Similarly in
Receipt details it automatically deducts the amount from the actual amount.
4. Range control:-
In Order Transaction the system checks whether quantity given by the user is not
more than the available product.
96
98. Future Enhancement
Being a computer system, the system has good scope to be
improved further.
Future Enhancements are as listed below
Maintain daily employee attendance.
Administrator can be given more rights so that he will be able
to change order details.
Conclusion
• System helps to store all the data about the customer order in computer
and there is no need to do paper work.
• Data is going to be preserved carefully for longer period hence proper
backup is required otherwise there is chance of losing entries or data.
98