private void LoadDgvBids()
{
DataTable dataTable = SearchBid.GetAssociated(CurrentSearch);
var dataTableEnum = dataTable.AsEnumerable();
/// Set the datatable based on the SelectedIndex of <see cref="cboBidViews"/>.
switch (cboBidViews.SelectedIndex)
{
case 0:
dataTableEnum = dataTableEnum.Where(x => x.Field <int>("StateCode") == 0);
break;
case 1:
dataTableEnum = dataTableEnum.Where(x => x.Field <int>("StateCode") == 1);
break;
default:
return;
}
if (dataTableEnum.Any())
{
dataTable = dataTableEnum.CopyToDataTable();
}
else
{
dataTable.Rows.Clear();
}
dataTable.Columns.Add("RecordKeeper", typeof(string));
dgvBids.DataSource = dataTable;
// Display/order the columns.
dgvBids.Columns["SearchBidId"].Visible = false;
dgvBids.Columns["SearchId"].Visible = false;
dgvBids.Columns["RecordKeeperId"].Visible = false;
dgvBids.Columns["Email"].Visible = false;
dgvBids.Columns["ConfirmInvestments"].Visible = false;
dgvBids.Columns["ConfirmServices"].Visible = false;
dgvBids.Columns["RequiredRevenueExplanation"].Visible = false;
dgvBids.Columns["AncillaryServices"].Visible = false;
dgvBids.Columns["Notes"].Visible = false;
dgvBids.Columns["ModifiedBy"].Visible = false;
dgvBids.Columns["ModifiedOn"].Visible = false;
dgvBids.Columns["CreatedBy"].Visible = false;
dgvBids.Columns["CreatedOn"].Visible = false;
dgvBids.Columns["StateCode"].Visible = false;
dgvBids.Columns["FullName"].DisplayIndex = 0;
dgvBids.Columns["RecordKeeper"].DisplayIndex = 1;
dgvBids.Columns["RequiredRevenue"].DisplayIndex = 2;
dgvBids.Columns["IsFinalist"].DisplayIndex = 3;
dgvBids.Columns["IsRecommended"].DisplayIndex = 4;
int rowIndex = 0;
foreach (DataGridViewRow dr in dgvBids.Rows)
{
Guid recordKeeperId = new Guid(dr.Cells["RecordKeeperId"].Value.ToString());
DataIntegrationHub.Business.Entities.RecordKeeper recordKeeper = new DataIntegrationHub.Business.Entities.RecordKeeper(recordKeeperId);
dgvBids.Rows[rowIndex].Cells["RecordKeeper"].Value = recordKeeper.Name;
rowIndex++;
}
}
