2/5 Implementation of Business Layer

_________________________________________________________
Start 9.00 a.m.
_________________________________________________________

Just thought i'd make a list of things i need to do for tomorrow/today before i forget.

• print out UML diagram
• make all basic classes
• work out lists
• make diagram on how i see the webservice working

************************************************************************
Break 10.00 a.m. - 11 a.m. - went back to sleep for hour haha
************************************************************************

I've decided I'm going to make a update UML diagram as i go for a better understanding of what ive actually implemented so far, i will comment on the changes ive made daily.

This is version 1.0. Just what I've programmed so far, as you can see I've basically only made the main classes and added in the properties.



************************************************************************
Break 1.30 p.m. - 2.30 p.m. - lunch & walk
************************************************************************

Gonna print out UML diagram and do a bit of brainstorming as to how the webservice is going to work, after that work more on the idictionarys/lists. I will upload a new UML diagram some time in the near future. LOL theres spider webs and dust all over printer, hope it still works!!!

OK spent some time fixing some problems with the database, or more like changing back things i shouldnt have changed... lol. For the newest diagram at this point click here. I'll also just put it below. I also made the creation script for the database should i want to begin from scratch. At this stage i still havent figured out whats going to happen with the user permissions, i'm thinking of just using what microsoft provides, we shall see. So for now i will briefly under changes mention this thought.



Now just before tea i'm gonna update some stuff on blogg such as problems and the side menus etc. After tea i'll be in a less tired state to start more C# programming.

************************************************************************
Break 5.30 p.m. - 7 - mr te-ar timmeeee
************************************************************************
_________________________________________________________
Finish 8.00 p.m. 7.5 hours
_________________________________________________________

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