private void BindAgents()
    {
        try
        {
            blAr._Action      = "GetAllAgents";
            dtGetReturnedData = dlAr.BindControls(blAr);

            List <BALAgent> agents = new List <BALAgent>();

            if (dtGetReturnedData != null && dtGetReturnedData.Rows.Count > 0)
            {
                foreach (DataRow row in dtGetReturnedData.Rows)
                {
                    BALAgent agent = new BALAgent {
                        AgentId = Convert.ToInt32(row["AgentId"].ToString()), AgentName = DataSecurityManager.Decrypt(row["AgentName"].ToString())
                    };
                    agents.Add(agent);
                }

                List <BALAgent> sortedAgents = agents.OrderBy(a => a.AgentName).ToList();

                ddlAgents.DataSource     = sortedAgents;
                ddlAgents.DataTextField  = "AgentName";
                ddlAgents.DataValueField = "AgentId";
                ddlAgents.DataBind();
                ddlAgents.Items.Insert(0, "-Select-");
            }
            else
            {
                GridAccomodations.DataSource = null;
                GridAccomodations.DataBind();
            }
        }
        catch (Exception sqe)
        {
            GridAccomodations.DataSource = null;
            GridAccomodations.DataBind();
        }
    }
 private void BindAccomGrid()
 {
     try
     {
         blAr._Action      = "GetAccomodations";
         dtGetReturnedData = dlAr.BindControls(blAr);
         if (dtGetReturnedData != null && dtGetReturnedData.Rows.Count > 0)
         {
             GridAccomodations.DataSource = dtGetReturnedData;
             GridAccomodations.DataBind();
         }
         else
         {
             GridAccomodations.DataSource = null;
             GridAccomodations.DataBind();
         }
     }
     catch (Exception sqe)
     {
         GridAccomodations.DataSource = null;
         GridAccomodations.DataBind();
     }
 }