protected void GetITBAandEDICombined()
{
try
{
List <ClsITBA> FullList = repository.GetITBAandEDICombined();
List <int> EmployeeIDs = FullList.GroupBy(p => p.idEmployee).Select(p => p.Key).ToList();
List <ClsITBA> balist = new List <ClsITBA>();
foreach (int i in EmployeeIDs)
{
balist.Add(FullList.Where(p => p.idEmployee == i).FirstOrDefault());
}
ClsITBA all = new ClsITBA();
all.ITBA = "All";
all.idITBA = 0;
balist.Insert(0, all);
rddlITBA.DataSource = balist;
rddlITBA.DataTextField = "ITBA";
rddlITBA.DataValueField = "idITBA";
rddlITBA.DataBind();
rddlITBA.SelectedIndex = 0;
}
catch (Exception ex)
{
var msg = ex.Message;
pnlDanger.Visible = true;
lblDanger.Text = msg;
}
}
