Mark Plumbing

Download Report

Transcript Mark Plumbing 

Mark Plumbing
Fantasy URL:
www.markplumbing.com
Realistic URL:
www.ectweb3.cs.depaul.edu/bbasset1/markplumbing.aspx
Value & Idea of Website

Mark plumbing will be run by two different
types uses for a database.





Database #1
Database #2
Function and programs I Plan to Implement
Plan of Work
Site Map
Database #1

The database will be used as a scheduling
system where the clients can schedule an
appointment

The employee, by job type, or by date the
database will also ask them to enter a description
of the problem.
Scheme
Database #1 scheme
Receives information from a form that the client fills out on the Internet website
which goes into the following database
CustomerID
#
First
Name
CustomerID #
Employees’s Name
Last Name
Cost
Address of
work site
Phone
Number
Type of
Problem
Date Of
Appointment
Employee’s
Name
Employee’s Name
Employee ID #
Address
Phone number
Work Schedule
More tables will be add during the building process
Position
Database #2



Database #2 will post information to the
website showing what hours are open.
Database #2 will also tell them what
employee will completing the job if they don’t
request a certain employee. Then if they
select a certain employee the database will
give them their open hours.
Database #2 is also going to have a show all
link that will show them all open times for all
employees.
Scheme
Database #2 Scheme
Database #2 will use the same employee information as in Database #1, but
instead of receiving information from the client it will send information to the
client.
Employees’s Name
Employee Name
Address
Work Schedule
Phone number
Day
Work Schedule
Date
Position
Working Hours
More tables will be add during the building process
Functions and Programs I Plan
to Implement (Ideal plans)
Functions




I plan to use ASP.NET
HTML Coding
PHP
Javascript
Programs


Microsoft Access
Notepad
Basic Page Set Up
Is on all slides
(not actual colors=>)
Is the same on
every page
Response
Page (PHP)
Is uniquely
different in
each page
Plan of Work

1st week


2nd and 3rd week


Gather Information from Mark Plumbing (Employee info and
client info)
Design databases
4th week


Design Web site
Link Web site to Databases
Click on Desired
page to view
possible layout
and content.
Site Map
Home Page
Show All Page
Form Page
Employee Availably
Page
Basic Page Set Up
The Mark Plumbing
Web site will consist of
4 pages.
Home Page





Owner: Mark Schedin
Phone Number:
Address:
Office Hours
Will have a dropbox that will allow the viewer
to navigate through the website (on all pages)
Site Map
Employee Availability Page
Form Page




Will have form for the client to fill out, which will
enter data into Database #1
And it will also ask which employee they want to do
the job (planning to use a dropbox with employees
name listed)
Then Database #2 will send the information back to
the website for the clients viewing (Employee
Availability Page.)
On this page there will also be the email address
and phone number were Mark Plumbing can be
contacted at.
Employee Availability Page


Shows Date and Time the employee is
available and as you click select employee
you will be returned to the Form Page by
using Database #2.
Also gives the client the opportunity to view
all employees availability by clicking Show
All.
Site Map
Show All

Shows all employees on one page

Shows a little bio about each employee




How long they have been in the field
How long they worked for Mark Plumbing
What position do they hold at Mark Plumbing
Also allows you to go back to the Form Page
where you can submit a “work order.”
Online calandar
Chapters14/web_calendar_cs.aspx
<%@ page language="cs" runat="server"%>
<script runat=server>
void SelectionChange(Object sender,EventArgs e){
OurLabel.Text = "The date you selected is " +
OurCalendar.SelectedDate.ToShortDateString();
}
</script>
<html>
<head>
<title>Web Control - Calendar</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form runat="server">
<asp:Calendar id="OurCalendar"
CellPadding="2"
Font-Name="verdana"
Font-Size="12px"
FirstDayOfWeek="Monday"
TitleStyle-Font-Size="14px"
TitleStyle-BackColor="#CCCCCC"
NextMonthText=">>"
PrevMonthText="<<"
NextPrevStyle-Font-Bold="false"
DayHeaderStyle-BackColor="#000000"
DayHeaderStyle-ForeColor="#FFFFFF"
SelectedDayStyle-BackColor="#000000"
ShowGridLines="true"
SelectionMode="Day"
OnSelectionChanged="SelectionChange"
BorderColor="#000000"
runat="server" />
<br><br>
<asp:Label id="OurLabel" runat="server" />
</form>
</body>