private void cmdUpdate_Click(object sender, EventArgs e) { frmMeasureCriteriaSetup frmMeasureCriteriaSetupCopy = new frmMeasureCriteriaSetup(); string ls_CritType = null; //LDW Index = frmMeasureCriteriaSetupCopy.SSTabCriteria.SelectedIndex; int Index = frmMeasureCriteriaSetupCopy.SSTabCriteria.ActiveWindow.DockTabStrip.SelectedIndex; try { switch (Index) { case 0: ls_CritType = "Reg"; break; case 1: ls_CritType = "Filter"; break; case 2: ls_CritType = "Risk"; break; } if (cboCat.SelectedIndex > -1 & !string.IsNullOrEmpty(txtGoToStep.Text)) { RadMessageBox.Show("Either category or the destination step has to be defined, but not both."); return; } int MeasureStepID = 0; modGlobal.gv_sql = " select MeasureStepID, "; modGlobal.gv_sql = modGlobal.gv_sql + " MeasureCriteriaSetID , MeasureCriteriaID "; modGlobal.gv_sql = modGlobal.gv_sql + " from vuMeasureCriteriaSetStep "; if (Index == 0) { modGlobal.gv_sql = string.Format("{0} WHERE MeasureCriteriaID = {1}", modGlobal.gv_sql, Support.GetItemData(frmMeasureCriteriaSetupCopy.lstMeasureDef0, frmMeasureCriteriaSetupCopy.lstMeasureDef0.SelectedIndex)); } else if (Index == 1) { modGlobal.gv_sql = string.Format("{0} WHERE MeasureCriteriaID = {1}", modGlobal.gv_sql, Support.GetItemData(frmMeasureCriteriaSetupCopy.lstMeasureDef1, frmMeasureCriteriaSetupCopy.lstMeasureDef1.SelectedIndex)); } else { modGlobal.gv_sql = string.Format("{0} WHERE MeasureCriteriaID = {1}", modGlobal.gv_sql, Support.GetItemData(frmMeasureCriteriaSetupCopy.lstMeasureDef2, frmMeasureCriteriaSetupCopy.lstMeasureDef2.SelectedIndex)); } //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "vuMeasureCriteriaSetStep"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); MeasureStepID = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["MeasureStepID"]); modGlobal.gv_rs.Dispose(); modGlobal.gv_sql = "Update tbl_Setup_MeasureStep set "; if (cboCat.SelectedIndex < 0) { modGlobal.gv_sql = modGlobal.gv_sql + " Measure_CatID = null "; } else { modGlobal.gv_sql = string.Format("{0} Measure_CatID = {1}", modGlobal.gv_sql, Support.GetItemData(cboCat, cboCat.SelectedIndex)); } modGlobal.gv_sql = modGlobal.gv_sql + ", "; if (string.IsNullOrEmpty(txtGoToStep.Text)) { modGlobal.gv_sql = modGlobal.gv_sql + " gotostep = null "; } else { modGlobal.gv_sql = string.Format("{0} gotostep = {1}", modGlobal.gv_sql, txtGoToStep.Text); } if (ls_CritType == "Risk") { modGlobal.gv_sql = modGlobal.gv_sql + ", IsRisk = 1"; } else { modGlobal.gv_sql = modGlobal.gv_sql + ", IsRisk = 0"; } modGlobal.gv_sql = string.Format("{0} where MeasureStepID = {1}", modGlobal.gv_sql, MeasureStepID); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); this.Close(); } catch (Exception ex) { const string errorMessage = "Oops...Something went wrong... "; // Create an EventLog instance and assign its source. EventLog appLog = new EventLog(); appLog.Source = "CopSetup"; appLog.WriteEntry(errorMessage + "Source: " + ex.Source + "=>" + "TargetSite: " + ex.TargetSite + "Exception #: " + ex.HResult + " => " + "Error Message: " + ex.Message + " => " + "Inner Exception: " + ex.InnerException + " => " + "Stack Trace: " + ex.StackTrace, EventLogEntryType.Error, 1002); RadMessageBox.Show(errorMessage + String.Format(format: "Exception: {0} => Inner Exception: {1}", arg0: ex.Message, arg1: ex.InnerException)); } }
public void RefreshCatList() { frmMeasureCriteriaSetup frmMeasureCriteriaSetupCopy = new frmMeasureCriteriaSetup(); string CatID = null; string is_CritType = null; int li_SELcatID = -1; string ls_CritType = null; int Index = frmMeasureCriteriaSetupCopy.SSTabCriteria.ActiveWindow.DockTabStrip.SelectedIndex; try { switch (Index) { case 0: ls_CritType = "Reg"; break; case 1: ls_CritType = "Filter"; break; case 2: ls_CritType = "Risk"; break; } modGlobal.gv_sql = "SELECT * FROM tbl_MEASURE_CAT "; if (is_CritType == "Reg") { modGlobal.gv_sql = modGlobal.gv_sql + " WHERE CAT_TYPE = 'CI'"; } else if (is_CritType == "Risk") { //gv_sql = gv_sql & " WHERE CAT_TYPE = 'RA'" modGlobal.gv_sql = modGlobal.gv_sql + " WHERE (CAT_TYPE = 'RA' Or IsRisk = 1) "; } modGlobal.gv_sql = modGlobal.gv_sql + " ORDER BY CAT"; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_MEASURE_CAT"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); cboCat.Items.Clear(); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow2 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { cboCat.Items.Add(new ListBoxItem(myRow2.Field <string>("CAT"), myRow2.Field <int>("measure_catid")).ToString()); if (!string.IsNullOrEmpty(CatID)) { if (myRow2.Field <int>("measure_catid") == Convert.ToInt16(CatID)) { li_SELcatID = cboCat.Items.Count - 1; } } //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); cboCat.SelectedIndex = li_SELcatID; return; } catch (Exception ex) { const string errorMessage = "Oops...Something went wrong... "; // Create an EventLog instance and assign its source. EventLog appLog = new EventLog(); appLog.Source = "CopSetup"; appLog.WriteEntry(errorMessage + "Source: " + ex.Source + "=>" + "TargetSite: " + ex.TargetSite + "Exception #: " + ex.HResult + " => " + "Error Message: " + ex.Message + " => " + "Inner Exception: " + ex.InnerException + " => " + "Stack Trace: " + ex.StackTrace, EventLogEntryType.Error, 1002); RadMessageBox.Show(errorMessage + String.Format(format: "Exception: {0} => Inner Exception: {1}", arg0: ex.Message, arg1: ex.InnerException)); } //LDW ErrHandler: //LDW modGlobal.CheckForErrors(); }