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")); } }