/// <summary> /// /// </summary> /// <param name="mf"></param> /// <param name="Close"></param> public frmSearchQuestion(frmMain mf, Search search, FormClosedEventHandler Close = null) { frmSplashScreen ss = new frmSplashScreen(); ss.Show(); Application.DoEvents(); InitializeComponent(); frmMain_Parent = mf; this.MaximumSize = Screen.PrimaryScreen.WorkingArea.Size; Application.AddMessageFilter(this); controlsToMove.Add(this.pnlSummaryTabHeader); controlsToMove.Add(this.panel16); controlsToMove.Add(this.label1); controlsToMove.Add(this.label23); FormClosed += Close; CurrentSearchQuestion = new SearchQuestion(); CurrentSearchQuestion.SearchId = search.Id; txtSubject.Text = CurrentSearchQuestion.SubjectValue; cboAnswer.Text = "No"; ss.Close(); this.Show(); }
internal static void FillTags(this SearchQuestion searchQuestion) { using (var db = new SovaContext()) { searchQuestion.Tags = db.QuestionTags.Include(qt => qt.Tag).Where(x => x.QuestionId == searchQuestion.Id).Select(qt => qt.Tag).ToList(); } }
private void dgvQuestions_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { int index = dgvQuestions.CurrentRow.Index; Guid searchQuestionId = new Guid(dgvQuestions.Rows[index].Cells["SearchQuestionId"].Value.ToString()); SearchQuestion searchQuestion = new SearchQuestion(searchQuestionId); frmSearchQuestion frmSearchQuestion = new frmSearchQuestion(frmMain_Parent, searchQuestion); frmSearchQuestion.FormClosed += frmSearchQuestion_FormClosed; }
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++; } }
private void btnDeleteQuestion_Click(object sender, EventArgs e) { int index = dgvQuestions.CurrentRow.Index; Guid searchQuestionId = new Guid(dgvQuestions.Rows[index].Cells["SearchQuestionId"].Value.ToString()); SearchQuestion searchQuestion = new SearchQuestion(searchQuestionId); DialogResult result = MessageBox.Show("Are you sure you wish to delete \"" + searchQuestion.SubjectValue + "\"?", "Attention", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { searchQuestion.DeleteRecordFromDatabase(); LoadDgvQuestions(); } }
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; }
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")); } }
/// <summary> /// /// </summary> /// <param name="mf"></param> /// <param name="accountId"></param> /// <param name="Close"></param> public frmSearchQuestion(frmMain mf, SearchQuestion searchQuestion, FormClosedEventHandler Close = null) { frmSplashScreen ss = new frmSplashScreen(); ss.Show(); Application.DoEvents(); InitializeComponent(); frmMain_Parent = mf; this.MaximumSize = Screen.PrimaryScreen.WorkingArea.Size; Application.AddMessageFilter(this); controlsToMove.Add(this.pnlSummaryTabHeader); controlsToMove.Add(this.panel16); controlsToMove.Add(this.label1); controlsToMove.Add(this.label23); FormClosed += Close; CurrentSearchQuestion = searchQuestion; txtSubject.Text = CurrentSearchQuestion.SubjectValue; if (CurrentSearchQuestion.AnswerValue == SqlBoolean.True) { cboAnswer.Text = "Yes"; } else if (CurrentSearchQuestion.AnswerValue == SqlBoolean.False) { cboAnswer.Text = "No"; } CurrentTabLabel = label46; // Summary tab label highlightSelectedTabLabel(CurrentTabLabel); ss.Close(); this.Show(); }
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; } } }