/// <summary>
/// The PopulateComboBoxes
/// </summary>
internal void PopulateAddTabComboBoxes()
{
DataTable table = new DataBuilder(Source.PRC).Table;
string[] query = table.AsEnumerable().Select(p => p.Field <string>("SubProject")).Distinct().ToArray();
foreach (string row in query)
{
AddSub.Items.Add(row);
}
string[] year = table.AsEnumerable().Select(p => p.Field <string>("BFY")).Distinct().ToArray();
foreach (string s in year)
{
AddYear.Items.Add(s);
}
string[] code = table.AsEnumerable().Select(p => p.Field <string>("Code")).Distinct().ToArray();
foreach (string c in code)
{
AddCode.Items.Add(c);
}
string[] fund = table.AsEnumerable().Select(p => p.Field <string>("FundCode")).Distinct().ToArray();
foreach (string f in fund)
{
AddFund.Items.Add(f);
}
string[] rc = table.AsEnumerable().Select(p => p.Field <string>("RC")).Distinct().ToArray();
foreach (string r in rc)
{
AddRc.Items.Add(r);
}
string[] bl = table.AsEnumerable().Select(p => p.Field <string>("BudgetLevel")).Distinct().ToArray();
foreach (string r in bl)
{
AddLevel.Items.Add(r);
}
string[] org = table.AsEnumerable().Select(p => p.Field <string>("Org")).Distinct().ToArray();
foreach (string oo in org)
{
AddOrg.Items.Add(oo);
}
string[] ah = table.AsEnumerable().Select(p => p.Field <string>("AH")).Distinct().ToArray();
foreach (string a in ah)
{
AddAh.Items.Add(a);
}
string[] boc = table.AsEnumerable().Select(p => p.Field <string>("BOC")).Distinct().ToArray();
foreach (string b in boc)
{
AddBoc.Items.Add(b);
}
}
