private void setMeasureStepID() { try { modGlobal.gv_sql = "SELECT ms.MeasureStepID FROM " + " tbl_setup_measurecriteria mc, tbl_setup_measurecriteriaset mcs, tbl_setup_MeasureStep ms " + " WHERE mc.measurecriteriasetid = mcs.measurecriteriasetid " + " AND ms.MeasureStepID = mcs.MeasureStepID " + " AND mc.MeasureCriteriaID = " + ii_MeasureCriteriaID; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_setup_measurecriteria"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); //LDW if (modGlobal.gv_rs.EOF) for (int itr = 0; itr < modGlobal.gv_rs.Tables[sqlTableName2].Rows.Count; itr++) { var myRow11 = modGlobal.gv_rs.Tables[sqlTableName2].Rows[itr]; int rowIndex = modGlobal.gv_rs.Tables[sqlTableName2].Rows.IndexOf(myRow11); int rowLast = modGlobal.gv_rs.Tables[sqlTableName2].Rows.Count - 1; if (rowIndex == rowLast) { RadMessageBox.Show("Could not determine step id from selected criteria", "Fatal Error", MessageBoxButtons.OK, RadMessageIcon.Error); this.Close(); } else { ii_MeasureStepID = (object.ReferenceEquals(modGlobal.gv_rs.Tables[sqlTableName2].Rows[0]["MeasureStepID"], DBNull.Value) ? 0 : Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName2].Rows[0]["MeasureStepID"])); } } modGlobal.gv_rs.Dispose(); 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(); }
private void cmdSelect_Click(object sender, EventArgs e) { frmHospStatSetup frmHospStatSetupCopy = new frmHospStatSetup(); int newfieldorder; var i = 0; try { for (i = 0; i <= lstHospStatFields.Items.Count - 1; i++) { if (lstHospStatFields.SelectedIndex == i) { //NewID = FindMaxRecID("tbl_Setup_DataReq", "IndicatorDDID") modGlobal.gv_sql = "select max(fieldorder) as maxorder from tbl_setup_HospStatGroupFields "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_setup_HospStatGroupFields"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); newfieldorder = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["maxorder"]) + 1; modGlobal.gv_sql = "Insert into tbl_setup_HospStatGroupFields (HospStatGroupID, DDID, fieldorder )"; modGlobal.gv_sql = modGlobal.gv_sql + " Values ("; modGlobal.gv_sql = modGlobal.gv_sql + Support.GetItemData(frmHospStatSetupCopy.lstHospStatGroup, frmHospStatSetupCopy.lstHospStatGroup.SelectedIndex); modGlobal.gv_sql = string.Format("{0},{1}, {2}", modGlobal.gv_sql, Support.GetItemData(lstHospStatFields, i), newfieldorder); modGlobal.gv_sql = modGlobal.gv_sql + ")"; //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)); } }
private void cmdNewIndicator_Click(System.Object eventSender, System.EventArgs eventArgs) { int NewIndID; string NewIndicator = null; //UPGRADE_WARNING: Couldn't resolve default property of object NewIndicator. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' NewIndicator = Interaction.InputBox("Please enter the description of the new indicator:", "Add New Indicator", ""); //UPGRADE_WARNING: Couldn't resolve default property of object NewIndicator. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' if (string.IsNullOrEmpty(NewIndicator)) { return; } //UPGRADE_WARNING: Couldn't resolve default property of object NewIndID. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' NewIndID = modDBSetup.FindMaxRecID("tbl_Setup_Indicator", "IndicatorID"); modGlobal.gv_sql = "Insert into tbl_setup_Indicator (IndicatorID, Description, State, RecordStatus) "; //UPGRADE_WARNING: Couldn't resolve default property of object NewIndicator. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' //UPGRADE_WARNING: Couldn't resolve default property of object NewIndID. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' modGlobal.gv_sql = modGlobal.gv_sql + " Values (" + NewIndID + ",'" + NewIndicator + "',"; //UPGRADE_WARNING: Couldn't resolve default property of object gv_State. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " null, "; } else { //UPGRADE_WARNING: Couldn't resolve default property of object gv_State. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' modGlobal.gv_sql = modGlobal.gv_sql + " '" + modGlobal.gv_State + "',"; } //UPGRADE_WARNING: Couldn't resolve default property of object gv_status. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " null "; } else { //UPGRADE_WARNING: Couldn't resolve default property of object gv_status. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' modGlobal.gv_sql = modGlobal.gv_sql + " '" + modGlobal.gv_status + "'"; } modGlobal.gv_sql = modGlobal.gv_sql + " )"; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshIndicator(); //UPGRADE_WARNING: Couldn't resolve default property of object NewIndicator. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' lstIndicators.Text = NewIndicator; }
private void cmdMeasureFieldDetails_Click(object sender, EventArgs e) { frmPatientFieldsExportLinks frmPatientFieldsExportLinksCopy = new frmPatientFieldsExportLinks(); try { if (lstFieldList.SelectedIndex > -1) { modGlobal.gv_sql = "update tbl_setup_DataDef "; modGlobal.gv_sql = modGlobal.gv_sql + " set CMSFieldCode = "; if (string.IsNullOrEmpty(txtCMSFieldCode.Text)) { modGlobal.gv_sql = modGlobal.gv_sql + " null "; } else { modGlobal.gv_sql = string.Format("{0}'{1}'", modGlobal.gv_sql, txtCMSFieldCode.Text); } modGlobal.gv_sql = modGlobal.gv_sql + ", "; modGlobal.gv_sql = modGlobal.gv_sql + " JCFieldCode = "; if (string.IsNullOrEmpty(txtJCFieldCode.Text)) { modGlobal.gv_sql = modGlobal.gv_sql + " null "; } else { modGlobal.gv_sql = string.Format("{0}'{1}'", modGlobal.gv_sql, txtJCFieldCode.Text); } modGlobal.gv_sql = string.Format("{0} where ddid = {1}", modGlobal.gv_sql, Support.GetItemData(lstFieldList, lstFieldList.SelectedIndex)); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); } } 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)); } frmPatientFieldsExportLinksCopy.ShowDialog(); }
private void cmdRemoveAction_Click(System.Object eventSender, System.EventArgs eventArgs) { if (lstAppliedActions.SelectedIndex < 0) { return; } modGlobal.gv_sql = "Delete tbl_setup_datadefactions "; modGlobal.gv_sql = modGlobal.gv_sql + " Where datadefactionid = "; modGlobal.gv_sql = modGlobal.gv_sql + Support.GetItemData(lstAppliedActions, lstAppliedActions.SelectedIndex); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshAvailableActions(); RefreshAppliedActions(); }
private void OKButton_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(cboType.Text) & !string.IsNullOrEmpty(txtCatID.Text) & !string.IsNullOrEmpty(txtCatDesc.Text)) { if (Information.IsNumeric(is_CatID)) { modGlobal.gv_sql = string.Format("UPDATE tbl_MEASURE_CAT SET CAT = '{0}', CAT_DESC = '{1}', CAT_TYPE = '{2}' WHERE MEASURE_CATID = {3}", txtCatID.Text, txtCatDesc.Text, cboType.Text, is_CatID); } else { //table has unique constraint setup on CAT field so duplicates will not be allowed modGlobal.gv_sql = string.Format("INSERT INTO tbl_MEASURE_CAT (CAT, CAT_DESC, CAT_TYPE) VALUES ('{0}', '{1}', '{2}')", txtCatID.Text, txtCatDesc.Text, cboType.Text); } //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); this.Close(); } else { //LDW RadMessageBox.Show("Please fill in all the Information", MsgBoxStyle.Critical, "Information Incomplete"); DialogResult ds1 = RadMessageBox.Show(this, "Please fill in all the Information.", "Create Category", MessageBoxButtons.OK, RadMessageIcon.Error); this.Text = ds1.ToString(); } 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(); }
public void RefreshSetList() { frmReportSetup frmReportSetupCopy = new frmReportSetup(); int SetIndex = 1; try { cboSet.Items.Clear(); modGlobal.gv_sql = "Select CriteriaSet from tbl_setup_SavedAdhocReportCriteria "; modGlobal.gv_sql = string.Format("{0} where Report_id = {1}", modGlobal.gv_sql, Support.GetItemData(frmReportSetupCopy.cboReportList, frmReportSetupCopy.cboReportList.SelectedIndex)); modGlobal.gv_sql = modGlobal.gv_sql + " Group by CriteriaSet "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName3 = "tbl_setup_SavedAdhocReportCriteria"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); //Display the list of criteria //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { cboSet.Items.Add("Set " + SetIndex); Support.SetItemData(cboSet, cboSet.Items.Count - 1, SetIndex); SetIndex = SetIndex + 1; //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); //always add a new one to the list in addition to the previous ones cboSet.Items.Add(new ListBoxItem("Set " + SetIndex, SetIndex).ToString()); } 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 RefreshSetDef() { frmReportSetup frmReportSetupCopy = new frmReportSetup(); try { if (cboSet.SelectedIndex < 0) { return; } modGlobal.gv_sql = "Select JoinOperator from tbl_setup_SavedAdhocReportSumCriteria "; modGlobal.gv_sql = string.Format("{0} where Report_ID = {1}", modGlobal.gv_sql, Support.GetItemData(frmReportSetupCopy.cboReportList, frmReportSetupCopy.cboReportList.SelectedIndex)); modGlobal.gv_sql = string.Format("{0} and CriteriaSet = {1}", modGlobal.gv_sql, Support.GetItemData(cboSet, cboSet.SelectedIndex)); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_setup_SavedAdhocReportSumCriteria"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName2].Rows.Count == 0) { cboJoinOperator.Text = ""; cboJoinOperator.Enabled = true; } else { cboJoinOperator.Text = modGlobal.gv_rs.Tables[sqlTableName2].Rows[0]["JoinOperator"].ToString(); cboJoinOperator.Enabled = false; } modGlobal.gv_rs.Dispose(); } 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)); } }
private void cmdDelete_Click(System.Object eventSender, System.EventArgs eventArgs) { DialogResult resp; //UPGRADE_WARNING: Couldn't resolve default property of object resp. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' resp = RadMessageBox.Show("Are you sure you want to delete this layout? All the associated fields will be deleted too.", MsgBoxStyle.YesNo, "Delete ImportLayout"); if (resp == DialogResult.No) { return; } modGlobal.gv_sql = " delete tbl_setup_ImportValidation "; modGlobal.gv_sql = modGlobal.gv_sql + " where msgid in "; modGlobal.gv_sql = modGlobal.gv_sql + " (select msgid "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_importvalidationmessage as msg "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_setup_importfields as impf "; modGlobal.gv_sql = modGlobal.gv_sql + " on msg.importfieldid = impf.importfieldid "; modGlobal.gv_sql = modGlobal.gv_sql + " where impf.importsetupid = " + rdcImportLayout.Resultset.rdoColumns["ImportSetupID"].Value; modGlobal.gv_sql = modGlobal.gv_sql + " )"; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " delete tbl_setup_ImportValidationMessage "; modGlobal.gv_sql = modGlobal.gv_sql + " where importfieldid in "; modGlobal.gv_sql = modGlobal.gv_sql + " (select importfieldid "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_importfields as impf "; modGlobal.gv_sql = modGlobal.gv_sql + " where impf.importsetupid = " + rdcImportLayout.Resultset.rdoColumns["ImportSetupID"].Value; modGlobal.gv_sql = modGlobal.gv_sql + " )"; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " delete tbl_setup_ImportFields "; modGlobal.gv_sql = modGlobal.gv_sql + " where importsetupid = " + rdcImportLayout.Resultset.rdoColumns["ImportSetupID"].Value; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " delete tbl_setup_ImportSetup "; modGlobal.gv_sql = modGlobal.gv_sql + " where importsetupid = " + rdcImportLayout.Resultset.rdoColumns["ImportSetupID"].Value; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshImportLayout(); }
private void frmPatientFieldsExportFormat_Load(object sender, EventArgs e) { this.CenterToParent(); try { txtJCFieldCode.Enabled = false; txtCMSFieldCode.Enabled = false; lstMeasureList.Enabled = false; lstSelectedMeasures.Enabled = false; cmdLinkToMeasure.Enabled = false; cmdRemoveFromMeasure.Enabled = false; //retrieve the list of table fields modGlobal.gv_sql = "Select * from tbl_setup_DataDef "; modGlobal.gv_sql = modGlobal.gv_sql + " where BaseTableID in "; modGlobal.gv_sql = modGlobal.gv_sql + " (select basetableid from tbl_setup_tableDef where BaseTable = 'PATIENT' )"; modGlobal.gv_sql = modGlobal.gv_sql + " order by FieldName "; //LDW rdcFieldList.Resultset = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); rdcFieldListTable = "tbl_setup_DataDef"; rdcFieldList = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, rdcFieldListTable, rdcFieldList); rdcFieldList.AcceptChanges(); lstFieldList.Items.Clear(); //LDW while (!rdcFieldList.Resultset.EOF) foreach (DataRow myRow1 in rdcFieldList.Tables[rdcFieldListTable].Rows) { lstFieldList.Items.Add(new ListBoxItem(myRow1.Field <string>("FieldName"), myRow1.Field <int>("DDID")).ToString()); //LDW rdcFieldList.Resultset.MoveNext(); } } 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)); } }
private void RefreshMeasureSetDetail() { try { modGlobal.gv_sql = "Select MeasureCriteriaID, CriteriaTitle, [DDID1], [DDID2], [ValueOperator], [FieldValue], [DestDDID], [LookupID]," + "[FieldOperator], [DateUnit], [JoinOperator], [LookupTableID] FROM tbl_Setup_MeasureCriteria WHERE MeasureCriteriaSetID = " + il_MeasureCriteriaSetID; modGlobal.gv_sql = modGlobal.gv_sql + " order by MeasureCriteriaID"; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, rdcMeasureSetTable, modGlobal.gv_rs); //LDW if (modGlobal.gv_rs.RowCount == 0) if (modGlobal.gv_rs.Tables[rdcMeasureSetTable].Rows.Count == 0) { //LDW RadMessageBox.Show("Please Create measure sets before using this form", MsgBoxStyle.Information, "No Measures Exist"); DialogResult dsn = RadMessageBox.Show(this, "Please Create measure sets before using this form", "Measure Set Detail", MessageBoxButtons.OK, RadMessageIcon.Error); this.Text = dsn.ToString(); return; } else { rdcMeasureSet = modGlobal.gv_rs; rdcMeasureSet.AcceptChanges(); dbgMeasureSet.Refresh(); // RefreshMeasureCriteria } 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(); }
private void cmdDeleteIndicator_Click(System.Object eventSender, System.EventArgs eventArgs) { if (lstIndicators.SelectedIndex < -1) { return; } modGlobal.gv_sql = "delete tbl_setup_datareq "; modGlobal.gv_sql = modGlobal.gv_sql + " where indicatorid = " + Microsoft.VisualBasic.Compatibility.VB6.Support.GetItemData(lstIndicators, lstIndicators.SelectedIndex); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = "delete tbl_setup_indicator "; modGlobal.gv_sql = modGlobal.gv_sql + " where indicatorid = " + Microsoft.VisualBasic.Compatibility.VB6.Support.GetItemData(lstIndicators, lstIndicators.SelectedIndex); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshIndicator(); }
private void cmdChangeStatus_Click(object sender, EventArgs e) { DialogResult resp; string MoveToModule = null; try { if (lstGroups.SelectedIndex < 0) { return; } MoveToModule = (modGlobal.gv_status == "TEST" ? "Active" : "Test"); resp = RadMessageBox.Show("Are you sure you want this group to the " + MoveToModule + " Module?", "", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (resp == DialogResult.No) { return; } modGlobal.gv_sql = "Update tbl_Setup_submitGroup "; modGlobal.gv_sql = string.Format("{0} Set RecordStatus = {1}", modGlobal.gv_sql, modGlobal.gv_status == "TEST" ? "Null" : "'TEST'"); modGlobal.gv_sql = string.Format("{0} where groupID = {1}", modGlobal.gv_sql, Support.GetItemData(lstGroups, lstGroups.SelectedIndex)); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); sstabGroup.ActiveWindow = sstabGroup0; RefreshGroupList(); RefreshGroupToUpdate(); modGlobal.gv_Action = "Update"; } 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)); } }
private void cmdEdit_Click(System.Object eventSender, System.EventArgs eventArgs) { string gv_Command = null; //UPGRADE_WARNING: Use of Null/IsNull() detected. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="2EED02CB-5C0E-4DC1-AE94-4FAA3A30F51A"' if (string.IsNullOrEmpty(txtID.Text) | Information.IsDBNull(txtID.Text)) { RadMessageBox.Show("ID cannot be blank"); return; } //UPGRADE_WARNING: Couldn't resolve default property of object gv_Command. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' gv_Command = "Update tbl_Setup_miscLookupList set "; //UPGRADE_WARNING: Couldn't resolve default property of object gv_Command. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' gv_Command = gv_Command + " ID = '" + txtID.Text + "',"; //UPGRADE_WARNING: Couldn't resolve default property of object gv_Command. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' gv_Command = gv_Command + " FieldValue = '" + txtLookupValue.Text + "'"; //UPGRADE_WARNING: Couldn't resolve default property of object gv_Command. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' gv_Command = gv_Command + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Columns["LookupID"]; //UPGRADE_WARNING: Couldn't resolve default property of object gv_Command. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, gv_Command); modGlobal.gv_sql = " update tbl_setup_savedadhocreportcriteria "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Columns["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " update tbl_setup_submitcleanuprecord "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Columns["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " update tbl_setup_submitcriteria "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Columns["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " update tbl_setup_tablevalidation "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Columns["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); this.Close(); }
private void PopulateSetList() { try { lstSetList.Items.Clear(); if (ii_MeasureStepID == 0) { setMeasureStepID(); } modGlobal.gv_sql = "SELECT MeasureCriteriaSet, MeasureCriteriaSetID FROM tbl_Setup_MeasureCriteriaSet " + " WHERE MeasureStepID = " + ii_MeasureStepID + " ORDER BY MeasureCriteriaSet"; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_Setup_MeasureCriteriaSet"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName1].Rows) { lstSetList.Items.Add(new ListBoxItem(myRow1.Field <string>("MeasureCriteriaSet"), myRow1.Field <int>("measurecriteriasetid")).ToString()); //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); 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(); }
private void dlgCreateCat_Load(Object eventSender, EventArgs eventArgs) { var dalAccess = new DALcop(); if (Information.IsNumeric(is_CatID)) { modGlobal.gv_sql = "SELECT * FROM tbl_MEASURE_CAT WHERE MEASURE_CATID = " + is_CatID; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_MEASURE_CAT"; modGlobal.gv_rs = dalAccess.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); //LDW txtCatID.Text = modGlobal.gv_rs.rdoColumns["CAT"].Value; txtCatID.Text = modGlobal.gv_rs.Tables[sqlTableName1].Columns["CAT"].ToString(); //LDW txtCatDesc.Text = modGlobal.gv_rs.rdoColumns["CAT_DESC"].Value; txtCatDesc.Text = modGlobal.gv_rs.Tables[sqlTableName1].Columns["CAT_DESC"].ToString(); //LDW cboType.Text = modGlobal.gv_rs.rdoColumns["CAT_TYPE"].Value; cboType.Text = modGlobal.gv_rs.Tables[sqlTableName1].Columns["CAT_TYPE"].ToString(); } }
private void RefreshFields() { var dalAccess = new DALcop(); const string sqlTableName2 = "tbl_Setup_DataDef"; modGlobal.gv_sql = string.Format("SELECT * FROM tbl_Setup_DataDef WHERE FieldType = '{0}' AND (ParentDDID IS NULL OR ParentDDID = DDID) ORDER BY FIELDNAME", is_PreviousDataType); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); modGlobal.gv_rs = dalAccess.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); cboField.Items.Clear(); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow2 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { //LDW cboField.Items.Add(new Microsoft.VisualBasic.Compatibility.VB6.ListBoxItem(modGlobal.gv_rs.rdoColumns["FieldName"].Value, modGlobal.gv_rs.rdoColumns["DDID"].Value)); cboField.Items.Add(new Microsoft.VisualBasic.Compatibility.VB6.ListBoxItem(myRow2.Field <string>("FieldName"), myRow2.Field <int>("DDID"))); //LDW modGlobal.gv_rs.MoveNext(); } }
public void RefreshPeriods() { List <Item> itemslstPeriods = new List <Item>(); try { //retrieve the list of periods modGlobal.gv_sql = "Select Quarter from tbl_Setup_IndicatorRiskAdjustmentCoefficients GROUP BY quarter order by quarter desc"; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName6 = "tbl_Setup_IndicatorRiskAdjustmentCoefficients"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName6, modGlobal.gv_rs); lstPeriods.Items.Clear(); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow6 in modGlobal.gv_rs.Tables[sqlTableName6].Rows) { itemslstPeriods.Add(new Item(myRow6.Field <int>("Quarter"), Strings.Mid(myRow6.Field <string>("Quarter"), 5, 2) + " - " + Strings.Mid(myRow6.Field <string>("Quarter"), 1, 4))); //lstPeriods.Items.Add(new ListBoxItem(Strings.Mid(myRow6.Field<string>("Quarter"), 5, 2) + " - " + Strings.Mid(myRow6.Field<string>("Quarter"), 1, 4), myRow6.Field<int>("Quarter")).ToString()); //LDW modGlobal.gv_rs.MoveNext(); } this.lstPeriods.DataSource = itemslstPeriods; this.lstPeriods.DisplayMember = "Description"; this.lstPeriods.ValueMember = "Id"; //LDW lstPeriods.SetSelected(0, true); lstPeriods.SelectedIndex = 0; lstPeriods.SelectedItem.Active = true; } 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)); } }
private void frmSubmissionAddValidation_Load(object sender, EventArgs e) { this.CenterToParent(); try { cboIndicators.Items.Clear(); modGlobal.gv_sql = "select tbl_setup_Indicator.* "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_Indicator "; if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " Where (State = '' or State is Null) "; } else { modGlobal.gv_sql = string.Format("{0} Where (State = '' or State is null or State = '{1}')", modGlobal.gv_sql, modGlobal.gv_State); } modGlobal.gv_sql = modGlobal.gv_sql + " order by Description "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_setup_Indicator"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName1].Rows) { cboIndicators.Items.Add(new ListBoxItem(myRow1.Field <string>("Description"), myRow1.Field <int>("IndicatorID")).ToString()); //LDW modGlobal.gv_rs.MoveNext(); } } 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)); } }
private void cmdDelete_Click(System.Object eventSender, System.EventArgs eventArgs) { DialogResult resp; if (rdcVersionHistory.Resultset.AbsolutePosition == 0) { return; } //UPGRADE_WARNING: Couldn't resolve default property of object resp. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' resp = RadMessageBox.Show("Are you sure you want to delete the log for this version?", MsgBoxStyle.YesNo, "Delete Log"); if (resp == DialogResult.Yes) { modGlobal.gv_sql = "Delete tbl_setup_Version where versionid = " + rdcVersionHistory.Resultset.rdoColumns["versionid"].Value; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); refreshVersionHistory(); } }
private void cmdSelect_Click(System.Object eventSender, System.EventArgs eventArgs) { var i = 0; for (i = 0; i <= lstIndicators.Items.Count - 1; i++) { if (lstIndicators.GetSelected(i)) { modGlobal.gv_sql = "Insert into tbl_setup_MeasureSetMapMeas (MeasureSetID, IndicatorID)"; modGlobal.gv_sql = modGlobal.gv_sql + " Values (" + Microsoft.VisualBasic.Compatibility.VB6.Support.GetItemData(frmMeasureSetup.cboMeasureSet, frmMeasureSetup.cboMeasureSet.SelectedIndex); modGlobal.gv_sql = modGlobal.gv_sql + "," + Microsoft.VisualBasic.Compatibility.VB6.Support.GetItemData(lstIndicators, i) + ")"; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); } } frmMeasureSetup.RefreshMeasureSetField(); this.Close(); }
private void RefreshMeasureFieldGroupLogic() { DataSet rs_Temp = new DataSet(); string ls_Sql = null; try { ls_Sql = "SELECT CriteriaTitle, MeasureFieldGroupLogicID FROM tbl_Setup_MeasureFieldGroupLogic ORDER BY CriteriaTitle"; //LDW rs_Temp = modGlobal.gv_cn.OpenResultset(ls_Sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string MSRDCGroupsTable = "tbl_Setup_MeasureFieldGroupLogic"; rs_Temp = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, MSRDCGroupsTable, rs_Temp); //LDW if (!rs_Temp.EOF) for (int itr = 0; itr < rs_Temp.Tables[MSRDCGroupsTable].Rows.Count; itr++) { var myRow = (DataRow)rs_Temp.Tables[MSRDCGroupsTable].Rows[itr]; int rowIndex = rs_Temp.Tables[MSRDCGroupsTable].Rows.IndexOf(myRow); if (rowIndex != rs_Temp.Tables[MSRDCGroupsTable].Rows.Count - 1) { MSRDCGroups = rs_Temp; } else { MSRDCGroups = null; } } MSRDCGroups.AcceptChanges(); dbgGroups.Refresh(); } 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)); } }
private void dlgField_Load(Object eventSender, EventArgs eventArgs) { var dalAccess = new DALcop(); const string sqlTableName1 = "tbl_Setup_MeasureCriteria"; modGlobal.gv_sql = string.Format("SELECT dd.DDID, dd.FieldName, dd.FieldType, mc.CriteriaTitle FROM tbl_Setup_MeasureCriteria mc, tbl_Setup_DataDef dd WHERE dd.DDID = mc.DDID1 AND mc.MeasureCriteriaID = {0}", ii_MeasureCriteriaID); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); modGlobal.gv_rs = dalAccess.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); //LDW if (!modGlobal.gv_rs.EOF) foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName1].Rows) { //LDW if (!Information.IsDBNull(modGlobal.gv_rs.rdoColumns["DDID"].Value)) if (!Information.IsDBNull(myRow1.Field <string>("DDID"))) { /*LDW txtPreviousField.Text = modGlobal.gv_rs.rdoColumns["FieldName"].Value; * is_PreviousDataType = modGlobal.gv_rs.rdoColumns["FieldType"].Value; * is_CriteriaTitle = modGlobal.gv_rs.rdoColumns["CriteriaTitle"].Value; */ txtPreviousField.Text = myRow1.Field <string>("FieldName"); is_PreviousDataType = myRow1.Field <string>("FieldType"); is_CriteriaTitle = myRow1.Field <string>("CriteriaTitle"); RefreshFields(); OKButton.Enabled = true; } else { Interaction.MsgBox("This criteria can not be modified"); OKButton.Enabled = false; } if (Information.IsDBNull(myRow1.Field <string>("DDID"))) { Interaction.MsgBox("This criteria can not be modified"); OKButton.Enabled = false; } } /*LDW else * { * Interaction.MsgBox("This criteria can not be modified"); * OKButton.Enabled = false; * } */ }
public void RefreshCategoryList() { var LIndex = 0; try { //retrieve the list of table fields modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_measure_cat "; 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); //Display the list of fields cboCategory.Items.Clear(); LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow2 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { LIndex = LIndex + 1; cboCategory.Items.Add(new ListBoxItem(myRow2.Field <string>("CAT") + " - " + myRow2.Field <string>("CAT_DESC"), myRow2.Field <int>("measure_catid")).ToString()); //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); } 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 RefreshOperatorList() { try { cmbOperators.Items.Clear(); modGlobal.gv_sql = "select * from tbl_Setup_MeasureCriteria "; modGlobal.gv_sql = string.Format("{0} where MeasureCriteriaID = {1}", modGlobal.gv_sql, mcid); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_Setup_MeasureCriteria"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["valueoperator"].ToString() == "In" | modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["valueoperator"].ToString() == "Not In") { cmbOperators.Items.Add("In"); cmbOperators.Items.Add("Not In"); } else { cmbOperators.Items.Add("="); cmbOperators.Items.Add("<>"); cmbOperators.Items.Add(">"); cmbOperators.Items.Add("<"); cmbOperators.Items.Add(">="); cmbOperators.Items.Add("<="); } modGlobal.gv_rs.Dispose(); } 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)); } }
private void lstUtilizationFields_ItemCheckedChanged(object sender, Telerik.WinControls.UI.ListViewItemEventArgs e) { frmIndicatorReportSetup frmIndicatorReportSetupCopy = new frmIndicatorReportSetup(); int sid; int fid = 0; try { if (openning == 0) { sid = Support.GetItemData(frmIndicatorReportSetupCopy.lstHeading, frmIndicatorReportSetupCopy.lstHeading.SelectedIndex); fid = Support.GetItemData(lstUtilizationFields, lstUtilizationFields.SelectedIndex); //LDW if (lstUtilizationFields.GetItemChecked(eventArgs.Index) == true) if (Convert.ToBoolean(e.Item.CheckState) == true) { modGlobal.gv_sql = "INSERT into tbl_Setup_IndicatorReportDenominators (SubGroupID, tName, FieldID, OpChar)"; modGlobal.gv_sql = modGlobal.gv_sql + " values (" + sid + ",'Utilization'," + Support.GetItemData(lstUtilizationFields, lstUtilizationFields.SelectedIndex) + " , 1)"; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); } else { modGlobal.gv_sql = "delete from tbl_Setup_IndicatorReportDenominators "; modGlobal.gv_sql = string.Format("{0} where SubGroupID = {1} and tName = 'Utilization' and FieldID ={2}", modGlobal.gv_sql, sid, fid); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); } } } 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)); } }
private void cmdChangeStatus_Click(object sender, EventArgs e) { DialogResult resp; string MoveToModule = null; try { if (rdcImportLayout.Tables[rdcImportLayoutTable].Rows.Count == 0) { return; } MoveToModule = (modGlobal.gv_status == "TEST" ? "Active" : "Test"); resp = RadMessageBox.Show("Are you sure you want this import layout to the " + MoveToModule + " Module?", "Layout Import", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (resp == DialogResult.No) { return; } modGlobal.gv_sql = "Update tbl_Setup_ImportSetup "; modGlobal.gv_sql = string.Format("{0} Set RecordStatus = {1}", modGlobal.gv_sql, modGlobal.gv_status == "TEST" ? "Null" : "'TEST'"); modGlobal.gv_sql = string.Format("{0} where ImportSetupID = {1}", modGlobal.gv_sql, rdcImportLayout.Tables[rdcImportLayoutTable].Rows[0]["ImportSetupID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshImportLayout(); } 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)); } }
private void cmdDeleteSet_Click(System.Object eventSender, System.EventArgs eventArgs) { if (cboIndicatorSet.SelectedIndex < 0) { return; } modGlobal.gv_sql = "Delete tbl_Setup_IndicatorSetField "; modGlobal.gv_sql = modGlobal.gv_sql + " where IndicatorSetID = " + Microsoft.VisualBasic.Compatibility.VB6.Support.GetItemData(cboIndicatorSet, cboIndicatorSet.SelectedIndex); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = "Delete tbl_Setup_IndicatorSet "; modGlobal.gv_sql = modGlobal.gv_sql + " where IndicatorsetID = " + Microsoft.VisualBasic.Compatibility.VB6.Support.GetItemData(cboIndicatorSet, cboIndicatorSet.SelectedIndex); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshIndicatorSet(); cboIndicatorSet.SelectedIndex = -1; RefreshIndicatorSetField(); }
private void cmsAddFieldLink_Click() { object lstFieldsToLink = null; //UPGRADE_WARNING: Couldn't resolve default property of object lstFieldsToLink.ListIndex. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' if (lstFieldsToLink.ListIndex > -1) { modGlobal.gv_sql = "update tbl_setup_cmsfieldmeasures "; modGlobal.gv_sql = modGlobal.gv_sql + " set LinkToDDID = " + rdcFieldList.Resultset.rdoColumns["DDID"].Value; //UPGRADE_WARNING: Couldn't resolve default property of object lstFieldsToLink.ListIndex. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' //UPGRADE_WARNING: Couldn't resolve default property of object lstFieldsToLink.ItemData. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' modGlobal.gv_sql = modGlobal.gv_sql + " where ddid = " + lstFieldsToLink.ItemData(lstFieldsToLink.ListIndex); modGlobal.gv_sql = modGlobal.gv_sql + " and MeasureCode = '" + rdcFieldList.Resultset.rdoColumns["measurecode"].Value + "' "; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshFieldsToLink(); RefreshLinkedFields(); } }
private void cmdSelect_Click(object sender, EventArgs e) { frmIndicatorSetup frmIndicatorSetupCopy = new frmIndicatorSetup(); int newid; var i = 0; try { for (i = 0; i <= lstIndicators.Items.Count - 1; i++) { if (lstIndicators.SelectedIndex == i) { newid = modDBSetup.FindMaxRecID("tbl_Setup_IndicatorsetField", "IndLinkID"); modGlobal.gv_sql = "Insert into tbl_setup_IndicatorsetField (IndLinkID, IndicatorSetID, IndicatorID)"; modGlobal.gv_sql = string.Format("{0} Values ({1}", modGlobal.gv_sql, newid); modGlobal.gv_sql = string.Format("{0},{1}", modGlobal.gv_sql, Support.GetItemData(frmIndicatorSetupCopy.cboIndicatorSet, frmIndicatorSetupCopy.cboIndicatorSet.SelectedIndex)); modGlobal.gv_sql = string.Format("{0},{1})", modGlobal.gv_sql, Support.GetItemData(lstIndicators, i)); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); } } frmIndicatorSetupCopy.RefreshIndicatorSetField(); 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)); } }