private void LoadDgvQuestions()
{
DataTable dataTable = SearchBidQuestion.GetAssociated(CurrentSearchBid);
var dataTableEnum = dataTable.AsEnumerable();
/// Set the datatable based on the SelectedIndex of <see cref="cboQuestionViews"/>.
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();
}
dataTable.Columns.Add("Question", typeof(string));
dgvQuestions.DataSource = dataTable;
// Display/order the columns.
dgvQuestions.Columns["SearchBidQuestionId"].Visible = false;
dgvQuestions.Columns["SearchBidId"].Visible = false;
dgvQuestions.Columns["SearchQuestionId"].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["Question"].DisplayIndex = 0;
dgvQuestions.Columns["AnswerValue"].DisplayIndex = 1;
int rowIndex = 0;
foreach (DataGridViewRow dr in dgvQuestions.Rows)
{
Guid searchQuestionId = new Guid(dr.Cells["SearchQuestionId"].Value.ToString());
SearchQuestion searchQuestion = new SearchQuestion(searchQuestionId);
dgvQuestions.Rows[rowIndex].Cells["Question"].Value = searchQuestion.SubjectValue;
rowIndex++;
}
}
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);
}
}
protected void ButtonSubmit_OnClick(object sender, EventArgs e)
{
searchBid.FullName = fullname.Value;
searchBid.Email = email.Value;
searchBid.ConfirmInvestments = SqlBoolean.Parse(confirminvestments.Checked.ToString());
searchBid.ConfirmServices = SqlBoolean.Parse(confirmservices.Checked.ToString());
searchBid.RequiredRevenue = decimal.Parse(requirerevenue.Value);
searchBid.RequiredRevenueExplanation = requirerevenueexplanation.Value;
searchBid.AncillaryServices = ancillaryservices.Value;
searchBid.SaveRecordToDatabase(new Guid("17F6FCEB-CF02-E411-9726-D8D385C29900"));
foreach (RepeaterItem item in RepeaterSearchQuestions.Items)
{
HiddenField hiddenField = (HiddenField)item.FindControl("SearchQuestionId");
SearchQuestion searchQuestion = new SearchQuestion(new Guid(hiddenField.Value.ToString()));
SearchBidQuestion searchBidQuestion = searchBidQuestions.Find(x => x.SearchQuestionId == searchQuestion.Id);
CheckBox checkBox = (CheckBox)item.FindControl("SearchQuestionAnswer");
searchBidQuestion.AnswerValue = SqlBoolean.Parse(checkBox.Checked.ToString());
searchBidQuestion.SaveRecordToDatabase(new Guid("17F6FCEB-CF02-E411-9726-D8D385C29900"));
}
}
