Help constructing a class !

[Big George]

Hello,

I develop in ASP.NET with VB.NET code.

I need some help constructing a class: Worker. I'm designing the
properties of this class.
The class is filled reading tables in database.

Properties of Class Worker:
- ID_Card
- Names of Person
- ID_Current_Comp any
- Name of Current Company
- Is Worker working at the company? (Yes, No)
- Projects that worker worked in
- Project 1 (ID and name)
- Project 2 (ID and name)
- Project 3 (ID and name)
- ...

My problem is with property Projects_Worked _In. A worker could have
been in many projects. I don't know how many projects a worker has
worked at. It could be only 1 project or 5 projects.

How would you desing this property Projects_Worked _In of class Worker?

I was thinking to:
- Define 50 properties like Project1, Project2, Project3,... Project50,
all of them initialized in NULL
- Define a property Number_Of_Proje cts and according to that I will
know if I have to display Project1, Project2, Project3, etc.

Problem is what happen if Number_Of_Proje cts 50

Thank you for your help !

[Jon Paal]

pass it in as a delimited string then parse it in the class.
"Big George" <jb*****@gmail. comwrote in message news:11******** **************@ b28g2000cwb.goo glegroups.com.. .

Hello,

I develop in ASP.NET with VB.NET code.

I need some help constructing a class: Worker. I'm designing the
properties of this class.
The class is filled reading tables in database.

Properties of Class Worker:
- ID_Card
- Names of Person
- ID_Current_Comp any
- Name of Current Company
- Is Worker working at the company? (Yes, No)
- Projects that worker worked in
- Project 1 (ID and name)
- Project 2 (ID and name)
- Project 3 (ID and name)
- ...

My problem is with property Projects_Worked _In. A worker could have
been in many projects. I don't know how many projects a worker has
worked at. It could be only 1 project or 5 projects.

How would you desing this property Projects_Worked _In of class Worker?

I was thinking to:
- Define 50 properties like Project1, Project2, Project3,... Project50,
all of them initialized in NULL
- Define a property Number_Of_Proje cts and according to that I will
know if I have to display Project1, Project2, Project3, etc.

Problem is what happen if Number_Of_Proje cts 50

Thank you for your help !

[Mark Fitzpatrick]

You use a collection instead. You could actually do this in several ways.
You could create a NameValueCollec tion (located in the
System.Collecti ons.Specialized namespace). This way you could put an id and
name into the collection. In this case, most people would probably put the
ID number as the name, and the name of the project as the value. You create
the namevaluecollec tion just as you would any other field. Then, you can add
projects to it as needed.

for example:
// initialize the collection
private NameValueCollec tion col = new NameValueCollec tion

then you can add to it such as:
col.Add(Id1.ToS tring(),"Projec tName1");
That's assuming that Id1 is a number.

Now, what if you wanted to make that a property. You woud do it like so

public NameValueCollec tion Projects
{
get
{
return col;
}
set
{
col = value;
}
}
You cuold then access it like so:
Worker.Projects .Add("1","Proje ct1");
--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Big George" <jb*****@gmail. comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .

Hello,

I develop in ASP.NET with VB.NET code.

I need some help constructing a class: Worker. I'm designing the
properties of this class.
The class is filled reading tables in database.

Properties of Class Worker:
- ID_Card
- Names of Person
- ID_Current_Comp any
- Name of Current Company
- Is Worker working at the company? (Yes, No)
- Projects that worker worked in
- Project 1 (ID and name)
- Project 2 (ID and name)
- Project 3 (ID and name)
- ...

My problem is with property Projects_Worked _In. A worker could have
been in many projects. I don't know how many projects a worker has
worked at. It could be only 1 project or 5 projects.

How would you desing this property Projects_Worked _In of class Worker?

I was thinking to:
- Define 50 properties like Project1, Project2, Project3,... Project50,
all of them initialized in NULL
- Define a property Number_Of_Proje cts and according to that I will
know if I have to display Project1, Project2, Project3, etc.

Problem is what happen if Number_Of_Proje cts 50

Thank you for your help !

[Robert Haken [MVP]]

Properties of Class Worker:

- ID_Card
- Names of Person
- ID_Current_Comp any
- Name of Current Company
- Is Worker working at the company? (Yes, No)
- Projects that worker worked in
- Project 1 (ID and name)
- Project 2 (ID and name)
- Project 3 (ID and name)
- ...

My problem is with property Projects_Worked _In. A worker could have
been in many projects. I don't know how many projects a worker has
worked at. It could be only 1 project or 5 projects.

How would you desing this property Projects_Worked _In of class Worker?

I was thinking to:
- Define 50 properties like Project1, Project2, Project3,... Project50,
all of them initialized in NULL
- Define a property Number_Of_Proje cts and according to that I will
know if I have to display Project1, Project2, Project3, etc.

Problem is what happen if Number_Of_Proje cts 50

Forget these ways to hell...

1) You have to make second class - Project (props ID and Name).
2) Add property Worker.Projects of type IList(Of Project), or other
collection-type.

....than, you can have any number of project that the worker worked on and
coding like this:
Worker.Project. Add(FirstProjec t)
Worker.Project. Add(SecondProje ct)
Worker.Project. Remove(FirstPro ject)
Worker.Project. Count

Robert Haken [MVP ASP/ASP.NET]
HAVIT, s.r.o., www.havit.cz
http://knowledge-base.havit.cz

[Big George]

Thank you Robert !

>
Forget these ways to hell...

1) You have to make second class - Project (props ID and Name).
2) Add property Worker.Projects of type IList(Of Project), or other
collection-type.

...than, you can have any number of project that the worker worked on and
coding like this:
Worker.Project. Add(FirstProjec t)
Worker.Project. Add(SecondProje ct)
Worker.Project. Remove(FirstPro ject)
Worker.Project. Count

Robert Haken [MVP ASP/ASP.NET]
HAVIT, s.r.o., www.havit.cz
http://knowledge-base.havit.cz

[Big George]

Maybe you are stil on line:

How do you declare and instance these classes:

Private oWorker as Worker(myID_Car d)

' Then how do you instance or call class "Project" ?
' Is enough to do:
oWorker.Project .Add(FirstProje ct)

But .NET doesn't allow this

Sorry about my ignorance

[Sean Chambers]

It depends on what type the "Project" field is.

Let's just say for the sake of argument that it's some type of
collection, Depending on the requirements of the class, you usually
instantiate it when you make a new instance of your Worker class:

public class Worker {

private List<Project_pr ojects;
public List<ProjectPro jects {
get { return _projects; }
set { _projects = value; }
}

public Worker() {
_projects = new List<Project>() ;
}
}

Then, whereever else in your code you can then add like so:

private oWorker = new Worker();
oWorker.Project s.Add(FirstProj ect);
oWorker.Project s.Add(SecondPro ject);
int projectCount = oWorker.Project s.Count;

you get the idea.

hope that helps!

Sean

Big George wrote:

Maybe you are stil on line:

How do you declare and instance these classes:

Private oWorker as Worker(myID_Car d)

' Then how do you instance or call class "Project" ?
' Is enough to do:
oWorker.Project .Add(FirstProje ct)

But .NET doesn't allow this

Sorry about my ignorance