Lab Managment System

CONTENT

Title CHAPTER – 1

INTRODUCTION  LAB panel  Admin, mentor & faculty  LAB Management System Modules  Proposed System  Objective of the Project  Theoretical Background

CHAPTER – 2

SYSTEM ANALYSES  User requirements  Technical Feasibility Addresses Three Major Issues  Economical Feasibility  Software Engineering Paradigm Applied  Study of the System

CHAPTER –3

SYSTEM DESIGN  Introduction  Logical Design  Physical Design  Physical system design consists of the following  Technical feasibility  Economical feasibility Page 1

CHAPTER – 4

SCREEN SHORT  Methodology adopted and System implementation  Detailed Life Cycle Project  ER-Diagram and Data Flow Diagram  Login DFD Diagram  Student Details Data Flow

CHAPTER – 5

DATABASE DESIGN  Input-Output Design  Design coding have three patterns

CHAPTER – 6

APPENDIX A  A Specification of Processes for small LAB

CHAPTER – 7

CONCLUSIONS

CHAPTER - 8

BIBLIOGRAPHIES

CHAPTER – 9

REFERENCES

Page 2

1.1Introduction ABOUT PROJECT Project Title: - LAB Management System This project mainly used for LAB management. This project I use many operations for keeping record. We use LAB department and staff registration form, search form and their management form of LAB. In this project we need to fill up the basic information about the student and LAB into the registration form, total qualifications, percentages, current & permanent address and student attends and staff salary and result, all of LAB record managing etc. The LAB Management System project is aimed at developing an online application for the LAB Management System Dept. of the LAB. The system is an online application that can be accessed throughout the organization and outside as well with proper login provided. This system can be used as an application for the HOD of the LAB to manage the student information and LAB information with regards to LAB management. LAB department and HOD logging should be able to upload their information in the system. Visitors & LAB staff representatives logging in may also access/search any information put up by Students. 

Institute & LAB record - Covering Details regarding Institute



Student record - Covering Details regarding Students



Counseling - Helps in Category wise Placements.



Staff record – Converting Details regarding staff.



Panels are available 1. LAB panel 2. Student panel 3. Parent’s panel 4. Other panel

Page 3

1. LAB panel There are three types of users in this panel they are admin, mentor & faculty and these three users have their own rights and authorized to be done. when any student take admission in LAB then admin give a unique student id & password for student and admin give a unique parents id & password for parents. And if any mentor or faculty is been changed and new faculty is Join LAB then admin also provide them the login id and password. And then these three types of user (admin, mentor, and faculty) can login in LAB panel and perform their tasks. 

Admin



Mentor



Faculty

Admin For LAB & Self:Admin can add or delete the new course in LAB’s courses. And admin can add or delete the new branch in particular course according to student study and requirement. Admin can add and delete (manage) the seats in particular branch means admin can fix seats in any branch of any courses. Admin can fix the criteria for the admission of student. Admin can enter the roll no of a particular student if he wants to show the full profile of student. Admin can change his bio data and profile if he needed it.

For Student: When any student takes admission in LAB. Admin take requirement for the branch and course and check that their is a seat available in that particular branch & course and allotted as required and admin give a unique student id & password for student and admin give a unique parents id & password for parents. 

Attendance: admin can see the attendance of all branches students year wise, branch wise, and roll no. wise. And admin is update and modification in attendance of all branches students. If admin has any issue of attendance of particular student then admin can be update notice in student account and parents account.



Marks: : admin can see the marks of all branches students year wise, branch wise, and roll no. wise. And admin is update and modification in marks of all branches students. If Page 4

admin has any issue of marks of particular student then admin can be update notice in student account and parents account. 

Notices: if admin has any issue for any student’s marks and attendance and other field then admin can be update notice in student & parents account for parents and students. If admin wants to give any notice for a particular student then admin can be give a message or notice for student.



Calendar: admin can be update a calendar for students. information about the midterms, practical and final exam dates in this calendar. Admin can be update calendar branch wise and year wise.



Time table: admin can be update a time table for students. information about the classes time with particular subject with day wise in this time table. Admin can be update time table branch wise and year wise.



News: admin can be update news in particular student and year wise and branch wise. information of LAB events,

functions. and information regarding technical &non

technical.

For Parents When any student take admission in LAB. Admin give a unique parents id & password for parents. 

Notice: If admin has any issue of attendance & marks of particular student then admin can be update notice in student account and parents account. So parents can see the notice of LAB regarding to student.

Mentor For LAB & Self mentor after login can be change in his profile and bio data. Mentor can be create a list for his contact. In this list he update the name, contact no, address, email id, etc. of his friends and faculty teacher.

For Student: 

Attendance: mentor can see the attendance of only their branch students year wise and roll no. wise. And mentor is update and modification in attendance of only their branch Page 5

students. If mentor has any issue of attendance of particular student then mentor can be update notice in student account and parents account. 

Marks: mentor can see the marks of only their branch students year wise and roll no. wise. And mentor is update and modification in marks of only their branch students. If mentor has any issue of marks of particular student then mentor can be update notice in student account and parents account.



Notices: if mentor has any issue for any student’s marks and attendance then mentor can be update notice in student & parents account. If mentor wants to give any notice for a particular student then mentor can be give a message or notice for student.



Time table: mentor can be update a time table for students of their branch. Information about the classes’ time with particular subject and subject teacher name in this time table. Mentor can be update time table year wise.



Profile & contact list: mentor can be see the profile of their branch students.

For Parents: If mentor has any issue of attendance & marks of particular student then mentor can be update notice in student account and parents account. For faculty: mentor can be update time table of faculty teacher. and mentor can see the contact no, address, email id and other information of his branch teacher.

Faculty For LAB & Self faculty can see their feedback and profile and bio data. and faculty can be change and update their profile and bio data but cannot be change the their feedback. For Student: faculty will take the attendance of their lecture students. And update the attendance & marks of students. if faculty has any issue for any student’s marks and attendance then teacher can be update notice in student & parents account. If faculty wants to give any notice for a particular student then faculty can be give a message or notice for student. For Parents: If mentor has any issue of attendance & marks of particular student then mentor can be update notice in student account and parents account.

Page 6

LAB Management System Modules Login & registration 

Admin: when any student take admission in LAB. admin give a unique student id & password for student and admin give a unique parents id & password for parents. For login in student & parents pannel. And admin can be login in LAB pannel. Admin give a unique id and password for faculty teacher.



Mentor: mentor can be login in LAB pannel.



Faculty: teacher can be login in LAB pannel.



Parents: parents can be login in parents pannel.



Student: student can be login in student pannel.

Bio data  Admin  admin can see the bio data of student and faculty. After searching by roll no. and name wise.  Admin can be change in their bio data.

 Mentor  mentor can be update and changes in their bio data.  mentor can see the bio data of their branch student. After searching by roll no.

 Faculty  faculty can be update and change in their bio data.  faculty teacher can see the bio data of their branch student. After searching by roll no.

 Parents:  Parents can see the bio data of student.

Page 7

 Student:  student can be update in their bio data.

Attendance  Admin Admin can be update and see the attendance of student. After search by semester wise and roll no wise. 

Mentor: mentor can be update and see the attendance of student. After search by semester wise and roll no wise.



Faculty: faculty can be update and see the attendance of student. After search by branch wise and roll no wise.



Parents: parents can see the attendance of student by semester wise and subject wise after search.



Student: student can see the attendance by semester wise and subject wise after search.

Marks: 

Admin: admin can be update and see the marks of student. After search by semester wise and roll no wise.



Mentor: mentor can be update and see the marks of student. After search by branch wise and roll no wise.



Faculty: faculty can be update and see the marks of student. After search by branch wise and roll no wise.



Parents: parents can see the marks of student by semester wise and subject wise after search.



Student: student can see the marks by semester wise and subject wise after search.

Page 8

PROPOSED SYSTEM 4.1INTRODUCTION TO LAB MANAGEMENT SYSTEM This project mainly used for LAB Management System of new or old student’s and LAB department. This project I use many operations for keeping record. We use student registration and LAB department record stored and performs for the HOD of Department form, search form and their LAB and department, students record. In this project we need to fill up the basic information about the LAB Management System into the registration form, total qualifications, percentages, result, and all of LAB record, and student and staff Employee current & permanent address etc.

a) Registration Form:When we enter the correct registration in the registration form n we enter in our project end work in it.

b) LAB Management System form:In this form we can insert those students and staff which are already login from the LAB.

c) Search:By using this form operator can search own self the students & LAB department by using information of branch and LAB department academic gap n back and other information which is required in very easy manner?

c) View Form:Using this option form operator can get the LAB Management System by providing LAB department all of record.

4.2Features of the Proposed System: In earlier time, the LAB was using the manual system, which as based on the entries on the registers. When a student want LAB Management System from the LAB then he must do the entries in the register and also when he/her talk record than help desk is also need to do the entry

Page 9

registers. The computerized integrated system from the existing system will have the following advantage: 

Handle volume of information.



Complexity of data processing.



Processing time constant.



Computational demand.



Instantaneous queries.



Security features.

In detail, the application needs to be developed for LAB Management System FORM.

Each of the application modules will have the following features: 

Linking of information as an integrated centralized system.



Data Entry



Query system

To define various levels of access control and security requirements, system will place the restriction on the use of different screens etc. It has one part

Page 10

OBJECTIVE OF THE PROJECT This project is invented for the LAB Management System of the student employee in LAB. The objective of the project solution for simplifying the entry process. It provides user friendly interface. The main objectives of the LAB Management System project are following: 

Easy searching of student, LAB & employee information.



Increase high throughputs.



Decrease overheads.



Minimization redundancy.



Make data more secure.



Improve report generation process to improve decision making.



To provide fast accurate and consist response.



Proposed system is according to the current demand.

Scope Our project has a big scope to do. We can store information of all the student & LAB record. LAB Management System is categorized according to various streams. Various companies can access the information. Students & LAB can maintain their information and can update it. Notifications are sent to students about the companies. Students & LAB department can access previous information about LAB. There are fallowing modules and forms are used1. Institute Record. 2. Student Record. 3. LAB Management System. 4. Category’s selection form. 5. Reporting, Withdraw. 6. Campus Placement. 7. Staff Salary.

Page 11

8. New Admission. 9. LAB Results. 

LAB information: Through this service one can access the complete information about the LAB campus such as courses available, admission procedure, placements, LAB events, achievements etc.



Student tracking: Any company or any organization that want to check the summary about the student of the LAB, so that they will be able to choose the particular students for their campus placement And for that purpose they will be given a particular link through which they can access the information required.



Student attendance status: It gives the attendance status of students. Faculty will update the attendance periodically and can be seen by students and parents.



Student’s performance in exams: This facility provides the performance of the student in each exam which is conducted by university or LAB such as midterm performance. Marks obtained by students in exams will be updated by faculties that can be access by students and parents.



Exam Notification: This facility notifies students and parents about examination schedule.



Events: It will give information about different events that will be conducted by LAB time to time. Information about these events will be updated by administrator.



Online assignments: This service provides the facility to faculty to upload assignments and to students to submit these assignments online.



Information about staff: It will help in maintaining complete information about LAB faculty members such as their department, cadre, date of joining, salary, etc. Administrator will register new faculties and remove their account when they leave the LAB.

Page 12

Page 13

1.4 Study of the System: 1.5 Graphical user interface In the flexibility of the uses the interface has been developed a graphics concept in mind, associated through a browser interface. The GUI’S at the top level have been categorized as 1. Administrative user interface 2. The operational or generic user interface The administrative user interface concentrates on the consistent information that is practically, part of the organizational activities and which needs proper authentication for the data collection. The interfaces help the administrations with all the transactional states like Data insertion, Data deletion and Date updation along with the extensive data search capabilities. The operational or generic user interface helps the users upon the system in transactions through the existing data and required services. The operational user interface also helps the ordinary users in managing their own information helps the ordinary users in managing their own information in a customized manner as per the assisted flexibilities.

4.4 Number of Modules The system after careful analysis has been identified to be presented with the following modules: The modules involved are: 1. LAB information: Through this service one can access the complete information about the LAB campus such as courses available, admission procedure, placements, LAB events, achievements etc. 2. Student tracking: Any company or any organization that want to check the summary about the student of the LAB, so that they will be able to choose the particular students for their campus placement And for that purpose they will be given a particular link through which they can access the information required.

Page 14

3. Student attendance status: It gives the attendance status of students. Faculty will update the attendance periodically and can be seen by students and parents. 4. Student’s performance in exams: This facility provides the performance of the student in each exam which is conducted by university or LAB such as midterm performance. Marks obtained by students in exams will be updated by faculties that can be access by students and parents. 5. Exam Notification: This facility notifies students and parents about examination schedule. 6. Events: it will give information about different events that will be conducted by LAB time to time. Information about these events will be updated by administrator. 7. Online assignments: This service provides the facility to faculty to upload assignments and to students to submit these assignments online. 8. Information about staff: It will help in maintaining complete information about LAB faculty members such as their department, cadre, date of joining, salary, etc. Administrator will register new faculties and remove their account when they leave the LAB.

Page 15

SYSTEM DESIGN 8.1. Introduction: The objective of the system design is to deliver the requirements as specified in the feasibility report. System design involves first logical design (logical design) and then physical construction (detailed design) of the system. The logical design describes the structure and characteristics of features, such as the outputs, inputs, files, databases, and procedures. The physical construction produces actual program software, files, and a working system.

System design goes through two phases of development: 1. Logical Design 2. Physical Design

1. Logical Design:We know that a data flow diagram shows the logical flow of a system and defines the boundaries of the system. Logical design specifies the user need at a level of details that virtually determine the information flow into and out of the system and the required data resources. Logical design describes the inputs, outputs, database and procedures .All in a format that meets the user’s requirements.

2. Physical Design:It provides the working system by defining the design specification that tells programmers exactly what that candidate system must do. In short it can state that physical design is the implementation of the logical design.

Physical system design consists of the following(a)Design the physical system • Specify input, output media • Design the database and specify backup procedures. • Design physical information flow through the system and a physical design walkthrough.

Page 16

Perform and evaluate feasibility studies like cost-benefit analysis, technical feasibility, time feasibility and operational feasibility for the project. Project Scheduling should be made using PERT charts. Feasibility study is carried out t decide whether the proposed system is feasible for the company. The feasibility study is to serve as a decision document it must answer three key questions: 1. Is there a new and better way to do the job that will benefit the user? 2. What are the cost and the savings of the alternative(s)? 3. What is recommended?

Technical feasibility: Technical feasibility centers on the existing computer system i.e. Hardware, Software etc. Bank

requires SQL database management that are all easily available with extensive

development support through manuals and blogs.

Economical feasibility: Economical Feasibility is the most frequently used method for evaluating the effectiveness of a candidate system. More commonly known as Cost/ Benefit analysis, the procedure is to determine the benefits and savings that are expected from the candidate system and compare them with costs. If the benefits outweigh costs, then the decision is made to design and implement the system.

Page 17

Adopted, System Implementation & Details of Hardware & Software Used 6.1 Methodology adopted and System implementation: 1. Apache tomcat is used as a web server to host the application. 2. All the environment variables are set. 3. The application is pasted in the webapps folder. 4. Web server is started now. 5. Application is run using the web browser by typing http://localhost/cis 6. Web.xml file is used to control the flow and user actions.

6.2 Details of hardware & software used: Hardware Specification (Minimum): Disc Space:

40 GB

PC Used:

IBM Compatible

Processor:

Pentium 3

Memory:

2 GB RAM

File System:

32 Bit

Software Specification: Operating System (Server Side):

Windows 7,8.

Operating System (Client Side):

Windows 7, 8.

Client End Language:

VISUAL BASIC 6.0

Local Validation:

PHP

Server Side Language:

PHP

Database:

My Sql

Web Browser:

Internet Explorer 8/ Mozilla Firefox

Page 18

7. DETAILED LIFE CYCLE OF PROJECT We have used Waterfall Model as Software Engineering life Cycle Process. It is the simplest; oldest and most widely used process model for software development .This model acquires its name from the fact that classic software life cycle is represented as a sequence of descending steps.

Page 19

7.1 Requirement Analysis: This process is also known as feasibility study. In this phase, the development team studied the site requirement. They investigate the need for possible dynamic representation of the site and increase security features. By the end of feasibility study, the team furnishes a document that holds the different specific recommendations for the candidate system. It also includes personnel assignments, costs, project schedules, target dates etc. the requirement gathering process is intensified and focused specially on software. The essential purpose of this phase is to find the need and to define the problem that needs to be solved. During this phase following facts were gathered. 

Determined the user need



Identified the facts



Establish the goals and objective for the proposed system



Feasibility for the new system

7.2 System Analysis and Design: In this phase the software’s overall structure and its nuances are defined. In terms of client server technology the no of tiers needed for the package architecture, database design, data structure design etc are defined in this phase. Analysis and Design are very crucial in entire development cycle. Any glitch in this phase could be expensive to solve in the later stage of software development. Hence following is the essential approach taken during website designing: 

DFD



Database Designing



Form Designing



Pseudo code for methods

Page 20

8 ER-Diagram and Data Flow Diagram ER-Diagram:Data Flow Diagram:8.2.1 Context 0th Level Diagram:

Data Out Put Stage

Data Input Stage

ADMIN Admin

Staff

Data Storage

Staff

Student

UI Screens

Student Parent

Parent Campus Information System

Page 21

8.2.2 Login DFD Diagram:

tbl_UserLogin

Open Login form

Enter Student Id

Check Student Id

Verification Data

Validate Data

User Home Page

Page 22

8.2.3 Admin Details Data Flow: 1st level DFD:

Login Admin

Enter details

Students info

Update

Page 23

2nd Level DFD

Admin

Login

Id

Login Password

Page 24

Admin

Enter details Student table

Admin Student

Modify Student

table

Faculty info.

Notification

Page 25

8.2.4 Student Details Data Flow 1st level DFD

Login Student

Enter details

Student’s info

Update

Page 26

2nd level DF

Student

Student

Login

Id

Login

Password

View marks

Student table

Attendance Notices Grades

Page 27

Student

Query

Faculty

Feed back Submission

Mgmt.

Page 28

V.B. FORM DESIGN & CODDING FORM - 1 : WELCOME FORM CODE : WELCOME FORM (FrmWelcome.frm)

Private Sub Form_Resize( ) Img1.Height = Me.ScaleHeight Img1.Width = Me.ScaleWidth LblWelcome1.Left = (Me.ScaleWidth / 2 - LblWelcome1.Width / 2) LblWelcome2.Left = Me.ScaleWidth / 2 - LblWelcome2.Width / 2 LblRpbc1.Left = (Me.ScaleWidth / 2 - LblRpbc1.Width / 2) + 60 LblRpbc2.Left = Me.ScaleWidth / 2 - LblRpbc1.Width / 2 LblLib1.Left = Me.ScaleWidth / 2 - LblLib1.Width / 2 LblLib2.Left = (Me.ScaleWidth / 2 - LblLib2.Width / 2) + 60 LblSys1.Left = Me.ScaleWidth / 2 - LblSys1.Width / 2 LblSys2.Left = (Me.ScaleWidth / 2 - LblSys2.Width / 2) + 60 End Sub Page 29

Private Sub Img1_Click( ) FrmLogin.Show Timer1.Enabled = False End Sub Private Sub LblWelcome1_Click( ) FrmLogin.Show Timer1.Enabled = False End Sub Private Sub Timer1_Timer( ) FrmLogin.Show vbModal Timer1.Enabled = False End Sub FORM - 2 : LOGIN FORM (FrmLogin.frm) CODE : LOGIN FORM (FrmLogin.frm)

Dim rs_user As New Recordset Page 30

Private Sub CmdCancel_Click() End End Sub Private Sub CmdLogin_Click() bkType = "LAB" userType = "L" Class = "BBA": Yer = "FY"

If Trim(TxtUser) = "" And Trim(TxtPwd) = "" Then MsgBox "Fill all the details", vbInformation, "Login" TxtUser.SetFocus Exit Sub End If If TxtUser = "LAB STORE" And TxtPwd = "INDISOFT" Then userType = "L" userNm = "LAB STORE" Unload FrmWelcome Unload FrmLogin MDIFrm.Show Exit Sub End If If rs_user.RecordCount <> 0 Then rs_user.MoveFirst Page 31

rs_user.Find "usr = '" & TxtUser & "'" If Not rs_user.EOF Then If rs_user.Fields(1) = TxtPwd Then userType = rs_user.Fields(2) userNm = rs_user.Fields(0) Unload FrmWelcome Unload FrmLogin MDIFrm.Show Exit Sub Else MsgBox "Wrong username or password.", vbCritical, "Login" TxtUser.SetFocus Exit Sub End If Else MsgBox "Wrong username or password.", vbCritical, "Login" TxtUser.SetFocus Exit Sub End If Else MsgBox "Wrong username or password.", vbCritical, "Login" TxtUser.SetFocus Exit Sub Page 32

End If End Sub Private Sub Form_Load() 'OPEN RECORDSET rs_user.Open "select * from Login_Mast", conn, adOpenStatic, adLockPessimistic End Sub Private Sub Form_Unload(Cancel As Integer) rs_user.Close End Sub Private Sub TxtPwd_GotFocus() Call selectTxt(TxtPwd) End Sub Private Sub TxtPwd_KeyPress(KeyAscii As Integer) If KeyAscii = 39 Then KeyAscii = 0 End If KeyAscii = upper(KeyAscii) End Sub Private Sub TxtUser_GotFocus() Call selectTxt(TxtUser) End Sub Private Sub TxtUser_KeyPress(KeyAscii As Integer) Page 33

If KeyAscii = 39 Then KeyAscii = 0 End If KeyAscii = upper(KeyAscii) End Sub FORM – 3 : MDI FORM (MDIFrm.frm)

FORM – 3 : MDI FORM (MDIFrm.frm) Option Explicit Dim rs As New ADODB.Recordset Dim FL As String 'TO STORE FILE NAME Dim rpt As String Private Sub CmdBkEntry_Click() Call MnuBkOpr_Click End Sub

Page 34

Private Sub CmdBkRpt_Click() Dim str As String str = InputBox("Enter LAB for LAB report and CD for Cd report", "Report Creation", "LAB") If str = "LAB" Then Call MnuBkRpt_Click ElseIf str = "CD" Then Call MnuCdRpt_Click Else MsgBox "Invalid input.", vbCritical, "Report Creation" End If End Sub Private Sub CmdBkSubISu_Click() Call MnuBkIsuSub_Click End Sub Private Sub CmdExit_Click() End End Sub Private Sub CmdIsuDtl_Click() Call MnuBkIsuDtl_Click End Sub Private Sub CmdIsuRpt_Click() Call mnuIsuRpt_Click Page 35

End Sub Private Sub CmdMbrEntry_Click() Call MnuMbrOpr_Click End Sub Private Sub CmdMbrRpt_Click() Call MnuMbrRpt_Click End Sub Private Sub CmdUAcc_Click() Call MnuUmgAcc_Click End Sub Private Sub LblClose_Click() Pct1.Visible = False End Sub Private Sub MDIForm_Load() 'CHECK USER TYPE If userNm = "LAB STORE" Then MnuUmg.Enabled = False CmdUAcc.Enabled = False End If If userType = "L" Then MnuBkIsuSub.Enabled = False MnuRpt.Enabled = False CmdBkSubISu.Enabled = False Page 36

End If End Sub Private Sub MDIForm_Resize() 'RESIZE STATUS BAR If Me.Width > 1000 And Me.Height > 1000 Then StatusBar1.Panels(1).Width = Me.ScaleWidth * 0.5 StatusBar1.Panels(2).Width = Me.ScaleWidth * 0.11 StatusBar1.Panels(3).Width = Me.ScaleWidth * 0.11 StatusBar1.Panels(4).Width = Me.ScaleWidth * 0.11 StatusBar1.Panels(5).Width = Me.ScaleWidth * 0.11 StatusBar1.Panels(6).Width = Me.ScaleWidth * 0.05 StatusBar1.Panels(1) = "Current User : " & userNm & "(" & userType & ")" End If 'ARRANGE PICTURE BOX AND OTHER COMMAND BUTTONS Pct1.Height = Me.Height If Me.Height >= 8100 And Me.Width >= 11500 Then 'MAKE LABLE TO CENTER LblTask.Left = Me.ScaleWidth / 2 - LblTask.Width / 2 'SET ALL COMMAND BUTTONS AND FRAME CmdUAcc.Left = Me.ScaleWidth / 2 - CmdUAcc.Width / 2 FramIsu.Left = Me.ScaleWidth / 2 - FramIsu.Width / 2 FramMbr.Left = FramIsu.Left - FramMbr.Width - 500 FramBk.Left = FramIsu.Left + FramIsu.Width + 500 Page 37

'SET COMMAND BUTTON TO CENTER CmdExit.Left = Me.ScaleWidth / 2 - CmdExit.Width / 2 LblClose.Top = Me.Height - 1500 LblClose.Left = Me.ScaleWidth - 2500 End If End Sub Private Sub MDIForm_Unload(Cancel As Integer) End End Sub Private Sub MnuAbtLib_Click() Pct1.Visible = False frmAbout.Show vbModal End Sub Private Sub MnuBkIsuDtl_Click() Pct1.Visible = False FrmIsuDtl.Show End Sub Private Sub MnuBkIsuSub_Click() Pct1.Visible = False FrmLABIsu.Show End Sub Private Sub MnuBkOpr_Click() Pct1.Visible = False Page 38

frmBkEntry.Show End Sub Private Sub MnuBkRpt_Click() Call LABCdReport("LAB") 'GENERATE REPORT End Sub Private Sub MnuCdRpt_Click() Call LABCdReport("CD") 'GENERATE REPORT End Sub Private Sub mnuIsuRpt_Click() Pct1.Visible = False Report = "I" 'I means Issue Report FrmRpt.Show vbModal End Sub Private Sub MnuMbrOpr_Click() Pct1.Visible = False FrmMember.Show End Sub Private Sub MnuMbrRpt_Click() Pct1.Visible = False Report = "M" 'M means Member Report FrmRpt.Show vbModal End Sub Private Sub MnuMstrSelection_Click() Page 39

Pct1.Visible = True End Sub Private Sub MnuUmgAcc_Click() Pct1.Visible = False FrmUserMng.Show vbModal End Sub Private Sub MnuWinClose_Click() Do While Forms.Count - 1 > 0 Unload Me.ActiveForm Loop End Sub Private Sub MnuWinCscd_Click() Arrange vbCascade End Sub Private Sub MnuWinHrz_Click() Arrange vbHorizontal End Sub Private Sub MnuWinVrtl_Click() Arrange vbVertical End Sub =='GENERATE REPORT FOR LAB/CD (PROCEDURE) Private Sub LABCdReport(typ As String) Set rs = New Recordset Page 40

If typ = "LAB" Then rs.Open "SELECT Code,Title,Author,Price,Qty FROM LAB_Mast WHERE Code like 'B%'", conn, adOpenStatic, adLockReadOnly Else rs.Open "SELECT Code,Title,Author,Price,Qty FROM LAB_Mast WHERE Code like 'C%'", conn, adOpenStatic, adLockReadOnly End If 'WHEN NO RECORD EXIST If rs.RecordCount = 0 Then rs.Close MsgBox "No record is found.", vbInformation, "Member Report" Exit Sub End If 'CREATE REPORT 'OPEN FILE FL = typ & "_" & Format(Date, "dd-mm-yyyy") Open App.Path & "\Reports\" & FL & ".txt" For Output As #1 Print #1, "" Print #1, "--------------------------------------------------------------------" If typ = "LAB" Then Print #1, "----------- B O O K S R E P O R T ---------------" Else Print #1, "-------- C D R E P O R T ----------------------" Page 41

End If Print #1, "---------------------------------------------------------" rs.MoveFirst Do While Not rs.EOF Print #1, " " & rs!Code & " " & _ Space(6 - Len(rs!Price)) & rs!Price & _ Space(11 - Len(rs!qty)) & rs!qty Print #1, "" rs.MoveNext Loop rs.Close Close #1 MsgBox FL & ".txt created successfully.", vbInformation, "Member Report" Shell App.Path & "\Reports\wordpad.exe " & App.Path & "\Reports\" & FL & ".txt", vbMaximizedFocus End Sub

Page 42

FORM – 4 : USER MANAGEMENT (FrmUserMng) CODE : USER MANAGEMENT (FrmUserMng.frm)

Private Sub CmdCancel_Click() Unload Me End Sub Private Sub CmdCreateAcc_Click() FrmCreateAcc.Show vbModal End Sub Private Sub CmdDeleteAcc_Click() Unload Me FrmUserDelete.Show vbModal End Sub Private Sub CmdEditAcc_Click() Unload Me FrmEditAcc.Show vbModal End Sub Page 43

Private Sub Form_Load() If userType = "L" Then CmdCreateAcc.Enabled = False CmdDeleteAcc.Enabled = False End If End Sub Private Sub Form_Unload(Cancel As Integer) If Forms.Count = 2 Then MDIFrm.Pct1.Visible = True End If End Sub FORM – 5 : CREATE NEW USER (FrmCreateAcc)

Page 44

CODE : CREATE NEW USER (FrmCreateAcc) Dim rs_user As New ADODB.Recordset Private Sub CmdBack_Click() Unload Me FrmUserMng.Show vbModal End Sub Private Sub CmdCancel_Click() Unload Me End Sub Private Sub CmdCreateAcc_Click() Dim Query As String, typ As String If Trim(TxtUser.Text) = "" Or Trim(TxtPwd) = "" Or Trim(TxtConfPwd) = "" Then MsgBox "All fields are compulsory.", vbInformation, "User Addition" Exit Sub ElseIf Trim(TxtPwd) <> Trim(TxtConfPwd) Then MsgBox "Your confirm password do not match." & vbCrLf & _ "Type your confirm password again.", vbCritical, "User Addition" TxtConfPwd.SetFocus Exit Sub End If 'DUPLICATION CHECK Page 45

rs_user.MoveFirst rs_user.Find "usr='" & TxtUser & "'" If rs_user.EOF Then 'USER NOT EXIST If CmbUserType.Text = "ADMIN" Then typ = "A" Else typ = "L" End If Query = "insert into Login_Mast values ('" & TxtUser & "','" & _ TxtPwd & "','" & typ & "')" MsgBox Query conn.Execute Query MsgBox "New user is successfully added.", vbInformation, "User Addition" TxtUser = "" TxtPwd = "" TxtConfPwd = "" CmbUserType.SetFocus Call Form_Load Else 'USER IS ALREADY EXIST MsgBox "User already exit. Enter another user name.", vbCritical, "User Additon" TxtUser.SetFocus End If Page 46

End Sub Private Sub Form_Load() MDIFrm.Pct1.Visible = False 'OPEN RECORDSET If rs_user.State = 1 Then rs_user.Close rs_user.Open "select * from Login_Mast", conn, adOpenStatic, adLockPessimistic 'CLEAR TEXT BOX TxtUser.Text = "" TxtPwd.Text = "" TxtConfPwd.Text = "" CmbUserType.Text = CmbUserType.List(0) End Sub Private Sub Form_Unload(Cancel As Integer) rs_user.Close End Sub Private Sub TxtConfPwd_GotFocus() Call LAB.selectTxt(TxtConfPwd) End Sub Private Sub TxtConfPwd_KeyPress(KeyAscii As Integer) If KeyAscii = 39 Or KeyAscii = 34 Or KeyAscii = 32 Then KeyAscii = 0 End If Page 47

KeyAscii = LAB.upper(KeyAscii) End Sub Private Sub TxtPwd_GotFocus() Call LAB.selectTxt(TxtPwd) End Sub Private Sub TxtPwd_KeyPress(KeyAscii As Integer) If KeyAscii = 39 Or KeyAscii = 34 Or KeyAscii = 32 Then KeyAscii = 0 End If KeyAscii = LAB.upper(KeyAscii) End Sub Private Sub TxtUser_GotFocus() Call LAB.selectTxt(TxtUser) End Sub Private Sub TxtUser_KeyPress(KeyAscii As Integer) If KeyAscii = 39 Or KeyAscii = 34 Or KeyAscii = 32 Then KeyAscii = 0 End If KeyAscii = LAB.upper(KeyAscii) End Sub

Page 48

FORM - 5 : CHANGE PASSWORD (FrmEditAcc)

CODE – 5 : CHANGE USER NAME & CHANGE PASSWORD (FrmEditAcc) Dim rs_user As New ADODB.Recordset Dim Query As String Private Sub CmdBack_Click() Unload Me FrmUserMng.Show vbModal End Sub Private Sub CmdCancel_Click() Unload Me End Sub Private Sub CmdPwd_Click() 'CHECKING FOR BLANCK TEXT BOXES If Trim(TxtUser) = "" Or Trim(TxtCurPwd) = "" Or Trim(TxtNewPwd) = "" Or Trim(TxtConfPwd) = "" Then MsgBox "All fields are compulsory.", vbInformation, "Change Password" Exit Sub End If Page 49

'CHECKING FOR NEW PASSWORD & CONF. PASSWORD MATCHING If TxtNewPwd <> TxtConfPwd Then MsgBox "Your confirm password do not match." & vbCrLf & "Enter confirm password again.", vbCritical, "Change Password" Exit Sub End If If userType = "A" Then 'WHEN USER IS ADMIN 'FIND USER IS EXIST OR NOT rs_user.MoveFirst rs_user.Find "usr='" & TxtUser & "'" If rs_user.EOF Then 'USER NOT EXIST MsgBox "User name does not exixt." & vbCrLf & _ "Enter current name again.", vbCritical, "Change Password" TxtUser.SetFocus Exit Sub End If 'IF USER AND PASSWORD NOT MATCH If rs_user.Fields(1) <> TxtCurPwd Then MsgBox "Your current password do not match. Enter it again.", vbCritical, "Change Password" TxtCurPwd.SetFocus Exit Sub Page 50

End If Query = "update Login_Mast set pw='" & TxtNewPwd & "' where usr='" & TxtUser & "'" Else 'WHEN USER IS LIMITED If TxtUser <> userNm Then MsgBox "Your user name not match. Enter it again.", vbCritical, "Change Password" Exit Sub End If rs_user.MoveFirst rs_user.Find "usr='" & TxtUser & "'" 'IF USER AND PASSWORD NOT MATCH If rs_user.Fields(1) <> TxtCurPwd Then MsgBox "Your current password do not match. Enter it again.", vbCritical, "Change Password" TxtCurPwd.SetFocus Exit Sub End If Query = "update Login_Mast set pw='" & TxtNewPwd & "' where usr='" & TxtUser & "'" End If 'UPDATE PASSWORD Page 51

conn.Execute Query MsgBox "Your password is changed successfully.", vbInformation, "Change Password" TxtUser.Text = "" TxtCurPwd.Text = "" TxtNewPwd.Text = "" TxtConfPwd.Text = "" TxtUser.SetFocus End Sub Private Sub CmdUser_Click() Dim typ As String typ = userType If Trim(TxtCurUser) = "" Or Trim(TxtNewUser) = "" Then MsgBox "All fields are compulsory.", vbInformation, "Change User" Exit Sub End If If userType = "A" Then 'WHEN USER IS ADMIN 'FIND USER IS EXIST OR NOT rs_user.MoveFirst rs_user.Find "usr='" & TxtCurUser & "'" If rs_user.EOF Then 'USER NOT EXIST MsgBox "User name does not exixt." & vbCrLf & _ Page 52

"Enter current name again.", vbCritical, "User Edition" TxtCurUser.SetFocus Exit Sub End If If CmbUserType.Text = "ADMIN" Then typ = "A" Else typ = "L" End If 'WHEN CURRENT USER IS CHANGING ACCOUNT If (TxtCurUser = userNm) And (userType <> typ) Then MsgBox "You can not change your account type." & vbCrLf & _ "Login with another Admin user and then change your account type.", vbInformation, "User Edition" Exit Sub End If Query = "update Login_Mast set usr='" & TxtNewUser & "',typ='" & _ typ & "' where usr='" & TxtCurUser & "'" Else 'WHEN USER IS LIMITED If userNm <> TxtCurUser Then MsgBox "Your current name is not correct." & vbCrLf & _ "Enter current name again.", vbCritical, "User Edition" Page 53

TxtCurUser.SetFocus Exit Sub End If Query = "update Login_Mast set usr='" & TxtNewUser & "' where usr='" & userNm & "'" End If 'CHECK FOR DUPLICATE RECORD rs_user.MoveFirst rs_user.Find "usr='" & TxtNewUser & "'" If (rs_user.EOF = False) And (userNm <> TxtNewUser) Then MsgBox "User already exixt. Enter another user name.", vbCritical, "User Edition" Exit Sub End If 'EXECUTE QUERY & UPDATE RECORD conn.Execute Query MsgBox "User name is changed successfully.", vbInformation, "User Edition" MDIFrm.StatusBar1.Panels(1) = "Current User : " & userNm & "(" & userType & ")" End If TxtCurUser.Text = "" TxtCurUser.SetFocus End Sub

Page 54

5 Database Design: Usually, a collection of interrelated data is referring to as database. The database contains information about one particular enterprise. Database system is designed to shear and manage large volume of information .The management of data involves both the manipulation of information .In addition ,the database system must provide for safety information storage in the database ,despite system crashes or unauthorized access.

8.6 Input-Output Design: Input Design: The input design is a crucial part of any system errors. Inaccurate input data are the most common cause of the errors in the processing. Data entry errors can be controlled by input design. Input design is the process of converting user-oriented inputs to computer –based formats .the goal of designing input data is to make data entry as easy, logical and free from errors as possible.

Output Design: Computer output is the most important and direct source of information to the users. Efficient intelligible output design should improve the system’s relationship with the user and help in decision making. A major form of output is a hard copy from the printer. In the system under consideration, the output is in two forms, hard copy from the printer and output to the CRT screen in predefined format.

Design:Design patterns are recurring sequences, built-in .NET patterns are scattered over the framework. In practice, following standard software patterns will help to achieve more standard code that is manageable and understandable by a bigger set of software programmers/developers and architects.

Page 55

CONCLUSION This was the first considerably large and important project undertaken by me during my MCA course. It was an experience that changed the way I perceived project development. The coding could not be started before the whole system was completely finalized. Even then there were so many changes required and the coding needed to be changed. I attribute this to inadequate information gathering from the user. Though there were many meetings with the user and most of the requirements were gathered, a few misinterpretations of the requirements still crept in. It made me realize how important the systems analysis phase is. The project is a classic example for the adage that learning of concepts needs to be supplemented with application of that knowledge. On the whole it was a wonderful experience developing this project and I would have considered my education incomplete without undertaking such a project which allowed me to apply all that I have learnt.

Page 56

BIBLIOGRAPHY

Books Referred  “Visual Studio Complete Reference 6.0” Noel Jecke  “Programming in Visual Basic “Julie Case Bradley  “Visual Basic 6.0” Wright Brothers  “Programming book of ASP.NET 2.5 with C#”  “Professional Book of ASP.NET 3.5 with C#”

Page 57

REFERENCE 

http://www.wisegeek.com



http://www.bonnettutorial.com



http://www.w3school.com

Page 58