private void LoadDDLs() { Pilot Allpilots = new Pilot(); Allpilots.LoadAll(); uiDropDownListPilots.DataSource = Allpilots.DefaultView; uiDropDownListPilots.DataTextField = "ShortName"; uiDropDownListPilots.DataValueField = "PilotID"; uiDropDownListPilots.DataBind(); uiDropDownListPilots.Items.Insert(0, new ListItem("Select Pilot", "")); AirPlane AllPlanes = new AirPlane(); AllPlanes.LoadAll(); uiDropDownListAirplane.DataSource = AllPlanes.DefaultView; uiDropDownListAirplane.DataTextField = "Name"; uiDropDownListAirplane.DataValueField = "AirPlaneID"; uiDropDownListAirplane.DataBind(); uiDropDownListAirplane.Items.Insert(0, new ListItem("All", "0")); AirPort AllAirports = new AirPort(); AllAirports.LoadAll(); uiDropDownListFrom.DataSource = AllAirports.DefaultView; uiDropDownListFrom.DataTextField = "IATACode"; uiDropDownListFrom.DataValueField = "AirPortID"; uiDropDownListFrom.DataBind(); uiDropDownListFrom.Items.Insert(0, new ListItem("Select Airport", "0")); uiDropDownListTo.DataSource = AllAirports.DefaultView; uiDropDownListTo.DataTextField = "IATACode"; uiDropDownListTo.DataValueField = "AirPortID"; uiDropDownListTo.DataBind(); uiDropDownListTo.Items.Insert(0, new ListItem("Select Airport", "0")); }
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", "")); uiDropDownListSectorTo.DataSource = AllAirports.DefaultView; uiDropDownListSectorTo.DataTextField = "IATACode"; uiDropDownListSectorTo.DataValueField = "AirPortID"; uiDropDownListSectorTo.DataBind(); uiDropDownListSectorTo.Items.Insert(0, new ListItem("Select Airport", "")); AirPlane Ap = new AirPlane(); Ap.LoadAll(); uiDropDownListAirCraftRegistration.DataSource = Ap.DefaultView; uiDropDownListAirCraftRegistration.DataTextField = "Name"; uiDropDownListAirCraftRegistration.DataValueField = "AirPlaneID"; uiDropDownListAirCraftRegistration.DataBind(); }
private void LoadDDLs() { 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")); AirPlane Ap = new AirPlane(); Ap.LoadAll(); uiDropDownListAirCraftRegistration.DataSource = Ap.DefaultView; uiDropDownListAirCraftRegistration.DataTextField = "Name"; uiDropDownListAirCraftRegistration.DataValueField = "AirPlaneID"; uiDropDownListAirCraftRegistration.DataBind(); SectorClients SC = new SectorClients(); SC.LoadAll(); uiDropDownListClients.DataSource = SC.DefaultView; uiDropDownListClients.DataTextField = "Name"; uiDropDownListClients.DataValueField = "ClientID"; uiDropDownListClients.DataBind(); uiDropDownListClients.Items.Insert(0, new ListItem("Select Client", "0")); }
protected void uiRadGridFlights_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item.ItemType == Telerik.Web.UI.GridItemType.Item || e.Item.ItemType == Telerik.Web.UI.GridItemType.AlternatingItem) { DataRowView row = (DataRowView)e.Item.DataItem; AirPlane plane = new AirPlane(); plane.LoadByPrimaryKey(Convert.ToInt32(row["AirCraft_AirPlaneID"].ToString())); Label l = (Label)e.Item.FindControl("uiLabelAirCraft"); l.Text = plane.Name; //Sector sectors = new Sector(); //sectors.GetSectorsByFlightID(Convert.ToInt32(row["ReportID"].ToString())); //foreach (DataRowView item in sectors.DefaultView) //{ if (!string.IsNullOrEmpty(row["ChoxOn"].ToString()) && !string.IsNullOrEmpty(row["ChoxOff"].ToString())) { if (DateTime.Parse(row["ChoxOn"].ToString()).Subtract(DateTime.Parse(row["ChoxOff"].ToString())) == TimeSpan.Zero) { e.Item.BackColor = Color.FromArgb(240, 176, 106); //break; } else { e.Item.BackColor = Color.LightBlue; } } else { e.Item.BackColor = Color.FromArgb(240, 176, 106); } if (Roles.IsUserInRole("Commercial") || Roles.IsUserInRole("SuperAdmin") || Roles.IsUserInRole("Operation")) { LinkButton delButton = (LinkButton)e.Item.FindControl("uiLinkButtonDelete"); if(delButton != null) delButton.Visible = true; } if (Roles.IsUserInRole("Operation") || Roles.IsUserInRole("SuperAdmin") ) { LinkButton delButton = (LinkButton)e.Item.FindControl("uiLinkButtonEditPilots"); if (delButton != null) delButton.Visible = true; } if (Roles.IsUserInRole("CabinCrew Admin") || Roles.IsUserInRole("SuperAdmin")) { LinkButton delButton = (LinkButton)e.Item.FindControl("uiLinkButtonCrew"); if (delButton != null) delButton.Visible = true; } //} } }
protected void uiRadGridFlights_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item.ItemType == Telerik.Web.UI.GridItemType.Item || e.Item.ItemType == Telerik.Web.UI.GridItemType.AlternatingItem) { DataRowView row = (DataRowView)e.Item.DataItem; AirPlane plane = new AirPlane(); plane.LoadByPrimaryKey(Convert.ToInt32(row["AirCraft_AirPlaneID"].ToString())); Label l = (Label)e.Item.FindControl("uiLabelAirCraft"); l.Text = plane.Name; //Sector sectors = new Sector(); //sectors.GetSectorsByFlightID(Convert.ToInt32(row["ReportID"].ToString())); //foreach (DataRowView item in sectors.DefaultView) //{ if (!string.IsNullOrEmpty(row["ChoxOn"].ToString()) && !string.IsNullOrEmpty(row["ChoxOff"].ToString())) { if (DateTime.Parse(row["ChoxOn"].ToString()).Subtract(DateTime.Parse(row["ChoxOff"].ToString())) == TimeSpan.Zero) { e.Item.BackColor = Color.FromArgb(240,176,106); //break; } else { e.Item.BackColor = Color.LightBlue; } } else { e.Item.BackColor = Color.FromArgb(240, 176, 106); } //} } }