ITC Resources

LINQ ADO and Other Stuff

2012-02-15T12:19:00.000-08:00

here is the code for the ListView, but remember to look at chapter 11


<%@ Page Language="C#" AutoEventWireup="true" 
CodeFile="Default.aspx.cs" Inherits="_Default"  
ViewStateMode="Enabled" ViewStateEncryptionMode="Always"%>

<!DOCTYPE html 
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <table>
        <asp:ListView ID="ListView1" runat="server">
         <ItemTemplate>
            <tr>
            <td><%#Eval("ServiceName")%></td>
            <td><%#Eval("ServiceDescription")%></td>
            </tr>
        </ItemTemplate>
        </asp:ListView>
        </table>
    </div>
    </form>
</body>
</html>

Here is the ADO code behind for that page


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection connect = new SqlConnection
       ("Data Source=Localhost;initial catalog=CommunityAssist;integrated security=true");

        string sql = "Select ServiceName, ServiceDescription from [Service]";

        SqlCommand cmd = new SqlCommand(sql, connect);

        SqlDataReader reader=null;

        try
        {
            connect.Open();
            reader = cmd.ExecuteReader();
            ListView1.DataSource = reader;
            ListView1.DataBind();
        }
        catch (SqlException )
        {
            Session["error"] = "There is an error in the SQL String";
            Response.Redirect("Default2.aspx");
        }
        catch (Exception)
        {
            Session["error"] = "Something went wrong, sorry";
            Response.Redirect("Default2.aspx");
        }
        finally
        {
            reader.Dispose();
            connect.Close();
        }


    }
}

Here is the source for the Error page


<%@ Page Language="C#" AutoEventWireup="true" 
CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC 
"-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
    </div>
    </form>
</body>
</html>

And here is the c# from the error page


using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["error"] != null)
        {
            //Exception ex = (Exception)Session["error"];
            //Label1.Text = ex.Message;
            Label1.Text = Session["Error"].ToString();
        }
    }
}

Linq

Remember with LINQ you need to add a new a LINQ to SQL object.

It adds the LINQ Designer

From the solution explored drag tables from a connection onto the designer. This causes Visual Studio to generate classes we can access.

Here is the code for the Linq example


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
        CommunityAssistDataContext dc = new CommunityAssistDataContext();

       
            var donors = from d in dc.PersonContacts
                         where d.ContactTypeKey == 6
                         orderby d.Person.LastName
                         select new
                         {
                             d.Person.LastName,
                             d.Person.FirstName,
                             d.ContactInfo
                         };

            GridView1.DataSource = donors.ToList();
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
        }
    }
}

Functions and Simple Procedures

2012-02-15T11:18:00.001-08:00



--a simple function
Create Function fx_cube
(@number int) --parameter provided by the user
returns int --what data type the function returns
As -- function is an alias for the content below
Begin
--result to return
return @number * @number * @number 
End

--using the function (always needs the schema "dbo" 
--or whatever schema owns it
Select dbo.fx_Cube(3)

--using the function with a field
Select EmployeeKey, dbo.fx_cube(EmployeeKey) From Employee

/***********************
always plot out the function or procedure first
the function will return the price of a subscription
parameters magid and subscriptionTypeID
use MagazineId and SubscriptionTypeID to look up price
********************************/
Use MagazineSubscription 
Go

Create function fx_GetSubscriptionPrice
(@magid int, @subscriptTypeID int) --parameters
Returns money --return type
AS
Begin
Declare @Price money --internal variable
--assign the value from a select statement
Select @Price=SubscriptionPrice
From MagazineDetail
Where MagID=@MagID
AND SubscriptTypeID=@subscriptTypeID
Return @Price --return the value

End


Select * From Magazine
Select * From magazineDetail where MagID=2

--using the function
Select MagName, SubscriptTypeName, 
dbo.fx_GetSubscriptionPrice(m.MagID, st.SubscriptTypeID) 
From Magazine m
Inner Join MagazineDetail md
on m.MagID=md.MagID
inner join SubscriptionType st
on st.SubscriptTypeID=md.SubscriptTypeID
Where m.MagID=2

--another way to declare and set a value
--for a variable
Declare @Today DateTime
Set @Today=GETDATE()
Select @Today


Declare @ID int 
set @ID=@@Identity --retursn the last identity
--created in the database


Declare @ID2 int
--returns the last identity created in the table
set @ID2=IDENT_CURRENT('MagazineDetail')
Select @ID2

Select * from MagazineDetail

Use CommunityAssist

--simple stored procedure
--really a parameterized view
Create proc usp_DonorContact
@contactType int --parameter
As
Select Distinct lastname [Last Name],
Firstname [First Name],
ContactInfo [Contact]
From Person p
inner join PersonContact pc
on p.PersonKey=pc.PersonKey
inner join Donation d
on p.PersonKey=d.PersonKey
Where ContactTypeKey=@ContactType

--calling the procedure
--the exec is optional
--6 is the contact type
Exec usp_DonorContact 6

Indexes and Views

2012-02-13T11:36:00.001-08:00


--views

Use CommunityAssist 

Go
If exists
 (Select name from sys.views
  where name='vw_Donors')
Begin
Drop View vw_Donors
end 
Go
--create a view
Create view vw_Donors
As
Select Distinct lastname [Last Name],
Firstname [First Name],
ContactInfo [Email]
From Person p
inner join PersonContact pc
on p.PersonKey=pc.PersonKey
inner join Donation d
on p.PersonKey=d.PersonKey
Where ContactTypeKey=6
Go

--use the view just like a table
Select * from vw_Donors
 where [Last Name] Like 'Mann%' 


--clustered index primary keys have a clustered index by default 

Create index ix_Lastname on Person(LastName)

--Force a query to use an index
Select * from Person with  (index(ix_LastName))

--a filtered index
Create index ix_City on PersonAddress(City)
Where City != 'Seattle'

--a unique index
Create unique index ix_contact on PersonContact(contactInfo)

Final Project

2012-02-12T14:27:00.000-08:00

The final project is based on the BitbyBitEbooks database. You will install this database and then write the SQL to answer a set of questions. You can work on this in groups of two to four people, or you can do it alone. I would suggest a group. A group often has more ideas and better ideas about how to solve certain problems.

First here is the ERD for the database:

Here is the code to create the database



USE MASTER
GO
IF EXISTS
 (SELECT Name FROM sys.databases
 WHERE name='BitbyBitEBooks')
BEGIN
DROP DATABASE BitbyBitEBooks
END
GO
CREATE DATABASE BitbyBitEbooks

GO
USE [BitbyBitEbooks]
GO
/****** Object:  Table [dbo].[Project]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Project](
 [ProjectKEy] [int] IDENTITY(1,1) NOT NULL,
 [ProjectName] [nvarchar](255) NOT NULL,
 [ProjectStart] [date] NOT NULL,
 [ProjectEnd] [date] NULL,
 [ProjectDescription] [nvarchar](255) NOT NULL,
 [ProjectAdvance] [money] NULL,
 [ProjectAuthorPercent] [decimal](3, 2) NULL,
 CONSTRAINT [PK_Project] PRIMARY KEY CLUSTERED 
(
 [ProjectKEy] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Project] ON
INSERT [dbo].[Project] ([ProjectKEy], [ProjectName], [ProjectStart], [ProjectEnd], [ProjectDescription], [ProjectAdvance], [ProjectAuthorPercent]) VALUES (1, N'WordPress', CAST(0xED300B00 AS Date), CAST(0xCF320B00 AS Date), N'Beginning WordPress', 2000.0000, CAST(0.07 AS Decimal(3, 2)))
INSERT [dbo].[Project] ([ProjectKEy], [ProjectName], [ProjectStart], [ProjectEnd], [ProjectDescription], [ProjectAdvance], [ProjectAuthorPercent]) VALUES (2, N'Snacks for Gamers', CAST(0x42310B00 AS Date), CAST(0x01330B00 AS Date), N'A recipe book for snacks', 800.0000, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[Project] ([ProjectKEy], [ProjectName], [ProjectStart], [ProjectEnd], [ProjectDescription], [ProjectAdvance], [ProjectAuthorPercent]) VALUES (4, N'SQL Server 2008 R2', CAST(0x6F320B00 AS Date), CAST(0x8A330B00 AS Date), N'Administering SQL Server', 2500.0000, CAST(0.07 AS Decimal(3, 2)))
INSERT [dbo].[Project] ([ProjectKEy], [ProjectName], [ProjectStart], [ProjectEnd], [ProjectDescription], [ProjectAdvance], [ProjectAuthorPercent]) VALUES (5, N'SQL', CAST(0x6E320B00 AS Date), CAST(0xE1330B00 AS Date), N'Basic SQL', 2500.0000, CAST(0.08 AS Decimal(3, 2)))
INSERT [dbo].[Project] ([ProjectKEy], [ProjectName], [ProjectStart], [ProjectEnd], [ProjectDescription], [ProjectAdvance], [ProjectAuthorPercent]) VALUES (6, N'Java for Android', CAST(0xA6320B00 AS Date), NULL, N'Introduction to Java for Android Development', 3000.0000, CAST(0.08 AS Decimal(3, 2)))
INSERT [dbo].[Project] ([ProjectKEy], [ProjectName], [ProjectStart], [ProjectEnd], [ProjectDescription], [ProjectAdvance], [ProjectAuthorPercent]) VALUES (7, N'WPF Development', CAST(0xC6320B00 AS Date), NULL, N'windows Presentation foundation and silverlight', 2800.0000, CAST(0.08 AS Decimal(3, 2)))
SET IDENTITY_INSERT [dbo].[Project] OFF
/****** Object:  Table [dbo].[Employee]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Employee](
 [EmployeeKey] [int] IDENTITY(1,1) NOT NULL,
 [EmployeeLasName] [nvarchar](50) NOT NULL,
 [EmployeeFirstName] [nvarchar](50) NOT NULL,
 [EmployeePosition] [nvarchar](50) NOT NULL,
 [EmployeeHireDate] [date] NOT NULL,
 [EmployeeLeaveDate] [date] NULL,
 CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED 
(
 [EmployeeKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Employee] ON
INSERT [dbo].[Employee] ([EmployeeKey], [EmployeeLasName], [EmployeeFirstName], [EmployeePosition], [EmployeeHireDate], [EmployeeLeaveDate]) VALUES (1, N'Brown', N'Paul', N'Chief Editor', CAST(0x48270B00 AS Date), NULL)
INSERT [dbo].[Employee] ([EmployeeKey], [EmployeeLasName], [EmployeeFirstName], [EmployeePosition], [EmployeeHireDate], [EmployeeLeaveDate]) VALUES (2, N'Gardner', N'Susan', N'Copy Editor', CAST(0x48270B00 AS Date), NULL)
INSERT [dbo].[Employee] ([EmployeeKey], [EmployeeLasName], [EmployeeFirstName], [EmployeePosition], [EmployeeHireDate], [EmployeeLeaveDate]) VALUES (3, N'West', N'Melissa', N'Design Editor', CAST(0x352A0B00 AS Date), NULL)
INSERT [dbo].[Employee] ([EmployeeKey], [EmployeeLasName], [EmployeeFirstName], [EmployeePosition], [EmployeeHireDate], [EmployeeLeaveDate]) VALUES (4, N'Long', N'Mark', N' Design Editor', CAST(0x79280B00 AS Date), CAST(0xD9290B00 AS Date))
INSERT [dbo].[Employee] ([EmployeeKey], [EmployeeLasName], [EmployeeFirstName], [EmployeePosition], [EmployeeHireDate], [EmployeeLeaveDate]) VALUES (5, N'Peterson', N'Fred', N'Sales Manager', CAST(0xCA290B00 AS Date), NULL)
SET IDENTITY_INSERT [dbo].[Employee] OFF
/****** Object:  Table [dbo].[Customer]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
 [CustomerKey] [int] IDENTITY(1,1) NOT NULL,
 [CustomerLastName] [nvarchar](50) NULL,
 [CustomerFirstName] [nvarchar](50) NULL,
 [CustomerEmail] [nvarchar](50) NULL,
 CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED 
(
 [CustomerKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Customer] ON
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (1, N'Martin', N'Jeff', N'jMartin@yahoo.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (2, N'Lawrence', N'Larry', N'll@gmail.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (3, N'Towne', N'Peter', N'pTowne@msn.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (4, N'Bradely', N'Susan', N'sBradely@hotmail.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (5, N'Anderson', N'Laura', N'landerson@hotmail.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (6, N'Harding', N'Melanie', N'mHarding@gmail.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (7, N'Nelson', N'Sam', N'sNelson@harvard.edu')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (8, N'Smith', N'Jason', N'jSmith405@yahoo.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (9, N'Simpson', N'Maggie', N'mSimpson@hotmail.com')
INSERT [dbo].[Customer] ([CustomerKey], [CustomerLastName], [CustomerFirstName], [CustomerEmail]) VALUES (10, N'Zilla ', N'God', N'godzilla@gmail.com')
SET IDENTITY_INSERT [dbo].[Customer] OFF
/****** Object:  Table [dbo].[Author]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Author](
 [AuthorKey] [int] IDENTITY(1,1) NOT NULL,
 [AuthorName] [nvarchar](50) NOT NULL,
 [AuthorEmail] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Author] PRIMARY KEY CLUSTERED 
(
 [AuthorKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Author] ON
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (1, N'Robert Jakobs', N'rj@hotmail.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (2, N'Linda Manning', N'linda@manning.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (3, N'Bradley Stevens', N'bradlys@yahoo.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (4, N'Mark Lewis', N'ml@Lewis.org')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (5, N'Tabitha King', N'King@gmail.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (6, N'Neil Hart', N'harttohart@msn.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (7, N'Melanie Dodge', N'melanie@gmail.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (8, N'Beth Charity', N'charity@yahoo.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (9, N'Gerald Norris', N'gnorris@hotmail.com')
INSERT [dbo].[Author] ([AuthorKey], [AuthorName], [AuthorEmail]) VALUES (10, N'Abby Kingston', N'ak@kingston.net')
SET IDENTITY_INSERT [dbo].[Author] OFF
/****** Object:  Table [dbo].[Sale]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sale](
 [SaleKey] [int] IDENTITY(1,1) NOT NULL,
 [SaleDate] [date] NULL,
 [CustomerKey] [int] NULL,
 CONSTRAINT [PK_Sale] PRIMARY KEY CLUSTERED 
(
 [SaleKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Sale] ON
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (1, CAST(0xEE320B00 AS Date), 1)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (2, CAST(0xEF320B00 AS Date), 2)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (3, CAST(0x20330B00 AS Date), 3)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (4, CAST(0x0C330B00 AS Date), 4)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (5, CAST(0x0F330B00 AS Date), 1)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (6, CAST(0x2C330B00 AS Date), 5)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (7, CAST(0x8A330B00 AS Date), 6)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (8, CAST(0x93330B00 AS Date), 3)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (9, CAST(0xDC330B00 AS Date), 7)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (10, CAST(0xF6330B00 AS Date), 9)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (11, CAST(0x3D340B00 AS Date), 10)
INSERT [dbo].[Sale] ([SaleKey], [SaleDate], [CustomerKey]) VALUES (12, CAST(0x3F340B00 AS Date), 3)
SET IDENTITY_INSERT [dbo].[Sale] OFF
/****** Object:  Table [dbo].[ProjectDetail]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProjectDetail](
 [ProjectDetailKey] [int] IDENTITY(1,1) NOT NULL,
 [ProjectKey] [int] NOT NULL,
 [ProjectTask] [nvarchar](50) NOT NULL,
 [EmployeeKey] [int] NOT NULL,
 [ProjectChargedAmount] [money] NULL,
 [Notes] [nvarchar](max) NULL,
 [ProjectDetailDate] [date] NULL,
 CONSTRAINT [PK_ProjectDetail] PRIMARY KEY CLUSTERED 
(
 [ProjectDetailKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[ProjectDetail] ON
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (1, 1, N'Initial Review and Contract', 1, 300.0000, N'lunch and contract', CAST(0xED300B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (3, 1, N'First outline', 2, 150.0000, N'reviewed outline with author', CAST(0x07310B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (4, 2, N'Conceptual meeting', 1, 200.0000, N'reviewed outline and concpt', CAST(0x64310B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (5, 4, N'Initial review', 1, 120.0000, NULL, CAST(0xCD320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (6, 5, N'Initial Review', 1, 130.0000, N'Included dinner', CAST(0xAB320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (7, 1, N'Design review', 3, 85.0000, N'Discuss design Options', CAST(0x59310B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (8, 2, N'Copy Editing', 2, 1200.0000, N'editing text', CAST(0x5F320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (9, 1, N'Copy Editing', 2, 500.0000, NULL, CAST(0x6F320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (10, 4, N'Design Review', 4, 120.0000, N'Reviewed Layout', CAST(0x91320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (11, 1, N'Sales Plan', 5, 100.0000, N'Discussed price and sales plan', CAST(0xB7320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (12, 5, N'Copy editing', 2, 400.0000, NULL, CAST(0xB9320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (13, 5, N'Design Review', 4, 450.0000, N'Included hotel', CAST(0xC6320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (14, 6, N'Initial Review', 1, 300.0000, NULL, CAST(0xC6320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (15, 7, N'Initial Review', 1, 250.0000, N'Lunch and contract', CAST(0xD2320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (16, 2, N'Design Review', 3, 450.0000, NULL, CAST(0xCD320B00 AS Date))
INSERT [dbo].[ProjectDetail] ([ProjectDetailKey], [ProjectKey], [ProjectTask], [EmployeeKey], [ProjectChargedAmount], [Notes], [ProjectDetailDate]) VALUES (17, 4, N'Sales Plan', 4, 200.0000, NULL, CAST(0xCE320B00 AS Date))
SET IDENTITY_INSERT [dbo].[ProjectDetail] OFF
/****** Object:  Table [dbo].[ProjectAuthor]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProjectAuthor](
 [AuthorKey] [int] NOT NULL,
 [ProjectKey] [int] NOT NULL,
 CONSTRAINT [PK_ProjectAuthor] PRIMARY KEY CLUSTERED 
(
 [AuthorKey] ASC,
 [ProjectKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (1, 1)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (2, 2)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (3, 2)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (4, 4)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (5, 4)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (6, 4)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (7, 5)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (8, 6)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (9, 7)
INSERT [dbo].[ProjectAuthor] ([AuthorKey], [ProjectKey]) VALUES (10, 7)
/****** Object:  Table [dbo].[EBook]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EBook](
 [EBookKey] [int] IDENTITY(1,1) NOT NULL,
 [EbookTitle] [nvarchar](255) NOT NULL,
 [EbookPrice] [money] NOT NULL,
 [EbookDescription] [nvarchar](255) NOT NULL,
 [ProjectKey] [int] NOT NULL,
 CONSTRAINT [PK_EBook] PRIMARY KEY CLUSTERED 
(
 [EBookKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[EBook] ON
INSERT [dbo].[EBook] ([EBookKey], [EbookTitle], [EbookPrice], [EbookDescription], [ProjectKey]) VALUES (1, N'Wordpress Made Easy', 33.5000, N'All you need to know to get started with word Press', 1)
INSERT [dbo].[EBook] ([EBookKey], [EbookTitle], [EbookPrice], [EbookDescription], [ProjectKey]) VALUES (2, N'Snacks for Gamers', 15.7000, N'How to keep from dying of malnutrition while beating Halo', 2)
INSERT [dbo].[EBook] ([EBookKey], [EbookTitle], [EbookPrice], [EbookDescription], [ProjectKey]) VALUES (3, N'SQL Server 2008 R2', 65.5000, N'A complete guide ', 4)
INSERT [dbo].[EBook] ([EBookKey], [EbookTitle], [EbookPrice], [EbookDescription], [ProjectKey]) VALUES (4, N'SQL', 35.7500, N'All the SQL you will ever need to know', 5)
SET IDENTITY_INSERT [dbo].[EBook] OFF
/****** Object:  Table [dbo].[SaleDetail]    Script Date: 02/12/2012 11:21:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SaleDetail](
 [SaleDetailKey] [int] IDENTITY(1,1) NOT NULL,
 [SaleKey] [int] NULL,
 [EbookKey] [int] NULL,
 [Quantity] [int] NULL,
 [Discount] [decimal](3, 2) NULL,
 CONSTRAINT [PK_SaleDetail] PRIMARY KEY CLUSTERED 
(
 [SaleDetailKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[SaleDetail] ON
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (1, 1, 1, 3, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (2, 2, 1, 1, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (3, 3, 1, 30, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (4, 4, 1, 5, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (5, 4, 2, 1, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (6, 5, 2, 1, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (7, 6, 1, 15, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (8, 7, 4, 1, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (9, 8, 4, 25, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (10, 8, 1, 20, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (11, 9, 2, 5, CAST(0.03 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (12, 9, 1, 1, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (15, 10, 4, 20, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (16, 10, 1, 20, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (17, 10, 2, 1, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (18, 11, 3, 2, NULL)
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (19, 12, 3, 30, CAST(0.05 AS Decimal(3, 2)))
INSERT [dbo].[SaleDetail] ([SaleDetailKey], [SaleKey], [EbookKey], [Quantity], [Discount]) VALUES (20, 12, 1, 25, CAST(0.05 AS Decimal(3, 2)))
SET IDENTITY_INSERT [dbo].[SaleDetail] OFF
/****** Object:  ForeignKey [FK_EBook_Project]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[EBook]  WITH CHECK ADD  CONSTRAINT [FK_EBook_Project] FOREIGN KEY([ProjectKey])
REFERENCES [dbo].[Project] ([ProjectKEy])
GO
ALTER TABLE [dbo].[EBook] CHECK CONSTRAINT [FK_EBook_Project]
GO
/****** Object:  ForeignKey [FK_ProjectAuthor_Author]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[ProjectAuthor]  WITH CHECK ADD  CONSTRAINT [FK_ProjectAuthor_Author] FOREIGN KEY([AuthorKey])
REFERENCES [dbo].[Author] ([AuthorKey])
GO
ALTER TABLE [dbo].[ProjectAuthor] CHECK CONSTRAINT [FK_ProjectAuthor_Author]
GO
/****** Object:  ForeignKey [FK_ProjectAuthor_Project]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[ProjectAuthor]  WITH CHECK ADD  CONSTRAINT [FK_ProjectAuthor_Project] FOREIGN KEY([ProjectKey])
REFERENCES [dbo].[Project] ([ProjectKEy])
GO
ALTER TABLE [dbo].[ProjectAuthor] CHECK CONSTRAINT [FK_ProjectAuthor_Project]
GO
/****** Object:  ForeignKey [FK_ProjectDetail_Employee]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[ProjectDetail]  WITH CHECK ADD  CONSTRAINT [FK_ProjectDetail_Employee] FOREIGN KEY([EmployeeKey])
REFERENCES [dbo].[Employee] ([EmployeeKey])
GO
ALTER TABLE [dbo].[ProjectDetail] CHECK CONSTRAINT [FK_ProjectDetail_Employee]
GO
/****** Object:  ForeignKey [FK_ProjectDetail_Project]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[ProjectDetail]  WITH CHECK ADD  CONSTRAINT [FK_ProjectDetail_Project] FOREIGN KEY([ProjectKey])
REFERENCES [dbo].[Project] ([ProjectKEy])
GO
ALTER TABLE [dbo].[ProjectDetail] CHECK CONSTRAINT [FK_ProjectDetail_Project]
GO
/****** Object:  ForeignKey [FK_Sale_Customer]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[Sale]  WITH CHECK ADD  CONSTRAINT [FK_Sale_Customer] FOREIGN KEY([CustomerKey])
REFERENCES [dbo].[Customer] ([CustomerKey])
GO
ALTER TABLE [dbo].[Sale] CHECK CONSTRAINT [FK_Sale_Customer]
GO
/****** Object:  ForeignKey [FK_SaleDetail_EBook]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[SaleDetail]  WITH CHECK ADD  CONSTRAINT [FK_SaleDetail_EBook] FOREIGN KEY([EbookKey])
REFERENCES [dbo].[EBook] ([EBookKey])
GO
ALTER TABLE [dbo].[SaleDetail] CHECK CONSTRAINT [FK_SaleDetail_EBook]
GO
/****** Object:  ForeignKey [FK_SaleDetail_Sale]    Script Date: 02/12/2012 11:21:24 ******/
ALTER TABLE [dbo].[SaleDetail]  WITH CHECK ADD  CONSTRAINT [FK_SaleDetail_Sale] FOREIGN KEY([SaleKey])
REFERENCES [dbo].[Sale] ([SaleKey])
GO
ALTER TABLE [dbo].[SaleDetail] CHECK CONSTRAINT [FK_SaleDetail_Sale]
GO

The questions

Create a view that shows the ebook title, its author(s) and its price.

What was the total cost of producing the book Wordpess made easy?"

What, if any, royalties are due the author Robert Jacobs? Royalties are based on the author's percent of sales, but all advances must be paid back before they receive any additional money). (

What is the average time in months for a project from start date to completion?

Are there any customers who have never purchased a book? If there are, delete that customer

Increase the price of the ebook "Snacks for Gamers" by 3%.

How many copies of the ebook "SQL Server 2008 R2" have been sold?

What is the average charge for services by the editorial staff?

what is the total charged by each editor?

Which employees have charged more than 1000 dollars total?

Add a new customer and a purchase to the database.

Create a function that can be used to determine the total amount for a sale detail.

Create a stored procedure that takes the sale key for a parameter and returns a reciept with the sale information, the details and totals.

It is a business rule of the database that any sale item with a quantity of 15 or above gets a 5% discount. Create a trigger to enforce this.

add a table that is a child to project. Its purpose is to record meetings among the staff concerning project status. The table should have an identity for a key, a date and a topic line, and an xml column with this structure. Below is an example of the xml document and a schema for it. Before creating the table create a new schema collection to validate the xml field.

The xml document


<?xml version="1.0" encoding="utf-8"?>
<meeting xmlns="http://www.BitbyBitEbooks.com/meeting">
 <head>
  <present>Brown</present>
  <present>Garner</present>
  <present>Peterson</present>
 </head>
 <body>
  <discussion>
   The book has a lot of grammatical and writing errors. 
   It is going to take work and time to clear them
   up.
  </discussion>
  <issues>
   <issue>Grammatical Errors</issue>
   <issue>timeLine</issue>
  </issues>
  <tasks>
   <task>contact author</task>
   <task>Revise timeline</task>
  </tasks>
 </body>
 
</meeting>

The schema


<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" 
elementFormDefault="qualified" 
targetNamespace="http://www.BitbyBitEbooks.com/meeting" 
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="meeting">
<xs:complexType>
<xs:sequence>
<xs:element name="head">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" 
name="present" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="body">
<xs:complexType>
<xs:sequence>
<xs:element name="discussion" type="xs:string" />
<xs:element name="issues">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="issue" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tasks">
<xs:complexType>
<xs:sequence>
<xs:element maxOccurs="unbounded" name="task" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Make a login and role for authors.

Create an Author role. authors should be able see projects, but not project details. They should be able to see the list of ebooks, and sale and sale detail information. But they shouldn't be able to add or change anything. Add the author user to the role.

What I am looking for

The project is worth 50 points. I want to see the SQL that would answer the question or complete the request(as in stored procedures and functions.) There are about 20 separate tasks, so each task is worth about 2 points with 10 points assigned to the more difficult tasks such as the stored procedure and trigger.

the questions do no have to be done in the order listed. Just let me know which one the code is for.

p>If you worked on this as a group, you only need to turn in one copy for the whole group. Just be sure to include all the names on the document.

To turn in

as always paste all the code and questions into a Google doc and share it with spconger@gmail.com

Assignment 12

2012-02-11T15:12:00.000-08:00

Creating Logins, Users and roles

This is fairly simple

1. Create a new login called CustLogin which has a password of "P@ssw0rd1" and the default database "Automart."

2. Create a new User that uses the login CustLogin called CustUser with a default schema of Customer

3. Create a role called CustomerRole.

4. Grant select on the Customer schema to the role Customer Role

5. Use the stored procedure to add the user CustUser to the Role Customer

You should try to log on as the new user and see if everything is working as it should. You should only be able to see those tables and objects that belong to the customer schema. You should only be able to select, not insert update or delete

What I am looking for

Each step is worth 2 points for a total of 10

What to turn in

copy the code into a Google doc and share it with spconger@gmail.com

Assignment 11

2012-02-11T13:32:00.000-08:00

Xml

Outputting data as XML

1. Out put person as xml raw as elements with a root of 'People'

2. Do an inner join bwtween Person and employee and output the resultsas xml auto with a root element of "Employees"

Querying XML

3. Select all the fields from the Customer.Autoservice table. Use the xml query() method on the Service description to only return the contents of the description element. Don't forget to account for the namespace.

XML Schema and XML data type

4. Alter the table InspectionDetail that we created in an earlier assignment and drop the xml column Description.

5. Create a new xml schema collection called "DescriptionSchema" using the following schema:


<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" 
 elementFormDefault="qualified" 
 targetNamespace="http://www.automart.com/inspectionDescription" 
 xmlns:xs="http://www.w3.org/2001/XMLSchema">
 <xs:element name="inspectiondescription">
   <xs:complexType>
     <xs:sequence>
  <xs:element name="issue" type="xs:string" />
  <xs:element name="details">
  <xs:complexType>
  <xs:sequence>
  <xs:element maxOccurs="unbounded" 
   name="detail" 
   type="xs:string" />
  </xs:sequence>
  </xs:complexType>
  </xs:element>
         </xs:sequence>
    </xs:complexType>
 </xs:element>
</xs:schema>

6. Now alter the table again, to add the xml column back in, but with schema added:


 Description xml (DescriptionSchema),

7. Insert an new record into the inspection and then the inspectionDetail. You can make up the values, but for the column description enter the following xml:


<?xml version="1.0" encoding="utf-8"?>
<inspectiondescription 
xmlns="http://www.automart.com/inspectionDescription" >
 <issue>
  cleanliness of the work area
 </issue>
 <details>
  <detail>discarded oil rags on counter</detail>
  <detail>Open pan of used oil left 
beside pit where it could be spilled</detail>
  <detail>Tools not cleaned immediately after use</detail>
 </details>
 
</inspectiondescription>

What I am looking for

1-5 are worth 1 point each, 6 is worth 3 and 7 is worth 2 for a total of 10

To Turn in

copy all the code to a google doc and share with spconger@gmail.com

Assignment 10

2012-02-11T12:42:00.000-08:00

More Stored Procedures and Triggers

Stored Procedure

Create a stored procedure to add a new customer. To do this add person, vehice and registerd customer info. First check to maks sure the customer does not already exist. If they do just print out a message saying they already exist; If they don't exist insert into all the tables necessary. Put the inserts in a transaction and a try catch. You want all the inserts to happen or none of them.

Remember you will need to find the newly generated person key. You can use @@identity or IDENT_Current to find it.

The procedure will create a temporary password that uses the first letter of the first name, the whole last name, and the first 3 characters of their vehicle License number. If you feel clever you can seperate this into a function and then call the function in the stored procedure

Use the procedure to enter a customer

Try Entering the same customer. You should get the message that the customer exists

Trigger

Create a trigger for insert on the table RegisteredCustomer. If a customer rates the service at 2 or less, copy the record to a table called "Problem". This table should have the same structure as the CustomerSurvey table. The trigger should check to make sure the customer survey table exists. If it doesn't it should create it.

Enter a survey record with a rating of 1 and see if the trigger works. Also enter one with a rating of 3 to make sure that it isn't written to the problem table.

What I am Looking for

The stored procedure code will be worth 5 points
1 point for checking to see if the customer exists
1 point for creating a transactions
1 point for inserting the records
2 points for creating the temporary password

The trigger will also be worth 5 points
1 point for checking that the table exists
1 point for creating the table
1 point for checking the value of the rating
1 point for copying the results to the new table
1 point for a working trigger

To Turn in

Copy the code for the trigger and the stored procedure into a google doc and share with spconger@gmail.com

My Version of the Calculator

2012-02-10T15:20:00.001-08:00

Here is my version of the calculator. I am only including the C# code. It is fully functional.


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

/***********************************
 * This is a fully functional version of the calculator
 * the key to completing this is to spend some time
 * prior to actully coding. Think about what a calculator
 * actually does when you click a number, when you
 * click an operator, etc. 
 * Steve Conger February 2012
 * ********************************************/

public partial class _Default : System.Web.UI.Page
{
   

    protected void Page_Load(object sender, EventArgs e)
    {
       
       
    }
    protected void number_click(object sender, EventArgs e)
    {
        //all the number buttons and the decimal 
        //share this event. 
        //first we figure out which button was clicked
        //and then we add it to the text box
        Button b = (Button)sender;
        TextBox1.Text += b.Text;
    }
    protected void operator_click(object sender, EventArgs e)
    {
        //all the operators except the equal sign
        //share this event
        Button b = (Button)sender;
        //we get the operator from the button text
        //and write it to a session variable
        string op = b.Text;
        Session["Operator"] = op;
        //we call the DoCalculation Method
        DoCalculation();
            
    }


    protected void equal_click(object sender, EventArgs e)
    {
        //first I check that the session variable is not null
        if (Session["Result"] != null)
        {
            //we call DoCalculation method to process the number
            //still in the textbox
            DoCalculation();
            //we display the answer in the textbox
            TextBox1.Text = Session["Result"].ToString();
            //we clear the session variable
            //this took me awhile to figure out, but it is key
            //to the calculator behaving properly.
            Session["Result"] = null;

            
        }
    }
    protected void Clear_click(object sender, EventArgs e)
    {
        //this event clears the textbox and
        //resets the session
        TextBox1.Text = "";
        Session["Result"] = null;
    }

    protected void DoCalculation()
    {
        //this method handles all the calcualtions and 
        //and stores them in the session variable
        double number;

        //first we get the current operator
        //I maybe should check to make sure it is not null,
        string op = Session["Operator"].ToString();
        
        //Then we get the number from the text box
        bool isDouble = double.TryParse(TextBox1.Text, out number);
        if (isDouble)
        {
            //if it is the first number we just assign
            //it to the session variable
            if (Session["Result"] == null)
            {
                Session["Result"] = number;
               

            }
            else
            {
                //so if it isn't the first number
                //do the math and assign the result
                //to the Session variable
                double number1 = (double)Session["Result"];
                switch (op)
                {
                    case "+":
                        Session["Result"] = number1 + number;
                        break;
                    case "-":
                        Session["Result"] = number1 - number;
                        break;
                    case "*":
                        Session["Result"] = number1 * number;
                        break;
                    case "/":
                        Session["Result"] = number1 / number;
                        break;
                }
            }
        }
        //clear the text box
        TextBox1.Text = "";

    }
}

Assignment 9

2012-02-08T11:54:00.000-08:00

Functions

We are going to create just one function. The purpose of the function is to total the cost of each service provided for a car. This has to take into account the price of the service, the discount amount and the tax amount. Here are a couple of queries that use the function. You can use these to test the function



Select ServicePrice, vs.VehicleServiceID, VehicleID, DiscountPercent,
TaxPercent, dbo.fx_TotalDue(ServicePrice, DiscountPercent, TaxPercent) as Total
From Employee.VehicleServiceDetail vsd
inner Join Employee.VehicleService vs
on vsd.VehicleServiceID=vs.VehicleServiceID
inner join Customer.AutoService a
on a.AutoServiceID=vsd.AutoServiceID

Select SUM( dbo.fx_TotalDue(ServicePrice, DiscountPercent, TaxPercent)) as Total
From Employee.VehicleServiceDetail vsd
inner Join Employee.VehicleService vs
on vsd.VehicleServiceID=vs.VehicleServiceID
inner join Customer.AutoService a
on a.AutoServiceID=vsd.AutoServiceID
Where vsd.VehicleServiceID=4

Simple Stored procedures

In a sense this is just redoing the views to add a parameter.

Make a stored procedure that returns the employee information. It will take the parameter @Locationname

Make one that returns all the names, vehicle information and email for registered customers. It will take a parameter of @VehicleLicense

Assignment 8

2012-02-08T10:38:00.000-08:00

Views

1. Create a view that shows Employee information. The view should include the employee's first name, last name, hire date and location name. You should alias each column.

2. Create a view that shows all the information about a registered customer. It should include their name, their vehicle licenses and makes and their email.

Indexes

3. Create a non clustered index on LastName in Person

4. Create a non clustered index on the License number in Vehicle

5. Create a non clustered index on AutoServiceID in VehicleServiceDetail

6. Create a non clustered index on ServiceDate in VehicleService

DVD Diagram

2012-02-07T15:09:00.000-08:00

Shorthand for Normalization

These three rules will get you through most of database design

1. Every table should be only about one thing. Split out every separate topic into its own entity

2. any multivalued attributes should be removed to their own entity

3. Whenever you have a many to many relationship you must resolve the relationship into two one to many relationships by adding a linking table

Here is the diagram for the DVD we did in class. Click on it to get a larger image.

LINQ

2012-02-07T12:21:00.000-08:00

I will add to this in the near future and provide the stepswe took in SQL Server and the link designer

for now here is the LINQ code


 protected void Button1_Click(object sender, EventArgs e)
 {
   AutomartDataClassesDataContext dc = new AutomartDataClassesDataContext();
   var ourCustomers = from c in dc.RegisteredCustomers
                      orderby c.Person.LastName
                      where c.Person.LastName=="Anderson"
                      select new {c.Person.LastName, 
                            c.Person.FirstName,c.Email};

    GridView1.DataSource = ourCustomers.ToList();
    GridView1.DataBind();
 }

Creating and altering Tables

2012-02-06T11:54:00.002-08:00


--Creating and altering tables
use master
go
Create database grading

use grading

Create Table Student
(
   StudentID nchar(12) primary key,
   StudentLastName nvarchar(255),
   StudentFirstName nvarchar(255)
)

Create Table Course
(
    CourseNumber nchar(7),
 CourseName nvarchar(255) not null,
 CourseCredits int not null,
 Constraint pk_Course Primary Key (CourseNumber)
 
)


Create Table Section
(
   SectionNumber nchar(4) not null,
   CourseNumber nchar(7) Foreign Key 
   References Course(CourseNumber),
 SectionQuarter nvarchar(7) not null,
 SectionYear char(4) not null
)

Drop Table Section

alter Table Section
Add Constraint Pk_Section Primary Key(SectionNumber)

Create Table Roster
(
 RosterID int identity(1,1),
 StudentID nchar(12),
 SectionNumber nchar(4),
 Grade Decimal(3,2),
 Notes xml,
 Constraint pk_Roster primary key(RosterID),
 Constraint FK_Student Foreign key (StudentID)
  References Student(StudentID)

)

Alter Table Roster
Add constraint FK_Section Foreign Key(SectionNumber)
References Section(SectionNumber)

Alter Table Roster
Add Constraint Ck_Grade Check(Grade between 0 and 4)

Alter Table Section
Add Constraint ch_Quarter 
Check (SectionQuarter in ('Fall', 'Winter', 'Spring', 'Summer'))

Insert into Student(StudentID, StudentLastName, StudentFirstName)
Values('919-00-9876','Smith','John')

Insert into Course(CourseNumber, CourseName, CourseCredits)
Values('ITC222','SQL',5)

Insert into Section(SectionNumber, CourseNumber, 
SectionQuarter, SectionYear)
Values('3208','ITC222','Winter','2012')

--these will cause errors because of the check constraints
Insert into Section(SectionNumber, CourseNumber, 
SectionQuarter, SectionYear)
Values('3209','ITC222','Jan','2012')

Insert into Roster(StudentID, SectionNumber, Grade, Notes)
Values ('919-00-9876','3208',5,null)

Create Table Student
(
   StudentKey int identity(1,1) primary key,
   StudentID nchar(12) unique
)

2012-02-01T14:02:00.000-08:00

Here are a couple of examples of use case written documentation. These are from a program and database I wrote to track short term certificates

Here is the use Case diagram. The documentation is below:

Enter Certificate Information Use Case

Trigger:

First use of database-- adding new Certificate

Steps:

1. Enter Certificates into database (through Form)

2. Enter Courses required for certificate

a. Select course from course table

b. add foreign key to Certificate Course table

3. Review and confirm

Terminal Condition:

List of certificates with required courses in database

List Students Getting Certificates Use Case

Precondition:

Students and grades imported into database

Trigger:

Quarterly Report on Certificate completions

Constraints:

Must have a 2.0 or greater grade point average (or cert specific average)

Steps:

1. Run query for each which students have taken all the courses for one certificate (Each certificate will have to be queries separately)

2. Average the grades of all the students who have completed the certificate

3. Select only those who have an average greater than 2.0

4. Write them into a Certificates received (or temp?) table

5. Run the queries again for each possible certificate

6. Summarize the results of all queries in a report (from the Certificates Received table)

Terminal Condition:

Quarterly report of Certificates completed for given quarter

Assignment 4 Notes

2012-02-01T12:08:00.000-08:00

It is not possible to assign the results of the web Service method directly to the DataSet, (though I swear I did this when I previewed the assignment some months ago.) It must be read as an XML file and then loaded into the DataSet. Here is a bit of code for that. Then you can bind the DataSet to the GridView


XmlNode node = zip.GetInfoByCity(txtCity.Text);
DataSet ds = new DataSet();
XmlNodeReader reader = new XmlNodeReader(node);
           
ds.ReadXml(reader);

Insert Update Delete

2012-02-01T11:48:00.001-08:00


--inserts, updates and deletes
Use CommunityAssist 
Insert into Person (LastName, FirstName)
Values('Smith', 'John'),
('Doe', 'Jane')

Select * from Person

Use Master
Drop table Employee.VehicleService

Create table Person2
(
FirstName nvarchar(255),
LastName Nvarchar(255)
)

--bulk insert of sorts
Insert into Person2(FirstName, LastName)
Select FirstName, LastName From Person

Select * From Person2

--creating a temporary table
Select LastName, Firstname
into #SpecialPeople
From Person

Select * From #SpecialPeople

--update with multiple fields an 
--update should always 
--have a where clause
update Person2
Set LastName='Anders',
Firstname='bob'
Where LastName='Anderson'
And FirstName='Jay'

Select * From Person2
Drop table Person2

--explicitly using a transaction
--can give you an undo
Begin transaction

--This turns everyone's name the same
Update Person2
Set Firstname='Bob'
Where LastName='zimmerman'

Select * From Person2

Rollback tran-- will undo all transactions\
--since the begin
Commit Tran -- will commit the transaction
--to the database


Use MagazineSubscription

Select * From magazineDetail

--increase all the prices by 20%
Update MagazineDetail
Set SubscriptionPrice=SubscriptionPrice * 1.2

-- Deletions
--can't delete records that
--have child records
Use CommunityAssist
Begin Tran
Delete From Person
Where PersonKey > 51

Select * From Person
Rollback tran
Commit tran
--removes all rows because no
--related records in a child table
Delete from Person2

--does the same as delete
--but more efficient
--doesn't do it row by row
Truncate table Person2

Select * From Person2

--get table information
exec sp_help PersonAddress

--system views
Select * from sys.Databases

Select name from sys.Tables

Select name from sys.procedures

Select * From Sys.columns

Dentist Appointment ERD

2012-01-31T14:59:00.000-08:00

Here is the ERD (Entity Relation Diagrom) for the Dentist office we did in class:

SubQueries

2012-01-30T11:23:00.000-08:00



Use MagazineSubscription

Select MagID From MagazineDetail
Where SubscriptionPrice = 
(Select MAX(SubscriptionPrice) From MagazineDetail)

Select MagID, SubscriptionPrice, 
(Select AVG(SubscriptionPrice) From MagazineDetail) as Average
From MagazineDetail
Where SubscriptionPrice >
(Select AVG(SubscriptionPrice) From MagazineDetail)

Insert into Customer(CustLastName, CustFirstName, 
CustAddress, CustCity, CustState, CustZipcode, CustPhone)
Values('John', 'Larry', '100 somewhere st','Seattle','Wa','98000',null)

Select CustID, CustLastName, CustFirstName
From Customer
Where CustID Not in (Select CustID from Subscription)

Select MagName 
 From Magazine
 Where MagID not in 
 (Select MagID 
  from MagazineDetail
  Where MagDetID in
  (Select MagDetID 
   from Subscription))
     
                  Select MagID 
      from MagazineDetail
   Where exists
   (Select MagDetID 
    from Subscription
    where SubscriptionPrice > 100)
     
Select MagdetID, SubscriptionPrice
From MagazineDetail
Where SubscriptionPrice >= all
(Select SubscriptionPrice
From MagazineDetail)

--any says that the subcription price must be
--greater than any one of the other prices
--the effect is to return all but the smallest price
Select MagdetID, SubscriptionPrice
From MagazineDetail
Where SubscriptionPrice > any
(Select SubscriptionPrice
From MagazineDetail)

Select SubscriptTypeID, AVG(SubscriptionPrice) as Average
From MagazineDetail
Group by SubscriptTypeID

--this is a correlated subquery
--that means the subquery is dependent
--on a value from the main query
--for its completion
--it is equivalent to a recursive function
--in programming
--Note that like a self join the same table
--is aliased with two different aliases
--treating it like two tables
Select md.SubscriptTypeID, MagDetID, SubscriptionPrice
From magazineDetail md
Where SubscriptionPrice >=
(Select AVG(SubscriptionPrice)
From magazinedetail amd
where md.SubscripttypeID = amd.SubscripttypeID)

Select * from SubscriptionType

--exists returns a boolean does it exist
--in the subset or not
--a bit more efficient than in
Select Magname
From Magazine
Where Exists
(Select MagID
from MagazineDetail
Where SubscriptTypeID=5)

Use CommunityAssist
Select Distinct (Select MAX(hireDate) from Employee) as "Newest", 
(Select MIN(HireDate) From Employee) as "Oldest",
DateDiff(yy,  (Select MIN(HireDate) From Employee),
(Select MAX(hireDate) from Employee) ) as "Range"
From Employee

ITC 222 Assignment 7

2012-01-27T11:01:00.000-08:00

Creating and altering tables

Automart has decided to implement a new inspection process where they go to each location at random times. They want to add the results of these inspections to the database. This involves adding three tables. One look up table that contains the various types of infractions or problems. One for the inspection date and location and another for the details of each inspection

The Problems

Create the following tables. Each table should be in the Schema "Employee".

InspectionCategory

It will contain the column CategoryID which will be an identity starting at 1 and incrementing by ones. This column will also be the primary key. The next column will be CategoryName which will provide the descriptive name of the category such as "cleanliness" or " waiting area" etc.

Inspection

This table will contain an InspectionID which is the primary key and and identity starting with 1 and incrementing by 1s. It will contain an InspectionDate and a LocationID which is a foreign key relating to the table location.

Inspection Detail

This table will contain the columns InspectionDetailID, an Identity and primary key, InspectionID, a foreign key, CategoryID a foreign key related to InspectionCategory and a Description column which will contain xml.

We also are going to make some changes to existing tables

Alter the Customer.RegisteredCustomer table to make emails unique. Do the same for passwords.

Also the CustomerSurvey table has check constraint on the column "rating" that limits it to a number between 1 and 10. The constraint name is CK__CustomerS__Ratin__25869641. Drop it and add a new constraint that limits it to numbers between 1 and 5.

We are also going to correct a mistake in the current database. The vehicleID in Employee.VehicleService should be a foreign key related to the VehicleID in Customer.Vehicle. Add the Foreign Key constraint to correct this oversite.

What I am looking for

I want to see the code for the three tables and the alter tables. I am especially looking at the primary key and foreign key constraints for those tables

Calculator Examples

2012-01-27T09:42:00.000-08:00

I am posting two examples of Calculator code that work. They both have different but effective approaches. The first is From Victoria Bailey. I have only included the code from the form.

Victoria's only works with binary operations, that is [number] [operator] [number], for example 4 + 2, 3 * 5, etc. It doesn't work with examples like 4 + 3 * 2 / 2. Christian's does


Default.aspx
   <form id="form1" runat="server">
    <div>
    
        <asp:Label ID="lblScreen" runat="server" Text=""></asp:Label><br />
        <asp:Button ID="Button1" runat="server" Text="1"  
onclick="btnNumber_Click" /><asp:Button ID="Button2"
runat="server" Text="2" onclick="btnNumber_Click" /> 
<asp:Button ID="Button3" runat="server" Text="3" onclick="btnNumber_Click" /><br />
        <asp:Button ID="Button4" runat="server" 
Text="4" onclick="btnNumber_Click" /><asp:Button ID="Button5"
            runat="server" Text="5" onclick="btnNumber_Click" />
<asp:Button ID="Button6" runat="server" Text="6" onclick="btnNumber_Click" /><br />
        <asp:Button ID="Button7" runat="server" 
Text="7" onclick="btnNumber_Click" /><asp:Button ID="Button8"
            runat="server" Text="8" 
onclick="btnNumber_Click" />
<asp:Button ID="Button9" runat="server" Text="9" 
onclick="btnNumber_Click" /><br />
        <asp:Button ID="Button10" runat="server" Text="0" 
onclick="btnNumber_Click" /><br />
        <asp:Button ID="Button11" runat="server" Text="+" 
onclick="btnOperation_Click" />
        <asp:Button ID="Button12" runat="server" Text="-" 
onclick="btnOperation_Click" />
        <asp:Button ID="Button13" runat="server" Text="*" 
onclick="btnOperation_Click" />
        <asp:Button ID="Button14" runat="server" Text="/" 
onclick="btnOperation_Click" />
        <br /><br />

        <asp:Button ID="btnCalculate"
            runat="server" Text="Calculate" onclick="btnCalculate_Click" /><br /><br />
        <asp:Label ID="lblAnswer" runat="server" Text="Answer: "></asp:Label>
        <asp:Label ID="lblCalculation" runat="server" Text=""></asp:Label><br /><br />

    </div>
    </form>



Code Behind:
    protected void Page_Load(object sender, EventArgs e)
    {
    }


    protected void btnCalculate_Click(object sender, EventArgs e)
    {
        string op = Session["operation"].ToString();
        double number = 0;
        double secondNumber = 0;
        double total = 0;
        if (lblScreen.Text != String.Empty)
        {
            secondNumber = double.Parse(lblScreen.Text);
        }
        if ((Session["firstNumber"] != null) && (Session["firstNumber"].ToString() != ""))
        {
            number = double.Parse(Session["firstNumber"].ToString());
        }
        switch (op)
        {
            case "+":
                total = number + secondNumber;
                break;
            case "-":
                total = number - secondNumber;
                break;
            case "*":
                total = number * secondNumber;
                break;
            case "/":
                total = number / secondNumber;
                break;
            default:
                break;
        }
        lblCalculation.Text = total.ToString();
    }

    protected void btnNumber_Click(object sender, EventArgs e)
    {
        Button button = (Button)sender;
        lblScreen.Text += button.Text;
    }

    protected void btnOperation_Click(object sender, EventArgs e)
    {
        Session["firstNumber"] = lblScreen.Text;
        Button button = (Button)sender;
        Session["operation"] = button.Text;
        lblScreen.Text = String.Empty;
    }

The second example is from Christian Roehr. It uses a very different approach. It is also well commented. Again I have only included the source from the form



>
 <form id="form1" runat="server">
 <div>
 <table>
 <tbody>

 <tr>
 <td colspan="4"></td>
     <asp:TextBox ID="txtDisplay" runat="server"></asp:TextBox>
 </tr>

 <tr>
 <td>
     <asp:Button ID="Button1" runat="server" Text="7" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="Button2" runat="server" Text="8" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="Button3" runat="server" Text="9" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="btnAdd" runat="server" Text="+" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>   
 </tr>

 <tr>
 <td>
     <asp:Button ID="Button5" runat="server" Text="4" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="Button6" runat="server" Text="5" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="Button7" runat="server" Text="6"
 CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="btnSubtract" runat="server" Text="-" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>   
 </tr>

 <tr>
 <td>
     <asp:Button ID="Button9" runat="server" Text="1" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="Button10" runat="server" Text="2" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="Button11" runat="server" Text="3" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="btnMult" runat="server" Text="*" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>  
 </tr>

 <tr>
 <td>
     <asp:Button ID="btnDel" runat="server" Text="Del" ToolTip="Use the <Del> button to clear the textbox in order to correct a value before clicking one of the operator buttons. The intermediate result and last operator are still kept in memory." CssClass="buttonstyle"
         onclick="btnDel_Click"/></td>
 <td>
     <asp:Button ID="Button14" runat="server" Text="0" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="Button15" runat="server" Text="." 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
 <td>
     <asp:Button ID="btnDiv" runat="server" Text="/" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>    
 </tr>

 <tr>
 <td>
     <asp:Button ID="btnClear" runat="server" Text="CL" ToolTip="Use the <CL> button to reset the calculator to its original state. Any prior values or operators are lost." CssClass="buttonstyle" OnClick="btnCl_Click"/></td>  
 <td colspan="3">
     <asp:Button ID="btnEqual" runat="server" Text="="  CssClass="buttonstyle" OnClick="Operator_Click"/></td>    
 </tr>  


 </tbody>
    
 </table>
 </div>
 </form>
</body>
</html>

======================== default.aspx.cs
using System;
using System.Diagnostics; // needed for "Debug" class
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
 // define unique integers to identify one of
 // {+,-,*,/,=}
 protected enum OperatorTypes
 {
     UNKNOWN=0,
     ADD = 1,
     SUBTRACT = 2,
     MULT = 3,
     DIVIDE = 4,
     EQUALS = 5
 };
 protected const double m_initialValue = 0.0;
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack) // wonna do it when page loads but not every time when we push a button
     {
         InitializeCalculator();
     }
 }
 protected void InitializeCalculator()
 {
     // START: define the session variables
     //
     // Here is why the operator is initially "+".
     // When the user clicks any operator
     // op_new = one of {+,-,*,/,=}
     // then the evaluation of the
     // _previous_ operator (op_prev ) happens and _not_ the one that was just clicked (op_new).
     // Thus, if we want everything to work the same and if we want to save ourselves
     // too much extra specialized initialization-specific code, we can just assume that
     // the very first op_prev was "+" and that the previous result (result_prev) was 0.0.
     // Then , when op_new is clicked, we evaluate
     // result_new = execute(result_prev, op_prev, number);
     // Where "number" is the number the user typed in prior to pressing op_new. "number"
     // got parsed right when we clicked op_new.
     // We could just as well have selected Session["result"] = 1.0 and Session["operator"] = "*"
     // but "+" is simpler and somehow cleaner, avoiding possible rounding errors.
     //
     // In any future discussion, i will call the session variables
     // the "stack", since that is what we kind of do when we
     // store the value on the server side and update it or retrieve it.
     Session["result"] = m_initialValue; // this writes it to the server and gives it a value of 0.0
     Session["operator"] = OperatorTypes.ADD;

     // END: define the session variables

     // in order to facilitate the very first parsing of a number
     // down the line, let's put a "0" into the text field.
     // That is how most calculators work and it also
     // puts it in sync with what is in our initial session "result" value.
     InitializeTextDisplay();
 }
 protected void InitializeTextDisplay()
 {
     txtDisplay.Text = m_initialValue.ToString();
 }
 protected void EmptyTextDisplayIfContainsInitialValue()
 {
     if (txtDisplay.Text == m_initialValue.ToString())
     {
         txtDisplay.Text = "";
     }
 }
 protected void InputNumber_Click(object sender, EventArgs e)
 {
     // avoid this scenario from happening:
     // after entering a number, get something like 06, 0555, 000, 0024
     // We dont want such numbers since they may not be parsable, or even if
     // they are, they dont look pretty.
     EmptyTextDisplayIfContainsInitialValue();

     // the button that is sending the message
     Button b = (Button)sender;
     txtDisplay.Text += b.Text;

 }
 protected void Operator_Click(object sender, EventArgs e)
 {
     // the button that is sending the message
     Button b = (Button)sender;
     // we could use the ID or we could use the text

     // START: determine which operator was clicked
     //
     // FYI: Equals() operator more optimized to work with strings, but could have done '==' too
     //
     OperatorTypes op_new = OperatorTypes.UNKNOWN;
     if (b.ID.Equals("btnAdd"))
     {
         op_new = OperatorTypes.ADD;
     }
     else if (b.ID.Equals("btnSubtract"))
     {
         op_new = OperatorTypes.SUBTRACT;
     }
     else if (b.ID.Equals("btnMult"))
     {
         op_new = OperatorTypes.MULT;
     }
     else if (b.ID.Equals("btnDiv"))
     {
         op_new = OperatorTypes.DIVIDE;
     }
     else if (b.ID.Equals("btnEqual"))
     {
         op_new = OperatorTypes.EQUALS;
     }
     else
     {
         // this should not happen anyways if we wrote
         // the code correctly.
         op_new = OperatorTypes.UNKNOWN;
     }

     // for debugging only
     Debug.Write(String.Format("op_new={0}\n", (int)op_new));

     if (op_new == OperatorTypes.UNKNOWN)
     {
         Exception ex = new Exception("Invalid operator");
         throw ex;
     }

     // END: determine which operator was clicked

     // 1. Parse the number which user had entered up to
     // the point of clicking one of the operator buttons.
     double operandNumber = GetNumber();

     // 2. Get the last result from the stack.
     double result_prev = (double)Session["result"];

     // 3. Get the operator from the stack.
     // This operator is _not_ the one we just got, but the one
     // entered before user entered <operandNumber>
     OperatorTypes op_prev = (OperatorTypes)Session["operator"];
     Debug.WriteLine("op_prev={0}\n", (int)op_prev);

     // 4. evaluate the new result based
     // on <result_prev>, <op_prev>, <operandNumber>
     // For instance, if op_prev is "*" (multiplication), then
     //
     // result_new = result_prev * operandNumber
     double result_new = ExecuteOperator(result_prev, op_prev, operandNumber);
     Debug.WriteLine("result_new={0}\n", result_new);

     // test if the number is wellformed. That can be for one of the following reasons
     // a) divide-by-zero
     // b) overflow (two very large numbers multiplied or a very small one in the denominator)
     // c) perhaps some other reason
     if (double.IsInfinity(result_new) || double.IsNaN(result_new))
     {
         // first reset the calculator since you cannot utilize the result for any future operation
         InitializeCalculator();

         // throw an exception
         string numberString = string.Format("resulting number = {0} .", result_new);
         Exception ex = new Exception(numberString+ "You either divided by zero or the operands resulted in an out-of-range number");
         throw ex;
     }




     // 5. put new result on the stack
     Session["result"] = result_new;

     // 6. put new operator on the stack
     Session["operator"] = op_new;

     // 7. display the new result
     if (op_new == OperatorTypes.EQUALS)
     {
         // return result to text box
         txtDisplay.Text = result_new.ToString();
     }
     else
     {
         // as shown in the programming assignment specification,
         // ("and clear it to make it ready for the next entry")
         // clear the text (even though that is not the typical
         // calculator behavior i think. the typical calculator
         // shows the intermittent result and only clears after
         // you press the first digit of
         // the new number you are about to enter)
         InitializeTextDisplay();
     }
 }
 protected double GetNumber()
 {
     // double number = double.Parse(txtDisplay.Text);
     double number = 0;
     bool isDouble = double.TryParse(txtDisplay.Text, out number);
     if (isDouble == false)
     {
         txtDisplay.Text = "";
         Exception ex = new Exception("Only enter valid numbers");
         throw ex;
     }
     return number;
 }
 // Perform the operation
 // returnvalue = result_old op num
 // e.g. if op=OperatorTypes.ADD
 // you will get
 // returnvalue = result_old + num
 protected double ExecuteOperator(
     double result_old,
     OperatorTypes op,
     double num
     )
 {
     double result = result_old; // default in case of an invalid operator
     switch (op)
     {
         case OperatorTypes.ADD:
             result = result_old + num;
             break;
         case OperatorTypes.SUBTRACT:
             result = result_old - num;
             break;
         case OperatorTypes.MULT:
             result = result_old * num;
             break;
         case OperatorTypes.DIVIDE:
             result = result_old / num;
             break;
         case OperatorTypes.EQUALS:
             result = result_old;
             break;
         default:
             result = result_old;
             break;
     }
     return result;
 }
 protected void btnDel_Click(object sender, EventArgs e)
 {
     // as specified in the assignment
     // have a "clear" button to clear the textbox.
     InitializeTextDisplay();
 }
 protected void btnCl_Click(object sender, EventArgs e)
 {
     // if we dont have a CLEAR button to reset everything,
     // I found that funky things happen where the operators
     // stop doing the right things after clicking a certain
     // combination of equal sign and operators etc.
     // Thus we must have a way to clear all memory and reset
     // the stack to the beginning of what it was when the calculator
     // first started.
     InitializeCalculator();
 }
}

Joins

2012-01-25T11:16:00.001-08:00



use CommunityAssist

Select LastName, Firstname, Street, [State], City, Zip
From Person
Inner Join PersonAddress
ON Person.PersonKey=PersonAddress.PersonKey

--
Select LastName, Firstname, Street, [State], City, Zip, ContactInfo
From Person, PersonAddress, personContact
WHERE Person.PersonKey=PersonAddress.PersonKey
AND Person.PersonKey=PersonContact.PersonKey

Select p.PersonKey, LastName, Firstname, Street, [State], City, Zip
From Person p
Inner Join PersonAddress pa
ON p.PersonKey=pa.PersonKey


Select LastName, Firstname, Hiredate, Dependents, Street, City,
[State], Zip
From Person p
inner join Employee e
on p.PersonKey=e.PersonKey
inner join PersonAddress pa
on p.PersonKey=pa.PersonKey

select LastName, City
From Person
Cross join PersonAddress

Select ServiceName, GrantKey
From [Service] s
left outer join ServiceGrant sg
On s.ServiceKey=sg.ServiceKey
Where GrantKey is Null

Select ServiceName, GrantKey
From [Service] s
inner join ServiceGrant sg
on sg.GrantKey > s.ServiceKey

--a self join joins a table with itself
--here is a little script to show 
--an example

Create Database sample
GO
Use sample
Go
Create table Employee
(
EmployeeID int Primary key,
lastName varchar(30) not null,
Supervisior int
)
GO
Insert into Employee
Values(1,'Smith', 3)
Insert into Employee
Values(2,'Rogers', 3)
Insert into Employee
Values(3,'Johnson', null)
Insert into Employee
Values(4,'Larson', 2)
Insert into Employee
Values(5,'Standish', 3)

Select * from Employee
--the self join
Select e.LastName as employee, s.Lastname as supervisor
From employee e
Inner join employee s
on s.employeeid=e.supervisior

ADO

2012-01-24T12:08:00.000-08:00

The database scripts can be found on the syllabus. Here is a description of how to run the scripts with SQL Server Express through visual Studio

Running SQL scripts through Visual Studio

Default.Aspx


<%@ Page Language="C#" AutoEventWireup="true" 
CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 
Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DropDownList ID="DropDownList1" runat="server">
        </asp:DropDownList>

        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
    </div>
    <asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
        Text="Get Donations" />
    </form>
</body>
</html>

Default.aspx.cs



using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection connect = new SqlConnection 
("Data Source=localhost;initial catalog=communityassist;integrated security=true");

            //SqlConnection connect = new SqlConnection 
("Data Source=localhost;initial catalog=communityassist;user=manager;password=p@ssw0rd1");

            //SqlConnection connect2 = new SqlConnection();
            //SqlConnectionStringBuilder builder=new SqlConnectionStringBuilder();
            //builder.DataSource = "localhost";
            //builder.InitialCatalog = "community assist";

            string sql = "Select Distinct DonationDate from donation";

            SqlCommand cmd = new SqlCommand(sql, connect);

            DataSet ds = new DataSet();

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            da.Fill(ds, "Donations");

            DropDownList1.DataSource = ds.Tables["Donations"];
            DropDownList1.DataTextField= "DonationDate";
            DropDownList1.DataBind();
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
         //ado objects

        SqlConnection connect = new SqlConnection
("Data Source=localhost;initial catalog=communityassist;integrated security=true");

        //SqlConnection connect2 = new SqlConnection();
        //SqlConnectionStringBuilder builder=new SqlConnectionStringBuilder();
        //builder.DataSource = "localhost";
        //builder.InitialCatalog = "community assist";

        string sql = "Select DonationDate, DonationAmount from donation Where DonationDate=@date";

        SqlCommand cmd = new SqlCommand(sql, connect);
        cmd.Parameters.AddWithValue("@date", DateTime.Parse(DropDownList1.SelectedItem.ToString()));

        DataSet ds = new DataSet();

        SqlDataAdapter da = new SqlDataAdapter(cmd);

        da.Fill(ds,"Donations");

        GridView1.DataSource = ds.Tables["Donations"];
        GridView1.DataBind();

         
       
    }
}

Aggregate Functions

2012-01-23T10:46:00.001-08:00

Here is the in-class code for Aggregate Functions


Use CommunityAssist 

--aggregate function

Select COUNT(PersonKey) "Number of Donations"
From Donation

--DISTINCT will return only unique values -- in the following
--it returns only unique persons for donors
Select COUNT(Distinct PersonKey) [Number of Donors]
From Donation

Select SUM(donationAmount) [total donations]
From Donation

Select Avg(donationAmount) "Average"
From Donation

Select MAX(donationAmount) "Highest"
From Donation

Select MiN(donationAmount) "Highest"
From Donation

--if you have an aggregate function in the SELECT
--any other column in the SELECT not a part of an 
--aggregate function must be contained in a
--GROUP BY clause
Select EmployeeKey, COUNT(DonationKey) "Count",
sum(DonationAmount) as Total
From Donation
Group by EmployeeKey

--this does several things:
--MONTH and YEAR are scalar functions
--that means they operate on one row at a time
--SUM is an aggreagate function operating on 
--multiple rows--so the MONTH and YEARfunctions
--must be contained in a group by clause
--the aliases don't work, you must do the functions
--themselves
--if you have an aggergate function in your 
--criteria you must use HAVING instead of WHERE
--you can use both in a query as in the example below
--the WHERE comes after the FROM
--the HAVING comes after the GROUP BY

Select MONTH(DonationDate) [Month], Year(DonationDate) [Year],SUM(donationAmount) total
From Donation
Where YEAR(DonationDate)=2010
Group by Year(donationDate), Month(DonationDate)
having SUM(donationAmount) > 3000

Here is a solution to the substring problem where it wouldn't return single worded entries. The problem was it was looking for a space and none existed. The solution, if inelegant is to concatenate in a space within the charIndex function so that every column has a trailing space.



Select SUBSTRING(VehicleMake, 1, CHARINDEX(' ', VehicleMake+' ', 1))
From Customer.Vehicle

Calculator with Addition

2012-01-12T12:15:00.000-08:00

Here is the calculator. I want to mention that when you do multiplication and division you will have to use a somewhat different pattern. There is only a zero in the session variable when you click the operator. That results in the final answer also equaling zero or infinity. Try to figure out how to do these, if you can and we will look at it again on Tuesday.

Default.aspx


<%@ Page Language="C#" AutoEventWireup="true" 
CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 
Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Calculator</title>
    <link href="calculator.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <table>
    <tbody>
    <tr>
    <td colspan="4">
        <asp:TextBox ID="txtDisplay" runat="server"></asp:TextBox></td>
    
    </tr>
    <tr>
    <td>
        <asp:Button ID="Button1" runat="server" Text="7" 
CssClass="buttonstyle" OnClick="InputNumber_Click" /></td>
    <td>
        <asp:Button ID="Button2" runat="server" Text="8" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="Button3" runat="server" Text="9" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="btnAdd" runat="server" Text="+" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>
    </tr>
    <tr>
    <td>
        <asp:Button ID="Button5" runat="server" Text="4" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="Button6" runat="server" Text="5" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="Button7" runat="server" Text="6" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="btnSubtract" runat="server" Text="-" 
CssClass="buttonstyle" OnClick="Operator_Click" /></td>
    </tr>
    <tr>
    <td>
        <asp:Button ID="Button9" runat="server" Text="1" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="Button10" runat="server" Text="2" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="Button11" runat="server" Text="3" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="btnMult" runat="server" Text="*" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>
    </tr>
    <tr>
    <td>
        <asp:Button ID="btnDel" runat="server" Text="Del" 
CssClass="buttonstyle"/></td>
    <td>
        <asp:Button ID="Button14" runat="server" Text="0" 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="Button15" runat="server" Text="." 
CssClass="buttonstyle" OnClick="InputNumber_Click"/></td>
    <td>
        <asp:Button ID="btnDiv" runat="server" Text="/" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>
    </tr>
    <tr>
   
    <td colspan="4">
        <asp:Button ID="btnEqual" runat="server" Text="=" 
CssClass="buttonstyle" OnClick="Operator_Click"/></td>
    </tr>
    </tbody>
    </table>
    </div>
    </form>
</body>
</html>

Default.aspx.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Session["result"] = 0.0;
        }

    }
    protected void InputNumber_Click(object sender, EventArgs e)
    {
        Button b = (Button)sender;
        txtDisplay.Text += b.Text;
    }
    protected void Operator_Click(object sender, EventArgs e)
    {
        Button b = (Button)sender;

        if (b.ID.Equals("btnAdd"))
        {
            Addition();
            Session["operator"] = "+";
        }
        if(b.ID.Equals("btnEqual"))
        {
            Calculate();
        }
    }

    protected void Addition()
    {
       
        try
        {
            double num = GetNumber();
            double numResult = (double)Session["result"];
            Session["result"] = num + numResult;
            txtDisplay.Text = "";
        }
        catch(Exception ex)
        {
            Response.Write(ex.Message);
        }

    }

    protected double GetNumber()
    {
       
        double number =0;
        bool isDouble = double.TryParse(txtDisplay.Text, out number);
        if (isDouble == false)
        {
            txtDisplay.Text = "";
            Exception ex = new Exception("Only enter valid numbers");
            throw ex;
        }
        return number;
    }

    protected void Calculate()
    {
        double number = (double)Session["result"];
        double number2 = GetNumber();
        if (Session["operator"].ToString().Equals("+"))
        {
            txtDisplay.Text = (number + number2).ToString();
        }
    }
}

Calculator.css


body {
}

.buttonstyle
{
    width:50px;
    
}

#txtDisplay
{
    text-align:right;
}

SQL Functions

2012-01-11T11:54:00.001-08:00


--concatination

Select (Lastname + ', ' + firstname) as [Person Name]
From Person

-- Operators
Select DonationAmount, DonationAmount * .85 as [Charity]
From Donation

Select * From Donation
Select YEAR(DonationDate) as [Year] From Donation
Select MONTH(DonationDate) as [Month] from Donation
Select  Distinct Day(DonationDate) as [Day] from Donation


Select DATEPART(MM,DonationDate) From Donation
Select DatePart(hh,DonationDate) as [Month] from Donation

Select DATEDIFF(DD,'12/31/2011', GETDATE())
Select DateAdd(YY, 5, GETDATE())

Select * from PersonAddress

Select CHARINDEX(Street, ' ') From PersonAddress


Select SUBSTRING(Street, 1, 10) 
From PersonAddress

Select SUBSTRING(Street, 1, charindex(' ', Street)) 
From PersonAddress

Select * From Donation
Select '$' +CAST( DonationAmount as Varchar) as Amount from Donation

Select '(' + SUBSTRING(ContactInfo, 1,3) + ')' 
From PersonContact 
Where ContactTypeKey !=6

Select '$' +CAST(( DonationAmount * .85) as Varchar) as CharityAmount from Donation

SQL SELECT

2012-01-09T11:57:00.000-08:00



Use CommunityAssist

Select Lastname, Firstname 
From Person;

Select * From Person

Select lastname as [Last Name], 
Firstname as [First Name]
From Person

--if there are no special characters or spaces
--you don't need brackets
Select lastname Surname, 
Firstname Name
From Person

/*this is a multi line
comment */

Select Distinct PersonKey from Donation
Order by PersonKey Desc

Select * from Donation
Order by donationAmount Desc

Select * from Donation
Order by 3 Desc

Select Top 10 DonationKey, DonationAmount
From Donation
Order by DonationAmount Desc

Select DonationKey, donationAmount
From Donation
Where DonationAmount > 1000

-- > < >= <= != <>

Select * From PersonAddress
Where City='Seattle'

Select * From PersonAddress
Where not City='Seattle'

Select * from Donation
Where DonationDate='2/2/2010'

Select * from Donation
Where DonationDate between '2/2/2010' And '2/6/2010'

Select * From PersonAddress
Where City='Kent' or City='Bellevue'

Select * From PersonContact
Where ContactInfo LIKE '306%'
-- _ for a single character ITC22_ 220 222 224 226

Select * From Donation
Where EmployeeKey in (3, 4, 5)

Select * from PersonAddress
Where Apartment is Not Null

ITC 222 assignment six

2012-01-08T14:18:00.001-08:00

Insert, Update, Delete

Problems

1-5 Insert the following new customer, his vehicle, and the services provided. He is not going to become a registered customer at this time. (This will require multiple insert statements. You will also need to look up the automatically generate keys to use as foreign keys.)

Jay Russell, license BFM349, Ford Fusion, 2011, at the new Tacoma shop. He got an oil change and new windshield wipers.

6. Registered customer 7 has a new email address. Change it to "laura26@yahoo.com" change the password to "moonshine"

7. Change the price of auto service 12 to $110.90

8. Delete AutoserviceDetailID 80 from vehicle service detail.

What I am Looking for

The insert requires some effort. Not only do you have to do multiple insert statements, you also have to look up vales, and the inserts must be done in the correct order. 1through 5 are wort 7 points. The others are worth 1 point each, though they are not without their dangers

To Turn In

Copy the SQL code to a Google doc and share it with spconger@gmail.com

ITC 222 Assignment Five

2012-01-07T15:28:00.001-08:00

Sub Queries

Problems

For each of these problems use subqueries for all parts of the problem, even though joins may make more sense to you.

1. List the name and price of the service with the maximum price.

2. Get a list of the first and last names of every person who is an employee.

3. Get a list of all the employee supervisors.

4. List the name of every person who is not a registered customer.

5. Get the license make and year of every vehicle that has been served. Some may appear more than once. You can use DISTINCT to not show duplicates.

6. Get the same information as in number five but only for those vehicles that have had service 12 completed on them.

7. Now repeat the query above, but include the service name in the select clause. (Remember, no inner joins).

8. Get the service price, the average service price and the difference between the two for every service. Sort them in descending order by service price. (This is one that can only be done with subqueries).

What I am looking for

I want only sub queries. 1 through 6 are worth 1 point each. 7 and 8 are worth 2 points each.

To Turn in

Post the SQL in a Google doc. Share it with spconger@gmail.com

ITC 222 Assignment 4

2012-01-07T14:05:00.000-08:00

Joins

Inner Joins

1. Return the names (first and last) and emails of every registered user.

2. Do the same query based on the old style "where" based syntax.

3. List the customer names, the license plate, the vehicle make and year of every registered customer.

4. List the customer name, the license plate, the vehicle make and year and the services provided for the Vehicle service with the ID of 12.

5. List the location names and the names of all the employees that work at those locations.

Cross Joins

6. Do a cross join between Person and registered customer. Use the cross Join syntax.

7. Do a cross join using the older syntax

Outer Joins

8. List the customers people that do not have a registered customer account.

9. List any location names that has never provided a service for any car

What I am looking for

I want to see the SQL that would provide the data to the query. Each one is worth 1 pt. with one point for free for a total of 10 points.

To Turn in

Copy the SQL into a Google doc. Share it with spconger@gmail.com

Stuf for the first Assignment

2012-01-05T12:28:00.000-08:00

Default.aspx


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" 
Inherits="_Default"  Trace="false" ViewStateMode="Enabled"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 
Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h1>Stuff</h1>
    <asp:DropDownList ID="DropDownList1" runat="server">
        
        </asp:DropDownList>
        <p><asp:Label ID="Label1" runat="server" Text="Enter Name"></asp:Label>
        <asp:TextBox ID="txtName" runat="server"></asp:TextBox></p>
        <asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>
        
    
        <asp:Button ID="btnConfirm" runat="server" Text="Confirm" 
            onclick="btnConfirm_Click" />
        
    
    </div>
    </form>
</body>
</html>

Default.aspx.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string[] colors = new string[5];
        colors[0] = "Blue";
        colors[1] = "Green";
        colors[2] = "Red";
        colors[3] = "Yellow";
        colors[4] = "Teal";

        if (!IsPostBack)
        {
            DropDownList1.DataSource = colors;
            DropDownList1.DataBind();
        }

        //DropDownList1.Items.Add("Red");
        //DropDownList1.Items.Add("Green");
    }
    protected void btnConfirm_Click(object sender, EventArgs e)
    {
        string name = txtName.Text;
        string date = Calendar1.SelectedDate.ToShortDateString();
        string chosenColor = DropDownList1.SelectedItem.ToString();

        //Response.Redirect("Confirmation.aspx?name=" 
        //    + name+"&date="
        //    +date+"&color="+chosenColor);

        Session["name"] = name;
        Session["color"]=chosenColor;
        Session["date"] = date;

        Response.Redirect("Confirmation.aspx");
    }
   
}

Confirmation.aspx


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Confirmation.aspx.cs" Inherits="Confirmation" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h1>Confirmation Page</h1>
    </div>
    <asp:Label ID="lblName" runat="server" Text="Label"></asp:Label><br />
    <asp:Label ID="lblColor" runat="server" Text="Label"></asp:Label><br />
    <asp:Label ID="lblDate" runat="server" Text="Label"></asp:Label>


    </form>
</body>
</html>

Confirmation.aspx.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Confirmation : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //lblColor.Text = Request.QueryString["color"];
        //lblName.Text = Request.QueryString["name"];
        //lblDate.Text = Request.QueryString["date"];
        if (Session["color"] != null)
        {
            lblColor.Text = Session["color"].ToString();
            lblDate.Text = Session["date"].ToString();
            lblName.Text = Session["name"].ToString();
        }
        else
        {
            Response.Redirect("Default.aspx");
        }

        
    }
}

ITC 222 Assignment 3

2011-12-13T11:40:00.000-08:00

Aggregate Functions

Outcomes

Use SQL to retrieve database information

Problems

1. How many Ford vehicles are there? (Remember the LIKE operator)

2. What is the highest price for a service?

3. What is the lowest price for a service?

4. What is the average price for a service?

5. Although it doesn't make much sense, what it the total of all the service prices?

6. What is the count of cars served in each location?

7. list only the locations and counts of those locations that have served more than 15 customers

8. How many employees does each supervisor supervise?

9. What is the count of vehicles served on the first of March 2010?

10. What is the total number of vehicles served per month?

What I am looking for

I want to see the SQL that would answer each problem. I do not need to see the actual answers, though you can include them if you wish

Each problem is worth 1 point for a total of 10 points

What to turn in

Paste your answers into a Google doc and share it with spconger@gmail.com

ITC 222 Assignment 2

2011-12-13T11:15:00.000-08:00

Scalar Functions

Outcomes

Use SQL to retrieve database information

The Problems

1. Select the distinct years in which employees were hired. Sort them so that the newest are on top

2. Display the names in person as (Last name, first name)

3. Return only the first word of each vehicle make

4. How many years difference is there between the newest and oldest hire date. (Just enter the dates manually. don't try to get them from the rows)

5. How many months are between the newest and oldest hires?

6. Format the phone numbers of the locations so they look like (206)555-1000

7. Format the prices of the auto services so that they have a $ sign

8.. Display the discount and tax percents in service detail as percents with a % sign. (You will have to multiply them by 100)

What I am looking for

I want to see the SQL for each problem

Each problem is worth 1 point except for 6 and 8 which are worth 2 points each for a total of 10 points

deally, copy and paste the code into a Google doc and share it with spconger@gmail.com. I will comment on the document

ITC 222 Assignment 1

2011-12-13T10:48:00.000-08:00

Simple Select Statements

Outcomes

Use SQL to retrieve database information

The problems

1. List all the people in the person table.

2. List all the people in the person table in alphabetical order by last name

3. List all the people in reverse order. Alias each field.

4. List all the locations in Seattle.

5. List all the services with a price of over $100.

6. List all the last names of persons with the letters 'tan' in them.

7. List all the services provided between 3/1/2010 and 3/15/2010.

8. List all the employees who don't have supervisors

9. List all the employees who do have supervisors.

10. List all the employees who have supervisors and were hired in 2007 (between 1/1 and 12/31/2007)

What I am looking for

I want just the SQL statement. I don't need the results. None of the questions involve joins or other more advanced SQL.

Each question is worth 1 point for a total of 10 pts

What to turn in

Ideally, copy and paste the code into a Google doc and share it with spconger@gmail.com. I will comment on the document

ITC 220 Presentation

2011-12-07T08:57:00.001-08:00

Here are the guidelines for the presentation:

1. Introduce the group members
2. Show your Entity Diagram of the database and explain briefly what tables you have developed and how the work
3. Explain what part of the project was the most challenging for the group and why
4. Explain what part of the project you are most proud of or excited about

Math Game Class

2011-12-06T13:27:00.001-08:00

Here is one possibility for a Math Game class. It generates the random numbers and performs all the math functions. You would call it from the Form's code behind by instantiating it and then accessing its properties and public methods. For example: (This would be in the Start Game button click event)


MathGame game = New MathGame(RadioButtonList.SelectedItem.Text);
lblNumber1.Text=game.Number1.ToString();
lblNumber2.Text=game.Number2.toString();

Remember, also, a web page has no state. That means that between clicking the start button and clicking the check answer button the class loses all its values. To prevent this you need to save the class to a session variable at the end of the start button code and recall it at the beginning of the Check answer code. First an example of saving the class to a Session variable:


Session["myGame"]=game;

Here is an example of recalling the class from the session variable:


MathGame game = (MathGame)Session["myGame"];

Sessions store everything as generic objects, so it is necessary to cast it back to the specific kind of object that it is, in this case (MathGame).

Here is the code for the class itself:

MathGame.cs


using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// 
///This is one verson of a class to handle
///the math game. It takes the operation 
///(Addition, multiplication, Subtraction, Division)
///in with the constructor. Assigns the random
///numbers and then calls the ChooseOperation()
///method. The ChooseOperation() method calls the
///appropriate math method. In the Subtract() 
///and Division() methods the method checks to make
///sure that first number is larger than the 
///second number. If not, it sends it tot the Reverse()
///method which reverses the values.
///The CheckAnswer method takes in an integer guess
///and compares it to the answer. It treats division
///as a special case and also compares the remainder.
///For problems not using the remainder it is passed
///as a default zero --not the best solution, but 
///easier than some of the alternatives. The Check
///answer method returns a string
/// 

public class MathGame
{

    //private fields
    int number1;
    int number2;
    int answer;
    string op;
    int remainder;

    

    //constructor
 public MathGame(string operation)
 {
  op=operation; //get the operation
        //get the random numbers
        number1 = GetRandom(); 
        number2 = GetRandom();
        //call the ChooseOperation() method
        ChooseOperation();
 }
    //public read only properties
    public int Number1
    {
        get { return number1; }
        
    }
    public int Number2
    {
        get { return number2; }
     
    }

    public int Answer
    {
        get { return answer; }
      
    }

    public int Remainder
    {
        get { return remainder; }
     
    }


    //private methods
    private int GetRandom()
    {
        //generate a random number
        Random r = new Random();
        return r.Next(1, 10);
    }

    private void ChooseOperation()
    {
        //choose an operation
        if (op.Equals("Add"))
            Add();
        if (op.Equals("Subtract"))
            Subtract();
        if (op.Equals("Multiply"))
            Multiply();
        if (op.Equals("Divide"))
            Division();
    }
    private void Add()
    {
        answer = number1 + number2;
    }
    private void Substract()
    {
        if (number1 < number2)
            Reverse();

        answer= number1 - number2;
    }
    private void Multiply()
    {
       answer= number1 * number2;
    }

    private void Division()
    {
        if (number1 > number2)
            Reverse();

       answer= number1 / number2;
       GetRemainder();
    }

    private void GetRemainder()
    {
        remainder= number1 % number2;
    }

    private void Reverse()
    {
        //this method reverses the numbers
        //if number1 is smaller than number2
        int number3;
        number3 = number1;
        number1 = number2;
        number2 = number3;
    }

    //public methods
    public string CheckGuess(int guess, int remain)
    {
        string reply = null;

        if (op.Equals("Divide"))
        {
            if (guess == answer && remain == remainder)
                reply = "Congratulations";
            else
                reply = "try again";
        }
        else
        {
            if (guess == answer)
                reply = "Congratulations";
            else
                reply = "try again";
        }

        return reply;
    }
}

ITC 110 course Evaluations

2011-12-05T11:37:00.001-08:00

The class evaluation for the evening class will be Wednesday 12/7/2011

The URL is http://www.seattlecolleges.com/facultyevaluations

The Course Number is 3191

The evaluation will be available 7:30 to 8:30 PM

For the morning class the evaluation will be on Thursday 12/8/2011

The Course Item number is 3190

The evaluation will be available 10:30 to 11:30 AM

For both evaluations the password is database

ITC 220 Evaluation

2011-12-05T11:35:00.001-08:00

The class evaluation will be Wednesday 12/7/2011

The URL is http://www.seattlecolleges.com/facultyevaluations

The course number is 3206

The password is "database" (no quotes)

The evaluation will be available between 10:30 AM and 11:30 AM.

View, Stored Procedures, Triggers

2011-12-05T11:20:00.001-08:00

Here is the code for the Views, Stored Procedures and Triggers


Use CommunityAssist
Go
--this is a view. A view is used to provide
--a particular "view" of the data
--usually taylored to a particular set of users
--views are behave like tables
--they are really filtered queries. No
--data is actually stored in the view itself
Alter view vw_Employees
As
Select LastName [Last Name],
FirstName [First Name],
Street,
City,
[State],
Zip [zip code]
From Person p
inner join PersonAddress pa
on p.PersonKey=pa.PersonKey
Inner join Employee e
on e.PersonKey=p.PersonKey

--using the view like a table
Select * from vw_Employees

--the aliases in a view become the 
--actual column names
Select [Last Name], [First Name], Street
From vw_Employees

go
--a store procedure is an executable
--that consist of one or more sql statements
--they can be used to make dangerous
--commands like updates safe
Create proc usp_UpdateAddress
--parameters provided by the user
--probablly through a form
@PersonAddressKey int ,
@street nvarchar(255) ,
@City nvarchar(255),
@Zip nvarchar(10) 
AS --beginning of the procedure proper
--check to see the the address exists
if exists
 (Select PersonAddressKey 
 from PersonAddress
 Where PersonAddressKey = @PersonAddressKey)
Begin --if it does
--update the address with the new values
Update PersonAddress
Set Street = @Street,
City=@City,
Zip = @Zip
Where PersonAddressKey=@PersonAddressKey
End --end if true
Else --if false
--print a message
print 'Address doesnt exist'

Select * From Personaddress

--calling the stored procedure and 
--providing the parameter values
--the keyword exec is optional
exec usp_UpdateAddress
@PersonAddressKey = 70,
@Street='10 South Mann Street',
@City='Tacoma',
@Zip='98000'

Go
--triggers are procedures that execute 
--on an event
--the following executes on inserts into
--the Donation table
Alter trigger tr_DonationAmount on Donation
for Insert 
As
--check to see if the receipt table exists
--if not create it
If not exists
(Select name from sys.tables 
 where name='receipt')
Begin
Create Table receipt
(

DonationDate DateTime, 
DonationAmount money, 
PersonKey int, 
EmployeeKey int
)
End
--declare a variable
Declare @DonationAmt money
--assign a value to the variable from the inserted
--table. the Inserted table is a temporary table
--created to store insertions for the length of
--the transaction
Select @DonationAmt = DonationAmount from inserted
--check on the size of the new donation
if (@DonationAmt >=200)
Begin --if greater than 199
--insert it into the receipt table
Insert into receipt(
DonationDate, 
DonationAmount, 
PersonKey, 
EmployeeKey)
--the values to be inserted are selected
--from the inserted table
Select 
DonationDate, 
DonationAmount, 
PersonKey, 
EmployeeKey
From Inserted
End

--using the key
Insert into Donation(DonationDate, DonationAmount, 
PersonKey, EmployeeKey)
Values(GETDATE(),250,1, 1)

Select * From Receipt
Select * From Donation

Guessing Game ASP.Net

2011-11-30T14:37:00.001-08:00

This example has much of what you need for the last assignment. It shows how to use a class with ASP.Net. It shows how to preserve values in Session variables and how to dynamically assign the cssClass property. It also uses the Random object.

Here is a picture of the program running

Here is the Source markup code

Default.aspx


<%@ Page Language="C#" AutoEventWireup="true"  
CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <link href="GuessGame.css" rel="stylesheet" 
type="text/css" />
</head>
<body>
<h1>Guessing Game</h1>
    <form id="form1" runat="server">
    <div>
    <p>For this game you get ten chances to Guess 
a random number. Choose the difficulty of the game
    from the following selections. 
Then click the Start Game button.</p>
    <p><strong>Choose Difficulty</strong></p>
        <asp:RadioButtonList ID="RadioButtonList1" runat="server">
        <asp:ListItem Value="1">1 to 10</asp:ListItem>
        <asp:ListItem Value="2">1 to 100</asp:ListItem>
        <asp:ListItem Value="3" Selected="True">1 to 1000</asp:ListItem>
        </asp:RadioButtonList>
        <asp:Button ID="btnStart" runat="server" Text="StartGame" 
                onclick="btnStart_Click" />
            <asp:Label ID="lblStart" runat="server" Text="Label">
</asp:Label>
        <p>Enter your Guess 
            <asp:TextBox ID="txtGuess" runat="server">
</asp:TextBox></p>
        <asp:Button ID="btnGuess" runat="server" Text="Guess" onclick="btnGuess_Click" />
        <p>   <asp:Label ID="lblResult" runat="server" Text="Result"></asp:Label></p>
        <p>
            <asp:Button ID="btnGameScore" runat="server"
 Text="GetGameScore" 
                onclick="btnGameScore_Click" />
            <asp:Label ID="lblScore" runat="server" Text="Label"></asp:Label></p>
    </div>
 
    </form>
</body>
</html>

Here is the code for the Class Guessing Game

GuessingGame.cs


using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// 
/// This class controls the guessing game
/// 

public class GuessingGame
{
    
    //class fields--they are private by default
    int max;
    int min;
    int number;
    int count;
   
    

       
 public GuessingGame(int minimum, int maximum)
 {
        //constructor, gets the max and min
        //values from the form
        max=maximum;
        min=minimum;
        GetRandom();//generate the random number
        count=10;
      
 }

    //public properties
    public int Max
    {
        get { return max; }
        set { max = value; }
    }

    public int Min
    {
        get { return min; }
        set { min = value; }
    }

    public int Number
    {
        //the random number is a see only
        //value--the user cannot change it
        get { return number; }
       
    }

    private void GetRandom()
    {
        //initiate the random number
        Random r = new Random();
        number = r.Next(Min, Max);
    }

    public string CheckGuess(int guess)
    {
        //the default reply
        string reply = 
"sorry you have used all your guesses the number was"
+ Number;

        //as long as the count is bigger than 0
        //keep playing the game
        if (count > 0)
        {
            if (guess > number)
                reply = "Your guess is too high";
            else if (guess < number)
                reply = "Your guess is too low";
            else
                reply = "Congratulations you got it!";
        }
        count--; //decrement the count
        return reply;
    }

    public int GetGameScore()
    {
        return count;
    }
}

And here is the code for the Web Page C#

Default.aspx.cs


using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page 
{
    //give the gameClass variable class scope
    GuessingGame game;
   
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnStart_Click(object sender, EventArgs e)
    {
        //Determine the range by getting 
        //the radio button values
        int max=0, min=0;
        if (RadioButtonList1.SelectedValue=="1")
        {
            max=10;
            min=1;
        }
        else if(RadioButtonList1.SelectedValue=="2")
        {
            max=100;
            min=1;
        }
        else{
            max=1000;
            min=1;
        }

        //instantiate the game
        //every time you click the start game you
        //get a new instance of the game class
        game = new GuessingGame(min, max);
        
        //save it to a session variable so it can keep
        //state ie its settings
        Session["gameSession"] = game;
        
        //change the text 
        lblStart.Text = "Ready to Play";
        //apply a style sheet style dynamically
        lblStart.CssClass = "winner";
        //set the focus in the guess text box
        txtGuess.Focus();
    }
    protected void btnGuess_Click(object sender, EventArgs e)
    {
        //make sure the session exists
        //ie that they pushed the start game button
        //if not warn them
        if (Session["gameSession"]==null)
        {
            lblStart.Text = "Press Start Button";
            lblStart.CssClass = "warning";
            return;
        }
        //recall the session and cast it to the class type
        GuessingGame game = (GuessingGame)Session["gameSession"];

        //make sure the guess is a good integer
        int guess;
        bool isGood = int.TryParse(txtGuess.Text, out guess);

        //if good, pass the guess to the class
        //the method returns the prompt too high
        //too low, etc.
        if (isGood)
        {
            lblResult.Text = game.CheckGuess(guess);
            lblResult.CssClass = "normal";
        }
        else
        {
            lblResult.Text = "Enter a valid number as a guess";
            lblResult.CssClass = "warning";
        }

        //if a winner change font using the css Style
        if(lblResult.Text.Equals("Congratulations you got it!"))
        {
            lblResult.CssClass="winner";
        }
       

       
       
    }
    protected void btnGameScore_Click(object sender, EventArgs e)
    {

        //call the session
        GuessingGame game = (GuessingGame)Session["gameSession"];

        //display the score
        lblScore.Text = "Your score for this game is "
            + game.GetGameScore().ToString();
    }
}

Here is the CSS I used for the class. Very Minimal

GuessingGame.css



body 
{
 font-family:Verdana Sans-Serif;
 font-size:large;
}
h1
{
 background-color:Navy;
 color:White;
 font-weight:bold;
 height:100px;
 font-size:200%;
 vertical-align:middle;
 text-align:center;
}

/**********************
these are css classes used 
dynamically in the code
***************************/
.winner
{
 color:Green;
 font-weight:bold;
}

.warning
{
 color:Red;
 font-weight:bold;
}

.normal
{
 color:Black;
 font-weight:normal;
}

Here is a sequence diagram of how the two classes communicate.

ITC 172 Assignment 7 MVC

2011-11-29T13:44:00.001-08:00

There are no practices with this assignment, just the MVC. It may seem overwhelming but is really much simpler than it looks.

Programming

Start a new ASP MVC2 web project

Add a model that uses LINQ to return a list of registered customers including their names (that means you will have to drag the Person table as well as the Registered Customer table onto the designer.)

Add a controller Named RegisteredCustomerController

Write the LINQ code to retrieve registered Customers

Add a View that displays the registered customers in a table

Add a tab to the menu in the Master page

What I am looking for

The model is worth 5 pts
The controller is worth 5 pts
The view is worth 5 pts
Modifying the Master and displaying the customers in a new tab 5 pts

The total is worth 20 points

To Turn in

Turn in all the code and markup you have done. (You don't need to post all the auto generated code and markup. Include a screenshot of the application running with the customers displayed. Put it all in a Google doc and share it with spconger@gmail.com

Morning ASP Examples

2011-11-29T11:56:00.001-08:00

Here is the ASP source code



<%@ Page Language="C#" AutoEventWireup="true" 
CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="FinalProject.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
      <p> Enter your Name <asp:TextBox 
ID="txtName" runat="server"></asp:TextBox></p>
        <asp:Button ID="btnName" runat="server" Text="Click Me" 
            onclick="btnName_Click" />
        <asp:Label ID="lblResult" runat="server" Text="Label"></asp:Label>
        <asp:CheckBoxList ID="CheckBoxList1" runat="server">
            <asp:ListItem Value="3.25">Bread</asp:ListItem>
            <asp:ListItem Value="1.95">Eggs</asp:ListItem>
            <asp:ListItem Value="3">Milk</asp:ListItem>
            <asp:ListItem Value="1.59">Chili</asp:ListItem>
            <asp:ListItem Value="7.99">Beer</asp:ListItem>
        </asp:CheckBoxList>
        
        <asp:Button ID="Button1" runat="server" 
onclick="Button1_Click" Text="GetTotal" />
        
        <asp:Label ID="lblTotal" runat="server" 
Text="Label"></asp:Label>
        
    </div>
    </form>
</body>
</html>

Here is the code behind


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //if (!IsPostBack)
        //{
        //    CheckBoxList1.Items.Add("Red");
        //    CheckBoxList1.Items.Add("Green");
        //    CheckBoxList1.Items.Add("Blue");
        //}
    }
    protected void btnName_Click(object sender, EventArgs e)
    {
        lblResult.Text = "Hello " + txtName.Text;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        double total = 0;
        foreach (ListItem item in CheckBoxList1.Items)
        {
            if (item.Selected)
            {
                total += double.Parse(item.Value.ToString());
               
            }

            lblTotal.Text = "Your total is " + total.ToString("c"); 
        }
    }
}

ASP Overview (a mess of sorts)

2011-11-28T19:07:00.001-08:00

here is the ASP and HTML source


<%@ Page Language="C#" AutoEventWireup="true"
 CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC 
"-//W3C//DTD XHTML 1.0 Transitional//EN" 
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
   
   
    
    <link href="ClassFun.css" rel="stylesheet" type="text/css" />
   
   
    
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h2>My Dates
        </h2>
        <asp:DropDownList ID="DropDownList1" runat="server">
        </asp:DropDownList>
        <asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>
        <asp:Button ID="btnGetDate" runat="server" Text="Get Date" 
            onclick="btnGetDate_Click" />
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <br />
        <p>Enter Quantity<asp:TextBox ID="txtQuantity" 
runat="server"></asp:TextBox></p>
        <br />
        <br />
        <asp:RadioButtonList ID="RadioButtonList1" 
runat="server" AutoPostBack="True" 
            onselectedindexchanged="RadioButtonList1_SelectedIndexChanged">
            <asp:ListItem Value="1.19">Apples</asp:ListItem>
            <asp:ListItem Value="4.99">Strawberries</asp:ListItem>
            <asp:ListItem Value=".59">Bananas</asp:ListItem>
            <asp:ListItem Value=".5">Kiwis</asp:ListItem>
            <asp:ListItem Value="1.50">Oranges</asp:ListItem>
        </asp:RadioButtonList>
        <asp:Label ID="lblResults" runat="server" Text="Label"></asp:Label>
        <br />
    
    </div>
    </form>
</body>
</html>

Here is the Code behind


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Calendar1.SelectedDate = Calendar1.TodaysDate;
            DropDownList1.Items.Add("One");
            DropDownList1.Items.Add("Two");
            DropDownList1.Items.Add("Three");
        }

      
    }

    protected void btnGetDate_Click(object sender, EventArgs e)
    {
       
            
            TextBox1.Text = Calendar1.SelectedDate.ToShortDateString();
        
    }

    protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        int quantity = int.Parse(txtQuantity.Text);
        double price = double.Parse(RadioButtonList1.SelectedValue.ToString());
        double total=price * quantity;

        lblResults.Text = "It will cost " + 
           total.ToString("c") + " for " + 
           quantity.ToString() + " " +
           RadioButtonList1.SelectedItem.ToString();
    }
}

And finally, here is the minimal CSS


body
{
    
}

h2
{
    color:Navy;
}

th
{
    color:White;
    background-color:Navy;
}

ITC 172 Assignment 6

2011-11-28T14:43:00.001-08:00

Practices

1. Add a textbox and a validation control that makes it a required field. Change the default message and show the ASP markup

2. Add a textbox and a regular expressions validation that validates that the textbox contains a valid email address

3. Assume you have a form with fields for last name and first name. Write the LINQ code to add them to the Person table in the AutoMart database

Programming

Start a new Empty Web Site and add a Web Form.

We are going to write a new customer and new vehicle to the Automart Database using LINQ. We are going to make the customer a registered customer. That means you will need to add the customer to the Person table, then to the RegisteredCustomer table and then add the Vehicle to the Vehicle table. All three tables are linked by the PersonKey.

Create the form with all the necessary fields. Validate the fields. Make Last name required. Make email required and also validate that it is a well formed email address. License plate and vehicle type and vehicle year should also be required.

Write the LINQ code to insert the new registered customer and vehicle. Use error trapping and add an error page to the project

Use CSS to style the web site

What I am looking for

The practices are worth 2 point each
The form textboxes and validation are worth 6 pts
The LINQ code is worth 5 points
The error trapping is worth 2 pts
The Css is worth 1

What to Turn in

Turn in all the ASP markup and the c# code in a Google Doc and share with spconger@gmail.com

ITC 172 Assignment Five

2011-11-28T14:19:00.001-08:00

Practices

1. Create a LINQ query that returns all the last names and first names in the people table

2. Bind the results the query in one to a DropDownList

3. Write a LINQ query that takes the city from a drop down list and returns the locations for that city

4. Add A try catch to number 3

5. Write the code to redirect an error message to an error page

6. Write the code to display the error message on the error page

7. Write the ASP markup to display a location Name, Address and City in a ListView control

Programming

Create a new Empty web site. Add a Web Form. Add a DropDownList and a ListView control. The drop down list will contain a distinct list of vehicle types. When a user chooses one of the vehicle types the ListView will display all the vehicles of that type. Use a LINQ query to fill the DropDownList, and another to fill the ListView. Add error checking to the code. Make a separate error page to display any errors. Use CSS to style the pages.

What I am looking for

Practices are worth 1 point each.
Filling the DropDownList is worth 2 pts
Filling the View List is worth 5 points
Error checking and error page is worth 4 pts
The CSS is worth 1 point

The total is worth 20 pts

To Turn in

Paste your code into a Google doc and share it with spconger@gmail.com

ITC 172 Final Project

2011-11-23T14:11:00.001-08:00

Outcomes

Create basic programming structures

Create interactive web pages with data bound controls

Connect to databases with ADO

Understand and implement secure coding techniques

Research relevant programming techniques

Work Effectively in groups

The Project

This is best done in groups of 3 or 4

Create a web application for Automart Customers.

The main page should have a banner for automart, and should show all the locations and their addresses. It should also advertise all the services available.Registered customers should be able to log in, choose a vehicle and see all the services that have been provided for that vehicle. If a customer is not registered, it should allow them to register themselves and their vehicle.

You can use any of the tools and techniques we have used in the assignments. The project should contain at least one control or technique we haven't looked at in class. Research it through books or the web and note where you got your information (in a comment in the code)

Use CSS to Style the application. I will not judge on the quality of the styling--only that you have attached a style sheet and used some of the styles.

Keep minutes for your group that list who contributes what to the project

What I am looking For

Presenting locations and addresses from Database 5pts
Presenting Automart Services offered from Database 5pts
Customer login 5 pts
Returning Vehicle services 5pts
Registering new Customer and vehicle 10 pts
New control or technique 10 pts
Css Stylsheet and styling 5 pts
Participation in group 5 pts

The total project is worth 50 points

What to turn in.

Paste the markup, CSS, and C# into a Google doc and share with spconger@gmail.com. I will also sit with each group and review the completed project

ITC 172 Assignment Four

2011-11-23T13:10:00.001-08:00

Outcomes

Make interactive Web pages with Data bound controls

Understand and implement secure coding techniques

Research relevant programming techniques

Practices

1. Given a DataSet named ds. Write the code that would bind it to a DataViewGrid control.

2. You have made a web reference to a service that provides the capital of any state. You have named it StateCapitalService. It has a method GetCapital(string state). Write the code that would invoke this method and display its results.

Programming

Open a new ASP.Net Web Application.

Go to http://www.webservicex.net/WS/wscatlist.aspx Click on the link for "Standards and Lookup Data", then scroll down to "USA Zip Code Information." Add a Web Reference to this Service. Use the Method "Get Info By City." This returns a DataSet of all the zip codes in a given city. You will need a text box to get the name of the city. Invoke the method and bind the DataSet to a ViewGrid

Add a second web service of your choice and display the results

Take a look at this modification of the assignment. You must load the results of the zip code web service into an XML file before you can load it into the DataSet.

What I am looking for

The first practice is worth 2 points
The second practice is worth 3 points
In the programming assignment adding the web service 3 pts
Creating the form for input and output 2 pts
Calling the method 2 pts
Binding the resulting DataSet to the View Grid 3 pts
Adding, invoking and displaying a second web service 5 pts

The whole is worth 20 pts

To turn in

Copy the c# code into a Google Doc and share with spconger@gmail.com

ITC 172 Assignment Three

2011-11-23T12:55:00.001-08:00

Outcomes

Connect to databases with ADO

Make interactive Web pages with Data bound controls

Understand and implement secure coding techniques

Practices

1. Show the code to create and instantiate a new ADO connection object that connects to a database named MagazineTracker using integrated security.

2. Show the code to create and instantiate a New ADO connection that connects to a database named MagazineTracker using SQL authentication with a username of "salesperson" and a password of "P@ssw0rd1"

3. Create a new SQL command object that gets all the data from the table Magazine.

4. Create the code to retrieve the data from the Magazine table and store it in a dataset. Bind the dataset to a ViewGrid

5. Use Css to Style a ViewGrid

Programming

Create a new empty web site. Add A Web Form and a Style Sheet.Use ADO programming objects to connect to the Automart Database and return a list of locations with their addresses.

Use Css to Style the ViewGrid.

What I am looking for

Practices are worth 1 point each
Using the ADO programming Objects to connect to the database 5 pts
Using the ADO programming objects to return data 5pts
Binding the data to the View Grid 3 pts
Using the CSS to style the ViewGrid 2 pts

The total is worth 20 points

To turn in

copy all the markup code, C# and CSS into a Google doc and share it with spconger@gmail.com

Color Change Code

2011-11-21T17:23:00.001-08:00

Here is the code for changing color


 private void button1_Click(object sender, RoutedEventArgs e)
  {
        
     label1.Background = new LinearGradientBrush(Colors.DarkSlateBlue, 
Colors.SkyBlue, 45);
     label1.Foreground = new SolidColorBrush(Colors.White);
     this.Background = new LinearGradientBrush(Colors.Gold, 
Colors.Silver, 30);
  }

Styling ASP.Net with CSS

2011-11-21T14:19:00.001-08:00

With ASP.Net you can set control properties to get colors and effects you want, but it is generally a better idea to use CSS to style your pages.

Setting the properties results in an inline style in the rendered HTML. This works and it is legal, but it it makes for a very hard to maintain web site. When you use in-line styles, it means if you want to change your sites look, you have to go to every single page and modify its controls separately. On the other hand, if you use CSS, you can change the whole look of a web site by editing just the one CSS file.

All web Controls render into xhtml before being displayed in the browser. So you can write CSS for the resulting xhtml objects rather than the ASP control itself. A GridView control, for instance, renders into a perfectly normal xhtml table. You can style it by styling the table elements. Below is an example of some CSS for styling a table that will apply to the DataGrid output. Note, it is not particularly sophisticated. It just shows the basics:


th
{
 font-weight:bold;
 color:White;
 background-color:Navy;
 border:solid,2px,White;
 padding-left:5px;
 padding-right:5px;
 
}

td
{
 border:solid,2px,Black;
 padding-left:5px;
 padding-right:5px;
}

Here is a picture of the styled table

You can also assign a CSS class to the cssStyle attribute of any ASP.Net control. Here is a simple Css class


.textback
{
 background-color:Teal;
}

Here is the ASP markup for applying the style


 <asp:TextBox ID="TextBox1" runat="server" CssClass="textback"></asp:TextBox>

Here is what it looks like when running

ITC 220 SQL

2011-11-21T12:07:00.001-08:00

Here is the SQL we did in class


Use CommunityAssist

--basic Select statement

Select FirstName, LastName
From Person

/*This is a quick way but
your can't choose the
order the columns*/

 Select * From Person

--aliasing field names
Select FirstName as [First Name], lastName as [Last Name]
From Person 

--returns only unique instances
Select Distinct EmployeeKey from Donation

--Calulations
Select DonationKey, DonationDate, DonationAmount, 
DonationAmount *.9  as Charity, DonationAmount * .1 as maintainance
From Donation

--ordering the output
Select DonationKey, DonationDate, DonationAmount, 
DonationAmount *.9  as Charity, DonationAmount * .1 as maintainance
From Donation
Order by DonationDate, DonationAmount Desc

--where Clause
Select * From PersonAddress
Where City='Kent'

Select DonationKey, donationDate, donationAmount
From Donation
Where DonationAmount > 500

-- >, <, >=, <=, !=

--like searches for patterns 
--% any number of characters
--_one character
Select * From Person where LastName Like 'Tan%'

Select * From Donation 
Where DonationDate between '3/15/2010' and '4/15/2010'

--use is with nulls
Select * From PersonAddress Where Apartment is Not Null

Select * from PersonAddress where City ='Bellevue' or City = 'Kent'

Select * From PersonAddress Where Apartment 
is not null and  not City  = 'Seattle'

--scalar functions are in line functions

Select Distinct MONTH(DonationDate) From Donation
Select DAY(DonationDate) From Donation
Select YEAR(DonationDate) from Donation

Select DATEDIFF(dd, '11/21/2011','5/1/2012')

--aggregate functions work accross multiple rows

Select COUNT(Personkey) from Person
Where LastName Like 'B%'

Select MAX(DonationAmount) From Donation

Select MIN(DonationAmount) From Donation

Select SUM(DonationAmount) From Donation

Select AVG(donationAmount) from Donation


Select Month(DonationDate) as Month,
SUM(DonationAmount) as total
From Donation
Group by MONTH(donationDate)

Select EmployeeKey, 
SUM(DonationAmount) as total
From Donation
Group by EmployeeKey

Select EmployeeKey, 
SUM(DonationAmount) as total
From Donation
Group by EmployeeKey
Having SUM(donationAmount) > 2000

--Join

Select lastName, firstname, Street, City, [State],Zip
From Person 
Inner Join PersonAddress
On Person.PersonKey=PersonAddress.PersonKey

--tables aliased
Select lastName, firstname, Street, City, [State],Zip
From Person p
Inner Join PersonAddress pa
On p.PersonKey=pa.PersonKey

Select lastName, firstname, Street, City, [State],Zip, ContactInfo as HomePhone
From Person p
Inner Join PersonAddress pa
On p.PersonKey=pa.PersonKey
Inner Join PersonContact pc
on p.PersonKey=pc.PersonKey
Where ContactTypeKey=1

--Insert update Delete

Insert into Person(LastName, FirstName)
Values('Blackmore','John'),
('More', 'Black')


Select * From Person

Update Person
Set LastName='BlueBeard',
FirstName='Jake'
Where PersonKey=53

Begin tran

Update Person
Set FirstName='Jason'
Where PersonKey=1

rollback tran
commit Tran

Delete from Person
Where PersonKey=52

Morning Mileage WPF (2)

2011-11-17T12:21:00.001-08:00

Here is the Windows.Xaml.cs file


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace MileageMorningWpf
{
    /// 
    /// Interaction logic for MainWindow.xaml
    /// 

    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void btnCalculate_Click(object sender, RoutedEventArgs e)
        {
            GetMileage();
        }

        private void GetMileage()
        {
            Mileage m;
            double begMiles;
            double endMiles;
            double gals;
            double price;

            bool x = double.TryParse(txtBeginningMiles.Text, out begMiles);
            bool y = double.TryParse(txtEndingMiles.Text, out endMiles);
            bool z = double.TryParse(txtGallons.Text, out gals);
            bool a = double.TryParse(txtPricePerGallon.Text, out price);

            if (x == false || y == false)
            {
                MessageBox.Show("Mileage must be a real number");
                txtBeginningMiles.Clear();
                txtEndingMiles.Clear();
                txtBeginningMiles.Focus();
                return;

            }
            if (z == false)
            {
                MessageBox.Show("Gallons must be a real number");
                txtGallons.Clear();
                txtGallons.Focus();
                return;

            }
            if (a == false)
            {
                MessageBox.Show("Price must be in numbers. No $ signs");
                txtPricePerGallon.Clear();
                txtPricePerGallon.Focus();
                return;

            }

            try
            {
                m = new Mileage(begMiles, endMiles, gals, price);

                lblMilesPerGallon.Content = "Your Mileage is: " + m.CalculateMilesPerGallon().ToString("F2");

                if (m.CalculateMilesPerGallon() > 50)
                    lblMilesPerGallon.Background = new SolidColorBrush(Colors.Green);
                else if (m.CalculateMilesPerGallon() > 30)
                    lblMilesPerGallon.Background = new SolidColorBrush(Colors.Yellow);
                else
                    lblMilesPerGallon.Background = new SolidColorBrush(Colors.Red);

                lblTotalPrice.Content = "The cost for the gallons is " + m.TotalCost().ToString("c");
            }//end try
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }//end catch
            
        }//end GetMileage
    } //end class
}//end namespace

Here is the Mileage.cs class

ITC 172 Assignment Two

2011-11-17T09:21:00.001-08:00

Practices

1. Write a method that gets an integer from a text box and returns the cube of that number

2. Have three buttons share the same click event. In the event get the text of the button and display it on a label. (Just give me the code for the event)

3. Write the code to store a the value of a variable of type double in a Session.

4. Write the code to retrieve the variable in 3 from the session.

5. Write a method to clear a text box.

6. Create a simple HTML table with two columns and 3 rows

Programming Assignment

One of my students was asked to write a calculator in ASP.Net for a job interview. She was unsure how to do it. I want to make sure you will know how.

Create a calculator that has the 10 number keys (make each number key a button. All 10 keys should share the same event.)

The calculator should have 4 functions: Addition, Subtraction, Multiplication, and Division. When you click one of the four operators above, the program should store the number that was in the text box and clear it to make it ready for the next entry. It will also need to store the operator.

There should be a calculate or "=" button that does the operation whether add, subtract, multiply or divide and returns the result to the textbox. The calculator should also have a clear button to clear the textbox.

I would suggest using an html table to arrange the calculator.

You can add a style sheet to refine the display.

What I am looking for

Each practice is worth 1 pt
in the Programming Assignment Form layout 3pts
using one method to handle all the numeric buttons 2 pts
Saving temporary variables in session states 2pts
Addition multiplication and subtraction 3 pts (1 pt each)
Division, with division by zero handling 2 pts
Clear button 1 pt

the total is worth 20 points

What to turn in

Post all the html asp and c# code in a Google doc and share it with spconger@gmail.com

ITC 172 Assignment One

2011-11-17T09:17:00.001-08:00

Outcomes

Create basic programming structures

Create interactive web pages with data bound controls

Practices

In each of these, provide the code snippet requested by the question. You do not have to provide the whole project and surrounding code.

1. Define an array that has the values "red, green, blue, yellow, white, black and brown"

2. Write the code that binds the array in one to a DropDownList.

3. Write the code to retrieve the text of the selected item from the DropDownlist

4. Add a calendar control to a web page, a button, and a label. Write the code so that when you click the button the current date shows in the label.

5. Write the code that would redirect the user to a second web page if they click a button.

6. Make an external style sheet that sets the color of the h2 element to Green. Attach the style sheet to the Web Form. (show the style sheet entry for h2, and the html for attaching the style sheet).

7. Write the code to pass the variables in a http Get

8. Write the coed to retrieve variables from an http Get string

Programing Assignment

Create a web form for Students to sign up for counseling appointments. It should have a calendar control. It should also have a drop down list that is bound to an array with the following elements : Class Selection, Degree audit, Initial interview, personal issues. The user should enter their name, choose the reason for the visit from the DropDownList and select a date from the Calendar. When they click the button to make an appointment, you should check to makes sure all three elements are there, then pass them to a second page which shows their name, the Date, the type of appointment requested and confirms the appointment.

What I am looking for

The practices are worth 1 point each

In the assignment:
the array----2pts
binding the array to the drop down list control---2pts
Getting the selected date from the calendar--1pt
Passing the information to the second page---2pts
Displaying the information on the second page--2pts
A working web app--3pts

The whole thing is worth 20 points

What to turn in

Use your school google docs account or a personal google docs account and copy all the code, the html/asp markup and the C# into a document. Share it with spconger@gmail.com. I will write comments and grades on the document.

Mileage Class with form and validation

2011-11-16T19:12:00.001-08:00

Here is the Code for the form


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace MileageWPF
{
    /// 
    /// Interaction logic for MainWindow.xaml
    /// 

    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void btnCalculate_Click(object sender, RoutedEventArgs e)
        {
            //call the method to process the mileage
            ProcessMileage();
        }

        private void ProcessMileage()
        {
            

            Mileage m;
            double begMiles;
            double endMiles;
            double gals;
            double price;
            //we switched to try catches to stop mis-entry from crashing t\
            //the progam
            bool x = double.TryParse(txtBeginningMiles.Text, out begMiles);
            bool y = double.TryParse(txtEndingMiles.Text, out endMiles);
            bool z= double.TryParse(txtGallons.Text, out gals);
            bool a = double.TryParse(txtPricePerGallon.Text, out price);
            // this also checks to see if the value of gallons is 0
            if (z == true && gals <= 0)
            {
                MessageBox.Show("I am sure you used more than" + gals.ToString() + " gallons");
                return;
            }

            if (x && y && z && a)
            {
                //if they are all valid numbers
                try
                {
                    //try this code
                    m = new Mileage(begMiles, endMiles, gals, price);
                }
                catch (Exception ex)
                {
                    //if there are any errors catch them and display
                    //the error message
                    MessageBox.Show(ex.Message);
                    return;
                }
            }
            else
            {
                //this is the message if the fields are left
                //empty or don't contain real numbers
                MessageBox.Show("You must use real numbers");
                return;
            }

            lblMilesPerGallon.Content = "Your MPG is " + m.CalculateMilesPerGallon().ToString("F2");
            lblCostOfGas.Content = "Your Cost is " + m.TotalCost().ToString("c");

        }

        private void btnClear_Click(object sender, RoutedEventArgs e)
        {
            //call clear when the clear button is clicked
            Clear();
        }

        private void Clear()
        {
            //this method clears the form
            txtBeginningMiles.Clear();
            txtEndingMiles.Clear();
            txtGallons.Clear();
            txtPricePerGallon.Clear();
            lblCostOfGas.Content = "";
            lblMilesPerGallon.Content = "";
            txtBeginningMiles.Focus();
        }
    }
}

Here is the Modified Mileage Class


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MileageWPF
{
    public class Mileage
    {
        //this class calculates 
        //Gas mileage and cost
        //fields
        private double beginningMiles;
        private double endingMiles;
        private double gallons;
        private double pricePerGallon;

        //we have 3 constructors
        public Mileage()
        {
            BeginningMiles=0;
            EndingMiles=0;
            Gallons=1;
            PricePerGallon=0;
        }

        public Mileage(double begMiles, double endMiles, double gals)
        {
            BeginningMiles = begMiles;
            EndingMiles = endMiles;
            Gallons = gals;
            PricePerGallon = 0;

        }

        public Mileage(double begMiles, double endMiles, double gals, double price)
        {
            //it is important to call the Properties
            //not the underlying fields
            BeginningMiles = begMiles;
            EndingMiles = endMiles;
            Gallons = gals;
            PricePerGallon =price;

        }

        #region Properties

        public double BeginningMiles
        {
            get { return beginningMiles; }
            set { beginningMiles = value; }
        }
               

        public double EndingMiles
        {
            get { return endingMiles; }
            set { endingMiles = value; }
        }
        
        public double Gallons
        {
            get { return gallons; }
            set {
                if (value <= 0)
                {
                    //we added some evaluation, we 
                    //created a Exception to handle
                    //gallon values of 0 or less
                    //we throw the exception back to the
                    //form to be handled
                    Exception ex = new Exception("You must have more than 0 Gallons");
                    throw ex;
                }
        
                gallons = value; 
            }
        }
       
         public double PricePerGallon
        {
            get { return pricePerGallon; }
            set { pricePerGallon = value; }
        }

#endregion

         private double TotalMiles()
         {
             return EndingMiles - BeginningMiles;
         }

         public double CalculateMilesPerGallon()
         {
             return TotalMiles() / Gallons;
         }

         public double TotalCost()
         {
             return Gallons * PricePerGallon;
         }

    }
}

Mileage with Forms Evening

2011-11-14T19:16:00.001-08:00

We imported the mileage class and created a wpf form to get the inputs and display the outputs

Here is a picture of the form running

Here is the XAMl for the windows form


<Window x:Class="MileageWindowsForm.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <Label Content="Enter the Beginning Mileage" 
Height="28" HorizontalAlignment="Left" Margin="43,33,0,0" 
Name="label1" VerticalAlignment="Top" />
        <TextBox Height="23" HorizontalAlignment="Right" 
Margin="0,33,161,0" Name="txtBeginningMileage" 
VerticalAlignment="Top" Width="120" />
        <Label Content="Enter Ending Mileage" 
Height="28" HorizontalAlignment="Left" Margin="43,71,0,0" 
Name="label2" VerticalAlignment="Top" />
        <TextBox Height="23" HorizontalAlignment="Right" 
Margin="0,70,161,0" Name="txtEndingMileage" 
VerticalAlignment="Top" Width="120" />
        <Label Content="Enter Number of Gallons" Height="28" 
HorizontalAlignment="Left" Margin="43,110,0,0" 
Name="label3" VerticalAlignment="Top" />
        <TextBox Height="23" HorizontalAlignment="Right" 
Margin="0,110,161,0" Name="txtGallons" 
VerticalAlignment="Top" Width="120" />
        <Label Content="Enter the Price Per Gallon" Height="28" 
HorizontalAlignment="Left" Margin="43,153,0,0" Name="label4" 
VerticalAlignment="Top" />
        <TextBox Height="23" HorizontalAlignment="Right" 
Margin="0,153,161,0" Name="txtPricePerGallon" 
VerticalAlignment="Top" Width="120" />
        <Button Content="Calculate" Height="23" 
HorizontalAlignment="Left" Margin="50,193,0,0" 
Name="btnCalculateMileage" VerticalAlignment="Top" Width="75" 
Click="btnCalculateMileage_Click" />
        <Label Content="label for miles" Height="28" 
HorizontalAlignment="Left" Margin="174,189,0,0" Name="lblMilesPerGallon" 
VerticalAlignment="Top" Width="205" />
        <Label Content="Label for Price" Height="28" 
HorizontalAlignment="Left" Margin="174,223,0,0" Name="lblPrice" 
VerticalAlignment="Top" Width="210" />
    </Grid>
</Window>

Here is the code for Mainwindow.xaml.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace MileageWindowsForm
{
    /// 
    /// Interaction logic for MainWindow.xaml
    /// 

    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void btnCalculateMileage_Click(object sender, RoutedEventArgs e)
        {
            Mileage m = new Mileage();
            m.BeginningMiles = double.Parse(txtBeginningMileage.Text);
            m.EndingMiles = double.Parse(txtEndingMileage.Text);
            m.Gallons = double.Parse(txtGallons.Text);
            m.PricePerGallon = double.Parse(txtPricePerGallon.Text);

            double MPG = m.CalculateMilesPerGallon();
            double totalCost = m.TotalCost();

            lblMilesPerGallon.Content = "Your MPG is " + MPG.ToString("F2");
            lblPrice.Content = "The total cost is " + totalCost.ToString("c");
        }
    }
}

Here is the Mileage Class again. It is totally unchanged from the previous console.Examples


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MileageWindowsForm
{
    public class Mileage
    {
        //fields
        private double beginningMiles;
        private double endingMiles;
        private double gallons;
        private double pricePerGallon;

        public Mileage()
        {
            beginningMiles=0;
            endingMiles=0;
            gallons=0;
            pricePerGallon=0;
        }

        public Mileage(double begMiles, double endMiles, double gals)
        {
            beginningMiles = begMiles;
            endingMiles = endMiles;
            gallons = gals;
            pricePerGallon = 0;

        }

        public Mileage(double begMiles, double endMiles, double gals, double price)
        {
            beginningMiles = begMiles;
            endingMiles = endMiles;
            gallons = gals;
            pricePerGallon =price;

        }

        #region Properties

        public double BeginningMiles
        {
            get { return beginningMiles; }
            set { beginningMiles = value; }
        }
               

        public double EndingMiles
        {
            get { return endingMiles; }
            set { endingMiles = value; }
        }
        
        public double Gallons
        {
            get { return gallons; }
            set { gallons = value; }
        }
       
         public double PricePerGallon
        {
            get { return pricePerGallon; }
            set { pricePerGallon = value; }
        }

#endregion

         private double TotalMiles()
         {
             return EndingMiles - BeginningMiles;
         }

         public double CalculateMilesPerGallon()
         {
             return TotalMiles() / Gallons;
         }

         public double TotalCost()
         {
             return Gallons * PricePerGallon;
         }

    }
}

Java Equivalent of ITC 110 Assignment 6

2011-11-09T14:09:00.000-08:00

Here is the code for the BMI Class



public class BMI {

 /**
  * This class calculates Body
  * Mass Index
  */
 //fields
 private int weight;
 private int feet;
 private int inches;
 private int totalHeightInInches;
 
 //constructors
 public BMI(){
  weight=0;
  feet=0;
  inches=0;
  totalHeightInInches=0;
 }
 
 public BMI(int weightInPounds, int heightInFeet, int additionalInches)
 {
  SetWeight(weightInPounds);
  SetHeightInFeet(heightInFeet);
  SetRemainingInches(additionalInches);
  totalHeightInInches=0;
 }
 
 //mutators and accessors
 public void SetWeight(int w)
 {
    weight=w;
 }
 
 public int GetWeight()
 {
  return weight;
 }
 
 public void SetHeightInFeet(int ft)
 {
  feet=ft;
 }
 
 public int GetHeightInFeet()
 {
  return feet;
 }
 
 public void SetRemainingInches(int inch)
 {
  inches=inch;
 }
 
 public int GetRemainingInches()
 {
  return inches;
 }
 
 //methods
 
 private void CalculateTotalHeightInInches()
 {
  totalHeightInInches=(feet*12)+inches;
 }
 
 public double CalculateBMI()
 {
  CalculateTotalHeightInInches();
  return (double)GetWeight() * 703/(double)
    (totalHeightInInches * totalHeightInInches);
 
 }
 
 public String BMIEvaluation(){
  double b = CalculateBMI();
  String eval="";
  if (b > 30)
   eval="Obese";
  else if (b >24.9)
   eval="Overweight";
  else if (b > 18.4)
   eval="Normal";
  else
   eval="Underweight";
  
  return eval;
   
 }
 
 
 
}

Here is the program class with the main. You could make a display class that is called by the main. That would be a better structure, but I did not specify that as a requirement


import java.util.Scanner;
public class Program {

 /**
  * @param args
  */
 public static void main(String[] args) {
  Scanner scan=new Scanner(System.in);
  
  System.out.println("Enter your wieght in pounds");
  int lbs = scan.nextInt();
  
  System.out.println("enter your height in feet");
  int ft = scan.nextInt();
  
  System.out.println("enter any Remaining inches");
  int inch = scan.nextInt();
  
  BMI bmi = new BMI(lbs, ft, inch);
  double b = bmi.CalculateBMI();
  
  System.out.println("Your BM! is " + b);
  String badNews=bmi.BMIEvaluation();
  System.out.println(badNews);

 }

}

Here is the output



Enter your wieght in pounds
180
enter your height in feet
5
enter any Remaining inches
10
Your BM! is 25.824489795918367
Overweight

Model View Control (MVC)

2011-11-08T14:28:00.000-08:00

Overview

Model View Control is an object oriented programming pattern. It consists of three parts. (Each part can consist of more than one class.). The pattern has the advantage of clearly separating responsibilities and concerns.

Model

The model's responsibility is connecting to and dealing with data. This can be done with LINQ, as in our example, or with Data Entities or with classic ADO.Net

Controller

The controller acts as an intermediary between the data and the display of the data in a view

View

The view consist of html designed to display the data

The Tutorial

Open Visual Studio and select New Project. Select ASP. MVC 2 Web Project

Go ahead and create a test project, though we will not be looking at it right now

You will end up with the following in your Solution pane

In the code window you have the code for the Home Controler


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace VehicleMVC.Controllers
{
    [HandleError]
    public class HomeController : Controller
    {
        public ActionResult Index()
        {
            ViewData["Message"] = "Welcome to ASP.NET MVC!";

            return View();
        }

        public ActionResult About()
        {
            return View();
        }
    }
}

We will ignore it for now

First we will build the model.

Right Click on the model folder and from the context menu choose Add, New. Select "Data" in the object dialog and then "Linq to SQL classes"

Name the Linq to SQL "Vehicles.dbml" and click OK

If it is not open already, from the View menu select "Server Explorer"

If you do not have an existing connection to Automart Database, add one. If you do have a connection you can skip the next 3 steps

Right click on Data Connections and select Add Connection

Choose SQL Server for a data source

Type "Localhost" for the name of the server and select "Automart" as the database

Press OK

Expand the node for the new connections. Expand Tables. Locate the table Vehicles and drag it onto the designer

Save the Designer

In the Solutions pane, right click on the Controller folder and select Add controller. Name it "VehicleController."

Add the following using line to the top. It connects the controller with the data model


using VehicleMVC.Models;

Change the method name to VehicleView and then add code as shown below


        public ActionResult VehicleView()
        {
           VehiclesDataContext dc = new VehiclesDataContext();
           var cars = from v in dc.vehicles
                      orderby v.VehicleYear
                      select v;
            return View(cars);
        }

Right click in the method and select Add View

Add a page directive on the view to import the data model


<%@ Import Namespace="VehicleMVC.Models" %>

Modify the content 2 section. Add this foreach loop


<h2>Vehicles Served</h2>
    <ul>
    <%foreach (vehicle v in (IEnumerable)ViewData.Model)
      { %>
      <li><%= v.LicenseNumber%> | <%= v.VehicleMake%> | <%= v.VehicleYear%></li>
      <%} %>
    </ul>

The whole page looks like this


<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" %>
<%@ Import Namespace="VehicleMVC.Models" %>

<asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
 VehicleView
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <h2>Vehicles Served</h2>
    <ul>
    <%foreach (vehicle v in (IEnumerable)ViewData.Model)
      { %>
      <li><%= v.LicenseNumber%> | <%= v.VehicleMake%> | <%= v.VehicleYear%></li>
      <%} %>
    </ul>

</asp:Content>

Now we will modify the main master page to add a new tab and display the view

find and open the Site.Master under Views/Shared in the Solution Explorer

In the site master under the div "menucontainer" add another list item so that the menu looks like this


 <div id="menucontainer">
            
     <ul id="menu">              
          <li><%= Html.ActionLink("Home", "Index", "Home")%></li>
          <li><%= Html.ActionLink("About", "About", "Home")%></li>
          <li><%= Html.ActionLink("Vehicles","VehicleView","Vehicle") %></li>
      </ul>
            
 </div>

The first item is the text for the tab, the second the name of the view file, the third the folder it is in.

Run the program. It can take quite awhile to compile the first time

If all goes well (an unlikely event) you should see the following web page

Click the vehicle tab and you should see the vehicles listed by year

Mileage Classes Morning

2011-11-08T11:56:00.000-08:00

Program.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MileageClassExample
{
    class Program
    {
        static void Main(string[] args)
        {
            Display d = new Display();
        }
    }

}

Display.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MileageClassExample
{
    class Display
    {
        Mileage m;

        public Display()
        {
            m = new Mileage();
            GetInputs();
            DisplayOutputs();
            PauseIt();
        }

        private void GetInputs()
        {
            Console.WriteLine("This program calculates Mileage");
            Console.WriteLine("*****************************");

            Console.WriteLine("Enter the Beginning Mileage");
            m.BeginningMiles = double.Parse(Console.ReadLine());

            Console.WriteLine("Enter the Ending Mileage");
            m.EndingMiles = double.Parse(Console.ReadLine());

            Console.WriteLine("Enter the Gallons");
            m.Gallons = double.Parse(Console.ReadLine());

            Console.WriteLine("Enter the Price per gallon");
            m.PricePerGallon = double.Parse(Console.ReadLine());

        }

        private void DisplayOutputs()
        {
            Console.WriteLine("***********************");
            Console.WriteLine("Your Miles Per Gallon is {0:F2}", 
                m.CalculateMilesPerGallon());
            Console.WriteLine("You paid {0:C}", m.TotalCost());
        }

        private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }//end PauseIt
    }
}

Mileage.cs


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MileageClassExample
{
    public class Mileage
    {
        //fields
        private double beginningMiles;
        private double endingMiles;
        private double gallons;
        private double pricePerGallon;

        public Mileage()
        {
            beginningMiles=0;
            endingMiles=0;
            gallons=0;
            pricePerGallon=0;
        }

        public Mileage(double begMiles, double endMiles, double gals)
        {
            beginningMiles = begMiles;
            endingMiles = endMiles;
            gallons = gals;
            pricePerGallon = 0;

        }

        public Mileage(double begMiles, double endMiles, double gals, double price)
        {
            beginningMiles = begMiles;
            endingMiles = endMiles;
            gallons = gals;
            pricePerGallon =price;

        }

        #region Properties

        public double BeginningMiles
        {
            get { return beginningMiles; }
            set { beginningMiles = value; }
        }
               

        public double EndingMiles
        {
            get { return endingMiles; }
            set { endingMiles = value; }
        }
        
        public double Gallons
        {
            get { return gallons; }
            set { gallons = value; }
        }
       
         public double PricePerGallon
        {
            get { return pricePerGallon; }
            set { pricePerGallon = value; }
        }

#endregion

         private double TotalMiles()
         {
             return EndingMiles - BeginningMiles;
         }

         public double CalculateMilesPerGallon()
         {
             return TotalMiles() / Gallons;
         }

         public double TotalCost()
         {
             return Gallons * PricePerGallon;
         }

    }
}

More Classes

2011-11-07T19:02:00.000-08:00

Here are the classes we did for the evening session.

Program.cs



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MultiClassExample
{
    class Program
    {
        static void Main(string[] args)
        {
            Display dis = new Display();
            //Mileage m = new Mileage();


            //m.BeginningMiles = 1000;
            //m.EndingMiles = 1450;
            //m.Gallons = 25;
            //m.PricePerGallon = 3.71;

            //Console.WriteLine("Your miles per gallon are {0:F2}", m.MilesPerGallon());
            //Console.WriteLine("The cost per Mile is {0:C}", m.CostPerMile());

            //Mileage m3 = new Mileage(2000, 2400);
            //m3.Gallons = 20;
            //Console.WriteLine("The MPG is {0}", m3.MilesPerGallon());


            //Mileage m2 = new Mileage(12000, 12500, 25);
            //Console.WriteLine("The MPG is {0}", m2.MilesPerGallon());

            //Console.ReadKey();
        }
    }

    //I could write a new class right here
}

Display.cs



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MultiClassExample
{
    class Display
    {
        Mileage m; 

        public Display()
        {
            m = new Mileage();
            GetInputs();
            ShowOutputs();
            PauseIt();
        }

        private void GetInputs()
        {
            Console.WriteLine("This program calculates MPG");

            Console.WriteLine("Enter the Beginning Miles");
            m.BeginningMiles = double.Parse(Console.ReadLine());

            Console.WriteLine("Enter the Ending Miles");
            m.EndingMiles = double.Parse(Console.ReadLine());

            Console.WriteLine("Enter the Gallons");
            m.Gallons = double.Parse(Console.ReadLine());

        }

        private void ShowOutputs()
        {
            Console.WriteLine("the Miles perGallon is {0}", m.MilesPerGallon());
        }

        private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }//end PauseIt

    }
}

Mileage.cs



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MultiClassExample
{
    public class Mileage
    {
        //fields
        double beginningMiles;
        double endingMiles;
        double pricePerGallon;
        double gallons;

        public Mileage()
        {
            beginningMiles=0;
             endingMiles=0;
            pricePerGallon=0;
            gallons=0;
        }

        public Mileage(double begMiles, double endMiles)
        {
            beginningMiles = begMiles;
            endingMiles = endMiles;
            pricePerGallon = 0;
            gallons = 0;
        }

        public Mileage(double begMiles, double endMiles, double gals)
        {
            beginningMiles = begMiles;
            endingMiles = endMiles;
            pricePerGallon = 0;
            gallons = gals;
        }
     
        #region Properties

        public double BeginningMiles
        {
            get { return beginningMiles; }
            set { beginningMiles = value; }
        }
        

        public double EndingMiles
        {
            get { return endingMiles; }
            set { endingMiles = value; }
        }
        

        public double PricePerGallon
        {
            get { return pricePerGallon; }
            set { pricePerGallon = value; }
        }
      

        public double Gallons
        {
            get { return gallons; }
            set { gallons = value; }
        }
        #endregion

        //methods
        private double GetTotalMileage()
        {
            return EndingMiles - BeginningMiles;
        }

        public double MilesPerGallon()
        {
            return GetTotalMileage() / Gallons;
        }

        public double CostPerMile()
        {
            return PricePerGallon / MilesPerGallon();
        }
            
    }
}

Normalization Practices

2011-11-07T11:19:00.000-08:00

Here is the diagram for the DVD.

This diagram reflects the process of going through Normal form 1, where we found and removed the multivalued attributes.Once removed they have many to many relationships with the main Entity, so we needed to create linking tables rejoin them. There are no functional dependencies or transient dependencies, so the diagram is already in normal form 3

Class Examples (Evening)

2011-11-02T19:01:00.000-07:00

Here is our Box class



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ClassExamples
{
    public class Box
    {
        //fields
        private double height;
        private double width;
        private double depth;

        //default constructor
       //a constructor has the same name
       //as the class and no return type
        public Box()
        {
            Height = 0;
            Width = 0;
            Depth = 0;
        }

       //overloaded constructor
        public Box(double h, double w, double d)
        {
            Height = h;
            Width = w;
            Depth = d;
        }
        
        #region properties

        public double Width
        {
            get { return width; }
            set { width = value; }
        }
        
       
        public double Depth
        {
            get { return depth; }
            set { depth = value; }
        }

        public double Height
        {
            get 
            {
                return height;
            }
            set
            {
                height = value;
            }
        
        }
        #endregion

        //class method 
        public double CalculateVolume()
        {
            return height * width * depth;
        }
    }
}

Here is the main class where we called the Box class and assigned properties



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ClassExamples
{
    class Program
    {
        static void Main(string[] args)
        {
            //Console.BackgroundColor = ConsoleColor.DarkMagenta;
            //Console.WriteLine("Hello");

            //initialize the new box class 
            //using the default constructor
            Box b = new Box();
            //set the property values
            b.Height = 5.1; //all use the set of the property
            b.Depth = 6;
            b.Width = 4;

            //call the method
            double volume = b.CalculateVolume();

            //these are using the get part of the properties
            Console.WriteLine("The volume of a box with a height of {0} and a width of {1} and a depth of {2} has a volume of {3} cubic feet", b.Height, b.Width, b.Depth, volume);

            //initialize a second Box instance
            //useing the overloaded constructor
            Box b2 = new Box(4, 5, 2);

            Console.WriteLine("The volume of box 2 is {0} cubic feet", b2.CalculateVolume());
           
            Console.ReadKey();


        }
    }
}

Assignment 5 Morning

2011-11-01T12:20:00.000-07:00

There are a few differences between this and the evening versions



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Assignment5
{
    class Program
    {
        const int SIZE= 50;
        int[] gameResults = new int[SIZE];
        int counter = 0;

        static void Main(string[] args)
        {
            Program p = new Program();
            p.StartGame();
            //Console.ReadKey();
        }//end main

        private void StartGame()
        {
            string choice = "y";
            do
            {
                int num = GetRandom();
                GetGuess(num);
                counter++;
                Console.WriteLine("do you want to play again (y/n)");
                choice = Console.ReadLine();
                choice = choice.ToLower();
            } while (choice.Equals("y"));
        }//end start game

        private int GetRandom()
        {
            Random rand = new Random();
            int number = rand.Next(1,1000);
            Console.WriteLine(number);
            return number;
        }//end get random

        private void GetGuess(int number)
        {
            int score;
            for (score = 10; score > 0; score--)
            {

                Console.WriteLine("Enter your guess between 1 and 1000");
                int guess = int.Parse(Console.ReadLine());

                if (guess > number)
                {
                    Console.WriteLine("Too high");
                }//end if
                else if (guess < number)
                {
                    Console.WriteLine("Too low");
                }//end else if
                else
                {
                    Console.WriteLine("Congratulations");
                    break;
                }//end else
            }//end for
            GetScores(score, number);
        }//end GetGuess

        private void GetScores(int gameScore, int num)
        {
            Console.WriteLine("Your current score is {0}", gameScore);
            if (gameScore == 0)
            {
                Console.WriteLine("the number was {0}", num);
            }//end if 

            gameResults[counter] = gameScore;
            int totalScore = 0;
            //totalScore = gameResults.Sum();
            for (int i = 0; i < SIZE; i++)
            {
                totalScore += gameResults[i];
            }//end for
            double averageScore = (double)totalScore / (counter + 1);
            Console.WriteLine("You have played {0} games", counter + 1);
            Console.WriteLine("the total score is {0}", totalScore);
            Console.WriteLine("the Average score is {0}",averageScore);
        }//end GetScores

    }//end class program
}//end namespace

Assignment five Evening

2011-10-31T19:16:00.000-07:00

Here is the code for assignment 5. This is not the only way to do it



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace GuessingGame
{
    class Program
    {
        int[] scoreArray = new int[50];
        int counter = 0;

        static void Main(string[] args)
        {
            Program p = new Program();
            string choice = "y";
            do
            {
                p.GetRandom();
                p.counter++;
                Console.WriteLine("Do you want to play again: y/n");
                choice = Console.ReadLine();
            } while (choice.Equals("y"));
           // Console.ReadKey();
        }

        private void GetRandom()
        {
            Random rand = new Random();
            int number = rand.Next(1, 1000);
            //Console.WriteLine(number);
            GetGuesses(number);
            
        }

        private void GetGuesses(int number)
        {
            int i;
            for (i = 10; i > 0; i--)
            {
                Console.WriteLine("Enter a guess between 1 and 1000");
                int guess = int.Parse(Console.ReadLine());

                if (guess > number)
                {
                    Console.WriteLine("Your guess is too high");
                }
                else if (guess < number)
                {
                    Console.WriteLine("Your guess is too low");
                }
                else
                {
                    Console.WriteLine("Congratulations");
                    break;
                 }
                
            }//end of for loop

            CalculateScores(i);
        }//end Guess

        private void CalculateScores(int score)
        {
            Console.WriteLine("Your current score is {0}", score);
            scoreArray[counter] = score;
            int totalScore = 0;
            for (int x = 0; x < 50; x++)
            {
                totalScore += scoreArray[x];
            }

            double averageScore = (double)totalScore / (double)(counter + 1);
            Console.WriteLine("Your have played {0} games", counter+1);
            Console.WriteLine("Your total score is {0} ", totalScore);
            Console.WriteLine("Your average score is {0} ", averageScore);
        }
    }
}

Java Equivalent to ITC110 Assignment 5

2011-10-31T14:43:00.000-07:00

Here is the java code



import java.util.Scanner;
public class GuessingGame {

 /**
  * This program presents a guessing game
  * where the computer randomly selects
  * a number between 0 and 1000
  * and the player gets 10 chances to guess
  * the player can play as many times
  * as he or she wants and the program
  * will list total wins and average score
  */
 int gameCounter=0;
 int[] scoreArray=new int[50];
 public static void main(String[] args) {
  //instantiate the class
  GuessingGame gg = new GuessingGame();
  //get the scanner
  Scanner reader = new Scanner(System.in);
  //initialize the variable for exiting
  int choice=1;
  //loop so the player can play until they choose
  //to quit
  do
  {
   //call the start of the game
  gg.Start();
  //increment the number of games
  gg.gameCounter++;
  System.out.println("Do you want to play again? 0 to quit");
  choice=reader.nextInt();
  
  }while (choice != 0);

 }
 
 private void Start()
 {
  //Call the method to get the random number
  double num=GetRandom();
  //the line below just for testing 
  //System.out.println((int)num);
  
  //cast the random number to an integer
  //and pass to the GetGuess method
  GetGuess((int)num);
 }
 
 private double GetRandom()
 {
  //Get the random number
  double number = Math.random()*1000;
  return number;
 }
 
 private void GetGuess(int number)
 {
  int score; //declare score counter
  Scanner reader = new Scanner(System.in);
  //loop backwards to keep score
  for(score=10; score > 0; score--)
  {
   System.out.println("Enter a quess between 0 and 1000");
   double guess=reader.nextDouble();
   
   //check the guesses
   if(guess > number)
    System.out.println("Your guess is too high");
   else if(guess < number)
    System.out.println("Your guess is too low");
   else
   {
    System.out.println("congratulations");
    break; //leave the loop if correct
   }
  }
  GetScores(score);//call the get scores method
 }
 
 private void GetScores(int score)
 {
  //output the current score
  System.out.println("Your current Score is " + score);
  //assign it to the scoreArray
  scoreArray[gameCounter]=score;
  //initialize the variable to get the totals
  int scoreTotal=0;
  //loop through the array to get the total

  for (int i=0;i<50;i++)
  {
   scoreTotal+=scoreArray[i];
  }
  //get the average casting it to a double to get decimal
  //pars
  double scoreAverage=(double)scoreTotal/(double)(gameCounter + 1);
  //pring out the results
  System.out.println("Your have played " + (gameCounter + 1) + "games");
  System.out.println("Your average score is " + scoreAverage);
 }

}

Here is a transcript of the console when the program is running



Enter a quess between 0 and 1000
500
Your guess is too low
Enter a quess between 0 and 1000
750
Your guess is too low
Enter a quess between 0 and 1000
875
Your guess is too high
Enter a quess between 0 and 1000
800
Your guess is too low
Enter a quess between 0 and 1000
850
Your guess is too high
Enter a quess between 0 and 1000
825
Your guess is too high
Enter a quess between 0 and 1000
812
Your guess is too low
Enter a quess between 0 and 1000
819
Your guess is too low
Enter a quess between 0 and 1000
822
Your guess is too low
Enter a quess between 0 and 1000

823
congratulations
Your current Score is 1
Your have played 1games
Your average score is 1.0
Do you want to play again? 0 to quit
1
Enter a quess between 0 and 1000
500
Your guess is too high
Enter a quess between 0 and 1000
250
Your guess is too low
Enter a quess between 0 and 1000
350
Your guess is too low
Enter a quess between 0 and 1000
425
Your guess is too low
Enter a quess between 0 and 1000
475
Your guess is too high
Enter a quess between 0 and 1000
450
Your guess is too high
Enter a quess between 0 and 1000
433
Your guess is too low
Enter a quess between 0 and 1000
444
Your guess is too high
Enter a quess between 0 and 1000
439
Your guess is too low
Enter a quess between 0 and 1000
441
Your guess is too high
Your current Score is 0
Your have played 2games
Your average score is 0.5
Do you want to play again? 0 to quit

0

MultiDimensional Arrays

2011-10-27T14:14:00.000-07:00

The simplest multidimensional array is a two dimensional array. You can think of a two dimensional array as a simple sort of table with columns and rows. The first dimension is the number of rows and the second dimension is the number of columns.

Here is an example of a two dimensional string array that keeps track of book titles and authors. It has 3 rows and 2 columns



 string[,] books = new string[3, 2];
           
            books[0, 0] = "War and Peace";
            books[0, 1] = "Tolstoy";
            books[1, 0] = "Lord of the Rings";
            books[1, 1] = "Tolkein";
            books[2, 0] = "Huckleberry Finn";
            books[2, 1] = "Twain";

Here is an example of a two dimensional array with 3 rows and 3 columns. Think of it as containing the height, width and length of a set of boxes


int[,] boxes = new int[3, 3];
            boxes[0, 0] = 4;
            boxes[0, 1] = 2;
            boxes[0, 2] = 3;
            boxes[1, 0] = 2;
            boxes[1, 1] = 2;
            boxes[1, 2] = 1;
            boxes[2, 0] = 3;
            boxes[2, 1] = 2;
            boxes[2, 2] = 5;

It is also possible to have arrays with more than two dimensions. Below is a three dimensional array.


int[, ,] space = new int[2, 2, 2];

            space[0, 0, 0] = 5;
            space[0, 0, 1] = 4;
            space[0, 1, 0] = 3;
            space[0, 1, 1] = 4;
            space[1, 0, 0] = 3;
            space[1, 0, 1] = 6;
            space[1, 1, 0] = 2;
            space[1, 1, 1] = 5;
            space[2, 0, 0] = 3;
            space[2, 0, 1] = 6;
            space[2, 1, 0] = 2;
            space[2, 1, 1] = 5;

Arrays can have more than 3 dimensions, but they rapidly get difficult to manage.

To display a multidimensional array, you access its indexes just as in an one dimensional array. Below is the full program that creates these arrays and displays all but the last one. If you would like a little chalange, you can add code to the display method to display the contents of the 3 dimensional array.



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MultidimensionalArrays
{
    class Program
    {
        static void Main(string[] args)
        {
            Program p = new Program();
            p.Display();
            Console.ReadKey();
        }

        private string[,] TwoDimensionalArray()
        {
            //define two dimensional Array
            //first number is number of rows
            //the second is number of columns
            string[,] books = new string[3, 2];
           
            books[0, 0] = "War and Peace";
            books[0, 1] = "Tolstoy";
            books[1, 0] = "Lord of the Rings";
            books[1, 1] = "Tolkein";
            books[2, 0] = "Huckleberry Finb";
            books[2, 1] = "Twain";

            return books;
        }

        private int[,] Another2DimensionalArray()
        {
            //think of an array that holds
            //the height, width, and length
            //of boxes
            //although it has 3 columns
            //it is still a two dimensional 
            //array
            int[,] boxes = new int[3, 3];
            boxes[0, 0] = 4;
            boxes[0, 1] = 2;
            boxes[0, 2] = 3;
            boxes[1, 0] = 2;
            boxes[1, 1] = 2;
            boxes[1, 2] = 1;
            boxes[2, 0] = 3;
            boxes[2, 1] = 2;
            boxes[2, 2] = 5;

            return boxes;

        }

        private int[, ,] ThreeDimensionalArray()
        {
            //think of 3 dimensionals as a cube
            //you can do more dimensions but it
            //gets beyond absurd
            int[, ,] space = new int[2, 2, 2];

            space[0, 0, 0] = 5;
            space[0, 0, 1] = 4;
            space[0, 1, 0] = 3;
            space[0, 1, 1] = 4;
            space[1, 0, 0] = 3;
            space[1, 0, 1] = 6;
            space[1, 1, 0] = 2;
            space[1, 1, 1] = 5;
            space[2, 0, 0] = 3;
            space[2, 0, 1] = 6;
            space[2, 1, 0] = 2;
            space[2, 1, 1] = 5;

            return space;
        }

        private void Display()
        {
            //you access the values in multidimensional arrays
            //just like regular ones, through their indexes

            string[,] mybooks = TwoDimensionalArray();
            Console.WriteLine("The second book is {0}, by {1}", 
                mybooks[1, 0], mybooks[1, 1]);
            Console.WriteLine("*********************************");
            // the loop below multiplies the contents
            //of the three columns together
            int[,] cubes = Another2DimensionalArray();
            int cubicInches = 0;
            for (int i = 0; i < 3; i++)
            {
                cubicInches = cubes[i, 0] * cubes[i, 1] * cubes[i, 2];
                Console.WriteLine("Box {0}, is {1} cubic inches", i+1, cubicInches);
            }
            Console.WriteLine("*********************************");
           
        }
    }
}

Midterm code

2011-10-26T09:01:00.000-07:00


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ExamExample
{
    class Program
    {
        const int SIZE = 50;
        static void Main(string[] args)
        {
            Program p = new Program();
            p.CreateArrays();
            p.PauseIt();
        }

       

        private void CreateArrays()
        { 
            int[] numbers= new int[SIZE];
            FillArray(numbers);

        }

        private void FillArray(int[] numbers)
        {
            Random rand = new Random();
            for (int i = 0; i < SIZE; i++)
            {
                numbers[i] = rand.Next(1, 100);
            }
            GetEvenNumbers(numbers);
        }

        private void GetEvenNumbers(int[] numbers)
        {
            int evenCount = 0;
            int oddCount = 0;

            for (int i = 0; i < SIZE; i++)
            {
                if (numbers[i] % 2 == 0)
                {
                    evenCount++;
                }
                else
                {
                    oddCount++;
                }

            }
            Console.WriteLine("There were {0} even numbers and {1} odd numbers", evenCount, oddCount);
           
        }

        private void PauseIt()
        {
            Console.WriteLine("\n\nPress any key to exit");
            Console.ReadKey();
        }

       
    }
}

Random

2011-10-25T12:07:00.000-07:00

Here is the random Function


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace RandomExample
{
    class Program
    {
        static void Main(string[] args)
        {
            Random rand = new Random();
            int number=rand.Next(1, 1000);

            Console.WriteLine(number);

            Console.ReadKey();
        }
    }
}

Assignment4 Morning Class

2011-10-25T12:04:00.001-07:00



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Assignment4Morning
{
    class Program
    {
        /// 
        /// This program calculates GPAs
        /// Based on grades and credits
        /// entered
        /// Steve Conger 10/25/2011
        /// 

      
        static void Main(string[] args)
        {
            Program p = new Program();

            string quit = "y";
            while (quit != "n")
            {
                p.CreateGPAArrays();
                Console.WriteLine("Continue y/n?");
                quit = Console.ReadLine();
               quit= quit.ToLower();
            }
            //Console.ReadKey();
        }//end main

        private void CreateGPAArrays()
        {
            Console.WriteLine("Enter how many grades you want to enter");
            int number = int.Parse(Console.ReadLine());

            double[] grades = new double[number];
            int[] credits = new int[number];

            FillGPAArrays(grades, credits);
        }//end Create

        private void FillGPAArrays(double[] grades, int[] credits)
        {
            for (int index = 0; index < grades.Length; index++)
            {
                double grade=0;
                
                do
                {
                    Console.WriteLine("enter grade");
                    grade = double.Parse(Console.ReadLine());
                    if (grade < 0 || grade > 4)
                    {
                        Console.WriteLine("Grades must be between 0 and 4");
                        
                    }
                } while (grade < 0 || grade > 4);
                grades[index] = grade;

                Console.WriteLine("enter Credits");
                credits[index] = int.Parse(Console.ReadLine());

            
            }//end for
            CalculateGPA(grades, credits);
        }//end Fill

        private void CalculateGPA(double[] grades, int[] credits)
        {
            double weight=0;
            int totalCredits = 0;

            for (int index = 0; index < grades.Length; index++)
            {
                weight += grades[index] * credits[index];
                totalCredits += credits[index];
            }

            //alternate way to sum credits
            //c# 4.0 and above only
            int total = credits.Sum();

            double gpa = weight / totalCredits;

            Console.WriteLine("Your GPA is {0}", Math.Round(gpa,1));
            
        }


    }//end class
}

Assignment 4

2011-10-24T19:11:00.000-07:00



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Assignment4
{
    class Program
    {
        static void Main(string[] args)
        {
            Program p = new Program();
            string quit = "y";
            while (quit != "n")
            {
                p.CreateArrays();
                Console.WriteLine("Do you want start over? n to quit");
               quit=Console.ReadLine();
                quit.ToLower();
            }
            Console.ReadKey();
        }

        private void CreateArrays()
        {
            Console.WriteLine("How many Grades do you want to enter");
            int number = int.Parse(Console.ReadLine());

            double[] grades = new double[number];
            double[] credits = new double[number];

            FillArrays(grades, credits);
            

        }

        private void FillArrays(double[] grades, double[] credits)
        {
            for (int counter = 0; counter < grades.Length; counter++)
            {
                double grade = 0;
                do
                {
                    Console.WriteLine("Enter a Grade");
                    grade = double.Parse(Console.ReadLine());
                    if (grade <= 0 || grade > 4)
                    {
                        Console.WriteLine("Grades must be between 0 and 4");
                    }

                } while (grade <= 0 || grade > 4);
                grades[counter]=grade;

                Console.WriteLine("Enter the Credits");
                credits[counter] = double.Parse(Console.ReadLine());
            }//end for
            CalculateGPA(grades, credits);
        }//end fill arrays

        private void CalculateGPA(double[] grades, double[] credits)
        {
            double totalCredits = 0;
            double weight = 0;

            for (int counter = 0; counter < grades.Length; counter++)
            {
                weight+=grades[counter] * credits[counter];
                totalCredits += credits[counter];
            }//end for

            
            
            double gpa = weight / totalCredits;

            Console.WriteLine("Your GPA is {0:F1}", gpa);
        }

    }//end class
}

and here is the code for doing random numbers



 static void Main(string[] args)
  {
            
            Random rand = new Random();
            int number = rand.Next(1, 10);
            Console.WriteLine(number);
            Console.ReadKey();

   }

Java Equivalent of ITC110 Assignment 4

2011-10-20T13:52:00.000-07:00

This is an assignment that deals with loops and arrays. It uses two array one for Grades and one for Credits. The purpose of the program is to calculate a GPA. The arrays are created in one method and then passed to another where they are filled in a for loop. Then they are passed to a third method where the arrays are multiplied together and summed to get the GPA.

Two other loops are added. One, a while loop in main, lets the user repeat the program as often as they wish. They enter 0 to exit. The other, a do loop, is used in the FillArrays method to make sure the grade is between 0 and 4. It will not allow the user to continue until they have entered a grade in the valid range. The grade is not written to the array until it is valid.

Here is the Java code



import java.util.Scanner;

public class GPACalculator {

 /**
  * This program calculates a GPA 
  * to do so it uses parallel arrays
  * one for grades and one for credits
  * it checks to make sure grades are
  * between 0 and 4
  * this program is the java equivalent
  * of ITC110 assignment 4
  * Steve Conger !0/20/2011
  */
 //declare the scanner globally
 Scanner reader = new Scanner(System.in);
 
 public static void main(String[] args) {
  GPACalculator calc=new GPACalculator();
  int choice=1;
  while(choice !=0)
  {
   calc.CreateArrays();
   System.out.println("Do you want to enter more grades: 0 to exit");
   choice=calc.reader.nextInt();
  }
  
 }
 
 private void CreateArrays()
 {
  
  System.out.println("How many grades do you want to enter?");
  int number=reader.nextInt();
  
  //declare the arrays
  double[] grades = new double[number];
  double[] credits=new double[number];
  
  //call the FillArrays method
  FillArrays(grades, credits);
 }
 
 private void FillArrays(double[] grades, double[]credits)
 {
  //loop through and fill the arrays)
  for(int i=0;i<grades.length; i ++)
  {
   //the do loop makes sure the grade is in 
   //the proper range
   double grade=0;
   do
   {
   System.out.println("Enter the grade");
   grade=reader.nextDouble();
   if(grade<0 || grade>4)
   {
    System.out.println("Grades must be between 0 and 4");
   }
   }while (grade<0 || grade>4);
   grades[i]=grade;
   System.out.println("Enter the credits");
   credits[i]=reader.nextDouble();
  }
  //call the CalculateGPA method
  CalculateGPA(grades, credits);
 }
 
 private void CalculateGPA(double[] grades, double[]credits)
 {
  double weight=0;
  double totalCredits=0;
  
  for(int i=0;i<grades.length; i ++)
  {
   weight += grades[i] * credits[i];
   totalCredits += credits[i];
  }
  
  double gpa = weight / totalCredits;
  System.out.println("Your GPA is " + gpa);
  
 }
 

}

Consuming a Simple Web Services

2011-10-19T14:57:00.000-07:00

This blog leads you through the process of consuming a simple web service. In it we will find a web service that provides global weather reports based on city and country and we will reference that web service in our own ASP.Net form and create our own little app that uses it.

Go to this url to get Free web services: http://www.webservicex.net/WS/wscatlist.aspx

Click on global weather

Click on get weather

Copy WSDL Schema Location http://www.webservicex.net/globalweather.asmx?WSDL

Open Visual Studio

Create a new website

Go to the Website menu,And select add web reference

Paste the schema location in the URL text box

Change the name of the web service name to net.globalweather.www

Add the web serviceadd a labels and textboxes for city name and country and a button and a label to the web form



<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h1>Global Weather</h1>
      <p> 
         <asp:Label ID="Label2" runat="server" Text="Enter City"> 
        </asp:Label><asp:TextBox ID="txtCity" runat="server"></asp:TextBox> 
      </p>
      <p>
        <asp:Label ID="Label3" runat="server" Text="Enter Country">
        </asp:Label><asp:TextBox ID="txtCountry" runat="server"></asp:TextBox>
      </p>
      <p>
        <asp:Button ID="Button1" runat="server" Text="Get Weather" />
       </p>
       <p>
        <asp:Label ID="lblWeather" runat="server" Text="Label"></asp:Label>
        </p>
    </div>
    </form>
</body>
</html>

Double click the buttom in design mode to get to the C# code window

In the buttonI_click method enter the following code


 protected void Button1_Click(object sender, EventArgs e)
 {
     GlobalWeather gw = new GlobalWeather();
     string weather = gw.GetWeather(txtCity.Text, txtCountry.Text);
     lblWeather.Text = weather;
 }

Note how little code it takes to process this. The web service tells you when you add it that this method requires two string arguments (city and country) and that it returns a string. Some webservices can be more complex, but most are fairly straight forward to use

Here is a picture of the form running

Java Equivalent to C# Assignment 3

2011-10-18T12:58:00.001-07:00



package Income;
import java.util.Scanner;

public class NetIncomeCalculator {

 /**
  * This program calculates gross pay
  * and net pay given deductions in 
  * Social Security, medicare and a bus
  * pass. It uses else if statments
  * to determine the rate of deduductions
  * This is the equivalent of
  * Assignment three in C# in ITC 110
  * Steve Conger 10/18/2011
  */
 
 //declaring constants
 //final double SOCIALSECURITY = .09;
 //final double MEDICARE=.03;
 final int BUSPASS=25;
   
 public static void main(String[] args) {
  //declare and instantiate the class
  //to load it (main being static is
  //already loaded into memory
  NetIncomeCalculator netcalc = new NetIncomeCalculator();
  //call the starting method
  netcalc.Display();
 }
 
 private void Display()
 {
  //get input
  //the scanner is an object to read from the console
  Scanner reader = new Scanner(System.in);
  System.out.println("Enter the number of hours worked");
  double hours = reader.nextDouble();
  System.out.println("Enter your rate per hour");
  double rate=reader.nextDouble();
  
  //call the methods to do the calculations
  double grossPay=CalcIncome(hours, rate);
  double socialSec = CalcSocialSecurity(grossPay);
  double medicare = CalcMedicare(grossPay);
  double netPay=CalcNetPay(grossPay, socialSec, medicare);
  
  //outputs
  System.out.println("Your gross income is " + grossPay);
  System.out.println("Your Social Security deduction is " + socialSec);
  System.out.println("Your Medicare deduction is " + medicare);
  System.out.println("Your Bus pass deduction is " + BUSPASS/4);
  System.out.println("Your net pay is " + netPay);
 }
 
 private double CalcIncome(double hrs, double rt)
 {
  double gross=0;
  //check to see if the hours are more than forty
  //if they are pay time and a half for overtime
  //if not just pay the rate of pay
  if (hrs > 40)
  {
   gross=rt * (40 + ((hrs-40)*1.5));
  }
  else
  {
   gross = rt * hrs;
  }
  return gross;
 }
 
 private double CalcSocialSecurity(double gPay)
 {
  double ss =0;
  if (gPay >= 5000)
   ss=.4;
  else if (gPay >= 4000 )
   ss=.35;
  else if (gPay >=3000)
   ss=.25;
  else if (gPay >=2000)
   ss=.2;
  else if (gPay > 1000)
   ss=.12;
  else
   ss=.09;
  
  return gPay * ss;
 }
 
 private double CalcMedicare(double gPay)
 {
  double med=0;
  if (gPay >=5000)
   med=.2;
  else if (gPay >= 2000)
   med=.1;
  else
   med=.05;
  return gPay * med;
 }
 
 private double CalcNetPay(double gPay, double ss, double med)
 {
  return gPay - (ss + med + (BUSPASS/4));
 }

}

Morning Arrays and loops

2011-10-18T12:22:00.000-07:00



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ArraysAndLoops2
{
    class Program
    {
        /// 
        /// This program will create an array
        /// populate and array
        /// Display it
        /// sum and average the contents
        /// 

       
        static void Main(string[] args)
        {
            Program p = new Program();
            string choice="y";
            while (choice != "n" && choice != "N")
            {
                p.CreateArray();
                p.ParallelArrays();
                Console.WriteLine("Do you want enter more payments? Y/N");
                choice = Console.ReadLine();
            }
            Console.ReadKey();
        }

        private void CreateArray()
        {
            //double[] payments = new double[5];
            //payments[0] = 234.5;
            //payments[1] = 45.6;
            //payments[2] = 100;
            //payments[3] = 37.98;
            //payments[4] = 223;

            //int[] ray;
            //ray = new int[] { 45, 2, 3, 7, 22 };

            Console.WriteLine("How many payments do you want to enter");
            int number = int.Parse(Console.ReadLine());

            double[] payments = new double[number];

            for (int i = 0; i < number; i++)
            {
                Console.WriteLine(payments[i]);
            }//end for

            FillArray(payments, number);
        }//end create array

        private void FillArray(double[] paymnts, int size)
        {
            for (int i = 0; i < size; i++)
            {
                Console.WriteLine("Enter Payment");
                paymnts[i] = double.Parse(Console.ReadLine());
            }// end for
            DisplayArray(paymnts, size);
        }//end of Fill array

        private void DisplayArray(double[] pmts, int size)
        {
            Console.WriteLine("************************\n");
          
            //Console.Clear();
            for (int i = 0; i < size; i++)
            {
                Console.WriteLine(pmts[i]);
            }//end for
            SumAndAverage(pmts, size);
        }//end Display

        private void SumAndAverage(double[] pay, int size)
        {
            double total = 0;
            for (int i = 0; i < size; i++)
            {
                total += pay[i]; //total=total + pay[i] -= *= %= /=
            }
            Console.WriteLine("The total is {0}", total);
            double average = total / pay.Length;
            Console.WriteLine("the average is {0}", average);
        }//end sum and average

        private void ParallelArrays()
        {
            int[] myArray1 = new int[] { 2, 3, 54, 6, 8 };
            int[] myArray2 = new int[] { 3, 5, 2, 12, 4 };

            for (int i = 0; i < myArray1.Length; i++)
            {
                Console.WriteLine(myArray1[i] * myArray2[i]);
            }
        }

    }//end class
}

Loops and Arrays

2011-10-17T19:12:00.000-07:00


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ArraysAndLoops
{
    class Program
    {

        /*This program will have three methods
         * one to create an array
         * one to populate it
         * and one to display it
         */
        static void Main(string[] args)
        {
            Program p = new Program();
            string exit = "y";
            while (exit != "n" && exit !="N")
            {
                p.CreateArray();
                Console.WriteLine("Do you want to continue y/n");
                exit = Console.ReadLine();
            }
            p.PauseIt();
        }

        //this method
        //creates an array
        private void CreateArray()
        {

            Console.WriteLine("How many payments do you want to enter?");
            int number = int.Parse(Console.ReadLine());
            double[] payments= new double[number];

            FillArray(payments, number);

            //double[] pmts = new double[] { 12.95, 34, 21.4, 43 };
            //payments[0] = 255;
            //payments[1] = 34.5;
            //payments[2] = 44.5;
            //payments[3] = 34;
            //payments[4] = 34.5;


        }

        private void FillArray(double[] payArray, int size)
        {
            //for loop
            for (int i=0; i < size; i++)
            {
                Console.WriteLine("Enter a payment");

                payArray[i] = double.Parse(Console.ReadLine());
            }//end for
            DisplayArray(payArray, size); //call DisplayArrayMethod
           
        }//end fill array

        private void DisplayArray(double[] pmt, int size)
        {
            Console.WriteLine("***********************");
            int x = 0;
            while (x < size)
            {
                Console.WriteLine(pmt[x]);
                x++;

                /*
                 * +=  (number += 10) same as (number= number + 10);
                -= minus (number -=10) same as (number=number-10)
                -- decrement subtract one each time
                *= (number *=10) same as (number=number*10)
                %=(number %=10) same as (number=number%10)
                /=(number /=10) same as (number=number/10)
                  */
            }//end while
            Sum(pmt, size);
        } //end display

        private void Sum(double[] payment, int size)
        {
            double total = 0;
            for (int i = 0; i < size; i++)
            {
                total += payment[i];
                //weight = grades[i] * credits[i];
            }
            double average = total / size;
            Console.WriteLine("the total is {0}", total);
            Console.WriteLine("the Average is {0}",average);
        }

        private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }//end PauseIt



    }//end class
}

Arrays

2011-10-17T16:29:00.000-07:00

An array says your book, "represents a fixed number of elements of the same type." An array, for instance can be a set of integers or a set of doubles or strings. The set can be accessed under a single variable name.

You use square brackets [] to signify an array. The following declares an array of integers with 5 elements


int[] myArray=new int[5];

Each element in an array has an index number. We can use these indexes to assign or access values in an array. Indexes always begin with 0


myArray[0]=5;
myArray[1]=12;
myArray[2]=7;
myArray[3]=74;
myArray[4]=9;

Console.WriteLine("The fourth element of the array is {0}",myArray[3]);

Here is another way to declare an array. This declaration declares a string array and assigns the values at the moment when the array is created


string[ ] weekdays =new string[ ]
       {"Monday","Tuesday","Wednesday", "Thursday", "Friday", "Saturday", "Sunday"};

The values are still indexed 0 to 6

Array work naturally with loops. You can easily use a loop to assign values:



for (int i=0; i<size;i++)
{
     Console.WriteLine("Enter an Integer");
     myArray[i]=int.Parse(Console.ReadLine());

}

Arrays can be passed as a parameter to methods and they can be returned by a method.


private void CreateArray()
{
    double[ ] payments = new double[5];
    FillArray(payments, 5);
}

private void FillArray(double[ ] pmts, int size)
{
    int x=0;
   while (x < size)
  {
     Console.WriteLine("Enter Payment Amount");
     pmts[x]=double.Parse(Console.ReadLine());
     x++;
  }
}

Apps

2011-10-17T13:18:00.000-07:00

The term "app" is short for application, but it has come to have a special meaning when applied to mobile devices such as phones, mp3 players and tablets. To some extent, these apps, like the term, are abbreviated. They are streamlined to run on the limited resources of a phone or tablet. That isn't to say that some of them aren't quite complex, but no matter how sophisticated, they must run within the constraints of the device they are on.

The question is how important is it for a student to get into the app market, and, if it is important, what skills do they need to get a foot in the door.

Apps have become big business, just as a decade ago every company had to have a web site, now every company has to have an app on your phone. Apps are rapidly becoming the predominate way of accessing the internet.

In September 2010 Chris Anderson wrote an article for Wired called The Web is Dead, Long Live the Internet In it he said:

Over the past few years, one of the most important shifts in the digital world has been the move from the wide-open Web to semiclosed platforms that use the Internet for transport but not the browser for display. It’s driven primarily by the rise of the iPhone model of mobile computing, and it’s a world Google can’t crawl, one where HTML doesn’t rule. And it’s the world that consumers are increasingly choosing, not because they’re rejecting the idea of the Web but because these dedicated platforms often just work better or fit better into their lives (the screen comes to them, they don’t have to go to the screen). The fact that it’s easier for companies to make money on these platforms only cements the trend. Producers and consumers agree: The Web is not the culmination of the digital revolution.

And the shift is only accelerating. Within five years, Morgan Stanley projects, the number of users accessing the Net from mobile devices will surpass the number who access it from PCs. Because the screens are smaller, such mobile traffic tends to be driven by specialty software, mostly apps, designed for a single purpose. For the sake of the optimized experience on mobile devices, users forgo the general-purpose browser. They use the Net, but not the Web. Fast beats flexible.

http://www.wired.com/magazine/2010/08/ff_webrip/all/1

Sara Perez in Read Write Moblie notes:Native data applications, such as those installed on smartphones like the iPhone and devices running Android, now account for 50% of all mobile data volume according to a new report from Finnish mobile analytics company Zokem. In a global smartphone study released this month, the company found that while the mobile Web browser was still the most popular smartphone "app," the use of native apps outside the browser is growing faster than mobile browsing itself.

Cisco networks notes the following:

Global mobile data traffic grew 2.6-fold in 2010, nearly tripling for the third year in a row. The 2010 mobile data traffic growth rate was higher than anticipated. Last year's forecast projected that the growth rate would be 149 percent. This year's estimate is that global mobile data traffic grew 159 percent in 2010

Last year's mobile data traffic was three times the size of the entire global Internet in 2000. Global mobile data traffic in 2010 (237 petabytes per month) was over three times greater than the total global Internet traffic in 2000 (75 petabytes per month).

Mobile video traffic will exceed 50 percent for the first time in 2011. Mobile video traffic was 49.8 percent of total mobile data traffic at the end of 2010, and will account for 52.8 percent of traffic by the end of 2011.

http://www.cisco.com/en/US/solutions/collateral/ns341/ns525/ns537/ns705/ns827/white_paper_c11-520862.html

Companies are advertising for programmers to create apps. Typically they want people who can program for Apple's IOS and also for Android. Some also want Window's phone developers. Simply Hired had scores of listing for IPhone developer and nearly equal listings for Android developers. There were several listings for Windows phones as well.

The financial model for these apps is still developing. Many are free. They either generate no revenue for the app creator or they generate revenue by incorporating advertisements. Company based apps are usually free, the app itself being a form of advertising. Many other free apps are "lite" versions which encourage you to upgrade to a more feature rich version for a price. Some apps are sold at a 99 cent level. If an app takes off and is downloaded often enough this can add up to significant revenue. Other, usually serious productivity apps, such as Quick Office, charge comparatively large fees for download. But even these fees are miniscule compared to the prices of comparable software for the PC. An expensive app might be priced around 25 dollars, whereas its pc equivalent would be hundreds.

For a student, then there would seem to be two opportunities. One would be to work for a company that wants to build and distribute apps to support its business customers and processes. Another is to build their own apps and try to sell them in the app stores.

Skills Required to Create Apps

First let's consider what apps do:

They must use disk and memory resources efficiently since these are limited on mobile devices
They must surrender focus gracefully, especially on phones where they must recede to allow the phone call to take precedence.
They must thread processes to allow both foreground and background processing
They often store data locally for short terms (some for longer)
They usually read from and write to cloud data sources
They need to refresh on receiving focus
They usually keep the location and status of the user
Most apps listen for data and can pass alerts to the user
They need a simple, clear GUI
Many scale to the device with a different look on a phone than a tablet

Let's be clear, to develop apps a programmer still needs all the basic programming skills. He or she must know how to use programming structures such a selection, repetition and arrays. He or she must know how to create appropriate methods, etc. In addition they should have a good understanding of object oriented principles especially inheritance, since much mobile programming involves extending objects that are provided by the development kit.

Additionally, a developer should learn to thread applications, separating foreground and background operations. This is an important skill for surrendering focus to a phone call or another application

The developer should know how to find and access services, both on the phone and the cloud. These include the GPS services and various data services

Basic database skills for storing and retrieving data are also valuable.

Specific Platform requirements

IPhone| IPad| IPod

The tools for IOS development are only available on the MAC. IOS Apps are developed in Object C using XCode. All apps must be processed and approved by Apple and distributed through Apple's AppStore

Here is Apple's">Developer site

Here is an example of Objective C code for a hello world IPhone app

Android

The primary tools for Android are Java and xml through the Android SDK. There are several possible distributors for Android Apps, the largest of which is Google. You can also self distribute if you wish.

Here is the link to the Android Developers guide

Windows Phones

Windows phones use Silverlight with its XAML xml and C# or alternatively XBoxes XNA platform with C#.

Here is Microsoft's phone development site

It is also possible to create phone apps in all these platforms using HTML5. HTML5 apps are run through the phones browser. Microsoft has announced that its next OS, Windows 8 will work across hardware platforms and be based on HTML 5 and JavaScript. I am still unclear as to what that implementation will look like.

This is just a draft of the topic. I will try to expand on it more over time. Please feel free to comment and suggest additions or changes

Morning Class Selection statements

2011-10-11T12:02:00.001-07:00

Here is the code we did in class with comments



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace SelectionExamples
{
    class Program
    {
        /*******************
         * this program has examples of 
         * if statements including an embedded if
         * and an if else statement
         * steve Conger 10/11/2011 
         * ****************************/

        static void Main(string[] args)
        {
            Program prog = new Program();
            //prog.SimpleIf();
            prog.IfElseIfExample();
            prog.PauseIt();

        }

        private void SimpleIf()
        {
            //this is not so simple an if any more
            //declare an integer
            //this is assigned a value by the "out" parameter
            //two lines down
            int number = 0;
            Console.WriteLine("Enter an integer");

            //try parse returns true or false
            //true if the number can be converted to an integer
            //otherwise false. If it is true it passes the 
            //interger value "out" to the number variable
            //declared above
            bool isInteger = int.TryParse(Console.ReadLine(),out number);

            //below is an example of an imbedded if
            //if it is a good number test it 
            if (isInteger == true)
            {
                //never get to this if, if it is not a number
                if (number % 2 == 0)
                {
                    Console.WriteLine("the number is even");
                }
                else
                {
                    Console.WriteLine("the number is odd");
                }
            }
            else
            {
                Console.WriteLine("Not a valid number");
            }
        }

        private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }//end PauseIt

        private void IfElseIfExample()
        {
            Console.WriteLine("Enter a test score");
            int score = int.Parse(Console.ReadLine());

            string grade=null; //initializes the string though to nothing

            //below is an if, else if statement. It allows you to test 
            // a value against a sequence of ranges
            //it is important that the sequence be correct
            if (score >= 90)
            {
                grade = "A";
            }
            else if (score >= 80)
            {
                grade = "B";
            }
            else if (score >= 70)
            {
                grade = "C";
            }
            else if (score >= 60)
            {
                grade = "D";
            }
            else
            {
                grade = "F";
            }
            Console.WriteLine("your grade is {0}", grade);
        }//end if else if
        
    }//end Program

    
}

If statements

2011-10-10T18:56:00.000-07:00

Here is the code from the evening class




using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace IfExamples
{
    class IfStatements
    {
        static void Main(string[] args)
        {
            IfStatements ifs = new IfStatements();
            //ifs.SimpleIfStatement();
            //ifs.IfElseExample();
            ifs.SwitchExample();
            ifs.PauseIt();
        }//end main

        private void SimpleIfStatement()
        {
            Console.WriteLine("Enter an age");
            int age = int.Parse(Console.ReadLine());
           //equality ==
            //!= not equal

            if (age > 75)
            {
                Console.WriteLine("You are old");
            }
            else
            {
                Console.WriteLine("You are a spring chicken");
            }
        }//end SimpleIf

        private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();


        }//end PauseIt

        private void IfElseExample()
        {
            bool isInteger;
            int score;
            Console.WriteLine("Enter your test Score");
             isInteger= int.TryParse(Console.ReadLine(), out score);

             if (isInteger == false)
             {
                 Console.WriteLine("Next time enter a number");
                 return;
             }

            int grade = 0;

            if (score >= 90)
            {
                grade = 4;
            }
            else if (score >= 80)
            {
                grade = 3;
            }
            else if (score >= 70)
            {
                grade = 2;
            }
            else if (score >= 60)
            {
                grade = 1;
            }
            else
            {
                grade = 0;
            }

            Console.WriteLine("Your Grade is {0}", grade);
        }//end ifelse

        private void SwitchExample()
        {
            int choice;
            Console.WriteLine("Choose which method to run");
            Console.WriteLine("1: SimpleIfStatement");
            Console.WriteLine("2: IfElseExample");
            Console.WriteLine("3: Exit");

            choice = int.Parse(Console.ReadLine());

            switch (choice)
            {
                case 1:
                    SimpleIfStatement();
                    break;
                case 2:
                    IfElseExample();
                    break;
                case 3:
                    PauseIt();
                    break;
                default:
                    Console.WriteLine("Not a valid choice");
                    break;
            }

        }//end switch

        //if (number > 0 && number < 100) and
        //if (number < 0 || number > 100) or

    }//end class
}

ITC 110 Assignment 2 in Java

2011-10-10T14:11:00.000-07:00

Here is the Java equivalent of Assignment 2



package Income;
import java.util.Scanner;

public class NetIncomeCalculator {

 /**
  * This program calculates gross pay
  * and net pay given deductions in 
  * Social Security, medicare and a bus
  * pass. This is the equivalent of
  * Assignment two in C# in ITC 110
  * Steve Conger 10/10/2011
  */
 
 //declaring constants
 final double SOCIALSECURITY = .09;
 final double MEDICARE=.03;
 final int BUSPASS=25;
   
 public static void main(String[] args) {
  //declare and instantiate the class
  //to load it (main being static is
  //already loaded into memory
  NetIncomeCalculator netcalc = new NetIncomeCalculator();
  //call the starting method
  netcalc.Display();
 }
 
 private void Display()
 {
  //get input
  //the scanner is an object to read from the console
  Scanner reader = new Scanner(System.in);
  System.out.println("Enter the number of hours worked");
  double hours = reader.nextDouble();
  System.out.println("Enter your rate per hour");
  double rate=reader.nextDouble();
  
  //call the methods to do the calculations
  double grossPay=CalcIncome(hours, rate);
  double socialSec = CalcSocialSecurity(grossPay);
  double medicare = CalcMedicare(grossPay);
  double netPay=CalcNetPay(grossPay, socialSec, medicare);
  
  //outputs
  System.out.println("Your gross income is " + grossPay);
  System.out.println("Your Social Security deduction is " + socialSec);
  System.out.println("Your Medicare deduction is " + medicare);
  System.out.println("Your Bus pass deduction is " + BUSPASS);
  System.out.println("Your net pay is " + netPay);
 }
 
 private double CalcIncome(double hrs, double rt)
 {
  double gross=0;
  //check to see if the hours are more than forty
  //if they are pay time and a half for overtime
  //if not just pay the rate of pay
  if (hrs > 40)
  {
   gross=rt * (40 + ((hrs-40)*1.5));
  }
  else
  {
   gross = rt * hrs;
  }
  return gross;
 }
 
 private double CalcSocialSecurity(double gPay)
 {
  return gPay * SOCIALSECURITY;
 }
 
 private double CalcMedicare(double gPay)
 {
  return gPay * MEDICARE;
 }
 
 private double CalcNetPay(double gPay, double ss, double med)
 {
  return gPay - (ss + med + BUSPASS);
 }

}

Here is the output from the program



Enter the number of hours worked
45
Enter your rate per hour
25
Your gross income is 1187.5
Your Social Security deduction is 106.875
Your Medicare deduction is 35.625
Your Bus pass deduction is 25
Your net pay is 1020.0

ITC 110 Assignment 1 in Java

2011-10-10T13:14:00.000-07:00

This is the Java equivalent of the first ITC 110 assignment. I will do the other assignments in ITC 110 and also post them here



package Mileage;
import java.util.Scanner;
import java.io.*;
public class CalcMileage {

 /**
  * This is a simple program to Calculate
  * miles per gallon
  * it is the equivalent to ITC110
  * assignment 1
  * steve conger 9-26-2011
  */
 public static void main(String[] args) {
  //declare Scanner
  Scanner reader = new Scanner(System.in);
  //declare variables
  double beginMileage;
  double endMileage;
  double gallons;
  double pricePerGallon;
  double milesPerGallon;
  double costPerMile;
  //get input
  System.out.println("Enter the beginning mileage");
  beginMileage=reader.nextDouble();
  System.out.println("Enter the ending mileage");
  endMileage=reader.nextDouble();
  System.out.println("Enter the number of gallons");
  gallons=reader.nextDouble();
  System.out.println("Enter the price per gallon");
  pricePerGallon=reader.nextDouble();
  
  //do processing of input
  milesPerGallon=(endMileage-beginMileage)/gallons;
  costPerMile=pricePerGallon /(endMileage-beginMileage);
  
  //output results
  System.out.print("Your miles per gallon is ");
  System.out.format("%.2f",milesPerGallon);
  System.out.println();
  System.out.print("the cost per mile is ");
  System.out.format("%.2f",costPerMile);
 }

}

Books and Websites

2011-10-06T13:25:00.000-07:00

Here is a list of books and websites you might fine useful to help you with C#

Books

Head First C#, O'Reilly, ISBN 978-0596514822
Programming C#, Jeff Liberty, O'Relly, ISBM 978-059600699
Sam's Teach Yourself, the C# Language in 21 days, Bradley Jones, Sams, ISBN 978-0672325465
Murach's C# 2010, Murach and Associates, ISBN 978-1890774592

Web Sites

http://www.msdn.microsoft.com MSDN Microsoft's development Network

http://www.Devx.com DevX development center

Start for Assignment 2

2011-10-05T19:24:00.000-07:00

Here is the starting code for Assignment 2


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Assignment2
{
    class Program
    {

        const double SOCSEC = .09;

        static void Main(string[] args)
        {
            Program p = new Program();
            p.Display();
            p.PauseIt();
        }//end main

        private void Display()
        {
            Console.WriteLine("Enter the hours worked this week");
            double hours = double.Parse(Console.ReadLine());
            Console.WriteLine("Enter the rate per hour");
            double rate = double.Parse(Console.ReadLine());

            double weeklyGross = GrossPay(hours, rate);
            Console.WriteLine("Your gross pay is {0:C}", weeklyGross);

            double socialsec = SocialSecurity(weeklyGross);
            Console.WriteLine("Your SS deduction is {0:C}", socialsec);


        }//end Display

        double GrossPay(double weeklyHours, double hourlyRate)
        {
            double gross =0;
            if (weeklyHours > 40)
            {
                gross = hourlyRate * (40 + ((weeklyHours - 40) * 1.5));
            }
            else
            {
                gross = hourlyRate * weeklyHours;
            }
            return gross;
        }//end GrossPay

        private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }//end PauseIt

        private double SocialSecurity(double grossWeeklyPay)
        {
            return grossWeeklyPay * SOCSEC;
        }
    }//end Program
}//end namespace

Notes for Assignment 2

2011-10-05T14:05:00.000-07:00

Remember to break it into methods. Each method should do one thing. For example, one method can calculate the gross pay, another method can deduct social security, etc.

To calculate Overtime we need to us an if statement. We need to do one of two things depending on if the hours are greater than 40 or 40 or less. This can be set up as follows:


if(hours > 40)
{
     pay=rate * (40 + ((hours - 40) * 1.5);
}
else
{
    pay=rate * hours;
}

If the hours are greater than forty, we multiply the rate times forty (because we know we have over forty hours and forty of them are paid at the regular rate) and then add the hours over forty times rate time 1.5 to get time and a half. The parenthesis are necessary to control the order of operations. We want the subtraction to occur first, then the multiplication, then the addition. If, on the other hand, the hours are 40 or less, we just multiply hours times the rate of pay.

For the assignment, you don't have to display the overtime pay separate from the regular pay. You can just display the Gross (total) pay, the deductions and the Net pay (what's left over). Though, if you want to add a challenge you can separate the two in the display.

Methods Morning Class

2011-10-04T11:47:00.001-07:00

Here is the Morning class's sample code for methods. It is a little different from the evening class. I did not comment it nearly as thoroughly


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Methods
{
    class Program
    {
        static void Main(string[] args)
        {
            Program prog = new Program();
            prog.Display();
            prog.PauseIt();
        }//end of Main

       private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }//end of PauseIt

       private void Display()
       {
           Console.WriteLine("Enter the beginning mileage");
           double beginningMileage = double.Parse(Console.ReadLine());

           Console.WriteLine("Enter the ending mileage");
           double endingMileage = double.Parse(Console.ReadLine());

           double miles = TotalMiles(beginningMileage, endingMileage);

           Console.WriteLine("\nYour total miles is {0}",miles);

           Console.WriteLine("Enter the number of Gallons");
           double gallons=double.Parse(Console.ReadLine());

           double milesPerGal = MilesPerGallon(miles, gallons);
           Console.WriteLine("Your miles per gallon is {0}", milesPerGal);
           
       }//end Display

       private double TotalMiles(double startMiles, double endMiles )
       {
           return endMiles - startMiles;
       }//Total Miles

       private double MilesPerGallon(double totalMiles, double gals)
       {
           double mpg = totalMiles / gals;
           return mpg;
       }//end MilesPerGallon

    }//end of program class

}//end of namespace

Methods Example

2011-10-03T19:16:00.001-07:00

Here is our example from class with extensive comments


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace methodsExample
{
    class Program
    {
        /*********************
         * the point of this excercise is to show
         * how to break a program into methods
         * we have a display method and seperate
         * methods to calcualte the gas mileage
         * and the cost per mile.
         * the point of breaking a program into methods
         * is to divide the work and make it easier
         * to maintain, debug and understand.
         * Ideally each method should do one thing
         * that way it is obvious where to look if
         * something goes wrong
         * Steve Conger 10/4/2011 */

        static void Main(string[] args)
        {
            //a static method is loaded automatically
            //into RAM, but the rest of the class is not
            //so we need to "instantiate" the class
            //to load it into memory where it can be used
            Program p = new Program();
            p.Display(); //call the display method
            p.PauseIt();// call the PauseIT class
            
        }

        //void methods don't return a value
        //they just do their thing
        private void Display()
        {
            //inputs
            //just like what we did in the first assignment
            Console.WriteLine("Enter the Mileage");
             double mileage = double.Parse(Console.ReadLine());
             Console.WriteLine("Enter The Gallons");
             double gals = double.Parse(Console.ReadLine());
             Console.WriteLine("Enter The price per gallon");
             double price = double.Parse(Console.ReadLine());
            //outputs
             Console.WriteLine("Your miles per gallon is {0:F2}", 
                 CalculateGasMileage(mileage, gals));//calls the CalculateGasMileage 
            //as part of the write line. You can only do this if the
            //method returns a value

            //this is another way to do it
            //here we assign the returned result of the method
            //to a new variable
            double mpg=CalculateGasMileage(mileage, gals);

            //we can use that variable in the writeline instead of calling
            //the method again
            Console.WriteLine("Your cost per mile is {0:C}",
                CalculateCostPerMile(mpg,price));

           
        }

        //this method returns a double
        //it takes two parameters that are give values
        //when the method is called in the Display() method above
        private double CalculateGasMileage(double miles, double gallons)
        {
            double milesPerGallon;
            milesPerGallon = miles / gallons; 
            return milesPerGallon;
        }

        private double CalculateCostPerMile(double milesPerGal, double pricePerGallon)
        {
            //double costPerGallon=0;
            //this is a different way to return a value
            //you can return the equation directly
            return pricePerGallon / milesPerGal;
        }

        private void PauseIt()
        {
            Console.WriteLine("Press any key to exit");
            Console.ReadKey();
        }
    }
}

Assignment One

2011-09-28T19:00:00.000-07:00

Program Planning Document

Your name: Steve

Date: 9/28/2011

Purpose of the Program:

he purpose of this program is to calculate gas mileage and cost per mile.

Outputs:

Cost per mile

Miles Per Gallon

Inputs:

Price of Gas

Beginning mileage

End Mileage

Gallons used

Algorithm:

Miles per gallon = (end Mileage-BeginningMileage)/gallons

Cost Per mile =cost per gallon / miles per gallon

est Plan:

Test: 100 miles/10 gallons (test case)

Expected Outcome: 10 miles per gallon

Test Cost 4 price /10

Expected Outcome .4

Actual Outcome: 10, .4

Notes:

Code (paste your code below):


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Assignment1
{
    /*Assignment 1
     * steve Conger
     * 9/28/2011 */

    class Program
    {
        static void Main(string[] args)
        {
            //declare variables
            double beginningMileage, endMileage, gallons, pricePerGallon, 
                milesPerGallon, costPerMile;

            //Getting input
            Console.WriteLine("Enter the beginning mileage");
            beginningMileage = double.Parse(Console.ReadLine());
            Console.WriteLine("Enter the ending mileage");
            endMileage = double.Parse(Console.ReadLine());
            Console.WriteLine("Enter the number of gallons");
            gallons = double.Parse(Console.ReadLine());
            Console.WriteLine("Enter the price per gallon");
            pricePerGallon = double.Parse(Console.ReadLine());

            //calculations
            milesPerGallon = (endMileage - beginningMileage) / gallons;
            costPerMile = pricePerGallon / milesPerGallon;

            //Output
            Console.WriteLine("Your miles per gallon are {0}", milesPerGallon);
            Console.WriteLine("Your cost per mile is {0:C}", costPerMile);

            Console.ReadKey();


        }
    }
}

Statement of Work

2011-09-28T11:48:00.000-07:00

Here is the statement of work we did in class

History

The college wants to implement short certificates that can be earned more quickly than existing certificates. This will increase the number of completions. Registration says it cannot track these new certificates, so a new database is needed to track them.

Scope

The database should track the certificates, and the classes each certificate requires. The database must also track the classes each student takes and what certificates they have earned. For a class to qualify a student must earn at least a 2.0, the classes should all have been taken within a five year span The database should allow for class substitutions. It should allow some comments and notes. The database should produce email and phone lists for students who have earned a certificate. Students who are close to a certificate should be notified. The database should be secured to protect student information.

The database should produce reports of how many students earned particular certificates in a given period. It should report how many students almost achieved certificates but were missing one class or so. Might use database to track popular and special topic courses, and how much time it took to complete the certificates.

Constraints: The database will not read the student data directly from the school system.

Objectives

To track short term certicates.

To determine which students achieve certificates

Preliminary Time Line

TimeLine

Gathering information—4 weeks

Defining Business Rules—2 weeks

Designing databases—1 week

Normalizing data—1 week

Make the database--week

Test the database sql--week

security

2011-09-26T18:24:00.001-07:00

Here is the Hello World app from the evening class


using System;
using System.Collections.Generic;
using System.Text;

namespace HelloWorld
{
    /*This is the traditional
     * Hello world application
     * pretty boring */

    
    class Program
    {
        static void Main(string[] args)
        {
            //This uses the console object
            //and its WriteLine method
            Console.WriteLine
                ("Hello all you Martians");
            //this is to pause the program long enough
            //to see it
            Console.ReadKey();
        }
    }
}

Trends in Programming and Database

2011-09-25T13:02:00.000-07:00

Information Technology is always in flux, but recently the field has experienced more and more significant changes than any time in recent memory. Many of the basic paradigms of computing are changing. More and more computing power is moving on to mobile devices such as phones and tablets. More and more we access our data and applications from the cloud. Computing is social and omnipresent. For would be developers and people thinking of entering the IT field the changes can be bewildering. What should I learn? What skills should I master? On What should I focus?

I am going to begin a new subject line in this blog called "trends." In these entries I am going to focus on arising trends in programming and database, and, in particular, the skills required to get entry level jobs in these changing fields.

Some of the topics I will look at include:

The new mobile market including phones and tablets
Device programming (gps, cars, house, smart grid, etc.
Cloud computing, including cloud databases
Windows 8
HTML 5
Security

I will also look at other topics as they arise

I encourage comments and suggestions

Debugging and Trouble Shooting

2011-08-18T12:38:00.000-07:00

Overview

There are three major types of errors that can occur in your program: First there are compile errors. These occur before you ever run the program. Typically they consist of mispelled key words or variables, missing semi-colons and curly braces. These must be corrected before you can run the program.

Next there are Run time errors. These are errors that occur when the program is running. Typically they consist of Data type conflicts, or objects that are called before they are initialized. These cause the code to break and go into debug mode.

The third kind of error is a logical error. Logical errors are errors in the logic of the program. They usually don't cause the program to fail or crash. Rather they cause the program to return the wrong answer or no answer at all. These are the hardest errors to track down and fix.

Compile Errors

The key with compile errors is to use the Visual Studio environnment.

Use the intellisense. The intellisense will show you all the objects defined by your program. It will show you all the relevant methods and properties. Using it can help cut down on mispellings and errors in capitalization.

Read the error messages. Actually read them. They don't always tell you exactly where the problem is, but they get you close.

Always work from the first error on down. Often fixing the first error will clear up most or all of the remaining errors. Errors tend to cascade through the program. One causes another which causes another, etc. If you work from the bottom of the list you will get frustrated, because you usually won't find anything wrong.

Pay attention to the color coding in the coding environment itself. A keyword should be blue--if it is not it may mean you mistyped it. A red underline signifies an error. A green underline is just a comment or possibly a warning.

Run time errors

Most runtime errors are caused by user input, Users don't always enter what we expect, so the program should be able to handle the unexpected input. Ideally, test all use input to see if it is in the correct form. Use TryParse() instead of Parse().

The other common cause of Runtime errors are objects that are not initialized properly. Make sure that you instantiate an object (make it new) before you call it.

Logical Errors

The key to finding logical errors is testing. Try the program with known values and a known output. If the output varies on the input, test a complete range of inputs to see if the proper outputs are returned.

One strategy is to put temporary outputs in your program that print out the state of certain variables at a given point in the process. You can check these against what the variable should be.

You can also use Visual Studios debugger. You can place breaks in the code and step through the part in question line by line, checking the values of the variables moment to moment.

General Suggestions

When writing a program, do one thing and then test it. If it works then when you add the next thing and the program fails you know it was in the new part.

The same goes when debugging and trouble shooting. Make one change and then test it. Never make a bunch of changes willy nilly. It makes it almost impossible to tell what is working and what isn't.

If you go over the code again and again and can't find a mistake in the logic, chances are good there isn't one. Look for syntax aand spelling errors instead. You often don't see these when looking at the logic.

If possible, have someone else look it over. Another person can often see what you don't.

If you spend hours on a thing and just can't get it to work. Walk away. Do something else entirely for a while. Often when you come back with fresh eyes, the problem that you were missing becomes obvious.

Repetition Structures

2011-08-18T12:05:00.001-07:00

Programs often need to do the same commands several times in a row. Repitition structures, or loops, are designed to do this. There are several kinds of loops.

For loops

The first one we will look at is a for loop.

A for loop contains three elements, a variable with an intial value, a terminal condition, and an increment or decriment statement. Here is an example of a simple for loop that simply outputs the numbers 1 through 10.


for(int i=0;i<=10;i++)

{

   Console.WriteLine(i);

}

You could also count backwards:


for(int i=10;i>0;i--)

{

   Console.WriteLine(i);

}

The terminating condition can be a variable:


Console.WriteLine("How far do you want to count?");

int number=int.Parse(Console.ReadLine());



for(i=0;i<=number;i++)

{

   Console.WriteLine(i);	

}

While Loops

For loops are good when you have a specific number or repititions you want to do. While loops are good for when you have an indefinite number of repititions.
Here is an example of a while loop:


int grade=0;

while(grade != 999)

{

    Console.WriteLine("Enter a grade. 999 to exit");

    int grade = int.Parse(Console.Readline());



}

Do loops

Do loops are like while loops, but the condition is at the end of the loop. This has a subtle effect. A while loop might never execute. If the condition is met before the loop is encountered--if, for instance, grade equaled 999, the program would never execute the while loop. A do loop, on the other hand, always executes at least once.

Here is an example of a do loop:


int grade=0;



do

{

    Console.WriteLine("Enter a grade. 999 to exit");

    int grade = int.Parse(Console.Readline());



}while(grade != 999);

Infinite Loops

It is important that a loop have a termination point. If not you can create what is called an infinite loop. The only way out of an infinite loop is to stop the program.


for(int i=0;i>0;i++)

{

   Console.WriteLine(i);

}

Embedded loops, break keyword

It is important to note that you can nest loops and selection structures as you need. You can have loops inside of loops and ifs inside of ifs. We will see some examples of this in later examples and lectures.

One additional Key words need mention: break. You can use break to exit from a loop before the terminal condition, Here is an example:


for(int i=1;i<1000;I++)

{

	Console.WriteLine("enter a name--'exit' to quit");

        string name=Console.ReadLine();

	if (name.Equals("exit") || name.Equals("Exit"))

	{

		break;

	}

}

Selection Statements

2011-08-17T11:33:00.000-07:00

Programs often have to make choices about what to do with a value. If statements and switches are programming structures used to select what to do if a value falls into a certain range.

If statements

An if consists of the if keyword and a condition in parenthesis. The condition must evaluate to true or false (a bool). If there is only one statement after the if you don't have to use curly braces {}, though I would encourage you to use them just to be in the habit. If there are multiple statements dependent on the condition you do have to use curly braces.

Here is a method that shows an example of simple if statements


        void SimpleIFStatement()

        {

            Console.WriteLine("Enter a number between 1 and 10");

            int number = int.Parse(Console.ReadLine());



           

            if (number <1 )

                 Console.WriteLine("the number is too small");





            if (number > 10)

                Console.WriteLine("The number is too Large");

                

        }

The next example shows the use of the "else" clause in an if statement. The else clause handles any value not covered by the main if statement.




        void IfElseStatement()

        {

            Console.WriteLine("Enter your age");

            int age = int.Parse(Console.ReadLine());



            if (age >= 18)

            {

                Console.WriteLine("You are old enough, Welcome");

            }

            else

            {

                //for anything less than 18

                Console.WriteLine("Come back when your are older");

            }

        }

If you need to test for multiple possible conditions you can use the if, else if, else structure. It is important to note that sequence matters. The program stops at the first true statement. In the following example if I put the lowest temperature first, the program would always read "cool" for any temperature over 40, even if the temperature were 110.




        void IFElseIFExample()

        {

            Console.WriteLine("Enter the day's  high Temperature");

            int temp = int.Parse(Console.ReadLine());



            if (temp >= 90)

            {

                Console.WriteLine("Way too hot");

            }

                else 

                     if(temp >= 80)

                    {

                        Console.WriteLine("A bit warm");

                    }

                else

                    if (temp >= 70)

                    {

                        Console.WriteLine("Just right");

                    }

                    else

                        if (temp >= 60)

                        {

                            Console.WriteLine("Pleasant");

                        }

                        else

                            if (temp >= 40)

                            {

                                Console.WriteLine("cool");

                            }

                            else

                            {

                                Console.WriteLine("Cold");

                            }



        }

Below is an if example used with the TryParse method. If you enter a bad value into the Parse method it crashes the program. With TryParse it doesn't. TryParse returns a boolean, True if the value actually parses into an int or double or whatever, false if it fails to parse. The try parse also requires an out parameter. If the values parses correctly it's value is assigned to the outside variable--in this case "number".
You can test the boolean variable with an if statement to determine if the parse worked or not.


void TryParseExample()

        {

            bool goodint;

            int number;



            Console.WriteLine("Enter an integer value");

            goodint = int.TryParse(Console.ReadLine(), out number);



            if (goodint == true)

            {

                Console.WriteLine("Your integer is {0}", number);

            }

            else

            {

                Console.WriteLine("Not an integer");

            }

        }

Finally here is an example of if statements with multiple conditions using and (&&) and or (||) to combine them.
In and conditions both sides of the statement must be true for the if to evaluate as true. For an or statement, if one or the other statement is true, then the whole statement is true.
Here is the example:


 void ANDORExamples()

        {

            Console.WriteLine("Enter a number between 1 and 10");

            int number = int.Parse(Console.ReadLine());



            //and example both must be true

            if (number > 1 && number < 10)

            {

                Console.WriteLine("Valid Entry");

            }



            //orExample

            {

                if (number < 1 || number > 10)

                {

                    Console.WriteLine("Invalid Entry"); 

                }

            }

        }

Switch

Switch is another way to select based on a set of values, but unlike the if else if structure it only matches exact values.




        void SwitchExample()

        {

            Console.WriteLine("Enter a grade 1, 2, 3, or 4");

            int grade = int.Parse(Console.ReadLine());



            switch (grade)

            {

                case 1:

                    Console.WriteLine("D");

                    break;

                case 2:

                    Console.WriteLine("c");

                    break;

                case 3:

                    Console.WriteLine("B");

                    break;

                case 4:

                    Console.WriteLine("A");

                    break;

                default:

                    Console.WriteLine("Not a valid grade");

                    break;

            }

        }

Link to High Availability Presentation

2011-08-16T14:31:00.000-07:00

Here is the link to the high Availability presentation"

http://www.seattlejungle.com/highavailability.htm

CLR Procedure

2011-08-16T10:04:00.001-07:00

Here is the SQL for the CLR procedure:

Select LocationName as [Location],
Sum(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent)) as Subtotal,
Sum(Employee.GetTax(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent),TaxPercent))
as Tax,
sum(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent) +
Employee.GetTax(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent),TaxPercent))
as Total
From Employee.VehicleServiceDetail vsd
inner Join Employee.VehicleService vs
on vs.VehicleServiceID=vsd.VehicleServiceID
inner Join Customer.Location l
on l.LocationID=vs.LocationID
Group by LocationName

Here is the CLR code with the SQL embedded:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void usp_LocationSales()
{
// Put your code here
using (SqlConnection connect = new SqlConnection("context connection=true"))
{
connect.Open();
SqlCommand cmd = connect.CreateCommand();
cmd.CommandText = "Select LocationName as [Location], "
+ "Sum(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent)) as Subtotal, "
+ "Sum(Employee.GetTax(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent),TaxPercent)) "
+ " as Tax, "
+ " sum(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent) "
+ "+ Employee.GetTax(Employee.func_PriceWithDiscount(AutoServiceID,DiscountPercent),TaxPercent)) "
+ "as Total "
+ "From Employee.VehicleServiceDetail vsd "
+ "inner Join Employee.VehicleService vs "
+ "on vs.VehicleServiceID=vsd.VehicleServiceID "
+ "inner Join Customer.Location l "
+ "on l.LocationID=vs.LocationID "
+ "Group by LocationName ";

SqlContext.Pipe.ExecuteAndSend(cmd);
}
}
};