private void LoadDDLs() { Delay delays = new Delay(); delays.LoadAll(); uiDropDownListArrDelay1Code.DataSource = delays.DefaultView; uiDropDownListArrDelay1Code.DataTextField = "Code"; uiDropDownListArrDelay1Code.DataValueField = "DelayID"; uiDropDownListArrDelay1Code.DataBind(); uiDropDownListArrDelay1Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListArrDelay2Code.DataSource = delays.DefaultView; uiDropDownListArrDelay2Code.DataTextField = "Code"; uiDropDownListArrDelay2Code.DataValueField = "DelayID"; uiDropDownListArrDelay2Code.DataBind(); uiDropDownListArrDelay2Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListArrDelay3Code.DataSource = delays.DefaultView; uiDropDownListArrDelay3Code.DataTextField = "Code"; uiDropDownListArrDelay3Code.DataValueField = "DelayID"; uiDropDownListArrDelay3Code.DataBind(); uiDropDownListArrDelay3Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListDelay1Code.DataSource = delays.DefaultView; uiDropDownListDelay1Code.DataTextField = "Code"; uiDropDownListDelay1Code.DataValueField = "DelayID"; uiDropDownListDelay1Code.DataBind(); uiDropDownListDelay1Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListDelay2Code.DataSource = delays.DefaultView; uiDropDownListDelay2Code.DataTextField = "Code"; uiDropDownListDelay2Code.DataValueField = "DelayID"; uiDropDownListDelay2Code.DataBind(); uiDropDownListDelay2Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListDelay3Code.DataSource = delays.DefaultView; uiDropDownListDelay3Code.DataTextField = "Code"; uiDropDownListDelay3Code.DataValueField = "DelayID"; uiDropDownListDelay3Code.DataBind(); uiDropDownListDelay3Code.Items.Insert(0, new ListItem("Select Code", "")); }
/*private void BindSectors() { Sector Sectors = new Sector(); Sectors.GetSectorsByFlightID(CurrentFlightReport.ReportID); uiGridViewSectors.DataSource = Sectors.DefaultView; uiGridViewSectors.DataBind(); }*/ private void LoadDDLs() { Pilot Allpilots = new Pilot(); Allpilots.GetAllPilots(); uiDropDownListPilot.DataSource = Allpilots.DefaultView; uiDropDownListPilot.DataTextField = "DisplayName"; uiDropDownListPilot.DataValueField = "PilotID"; uiDropDownListPilot.DataBind(); uiDropDownListPilot.Items.Insert(0, new ListItem("Select Pilot", "")); Pilot AllCopilots = new Pilot(); AllCopilots.GetAllCoPilots(); uiDropDownListCoPilot.DataSource = AllCopilots.DefaultView; uiDropDownListCoPilot.DataTextField = "DisplayName"; uiDropDownListCoPilot.DataValueField = "PilotID"; uiDropDownListCoPilot.DataBind(); uiDropDownListCoPilot.Items.Insert(0, new ListItem("Select Co-Pilot", "")); Position AllPositions = new Position(); AllPositions.LoadAll(); uiDropDownListPilotPos.DataSource = AllPositions.DefaultView; uiDropDownListPilotPos.DataTextField= "Title"; uiDropDownListPilotPos.DataValueField = "PositionID"; uiDropDownListPilotPos.DataBind(); uiDropDownListPilotPos.Items.Insert(0, new ListItem("Select Position", "")); uiDropDownListCOPos.DataSource = AllPositions.DefaultView; uiDropDownListCOPos.DataTextField = "Title"; uiDropDownListCOPos.DataValueField = "PositionID"; uiDropDownListCOPos.DataBind(); uiDropDownListCOPos.Items.Insert(0, new ListItem("Select Position", "")); Crew AllCrew = new Crew(); AllCrew.LoadAll(); uiDropDownListCrew.DataSource = AllCrew.DefaultView; uiDropDownListCrew.DataTextField = "Name"; uiDropDownListCrew.DataValueField = "CrewID"; uiDropDownListCrew.DataBind(); uiDropDownListCrew.Items.Insert(0, new ListItem("Select Member", "")); uiDropDownListCrewPos.DataSource = AllPositions.DefaultView; ; uiDropDownListCrewPos.DataTextField = "Title"; uiDropDownListCrewPos.DataValueField = "PositionID"; uiDropDownListCrewPos.DataBind(); uiDropDownListCrewPos.Items.Insert(0, new ListItem("Select Position", "")); AirPort AllAirports= new AirPort(); AllAirports.LoadAll(); uiDropDownListSectorFrom.DataSource = AllAirports.DefaultView; uiDropDownListSectorFrom.DataTextField = "IATACode"; uiDropDownListSectorFrom.DataValueField = "AirPortID"; uiDropDownListSectorFrom.DataBind(); uiDropDownListSectorFrom.Items.Insert(0, new ListItem("Select Airport", "0")); uiDropDownListSectorTo.DataSource = AllAirports.DefaultView; uiDropDownListSectorTo.DataTextField = "IATACode"; uiDropDownListSectorTo.DataValueField = "AirPortID"; uiDropDownListSectorTo.DataBind(); uiDropDownListSectorTo.Items.Insert(0, new ListItem("Select Airport", "0")); Delay delays = new Delay(); delays.LoadAll(); uiDropDownListArrDelay1Code.DataSource = delays.DefaultView; uiDropDownListArrDelay1Code.DataTextField = "Code"; uiDropDownListArrDelay1Code.DataValueField = "DelayID"; uiDropDownListArrDelay1Code.DataBind(); uiDropDownListArrDelay1Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListArrDelay2Code.DataSource = delays.DefaultView; uiDropDownListArrDelay2Code.DataTextField = "Code"; uiDropDownListArrDelay2Code.DataValueField = "DelayID"; uiDropDownListArrDelay2Code.DataBind(); uiDropDownListArrDelay2Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListArrDelay3Code.DataSource = delays.DefaultView; uiDropDownListArrDelay3Code.DataTextField = "Code"; uiDropDownListArrDelay3Code.DataValueField = "DelayID"; uiDropDownListArrDelay3Code.DataBind(); uiDropDownListArrDelay3Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListDelay1Code.DataSource = delays.DefaultView; uiDropDownListDelay1Code.DataTextField = "Code"; uiDropDownListDelay1Code.DataValueField = "DelayID"; uiDropDownListDelay1Code.DataBind(); uiDropDownListDelay1Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListDelay2Code.DataSource = delays.DefaultView; uiDropDownListDelay2Code.DataTextField = "Code"; uiDropDownListDelay2Code.DataValueField = "DelayID"; uiDropDownListDelay2Code.DataBind(); uiDropDownListDelay2Code.Items.Insert(0, new ListItem("Select Code", "")); uiDropDownListDelay3Code.DataSource = delays.DefaultView; uiDropDownListDelay3Code.DataTextField = "Code"; uiDropDownListDelay3Code.DataValueField = "DelayID"; uiDropDownListDelay3Code.DataBind(); uiDropDownListDelay3Code.Items.Insert(0, new ListItem("Select Code", "")); AirPlane Ap = new AirPlane(); Ap.LoadAll(); uiDropDownListAirCraftRegistration.DataSource = Ap.DefaultView; uiDropDownListAirCraftRegistration.DataTextField = "Name"; uiDropDownListAirCraftRegistration.DataValueField = "AirPlaneID"; uiDropDownListAirCraftRegistration.DataBind(); }