private void dgvPerfomance_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex >= 2) { if (Global.SecurityOperations.CanModifySimulationPerformance(m_strNetworkID, m_strSimulationID)) { if (dgvPerfomance.Rows[e.RowIndex].Cells[0].Value == null) { Global.WriteOutput("Error: Select a performance attribute before editing the performance equation or criteria."); return; } String strAttribute = dgvPerfomance.Rows[e.RowIndex].Cells[0].Value.ToString(); if (strAttribute.Trim().Length == 0) { Global.WriteOutput("Error: Select a performance attribute before editing the performance equation or criteria."); return; } String strCriteria = ""; if (e.ColumnIndex == 2) { Performance performance = (Performance)dgvPerfomance.Rows[e.RowIndex].Tag; if (performance == null) { performance = new Performance(); } FormEditEquation formEditEquation = new FormEditEquation(performance); if (formEditEquation.ShowDialog() == DialogResult.OK) { dgvPerfomance.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = performance.Equation; dgvPerfomance.Update(); } } else if (e.ColumnIndex == 3) { if (dgvPerfomance.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null) { strCriteria = dgvPerfomance.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } FormAdvancedSearch formAdvancedSearch = new FormAdvancedSearch(m_strNetwork, m_hashAttributeYear, strCriteria, true); if (formAdvancedSearch.ShowDialog() == DialogResult.OK) { dgvPerfomance[e.ColumnIndex, e.RowIndex].Value = formAdvancedSearch.GetWhereClause(); } dgvPerfomance.Update(); } } } }
private void editEquationToolStripMenuItem_Click(object sender, EventArgs e) { if (dgvPerfomance.SelectedCells == null) { return; } int nRow = dgvPerfomance.SelectedCells[0].RowIndex; String strEquation = dgvPerfomance[2, nRow].Value.ToString(); String strAttribute = dgvPerfomance[0, nRow].Value.ToString(); FormEditEquation formEditEquation = new FormEditEquation(strEquation, strAttribute); if (formEditEquation.ShowDialog() == DialogResult.OK) { dgvPerfomance.Rows[nRow].Cells[2].Value = formEditEquation.Equation; dgvPerfomance.Update(); } }
private void ORACLEdgvCalculatedCellDoubleClick(DataGridViewCellEventArgs e) { int nRow = e.RowIndex; int nColumn = e.ColumnIndex; String strID = ""; if (nColumn == 0) //Edit equations { String strEquation = ""; String isFunctionTag = "0"; bool isFunction = false; if (dgvCalculated[nColumn, nRow].Value != null) { strEquation = dgvCalculated[nColumn, nRow].Value.ToString(); isFunctionTag = dgvCalculated[0, nRow].Tag.ToString(); if (isFunctionTag == "1") { isFunction = true; } } FormEditEquation formEditEquation = new FormEditEquation(strEquation, false, isFunction); formEditEquation.CalculatedField = true; if (formEditEquation.ShowDialog() == DialogResult.OK) { if (formEditEquation.IsFunction) { dgvCalculated[0, nRow].Tag = "1"; } else { dgvCalculated[0, nRow].Tag = "0"; } dgvCalculated[e.ColumnIndex, e.RowIndex].Value = formEditEquation.Equation; if (dgvCalculated.Rows[nRow].Tag == null) //Insert new { dgvCalculated.Rows.Add(); try { strEquation = formEditEquation.Equation; String strInsert = "INSERT INTO ATTRIBUTES_CALCULATED (ATTRIBUTE_,EQUATION,ISFUNCTION)VALUES('" + this.Attribute + "','" + strEquation + "','" + dgvCalculated[0, nRow].Tag.ToString() + "')"; DBMgr.ExecuteNonQuery(strInsert); dgvCalculated.Rows[nRow].Tag = DBMgr.GetCurrentAutoIncrement("ATTRIBUTES_CALCULATED").ToString(); dgvCalculated[nColumn, nRow].Value = strEquation; dgvCalculated.Update(); } catch (Exception exception) { Global.WriteOutput("Error: Inserting EQUATION for Calculated Fields." + exception.Message); } } else //Update existing { try { strEquation = formEditEquation.Equation; strID = dgvCalculated.Rows[nRow].Tag.ToString(); string strUpdate = "UPDATE ATTRIBUTES_CALCULATED SET EQUATION='" + strEquation + "', ISFUNCTION='" + dgvCalculated[0, nRow].Tag.ToString() + "' WHERE ID_='" + strID + "'"; DBMgr.ExecuteNonQuery(strUpdate); } catch (Exception exception) { Global.WriteOutput("Error: Updating EQUATION for Calculated Fields." + exception.Message); } } } } else // Edit criteria { String strCriteria = ""; if (dgvCalculated[nColumn, nRow].Value != null) { strCriteria = dgvCalculated[nColumn, nRow].Value.ToString(); } FormAdvancedSearch formAdvancedSearch = new FormAdvancedSearch(strCriteria); if (formAdvancedSearch.ShowDialog() == DialogResult.OK) { //SqlParameter param0 = new SqlParameter("@criteria", SqlDbType.VarBinary, -1); dgvCalculated[e.ColumnIndex, e.RowIndex].Value = formAdvancedSearch.Query; if (dgvCalculated.Rows[nRow].Tag == null) //Insert new { try { strCriteria = formAdvancedSearch.Query; dgvCalculated[nColumn, nRow].Value = strCriteria; strCriteria = strCriteria.Replace("'", "|"); string strInsert = "INSERT INTO ATTRIBUTES_CALCULATED (ATTRIBUTE_,EQUATION,CRITERIA)VALUES('" + this.Attribute + "','','" + strCriteria + "')"; DBMgr.ExecuteNonQuery(strInsert); dgvCalculated.Rows[nRow].Tag = DBMgr.GetCurrentAutoIncrement("ATTRIBUTES_CALCULATED"); dgvCalculated.Rows.Add(); dgvCalculated.Update(); dgvCalculated.Refresh(); } catch (Exception exception) { Global.WriteOutput("Error: Inserting Criteria for Calculated Fields." + exception.Message); } } else //Update existing { try { strCriteria = formAdvancedSearch.Query; dgvCalculated[nColumn, nRow].Value = strCriteria; strCriteria = strCriteria.Replace("'", "|"); strID = dgvCalculated.Rows[nRow].Tag.ToString(); string strUpdate = "UPDATE ATTRIBUTES_CALCULATED SET CRITERIA='" + strCriteria + "' WHERE ID_='" + strID + "'"; DBMgr.ExecuteNonQuery(strUpdate); dgvCalculated.Update(); } catch (Exception exception) { Global.WriteOutput("Error: Updating CRITERIA for Calculated Fields." + exception.Message); } } } } dgvCalculated.Update(); }
private void dataGridViewCompoundTreatmentElements_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { // Extent column or Quantity column if (e.ColumnIndex != -1) { // Select only one element at a time for editing if (dataGridViewCompoundTreatmentElements.SelectedCells.Count == 1) { // If the selected cell contains data if (e.RowIndex != -1) { CompoundTreatmentElement selectedCompoundElement = (CompoundTreatmentElement)dataGridViewCompoundTreatmentElements["colCompoundTreatmentElement", e.RowIndex].Value; if (selectedCompoundElement != null) { if (dataGridViewCompoundTreatmentElements.Columns["colExtent"].Index == e.ColumnIndex) { // Extent column selected FormEditEquation formEditCompoundElementEquation = new FormEditEquation(selectedCompoundElement.ExtentEquation.m_expression, _effectedTreatmentAttribute); if (formEditCompoundElementEquation.ShowDialog() == DialogResult.OK) { selectedCompoundElement.ExtentEquation.m_expression = formEditCompoundElementEquation.Equation; dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCompoundElementEquation.Equation; } } if (dataGridViewCompoundTreatmentElements.Columns["colQuantity"].Index == e.ColumnIndex) { // Quantity column selected FormEditEquation formEditCompoundElementEquation = new FormEditEquation(selectedCompoundElement.Quantity.m_expression, _effectedTreatmentAttribute); if (formEditCompoundElementEquation.ShowDialog() == DialogResult.OK) { selectedCompoundElement.Quantity.m_expression = formEditCompoundElementEquation.Equation; dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCompoundElementEquation.Equation; } } if (dataGridViewCompoundTreatmentElements.Columns["colCriteria"].Index == e.ColumnIndex) { // Criteria column selected FormAdvancedSearch formEditCriteria = new FormAdvancedSearch(selectedCompoundElement.CriteriaEquation.Criteria); if (formEditCriteria.ShowDialog() == DialogResult.OK) { selectedCompoundElement.CriteriaEquation.Criteria = formEditCriteria.GetWhereClause(); dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCriteria.GetWhereClause(); } } if (dataGridViewCompoundTreatmentElements.Columns["colCost"].Index == e.ColumnIndex) { // Cost column selected FormEditEquation formEditCompoundElementExtent = new FormEditEquation(selectedCompoundElement.CostEquation.m_expression, _effectedTreatmentAttribute); if (formEditCompoundElementExtent.ShowDialog() == DialogResult.OK) { selectedCompoundElement.CostEquation.m_expression = formEditCompoundElementExtent.Equation; dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCompoundElementExtent.Equation; } } } } else { if (dataGridViewCompoundTreatmentElements.Columns["colExtent"].Index == e.ColumnIndex) { // Extent column selected FormEditEquation formEditCompoundElementEquation = new FormEditEquation("", _effectedTreatmentAttribute); if (formEditCompoundElementEquation.ShowDialog() == DialogResult.OK) { dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCompoundElementEquation.Equation; } } if (dataGridViewCompoundTreatmentElements.Columns["colQuantity"].Index == e.ColumnIndex) { // Quantity column selected FormEditEquation formEditCompoundElementEquation = new FormEditEquation("", _effectedTreatmentAttribute); if (formEditCompoundElementEquation.ShowDialog() == DialogResult.OK) { dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCompoundElementEquation.Equation; } } if (dataGridViewCompoundTreatmentElements.Columns["colCriteria"].Index == e.ColumnIndex) { // Criteria column selected FormAdvancedSearch formEditCriteria = new FormAdvancedSearch(""); if (formEditCriteria.ShowDialog() == DialogResult.OK) { dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCriteria.GetWhereClause(); } } if (dataGridViewCompoundTreatmentElements.Columns["colCost"].Index == e.ColumnIndex) { // Cost column selected FormEditEquation formEditCompoundElementExtent = new FormEditEquation("", _effectedTreatmentAttribute); if (formEditCompoundElementExtent.ShowDialog() == DialogResult.OK) { dataGridViewCompoundTreatmentElements[e.ColumnIndex, e.RowIndex].Value = formEditCompoundElementExtent.Equation; } } } } } }
private void MSSQLdgvCalculatedCellDoubleClick(DataGridViewCellEventArgs e) { int nRow = e.RowIndex; int nColumn = e.ColumnIndex; String strID = ""; if (nColumn == 0) //Edit equations { String strEquation = ""; String isFunctionTag = "0"; bool isFunction = false; if (dgvCalculated[nColumn, nRow].Value != null) { strEquation = dgvCalculated[nColumn, nRow].Value.ToString(); } FormEditEquation formEditEquation = new FormEditEquation(strEquation, false, isFunction); formEditEquation.CalculatedField = true; if (formEditEquation.ShowDialog() == DialogResult.OK) { if (dgvCalculated.Rows[nRow].Tag == null) //Insert new { try { strEquation = formEditEquation.Equation; dgvCalculated.Rows.Add(); String strInsert = "INSERT INTO ATTRIBUTES_CALCULATED (ATTRIBUTE_,EQUATION,ISFUNCTION)VALUES('" + this.Attribute + "','" + strEquation + "','0')"; SqlCommand command = new SqlCommand(strInsert, DBMgr.NativeConnectionParameters.SqlConnection); command.ExecuteNonQuery(); String strIdentity = "SELECT IDENT_CURRENT ('ATTRIBUTES_CALCULATED') FROM ATTRIBUTES_CALCULATED"; DataSet ds = DBMgr.ExecuteQuery(strIdentity); strIdentity = ds.Tables[0].Rows[0].ItemArray[0].ToString(); dgvCalculated.Rows[nRow].Tag = strIdentity; dgvCalculated[nColumn, nRow].Value = strEquation; dgvCalculated.Update(); dgvCalculated[e.ColumnIndex, e.RowIndex].Value = formEditEquation.Equation; } catch (Exception exception) { Global.WriteOutput("Error: Inserting EQUATION for Calculated Fields." + exception.Message); } } else //Update existing { try { strEquation = formEditEquation.Equation; strID = dgvCalculated.Rows[nRow].Tag.ToString(); String strUpdate = "UPDATE ATTRIBUTES_CALCULATED SET EQUATION='" + strEquation + "', ISFUNCTION='0' WHERE ID_='" + strID + "'"; SqlCommand command = new SqlCommand(strUpdate, DBMgr.NativeConnectionParameters.SqlConnection); command.ExecuteNonQuery(); dgvCalculated[e.ColumnIndex, e.RowIndex].Value = formEditEquation.Equation; } catch (Exception exception) { Global.WriteOutput("Error: Updating EQUATION for Calculated Fields." + exception.Message); } } } } else // Edit criteria { String strCriteria = ""; if (dgvCalculated[nColumn, nRow].Value != null) { strCriteria = dgvCalculated[nColumn, nRow].Value.ToString(); } FormAdvancedSearch formAdvancedSearch = new FormAdvancedSearch(strCriteria); if (formAdvancedSearch.ShowDialog() == DialogResult.OK) { dgvCalculated[nColumn, nRow].Value = formAdvancedSearch.Query; SqlParameter param0 = new SqlParameter("@criteria", SqlDbType.VarBinary, -1); if (dgvCalculated.Rows[nRow].Tag == null) //Insert new { try { strCriteria = formAdvancedSearch.Query; dgvCalculated[nColumn, nRow].Value = strCriteria; strCriteria = strCriteria.Replace("'", "|"); String strInsert = "INSERT INTO ATTRIBUTES_CALCULATED (ATTRIBUTE_,EQUATION,CRITERIA)VALUES('" + this.Attribute + "','','" + strCriteria + "')"; SqlCommand command = new SqlCommand(strInsert, DBMgr.NativeConnectionParameters.SqlConnection); command.ExecuteNonQuery(); String strIdentity = "SELECT IDENT_CURRENT ('ATTRIBUTES_CALCULATED') FROM ATTRIBUTES_CALCULATED"; DataSet ds = DBMgr.ExecuteQuery(strIdentity); strIdentity = ds.Tables[0].Rows[0].ItemArray[0].ToString(); dgvCalculated.Rows[nRow].Tag = strIdentity; dgvCalculated.Rows.Add(); dgvCalculated.Update(); dgvCalculated.Refresh(); } catch (Exception exception) { Global.WriteOutput("Error: Inserting Criteria for Calculated Fields." + exception.Message); } } else //Update existing { try { strCriteria = formAdvancedSearch.Query; dgvCalculated[nColumn, nRow].Value = strCriteria; strCriteria = strCriteria.Replace("'", "|"); strID = dgvCalculated.Rows[nRow].Tag.ToString(); String strUpdate = "UPDATE ATTRIBUTES_CALCULATED SET CRITERIA='" + strCriteria + "' WHERE ID_='" + strID + "'"; SqlCommand command = new SqlCommand(strUpdate, DBMgr.NativeConnectionParameters.SqlConnection); command.ExecuteNonQuery(); dgvCalculated.Update(); } catch (Exception exception) { Global.WriteOutput("Error: Updating CRITERIA for Calculated Fields." + exception.Message); } } } } dgvCalculated.Update(); }