protected void LoadAgents(bool bIncludeAll)
{
string[] sExcludedAgents = { };
ddlAgents.Items.Clear();
DataTable dt = q.Agents();
ddlAgents.DataTextField = "Distributor";
ddlAgents.DataValueField = "MGMAgentNo";
//if (WebConfigurationManager.AppSettings["ExcludeAgentCode"] != null)
//{
// sExcludedAgents = WebConfigurationManager.AppSettings["ExcludeAgentCode"].ToString().Split(';');
//}
//foreach (string sExclude in sExcludedAgents)
//{
// if (sExclude != "")
// dt = dt.AsEnumerable().Select(r => r).Where(d => Convert.ToInt32(d["MGMAgentNo"]) != Convert.ToInt32(sExclude)).Select(v => v).CopyToDataTable();
//}
DataRow dr = dt.NewRow();
dr["MGMAgentNo"] = -1;
dr["Distributor"] = "Please select an agent...";
dt.Rows.InsertAt(dr, 0);
if (bIncludeAll)
{
dr = dt.NewRow();
dr["MGMAgentNo"] = -2;
dr["Distributor"] = "All Agents";
dt.Rows.InsertAt(dr, 1);
}
ddlAgents.DataSource = dt;
ddlAgents.DataBind();
//ddlAgents.Items.Clear();
//DataTable dt = q.Agents();
//ddlAgents.DataTextField = "Distributor";
//ddlAgents.DataValueField = "MGMAgentNo";
//DataRow dr = dt.NewRow();
//dr["MGMAgentNo"] = -1;
//dr["Distributor"] = "Please select an agent...";
//dt.Rows.InsertAt(dr, 0);
//ddlAgents.DataSource = dt;
//ddlAgents.DataBind();
}
