/// <summary> /// Determines if a cell change its value, through calling Trivia.CheckDataIntegrity() method, /// in order to determine if this value is congruent or not. /// </summary> /// <param name="sender">Object that is a dataGridView cell type</param> /// <param name="e">This contains event info about object</param> private void dataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e) { //Make sure the clicked row/column is valid. Boolean validClick = (e.RowIndex != -1 && e.ColumnIndex != -1); if ((validClick) && (e.ColumnIndex == Constants.K_ColumnValue) && (Trivia.VerifyTypeCellCombo(dgvConfig[Constants.K_ColumnTag, e.RowIndex].Value.ToString(), ref ListCombo))) { dgvConfig.Refresh(); String myTag = dgvConfig[Constants.K_ColumnTag, e.RowIndex].Value.ToString(); String myValue = dgvConfig[Constants.K_ColumnValue, e.RowIndex].Value.ToString(); String myDescription = dgvConfig[Constants.K_ColumnDescriptionHidden, e.RowIndex].Value.ToString(); //TODO: determine cases if (!DictionaryUtils.CheckDataIntegrity(ref DictionaryAllRows, myTag, myValue)) { return; } DictionaryUtils.UpdateCustomValue(myTag, myValue, myDescription, ref DictionaryAllRows); } }
/// <summary> /// This method create a DataTable object which is loaded with a filtered dictionary. /// Then it creates two column. /// <list type="Column"> /// <item> It contains values and (depending on type of key/tag) it is modified into combo or button (invisible).</item> /// <item> A column where store the original value read of config file (remember this method is called by ReadConfigFile()!).</item> /// </list> /// </summary> /// Finally set datagridview. /// <param name="DictionaryDataSource">This parameter is a dictionary (filtered if it is possible) as datagridview datasource.</param> private void SetDataGridView(Dictionary <String, DefinitionTag> DictionaryDataSource) { CloseConnection(); dgvConfig.ColumnHeadersDefaultCellStyle.ForeColor = Color.Chocolate; dgvConfig.ColumnHeadersDefaultCellStyle.BackColor = Color.Lavender; dgvConfig.EnableHeadersVisualStyles = false; dgvConfig.Visible = false; gbConfFile.Text = "Reading Configuration file..."; dgvConfig.AutoGenerateColumns = true; var filteredValues = DictionaryUtils.GetQuery(txtSearch.Text.Trim(), DictionaryAllRows); DataTable dt = new DataTable(); dt.Columns.Add("TAG", typeof(String)); dt.Columns.Add("Value", typeof(String)); dt.Columns.Add("Description", typeof(String)); dt.Columns.Add("OriginalValue", typeof(String)); //http://robertgreiner.com/2010/05/iterating-through-a-dictionary-in-csharp/ foreach (KeyValuePair <String, DefinitionTag> x in filteredValues) { dt.Rows.Add(x.Key, x.Value.Value, x.Value.Description); } dgvConfig.DataSource = dt; dgvConfig.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dgvConfig.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None; dgvConfig.AllowUserToResizeRows = false; //progress bar... gbProgressBar.Visible = true; gbProgressBar.Maximum = dgvConfig.Rows.Count * 2; gbProgressBar.Step = 1; gbProgressBar.Value = 0; this.Refresh(); Int32 q = 0; for (Int32 x = 0; x < dgvConfig.Rows.Count; x++) { String myTag = dgvConfig[Constants.K_ColumnTag, x].Value.ToString(); String myValue = dgvConfig[Constants.K_ColumnValue, x].Value.ToString(); if (Trivia.VerifyTypeCellButton(myTag, ref ListButton)) { //DEPRECATED //DataGridViewButtonCell bt = new DataGridViewButtonCell(); //bt.Value = kButtonText; //dgvConfig[kColumnActions, x] = bt; //DEPRECATED -- END String tmp = dgvConfig[Constants.K_ColumnValue, x].Value.ToString().Replace("\"", ""); dgvConfig[Constants.K_ColumnValue, x].Value = tmp; dgvConfig[Constants.K_ColumnOriginalValue, x].Value = tmp; //if (txtSearch.Text.Length == 0) UpdateCustomValue(myTag, tmp); } else if (Trivia.VerifyTypeCellCombo(myTag, ref ListCombo)) { DataGridViewComboBoxCell cb = new DataGridViewComboBoxCell(); cb.FlatStyle = FlatStyle.Flat; Trivia.FillCombo(ref cb, myTag); dgvConfig[Constants.K_ColumnValue, x] = cb; dgvConfig.Refresh(); dgvConfig.Rows[x].Cells[Constants.K_ColumnValue].Value = myValue; dgvConfig[Constants.K_ColumnOriginalValue, x].Value = myValue; //if (txtSearch.Text.Length == 0) UpdateCustomValue(myTag, myValue); } else { if (Trivia.TestingDotLineDescription(myTag)) { //TODO: regex... //(.*) etc //####myValue= myValue.Replace( } //UpdateCustomValue(myTag, myValue); } q += 1; gbProgressBar.Value = q; } this.Refresh(); dgvConfig.Columns[Constants.K_ColumnOriginalValue].Visible = false; dgvConfig.Columns[Constants.K_ColumnDescriptionHidden].Visible = true; //set autosize mode dgvConfig.Columns[Constants.K_ColumnTag].AutoSizeMode = DataGridViewAutoSizeColumnMode.None; dgvConfig.Columns[Constants.K_ColumnValue].AutoSizeMode = DataGridViewAutoSizeColumnMode.None; dgvConfig.Columns[Constants.K_ColumnTag].Width = Constants.K_ColWidthTag; dgvConfig.Columns[Constants.K_ColumnValue].Width = dgvConfig.Width - dgvConfig.Columns[Constants.K_ColumnTag].Width - Constants.K_ColWidthFillUp; dgvConfig.Visible = true; dgvConfig.Rows[0].Selected = true; txtDescription.Text = dgvConfig.Rows[0].Cells[Constants.K_ColumnDescriptionHidden].Value.ToString().Replace("\r\n", "");; gbConfFile.Text = "Configuration file: nr " + dgvConfig.Rows.Count.ToString() + " rows"; gbConfFile.ForeColor = Color.GreenYellow; dgvConfig.Refresh(); gbProgressBar.Value = 0; gbProgressBar.Visible = false; }