Problem Statement
Consider the project database designed and implemented during previous semester i.e. Fall 2024. Its implementation was done using structured query language during previous semester. Try to recall major relations in your project database. You already have its report in printed form.
There is a need to implement a web based solution for above mentioned database. The web based solution must incorporate various functionalities of your project.
(1) Registration of Student/Patient/Passenger/Customer, or whatever is applicable in your project.
(2) Search facilities including partial matches
(3) Any other project specific functionalities
(4) Role based access control
(5) Payment system (if required)
As a first step design above mentioned (i) to (v) user interfaces using paper and pencil.
Next write appropriate html for creating (i) to (v) user interface prototypes.
Create links for navigation among above pages.
Design a menu using list and styles.
Add help pages for user guidance.
Either use table for layout or may opt for flow based layout.
Test user interface prototypes in browser.
Experiment with style sheets.
Code Implementation
1.Registration.aspx
<%@ Page Language="vb" AutoEventWireup="false" CodeFile="Registration.aspx.vb" Inherits="Registration" %>
<!DOCTYPE html>
<html>
<head>
<title>Employee Registration</title>
<style>
body { font-family: Arial; padding: 20px; background: #f9f9f9; }
table { background: #fff; padding: 20px; border: 1px solid #ccc; }
td { padding: 10px; }
.btn { padding: 10px 15px; background: #28a745; color: white; border: none; }
</style>
</head>
<body>
<h2>Register Employee</h2>
<form id="form1" runat="server">
<table>
<tr>
<td>First Name:</td>
<td><asp:TextBox ID="txtFirstName" runat="server" /></td>
</tr>
<tr>
<td>Last Name:</td>
<td><asp:TextBox ID="txtLastName" runat="server" /></td>
</tr>
<tr>
<td>Email:</td>
<td><asp:TextBox ID="txtEmail" runat="server" /></td>
</tr>
<tr>
<td>Phone:</td>
<td><asp:TextBox ID="txtPhone" runat="server" /></td>
</tr>
<tr>
<td>Date of Joining:</td>
<td><asp:TextBox ID="txtDOJ" runat="server" TextMode="Date" /></td>
</tr>
<tr>
<td>Address:</td>
<td>
<asp:TextBox ID="txtStreet" runat="server" placeholder="Street" /><br />
<asp:TextBox ID="txtCity" runat="server" placeholder="City" /><br />
<asp:TextBox ID="txtCountry" runat="server" placeholder="Country" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="btnRegister" runat="server" CssClass="btn" Text="Register" OnClick="btnRegister_Click" />
</td>
</tr>
</table>
</form>
</body>
</html>
1.Registration.vb
Partial Class Registration
Inherits System.Web.UI.Page
Protected Sub btnRegister_Click(sender As Object, e As EventArgs)
Dim name As String = txtFirstName.Text & " " & txtLastName.Text
ClientScript.RegisterStartupScript(Me.GetType(), "alert", "alert('Employee " & name & " registered successfully!');", True)
End Sub
End Class
3. Search.aspx
<%@ Page Language="vb" AutoEventWireup="false" CodeFile="Search.aspx.vb" Inherits="Search" %>
<!DOCTYPE html>
<html>
<head>
<title>Employee Search</title>
<style>
body { font-family: Arial; margin: 20px; }
.btn { background: #007bff; color: white; border: none; padding: 8px 12px; }
</style>
</head>
<body>
<h2>Search Employees</h2>
<form id="form1" runat="server">
<asp:TextBox ID="txtSearch" runat="server" placeholder="Enter name..." />
<asp:Button ID="btnSearch" runat="server" CssClass="btn" Text="Search" OnClick="btnSearch_Click" />
<br /><br />
<asp:Label ID="lblResult" runat="server" ForeColor="Green" />
</form>
</body>
</html>