private void PopulateComboBoxes()
{
DataBase db;
db = new StaffData();
List <Staff> list = db.GetList().ConvertAll(x => x as Staff);
cmbStaff.DataSource = list;
cmbStaff.DisplayMember = "FullName";
cmbStaff.ValueMember = "PersonId";
cmbStaff.SelectedIndex = -1;
List <Staff> whoReported = new List <Staff>();
List <Staff> coordinators = db.GetList("SELECT * FROM vw_Staff Where TitleId =" + 3).ConvertAll(x => x as Staff);
List <Staff> managers = db.GetList("SELECT * FROM vw_Staff Where TitleId =" + 4).ConvertAll(x => x as Staff);
List <Staff> hsOfficers = db.GetList("SELECT * FROM vw_Staff Where TitleId = " + 6).ConvertAll(x => x as Staff);
whoReported.AddRange(list);
cmbWhoReported.DataSource = whoReported;
cmbWhoReported.DisplayMember = "FullName";
cmbWhoReported.ValueMember = "PersonId";
cmbWhoReported.SelectedIndex = -1;
cmbCoordinator.DataSource = coordinators;
cmbCoordinator.DisplayMember = "FullName";
cmbCoordinator.ValueMember = "PersonId";
cmbCoordinator.SelectedIndex = -1;
cmbManager.DataSource = managers;
cmbManager.DisplayMember = "FullName";
cmbManager.ValueMember = "PersonId";
cmbManager.SelectedIndex = -1;
cmbHSOfficer.DataSource = hsOfficers;
cmbHSOfficer.DisplayMember = "FullName";
cmbHSOfficer.ValueMember = "PersonId";
cmbHSOfficer.SelectedIndex = -1;
db = new StudentData();
List <Student> list5 = db.GetList().ConvertAll(x => x as Student);
cmbStudent.DataSource = list5;
cmbStudent.DisplayMember = "FullName";
cmbStudent.ValueMember = "PersonId";
cmbStudent.SelectedIndex = -1;
LocationData ld = new LocationData();
List <Location> list6 = ld.GetList("SELECT * FROM vw_Locations WHERE IsStudentCentre = true");
cmbLocation.DataSource = list6;
cmbLocation.DisplayMember = "LocationName";
cmbLocation.ValueMember = "LocationId";
cmbLocation.SelectedIndex = -1;
}
private void PopulateLocationCombobox()
{
LocationData ld = new LocationData();
List <Location> locations = ld.GetList("SELECT * FROM vw_Locations WHERE IsResidence=true");
Location location = new Location();
location.LocationId = 0;
location.LocationName = string.Empty;
locations.Insert(0, location);
cmbLocation.DataSource = locations;
cmbLocation.ValueMember = "LocationId";
cmbLocation.DisplayMember = "LocationName";
}
private void PopulateLocations()
{
try
{
LocationData db = new LocationData();
_list = db.GetList();
dgLocation.AutoGenerateColumns = false;
dgLocation.DataSource = _list;
dgLocation.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void populateLocations()
{
LocationData ld = new LocationData();
Locations = ld.GetList();
int i = 0;
foreach (Location wc in Locations)
{
_staffLocationAllocation.checkedListBox1.Items.Add(wc.LocationName);
if (FindWorkCentre(wc.LocationNameWithoutAbbreviation))
{
_staffLocationAllocation.checkedListBox1.SetItemChecked(i, true);
}
i += 1;
}
}
private void PopulateLocationCombobox()
{
LocationData ld = new LocationData();
List <Location> locations = ld.GetList("SELECT * FROM vw_Locations WHERE IsResidence=true");
Location location = new Location();
location.LocationId = 0;
location.LocationName = string.Empty;
locations.Insert(0, location);
cmbLocation.DataSource = locations;
cmbLocation.ValueMember = "LocationId";
cmbLocation.DisplayMember = "LocationName";
;
//cmbLocation.DataBindings.Add("SelectedValue", _student, "LocationId");
//cmbLocation.SelectedIndexChanged += cmbLocation_SelectedIndexChanged;
}
private List <Location> GetResidentLocations()
{
LocationData ld = new LocationData();
return(ld.GetList("SELECT * FROM vw_Locations WHERE IsRollCall=true"));
}
