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);
                }
                //}
            }
        }