This document is a project report for an E-Billing and Invoice System submitted in partial fulfillment of a B.Tech degree. It contains sections on system analysis, design, and implementation. The system analysis section outlines business requirements like automating the bill generation process and providing reports. User requirements for sales, accounting, and management staff are also defined. The system design section includes UML diagrams and data dictionaries. The implementation section begins code for a login form. The overall purpose is to develop a software system to automate an organization's manual billing and invoicing process.
This document provides an overview of an e-billing and invoice system project. It describes the objectives of creating a secure, fast, and easy-to-use electronic billing system to replace a manual Excel-based process. It outlines the key user profiles, features including managing customers, orders, products, and reports. It also includes software and hardware requirements and describes the planned frontend and backend technologies.
This document outlines a banking management system project that includes maintaining customer accounts, deposits, withdrawals, currency conversion, and other banking tasks. The project supervisor is Ahmad Aslam and the group members are Chaudhry Sajid, Mohsin Riaz, Affan Shahzad, and Ebad Ur Rahman. The system provides customers access to create accounts, deposit and withdraw cash, and view account balances. Requirements include software like Oracle Database, hardware specifications, and functionalities like registration, transactions, inquiries, and administration. Diagrams show entity relationships and use cases. Code examples demonstrate queries and functionality.
This document outlines the requirements for a store inventory control system. It will automate tasks like tracking inventory levels, calculating reorder amounts, and placing orders. The system must be easy for staff to use, accurate, and reliable. It will allow admin to add, update, and delete stock items. The system aims to streamline the inventory management process and reduce errors compared to manual methods. Non-functional requirements include usability, reliability, performance, supportability and packaging. The detailed design goals are for low response time, high robustness, reliability, and extensibility with low fault tolerance and adaptability.
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.
Medical store management System is a software to manage the store and billing. It has a special feature like bill messaging and mailing bills to the customers. Special offer alert and warehouse management is an additional thing in Medical Store Management System.
The document describes a proposed food ordering system called iOder. It discusses how current manual food ordering processes can be time-consuming and error-prone. The objectives of iOder are to study how an online ordering system could address these issues, design and develop such a system, and test its usability and functionality. Key features of iOder would allow customers to view menus, place orders, and get order confirmations, and employees to manage menus, bookings, and process orders. The document outlines the system development methodology, hardware and software requirements, and proposed system design diagrams for iOder.
The project “Billing system” is an application to automate the process of ordering
And billing of a restaurant .This application is developed for the established restaurants in the city to manage the billing operations. It has the entire basic module to operate the billing modules. This application also administrates its users and customers.
This project will serve the following objectives:-
• Add and maintain records of available products.
• Add and maintain customer details.
• Add and maintain description of new products.
• Add and maintain admin and employee details.
• Provides a convenient solution of billing pattern.
• Make an easy to use environment for users and customers.
• Create membership for customers.
The document discusses a proposed ticketing system to track technical problems, manage IT assets, and provide a knowledge base. The current system lacks organization and record keeping. The proposed system would allow employees to submit problems, technical support to receive and solve issues while recording the solutions. It would manage data on assets, problems, and solutions to generate analytical reports. Key benefits include tracking problems, generating performance reports, highlighting weaknesses, providing a knowledge base for employees, and improving process of managing data and issues.
This document provides an overview of an e-billing and invoice system project. It describes the objectives of creating a secure, fast, and easy-to-use electronic billing system to replace a manual Excel-based process. It outlines the key user profiles, features including managing customers, orders, products, and reports. It also includes software and hardware requirements and describes the planned frontend and backend technologies.
This document outlines a banking management system project that includes maintaining customer accounts, deposits, withdrawals, currency conversion, and other banking tasks. The project supervisor is Ahmad Aslam and the group members are Chaudhry Sajid, Mohsin Riaz, Affan Shahzad, and Ebad Ur Rahman. The system provides customers access to create accounts, deposit and withdraw cash, and view account balances. Requirements include software like Oracle Database, hardware specifications, and functionalities like registration, transactions, inquiries, and administration. Diagrams show entity relationships and use cases. Code examples demonstrate queries and functionality.
This document outlines the requirements for a store inventory control system. It will automate tasks like tracking inventory levels, calculating reorder amounts, and placing orders. The system must be easy for staff to use, accurate, and reliable. It will allow admin to add, update, and delete stock items. The system aims to streamline the inventory management process and reduce errors compared to manual methods. Non-functional requirements include usability, reliability, performance, supportability and packaging. The detailed design goals are for low response time, high robustness, reliability, and extensibility with low fault tolerance and adaptability.
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.
Medical store management System is a software to manage the store and billing. It has a special feature like bill messaging and mailing bills to the customers. Special offer alert and warehouse management is an additional thing in Medical Store Management System.
The document describes a proposed food ordering system called iOder. It discusses how current manual food ordering processes can be time-consuming and error-prone. The objectives of iOder are to study how an online ordering system could address these issues, design and develop such a system, and test its usability and functionality. Key features of iOder would allow customers to view menus, place orders, and get order confirmations, and employees to manage menus, bookings, and process orders. The document outlines the system development methodology, hardware and software requirements, and proposed system design diagrams for iOder.
The project “Billing system” is an application to automate the process of ordering
And billing of a restaurant .This application is developed for the established restaurants in the city to manage the billing operations. It has the entire basic module to operate the billing modules. This application also administrates its users and customers.
This project will serve the following objectives:-
• Add and maintain records of available products.
• Add and maintain customer details.
• Add and maintain description of new products.
• Add and maintain admin and employee details.
• Provides a convenient solution of billing pattern.
• Make an easy to use environment for users and customers.
• Create membership for customers.
The document discusses a proposed ticketing system to track technical problems, manage IT assets, and provide a knowledge base. The current system lacks organization and record keeping. The proposed system would allow employees to submit problems, technical support to receive and solve issues while recording the solutions. It would manage data on assets, problems, and solutions to generate analytical reports. Key benefits include tracking problems, generating performance reports, highlighting weaknesses, providing a knowledge base for employees, and improving process of managing data and issues.
This document outlines the requirements for an inventory management system for a general store. It includes four key user roles: administrator, salesperson, sales manager, and inventory manager. The administrator can add/edit/delete user accounts and product inventory. Salespeople can view inventory levels, search for products, generate bills, cancel bills, return unsatisfactory items, and notify managers. Sales managers oversee exceptions and the inventory manager replenishes stock levels based on salesperson notifications. Data flow diagrams and entity relationship diagrams are also included to design the system's architecture and database structure.
This document is a project report submitted by Aaditya Shah for his AISSCE examination in 2013-2014 on a Library Management System created under the guidance of Sanjay Parmar. The report includes a declaration by Aaditya Shah, an acknowledgement thanking those who supported the project, and a certificate signed by the principal and teacher confirming the project fulfillment. The report then provides an introduction to the Library Management System software created, an analysis of the existing manual library system and benefits of the proposed computerized system, a feasibility analysis, hardware and software requirements, descriptions of the system interface and design.
This document describes a restaurant management system project that was developed using Visual Studio 2008 and SQL Server 2005. The system allows a restaurant to manage inventory, employee records, sales, purchases and generate reports. It aims to automate the manual processes currently used in restaurants to make record keeping easier and more efficient. The document outlines the existing manual system and limitations, proposed computerized system and its advantages, system requirements and modules developed.
Hospital Management System Project Report Sarfaraj Alam
The document provides an overview of a hospital management system project implemented using PHP. It discusses the various modules of the project including admin, user/patient, doctor, nurse, pharmacist, laboratories, and accountant modules. It also covers the requirements specification including hardware requirements of Intel dual-core processor, 1GB RAM, 80GB hard disk and software requirements of Windows 7/8/10, HTML, CSS, JavaScript, and MySQL database. The feasibility study and existing manual system are analyzed and the benefits of the proposed web-based system are outlined.
Library Management System Waterfall Modelmitwa1990
The document provides a summary of a team project to develop a Computerized Library Management System called Quick Access. It outlines the team members, topics to be covered which include objectives, competitive analysis, system functionality, non-functional requirements and future enhancements. It also discusses the project management approach including using a waterfall model, estimating time and costs using a work breakdown structure, and identifying risks.
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 provides information about an IT services company called Coalesce Technologies. It discusses Coalesce's services, commitment to client satisfaction, growing network, and customized solutions. It also describes the library management system project, including the problems with existing systems, proposed new system features, and UML diagrams for modeling the system. Key aspects of the proposed system include automating transactions, providing a simple GUI, efficient database updating, and restricting administrative access for security.
Wants to view the record of all students
Pre-Conditions The records of students are already added in the database.
Post-Conditions The record of all students is presented in tabular form.
Main Success Scenario 1. Admin selects the menu option to view record of all students.
2. LMS presents the record of all students in tabular form.
Alternative Flows: None
Technology Online web access is supported.
Special Requirements In case of high latency the response time may exceed up to 1 minute.
The System can support Urdu English and French language.
Open Issues If the site
This document summarizes an e-restaurant automation project created by a team of students. The team's tasks included requirements gathering, database design, implementation, and testing. The project aims to automate ordering and other activities in traditional restaurants. It uses a point-of-sale system with a .NET backend and SQL Server database. Customers can order from an Android app while staff manage orders, payments and other functions through a desktop interface. The system was designed to save restaurants money and time while improving customer and staff experience over traditional paper-based methods.
This project report describes a Hospital Management System (HMS) that was developed to automate operations at hospitals. The HMS allows for maintaining patient records, storing diagnosis and test information, providing test facilities for doctors, and generating bills. It has two user levels - administrator and user. The report provides an introduction to the system, describes overall goals and requirements, presents data flow diagrams and database tables, and includes screenshots of the system interface. It concludes that the HMS aims to efficiently digitize hospital workflows and storage of patient information.
This Document Contains All DFDs, Uml Diagrams, Test Cases, Functional Requirements, Non-Functional requirements, Database Design and User Interface Diagrams. Hope it helps
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.
This document provides a software requirements specification for a Hospital Management System. It includes sections on the introduction, intended audience, product perspective, user classes and environment, functional requirements, and other non-functional requirements. The system will allow authorized users like administrators, doctors, nurses, and patients to access modules for management of hospital activities, patient records, appointments, billing, and more. It aims to automate paper-based hospital processes for improved efficiency, accuracy, and data security.
Design and implementation of a hospital management systemOvercomer Michael
This document provides an introduction and background to a hospital management system project. It discusses the limitations of the current manual system, including that it is time-consuming and prone to errors. The proposed computerized system aims to automate key hospital processes like admissions, discharges, doctor assignments, and billing online. It also discusses the benefits of the proposed system, like increased efficiency, control, security and easy retrieval of patient information. Some limitations of the proposed system are also outlined, such as potential for incorrect information entry and lack of immediate information retrieval.
The document describes an employee management system that was developed to simplify maintaining records for employees in a company. It maintains personal and official details of employees, including salary calculation, attendance tracking, and various leave categories. The system aims to overcome issues with the previous manual paper-based system by providing a computerized database, faster searching and updating of records, and generation of reports for management. It includes modules for administration, employee access, and functionality for attendance, leave, salary processing, and more.
This document describes an employee management system that aims to simplify maintaining employee records by developing a well-designed database. It allows administrators to add, remove, and edit employee details as well as manage employee attendance, leaves, finance, and performance. Employees can also access information related to their attendance, leaves, and salary through an online dashboard. The system provides a computerized and more efficient alternative to the traditional manual method of maintaining employee records.
This document introduces the key components of a telecommunication billing system, including services, accounts, ratings, invoices, payments, and billing types. It describes how a billing system processes usage records, determines rates, generates invoices, and collects payments. Specifically, it outlines a system where users can order services, those services are linked to accounts, and usage is tracked to produce postpaid or prepaid invoices depending on the billing type.
This document is a project report submitted by Alok Sharma for a summer training internship on a Console Based Billing System. The report provides details of the project including objectives to create a convenient billing solution and generate financial reports. It discusses the existing manual system and problems with it. The proposed computerized system aims to be more user friendly, support data sharing and modification, and strategic decision making through easy report generation. A feasibility analysis is also included covering technical, behavioral, economic and product aspects.
CUSTOMER CARE ADMINISTRATION-developer-2000 and oracle 9iAkash Gupta
This document discusses a project titled "CUSTOMER CARE ADMINISTRATION". The project aims to develop a system to handle all aspects of customer relationship management, including registering customer complaints, assigning complaints to agents for resolution, tracking complaint status, and generating reports. The system will use Developer 2000 for the front-end and Oracle 9i for the backend database. An analysis of the current manual system identified needs for the new automated system, including more efficient complaint handling, real-time complaint status visibility, and report generation for management.
This document outlines the requirements for an inventory management system for a general store. It includes four key user roles: administrator, salesperson, sales manager, and inventory manager. The administrator can add/edit/delete user accounts and product inventory. Salespeople can view inventory levels, search for products, generate bills, cancel bills, return unsatisfactory items, and notify managers. Sales managers oversee exceptions and the inventory manager replenishes stock levels based on salesperson notifications. Data flow diagrams and entity relationship diagrams are also included to design the system's architecture and database structure.
This document is a project report submitted by Aaditya Shah for his AISSCE examination in 2013-2014 on a Library Management System created under the guidance of Sanjay Parmar. The report includes a declaration by Aaditya Shah, an acknowledgement thanking those who supported the project, and a certificate signed by the principal and teacher confirming the project fulfillment. The report then provides an introduction to the Library Management System software created, an analysis of the existing manual library system and benefits of the proposed computerized system, a feasibility analysis, hardware and software requirements, descriptions of the system interface and design.
This document describes a restaurant management system project that was developed using Visual Studio 2008 and SQL Server 2005. The system allows a restaurant to manage inventory, employee records, sales, purchases and generate reports. It aims to automate the manual processes currently used in restaurants to make record keeping easier and more efficient. The document outlines the existing manual system and limitations, proposed computerized system and its advantages, system requirements and modules developed.
Hospital Management System Project Report Sarfaraj Alam
The document provides an overview of a hospital management system project implemented using PHP. It discusses the various modules of the project including admin, user/patient, doctor, nurse, pharmacist, laboratories, and accountant modules. It also covers the requirements specification including hardware requirements of Intel dual-core processor, 1GB RAM, 80GB hard disk and software requirements of Windows 7/8/10, HTML, CSS, JavaScript, and MySQL database. The feasibility study and existing manual system are analyzed and the benefits of the proposed web-based system are outlined.
Library Management System Waterfall Modelmitwa1990
The document provides a summary of a team project to develop a Computerized Library Management System called Quick Access. It outlines the team members, topics to be covered which include objectives, competitive analysis, system functionality, non-functional requirements and future enhancements. It also discusses the project management approach including using a waterfall model, estimating time and costs using a work breakdown structure, and identifying risks.
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 provides information about an IT services company called Coalesce Technologies. It discusses Coalesce's services, commitment to client satisfaction, growing network, and customized solutions. It also describes the library management system project, including the problems with existing systems, proposed new system features, and UML diagrams for modeling the system. Key aspects of the proposed system include automating transactions, providing a simple GUI, efficient database updating, and restricting administrative access for security.
Wants to view the record of all students
Pre-Conditions The records of students are already added in the database.
Post-Conditions The record of all students is presented in tabular form.
Main Success Scenario 1. Admin selects the menu option to view record of all students.
2. LMS presents the record of all students in tabular form.
Alternative Flows: None
Technology Online web access is supported.
Special Requirements In case of high latency the response time may exceed up to 1 minute.
The System can support Urdu English and French language.
Open Issues If the site
This document summarizes an e-restaurant automation project created by a team of students. The team's tasks included requirements gathering, database design, implementation, and testing. The project aims to automate ordering and other activities in traditional restaurants. It uses a point-of-sale system with a .NET backend and SQL Server database. Customers can order from an Android app while staff manage orders, payments and other functions through a desktop interface. The system was designed to save restaurants money and time while improving customer and staff experience over traditional paper-based methods.
This project report describes a Hospital Management System (HMS) that was developed to automate operations at hospitals. The HMS allows for maintaining patient records, storing diagnosis and test information, providing test facilities for doctors, and generating bills. It has two user levels - administrator and user. The report provides an introduction to the system, describes overall goals and requirements, presents data flow diagrams and database tables, and includes screenshots of the system interface. It concludes that the HMS aims to efficiently digitize hospital workflows and storage of patient information.
This Document Contains All DFDs, Uml Diagrams, Test Cases, Functional Requirements, Non-Functional requirements, Database Design and User Interface Diagrams. Hope it helps
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.
This document provides a software requirements specification for a Hospital Management System. It includes sections on the introduction, intended audience, product perspective, user classes and environment, functional requirements, and other non-functional requirements. The system will allow authorized users like administrators, doctors, nurses, and patients to access modules for management of hospital activities, patient records, appointments, billing, and more. It aims to automate paper-based hospital processes for improved efficiency, accuracy, and data security.
Design and implementation of a hospital management systemOvercomer Michael
This document provides an introduction and background to a hospital management system project. It discusses the limitations of the current manual system, including that it is time-consuming and prone to errors. The proposed computerized system aims to automate key hospital processes like admissions, discharges, doctor assignments, and billing online. It also discusses the benefits of the proposed system, like increased efficiency, control, security and easy retrieval of patient information. Some limitations of the proposed system are also outlined, such as potential for incorrect information entry and lack of immediate information retrieval.
The document describes an employee management system that was developed to simplify maintaining records for employees in a company. It maintains personal and official details of employees, including salary calculation, attendance tracking, and various leave categories. The system aims to overcome issues with the previous manual paper-based system by providing a computerized database, faster searching and updating of records, and generation of reports for management. It includes modules for administration, employee access, and functionality for attendance, leave, salary processing, and more.
This document describes an employee management system that aims to simplify maintaining employee records by developing a well-designed database. It allows administrators to add, remove, and edit employee details as well as manage employee attendance, leaves, finance, and performance. Employees can also access information related to their attendance, leaves, and salary through an online dashboard. The system provides a computerized and more efficient alternative to the traditional manual method of maintaining employee records.
This document introduces the key components of a telecommunication billing system, including services, accounts, ratings, invoices, payments, and billing types. It describes how a billing system processes usage records, determines rates, generates invoices, and collects payments. Specifically, it outlines a system where users can order services, those services are linked to accounts, and usage is tracked to produce postpaid or prepaid invoices depending on the billing type.
This document is a project report submitted by Alok Sharma for a summer training internship on a Console Based Billing System. The report provides details of the project including objectives to create a convenient billing solution and generate financial reports. It discusses the existing manual system and problems with it. The proposed computerized system aims to be more user friendly, support data sharing and modification, and strategic decision making through easy report generation. A feasibility analysis is also included covering technical, behavioral, economic and product aspects.
CUSTOMER CARE ADMINISTRATION-developer-2000 and oracle 9iAkash Gupta
This document discusses a project titled "CUSTOMER CARE ADMINISTRATION". The project aims to develop a system to handle all aspects of customer relationship management, including registering customer complaints, assigning complaints to agents for resolution, tracking complaint status, and generating reports. The system will use Developer 2000 for the front-end and Oracle 9i for the backend database. An analysis of the current manual system identified needs for the new automated system, including more efficient complaint handling, real-time complaint status visibility, and report generation for management.
This document is the final project report submitted by Waqar Younas and Yasmin Akhter for their Master's degree in Computer Science. It outlines the development of an Accounts Management System for a spray center. The report includes chapters on project introduction and background, requirements analysis, planning and design, implementation, and testing. The system aims to help the dealer manage customer and supplier records, transactions, expenses, reports, and other accounting tasks online as the current manual system is time-consuming. It was developed using HTML, PHP, MySQL, JavaScript, jQuery and CSS. Various diagrams and test cases are included to document the system analysis, design, and testing process.
This document provides a summary of Tarunpreet Singh's 6-month industrial training project at Aviox Technology Pvt Ltd from January 2022 to June 2022. The project involved developing a Real Estate Management System using the Django framework. Key features included user registration/login, property search functionality, and an admin dashboard. The project utilized HTML, CSS, JavaScript, and a SQLite3 database. The training helped Tarunpreet Singh gain experience in software development lifecycles, technologies like Python and Django, and project implementation.
includes the followingBusiness Case InvestigationIdenti.docxannettsparrow
includes the following:
Business Case Investigation
Identify 4 employees to interview to support business analysis. For each employee, state the topic(s) used for questioning. The interview topics and responses will be used to influence future design.
A possible use case diagram for making an appointment and verifying parts availability
Identify the users of the system and requests into and out of the system.
Implementation resources needed for the project
Identify people and hardware. Human resources may include internal or external resources.
I am delighted to announce that Emily Johns will be starting at Appliance Warehouse today! Emily will be undertaking the role of Service Manager and will be the force behind creating our new service department.
Emily comes to us with 25 years of experience in the service repair industry. Emily began her career as a service technician and quickly moved through the ranks to the first female service manager in ABC Appliance Service Company's history. After 17 years, she went to work for Acme Appliance Repair. Over the last 8 years, the revenue for Acme increased by 200% after being stagnant for the preceding 5 years
Our new service manager starts work today! This is great news! As our business starts to expand, we must move our software project along.
need to talk to some of our employees to better understand the functionality and requirements for the proposed system. This is important because they are the key stakeholders of the system. list of employees who will want to interview. learn the process for scheduling an appliance repair appointment and how the parts are obtained for those repair visits. Also, it is important to understand what reports that managers are hoping to extract from the new system. I find it is helpful to write down questions prior to your meetings as to not forget the topics that you want to cover.
My suggestion is at least 10 questions per person prior to the meeting. Make sure to use open-ended questions (at least 7 questions) to get the employees talking. Also use closed response and range of response questions. I find that each type of question can provide valuable information and are quite useful in requirements gathering.
Please send the questions to me for at least two of the interviews.
We have previously used both the Joint Application Development technique and the Rapid Application Development technique. However, many colleagues of mine swear by the agile technique. Each of these methodologies offer up some great advantages. Since we need to get this project done as quickly as possible, which of these techniques should be used? I want to ensure that we've created software that will handle all of our users' requirements and that it is a robust system
I almost forgot to mention to also send a questionnaire out to the users of the proposed system.Should it be sent out to all employees or as a stratified or systematic sample?
18 hours ago
department in or.
Sales Management System for ABC Company ANISUR RAHMAN
In this project based research an effort has been made to explore the different aspects of Sales management along with Management Information System. Various dimensions of the scope of sales related Management System have been studied in this project. Initiative has been taken to explore the field where competent management can comply properly.
The key task of this project is to be sensitized and familiarized with Management concepts and its effect on Sales Management System of relevant Company. In this project it has been tried to build a uncomplicated multidimensional Database Management System. It has also been tried to make an analytical Processing Cube with a view to illustrate how to utilize Sales Management System software.
The final component the of this project’s goal is to make certain that in which way the relevant company can get benefitted by utilizing Sales Management.
Hospitals currently use a manual system for visiting Doctor Slip as a token. The current system
requires numerous paper forms, with data stores spread throughout the hospital management infrastructure.
Often information (on forms) is incomplete, or does not follow management standards. Forms are often lost
in transit between departments requiring a comprehensive auditing process to ensure that no vital
information is lost. Multiple copies of the same information exist in the hospital and may lead to
inconsistencies in data in various data stores.
A significant part of the operation of any hospital involves the acquisition, management and timely
retrieval of great volumes of information. This information typically involves; Doctor, Room, Department
and Patient personal Information. All of this information must be managed in an efficient and cost wise
fashion so that an institution's resources may be effectively utilized Hospital E-Token management will
automate the management of the hospital making it more efficient and error free for outdoor patient. It aims
at standardizing data, consolidating data ensuring data integrity and reducing inconsistencies.
This document provides details about a student project on a cable management system. It includes an introduction describing the purpose of the project, objectives, proposed system, system development life cycle phases from initiation to maintenance, flow charts, source code, hardware and software requirements, and more. The project aims to develop a software to allow users to login, manage customer details, view maintenance costs, provide customer feedback, and retrieve customer information to resolve issues.
The document describes a project report on an Employee Management System created by a student named Vishal Kumar. It includes an introduction describing the project, objectives, proposed system, and phases of the system development life cycle used to create the software. The project uses SDLC methodology and includes phases for initiation, concept development, planning, design, implementation, testing, and maintenance.
The document describes a final year project on developing a Customer Relationship Management (CRM) system for Entourage Solutions. It provides an overview of the existing manual system and outlines the objectives, features and benefits of developing a web-based CRM system. The system will allow administrators, business developers and clients to manage contacts, leads, projects, quotations and track project status through a centralized online platform. It includes sections on the company profile, proposed system features, design diagrams, implementation details, screenshots and a project schedule.
Ignou MCA 4th semester mini project report. College admission system. This project is based on real working system of University seat allocation to affiliate colleges. College admission system provide seat allocation process for various UG PG programs for every academic session.
This document is a project report on bank management submitted by Ganesh Bhingare and Ketan Ghatkamble for their Bachelor of Computer Application degree. It proposes developing a computerized banking management system using Visual Basic 6.0 and MS Access to replace the bank's manual processing of daily transactions. The report outlines the project scope, analysis conducted, proposed system design including entity relationship and data flow diagrams, interface forms, and advantages of the new system in automating processes and reducing errors compared to the manual system.
Using the Tablet device, field force can do the detail the brands to HCP. You can get the following benefits.
Real Time Data: SAN eForce already captures traditional data elements with standard and custom fields. Now, by using eDetailing feature from SAN eForce application, the companies can now access in-clinic data. This data is real and authentic information at the point of promotion.
Quick and Agile: Modern way to communicate your products, receives feedback and metrics, re-deploy strategies and even lower your costs. Those promotional and detailing experiments are not so much expensive now-a-days..!
Power of Digital Media: Tablets can be used for presentation of a truly interactive content that can be customized to the needs of each meeting. Also, the content can be pushed and quickly changed before any meeting.
Walk the Talk: Marketing strategy, taking place in boardrooms gets diluted by the time it reaches sales representative working in the field. eDetailing helps in streamlining the communication to the client as well as helps in monitoring how well the strategy is being implemented at field level. (In Pharmaceuticals, mapping Doctor Specialty to product’s therapeutic class)
Call Effectiveness: Offers a unique opportunity to the representative, to obtain better results and communicate his products in the most efficient way.
Insights: Get better understanding of the campaign results by accessing live analytics and reports from the field.
Actionable Alerts: With custom report writing tool and dashboard analytics, adjust marketing strategies and redeploy promotional material.
Domain Independent: Product promotion by a Sales Team is common across many domains, other than Pharmaceuticals. Applications for various such domains can be quickly configured and Rolled-out
Student information management system project report ii.pdfKamal Acharya
Our project explains about the student management. This project mainly explains the various actions related to student details. This project shows some ease in adding, editing and deleting the student details. It also provides a less time consuming process for viewing, adding, editing and deleting the marks of the students.
This document provides an overview and preliminary investigation of a software project for a construction materials supplier. It includes sections on the description of the current system and its limitations, the proposed new system, a feasibility study, and a work breakdown structure showing the topics to be covered in the project analysis, design, coding, implementation, and future enhancements. The project involves developing a software system to automate operations such as managing customer and product data, processing orders and payments, and generating reports.
This document contains a summary of Kotagiri Sai Krishna's professional experience and qualifications. He has over 2 years of experience as a senior software engineer, working on projects involving customer relationship management and communication products. He has a Bachelor's degree in technology and certifications in IT service management. Currently he works as a senior software engineer for Intense Technologies, where he is responsible for requirements gathering, project coordination, and production support for clients in various countries and industries.
The event table outlines the key interactions between customers, engineers, and management for the cooling equipment servicing system. Customers can inquire about services, register for maintenance or repairs, update registrations, and pay bills. Engineers provide service sheets after reviewing problem details from management. Management records customer, engineer, and service details; and can update any of these as needed.
RISK REPORTING SYSTEM IN IT ORGANIZATIONSCPT PAPERName Vi.docxjoellemurphey
RISK REPORTING SYSTEM IN IT ORGANIZATIONS
CPT PAPER
Name: Vinod Kumar Donthagani
Institution: University Of The Cumberlands
Fall - 2015
INDEX
Title
Page No:
1. Company
3
2. Job Description
3
3. Project Description
4
4. Job tasks in Detail
6
5. Tools and Technologies
7
6. Learnings during Internship
8
7. Applying coursework to Internship
8
8. Challenges faced during Internship
8
9. Activities provided by company
9
10. Conclusion
10
11. References
111. COMPANY
Agnosco Technolgies, a diverse communications and technology company providing top-class business consulting, information technology and communication services.
We are powered by a pool of talented IT and consulting professionals across SAP enterprise solutions, supply chain management, financials and controlling, client relationship management, business analytics, enterprise reporting , HR and human capital management, enterprise security and administration and web development amongst other capabilities.
2. JOB DESCRIPTION
I am part of team that works on application named “Risk Reporting System” for a leading banking domain client. My role in the team was to analyze the new change requests and enhancements of current application requested by client and complete the tasks accordingly. I need to update the changes and report to my manager about the status and take care that changes has met the client’s requirements.
My secondary goal was to test the application. As a part of testing process, I have to do primary tests for validations of the User Interface pages, perform unit testing on individual class files using Junit test cases, perform manual testing and write individual test cases for manual testing. I need to make sure that test cases need to be passed and application is 100% as per the expectations with the clients. If any bugs reported needs to be taken to the notice of development team and correct them with in the deadlines and repeat the testing process. I need to make sure to follow this process until the application module is perfect.
My responsibilities in brief are:
1. Setup the computer with required soft wares needed for the project
2. Raise various access requests for shared drives, servers etc. and follow up with respective department employees to grant them.
3. Organize and analyze the requirements collected from clients and document them appropriately
4. Develop the requirements in Java and spring framework as per the clients expectations
5. Adding new features and correcting existing features as per the client’s requirements.
6. Writing sql queries for backend operations to retrieve data from database
7. Maintain database backup for every end of the day for safe recovery purpose
8. Have to provide all the change requests documents to the supervisor on weekly basis and get them reviewed.
9. Write test cases for the application modules after development of each module
10. Perform manual testing for validations of UI pages
11. Perform unit testing of ind ...
Sri Guru Hargobind Ji - Bandi Chor Guru.pdfBalvir Singh
Sri Guru Hargobind Ji (19 June 1595 - 3 March 1644) is revered as the Sixth Nanak.
• On 25 May 1606 Guru Arjan nominated his son Sri Hargobind Ji as his successor. Shortly
afterwards, Guru Arjan was arrested, tortured and killed by order of the Mogul Emperor
Jahangir.
• Guru Hargobind's succession ceremony took place on 24 June 1606. He was barely
eleven years old when he became 6th Guru.
• As ordered by Guru Arjan Dev Ji, he put on two swords, one indicated his spiritual
authority (PIRI) and the other, his temporal authority (MIRI). He thus for the first time
initiated military tradition in the Sikh faith to resist religious persecution, protect
people’s freedom and independence to practice religion by choice. He transformed
Sikhs to be Saints and Soldier.
• He had a long tenure as Guru, lasting 37 years, 9 months and 3 days
Cricket management system ptoject report.pdfKamal Acharya
The aim of this project is to provide the complete information of the National and
International statistics. The information is available country wise and player wise. By
entering the data of eachmatch, we can get all type of reports instantly, which will be
useful to call back history of each player. Also the team performance in each match can
be obtained. We can get a report on number of matches, wins and lost.
Sachpazis_Consolidation Settlement Calculation Program-The Python Code and th...Dr.Costas Sachpazis
Consolidation Settlement Calculation Program-The Python Code
By Professor Dr. Costas Sachpazis, Civil Engineer & Geologist
This program calculates the consolidation settlement for a foundation based on soil layer properties and foundation data. It allows users to input multiple soil layers and foundation characteristics to determine the total settlement.
1. E-BILLING AND INVOICE SYSTEM
A PROJECT REPORT
Submitted by
V.SURYA INDIRA 103678137
In partial fulfillment for the award of the degree of
B.Tech
In
COMPUTER SCIENCE
Under the esteemed Guidance of
Prof.Ch. Raja Ramesh
M.Tech, [PhD]
REGENCY INSTITUTE OF TECHNOLOGY
ADAVIPOLAM, YANAM-533464
Department of Computer Science and Engineering
March-2012
1
2. DECLARATION BY THE CANDIDATE
I here by declare that the project report entitled “E-Billing and Invoice
System“submitted for the partial fulfillment of mini project in B.Tech Third
year Computer Science & Engineering Department. I further declare that the
work reported in this project has not been submitted and will not be
submitted, either in part or in full, for the award of any other degree or
diploma in this institute or any other institute or university.
Yanam Signature of the Candidate
Date:
2
3. DEPARTEMENT OF COMPUTER SCIENCE AND ENGINEERING
BONAFIDE CERTIFICATE
I here by declare that the project report entitled “ E-Billing and Invoice
System “ submitted for the partial fulfillment of mini project in B.Tech
Third year Computer Science & Engineering Department bonafide work
carried out by him/her under my guidance. The project fulfills the
requirements as per the regulations of this Institute and in my opinion meets
the necessary standards for submission. The contents of this report have not
been submitted and will not be submitted either in part or in full, for the
award of any other degree or diploma in this institute or any other institute
or university.
Ch. Raja Ramesh S.T.V.V.S Kumar
M.Tech [PhD] M.Tech,[PhD]
Lab in charge Head of the Department
Date: Date:
Internal Examiner (s) External Examiner (s)
3
4. ACKNOWLEDGEMENT
“Task successful” makes everyone happy. But the happiness will be gold without
glitter if we didn’t state the persons who have supported us to make it a success. Success
will be crowned to people who made it a reality but the people whose constant guidance
and encouragement made it possible will be crowned first on the eve of success.
This acknowledgment transcends the reality of formality when we would like to
express deep gratitude and respect to all those people behind the screen who guided,
inspired and helped me for the completion of our project work. We consider ourselves
lucky enough to get such a good project. This project would add as an asset to my
academic profile.
We express our sincere gratitude to our respectful Principal Dr. A. Ramakrishna
Rao for enabling us to make use of laboratory and library facilities liberally, that helped
us a long way in carrying out our project work successfully.
We express our gratitude to the help of the Head of the Department of Computer
Science and Engineering, Mr. S. T. V. S. Kumar, M.Tech, (Ph. D), for his constant
supervision, guidance and co-operation throughout the project and we would like to
express our thankfulness to our project guide, Mr.Ch. Raja Ramesh, M.Tech for his
constant motivation and valuable help through the project work.
We extend our sincere gratitude to our parents who have encouraged us with their
blessings to do this project successfully. Finally we would like to thank to all our friends,
all the teaching and non-teaching staff members of the CSE Department, for all the
timely help, ideas and encouragement which helped throughout in the completion of
project.
4
5. INDEX
Abstract
List of Tables
List of Figures
1. Introduction
1.1. Overview of Proposed System
1.1.1 Existing System
1.1.2 Proposed System
2. System Analysis
2.1 Business Requirements
2.2 User Requirements
2.3 Operational Requirements
2.4 System Requirements
2.5 Software and Hardware Requirement
3. System Design
3.1 UML Diagrams
3.1.1 Class Diagrams
3.1.2 Activity Diagrams
3.1.3 Sequence Diagrams
3.1.4 Data Flow Diagrams
3.2 Data Dictionary
4. Implementation
5. Testing
5.1 Unit Testing
5.2 Recovery Testing
5.3Security Testing
5
7. Objective
This section presents a conceptual overview of the solution, and then provides
an introduction to its requirements.
Solution Concept
The E- Billing and Invoice System consist of:
• Customer, Products, Billing Generation: Automate the current manual
bill generation system and maintain the searchable customer, products
database and product invoice, maintain the data security, user rights.
• Report Generation: A Report Generation system will be developed for the
user and management of E- Billing and Invoicing System. This MIS
system will have both details and summary type reports for analysis the
sales volume, sales trend, available stock
Part of the solution will involve converting data from Microsoft Excel to the
Database, system can import existing customer, product data from predefined
MS Excel, CSV format. It reduces the data entry work and quick implementation
of the system.
7
8. List of Tables:
Product master
Bill owner
Bill details
Company master
User master
List of Figures:
Class Diagrams
Activity Diagrams
Sequence Diagrams
Data Flow Diagrams
Top level
First level
8
9. 1. Introduction
1.1. Overview of Proposed System
1.1.1 Existing System:
The client uses MS Excel, and maintains their product list, customer list, and prints the
invoice, however it is not possible them to share the data from multiple system in multi
user environment, there is lot of duplicate work, and chance of mistake. When the
product price are changed they need to update each and every excel file. There is no
option to find and print previous saved invoice. There is no security; any body can access
any report and sensitive data, also no reports to find out the sales volume, stock list, and
summary report
1.1.2 Proposed System:
. This E-Billing and invoicing system is used to overcome the entire problem which they
are facing currently, and making complete atomization of manual billing and invoicing
system
9
10. 2. System Analysis
The following preliminary lists are based on initial interviews
2.1 Business Requirements:
The business goal for the application is to support an increase the productivity and
complete automation of existing manual bill and invoice generation process. Business
requirements are discussed in the Scope section, with the following additional detail:
• Sales representatives need a method to store and access sales opportunity data,
and when a sale is generated, convert some or all of the information into a sales
order without re-entering information.
• Each sales representative should receive customer and sales data pertinent only to
them.
• The accountant should be able to enter or update product information in one
interface only, with all necessary product information being received by sales
staff.
• Manager must receive his or her customer and appointment data plus detailed and
rollup information for each sales representative on his or her team.
• The application should support the capability to use multi user environment.
• The MIS Executive should able to generate all type of reports as and when
required by the management.
The sales staff wants to improve their current ability to analyze their customers. In
particular, they want to focus on identifying their best customers and building long-term
relationships within that base. To enable them to accomplish this goal, they want to
extract meaningful data that easily answers the following questions:
• What are the early warning signs of problems?
• Who are my best customers across product lines?
• With whom do I focus my efforts for building a long-term relationship?
10
11. • What are my customers' issues as groups?
• Geographically, where are my best customers?
• What products are my customers buying and at what rate?
2.2 User Requirements:
User requirements are categorized by user type.
Sales Staff (Representatives and Managers)
• View the data in various ways, for example:
o Customers who are the top buyers of specific items
o Best customers based on criteria to be determined
o Best customers based on geographical analysis
o Drops in a customer's sales
• Store multilingual and multiregional information in the database rather than
relying on the sales staff to translate the information
• Identify which product prices have been modified, especially on current orders in
progress
• Use opportunity rules, which are statements that help the sales representative
convert an opportunity into a sale
• Add third-party data sources and financial evaluation tools
• Identify where promotions and programs would be the most beneficial
• Apply discounts to customer orders:
o Sales representatives can offer discounts up to 15 percent, or up to 20
percent with authorization.
o Sales managers can offer discounts up to 20 percent
• Enable capture, analysis, and sharing of data about a customer across the
company
• Use forecasts to establish sales goals
11
12. • Allow all staff to view all contacts, but allow each contact to be assigned to a sales
representative
Accountant
• Update product details, including price, photo, and description
• Add, delete, and update product specifications
• Generate stock reports and check the availability, order the item as and when
needed.
MIS Executive
• Generate Reports as per requirement.
• Share the data, and convert reports to different format like Text, CSV.
2.3 Operational Requirements:
The following requirements provide a high-level view of how the system will run:
• Processor usage should not exceed 80 percent during concurrent uses.
• Backups will occur incrementally throughout the day.
• A full weekly backup is required to WORM drives.
• Ensure that information is easy to access either, and meaningful for the sales
representative and the company.
• Minimize the technical knowledge that sales and marketing staff need to access
the data, generate ad hoc queries, track promotions, and view customer
segmentation information.
• Any change to information must be reflected immediately, and the changes must
be propagated to the search engine so that employees that perform searches see
this new information.
12
13. • The application should work with the existing communications and networking
infrastructure.
• The application should deploy with a minimum of additional operational
processes, manual or otherwise.
2.4 System Requirements:
These are additional constraints from a system perspective:
• Previous data of customer, product details must be imported in the new system.
• The administrator must be able to monitor everything from the IT department.
• The information must be accessible by everyone in the company as per the rights
specify.
Success Criteria
To determine the success of this project, the following metrics can be quantified and used
to analyze success factors.
Sales Automation
• Problem customer identification. Ability to identify top 10 developing problem
customers by sales representative.
• Identification of best customers across product lines and regions. All customers
can be sorted by the factors (to be determined) that rank them qualitatively.
Variable sorts and rankings can be chosen by the sales representative.
• Identification of issues across groups. All customers can be sorted by the issues
(to be determined) within group categories that can be updated. Variable sorts
and rankings can be chosen by the sales representative or other user.
• Analysis of quantities and rates of products. Products can be sorted by the
quantity and dates sold. Variable sorts and rankings can be chosen by the user.
13
14. 2.5 Software and Hardware Requirement:
General Requirement for Server/Client:
Type Software Hardware
Work Station/ Node 1. Windows XP
2. VB Run time
3. MS Office
1. P-4
2. RAM -256 MB
Database Server 1.Win2000 Advance Server 1.P-4
2.RAM- 2GB
3.Hard Disk-160GB
4.RAID
Application Server 1.Win 2000 Advance Server 1.P-4
2.RAM- 1GB
3.Hard Disk-40GB
14
15. Development Tools and Technologies
Front End
1. VB.Net
Why VB.Net?
VB.Net is built on the Windows Server System to take major advantage of the OS
and which comes with a host of different servers which allows for building,
deploying, managing and maintaining Windows Based solutions. The Windows
Server System is designed with performance as priority and it provides
scalability, reliability.
The advantage of VB.NET includes
• Rapid Application Development (RAD) Support.
• Powerful Windows-based Applications
• Simplified Deployment
• Powerful, Flexible, Simplified Data Access
• Improved Coding
• Direct Access to the OS Platform
• Object-Oriented Constructs
• COM Interoperability
Back End
1. MS Access
Why MS Access?
MS Access is desktop RDMS support small application with all features like
relational query, different data types, joins, and query. Includes
• Easy to use and easy to deployment.
15
16. • Integration with Windows OS
• Scalability
• Import and Export of data in all major database system.
• Centralized Management
• Reliability
• Automating tasks
16
21. Table : product_master
Owner: dbo
Destination DB name: ebill
Number of columns: 5
Number of indexes: 2
Number of foreign keys: 0
Extended attributes:
OnFileGroup PRIMARY
Clustered PK Yes
Columns Data type Allow NULLs Value/ran
ge
Sno int Not allowed
ProdType nvarchar(60) Not allowed
ProdSubType nvarchar(60) Not allowed
Rate int Not allowed
isactive nvarchar(30) Not allowed
Indexes Type Columns
PK_ProductMaster_sno clustered, unique,
primary key located on
PRIMARY
sno
Table : bill
Owner:dbo
Destination DB name: ebill
Number of columns: 15
Number of indexes: 3
Number of foreign keys: 0
Extended attributes:
OnFileGroup PRIMARY
Clustered PK Yes
21
23. sno int Not allowed
invoiceno nvarchar(60) Not allowed
canme nvarchar(60) Not allowed
Invoice_date datetime Not allowed
location nvarchar(60) Not allowed
chalan_no int Not allowed
customer_name nvarchar(100) Not allowed
Customer_address1 nvarchar(100) Not allowed
Customer_address2 nvarchar(100) Allowed
Total_amt int Not allowed
discount int Not allowed
Amt_words nvarchar(100) Not allowed
Paid_type nvarchar(60) Not allowed
Cheque_no nvarchar(60) Allowed
Entry_date datetime Not allowed
Indexes Type Columns
PK_Bill_SNO clustered, unique,
primary key located on
PRIMARY
sno
IX_bill_cname nonclustered located on
PRIMARY
cname
IX_bill_invoiceno nonclustered, unique
located on PRIMARY
invoiceno
Table : bill_details
Owner: dbo
Destination DB name: ebill
Number of columns: 6
Number of indexes: 3
Number of foreign keys: 2
Extended attributes:
OnFileGroup PRIMARY
Clustered PK Yes
Columns Data type Allow Value/ran
23
24. NULLs ge
sno int Not allowed
Bill_sno int Not allowed
Prod_sno nvarchar(60) Not allowed
qty datetime Not allowed
rate nvarchar(60) Not allowed
amt int Not allowed
Indexes Type Columns
PK_Bill_details_SNO clustered, unique,
primary key located on
PRIMARY
sno
IX_bill_details_bill_sno nonclustered located on
PRIMARY
Bill_sno
IX_bill_deatils_prod_sno nonclustered, unique
located on PRIMARY
Prod_sno
Table : Company_master
Owner: dbo
Destination DB name: ebill
Number of columns: 7
Number of indexes: 2
Number of foreign keys: 0
Extended attributes:
OnFileGroup PRIMARY
Clustered PK Yes
Columns Data type Allow
NULLs
Value/ran
ge
Company_name nvarchar(60) Not allowed
Address1 nvarchar(100) Not allowed
Address2 nvarchar(100) Allowed
city nvarchar(60) Not allowed
pin int Not allowed
telephone nvarchar(60) Not allowed
vatno nvarchar(60) Not allowed
24
25. Indexes Type Columns
PK_comapny_master_company
_name
clustered, unique,
primary key located on
PRIMARY
Comapnay_nam
e
IX_ comapny_master_pin nonclustered located on
PRIMARY
pin
Table : user_master
Owner: dbo
Destination DB name: ebill
Number of columns: 3
Number of indexes: 2
Number of foreign keys: 0
Extended attributes:
OnFileGroup PRIMARY
Clustered PK Yes
Columns Data type Allow
NULLs
Value/ran
ge
user_name nvarchar(60) Not allowed
User_password nvarchar(60) Not allowed
User_type nvarchar(60) Allowed
Indexes Type Columns
PK_user_master_user_name clustered, unique,
primary key located on
PRIMARY
user_name
IX_ user_master_user_type nonclustered located on
PRIMARY
User_type
25
26. 4. Implementation
FrmLogin
Dim Rs As New ADODB.Recordset
Private Sub Command1_Click()
'>>> check wheather user name and password are blank
'>>> if its is blan warn user to enter
If TxtUserName.Text = "" Or TxtPassword.Text = "" Then
MsgBox("Enter user name and password ...", vbExclamation)
TxtUserName.SetFocus()
Exit Sub
End If
'>>> check for entered company
'>>> query to database and if no record found warn user to select company from the
list.
If Rs.State = adStateOpen Then Rs.Close()
Rs.Open("select * from company_master where company_name='" &
CmbCompanyName.Text & "'", Cn, adOpenStatic, adLockReadOnly)
If Rs.RecordCount > 0 Then
CompanyName = CmbCompanyName.Text
Else
26
27. MsgBox("Select company name from the list", vbExclamation)
CmbCompanyName.SetFocus()
Exit Sub
End If
'>>> check for username and password
'>>> query to user_master with user_name and password
'>>> if no record found check warn user for enter valid user namne and password
'>>> if record found store user_nmae, user_type in global variable for future use.
If Rs.State = adStateOpen Then Rs.Close()
Rs.Open("select * from user_master where USER_name ='" & TxtUserName.Text
& "' and user_password ='" & TxtPassword & "'", Cn, adOpenStatic, adLockReadOnly)
If Rs.RecordCount > 0 Then
CheckLogin = True
UserName = IIf(IsNull(Rs("USER_name").Value) = True, "NA",
Rs("USER_name").Value)
UserType = IIf(IsNull(Rs("user_type").Value) = True, "NA",
Rs("user_type").Value)
Unload(Me)
Else
MsgBox("Invalid User Name and Password ... ", vbExclamation, "Login Error ")
TxtPassword.Text = ""
TxtUserName.SetFocus()
Exit Sub
End If
End Sub
Private Sub Command2_Click()
'>>> close the application
End
FrmLogin = Nothing
End Sub
27
28. Private Sub Form_Load()
'>>> open the global connection
If Cn.State = 1 Then Cn.Close()
OpenCon()
'>>> center the form
Me.Move (Screen.Width - Width) / 2, (Screen.Height - Height) / 2
'>>> fill the combo box with all company_name from company master
If Rs.State = adStateOpen Then Rs.Close()
Rs.Open("select * from company_master ", Cn, adOpenStatic, adLockReadOnly)
CmbCompanyName.Clear()
If Rs.RecordCount > 0 Then
While Rs.EOF = False
CmbCompanyName.AddItem(Rs("company_name"))
Rs.MoveNext()
End While
End If
If Rs.State = adStateOpen Then Rs.Close()
End Sub
Private Sub Form_QueryUnload(ByVal Cancel As Integer, ByVal UnloadMode As
Integer)
'>>> release all the object variable used by form
FrmLogin = Nothing
End Sub
FrmBillSummary
(Show bill summary for particular date range)
'*************************************
' eBilling System
28
29. ' Version 1.0.0
'*************************************
' Show summery of bill
' Used Table : bill
' : bill_details
'show bill summary for seleted date
'range, show report in crystal report
'move data into temp table and show
'report from temp table
'*************************************
Option Explicit
Private Sub CmdClose_Click()
'>>> close the form
Unload(Me)
End Sub
Private Sub CmdGetBill_Click()
'NOTE : it is not the right solution to call crystal report by temp using temp table
'some time it is a good practice for complecated databse relation table
'This may not run properly in multi user environment
'Better approch is passing value by SelectionFormula in crystal report
'but anyway it is a working solution
'>>> find the bill sno from seleted invoice no
'>>> if record found
'>>> delete temp bill na dbill_details
'>>> insert from bill,bill_details to temp_bill, teemp_bill_details
Cn.Execute("delete from temp_bill_details")
Cn.Execute("delete from temp_bill")
29
30. Cn.Execute("insert into temp_bill select * from bill where invoice_date>=#" &
Format(DTPicker1.Value, "dd-mmm-yy") & "# and invoice_date<=#" &
Format(DTPicker2.Value, "dd-mmm-yy") & "# and cname='" & CompanyName & "' ")
Cn.Execute("insert into temp_bill_details select * from bill_details where bill_sno in
( select sno from bill where invoice_date >=#" & Format(DTPicker1.Value, "dd-mmm-
yy") & "# and invoice_date<=#" & Format(DTPicker2.Value, "dd-mmm-yy") & "# and
cname='" & CompanyName & "')")
Call OpenCon()
'>>> open crystal report
Cr1.DataFiles(0) = App.Path & "data.mdb"
Cr1.WindowState = crptMaximized
Cr1.ReportFileName = App.Path & "reportsbillsummary.rpt"
Cr1.Action = 1
End Sub
Private Sub Form_Load()
'>>> cnter the form
Me.Left = (Screen.Width - Me.Width) / 2
Me.Top = (Screen.Height - Me.Height) / 2
'>>> show the current date
DTPicker1.Value = Date
DTPicker2.Value = Date
End Sub
FrmExportData
(Export product Data in FlexGrid and MS-Excel with formatting)
'*************************************
' eBilling System
' Version 1.0.0
'*************************************
' Export product_master in grid and ms-excel
' Used Table : product_master
'open the product_master in grid
30
31. 'display record in flex grid with gropu by product type
'*************************************
Option Explicit
Private Sub CmdClose_Click()
'>>> close the form
Unload(Me)
End Sub
Private Sub CmdExcel_Click()
'>>>export data into ms excel from grid with formatting
'>>> check the grid
If Mf1.TextMatrix(0, 0) = "" Then
MsgBox("No Records Available for Exporting ... ", vbExclamation)
Exit Sub
End If
Label1.Caption = "WAIT ... Generate Excel "
Label1.Refresh()
'>>> creating excel object variable
Dim ex As New Excel.Application
Dim wb As New Workbook
Dim Es As New Worksheet
wb = ex.Workbooks.Add
Es = wb.Worksheets(1)
Dim i As Integer
Dim j As Integer
'>>> set excel columns width as per flex grid columns width
For i = 0 To Mf1.Cols - 1
Mf1.Row = 1
Mf1.Col = i
31
32. Es.Columns(ReturnAlphabet(i + 1) & ":" & ReturnAlphabet(i + 1)).ColumnWidth
= Mf1.CellWidth / 110
Next
'>>> set data from grid to excel row, column wise
Dim K As Integer
For i = 0 To Mf1.Rows - 1
For j = 0 To Mf1.Cols - 1
ex.Cells(i + 1, j + 1) = Mf1.TextMatrix(i, j)
Next
Next
Dim R1 As String
Dim R2 As String
R2 = ReturnAlphabet(Mf1.Cols) & "1"
'>>> formatting excel
Dim x As Range
'>>>head
x = Es.Range("A1:" & R2)
x.Font.Bold = True
x.Font.ColorIndex = 40
x.Interior.ColorIndex = 9
x.Interior.Pattern = xlSolid
x.HorizontalAlignment = xlCenter
x.VerticalAlignment = xlBottom
'>>>border
R2 = ReturnAlphabet(Mf1.Cols) & Mf1.Rows - 1
x = Es.Range("A1:" & R2)
With x.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThin
32
33. .ColorIndex = xlAutomatic
End With
With x.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With x.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With x.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With x.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
With x.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
'>>> FILL DETAILS
x = Es.Range("A2:" & R2)
x.Interior.ColorIndex = 40
'>>TOTAL
R2 = ReturnAlphabet(Mf1.Cols) & Mf1.Rows
33
35. Mf1.CellForeColor = vbBlue
Mf1.CellBackColor = vbCyan
Mf1.Col = 1
Mf1.ColWidth(1) = 2500
Mf1.Text = "Product Type"
Mf1.CellAlignment = 4
Mf1.CellFontName = "Arial"
Mf1.Font.Size = 10
Mf1.Font.Bold = True
Mf1.CellForeColor = vbBlue
Mf1.CellBackColor = vbCyan
Mf1.Col = 2
Mf1.ColWidth(2) = 5000
Mf1.Text = "Product"
Mf1.CellAlignment = 4
Mf1.CellFontName = "Arial"
Mf1.Font.Size = 10
Mf1.Font.Bold = True
Mf1.CellForeColor = vbBlue
Mf1.CellBackColor = vbCyan
'>>> find distinct product type from product master
'>>> loop all product type
Dim RS1 As New ADODB.Recordset
Dim Rs2 As New ADODB.Recordset
RS1.Open("select distinct prod_type from product_master", Cn, adOpenStatic,
adLockReadOnly)
Dim i As Integer
Dim j As Integer
For i = 0 To RS1.RecordCount - 1
Me.Caption = i + 1
Mf1.Row = Mf1.Rows - 1
35
36. Mf1.Col = 0
Mf1.Text = i + 1
Mf1.Col = 1
Mf1.Text = RS1("prod_type")
'>>> query product master for each prod type from outer loop
If Rs2.State = adStateOpen Then Rs2.Close()
Rs2.Open("select prod_sub_type from product_master where prod_type ='" &
RS1("prod_type") & "' order by prod_sub_type", Cn, adOpenStatic, adLockReadOnly)
For j = 0 To Rs2.RecordCount - 1
Mf1.Row = Mf1.Rows - 1
Mf1.Col = 2
Mf1.Text = Rs2(0)
Mf1.Rows = Mf1.Rows + 1
Rs2.MoveNext()
Next
RS1.MoveNext()
Next
End Sub
Private Sub Form_Load()
'>>> cnter the form
Me.Left = (Screen.Width - Me.Width)
Me.Top = (Screen.Height - Me.Height)
End Sub
FrmCompanyInfo
(Add/Modify Company Info)
'*************************************
' eBilling System
' Version 1.0.0
'*************************************
' add/edit/delete company details
' Used Table : company_master
36
37. 'open the company_master
'display first record in form load
'add edit save delete and navigation
'*************************************
Option Explicit
Dim RS1 As New ADODB.Recordset
Dim AddEdit As String
Private Sub Command1_Click()
'>>> close the form
Unload(Me)
End Sub
Private Sub Command11_Click()
'>>> delete the record
If RS1.State = adStateClosed Then Exit Sub
If RS1.RecordCount <= 0 Then Exit Sub
On Error GoTo myer1
'>>> confirm before delete
If MsgBox("Delete the Record ? ", vbCritical + vbYesNo) = vbYes Then
RS1.Delete()
Call ClearText()
Command4_Click()
End If
Exit Sub
myer1:
MsgBox("Error Occured : " & Err.Description, vbCritical)
End Sub
Private Sub Command2_Click()
37
38. '>>> move record ponter to first record
'>>> display first record
On Error Resume Next
If RS1.State = adStateClosed Then Exit Sub
If RS1.RecordCount <= 0 Then Exit Sub
RS1.MoveFirst()
Call DisplayRecord()
End Sub
Private Sub Command3_Click()
'>>> move back the record pointer and display current record
On Error Resume Next
If RS1.State = adStateClosed Then Exit Sub
If RS1.RecordCount <= 0 Then Exit Sub
If RS1.AbsolutePosition > 1 Then
RS1.MovePrevious()
Else
MsgBox("First Record ..", vbInformation)
RS1.MoveFirst()
End If
Call DisplayRecord()
End Sub
Private Sub Command4_Click()
'>>> move next the record pointer and display current record
On Error Resume Next
If RS1.State = adStateClosed Then Exit Sub
If RS1.RecordCount <= 0 Then Exit Sub
If RS1.AbsolutePosition < RS1.RecordCount Then
RS1.MoveNext()
38
39. Else
MsgBox("Last Record ..", vbInformation)
RS1.MoveLast()
End If
Call DisplayRecord()
End Sub
Private Sub Command5_Click()
'>>> move last the record pointer and display current record
On Error Resume Next
If RS1.State = adStateClosed Then Exit Sub
If RS1.RecordCount <= 0 Then Exit Sub
RS1.MoveLast()
Call DisplayRecord()
End Sub
Private Sub Command6_Click()
'>>> prepare for add record, clear all text box, set flag to ADD
If RS1.State = adStateClosed Then Exit Sub
If RS1.RecordCount <= 0 Then Exit Sub
AddEdit = "ADD"
Call ClearText()
DE(False, True)
TxtCompanyName.SetFocus()
End Sub
Private Sub Command7_Click()
'>>> prepare for edit record, set flag to EDIT
If RS1.State = adStateClosed Then Exit Sub
39
40. If RS1.RecordCount <= 0 Then Exit Sub
AddEdit = "EDIT"
DE(False, True)
TxtCompanyName.SetFocus()
End Sub
Private Sub Command8_Click()
'>>> save the record
'>>> check for validation
'>>> check the flag for ADD/Edit
If RS1.State = adStateClosed Then Exit Sub
If RS1.RecordCount <= 0 Then Exit Sub
On Error GoTo myer1
If Trim(TxtCompanyName.Text) = "" Then
MsgBox("Enter Company Name ", vbCritical)
TxtCompanyName.SetFocus()
Exit Sub
End If
If AddEdit = "ADD" Then
RS1.AddNew()
RS1("company_name") = TxtCompanyName.Text
RS1("Address1") = TxtAddress1.Text
RS1("Address2") = TxtAddress2.Text
RS1("city") = TxtCity.Text
RS1("pin") = TxtPin.Text
RS1("telephone") = TxtTelephone.Text
RS1("vatno") = TxtVatNo.Text
RS1.Update()
RS1.MoveLast()
40
41. Call DisplayRecord()
Else
RS1("Address1") = TxtAddress1.Text
RS1("Address2") = TxtAddress2.Text
RS1("city") = TxtCity.Text
RS1("pin") = TxtPin.Text
RS1("telephone") = TxtTelephone.Text
RS1("vatno") = TxtVatNo.Text
RS1.Update()
'>>> if it is edit after requery show the edited record
Dim p As Integer
p = RS1.AbsolutePosition
RS1.Requery()
RS1.MoveFirst()
RS1.Move(p - 1)
Call DisplayRecord()
End If
DE(True, False)
Exit Sub
myer1:
MsgBox("Error Occured : " & Err.Description, vbCritical)
End Sub
Private Sub Command9_Click()
'>>> cancel save
DE(True, False)
End Sub
Private Sub Form_Load()
'>>> center the form
41
42. Me.Move (Screen.Width - Width) / 2, (Screen.Height - Height) / 2
'>>> reset connection
'>>> clear all text
ClearText()
OpenCon()
'>>> load alreday saved clent data
'>>> and show the first record
If RS1.State = adStateOpen Then RS1.Close()
RS1.Open("select * from company_master order by company_name ", Cn,
adOpenDynamic, adLockOptimistic)
If RS1.RecordCount > 0 Then
RS1.MoveFirst()
Call DisplayRecord()
End If
DE(True, False)
End Sub
Private Sub ClearText()
'>>> clear all text box in the form
Dim Ctl As Control
For Each Ctl In Me.Controls
If TypeOf Ctl Is TextBox Then
Ctl.Text = ""
End If
Next
End Sub
Private Sub DisplayRecord()
'>>> display current record
On Error Resume Next
Call ClearText()
42
43. TxtCompanyName.Text = IIf(IsNull(RS1("company_name")) = True, "",
RS1("company_name"))
TxtAddress1.Text = IIf(IsNull(RS1("Address1")) = True, "", RS1("Address1"))
TxtAddress2.Text = IIf(IsNull(RS1("Address2")) = True, "", RS1("Address2"))
TxtCity.Text = IIf(IsNull(RS1("city")) = True, "", RS1("city"))
TxtPin.Text = IIf(IsNull(RS1("pin")) = True, "", RS1("pin"))
TxtTelephone.Text = IIf(IsNull(RS1("telephone")) = True, "", RS1("telephone"))
TxtVatNo.Text = IIf(IsNull(RS1("vatno")) = True, "", RS1("vatno"))
Label17.Caption = RS1.AbsolutePosition & "/" & RS1.RecordCount
End Sub
Private Sub DE(ByVal T1 As Boolean, ByVal T2 As Boolean)
'>>> enable disable buttons
Command2.Enabled = T1
Command3.Enabled = T1
Command4.Enabled = T1
Command5.Enabled = T1
Command6.Enabled = T1
Command7.Enabled = T1
Command11.Enabled = T1
Command8.Enabled = T2
Command9.Enabled = T2
5. Testing
System Development and Testing:
System Development is a process of conceiving the specification specified in
the designing stage into source code. Careful study and observation about system
designing were made and accordingly the system was coded to convert from designing
to source code, where visual Basic as the front end and OracleXE as the backend. The
System was developed such that it should be used for the future enhancement.
43
44. All the module of the system is combined and is put to the operational use. This
means that the new and old system are run in the parallel for sometimes, errors are
identified and the corresponding errors are to be concerned to get the required output.
The set of working programs and initialized tables are also provided for the easy start
of the user, in addition, system documentation is also provided, all users have been
trained to use the system.
This creates two problems,
• The time lag between the cause and appearance of the
problem.
• The effect of system errors on files and records within the
system.
44
45. Types of testing done:
5.1 Unit Testing:
Unit test is designed to ensure that the purpose for which it was designed for
which it was designed for is fulfilled. Each and every module was tested individually
with the test data and error messages were displayed for incorrect and sufficient for entry
works. All validation was tested to correctness. Test data were fed in and results were
checked for the maintenance module, to ensure that all tables created contained nothing
but valid data. Reverential integrity constraints specified as part of the table definition
was also tested.
5.2 Recovery Testing:
Many computer based systems must recover from faults and resume processing
within a pre-specified time. In some cases a system must be fault tolerant.ie processing
faults must not cause overall system function to cease. In the casers a system failure must
be corrected within a specified period of time or severe economic damage will occur.
5.3 Security Testing:
Any computer-based system the manages sensitive information or cause
action that can improperly harm individual is a tablet for improper or illegal penetration
Security testing attempts to verify that protection mechanism built into a system will, in
fact protect it from improper penetration . During security testing, the tester plays the role
of the individual who desire to penetrate the system. The tester may attempt to acquire
passwords through external clerical means; may attack the system with custom software
designed to break down any defenses that have been constructed; may overwhelm the
System.
45
46. 5.4 Performance Testing:
For real time and embedded system, software that provides required
functions but not confirm to performance requirements is unacceptable. Performance
testing is designed to test the run time performance of software within the context of an
integrated system. Performance testing occurs throughout all steps in the testing process.
Even at unit level, the performance of an individual module may be accessed as white
box test recon ducted. However, it is not until all system elements are fully integrated that
true performance of a system can be ascertained.
Performance Tests are sometimes coupled with stress testing and often
required other hardware and software implementation. It is often necessary to measure
Resource utilization .By incrementing a system the tester can uncover situations that lead
to degradation and possible system failure.
5.5 Integration Testing
In integration testing a system consisting of different modules is tested for problems
arising from component interaction. Integration testing should be developed from
the system specification. Firstly, a minimum configuration must be integrated and tested.
In my project I have done integration testing in a bottom up fashion i.e. in this project I
have started construction and testing with atomic modules. After unit testing the
modules are integrated one by one and then tested the system for problems arising
from component interaction.
5.6 White Box Testing
In white box testing knowing the internal working of the base, test can be conducted to
ensure that internal operations are performed according to specification and all internal
components have been adequately exercised. In white box testing logical path through the
software are tested by providing test cases that exercise specific set of conditions and
loops. Using white-box testing software developer can derive test case that
• Guarantee that all independent paths within a module have been exercised at least
46
47. once.
• Exercise all logical decisions on their true and false side.
• Exercise all loops at their boundaries and within their operational bound.
• Exercise internal data structure to ensure their validity.
47
52. 7. Conclusion
This project was developed to fulfill user and business requirement; however there are
lots of scope to improve the performance of the eBilling and Invoice System in the area
of user interface, database performance, and query processing time. Etc.
So there are many things for future enhancement of this project. The future enhancements
that are possible in the project are as follows.
• Linking and integration of any legacy system for accounting.
• Integration with travel agent through Web Services
• Connection to third-party OLAP applications
• Electronic Data Interchange (EDI) system between banks, other credit verification
agency and their vendors
• In the area of data security and system security.
• Provide more online tips and help.
• To optimize the query which is embedded in the system
52