1/5 Same Shtuff Different Day

_________________________________________________________
Start 9.30 a.m.
_________________________________________________________

Today carrying on with C# stuff. Have project meeting at 2.00 p.m.

************************************************************************
Break 12.00 p.m. - 3p.m. Go into town & meeting
************************************************************************

Had good meeting, just talked about where ive gotten up to and what i want to achieve in the next week. Other than that break i have just been implementing a small application in C# just to get used to the syntax differences, also using properties to access fields, so thats all new. Picking it up pretty fast though, hopefully i will only need tonight to do basic revision/research i was supposed to have done during the design stage.


************************************************************************
Break 4.00 p.m. - 5p.m. walk
************************************************************************

Well heres a sample of the clsUser class.

namespace tracking
{
public class clsUser
{
//Fields
protected int staffID;
protected string firstName;
protected string lastName;
protected string jobDescription;

public int PropertyStaffID
{
get { return staffID; }
set { staffID = value; }
}

public string propertyFirstName
{
get { return firstName; }
set { firstName = value; }
}

public string propertyLastName
{
get { return lastName; }
set { lastName = value; }
}

public string propertyJobDescription
{
get { return jobDescription; }
set { jobDescription = value; }
}

public clsUser()
{
staffID = 0;
firstName = "DEFAULT";
lastName = "DEFAULT";
jobDescription = "DEFAULT";

//System.Windows.Forms.MessageBox.Show("Called Constructor");
}

public clsUser(int prStaffID, string prFirstName, string prLastName, string prJobDescription)
{
staffID = prStaffID;
firstName = prFirstName;
lastName = prLastName;
jobDescription = prJobDescription;
}


}
}


Will make the basic classes for the other entitys seeing as i seem to have figured out those basics... i hope haha.

_________________________________________________________
Finsh 11.00 p.m. 8 hours
_________________________________________________________

30/4 Carry on with Classes

_________________________________________________________
Start 12.00 p.m.
_________________________________________________________

Just carrying on with virtual machine. Got to download C# template for web services. Soon i am going into town to do a few things, will also get a C# book from polytech.

************************************************************************
Break 1.00 p.m. - 3p.m.
************************************************************************

Went into town at 1, couldnt find any books for visual C#, so internet will have to do for now. Spent from 3-5 working on making some webservices in C# just to get some of the basics, picking it up pretty fast.

************************************************************************
Break 5.00 p.m. - 6p.m.
************************************************************************
_________________________________________________________
Finish 7.30 p.m. - 4.5
_________________________________________________________

29/4 Classes

_________________________________________________________
Start 10.30 a.m.
_________________________________________________________
Because i havent got the iso for visual studio 2005 yet, i am going to create all the classes etc on my local computer then transfer them to my virtual machine once i get VS2005 set up on it.

WOO, i have the iso's now thanks to lucid, thanks! :D Will get onto that. I'm also reading old documentation on webservices from my INT300 class last year, just revise some stuff.

************************************************************************
Break 2.00 p.m. - 4p.m. & 6 - 7
************************************************************************
_________________________________________________________
Finish 8.00 p.m. 5 hours productive work.
_________________________________________________________

28/4 Slack i am

_________________________________________________________
Start 10.30 a.m.
_________________________________________________________

Bahh man i'm slack, have alot of catchign up to do this week, at the moment i'm making the database.

A few new changes have been made. Management is in a table by itself... that normalization didn't make sense ha ha. I changed the user permission PK to a composite key instead of a surrogate one.




Tables


************************************************************************
Break 2.30 p.m. - 7.00 p.m.
************************************************************************

Stored Procedures

USER

Insert

CREATE procedure [dbo].[sp_user_Insert]

@userID smallint

,@firstName varchar(30)

,@lastName varchar(30)

,@jobDescription varchar(150)

AS

INSERT INTO [dbo].[user]

(userID

,firstName

,lastName

,jobDescription)

VALUES

(@userID

,@firstName

,@lastName

,@jobDescription)

Update

CREATE procedure [dbo].[sp_user_Update]

@userID smallint

,@firstName varchar(30)

,@lastName varchar(30)

,@jobDescription varchar(150)

AS

UPDATE [dbo].[user] SET

firstName = @firstName

,lastName = @lastName

,jobDescription = @jobDescription

WHERE userID = @userID

Delete

create procedure [dbo].[sp_user_Delete]

@userID smallint

AS

DELETE FROM [dbo].[user]

WHERE userID = @userID

USER PERMISSION

Insert

CREATE procedure [dbo].[sp_userPermission_Insert]

@permissionID nvarchar(20)

,@userID smallint

AS

INSERT INTO [dbo].[userPermission]

(permissionID

,userID)

VALUES

(@permissionID

,@userID)

Update

CREATE procedure [dbo].[sp_userPermission_Update]

@permissionID nvarchar(20)

,@userID smallint

AS

UPDATE [dbo].[userPermission] SET

permissionID = @permissionID

,userid = @userID

WHERE permissionID = @permissionID and userID = @userID

Delete

create procedure [dbo].[sp_userpermission_Delete]

@permissionID nvarchar(20)

,@userID smallint

AS

DELETE FROM [dbo].[userPermission]

WHERE permissionID = @permissionID and userID = @userID

PERMISSION

Insert

CREATE procedure [dbo].[sp_permission_Insert]

@permissionID nvarchar(20)

AS

INSERT INTO [dbo].[permission]

(permissionID)

VALUES

(@permissionID)

Update

CREATE procedure [dbo].[sp_permission_Update]

@permissionID nvarchar(20)

AS

UPDATE [dbo].[permission] SET

permissionID = @permissionID

WHERE permissionID = @permissionID

Delete

create procedure [dbo].[sp_permission_Delete]

@permissionID nvarchar(20)

AS

DELETE FROM [dbo].[permission]

WHERE permissionID = @permissionID

JOB

Insert

CREATE procedure [dbo].[sp_job_Insert]

@jobID smallint

,@clientID nchar(6)

,@userID smallint

,@clientAddressID smallint

,@jobDescription nvarchar(120)

,@jobCompleted bit

,@jobCreatedDate datetime

,@JobCompletedDate datetime

AS

INSERT INTO [dbo].[job]

(jobID

,clientID

,userID

,clientAddressID

,jobDescription

,jobCompleted

,jobCreatedDate

,JobCompletedDate)

VALUES

(@jobID

,@clientID

,@userID

,@clientAddressID

,@jobDescription

,@jobCompleted

,@jobCreatedDate

,@JobCompletedDate)

Update

CREATE procedure [dbo].[sp_job_Update]

@jobID smallint

,@clientID nchar(6)

,@userID smallint

,@clientAddressID smallint

,@jobDescription nvarchar(120)

,@jobCompleted bit

,@jobCreatedDate datetime

,@JobCompletedDate datetime

AS

UPDATE [dbo].[job] SET

clientID = @clientID

,userID = @userID

,clientAddressID = @clientAddressID

,jobDescription = @jobDescription

,jobCompleted = @jobCompleted

,jobCreatedDate = @jobCreatedDate

,jobCompletedDate = @JobCompletedDate

WHERE jobID = @jobID

Delete

create procedure [dbo].[sp_permission_Delete]

@permissionID nvarchar(20)

AS

DELETE FROM [dbo].[permission]

WHERE permissionID = @permissionID

CLIENT ADDRESS

Insert

CREATE procedure [dbo].[sp_clientAddress_Insert]

@clientAddressID smallint

,@clientID nchar(6)

,@streetNumber nvarchar(15)

,@streetName nvarchar(30)

,@suburb nvarchar(30)

,@city nvarchar(30)

,@country nvarchar(30)

,@geocode nvarchar(50)

,@phoneNumber nvarchar(15)

,@faxNumber nvarchar(15)

AS

INSERT INTO [dbo].[clientAddress]

(clientAddressID

,clientID

,streetNumber

,streetName

,suburb

,city

,country

,geocode

,phoneNumber

,faxNumber)

VALUES

(@clientAddressID

,@clientID

,@streetNumber

,@streetName

,@suburb

,@city

,@country

,@geocode

,@phoneNumber

,@faxNumber)

Update

CREATE procedure [dbo].[sp_clientAddress_Update]

@clientAddressID smallint

,@clientID nchar(6)

,@streetNumber nvarchar(15)

,@streetName nvarchar(30)

,@suburb nvarchar(30)

,@city nvarchar(30)

,@country nvarchar(30)

,@geocode nvarchar(50)

,@phoneNumber nvarchar(15)

,@faxNumber nvarchar(15)

AS

UPDATE [dbo].[clientAddress] SET

clientID = @clientID

,streetNumber = @streetNumber

,streetName = @streetName

,suburb = @suburb

,city = @city

,country = @country

,geocode = @geocode

,phoneNumber = @phoneNumber

,faxNumber = @faxNumber

WHERE clientAddressID = @clientAddressID

Delete

create procedure [dbo].[sp_clientAddress_Delete]

@clientAddressID smallint

AS

DELETE FROM [dbo].[clientAddress]

WHERE clientAddressID = @clientAddressID

CLIENT

Insert

CREATE procedure [dbo].[sp_client_Insert]

@clientID nchar(6)

,@clientName nvarchar(30)

AS

INSERT INTO [dbo].[client]

(clientID

,clientName)

VALUES

(@clientID

,@clientName)

Update

CREATE procedure [dbo].[sp_client_Update]

@clientID nchar(6)

,@clientName nvarchar(30)

AS

UPDATE [dbo].[client] SET

clientID = @clientID

,clientName = @clientName

WHERE clientID = @clientID

Delete

create procedure [dbo].[sp_client_Delete]

@clientID nchar(6)

AS

DELETE FROM [dbo].[client]

WHERE clientID = @clientID

MANAGEMENT

Insert

CREATE procedure [dbo].[sp_management_Insert]

@businessName nvarchar(30)

,@streetNumber nvarchar(15)

,@streetName nvarchar(30)

,@suburb nvarchar(30)

,@city nvarchar(30)

,@country nvarchar(30)

,@geocode nvarchar(50)

,@phoneNumber nvarchar(15)

,@faxNumber nvarchar(15)

AS

INSERT INTO [dbo].[management]

(businessName

,streetNumber

,streetName

,suburb

,city

,country

,geocode

,phoneNumber

,faxNumber)

VALUES

(@businessName

,@streetNumber

,@streetName

,@suburb

,@city

,@country

,@geocode

,@phoneNumber

,@faxNumber)

Update

CREATE procedure [dbo].[sp_management_Update]

@businessName nvarchar(30)

,@streetNumber nvarchar(15)

,@streetName nvarchar(30)

,@suburb nvarchar(30)

,@city nvarchar(30)

,@country nvarchar(30)

,@geocode nvarchar(50)

,@phoneNumber nvarchar(15)

,@faxNumber nvarchar(15)

AS

UPDATE [dbo].[management] SET

businessName = @businessName

,streetNumber = @streetNumber

,streetName = @streetName

,suburb = @suburb

,city = @city

,country = @country

,geocode = @geocode

,phoneNumber = @phoneNumber

,faxNumber = @faxNumber

WHERE businessName = @businessName

Delete

create procedure [dbo].[sp_management_Delete]

@businessName nvarchar(30)

AS

DELETE FROM [dbo].[management]

WHERE businessName = @businessName

************************************************************************
Break 9.00 p.m. - ?p.m.
************************************************************************

7 hours