A New Computer System For Traveline Transit Computer Science Essay

Published:

Travel Transit Services is a company that provides bus and cab services to commuters. The company aims to provide safe and flexible transportation to customers. In essence, the company makes continuous efforts to maximize customer satisfaction. The high quality of services provided by the company has led to a sizeable growth in its business.The company's Customer Relations (CR) department serves as liaison between TraveLine and its customers. The main responsibility of this department is to enhance the image of TraveLine. For this purpose, the company constantly monitors customer feedback, then suggests, and implements corrective actions. This is the most important task performed by the CR department because it increases customer goodwill.

Requirements of the New System

To take advantage of the latest technology and to facilitate Customer to make online inquiries about the booking, feedback and waiting list status a new system needs to be developed for TraveLine Transite Services. The new system should accomplish the following functions:

Lady using a tablet
Lady using a tablet

Professional

Essay Writers

Lady Using Tablet

Get your grade
or your money back

using our Essay Writing Service!

Essay Writing Service

The new system should store data about employees in the CR department and operational department

The system should provide a logon screen for the employees. The logon screen accepts the employee ID and the valid password.

Only employee's form the CR department should be allowed to log customer feedback.

All operational departments should be able to view the pending complaints. The system should ensure that this option of viewing details is available only to the key person in an operational department.

The system should allow users to enter corrective action details and updated the status of the feedback.

The new system should be capable of generating the pending complaints and customer complaints Investigation reports.

In order to develop the software system for Horizon Airways, you need to analyze the existing system and create a design for the envisioned system, using the case study; you need to create the solution diagrams and the application in the .NET environment.

The Existing System

Customer feedback is categorized as complaints, suggestions, and commendations received from customers. The feedback may be related to any of the transportation services. The details about the regular customer of TraveLine are maintained in the customers Register. A representative from the CR department logs all feedback specified by the customer in a complaints Register.

The operational department that is responsible for handling the complaints, the incident date, the place of incident, the bus stop, feedback description, the registration number of the vehicle, and the employee to whom the feedback will be assigned. The complaint Register also stores the status of the complaint. When a new complaint is lodged, the status of the complaint is marked as 'New'. Each complaint, commendation, and suggestion has a unique reference number. The prefix for the reference number differs in all three cases and is as follows

Complaint

Commendation

Suggestion

The Solution for the new system

The new system is built with a user friendly interface where as the current interface is very complicated and hard to understand. The new System given to handle by the counter assistants to add new registers made by customers, to update them and to cancel and provide tickets are receipts accordingly.

The new system built mainly concerning about the counter assistants for them to find it very easy to interact with the system. Therefore not much technical terms are used, it is built using simple English and less gadgets. It will only have the main forms where the counter assistants will only have to add data and search data in the easiest way while the cancellation will be done and will be provided with a receipt to the customer with the refund amount calculated according to the date of cancellation from the date of reservation.

The interface of the new system will be user friendly as mentioned earlier and the colors used will be easy to look into while a the spacing in between different options will be equal within the same category and different categories will have more space in between.

This new system is very time effective where as the current system takes a long time to update and give search results which also results in the disappointment in customers. This system will only take maximum of 4-5 seconds to give search results and will also update the system very quickly.

Lady using a tablet
Lady using a tablet

Comprehensive

Writing Services

Lady Using Tablet

Plagiarism-free
Always on Time

Marked to Standard

Order Now

Depending on customer feedback and counter assistant's feedback the system is to be changed and renewed with the new requirements.

Visual Basic .NET

Visual Basic .NET (VB.NET) is an object-oriented computer language that can be viewed as an evolution of Microsoft's Visual Basic (VB) implemented on the Microsoft .NET framework. Its introduction has been controversial, as significant changes were made that broke backward compatibility with older versions and caused a rift within the developer community.

Versions of Visual Basic .NET

Visual Basic .NET (VB 7)

The original Visual Basic .NET was released alongside Visual C# and ASP.NET in 2002. C# widely touted as Microsoft's answer to Java received the lion's share of media attention, while VB.NET (sometimes known as VB7) was not widely covered. As a result, few outside the Visual Basic community paid much attention to it.[citation needed]

Those who did try the first version found a powerful but very different language under the hood, with disadvantages in some areas, including a runtime that was ten times as large to package as the VB6 runtime and an increased memory footprint.

Visual Basic .NET 2003 (VB 7.1)

Visual Basic .NET 2003 was released with version 1.1 of the .NET Framework. New features included support for the .NET Compact Framework and a better VB upgrade wizard. Improvements were also made to the performance and reliability of the .NET IDE (particularly the background compiler) and runtime.

In addition, Visual Basic .NET 2003 was also available in the Visual Studio .NET 2003 Academic Edition (VS03AE). VS03AE is distributed to a certain number of scholars from each country for free.

Evolution of VB.NET

Before VB .NET, there was VB and before there was VB, there was BASIC. BASIC stands for Beginner's All-purpose Symbolic Instruction Code. It was developed in 1963 by computer scientists John Kemeny and Thomas Kurtz in Dartmouth College. It was a general purpose programming language that was intended for beginners. In 1975, when the MITS Altair 8800 Microcomputer was released, BASIC became Altair BASIC, developed by the computer heavyweights Bill Gates and Paul Allen. During the eighties, when the personal computer was starting to get into everyone's homes, the BASIC computer language started to lose its hold on the market because more and more people and corporations were using computer programs for complex tasks rather than simple and "basic" tasks.

In 1991, BASIC was infused with its Visual component and became Visual Basic. The new graphical user interface was pioneered by Alan Cooper. Visual Basic was not an instant hit at first due to compatibility issues but it began getting a solid following in the mid to late nineties when developers started becoming familiar with it. In the new millennium, the Visual Basic .NET became the successor of the Visual Basic programming languages.

Visual Basic 2005 (VB 8.0)

Visual Basic 2005 is the name used to refer to the update to Visual Basic .NET, Microsoft having decided to drop the .NET portion of the title.

For this release, Microsoft added many features, including:

Edit and Continue

Design-time expression evaluation.

The My pseudo-namespace (overview, details), which provides:

easy access to certain areas of the .NET Framework that otherwise require significant code to access

dynamically-generated classes (notably My.Forms)

Improvements to the VB-to-VB.NET converter

Visual Basic 2005 Express

Part of the Visual Studio product range, Microsoft created a set of free development environments for hobbyists and novices, the Visual Studio 2005 Express series. One edition in the series is Visual Basic 2005 Express Edition, which was succeeded by Visual Basic 2008 Express Edition in the 2008 edition of Visual Studio Express.

The Express Editions are targeted specifically for people learning a language. They have a streamlined version of the user interface, and lack more advanced features of the standard versions.

Visual Basic 2008 (VB 9.0)

Visual Basic 9.0 was released together with the Microsoft .NET Framework 3.5 on November 19, 2007.

For this release, Microsoft added many features, including:

A true conditional operator, "If(boolean, value, value)", to replace the "IIf" function.

Anonymous types

Support for LINQ

How do you begin VB.net?

Start

All Programs

Microsoft Visual Studio.Net 2003

Microsoft Visual Studio

Task 01

Identify various virtual objects you

Lady using a tablet
Lady using a tablet

This Essay is

a Student's Work

Lady Using Tablet

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Examples of our work

Button Control

One of the most popular controls in Visual Basic is the Button Control. They are the controls which we click and release to perform some action. Buttons are used mostly for handling events in code, say, for sending data entered in the form to the database and so on. The default event of the Button class is based on the Button. Base class which is based on the Control class.

a. Appearance

Appearance section of the properties window allows us to make changes to the appearance of the button. With the help of BackColor and Background image properties we can set a background color and a background image to the button. We set the font style for the text that appears on button with ForeColor and the font property.

b. Behavior

Notable Behavior properties of the button are the Enabled and Visible properties. The Enabled property is set to true by default which makes the button enabled and setting its property to False makes the button disabled.

c. Layout

Layout properties are about the look of the button. (Dock property) A control can be docked to one edge of its parent container or can be docked to all edges fill the parent container. The default value is set to none.

Textbox Control

This control looks like a box and accepts input from the user. The textbox is based on the TextBoxBase class which is based on the control class. Textboxes are used to accept input from the user or used to display text.

Rich Textboxes

It's similar to textboxes but they provide some advanced features over the standard textbox. RichTextBox allows f ormatting the text, say adding colors, displaying particular font types and so on. The RichTextBox, like the textbox is based on the TextBoxBase class which is based on the control class.

Label

Labels are those controls that are used to display text in other parts of the application. They are based on the control class.

LinkLabel

LinkLabel is similar to a Label but they display a hyperlink. Even multiple hyperlinks can be specified in the text of the control and each hyperlink can perform a different task within the application.

CheckBox

CheckBoxes are those controls which gives us an option to select, say, Yes/No or True/False.

RadioButton

RadioButton are similar to Checkboxes but RadioButtons are displayed as rounded instead of boxed as with a checkbox.

ListBox

The ListBox control displays a list of items from which we can make selection. We can select one or more than one of the items from the list. The ListBox control is based on the ListControl class which is based on the Control class.

ComboBox

ComboBox is a combination of a TextBox and a ListBox. The ComboBox displays an editing field (TextBox) combined with a ListBox allowing us to select from the list or to enter new text. ComboBox displays data in a drop down style format.

GroupBox Control

As said above, GroupBoxes are used to Group controls. GroupBoxes display a frame around them and also allow displaying captions to them which is not possible with the Panel control..

PictureBox Control

PictureBoxes are used to display images on them. The images displayed can be anything varying from Bitmap, JPEG, GIF, PNG or any other image format files. The PictureBox control is based on the Control class.

Menus

Menus (File, Edit, Format etc in all windows applications) are those that allow us to make a selection when we want to perform some action with the application.

Date Time Picker, Month Calendar, Splitter

Date Time Picker

Date Time Picker allows us to select date and time. Date Time Picker is based on the control class. When we click on the drop-down arrow on this control it displays a month calendar from which we can make selections.

Notable Properties of Date Time Picker

The Format property in the Appearance section is used to select the format of the date and time selected. Default value is long which displays the date in long format. Other values include short, time and custom

Date TimePicker, Month Calendar, Splitter

Checked List Box

As the name says, Checked List Box is a combination of a List Box and a Check Box. It displays a List Box with a Check Box towards it's left. The Checked List Box class is derived from the List Box class and is based on that class.

CheckedListBox

Notable Properties of Checked List Box

The notable property in the appearance section of the properties window is the Three Checkboxes property which is set to False by default. Setting it to True makes the Checked List Box to be displayed in Flat or Normal style.

Panel, Group Box, Picture Box

Panels are those controls which contain other controls, for example, a set of radio buttons, checkboxes, etc. Panels are similar to Group boxes but the difference, Panels cannot display captions where as Group Boxes can and Panels can have scrollbars where as GroupBoxes can't. Panel

Panels are those controls which contain other controls, for example, a set of radio buttons, checkboxes, etc. Panels are similar to Group boxes but the difference,

ToolTip

ToolTips are those small windows which display some text when the mouse is over a control giving a hint about what should be done with that control.

Print Dialogs 

Providing support for Printing is one of the common tasks during application development. The .NET Framework provides excellent support for Printing documents.

Print Document Component

In the .NET Framework, a printed document is represented by the Print Document component. The Print Document object encapsulates all the information needed to print a page. 

Tab Control

Tab Control occupies the area within the hashed border. It manages the Tab Page objects through its Tab Pages collection property.

screen-shot

DataGridView

Displaying data in tabular format is one of the common requirements in Windows-based

applications. No wonder the DataGridView control is popular amongst Windows Forms developers. The DataGridView control has many enhancements over the earlier DataGrid and it is worthwhile for any Windows developer to master this control. In this article, I am going to illustrate some of the features that were missing (or tedious to implement) in the earlier versions of .NET. Specifically, How to perform data binding with Dataset

How to add button and combo box columns to the grid

How to validate data in the grid

http://www.techotopia.com/images/d/d7/Vb_datagridview_running.jpg

Task 02

Forms In my program

Forms are very important things in a VB.Net program. In Visual Basic its these Forms with which we work. They are the base on which we build; develop all our user interface and they come with a rich set of classes. Forms allow us to work visually with controls and other items from the toolbox. In VB .NET forms are based on the.

This is customer details section, here customer can add the details that means customer can accept this company's regular customer.

This is driver's details; here customer can select the driver.

This is vehicle details here customer can select the wanted vehicle

This is feedback details; here customer can add customer feedback, employee feedback, commendation, Suggestion, vehicle description and company feedback.

This is the rent customer and rent vehicle details, here customer can see the vehicle details and select the vehicle. But customer should add his details………..that is important

Task 03

Every object that I have in my program has its own properties. We can modify the properties of any object on the properties box. It is normally located in the lower right corner of the screen. I can modify attributes like the alignment, style, and labels. Modify the text that will appear on the first label that I created.

This is the name of the object we can call it

using coding

This is the background color of the object we

can change it

We can add image to the object background

through it

Using it we can control user editing or access

to this object

This is used for change the font style

This is used for change the text color

Form Properties

Caption

The text string for the title bar.

Tag

A string available for free use by the programmer. Often used for comments.

Control Box

Check the Control Box to create the X "close" box in the upper right corner of the form and to enable creation of Minimize and Maximize boxes. If checked, will add to the title bar a standard Windows right mouse context menu with Restore, Move, Size, Minimize, Maximize and Close (ALT+F4) choices.

Maximize Box

Create a maximize box control in the title bar along with the control box.

Minimize Box

Create a minimize box control in the title bar along with the control box.

Center on Screen

Display the form in the center of the main Manifold window.

General

Mouse Pointer

The type of mouse pointer displayed when over the DateTimePicker. Choose from 16 different types plus a custom pointer

OLEDropMode

Set to None (default) if the DateTimePicker does not accept OLE drops and is to display the No Drop cursor if an OLE drop is attempted. Set to Manual, the DateTimePicker will trigger OLE drop events, allowing programs to handle the OLE drop operation in code.

Custom Format

string setting forth custom format when Format is set to custom.

Enabled

True or False. True means the object can respond to user-generated events, false prevents it from responding.

CheckBox

False (Default) - Control always returns a date. True - A checkbox appears. If the user does not check this box, no date is returned. Handy for forms where requiring a date ("Due date?") is an option.

UpDown

True - Up Down control appears to change the date instead of a drop down calendar. False (Default) - Calendar appears. When True, switches mode to become a masked edit control   

Font

Properties

Font properties that may be changes.

Font

Choose a font installed on this system. It's wise to choose standard Windows fonts such as MS Sans Serif that are universally available.

.Color

CalendarBackColor

Color to be used for the DateTimePicker's background.

CalendarTitleBack Color

Customize calendar title background color.

 MouseIcon

Custom icon to use when the MousePointer property is set to 99. Like Visual Basic, will not load animated cursor (.ani) files.

Tab control Properties

UseTabControl.PNG

The properties of the font, color, size are similar to all. But the additional option in tab control can customize tabs on the same screen.

The user can add tabs by pressing the Add button. And can be deleted as shown in the below image.

Menu Strip

Visual Basic Add New Menu

Use the Properties panel to change the name of the Menu Strip object to main Menu. Click in the Type Here field at the top of the form and enter &File. This has the effect of creating a menu item object labeled "File". The ampersand (&) is added to instruct Visual Basic to use the 'F' at the beginning of the file as the accelerator key for this menu item. Once the File menu item has been added, Visual Studio will create both a drop down menu and a field to add another menu item as follows:

Visual basic New Menu Item

Click on the Type Here field and type &Open File.... When you have entered this text Visual Studio will add another Type Here field beneath the "Open File" entry. Click in this field and

Visual Studio provides the opportunity to add another item. This time, however, we are going to add a different type of item to the menu. As you move the mouse pointer over the Type Here field, the field will highlight and a down arrow will appear to the right of the Type Here text. Clicking on this arrow drops down a menu of items to add to the menu:

Visual Basic Menu Item Types

The options available are as follows:

MenuItem - Creates a sub-menu (also known as a pull-right menu) which essentially pops up a new menu to the right of the currently displayed menu.

ComboBox - Adds a ComboBox control to the menu. Although you have the option of adding a ComboBox to your menu, you should resist the urge to do so. The placing of a ComboBox in a menu is not considered to be good user interface design.

Separator - Places a separator after the last menu item to be added. Separators in menus are useful for distinguishing between groups of menu items.

TextBox - Adds a TextBox control to the menu. As with the ComboBox, you should resist the temptation to add such a control to a menu as it violates GUI design convention.

Task 04

Design the System Using UML Diagram

Elements of a Use Case Diagram

A use case diagram is quite simple in nature and depicts two types of elements: one representing the business roles and the other representing the business processes. Let us take a closer look at use at what elements constitute a use case diagram.

Actors:

An actor portrays any entity that performs certain roles in a given system. The different roles the actor represents are the actual business roles of users in a given system.

An actor in a use case diagram interacts with a use case. For example, for modeling a banking application, a customer entity represents an actor in the application. Similarly, the person who provides service at the counter is also an actor.

But it is up to you to consider what actors make an impact on the functionality that you want to model. If an entity does not affect a certain piece of functionality that you are modeling, it makes no sense to represent it as an actor.

An actor is shown as a stick figure in a use case diagram depicted "outside" the system boundary.

Customer

An actor in a use case diagram

DetailsTo identify an actor, search in the problem statement for business terms that portray roles in the system. For example, in the statement "patients visit the doctor in the clinic for

medical tests," "doctor" and "patients" are the business roles and can be easily identified as actors in the system.

Use case:

A use case in a use case diagram is a visual representation of distinct business functionality in a system. The key term here is "distinct business functionality." To choose a business process as a likely candidate for modeling as a use case, you need to ensure that the business process is discrete in nature.As the first step in identifying use cases, you should list the discrete business functions in your problem statement. Each of these business functions can be classified as a potential use case.

Uses of arrow

The uses arrow is drawn from a use case X to another use case Y to indicate that the process of doing X always involves doing Y at least once .This symbol can be referred to as an aggregation operator, because it indicates that a given use case is an aggregate whose components are the use cases that it uses.

Uses of extends arrow

The extends arrow (or extends edge) is drawn from a use case X to a use case Y to indicate that the process X is a special case behavior of the same type as the more general process Y. You would use this in situations where your system has a number of use cases (processes)

Show the Booking Details

Show the payment

Facility Details

Show the vehicle Category

Accept the Customer Details

Accept Feedback information

Complaint

<<Extends>>

Operational

Department

Valid

Complaint

Pending

Complaint

Investigation

Complete

When do I use the include arrow?

In one form of interaction, a given use case may include another. "Include is a Directed Relationship between two use cases, implying that the behavior of the included use case is inserted into the behavior of the including use case".

The first use case often depends on the outcome of the included use case. This is useful for extracting truly common behaviors from multiple use cases into a single description. The notation is a dashed arrow from the including to the included use case, with the label "«include»".

Use Case Diagram

LOGIN VALIDATE PASSWORD

<<Include>>

<<Include>>

CR Department

CustomerEnter the Details

Send the Feedback

Search Vehicle

Request the booking Details

Log to the System

Normal

AC

Luxury

Use Class Diagram

Class diagrams are widely used to describe the types of objects in a system and their relationships.  Class diagrams model class structure and contents using design elements such as classes, packages and objects.

Class diagrams describe three different perspectives when designing a system, conceptual, specification, and implementation.   These perspectives become evident as the diagram is created and help solidify the design. 

This example is only meant as an introduction to the UML and class diagrams.  If you would like to learn more see the Resources page for more detailed resources on UML.

Notation

For those not familiar with the notation used for class diagrams, some explanation is in order.

Object-:

A specific entity or concept that has meaning in an application domain.

Class-:

A definition of a set of potential objects that have the same data, behavior, and relationships.

Attribute-:

A data value defined in a class and held within an object that has meaning within the application domain.

Behavior-:

A service defined in a class and provided by an object.

Method-:

The implementation of a behavior in a VB. frame work.Net

Association-:

A "peer-to-peer" relationship between classes.

Class Diagram

A class diagram is similar to a family tree. A class diagram consists of a group of classes and interfaces reflecting important entities of the business domain of the system being modeled, and the relationships between these classes and interfaces. The classes and interfaces in the diagram represent the members of a family tree and the relationships between the classes are analogous to relationships between members in a family tree..

CR Department

Department Name

Department ID

Employee Details

Complaints Details

Vehicle Category

Facilities

Customer

Customer Name

Customer ID

Customer Details

Feedback Details

Employee

Employee Name

Employee ID

Employee Details

State chart diagram

What are statechart diagrams?

Member of the Behavioral group Graph of states and transitions showing the response of an object to external stimuli attached to a class or a method

TraveLine Transit

Quit

Ticket Cancellation

Ticket Status

Online Services

General Inquiry

Exit from Transit

Task 05

Coding for Main Menu

Public Class Form5

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Form1.Show()

End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

Form2.Show()

End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click

Form3.Show()

End Sub

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click

Form4.Show()

End Sub

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click

Close()

End Sub

Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click

Form6.Show()

End Sub

Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click

End Sub

Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click

End Sub

Private Sub Label9_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label9.Click

End Sub

End Class

Coding for Customer Details

Imports System.Data.SqlClient

Public Class Form1

Dim con As New SqlConnection("Data Source=SUNDB;Initial catalog=HND35_VB;user id=hnd;password=hnd")

Dim CustomerID As String

Dim CustomerName As String

Dim Address As Integer

Dim City As String

Dim State As String

Dim ZipCode As String

Dim EmailAddress As String

Dim ContactNumber As String

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

Sub Clear()

TextBox1.Text = ""

TextBox2.Text = ""

TextBox3.Text = ""

TextBox4.Text = ""

r1.Checked = False

b2.Checked = False

TextBox5.Text = ""

TextBox6.Text = ""

TextBox7.Text = ""

TextBox6.Text = ""

' CustomerID = ""

'CustomerName= ""

'Address = ""

' State= ""

' City= ""

'ZipCode= ""

'EmailAddress = ""

'ContactNumber= ""

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Task 06

Comments are important to all the programming language; these comments explain the system, such as user defines names, and all the control buttons properties.

These comments are help to developers………….

Comments can be used to document what the program does and what specific blocks or lines of code do. Since the Visual Basic compiler ignores comments, you can include them anywhere in a program without affecting your code.

Align comments in consecutive lines

For multiple lines of code with trailing comments, align the comments so they will be easy to read.Some developers use tabs to align comments, while others use spaces. Because tab stops can vary among editors and IDEs, the best approach is to use spaces

This coding for used to import the variable declaration part

Imports System.Data.SqlClient

Public Class Form1

Dim con As New SqlConnection("Data Source=SUNDB;Initial catalog=HND35_VB;user id=hnd;password=hnd")

Dim CustomerID As String

Dim CustomerName As String

Dim Address As Integer

Dim City As String

Dim State As String

Dim ZipCode As String

Dim EmailAddress As String

Dim ContactNumber As String

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Coding for deleting

cmdDelete.Parameters.Add(New SqlParameter("@cid", TextBox1.Text))

cmdDelete.Parameters.Add(New SqlParameter("@cid", TextBox2.Text))

cmdDelete.Parameters.Add(New SqlParameter("@cid", TextBox3.Text))

cmdDelete.Parameters.Add(New SqlParameter("@cid", TextBox4.Text))

cmdDelete.Parameters.Add(New SqlParameter("@cid", TextBox5.Text))

cmdDelete.Parameters.Add(New SqlParameter("@cid", TextBox6.Text))

cmdDelete.Parameters.Add(New SqlParameter("@cid", TextBox7.Text))

cmdDelete.Parameters.Add(New SqlParameter("@tp", r1.Checked))

cmdDelete.Parameters.Add(New SqlParameter("@add", b2.Checked))

cmdDelete.Connection = con

cmdDelete.ExecuteNonQuery()

MsgBox("Successfully Deleted")

Catch ex As Exception

MsgBox("No data" & " " & ex.Message)

con.Close()

coding for Adding

cmdAdd.Parameters.Add(New SqlParameter("@cid", TextBox1.Text))

cmdAdd.Parameters.Add(New SqlParameter("@name", TextBox2.Text))

cmdAdd.Parameters.Add(New SqlParameter("@Add", TextBox3.Text))

cmdAdd.Parameters.Add(New SqlParameter("@City", TextBox4.Text))

cmdAdd.Parameters.Add(New SqlParameter("@ZipCode", TextBox5.Text))

cmdAdd.Parameters.Add(New SqlParameter("@Email", TextBox6.Text))

cmdAdd.Parameters.Add(New SqlParameter("@TelNo", TextBox7.Text))

cmdAdd.Parameters.Add(New SqlParameter("@tp", r1.Checked))

cmdAdd.Parameters.Add(New SqlParameter("@add", b2.Checked))

cmdAdd.Connection = con

cmdAdd.ExecuteNonQuery()

MsgBox("Successfully Inserted")

Catch ex As Exception

MsgBox("Invalid data" & " " & ex.Message)

con.Close()

'to find some errors type & " " & ex.Message

End Try

con.Close()

coding for Clearing

Sub Clear()

TextBox1.Text = ""

TextBox2.Text = ""

TextBox3.Text = ""

TextBox4.Text = ""

r1.Checked = False

b2.Checked = False

Task 08

A validation function determines whether or not a string meets certain requirements. This topic discusses the properties of validation functions, and describes how to create and use validation functions.

Validation Functions types

A string that you are attempting to validate falls into one of three categories:

Provably valid.

Probably not valid.

Not valid.

It is obvious what a validation function should do with strings in the first two categories

the third category is harder.

cmdSave.Connection = con

cmdSave.ExecuteNonQuery()

MsgBox("Successfully Inserted")

Catch ex As Exception

MsgBox("Invalid data" & " " & ex.Message)

con.Close()

'to find some errors type & " " & ex.Message

End Try

con.Close()

End Sub

Task 10

Events in the .NET Framework are based on the delegate model. Delegates are type-safe Function Pointers or Callbacks. A delegate can reference both static and instance methods.

Implementation of an event is a three-step procedure.

Declare a delegate, if definition is not provided the .Net Framework would provide a default delegate implementation.

Declare the event signature using the Event keyword and Raise the event using the RaiseEvent statement.

Handle the Event by declaring an event receiver, often called an event handler. Which is a subroutine that responds to an event?

Button Event

rivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

If TextBox1.Text = "" Then

MsgBox("Enter the Customer ID")

TextBox1.Focus()

ElseIf TextBox2.Text = "" Then

MsgBox("Enter the Customer Name")

TextBox2.Focus()

ElseIf TextBox3.Text = "" Then

MsgBox("Enter the Customer ContactNumber")

TextBox3.Focus()

Gantt chartConclusion

This project is given to us as an assessment method to check our knowledge of VB.Net Frame work and related concepts in handling a small scale programming project. In the process of this project, we were expected to identify and use proper tools and methods to do system analysis, system design, system development and system testing.

This is an assignment for Visual Programming. In this assignment I gave good details about which implemented system for Horizon Airways. I think, I gave full fill all the user requirements in this program. When I am starting this program I felt, this is tuff program for me, because some short of weaknesses, I show creating a system through VB. But while I am doing this program, I moved with few amount of confident, because my friends gave me ideas to make this system very successfully. In the system I had few problems in making database connection and generating report. As well as assigning seats for a passenger. But any way, at last I got good idea about company process and I done a system with lot of creative ideas, such as designing buttons, designing frames with nice backgrounds. Finally I hope I done a good system for Horizon Airways.

As well as I done the questions which they asking me, there are such reports I generated through my program, I generated a ticket, and I can refund the amount, who are the people wants to cancel there are tickets. So over all the airline process can be done through this system. I hope this system has all the important airline features and user can handle this system very easily. Then I have done the documentation for my program, but I had in critical situation, because I little late to finishing the program. So at last time only I could able to do this documentation. But any way the documentation little easiest than program, for that I got some confident, and I done the documentation on time. I hope, I done both documentation and program in usual manner and under given scenario. One last thing to mention is that I tried my best to give a nice interface to the system. But it still is a command based interface and users prefer GUI based point and click interfaces. If this can be developed to be such an application, it will be more and more attractive to the users of the system.