public static void PopulateClientList(DropDownList ddl)
{
EntitiesNBD db = new EntitiesNBD();
// Reset employee list
ddl.Items.Clear();
ListItem item = new ListItem();
item.Text = "Select a Client...";
item.Value = "-1";
ddl.Items.Add(item);
// Reset the drop down list
var query = from client in db.CLIENTs
select client;
foreach (var c in query)
{
ListItem li = new ListItem();
li.Text = c.cliName;
li.Value = c.ID.ToString();
ddl.Items.Add(li);
}
}
public static void PopulateEmployeeList(DropDownList ddl)
{
EntitiesNBD db = new EntitiesNBD();
// Reset employee list
ddl.Items.Clear();
ListItem item = new ListItem();
item.Text = "Select an Employee...";
item.Value = "-1";
ddl.Items.Add(item);
// Reset the drop down list
var query = from worker in db.WORKERs
select worker;
foreach (var w in query)
{
ListItem li = new ListItem();
li.Text = w.wrkFName + " " + w.wrkLName;
li.Value = w.ID.ToString();
ddl.Items.Add(li);
}
}