Hello,
I'm having a problem displaying an entity collection in a combo box. I think it is probably my inexperience with Windows Forms, but I can't figure out where to add some code.
I am using LLBLGen Pro 2.5 Final (Feb 4, 2008 ) and working through the tutorial AW (AW.Data, AW.WIN projects) from "Rapid C# Development, Visual Studio 2005, SQL Server 2005 & LLBLGen Pro", by Joseph Chancellor. I have Microsoft SQL Server 2005 (SQL Express) running locally. I'm using .Net 20, Self-servicing, two classes.
I am working on a form (frmOrganization) which displays a tree view of employees (a tree of entity nodes) in an organization when the employee number is put in a combo box and then search button returns the nodes. I was able to complete the form successfully, where you enter the employee number and then see a list of all employees related to that person (managers and people supervised). So the database connection seems fine and the basic form works.
The next step is to change the code by populating the combo box with a list of employee names. This is where I'm not sure what to do. (The form compiles and runs, but I don't get values populated in the combo box.) I modified the EmployeeEntity.cs code generated by LLBLGen, extending the business logic layer, by both importing AW.Data.HelperClasses namespace and adding the custom code from the tutorial. (I've pasted the code added to EmployeeEntity.cs below, as well as the current code for the form, without the "frmOrganization_Load" part.
The next part of the tutorials says to add to the frmOrganization form, "in the form Load event" handler, the following code:
private void frmOrganization_Load(object sender, EventArgs e)
{
cbEmployee.DataSource = EmpllyeeEntity.GetEmployees();
cbEmployee.DisplayMember = "EmployeeDisplayName";
cbEmployee.ValueMember = EmployeeFieldIndex.EmployeeId.ToString();
}
And I can't figure out where to put this code. Is it done through the GUI? Via properties? Dragged from the toolbox area? I've tried putting it directly in the frmOrganization.cs code in a variety of places. I either get an error about the context not being correct or it compiles and runs, but without any data displayed.
Thanks for any suggestions,
Carol
Here is the added the namespace at the top of EmployeeEntity.cs and added CustomEntityCode:
using AW.Data.HelperClasses;
// __LLBLGENPRO_USER_CODE_REGION_START CustomEntityCode
public static EmployeeCollection GetEmployees()
{
RelationCollection Relations = new RelationCollection();
Relations.Add(EmployeeEntity.Relations.ContactEntityUsingContactId);
ISortExpression LastFirstAlpha =
(ContactFields.LastName | SortOperator.Ascending)
& (ContactFields.FirstName | SortOperator.Ascending);
EmployeeCollection Employees = new EmployeeCollection();
Employees.GetMulti(null,0,LastFirstAlpha,Relations);
return Employees;
}
public String EmployeeDisplayName
{
get
{
return this.Contact.LastName + ", " + this.Contact.FirstName;
}
}
// __LLBLGENPRO_USER_CODE_REGION_END
And here is the frmOrganization,without the Load event part:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using AW.Data;
using AW.Data.EntityClasses;
using AW.Data.CollectionClasses;
using AW.Data.HelperClasses;
using SD.LLBLGen.Pro.ORMSupportClasses;
namespace AW.WIN
{
public partial class frmOrganization : Form
{
public frmOrganization()
{
InitializeComponent();
}
private TreeNode FindLowestNode(TreeNode Node)
{
if (Node.Nodes.Count > 0)
return FindLowestNode(Node.Nodes[0]);
else
return Node;
}
private TreeNode MakeNode(EmployeeEntity Employee)
{
TreeNode MyNode = new TreeNode(Employee.Contact.LastName
+ ", " + Employee.Contact.FirstName + " ["
+ Employee.EmployeeId.ToString() + " ]");
MyNode.Tag = Employee.EmployeeId;
return MyNode;
}
private TreeNode GetManagersRecursive(EmployeeEntity Employee)
{
TreeNode EmployeeNode = MakeNode(Employee);
if (Employee.ManagerId != null)
{
TreeNode ManagerNode = GetManagersRecursive(Employee.Manager);
FindLowestNode(ManagerNode).Nodes.Add(EmployeeNode);
return ManagerNode;
}
return EmployeeNode;
}
private TreeNode GetEmployeesRecursive(EmployeeEntity Employee)
{
TreeNode EmployeeNode = MakeNode(Employee);
if (Employee.Manages.Count > 0)
{
foreach (EmployeeEntity Subordinate in Employee.Manages)
{
EmployeeNode.Nodes.Add(GetEmployeesRecursive(Subordinate));
}
}
return EmployeeNode;
}
private void btnSearch_Click(object sender, EventArgs e)
{
tvOrganization.Nodes.Clear();
TreeNode MasterNode;
// Here is where I don't have a value selected, as the list of names doesn't show in // the combo box
EmployeeEntity Employee = new EmployeeEntity(
Convert.ToInt32(cbEmployee.SelectedValue));
TreeNode EmployeeNode = MakeNode(Employee);
if (Employee.Manages.Count > 0)
{
foreach (EmployeeEntity Subordiante in Employee.Manages)
{
EmployeeNode.Nodes.Add(GetEmployeesRecursive(Subordiante));
}
}
if (Employee.ManagerId != null)
{
TreeNode ManagersNode = GetManagersRecursive(Employee.Manager);
FindLowestNode(ManagersNode).Nodes.Add(EmployeeNode);
MasterNode = ManagersNode;
}
else
{
MasterNode = EmployeeNode;
}
MasterNode.ExpandAll();
tvOrganization.Nodes.Add(MasterNode);
}
}
}
