public void LoadSearchQuestions(Search search)
{
DataTable dataTable = SearchQuestion.GetAssociated(search);
foreach (DataRow dr in dataTable.Rows)
{
var searchQuestionId = new Guid(dr["SearchQuestionId"].ToString());
var searchQuestion = new SearchQuestion(searchQuestionId);
SearchQuestions.Add(searchQuestion);
var searchBidQuestion = new SearchBidQuestion();
searchBidQuestion.SearchBidId = searchBid.Id;
searchBidQuestion.SearchQuestionId = searchQuestion.Id;
searchBidQuestions.Add(searchBidQuestion);
}
}
private void LoadDgvQuestions()
{
DataTable dataTable = SearchQuestion.GetAssociated(CurrentSearch);
var dataTableEnum = dataTable.AsEnumerable();
/// Set the datatable based on the SelectedIndex of <see cref="cboResultsView"/>.
switch (cboQuestionViews.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();
}
dgvQuestions.DataSource = dataTable;
// Display/order the columns.
dgvQuestions.Columns["SearchQuestionId"].Visible = false;
dgvQuestions.Columns["SearchId"].Visible = false;
dgvQuestions.Columns["ModifiedBy"].Visible = false;
dgvQuestions.Columns["ModifiedOn"].Visible = false;
dgvQuestions.Columns["CreatedBy"].Visible = false;
dgvQuestions.Columns["CreatedOn"].Visible = false;
dgvQuestions.Columns["StateCode"].Visible = false;
dgvQuestions.Columns["SubjectValue"].DisplayIndex = 0;
dgvQuestions.Columns["AnswerValue"].DisplayIndex = 1;
}
private void LoadDgvQuestions()
{
int currentCellRow = 0;
int currentCellCol = 0;
if (dgvQuestions.CurrentCell != null)
{
currentCellRow = dgvQuestions.CurrentCell.RowIndex;
currentCellCol = dgvQuestions.CurrentCell.ColumnIndex;
}
DataTable dataTable = SearchQuestion.GetAssociated(CurrentSearch);
var dataTableEnum = dataTable.AsEnumerable();
/// Set the datatable based on the SelectedIndex of <see cref="cboResultsView"/>.
switch (cboQuestionViews.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();
}
dgvQuestions.DataSource = dataTable;
// Display/order the columns.
dgvQuestions.Columns["SearchQuestionId"].Visible = false;
dgvQuestions.Columns["SearchId"].Visible = false;
dgvQuestions.Columns["ModifiedBy"].Visible = false;
dgvQuestions.Columns["ModifiedOn"].Visible = false;
dgvQuestions.Columns["CreatedBy"].Visible = false;
dgvQuestions.Columns["CreatedOn"].Visible = false;
dgvQuestions.Columns["StateCode"].Visible = false;
dgvQuestions.Columns["SubjectValue"].DisplayIndex = 0;
dgvQuestions.Columns["AnswerValue"].DisplayIndex = 1;
if (dgvQuestions.RowCount > 0 && dgvQuestions.ColumnCount > 0)
{
DataGridViewCell selectedCell = dgvQuestions.Rows[currentCellRow].Cells[currentCellCol];
if (selectedCell != null && selectedCell.Visible)
{
dgvQuestions.CurrentCell = selectedCell;
}
else
{
dgvQuestions.CurrentCell = dgvQuestions.FirstDisplayedCell;
}
}
}
