public static void PrintSummaryValidation() { string vmessage = null; int msgcount = 0; string valFile = null; var vrs = new DataSet(); //LDW DataSet vcrs = new DataSet(); var vsetrs = new DataSet(); var vgrouprs = new DataSet(); const string sqlTableName = "tbl_setup_SubmitValidation"; const string sqlTableName2 = "tbl_Setup_SubmitValSetGroup1"; const string sqlTableName3 = "tbl_setup_Datadef"; const string sqlTableName4 = "temp_table"; const string sqlTableName5 = "tbl_setup_Datadef1"; const string sqlTableName6 = "temp_table1"; try { modGlobal.gv_SelectedDirectory = ""; /*LDW FileFind.Text = "Specify the destination directory for the document"; * FileFind.ShowDialog();*/ var dialog1 = new OpenFileDialog(); dialog1.Title = "Specify the destination directory for the document"; dialog1.RestoreDirectory = true; dialog1.DefaultExt = "txt"; dialog1.CheckFileExists = true; dialog1.CheckPathExists = true; dialog1.Filter = "Text files (*.txt)|*.txt|All files (*.*)|*.*"; dialog1.FilterIndex = 2; dialog1.ShowReadOnly = true; dialog1.ShowDialog(); if (!string.IsNullOrEmpty(modGlobal.gv_SelectedDirectory)) { valFile = modGlobal.gv_SelectedDirectory + (Strings.Mid(modGlobal.gv_SelectedDirectory, Strings.Len(modGlobal.gv_SelectedDirectory), 1) == "\\" ? "SummVal.txt" : "\\SummVal.txt"); } else { return; } //LDW added tostring to valFile FileSystem.FileOpen(1, valFile, OpenMode.Output); //retrieve the list of Summary Validation messages modGlobal.gv_sql = "Select tbl_setup_SubmitValidation.*"; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_SubmitValidation "; modGlobal.gv_sql = modGlobal.gv_sql + " Where "; if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " (tbl_setup_SubmitValidation.state = '' or tbl_setup_SubmitValidation.state is null) "; } else { modGlobal.gv_sql = string.Format("{0} tbl_setup_SubmitValidation.state = '{1}'", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (tbl_setup_SubmitValidation.RecordStatus = '' or tbl_setup_SubmitValidation.RecordStatus is null) "; } else { modGlobal.gv_sql = string.Format("{0} and tbl_setup_SubmitValidation.RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } modGlobal.gv_sql = modGlobal.gv_sql + " order by tbl_setup_SubmitValidation.valType "; //LDW vrs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); vrs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName, vrs); FileSystem.PrintLine(1, " Summary Validation Messages "); FileSystem.PrintLine(1, "------------------------------"); FileSystem.PrintLine(1, "------------------------------"); FileSystem.PrintLine(1, " "); FileSystem.PrintLine(1, " "); //LDW while (!vrs.EOF) { foreach (DataRow myRow in vrs.Tables[sqlTableName].Rows) { msgcount = msgcount + 1; //LDW vmessage = vrs.rdoColumns["Message"].Value; //vmessage = vrs.Tables[sqlTableName].Rows[0]["Message"].ToString(); vmessage = myRow.Field <string>("Message"); FileSystem.PrintLine(1, msgcount + " ******************************************************************"); //LDW FileSystem.PrintLine(1, vrs.rdoColumns["ValType"].Value); //FileSystem.PrintLine(1, vrs.Tables[sqlTableName].Rows[0]["ValType"].ToString()); FileSystem.PrintLine(1, myRow.Field <string>("ValType")); FileSystem.PrintLine(1, ""); FileSystem.PrintLine(1, vmessage); FileSystem.PrintLine(1, ""); modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_SubmitValSet "; //LDW modGlobal.gv_sql = modGlobal.gv_sql + " Where submitvalid = " + vrs.rdoColumns["submitvalid"].Value; //modGlobal.gv_sql = string.Format("{0} Where submitvalid = {1}", modGlobal.gv_sql, vrs.Tables[sqlTableName1].Rows[0]["submitvalid"].ToString()); modGlobal.gv_sql = string.Format("{0} Where submitvalid = {1}", modGlobal.gv_sql, myRow.Field <string>("submitvalid")); //LDW vsetrs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); vsetrs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, vsetrs); //LDW while (!vsetrs.EOF) foreach (DataRow myRow1 in vsetrs.Tables[sqlTableName2].Rows) { FileSystem.PrintLine(1, "----------------"); //FileSystem.PrintLine(1, vsetrs.rdoColumns["Description"].Value); //FileSystem.PrintLine(1, vsetrs.Tables[sqlTableName2].Rows[0]["Description"].ToString()); FileSystem.PrintLine(1, myRow1.Field <string>("Description")); FileSystem.PrintLine(1, "----------------"); modGlobal.gv_sql = " select svg.* "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_SubmitValSetGroup1 as svg "; //LDW modGlobal.gv_sql = modGlobal.gv_sql + " where svg.submitvalsetid = " + vsetrs.rdoColumns["submitvalsetid"].Value; //modGlobal.gv_sql = string.Format("{0} where svg.submitvalsetid = {1}", modGlobal.gv_sql, vsetrs.Tables[sqlTableName2].Rows[0]["submitvalsetid"]); modGlobal.gv_sql = string.Format("{0} where svg.submitvalsetid = {1}", modGlobal.gv_sql, myRow1.Field <string>("submitvalsetid")); //LDW vgrouprs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); vgrouprs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, vgrouprs); FileSystem.PrintLine(1, " Group 1 Fields ***"); //LDW while (!vgrouprs.EOF) foreach (DataRow myRow2 in vgrouprs.Tables[sqlTableName3].Rows) { //LDW if (vgrouprs.rdoColumns["SourceTable"].Value == "HOSPITAL STATISTICS") //if (vgrouprs.Tables[sqlTableName3].Rows[0]["SourceTable"].ToString() == "HOSPITAL STATISTICS") if (myRow2.Field <string>("SourceTable") == "HOSPITAL STATISTICS") { modGlobal.gv_sql = " SELECT Fieldname "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_Datadef "; modGlobal.gv_sql = modGlobal.gv_sql + " Where "; //LDW modGlobal.gv_sql = modGlobal.gv_sql + " DDID = " + vgrouprs.rdoColumns["FieldID"].Value; //modGlobal.gv_sql = string.Format("{0} DDID = {1}", modGlobal.gv_sql, vgrouprs.Tables[sqlTableName3].Rows[0]["FieldID"]); modGlobal.gv_sql = string.Format("{0} DDID = {1}", modGlobal.gv_sql, myRow2.Field <string>("FieldID")); } else { modGlobal.gv_sql = " select g.groupname + ' / ' + gr.title + ' / ' + sg.title as fieldname "; modGlobal.gv_sql = modGlobal.gv_sql + " from "; modGlobal.gv_sql = modGlobal.gv_sql + " (tbl_Setup_submitsubgroup as sg "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_Setup_submitgrouprow as gr "; modGlobal.gv_sql = modGlobal.gv_sql + " on sg.grouprowid = gr.grouprowid) "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_Setup_submitgroup as g "; modGlobal.gv_sql = modGlobal.gv_sql + " on g.groupid = gr.groupid "; //LDW modGlobal.gv_sql = modGlobal.gv_sql + " where sg.subgroupid = " + vgrouprs.rdoColumns["FieldID"].Value; modGlobal.gv_sql = string.Format("{0} where sg.subgroupid = {1}", modGlobal.gv_sql, myRow2.Field <string>("FieldID")); } //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, sqlTableName4, modGlobal.gv_rs); //LDW FileSystem.PrintLine(1, " - " + vgrouprs.rdoColumns["SourceTable"].Value + ": " + modGlobal.gv_rs.rdoColumns["FieldName"].Value); //FileSystem.PrintLine(1, string.Format(" - {0}: {1}", vgrouprs.Tables[sqlTableName3].Rows[0]["SourceTable"], modGlobal.gv_rs.Tables[sqlTableName4].Rows[0]["FieldName"])); FileSystem.PrintLine(1, string.Format(" - {0}: {1}", myRow2.Field <string>("SourceTable"), modGlobal.gv_rs.Tables[sqlTableName4].Rows[0]["FieldName"])); //LDW vgrouprs.MoveNext(); } FileSystem.PrintLine(1, " "); modGlobal.gv_sql = " select svg.* "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_SubmitValSetGroup2 as svg "; //LDW modGlobal.gv_sql = modGlobal.gv_sql + " where svg.submitvalsetid = " + vsetrs.rdoColumns["submitvalsetid"].Value; modGlobal.gv_sql = string.Format("{0} where svg.submitvalsetid = {1}", modGlobal.gv_sql, vsetrs.Tables[sqlTableName2].Rows[0]["submitvalsetid"]); //LDW vgrouprs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); vgrouprs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName5, vgrouprs); FileSystem.PrintLine(1, " Group 2 Fields ***"); //LDW while (!vgrouprs.EOF) foreach (DataRow myRow3 in vgrouprs.Tables[sqlTableName5].Rows) { //LDW if (vgrouprs.rdoColumns["SourceTable"].Value == "HOSPITAL STATISTICS") if (myRow3.Field <string>("SourceTable") == "HOSPITAL STATISTICS") { modGlobal.gv_sql = " SELECT Fieldname "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_Datadef "; modGlobal.gv_sql = modGlobal.gv_sql + " Where "; //LDW modGlobal.gv_sql = modGlobal.gv_sql + " DDID = " + vgrouprs.rdoColumns["FieldID"].Value; modGlobal.gv_sql = string.Format("{0} DDID = {1}", modGlobal.gv_sql, myRow3.Field <string>("FieldID")); } else { modGlobal.gv_sql = " select g.groupname + ' / ' + gr.title + ' / ' + sg.title as fieldname "; modGlobal.gv_sql = modGlobal.gv_sql + " from "; modGlobal.gv_sql = modGlobal.gv_sql + " (tbl_Setup_submitsubgroup as sg "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_Setup_submitgrouprow as gr "; modGlobal.gv_sql = modGlobal.gv_sql + " on sg.grouprowid = gr.grouprowid) "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_Setup_submitgroup as g "; modGlobal.gv_sql = modGlobal.gv_sql + " on g.groupid = gr.groupid "; modGlobal.gv_sql = string.Format("{0} where sg.subgroupid = {1}", modGlobal.gv_sql, myRow3.Field <string>("FieldID")); } //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, sqlTableName6, modGlobal.gv_rs); //LDW FileSystem.PrintLine(1, " - " + vgrouprs.rdoColumns["SourceTable"].Value + ": " + (modGlobal.gv_rs.RowCount > 0 ? modGlobal.gv_rs.rdoColumns["FieldName"].Value : "")); FileSystem.PrintLine(1, string.Format(" - {0}: {1}", myRow3.Field <string>("SourceTable"), modGlobal.gv_rs.Tables[0].Rows.Count > 0 ? modGlobal.gv_rs.Tables[sqlTableName6].Rows[0]["FieldName"].ToString() : "")); //vgrouprs.MoveNext(); } FileSystem.PrintLine(1, " "); //LDW vsetrs.MoveNext(); } //LDW vrs.MoveNext(); } FileSystem.FileClose(1); RadMessageBox.Show("Summary validation was exported into " + valFile); } 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 RefreshFieldList() { string ls_FieldList = "[DDID] ,[BaseTableID], [FieldName],convert(varchar(255), [Help]) as Help,[FieldType],[LookupTableID] ,[FieldSize] ,[FieldOrderold] ,[OldFieldName] ,[Required]" + " ,[Required_EffDate] ,[FieldCategory] ,[State] ,[RecordStatus],[SortOrder],[DateFieldDDID],[CMSFieldCode],[JCFieldCode],[Inactive],[ParentDDID],[AllowUTD],[IsPhysician]"; try { if (cboTableList.SelectedIndex > -1) { //clean up possible lookup table definition for fields that are date type modGlobal.gv_sql = " update tbl_setup_datadef "; modGlobal.gv_sql = modGlobal.gv_sql + " set lookuptableid = null"; modGlobal.gv_sql = string.Format("{0} where BaseTableID = {1}", modGlobal.gv_sql, Support.GetItemData(cboTableList, cboTableList.SelectedIndex)); modGlobal.gv_sql = modGlobal.gv_sql + " and upper(fieldtype) = 'DATE'"; //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); //retrieve the list of table fields modGlobal.gv_sql = string.Format("Select {0}, Category = ", ls_FieldList); modGlobal.gv_sql = modGlobal.gv_sql + " case when FieldCategory = 'Fix' then"; modGlobal.gv_sql = modGlobal.gv_sql + " 'Fix' "; modGlobal.gv_sql = modGlobal.gv_sql + " else 'Dyn' "; modGlobal.gv_sql = modGlobal.gv_sql + " end, "; modGlobal.gv_sql = modGlobal.gv_sql + " AI = case when InActive is Null then"; modGlobal.gv_sql = modGlobal.gv_sql + " 'A' "; modGlobal.gv_sql = modGlobal.gv_sql + " else 'I' "; modGlobal.gv_sql = modGlobal.gv_sql + " end "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_DataDef "; modGlobal.gv_sql = string.Format("{0} where BaseTableID = {1}", modGlobal.gv_sql, Support.GetItemData(cboTableList, cboTableList.SelectedIndex)); modGlobal.gv_sql = modGlobal.gv_sql + " AND (ParentDDID IS NULL OR ParentDDID = DDID) "; if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (State = '' or State is Null) "; } else { modGlobal.gv_sql = string.Format("{0} and State = '{1}'", modGlobal.gv_sql, modGlobal.gv_State); } // if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (RecordStatus = '' or RecordStatus is null) "; } else { modGlobal.gv_sql = string.Format("{0} and RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } // if (cboTableList.Text == "HOSPITAL DEMOGRAPHICS") { modGlobal.gv_sql = modGlobal.gv_sql + " order by SORTorder "; } else { modGlobal.gv_sql = modGlobal.gv_sql + " order by FieldCategory desc, FieldName asc "; } } else { modGlobal.gv_sql = string.Format("Select {0}, Category = ", ls_FieldList); modGlobal.gv_sql = modGlobal.gv_sql + " case when FieldCategory = 'Fix' then"; modGlobal.gv_sql = modGlobal.gv_sql + " 'Fix' "; modGlobal.gv_sql = modGlobal.gv_sql + " else 'Dyn' "; modGlobal.gv_sql = modGlobal.gv_sql + " end "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_DataDef "; modGlobal.gv_sql = modGlobal.gv_sql + " where BaseTableID = 0 "; if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (State = '' or State is Null) "; } else { modGlobal.gv_sql = string.Format("{0} and State = '{1}'", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (RecordStatus = '' or RecordStatus is null) "; } else { modGlobal.gv_sql = string.Format("{0} and RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } if (cboTableList.Text == "HOSPITAL DEMOGRAPHICS") { modGlobal.gv_sql = modGlobal.gv_sql + " order by SORTorder "; } else { modGlobal.gv_sql = modGlobal.gv_sql + " order by FieldCategory desc , FieldName asc"; } } //LDW rdcFieldList.Resultset = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); //clear current entries rdcFieldList.Reset(); //Load new entries rdcFieldListTable = "tbl_setup_datadef"; rdcFieldList = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, rdcFieldListTable, rdcFieldList); //refresh radgridview with new entries dbgFieldList.Refresh(); if (cboTableList.Text == "HOSPITAL DEMOGRAPHICS") { cmdMoveUp.Visible = true; cmdMoveDown.Visible = true; } else { cmdMoveUp.Visible = false; cmdMoveDown.Visible = false; } //End If 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)); } }
private void SaveChanges() { int li_group = 0; string SQL = null; try { if (string.IsNullOrEmpty(Strings.Trim(cboGroup.Text))) { RadMessageBox.Show("Please select a group to associate with this criteria"); return; } li_group = Convert.ToInt32(cboGroup.Text); if (lstSelectedSetList.Items.Count == 0) { if (RadMessageBox.Show("Are you sure you want to remove this group?", "Confirm Delete", MessageBoxButtons.OKCancel, RadMessageIcon.Question) == DialogResult.OK) { modGlobal.gv_sql = string.Format("SELECT * FROM tbl_Setup_MeasureStepGroup WHERE MeasureStepID = {0} AND MeasureStepGroup > {1}", ii_MeasureStepID, li_group); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName7 = "tbl_Setup_MeasureStepGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName7, modGlobal.gv_rs); //LDW if (!modGlobal.gv_rs.EOF) foreach (DataRow myRow7 in modGlobal.gv_rs.Tables[sqlTableName7].Rows) { RadMessageBox.Show("You must delete groups after this group first.", "Remove Other Groups First", MessageBoxButtons.OK, RadMessageIcon.Error); return; } //delete the grouping //LDW modGlobal.gv_cn.Execute("DELETE FROM tbl_Setup_MeasureStepGroup WHERE MeasureStepID = " + ii_MeasureStepID + " AND MeasureStepGroup = " + li_group); SQL = string.Format("DELETE FROM tbl_Setup_MeasureStepGroup WHERE MeasureStepID = {0} AND MeasureStepGroup = {1}", ii_MeasureStepID, li_group); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, SQL); goto Populate; } else { return; } } if (string.IsNullOrEmpty(Strings.Trim(cboJoinOperator.Text))) { RadMessageBox.Show("Please select the Join Type; the option that defines how to add this group to the exisiting ones."); return; } int li_cnt = 0; //LDW modGlobal.gv_cn.Execute("DELETE FROM tbl_Setup_MeasureStepGroup WHERE MeasureStepID = " + ii_MeasureStepID + " AND MeasureStepGroup = " + li_group); SQL = string.Format("DELETE FROM tbl_Setup_MeasureStepGroup WHERE MeasureStepID = {0} AND MeasureStepGroup = {1}", ii_MeasureStepID, li_group); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, SQL); for (li_cnt = 0; li_cnt <= lstSelectedSetList.Items.Count - 1; li_cnt++) { //delete then insert in case any were removed from the selected list modGlobal.gv_sql = "SELECT * FROM tbl_Setup_MeasureStepGroup WHERE MeasureStepID = " + ii_MeasureStepID; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenKeyset, RDO.LockTypeConstants.rdConcurLock); const string sqlTableName8 = "tbl_Setup_MeasureStepGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName8, modGlobal.gv_rs); //LDW modGlobal.gv_rs.AddNew(); //LDW creat new datatable row DataRow newRow = modGlobal.gv_rs.Tables[sqlTableName8].NewRow(); newRow["MeasureStepID"] = ii_MeasureStepID; newRow["measurecriteriasetid"] = Convert.ToInt32(Support.GetItemData(lstSelectedSetList, li_cnt)); newRow["MeasureStepGroup"] = li_group; newRow["JoinOperator"] = cboJoinOperator.Text; //Add new datatable row modGlobal.gv_rs.Tables[sqlTableName8].Rows.Add(newRow); //LDW modglobal.gv_rs.Update(); modGlobal.gv_rs.AcceptChanges(); } modGlobal.gv_rs.Dispose(); Populate: PopulateGroupList(); cboGroup.SelectedIndex = li_group - 1; 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 CopyFromMeasureToMeasure() { string is_MeasureID = null; bool CopyStepandSetRecords = false; var cboMeasures = new RadDropDownList(); var cboSet = new RadDropDownList(); var cboStep = new RadDropDownList(); string [] is_MeasureCriteriaIDs = null; var cboJoinOperator = new RadDropDownList(); int InsertStepandSetRecords = 0; int li_SetID = 0; //On Error GoTo ErrHandler try { if (string.IsNullOrEmpty(is_MeasureID)) { if (cboStep.SelectedIndex < 0 | cboSet.SelectedIndex < 0 | cboMeasures.SelectedIndex < 0 | (cboJoinOperator.SelectedIndex < 0 & string.IsNullOrEmpty(cboJoinOperator.Text))) { RadMessageBox.Show("Define the definition of the new criteria."); } else { //copy the criteria li_SetID = InsertStepandSetRecords; if (li_SetID != -1) { modGlobal.gv_sql = " insert into tbl_Setup_MeasureCriteria ("; modGlobal.gv_sql = modGlobal.gv_sql + " MeasureCriteriaSetID, "; modGlobal.gv_sql = modGlobal.gv_sql + " CriteriaTitle, "; modGlobal.gv_sql = modGlobal.gv_sql + " DDID1, "; modGlobal.gv_sql = modGlobal.gv_sql + " DDID2, "; modGlobal.gv_sql = modGlobal.gv_sql + " FieldOperator, "; modGlobal.gv_sql = modGlobal.gv_sql + " ValueOperator, "; modGlobal.gv_sql = modGlobal.gv_sql + " FieldValue, "; modGlobal.gv_sql = modGlobal.gv_sql + " LookupID, "; modGlobal.gv_sql = modGlobal.gv_sql + " LookupTableID, "; modGlobal.gv_sql = modGlobal.gv_sql + " DateUnit, "; modGlobal.gv_sql = modGlobal.gv_sql + " JoinOperator, MeasureFieldGroupLogicID, MultSelAny "; modGlobal.gv_sql = modGlobal.gv_sql + " ) "; modGlobal.gv_sql = modGlobal.gv_sql + " select "; modGlobal.gv_sql = modGlobal.gv_sql + li_SetID + ", "; modGlobal.gv_sql = modGlobal.gv_sql + " CriteriaTitle, "; modGlobal.gv_sql = modGlobal.gv_sql + " DDID1, "; modGlobal.gv_sql = modGlobal.gv_sql + " DDID2, "; modGlobal.gv_sql = modGlobal.gv_sql + " FieldOperator, "; modGlobal.gv_sql = modGlobal.gv_sql + " ValueOperator, "; modGlobal.gv_sql = modGlobal.gv_sql + " FieldValue, "; modGlobal.gv_sql = modGlobal.gv_sql + " LookupID, "; modGlobal.gv_sql = modGlobal.gv_sql + " LookupTableID, "; modGlobal.gv_sql = modGlobal.gv_sql + " DateUnit, "; modGlobal.gv_sql = modGlobal.gv_sql + " '" + cboJoinOperator.Text + "', MeasureFieldGroupLogicID, MultSelAny "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_MeasureCriteria "; modGlobal.gv_sql = modGlobal.gv_sql + " where MeasureCriteriaID in (" + Strings.Join(is_MeasureCriteriaIDs, ", ") + ")"; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); this.Close(); } } } else { //LDW modGlobal.gv_sql = "SELECT * FROM tbl_Setup_MeasureStep WHERE " + " MeasureID = " + cboMeasures.ItemData(cboMeasures.SelectedIndex); modGlobal.gv_sql = "SELECT * FROM tbl_Setup_MeasureStep WHERE " + " MeasureID = " + Support.GetItemData(cboMeasures, cboMeasures.SelectedIndex); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_Setup_MeasureStep"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName1].Rows.Count > 0) { RadMessageBox.Show("Cannot duplicate! The destination measure has some criteria in the flowchart that has to be removed first."); } else { if (CopyStepandSetRecords) { this.Close(); } } } 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 cmdDelete_Click(Object eventSender, EventArgs eventArgs) { DialogResult Delfield; string msg = null; bool hasvalidation; try { if (rdcFieldList.Tables[rdcFieldListTable].Rows.Count > 0) { //LDW if (rdcFieldList.Resultset.rdoColumns["FieldCategory"].Value == "Fix") if (rdcFieldList.Tables[rdcFieldListTable].Rows[0]["FieldCategory"].ToString() == "Fix") { //LDW RadMessageBox.Show("Cannot delete this field, because this is a fix field."); DialogResult ds3 = RadMessageBox.Show(this, "Cannot delete this field, because this is a fix field.", "Delete Field", MessageBoxButtons.OK, RadMessageIcon.Error); this.Text = ds3.ToString(); return; } hasvalidation = false; modGlobal.gv_sql = "Select * from tbl_setup_TableValidation "; modGlobal.gv_sql = string.Format("{0} where SourceDDID1 = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); modGlobal.gv_sql = string.Format("{0} or SourceDDID2 = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); modGlobal.gv_sql = string.Format("{0} or DestDDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName3 = "tbl_setup_TableValidation"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); //LDW if (modGlobal.gv_rs.RowCount > 0) if (modGlobal.gv_rs.Tables[sqlTableName3].Rows.Count > 0) { hasvalidation = true; } modGlobal.gv_sql = "Select * from tbl_setup_TableValidationAction "; modGlobal.gv_sql = string.Format("{0} where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName4 = "tbl_setup_TableValidationAction"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName4, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName4].Rows.Count > 0) { hasvalidation = true; } modGlobal.gv_sql = "Select * from tbl_setup_TableValidationAfterFieldupdate "; modGlobal.gv_sql = string.Format("{0} where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName5 = "tbl_setup_TableValidationAfterFieldupdate"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName5, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName5].Rows.Count > 0) { hasvalidation = true; } if (hasvalidation == true) { //LDW RadMessageBox.Show("This field has been used in the validation setup. Remove the related validation before deleting the field."); DialogResult ds4 = RadMessageBox.Show(this, "This field has been used in the validation setup. Remove the related validation before deleting the field.", "Delete Field", MessageBoxButtons.OK, RadMessageIcon.Error); this.Text = ds4.ToString(); return; } modGlobal.gv_sql = "Select * from tbl_setup_submitsubgroupfields "; modGlobal.gv_sql = string.Format("{0} where aggregatefieldid = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName6 = "tbl_setup_submitsubgroupfields"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName6, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName6].Rows.Count > 0) { //LDW RadMessageBox.Show("This field has been used in the summarization process. Update the related summarization before deleting the field."); DialogResult ds5 = RadMessageBox.Show(this, "This field has been used in the summarization process. Update the related summarization before deleting the field.", "Delete Field", MessageBoxButtons.OK, RadMessageIcon.Error); this.Text = ds5.ToString(); return; } if (string.IsNullOrEmpty(rdcFieldList.Tables[rdcFieldListTable].Rows[0]["OldFieldName"].ToString()) | Information.IsDBNull(rdcFieldList.Tables[rdcFieldListTable].Rows[0]["OldFieldName"])) { msg = " Are you sure that you want to delete this field?"; //LDW Delfield = RadMessageBox.Show(msg, MsgBoxStyle.YesNo, "Delete Field"); Delfield = RadMessageBox.Show(this, msg, "Delete Field", MessageBoxButtons.YesNo, RadMessageIcon.Question); } else { msg = string.Format("This field has been mapped to a field in the older version.{0}{1}", Strings.Chr(10), Strings.Chr(13)); msg = msg + " Are you sure you want to delete this field?"; Delfield = RadMessageBox.Show(this, msg, "Delete Field", MessageBoxButtons.YesNo, RadMessageIcon.Question); } if (Delfield == DialogResult.Yes) { modGlobal.gv_sql = "Delete tbl_setup_DataReq "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "Delete tbl_setup_HospStatGroupFields "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "Delete tbl_setup_IndicatorGroupSet "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_Importvalidation "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_Importvalidation "; modGlobal.gv_sql = modGlobal.gv_sql + " Where msgid in "; modGlobal.gv_sql = modGlobal.gv_sql + " (select ivm.msgid "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_Importvalidationmessage as ivm "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_setup_importfields as imf "; modGlobal.gv_sql = modGlobal.gv_sql + " on ivm.importfieldid = imf.importfieldid "; modGlobal.gv_sql = string.Format("{0} Where imf.DDID = {1})", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(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 "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1})", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_ImportFields "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_submitcleanupcrit "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //was missing call to the execute command DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_submitcleanupcrit "; modGlobal.gv_sql = modGlobal.gv_sql + " where submitcleanupid in "; modGlobal.gv_sql = modGlobal.gv_sql + " (select submitcleanupid from tbl_setup_submitcleanupitems "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1})", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_submitcriteria "; modGlobal.gv_sql = string.Format("{0} Where DDID1 = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); modGlobal.gv_sql = string.Format("{0} or DDID2 = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_savedadhocreportcriteria "; modGlobal.gv_sql = string.Format("{0} Where SourceDDID1 = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); modGlobal.gv_sql = string.Format("{0} or SourceDDID2 = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); modGlobal.gv_sql = string.Format("{0} or DestDDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "delete tbl_setup_savedadhocreportfields "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "Delete tbl_setup_DataDef "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); // modGlobal.gv_sql = "Delete tbl_setup_DataDefActions "; modGlobal.gv_sql = string.Format("{0} Where DDID = {1}", modGlobal.gv_sql, rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshFieldList(); } } } 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 RefreshHospStatFields() { frmHospStatSetup frmHospStatSetupCopy = new frmHospStatSetup(); var LIndex = 0; var Table_ListIndex = 0; List <Item> itemslstHospStatFields = new List <Item>(); try { //retrieve the list of Fields modGlobal.gv_sql = "Select tbl_setup_DataDef.* "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_DataDef, tbl_setup_TableDef "; modGlobal.gv_sql = modGlobal.gv_sql + " Where tbl_setup_DataDef.BaseTableID = tbl_setup_TableDef.BaseTableID "; modGlobal.gv_sql = modGlobal.gv_sql + " and upper(substring(tbl_setup_TableDef.BaseTable,1,13)) = 'HOSPITAL STAT' "; modGlobal.gv_sql = modGlobal.gv_sql + " and tbl_setup_DataDef.ddid not in "; modGlobal.gv_sql = modGlobal.gv_sql + " (Select DDID from tbl_setup_HospStatGroupFields "; modGlobal.gv_sql = string.Format("{0} where hospstatgroupid = {1})", modGlobal.gv_sql, Support.GetItemData(frmHospStatSetupCopy.lstHospStatGroup, frmHospStatSetupCopy.lstHospStatGroup.SelectedIndex)); if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (tbl_Setup_DataDef.State = '' or tbl_Setup_DataDef.State is null) "; } else { modGlobal.gv_sql = string.Format("{0} and (tbl_Setup_DataDef.State = '' or tbl_Setup_DataDef.State is null or tbl_Setup_DataDef.State = '{1}') ", modGlobal.gv_sql, modGlobal.gv_State); } modGlobal.gv_sql = modGlobal.gv_sql + " order by tbl_setup_DataDef.FieldName "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_setup_DataDef"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); lstHospStatFields.Items.Clear(); Table_ListIndex = -1; LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow2 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { LIndex = LIndex + 1; Table_ListIndex = LIndex; itemslstHospStatFields.Add(new Item(myRow2.Field <int>("ddid"), myRow2.Field <string>("FieldName"))); //lstHospStatFields.Items.Add(new ListBoxItem(myRow2.Field<string>("FieldName"), myRow2.Field<int>("ddid")).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 cmdSelect_Click(object sender, EventArgs e) { frmPatientSetup frmPatientSetupCopy = new frmPatientSetup(); var i = 0; int newid = modDBSetup.FindMaxRecID("tbl_Setup_Indicatorgroupset", "Indicatorgroupsetid"); int maxorder; try { if (string.IsNullOrEmpty(cboPatientFields.Text)) { RadMessageBox.Show("Please select a field from the list."); return; } modGlobal.gv_sql = "Select max(tbl_setup_indicatorgroupset.FieldOrder) as MaxOrder "; modGlobal.gv_sql = modGlobal.gv_sql + " from (tbl_setup_indicatorgroupset "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_setup_DataDef "; modGlobal.gv_sql = modGlobal.gv_sql + " on tbl_setup_indicatorgroupset.ddid = tbl_setup_DataDef.ddid) "; modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_Setup_TableDef "; modGlobal.gv_sql = modGlobal.gv_sql + " on tbl_setup_DataDef.BaseTableID = tbl_Setup_TableDef.BaseTableID "; modGlobal.gv_sql = modGlobal.gv_sql + " WHERE tbl_Setup_TableDef.BaseTable = 'PATIENT' "; modGlobal.gv_sql = string.Format("{0} AND IndicatorGroupID = {1}", modGlobal.gv_sql, Support.GetItemData(frmPatientSetupCopy.cboIndicatorGroup, frmPatientSetupCopy.cboIndicatorGroup.SelectedIndex)); //gv_sql = gv_sql & " and tbl_Setup_DataDef.FieldCategory <> 'Fix' " //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_setup_indicatorgroupset"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); maxorder = (Information.IsDBNull(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["maxorder"]) ? 0 : Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["maxorder"])) + 1; modGlobal.gv_sql = "insert into tbl_setup_indicatorgroupset "; modGlobal.gv_sql = modGlobal.gv_sql + " (indicatorgroupsetid, IndicatorGroupID, ddid, fieldorder) "; modGlobal.gv_sql = modGlobal.gv_sql + " values ( "; modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, newid); modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, Support.GetItemData(frmPatientSetupCopy.cboIndicatorGroup, frmPatientSetupCopy.cboIndicatorGroup.SelectedIndex)); modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, Support.GetItemData(cboPatientFields, cboPatientFields.SelectedIndex)); modGlobal.gv_sql = string.Format("{0}{1}) ", modGlobal.gv_sql, maxorder); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); for (i = 0; i <= lstIndicators.Items.Count - 1; i++) { if (lstIndicators.SelectedIndex == i) { newid = modDBSetup.FindMaxRecID("tbl_setup_DataReq", "Indicatorddid"); modGlobal.gv_sql = "Insert into tbl_setup_DataReq "; modGlobal.gv_sql = modGlobal.gv_sql + " (IndicatorDDID, IndicatorID, DDID)"; modGlobal.gv_sql = string.Format("{0} Values ({1}", modGlobal.gv_sql, newid); modGlobal.gv_sql = string.Format("{0},{1}", modGlobal.gv_sql, Support.GetItemData(lstIndicators, i)); modGlobal.gv_sql = string.Format("{0},{1})", modGlobal.gv_sql, Support.GetItemData(cboPatientFields, cboPatientFields.SelectedIndex)); 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 frmImportAddValidField_Load(object sender, EventArgs e) { frmImportSetup frmImportSetupCopy = new frmImportSetup(); int thisindex = 0; RadLabel dtText = new RadLabel(); List <Item> itemscboImportFields = new List <Item>(); try { cboImportFields.Items.Clear(); modGlobal.gv_sql = "select tbl_setup_DataDef.* , tbl_setup_ImportFields.OrderNumber "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_DataDef, tbl_setup_ImportFields "; modGlobal.gv_sql = modGlobal.gv_sql + " where tbl_setup_DataDef.DDID = tbl_setup_ImportFields.DDID "; modGlobal.gv_sql = string.Format("{0} and tbl_setup_ImportFields.importsetupid = {1}", modGlobal.gv_sql, modGlobal.gv_importsetupid); modGlobal.gv_sql = modGlobal.gv_sql + " order by tbl_setup_ImportFields.OrderNumber "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_setup_DataDef"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { itemscboImportFields.Add(new Item(myRow1.Field <int>("DDID"), myRow1.Field <string>("FieldName"))); //cboImportFields.Items.Add(new ListBoxItem(myRow1.Field<string>("FieldName"),myRow1.Field<int>("DDID")).ToString()); if (frmImportSetupCopy.txtAction.Text == "Edit Error") { if (myRow1.Field <int>("DDID") == Convert.ToInt32(frmImportSetupCopy.rdcImportValError.Tables[rdcImportValErrorTable].Rows[0]["DDID"])) { cboImportFields.SelectedIndex = thisindex; } } else if (frmImportSetupCopy.txtAction.Text == "Edit Warning") { if (myRow1.Field <int>("DDID") == Convert.ToInt32(frmImportSetupCopy.rdcImportValWarning.Tables[rdcImportValWarningTable].Rows[0]["DDID"])) { cboImportFields.SelectedIndex = thisindex; } } thisindex = thisindex + 1; //LDW modGlobal.gv_rs.MoveNext(); } this.cboImportFields.DataSource = itemscboImportFields; this.cboImportFields.DisplayMember = "Description"; this.cboImportFields.ValueMember = "Id"; if (frmImportSetupCopy.txtAction.Text == "Add Error") { } else if (frmImportSetupCopy.txtAction.Text == "Edit Error") { txtMessage.Text = frmImportSetupCopy.rdcImportValError.Tables[rdcImportValErrorTable].Rows[0]["Message"].ToString(); //gv_sql = "Select Message from tbl_setup_ImportValidationMessage " //gv_sql = gv_sql & " where msgID = " & frmImportSetupCopy.rdcImportValError.Resultset!msgid //Set dtText.Recordset = gv_cn.OpenResultset(gv_sql, dbOpenSnapshot) //txtMessage = dtText.Recordset!Message } else if (frmImportSetupCopy.txtAction.Text == "Add Warning") { } else if (frmImportSetupCopy.txtAction.Text == "Edit Warning") { txtMessage.Text = frmImportSetupCopy.rdcImportValWarning.Tables[rdcImportValWarningTable].Rows[0]["Message"].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)); } }
private void cmdAdd_Click(object sender, EventArgs e) { frmImportSetup frmImportSetupCopy = new frmImportSetup(); int newmsgid; int thisimportfieldid; try { if (cboImportFields.SelectedIndex < 0 | string.IsNullOrEmpty(txtMessage.Text)) { RadMessageBox.Show("Field and Message are both required to complete this action."); return; } modGlobal.gv_sql = "select importfieldid "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_ImportFields "; modGlobal.gv_sql = string.Format("{0} where DDID = {1}", modGlobal.gv_sql, Support.GetItemData(cboImportFields, cboImportFields.SelectedIndex)); modGlobal.gv_sql = string.Format("{0} and importsetupid = {1}", modGlobal.gv_sql, modGlobal.gv_importsetupid); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_setup_ImportFields"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); thisimportfieldid = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["ImportFieldID"]); if (frmImportSetupCopy.txtAction.Text == "Add Error") { newmsgid = modDBSetup.FindMaxRecID("tbl_setup_ImportValidationMessage", "MSGID"); modGlobal.gv_sql = "Insert into tbl_setup_ImportValidationMessage "; modGlobal.gv_sql = modGlobal.gv_sql + " (importfieldid, MSGID, DDID, ValidationType, Message)"; modGlobal.gv_sql = string.Format("{0} values ({1},{2},", modGlobal.gv_sql, thisimportfieldid, newmsgid); modGlobal.gv_sql = string.Format("{0}{1},", modGlobal.gv_sql, Support.GetItemData(cboImportFields, cboImportFields.SelectedIndex)); modGlobal.gv_sql = string.Format("{0} 'ERROR', '{1}')", modGlobal.gv_sql, modGlobal.ConvertApastroph(txtMessage.Text)); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); this.Close(); } else if (frmImportSetupCopy.txtAction.Text == "Edit Error") { modGlobal.gv_sql = "update tbl_setup_ImportValidationMessage "; modGlobal.gv_sql = string.Format("{0} set DDID = {1}", modGlobal.gv_sql, Support.GetItemData(cboImportFields, cboImportFields.SelectedIndex)); modGlobal.gv_sql = string.Format("{0}, Message = '{1}", modGlobal.gv_sql, modGlobal.ConvertApastroph(txtMessage.Text)) + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " where msgid = " + frmImportSetupCopy.rdcImportValError.Tables[rdcImportValErrorTable].Rows[0]["msgid"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); this.Close(); } else if (frmImportSetupCopy.txtAction.Text == "Add Warning") { newmsgid = modDBSetup.FindMaxRecID("tbl_setup_ImportValidationMessage", "MSGID"); modGlobal.gv_sql = "Insert into tbl_setup_ImportValidationMessage "; modGlobal.gv_sql = modGlobal.gv_sql + " (importfieldid, MSGID, DDID, ValidationType, Message)"; modGlobal.gv_sql = string.Format("{0} values ({1},{2},", modGlobal.gv_sql, thisimportfieldid, newmsgid); modGlobal.gv_sql = string.Format("{0}{1},", modGlobal.gv_sql, Support.GetItemData(cboImportFields, cboImportFields.SelectedIndex)); modGlobal.gv_sql = string.Format("{0} 'WARNING', '{1}')", modGlobal.gv_sql, modGlobal.ConvertApastroph(txtMessage.Text)); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); this.Close(); } else if (frmImportSetupCopy.txtAction.Text == "Edit Warning") { modGlobal.gv_sql = "update tbl_setup_ImportValidationMessage "; modGlobal.gv_sql = string.Format("{0} set DDID = {1}", modGlobal.gv_sql, Support.GetItemData(cboImportFields, cboImportFields.SelectedIndex)); modGlobal.gv_sql = string.Format("{0}, Message = '{1}", modGlobal.gv_sql, modGlobal.ConvertApastroph(txtMessage.Text)) + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " where msgid = " + frmImportSetupCopy.rdcImportValError.Tables[rdcImportValErrorTable].Rows[0]["msgid"]; 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 RefreshIndicatorDep() { string IndDesc = null; var LIndex = 0; var Table_ListIndex = 0; try { modGlobal.gv_sql = "Select tbl_setup_Indicator.Description, tbl_setup_IndicatorDep.* "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_Indicator, tbl_setup_IndicatorDep "; modGlobal.gv_sql = modGlobal.gv_sql + " Where "; modGlobal.gv_sql = modGlobal.gv_sql + " tbl_setup_Indicator.IndicatorID = tbl_setup_IndicatorDep.IndicatorID "; if (lstIndicators.SelectedIndex > -1) { modGlobal.gv_sql = modGlobal.gv_sql + " and tbl_setup_IndicatorDep.IndicatorParentID = " + Support.GetItemData(lstIndicators, lstIndicators.SelectedIndex); } else { modGlobal.gv_sql = modGlobal.gv_sql + " and tbl_setup_IndicatorDep.IndicatorParentID = -1 "; } modGlobal.gv_sql = modGlobal.gv_sql + " order by tbl_setup_Indicator.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); lstRequiredIndicator.Items.Clear(); Table_ListIndex = -1; LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName1].Rows) { LIndex = LIndex + 1; Table_ListIndex = LIndex; if (Information.IsDBNull(myRow1.Field <string>("EffDate"))) { IndDesc = myRow1.Field <string>("Description"); } else { IndDesc = string.Format("{0} (Eff. as of: {1})", myRow1.Field <string>("Description"), myRow1.Field <string>("EffDate")); } lstRequiredIndicator.Items.Add(new ListBoxItem(IndDesc, myRow1.Field <int>("IndicatorDepID")).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)); } }
public void RefreshIndicatorSet() { string setDesc = null; var LIndex = 0; var Table_ListIndex = 0; try { modGlobal.gv_sql = "Select * from tbl_setup_IndicatorSet "; 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 = '{1}'", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (RecordStatus = '' or RecordStatus is null) "; } else { modGlobal.gv_sql = string.Format("{0} and RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } modGlobal.gv_sql = modGlobal.gv_sql + " order by IndicatorsetDesc "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_setup_Indicator"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); cboIndicatorSet.Items.Clear(); Table_ListIndex = -1; LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow2 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { LIndex = LIndex + 1; Table_ListIndex = LIndex; if (Information.IsDBNull(myRow2.Field <string>("EffDate"))) { setDesc = myRow2.Field <string>("IndicatorSetDesc"); } else { setDesc = string.Format("{0} ({1})", myRow2.Field <string>("IndicatorSetDesc"), myRow2.Field <string>("EffDate")); } cboIndicatorSet.Items.Add(new ListBoxItem(setDesc, myRow2.Field <int>("IndicatorSetID")).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)); } }
public void RefreshIndicator() { string JCAHOID = null; var LIndex = 0; var Table_ListIndex = 0; try { //retrieve the list of Indicators modGlobal.gv_sql = "Select * 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 = '{1}'", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (RecordStatus = '' or RecordStatus is null) "; } else { modGlobal.gv_sql = string.Format("{0} and RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } 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 sqlTableName3 = "tbl_setup_Indicator"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); lstIndicators.Items.Clear(); Table_ListIndex = -1; LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { LIndex = LIndex + 1; Table_ListIndex = LIndex; JCAHOID = ""; if (!Information.IsDBNull(myRow3.Field <int>("JCAHOID"))) { JCAHOID = myRow3.Field <int>("JCAHOID") + " - "; } if (Information.IsDBNull(myRow3.Field <string>("lastupdatedate"))) { lstIndicators.Items.Add(JCAHOID + myRow3.Field <string>("Description")); } else { lstIndicators.Items.Add(string.Format("{0}{1} ({2})", JCAHOID, myRow3.Field <string>("Description"), myRow3.Field <string>("lastupdatedate"))); } Support.SetItemData(lstIndicators, lstIndicators.Items.Count - 1, myRow3.Field <int>("IndicatorID")); //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)); } }
public static void PrintTableValCriteria(int thismessageid) { string CPref = null; string CSuff = null; //LDW object Cindex = null; int Cindex = 0; //LDW object TotalRec = null; int TotalRec = 0; //LDW object SetCount = null; int SetCount = 0; //LDW object TotalSetRec = null; int TotalSetRec = 0; string mainjoinop = ""; //LDW object rs_critSet = null; var rs_critSet = new DataSet(); const string sqlTableName8 = "tbl_setup_TableValidation"; const string sqlTableName9 = "temp_table3"; const string sqlTableName10 = "temp_table4"; try { int rs_critsetIndexLast = rs_critSet.Tables[sqlTableName8].Rows.Count - 1; const int rs_critset_IndexFirst = 0; int rs_critset_Count = modGlobal.gv_rs.Tables[sqlTableName10].Rows.Count; int gv_rsIndexLast = modGlobal.gv_rs.Tables[sqlTableName10].Rows.Count - 1; const int gv_rsIndexFirst = 0; int gv_rsCount = modGlobal.gv_rs.Tables[sqlTableName10].Rows.Count; modGlobal.gv_sql = "Select CriteriaSet from tbl_setup_TableValidation "; modGlobal.gv_sql = string.Format("{0" + "} where tablevalidationmessageid = {1}", modGlobal.gv_sql, thismessageid); modGlobal.gv_sql = modGlobal.gv_sql + " group by CriteriaSet "; modGlobal.gv_sql = modGlobal.gv_sql + " order by CriteriaSet "; //LDW rs_critSet = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); rs_critSet = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName8, rs_critSet); //LDW rs_critSet.MoveLast(); //for (int index = 0; index <= rs_critsetIndexLast; index++) //{ // DataRow myRow2 = rs_critSet.Tables[sqlTableName8].Rows[index]; //} //LDW TotalSetRec = rs_critSet.RowCount; TotalSetRec = rs_critSet.Tables[sqlTableName8].Rows.Count; ////LDW rs_critSet.MoveFirst(); //for (int index = 0; index >= rs_critset_IndexFirst; index++) //{ // DataRow myRow2 = rs_critSet.Tables[sqlTableName8].Rows[index]; //} //LDW if (rs_critSet.RowCount > 0) if (rs_critset_Count > 0) { SetCount = SetCount + 1; modGlobal.gv_sql = "Select * from tbl_setup_tablevalidationmessage "; modGlobal.gv_sql = string.Format("{0} " + "where tablevalidationmessageid = {1}", modGlobal.gv_sql, thismessageid); //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, sqlTableName9, modGlobal.gv_rs); //LDW if (!Information.IsDBNull(modGlobal.gv_rs.rdoColumns["JoinOperator"].Value)) if (!Information.IsDBNull(modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["JoinOperator"])) { //LDW mainjoinop = modGlobal.gv_rs.rdoColumns["JoinOperator"].Value; mainjoinop = modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["JoinOperator"].ToString(); } //LDW while (!rs_critSet.EOF) foreach (DataRow myRow in rs_critSet.Tables[sqlTableName8].Rows) { modGlobal.gv_sql = "Select * from tbl_setup_tablevalidation "; modGlobal.gv_sql = string.Format("{0} where tablevalidationmessageid = {1}", modGlobal.gv_sql, thismessageid); //LDW modGlobal.gv_sql = modGlobal.gv_sql + " and CriteriaSet = " + rs_critSet["CriteriaSet"]; modGlobal.gv_sql = string.Format("{0} and CriteriaSet = {1}", modGlobal.gv_sql, myRow.Field <string>("CriteriaSet")); //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, sqlTableName10, modGlobal.gv_rs); ////LDW modGlobal.gv_rs.MoveLast(); //for (int index = 0; index <= gv_rsIndexLast; index++) //{ // DataRow myRow2 = modGlobal.gv_rs.Tables[sqlTableName10].Rows[index]; //} //LDW TotalRec = modGlobal.gv_rs.RowCount; TotalRec = gv_rsCount; ////LDW modGlobal.gv_rs.MoveFirst(); //for (int index = 0; index >= gv_rsIndexFirst; index++) //{ // DataRow myRow2 = modGlobal.gv_rs.Tables[sqlTableName10].Rows[index]; //} Cindex = 0; CSuff = ""; //LDW CPref = "Set " + modGlobal.gv_rs.rdoColumns["CriteriaSet"].Value + ": ("; CPref = string.Format("Set {0}: (", modGlobal.gv_rs.Tables[sqlTableName10].Rows[0]["CriteriaSet"]); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName10].Rows) { Cindex = Cindex + 1; if (Cindex == TotalRec) { if (TotalRec == 1) { //LDW CSuff = " (" + modGlobal.gv_rs.rdoColumns["JoinOperator"].Value + ") )"; CSuff = " (" + myRow3.Field <string>("JoinOperator"); } else { CSuff = ")"; } } else { //LDW CSuff = " " + modGlobal.gv_rs.rdoColumns["JoinOperator"].Value; CSuff = " " + myRow3.Field <string>("JoinOperator"); } if (Cindex == 1) { //LDW FileSystem.PrintLine(1, CPref + modGlobal.gv_rs.rdoColumns["CriteriaTitle"].Value + CSuff); FileSystem.PrintLine(1, CPref + myRow3.Field <string>("CriteriaTitle") + CSuff); } else { //LDW FileSystem.PrintLine(1, " " + modGlobal.gv_rs.rdoColumns["CriteriaTitle"].Value + CSuff); FileSystem.PrintLine(1, string.Format(" {0}{1}", myRow3.Field <string>("CriteriaTitle"), CSuff)); } //LDW modGlobal.gv_rs.MoveNext(); } if (SetCount < TotalSetRec) { FileSystem.PrintLine(1, Strings.Chr(13)); FileSystem.PrintLine(1, mainjoinop); } //LDW rs_critSet.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)); } }
public static void PrintTableValidation(int thisTableID) { string vmessage = null; string validatewhen = null; int thismessageid; int msgcount = 0; string valFile = null; var vrs = new DataSet(); //LDW DataSet vcrs = new DataSet(); const string sqlTableName7 = "temp_table2"; try { modGlobal.gv_SelectedDirectory = ""; /*FileFind.Text = "Specify the destination directory for the document"; * FileFind.ShowDialog();*/ var dialog1 = new OpenFileDialog(); dialog1.Title = "Specify the destination directory for the document"; dialog1.RestoreDirectory = true; dialog1.DefaultExt = "txt"; dialog1.CheckFileExists = true; dialog1.CheckPathExists = true; dialog1.Filter = "Text files (*.txt)|*.txt|All files (*.*)|*.*"; dialog1.FilterIndex = 2; dialog1.ShowReadOnly = true; dialog1.ShowDialog(); if (!string.IsNullOrEmpty(modGlobal.gv_SelectedDirectory)) { valFile = modGlobal.gv_SelectedDirectory + (Strings.Mid(modGlobal.gv_SelectedDirectory, Strings.Len(modGlobal.gv_SelectedDirectory), 1) == "\\" ? "TableVal.txt" : "\\TableVal.txt"); } else { return; } FileSystem.FileOpen(1, valFile, OpenMode.Output); //retrieve the list of Validation Error messages modGlobal.gv_sql = "Select *, ValidateWhen = case when useraction is null then 'Updating Field' else useraction end "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_TableValidationMessage "; modGlobal.gv_sql = string.Format("{" + "0} Where BaseTableid = {1}", modGlobal.gv_sql, thisTableID); if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (state = '' or state is null) "; } else { modGlobal.gv_sql = string.Format("{" + "0} and state = '{1}'", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (RecordStatus = '' or RecordStatus is null) "; } else { modGlobal.gv_sql = string.Format("{" + "0} and RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } modGlobal.gv_sql = modGlobal.gv_sql + " order by MessageType, substring(Message, 1, 150)"; //LDW vrs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); vrs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName7, vrs); Cursor.Current = Cursors.WaitCursor; FileSystem.PrintLine(1, " Table Validation Messages "); FileSystem.PrintLine(1, "------------------------------"); FileSystem.PrintLine(1, "------------------------------"); FileSystem.PrintLine(1, " "); FileSystem.PrintLine(1, " "); //LDW while (!vrs.EOF) foreach (DataRow myRow1 in vrs.Tables[sqlTableName7].Rows) { msgcount = msgcount + 1; //LDW thismessageid = vrs.rdoColumns["TableValidationMessageID"].Value; thismessageid = myRow1.Field <int>("TableValidationMessageID"); FileSystem.PrintLine(1, msgcount + " ******************************************************************"); //LDW validatewhen = vrs.rdoColumns["messagetype"].Value + ": " + vrs.rdoColumns["validatewhen"].Value; validatewhen = string.Format("{0}: {1}", myRow1.Field <string>("messagetype"), myRow1.Field <string>("validatewhen")); FileSystem.PrintLine(1, validatewhen); FileSystem.PrintLine(1, ""); //LDW vmessage = vrs.rdoColumns["Message"].Value; vmessage = myRow1.Field <string>("Message"); FileSystem.PrintLine(1, vmessage); FileSystem.PrintLine(1, ""); PrintTableValCriteria(thismessageid); FileSystem.PrintLine(1, ""); //LDW vrs.MoveNext(); } FileSystem.FileClose(1); Cursor.Current = Cursors.Default; RadMessageBox.Show("Table validation was exported into " + valFile); } 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 cmdMoveUp_Click(object sender, EventArgs e) { int thisindex; int CurrOrderNum;; int ThisFieldID; try { if (lstGroups.SelectedIndex < 0) { return; } ThisFieldID = Support.GetItemData(lstGroups, lstGroups.SelectedIndex); modGlobal.gv_sql = "Select ordernumber "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_Submitgroup "; modGlobal.gv_sql = string.Format("{0} where groupID = {1}", modGlobal.gv_sql, ThisFieldID); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName4 = "tbl_setup_Submitgroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName4, modGlobal.gv_rs); CurrOrderNum = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName4].Rows[0]["OrderNumber"]); if ((CurrOrderNum - 1) > 0) { thisindex = lstGroups.SelectedIndex - 1; //update order number of the field prior to this one modGlobal.gv_sql = "Update tbl_setup_submitgroup "; modGlobal.gv_sql = string.Format("{0} set ordernumber = {1}", modGlobal.gv_sql, CurrOrderNum); modGlobal.gv_sql = modGlobal.gv_sql + " where "; modGlobal.gv_sql = string.Format("{0} ordernumber = {1}", modGlobal.gv_sql, CurrOrderNum - 1); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); //update order number of this field modGlobal.gv_sql = "Update tbl_setup_submitgroup "; modGlobal.gv_sql = string.Format("{0} set ordernumber = {1}", modGlobal.gv_sql, CurrOrderNum - 1); modGlobal.gv_sql = modGlobal.gv_sql + " where "; modGlobal.gv_sql = string.Format("{0} groupID = {1}", modGlobal.gv_sql, ThisFieldID); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshGroupList(); lstGroups.SelectedIndex = thisindex; } } 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 cmdMoveDown_Click(object sender, EventArgs e) { int thisindex; int CurrOrderNum; int ThisFieldID; try { if (lstRows.SelectedIndex < 0) { return; } ThisFieldID = Support.GetItemData(lstRows, lstRows.SelectedIndex); //retrieve the current order modGlobal.gv_sql = "Select ordernumber "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_submitgrouprow "; modGlobal.gv_sql = string.Format("{0} where grouprowid = {1}", modGlobal.gv_sql, Support.GetItemData(lstRows, lstRows.SelectedIndex)); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName4 = "tbl_setup_submitgrouprow"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName4, modGlobal.gv_rs); CurrOrderNum = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName4].Rows[0]["OrderNumber"]); if (CurrOrderNum != lstRows.Items.Count) { thisindex = lstRows.SelectedIndex + 1; modGlobal.gv_sql = "Select Groupid "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_submitgrouprow "; modGlobal.gv_sql = string.Format("{0} where grouprowid = {1}", modGlobal.gv_sql, ThisFieldID); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName5 = "tbl_setup_submitgrouprow"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName5, modGlobal.gv_rs); //update order number of the field prior to this one modGlobal.gv_sql = "Update tbl_setup_submitgrouprow "; modGlobal.gv_sql = string.Format("{0} set ordernumber = {1}", modGlobal.gv_sql, CurrOrderNum); modGlobal.gv_sql = modGlobal.gv_sql + " where "; modGlobal.gv_sql = modGlobal.gv_sql + " ordernumber = " + CurrOrderNum + 1; modGlobal.gv_sql = string.Format("{0} and groupID = {1}", modGlobal.gv_sql, modGlobal.gv_rs.Tables[sqlTableName5].Rows[0]["groupid"]); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); //update order number of this field modGlobal.gv_sql = "Update tbl_setup_submitgrouprow "; modGlobal.gv_sql = modGlobal.gv_sql + " set ordernumber = " + CurrOrderNum + 1; modGlobal.gv_sql = modGlobal.gv_sql + " where "; modGlobal.gv_sql = string.Format("{0} grouprowID = {1}", modGlobal.gv_sql, ThisFieldID); modGlobal.gv_sql = string.Format("{0} and groupID = {1}", modGlobal.gv_sql, modGlobal.gv_rs.Tables[sqlTableName5].Rows[0]["groupid"]); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshRowList(); lstRows.SelectedIndex = thisindex; //find the right field //For i = 1 To rdcFieldList.Resultset.RowCount // If rdcFieldList.Resultset!DDID = ThisFieldID Then // Exit For // End If // rdcFieldList.Resultset.MoveNext //Next i } } 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 RefreshGroupToUpdate() { try { modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_SubmitGroup "; if (lstGroups.SelectedIndex > -1) { modGlobal.gv_sql = string.Format("{0} where GroupID = {1}", modGlobal.gv_sql, Support.GetItemData(lstGroups, lstGroups.SelectedIndex)); } else { modGlobal.gv_sql = modGlobal.gv_sql + " where GroupID = -1 "; } //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName9 = "tbl_setup_SubmitGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName9, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName9].Rows.Count > 0) { txtGroupNameToUpdate.Text = modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["GroupName"].ToString(); chkDisplayGroupTitleToUpdate.CheckState = CheckState.Unchecked; chkIncludeGroupToUpdate.CheckState = CheckState.Unchecked; chkShowTotalToUpdate.CheckState = CheckState.Unchecked; if (!Information.IsDBNull(modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["ShowGroupHeader"])) { if (modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["ShowGroupHeader"].ToString() == "Y") { chkDisplayGroupTitleToUpdate.CheckState = CheckState.Checked; } } if (!Information.IsDBNull(modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["ShowOnReport"])) { if (modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["ShowOnReport"].ToString() == "Y") { chkIncludeGroupToUpdate.CheckState = CheckState.Checked; } } if (!Information.IsDBNull(modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["ShowTotal"])) { if (modGlobal.gv_rs.Tables[sqlTableName9].Rows[0]["ShowTotal"].ToString() == "Y") { chkShowTotalToUpdate.CheckState = CheckState.Checked; } } modGlobal.gv_rs.Dispose(); } else { txtGroupNameToUpdate.Text = ""; } } 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 cmdAddSubmissionGroup_Click(object sender, EventArgs e) { int NextRowID = modDBSetup.FindMaxRecID("tbl_Setup_SubmitGroupRow", "GroupRowID"); int NextOrderNumber; try { if (cboGroupList.SelectedIndex < 0) { RadMessageBox.Show("Please Select a Group From the List."); return; } if (string.IsNullOrEmpty(txtRowName.Text)) { RadMessageBox.Show("Please define the Row Name."); return; } modGlobal.gv_Action = "Add"; //check for duplicates modGlobal.gv_sql = "Select g.* "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_SubmitGroup as g left join tbl_Setup_SubmitGroupRow as r"; modGlobal.gv_sql = modGlobal.gv_sql + " on g.GroupID = r.GroupID "; modGlobal.gv_sql = string.Format("{0} Where g.GroupID = {1}", modGlobal.gv_sql, Support.GetItemData(cboGroupList, cboGroupList.SelectedIndex)); modGlobal.gv_sql = string.Format("{0} and r.Title = '{1}'", modGlobal.gv_sql, txtRowName.Text); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_setup_SubmitGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName1].Rows.Count > 0) { RadMessageBox.Show("This row for the selected group already exists."); return; } //find the next ordernumber modGlobal.gv_sql = " Select max(OrderNumber) as MaxOrdNum from tbl_Setup_SubmitGroupRow "; modGlobal.gv_sql = string.Format("{0} Where GroupID = {1}", modGlobal.gv_sql, Support.GetItemData(cboGroupList, cboGroupList.SelectedIndex)); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_Setup_SubmitGroupRow"; 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) { if (Information.IsDBNull(modGlobal.gv_rs.Tables[sqlTableName2].Rows[0]["maxordnum"])) { NextOrderNumber = 1; } else { NextOrderNumber = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName2].Rows[0]["maxordnum"]) + 1; } } else { NextOrderNumber = 1; } modGlobal.gv_rs.Dispose(); //add the group modGlobal.gv_sql = "Insert into tbl_Setup_SubmitGroupRow"; modGlobal.gv_sql = modGlobal.gv_sql + " (GroupRowID, GroupID, Title, ShowOnReport, OrderNumber) "; modGlobal.gv_sql = string.Format("{0} values ({1},", modGlobal.gv_sql, NextRowID); modGlobal.gv_sql = modGlobal.gv_sql + Support.GetItemData(cboGroupList, cboGroupList.SelectedIndex); modGlobal.gv_sql = string.Format("{0},'{1}',", modGlobal.gv_sql, txtRowName.Text); if (chkIncludeRow.CheckState == CheckState.Checked) { modGlobal.gv_sql = modGlobal.gv_sql + " 'Y',"; } else { modGlobal.gv_sql = modGlobal.gv_sql + " Null,"; } modGlobal.gv_sql = string.Format("{0}{1}) ", modGlobal.gv_sql, NextOrderNumber); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); txtRowName.Text = ""; RefreshRowList(); } 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 refreshIndicators() { var LIndex = 0; var Table_ListIndex = 0; try { //retrieve the list of indicators modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_Indicator "; modGlobal.gv_sql = modGlobal.gv_sql + " Where IndicatorID not in "; modGlobal.gv_sql = modGlobal.gv_sql + " (select IndicatorID from tbl_setup_DataReq "; if (cboPatientFields.SelectedIndex > -1) { modGlobal.gv_sql = string.Format("{0} where DDID = {1} )", modGlobal.gv_sql, Support.GetItemData(cboPatientFields, cboPatientFields.SelectedIndex)); } else { modGlobal.gv_sql = modGlobal.gv_sql + " where DDID = 0 ) "; } if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (State = '' or State is Null) "; } else { modGlobal.gv_sql = string.Format("{0} and (State = '' or State is null or State = '{1}')", modGlobal.gv_sql, modGlobal.gv_State); } modGlobal.gv_sql = string.Format("{0} and 1 = (SELECT CASE WHEN FieldCategory = 'Dynamic' THEN 1 ELSE 0 END FROM tbl_Setup_DataDef WHERE DDID = {1} )", modGlobal.gv_sql, Support.GetItemData(cboPatientFields, cboPatientFields.SelectedIndex)); 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 sqlTableName3 = "tbl_setup_Indicator"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); lstIndicators.Items.Clear(); Table_ListIndex = -1; LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { LIndex = LIndex + 1; Table_ListIndex = LIndex; lstIndicators.Items.Add(new ListBoxItem(myRow3.Field <string>("Description"), myRow3.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 frmSubmissionRowAdd_Load(object sender, EventArgs e) { var LIndex = 0; int FCount; DataSet thisrs = new DataSet(); this.CenterToParent(); try { modGlobal.gv_Action = "NotDefined"; sstabRow.ActiveWindow = sstabRow0; //re-order the rows modGlobal.gv_sql = "Select Groupid "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_submitgroup "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName9 = "tbl_setup_submitgroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName9, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow9 in modGlobal.gv_rs.Tables[sqlTableName9].Rows) { modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_submitgrouprow "; modGlobal.gv_sql = string.Format("{0} where groupid = {1}", modGlobal.gv_sql, myRow9.Field <int>("groupid")); modGlobal.gv_sql = modGlobal.gv_sql + " order by ordernumber "; //LDW thisrs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName10 = "tbl_setup_submitgrouprow"; thisrs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName10, thisrs); FCount = 0; //LDW while (!thisrs.EOF) foreach (DataRow myRow10 in thisrs.Tables[sqlTableName10].Rows) { //first we make sure every field in this list has a number FCount = FCount + 1; modGlobal.gv_sql = "Update tbl_setup_submitgrouprow "; modGlobal.gv_sql = modGlobal.gv_sql + " set OrderNumber = " + FCount; modGlobal.gv_sql = modGlobal.gv_sql + " where grouprowID = " + myRow10.Field <int>("grouprowID"); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); //LDW thisrs.MoveNext(); } //LDW modGlobal.gv_rs.MoveNext(); } RefreshRowList(); //Refresh the group list modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_SubmitGroup "; 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 = '{1}')", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (RecordStatus = '' or RecordStatus is null) "; } else { modGlobal.gv_sql = string.Format("{0} and RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } modGlobal.gv_sql = modGlobal.gv_sql + " order by GroupName"; //rdcFieldList.Refresh //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName11 = "tbl_setup_SubmitGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName11, modGlobal.gv_rs); cboGroupList.Items.Clear(); LIndex = -1; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow11 in modGlobal.gv_rs.Tables[sqlTableName11].Rows) { LIndex = LIndex + 1; cboGroupList.Items.Add(new ListBoxItem(myRow11.Field <string>("GroupName"), myRow11.Field <int>("groupid")).ToString()); cboGroupListToUpdate.Items.Add(myRow11.Field <string>("GroupName")); Support.SetItemData(cboGroupListToUpdate, cboGroupList.Items.Count - 1, myRow11.Field <int>("groupid")); //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 RefreshErrorList() { frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup(); try { //retrieve the list of Validation Error messages modGlobal.gv_sql = "Select *, ValidateWhen = case when useraction is null then 'Updating Field' else useraction end "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_TableValidationMessage "; modGlobal.gv_sql = modGlobal.gv_sql + " Where BaseTableid = " + Support.GetItemData(frmTableValidationSetupCopy.cboTableList, frmTableValidationSetupCopy.cboTableList.SelectedIndex); if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (state = '' or state is null) "; } else { modGlobal.gv_sql = modGlobal.gv_sql + " and state = '" + modGlobal.gv_State + "'"; } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (RecordStatus = '' or RecordStatus is null) "; } else { modGlobal.gv_sql = modGlobal.gv_sql + " and RecordStatus = '" + modGlobal.gv_status + "'"; } modGlobal.gv_sql = modGlobal.gv_sql + " and MessageType = 'ERROR' "; modGlobal.gv_sql = modGlobal.gv_sql + " order by substring(Message, 1, 150) "; // 3.17.2005 - order by message //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName3 = "tbl_setup_TableValidationMessage"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); cboError.Items.Clear(); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { cboError.Items.Add(new ListBoxItem((myRow3.Field <string>("Message")), myRow3.Field <int>("TableValidationMessageID")).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 RefreshRowList() { try { modGlobal.gv_sql = "Select g.*, "; modGlobal.gv_sql = modGlobal.gv_sql + " r.GroupRowID, r.Title as GroupRow "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_SubmitGroup as g inner join tbl_Setup_SubmitGroupRow as r"; modGlobal.gv_sql = modGlobal.gv_sql + " on g.GroupID = r.GroupID "; if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " Where (g.State = '' or g.State is null) "; } else { modGlobal.gv_sql = modGlobal.gv_sql + " Where (g.State = '" + modGlobal.gv_State + "')"; } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " and (g.RecordStatus = '' or g.RecordStatus is null) "; } else { modGlobal.gv_sql = modGlobal.gv_sql + " and g.RecordStatus = '" + modGlobal.gv_status + "'"; } modGlobal.gv_sql = modGlobal.gv_sql + " order by g.Ordernumber, g.GroupName, r.OrderNumber, r.Title "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName12 = "tbl_setup_SubmitGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName12, modGlobal.gv_rs); //Display the list of fields lstRows.Items.Clear(); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow12 in modGlobal.gv_rs.Tables[sqlTableName12].Rows) { lstRows.Items.Add(new ListBoxItem(myRow12.Field <string>("GroupName") + " / " + myRow12.Field <string>("GroupRow"), myRow12.Field <int>("grouprowID")).ToString()); //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); cboGroupListToUpdate.SelectedIndex = -1; cboGroupListToUpdate.Text = ""; txtRowNameToUpdate.Text = ""; chkIncludeRowToUpdate.CheckState = CheckState.Unchecked; } 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 cmdAddField_Click(Object eventSender, EventArgs eventArgs) { frmTableFieldAdd frmTableFieldAddCopy = new frmTableFieldAdd(); bool FoundIt; int NewDDID = 0; try { if (string.IsNullOrEmpty(cboTableList.Text)) { //LDW RadMessageBox.Show("Please select a table from the list"); RadMessageBox.Show(this, "Please select a table from the list", "Add Field", MessageBoxButtons.OK, RadMessageIcon.Info); return; } modGlobal.gv_Action = ""; frmTableFieldAddCopy.ShowDialog(); if (modGlobal.gv_Action == "Add") { RefreshFieldList(); modGlobal.gv_sql = "Select max(DDID) as NewDDID from tbl_setup_DataDef "; modGlobal.gv_sql = string.Format("{0} where BaseTableID = {1}", modGlobal.gv_sql, Support.GetItemData(cboTableList, cboTableList.SelectedIndex)); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_setup_DataDef"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); //LDW NewDDID = modGlobal.gv_rs.rdoColumns["NewDDID"].Value; NewDDID = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName2].Rows[0]["NewDDID"]); FoundIt = false; //LDW while ((!rdcFieldList.Resultset.EOF) & FoundIt == false) foreach (DataRow myRow2 in rdcFieldList.Tables[rdcFieldListTable].Rows) { while (FoundIt == false) { //LDW if (rdcFieldList.Resultset.rdoColumns["DDID"].Value == NewDDID) if (myRow2.Field <int>("DDID") == NewDDID) { FoundIt = 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)); } //rdcFieldList.Resultset.Bookmark = bk }
private void cmdAdd_Click(object sender, EventArgs e) { int newid = modDBSetup.FindMaxRecID("tbl_setup_Importsetup", "importsetupid"); try { if (string.IsNullOrEmpty(txtNewImportLayout.Text)) { RadMessageBox.Show("Please enter a description for the new layout."); return; } modGlobal.gv_sql = "select * from tbl_setup_ImportSetup "; modGlobal.gv_sql = string.Format("{0} where upper(description) = '{1}'", modGlobal.gv_sql, Strings.UCase(txtNewImportLayout.Text)); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_setup_ImportSetup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName1].Rows.Count > 0) { RadMessageBox.Show("There is a layout with the same description."); return; } modGlobal.gv_sql = "Insert into tbl_setup_ImportSetup (importsetupid, description, state, recordstatus)"; modGlobal.gv_sql = modGlobal.gv_sql + " values ("; modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, newid); modGlobal.gv_sql = string.Format("{0} '{1}',", modGlobal.gv_sql, txtNewImportLayout.Text); if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " Null, "; } else { modGlobal.gv_sql = string.Format("{0} '{1}',", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " null "; } else { modGlobal.gv_sql = string.Format("{0} '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } modGlobal.gv_sql = modGlobal.gv_sql + ")"; //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshImportLayout(); txtNewImportLayout.Text = ""; cmdSelect.Enabled = true; cmdDelete.Enabled = true; cmdUpdate.Enabled = 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 cmdMoveUp_Click(Object eventSender, EventArgs eventArgs) { var i = 0; int ThisFieldID = 0; int CurrOrderNum = 0; int FCount = 0; try { if (rdcFieldList.Tables[rdcFieldListTable].Rows.Count < 0) { return; } //retrieve the list of fields for the selected Section modGlobal.gv_sql = "Select ddid "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_setup_DataDef "; modGlobal.gv_sql = string.Format("{0} where basetableid = {1}", modGlobal.gv_sql, Support.GetItemData(cboTableList, cboTableList.SelectedIndex)); modGlobal.gv_sql = modGlobal.gv_sql + " order by sortorder "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName8 = "tbl_setup_DataDef"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName8, modGlobal.gv_rs); //first we make sure every field in this list has a number //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow4 in modGlobal.gv_rs.Tables[sqlTableName8].Rows) { FCount = FCount + 1; modGlobal.gv_sql = "Update tbl_setup_DataDef "; modGlobal.gv_sql = string.Format("{0} set SortOrder = {1}", modGlobal.gv_sql, FCount); modGlobal.gv_sql = string.Format("{0} where DDID = {1}", modGlobal.gv_sql, myRow4.Field <int>("DDID")); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); if (Convert.ToInt32(rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]) == myRow4.Field <int>("DDID")) { CurrOrderNum = FCount; } //LDW modGlobal.gv_rs.MoveNext(); } ThisFieldID = Convert.ToInt32(rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]); if (CurrOrderNum - 1 > 0) { //update order number of the field prior to this one modGlobal.gv_sql = "Update tbl_setup_Datadef "; modGlobal.gv_sql = string.Format("{0} set SortOrder = {1}", modGlobal.gv_sql, CurrOrderNum); modGlobal.gv_sql = string.Format("{0} where BaseTableID = {1}", modGlobal.gv_sql, Support.GetItemData(cboTableList, cboTableList.SelectedIndex)); modGlobal.gv_sql = string.Format("{0} and SortOrder = {1}", modGlobal.gv_sql, CurrOrderNum - 1); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); //update order number of this field modGlobal.gv_sql = "Update tbl_setup_datadef "; modGlobal.gv_sql = string.Format("{0} set sortOrder = {1}", modGlobal.gv_sql, CurrOrderNum - 1); modGlobal.gv_sql = string.Format("{0} where basetableid = {1}", modGlobal.gv_sql, Support.GetItemData(cboTableList, cboTableList.SelectedIndex)); modGlobal.gv_sql = string.Format("{0} and DDID = {1}", modGlobal.gv_sql, ThisFieldID); //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshFieldList(); //find the right field for (i = 1; i <= rdcFieldList.Tables[rdcFieldListTable].Rows.Count; i++) { if (Convert.ToInt32(rdcFieldList.Tables[rdcFieldListTable].Rows[0]["DDID"]) == ThisFieldID) { break; // TODO: might not be correct. Was : Exit For } //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 cmdCopy_Click(object sender, EventArgs e) { int li_CritCount = 0; int li_Cnt = 0; int li_MaxID = 0; int li_MinID = 0; try { if (cboSet.SelectedIndex > -1 & cboCopyTo.SelectedIndex > -1) { modGlobal.gv_sql = string.Format("select count(*) as CritCount, min(tableValidationID) as MinID FROM tbl_setup_tableValidation Where TableValidationMessageID = {0} AND CriteriaSet = {1}", ii_TableValidationMessageID, ii_TableSet); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_setup_tableValidation"; modGlobal.gv_rs = DALcop.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) { li_CritCount = myRow1.Field <int>("CritCount"); li_MinID = myRow1.Field <int>("MinID"); } modGlobal.gv_rs.Dispose(); modGlobal.gv_sql = "select max(TableValidationID) as MaxID FROM tbl_setup_tableValidation "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_setup_tableValidation"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); //LDW if (!modGlobal.gv_rs.EOF) foreach (DataRow myRow2 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { li_MaxID = myRow2.Field <int>("MaxID"); } modGlobal.gv_rs.Dispose(); for (li_Cnt = 1; li_Cnt <= li_CritCount; li_Cnt++) { modGlobal.gv_sql = " Insert Into tbl_Setup_TableValidation " + " SELECT " + li_MaxID + li_Cnt + " , " + Support.GetItemData (cboCopyTo, cboCopyTo.SelectedIndex) + " ,[ValidationType] " + " , " + cboSet.Text + " ,[CriteriaTitle] " + " ,[SourceDDID1] " + " ,[SourceDDID2] " + " ,[FieldOperator] " + " ,[DestDDID] " + " ,[LookupID] " + " ,[LookupTableID] " + " ,[ValueOperator] " + " ,[Value] " + " ,[DateUnit] " + " ,[JoinOperator] " + " From tbl_Setup_TableValidation " + " Where TableValidationMessageID = " + ii_TableValidationMessageID + " AND TableValidationID = " + li_MinID; //LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql); DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = string.Format("SELECT min(tableValidationID) as MinID FROM tbl_setup_tableValidation WHERE TableValidationMessageID = {0} AND TableValidationID > {1} AND CriteriaSet = {2}", ii_TableValidationMessageID, li_MinID, ii_TableSet); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName3 = "tbl_Setup_TableValidation"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); //LDW if (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { li_MinID = (Information.IsDBNull(myRow3.Field <int>("MinID")) ? 0 : myRow3.Field <int>("MinID")); } modGlobal.gv_rs.Dispose(); } //LDW RadMessageBox.Show("Save Success!"); DialogResult ds1 = RadMessageBox.Show(this, "Save Success!", "Copy", MessageBoxButtons.OK, RadMessageIcon.Exclamation); this.Text = ds1.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)); } }
private void cboGroup_SelectedIndexChanged(object sender, Telerik.WinControls.UI.Data.PositionChangedEventArgs e) { try { modGlobal.gv_sql = "SELECT msg.*, mcs.MeasureCriteriaSet " + " FROM tbl_Setup_MeasureStepGroup msg, tbl_Setup_MeasureCriteriaSet mcs " + " WHERE msg.MeasureCriteriaSetID = mcs.MeasureCriteriaSetID " + " AND msg.MeasureStepID = " + ii_MeasureStepID + " AND msg.MeasureStepGroup = " + Convert.ToInt32(cboGroup.Text); lstSelectedSetList.Items.Clear(); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName3 = "tbl_Setup_MeasureStepGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); //LDW if (modGlobal.gv_rs.EOF) for (int itr = 0; itr < modGlobal.gv_rs.Tables[sqlTableName3].Rows.Count; itr++) { var myRow3 = modGlobal.gv_rs.Tables[sqlTableName3].Rows[itr]; int rowIndex = modGlobal.gv_rs.Tables[sqlTableName3].Rows.IndexOf(myRow3); int rowLast = modGlobal.gv_rs.Tables[sqlTableName3].Rows.Count - 1; if (rowIndex == rowLast) { modGlobal.gv_rs.Dispose(); modGlobal.gv_sql = string.Format("SELECT JoinOperator FROM tbl_Setup_MeasureStepGroup WHERE MeasureStepID = {0}", ii_MeasureStepID); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName4 = "tbl_Setup_MeasureStepGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName4, modGlobal.gv_rs); //LDW if (!modGlobal.gv_rs.EOF) foreach (DataRow myRow4 in modGlobal.gv_rs.Tables[sqlTableName4].Rows) { cboJoinOperator.Text = myRow4.Field <string>("JoinOperator"); } } else { //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRowA3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { cboJoinOperator.Text = myRowA3.Field <string>("JoinOperator"); lstSelectedSetList.Items.Add(new ListBoxItem(myRowA3.Field <string>("MeasureCriteriaSet"), myRowA3.Field <int>("measurecriteriasetid")).ToString()); //LDW modGlobal.gv_rs.MoveNext(); } } } modGlobal.gv_rs.Dispose(); PopulateSetList(); RemoveSelected(); 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 cmdAddSubmissionGroup_Click(object sender, EventArgs e) { int NextGroupID = modDBSetup.FindMaxRecID("tbl_Setup_SubmitGroup", "GroupID"); int NextOrderNumber; try { if (string.IsNullOrEmpty(txtGroupName.Text)) { RadMessageBox.Show("Please define the Group Name."); return; } modGlobal.gv_Action = "Add"; //find the next ordernumber modGlobal.gv_sql = " Select max(OrderNumber) as MaxOrdNum from tbl_Setup_SubmitGroup "; //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_Setup_SubmitGroup"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs); if (modGlobal.gv_rs.Tables[sqlTableName1].Rows.Count > 0) { if (Information.IsDBNull(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["maxordnum"])) { NextOrderNumber = 1; } else { NextOrderNumber = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["maxordnum"]) + 1; } } else { NextOrderNumber = 1; } modGlobal.gv_rs.Dispose(); //add the group modGlobal.gv_sql = "Insert into tbl_Setup_SubmitGroup"; modGlobal.gv_sql = modGlobal.gv_sql + " (GroupID, GroupName, ShowGroupHeader, ShowOnReport, ShowTotal, OrderNumber, State, RecordStatus) "; modGlobal.gv_sql = string.Format("{0} values ({1},'{2}',", modGlobal.gv_sql, NextGroupID, txtGroupName.Text); if (chkDisplayGroupTitle.CheckState == CheckState.Checked) { modGlobal.gv_sql = modGlobal.gv_sql + " 'Y',"; } else { modGlobal.gv_sql = modGlobal.gv_sql + " Null,"; } if (chkIncludeGroup.CheckState == CheckState.Checked) { modGlobal.gv_sql = modGlobal.gv_sql + " 'Y',"; } else { modGlobal.gv_sql = modGlobal.gv_sql + " Null,"; } if (chkShowTotal.CheckState == CheckState.Checked) { modGlobal.gv_sql = modGlobal.gv_sql + " 'Y',"; } else { modGlobal.gv_sql = modGlobal.gv_sql + " Null,"; } modGlobal.gv_sql = string.Format("{0}{1},", modGlobal.gv_sql, NextOrderNumber); if (string.IsNullOrEmpty(modGlobal.gv_State)) { modGlobal.gv_sql = modGlobal.gv_sql + " null, "; } else { modGlobal.gv_sql = string.Format("{0} '{1}',", modGlobal.gv_sql, modGlobal.gv_State); } if (string.IsNullOrEmpty(modGlobal.gv_status)) { modGlobal.gv_sql = modGlobal.gv_sql + " null "; } else { modGlobal.gv_sql = string.Format("{0} '{1}'", modGlobal.gv_sql, modGlobal.gv_status); } modGlobal.gv_sql = modGlobal.gv_sql + ") "; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); RefreshGroupList(); txtGroupName.Text = ""; } 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 frmSubmissionUpdateValidation_Load(object sender, EventArgs e) { frmSubmissionSetup frmSubmissionSetupCopy = new frmSubmissionSetup(); int IndicatorListIndex = 0; var i = 0; this.CenterToParent(); try { //populate the indicator drop down box 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 = modGlobal.gv_sql + " Where (state = '' or State is null or state = '" + modGlobal.gv_status + "')"; } 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); i = -1; IndicatorListIndex = i; //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName1].Rows) { i = i + 1; cboIndicators.Items.Add(new ListBoxItem(myRow1.Field <string>("Description"), myRow1.Field <int>("IndicatorID")).ToString()); if (modGlobal.gv_Action == "ERROR") { if (myRow1.Field <int>("IndicatorID") == Convert.ToInt32(frmSubmissionSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["IndicatorID"])) { IndicatorListIndex = i; } } else if (modGlobal.gv_Action == "WARNING") { if (myRow1.Field <int>("IndicatorID") == Convert.ToInt32(frmSubmissionSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["IndicatorID"])) { IndicatorListIndex = i; } } //LDW modGlobal.gv_rs.MoveNext(); } cboIndicators.SelectedIndex = IndicatorListIndex; if (modGlobal.gv_Action == "ERROR") { txtMessage.Text = frmSubmissionSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["Message"].ToString(); } else { txtMessage.Text = frmSubmissionSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["Message"].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)); } }
private void OutputIndicatorRiskCoefficientTables(string Quarters) { string Method = null; string factortxt = null; string TriggerValue = null; string triggerID = null; string strtab = null; string DDID = null; string factorOperator = null; string TriggerBy2 = null; string TriggerBy = null; string coefficient = null; string Description = null; string FactorType = null; string FactorStatus = null; string FactorID = null; string EqType = null; string MeasureID = null; string Quarter = null; string coefID = null; try { FileSystem.PrintLine(FileNum, "[INDICATORRISKADJUSTMENTCOEFFICIENTS]"); modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_IndicatorRiskAdjustmentCoefficients "; modGlobal.gv_sql = string.Format("{0} WHERE Quarter in ({1}) ", modGlobal.gv_sql, Quarters); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName1 = "tbl_Setup_IndicatorRiskAdjustmentCoefficients"; 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) { coefID = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("coefID")) ? "" : myRow1.Field <string>("coefID"))); Quarter = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("Quarter")) ? "" : myRow1.Field <string>("Quarter"))); MeasureID = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("MeasureID")) ? "" : myRow1.Field <string>("MeasureID"))); EqType = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("EqType")) ? "" : myRow1.Field <string>("EqType"))); FactorID = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("FactorID")) ? "" : myRow1.Field <string>("FactorID"))); FactorStatus = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("FactorStatus")) ? "" : myRow1.Field <string>("FactorStatus"))); FactorType = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("FactorType")) ? "" : myRow1.Field <string>("FactorType"))); Description = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("Description")) ? "" : myRow1.Field <string>("Description"))); coefficient = Strings.Trim((Information.IsDBNull(myRow1.Field <string>("coefficient")) ? "" : myRow1.Field <string>("coefficient"))); if (!Information.IsDBNull(myRow1.Field <string>("TriggerBy"))) { TriggerBy = Strings.Trim(myRow1.Field <string>("TriggerBy")); } else { TriggerBy = ""; } if (!Information.IsDBNull(myRow1.Field <string>("TriggerBy2"))) { TriggerBy2 = Strings.Trim(myRow1.Field <string>("TriggerBy2")); } else { TriggerBy2 = ""; } if (!Information.IsDBNull(myRow1.Field <string>("factorOperator"))) { factorOperator = Strings.Trim(myRow1.Field <string>("factorOperator")); } else { factorOperator = ""; } FileSystem.PrintLine(FileNum, coefID + "," + Quarter + "," + MeasureID + "," + EqType + "," + FactorID + "," + FactorStatus + "," + FactorType + "," + Description + "," + coefficient + "," + TriggerBy + "," + TriggerBy2 + "," + factorOperator); //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); FileSystem.PrintLine(FileNum, "[INDICATORRISKADJUSTMENTCOEFFICIENTFIELDLINKS]"); modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_IndicatorRiskAdjustmentCoefficientFieldLinks WHERE CoefID IN " + " (SELECT CoefID FROM tbl_Setup_IndicatorRiskAdjustmentCoefficients "; // WHERE Quarter = '" & quarter & "')" modGlobal.gv_sql = string.Format("{0} WHERE Quarter in ({1}) )", modGlobal.gv_sql, Quarters); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName2 = "tbl_Setup_IndicatorRiskAdjustmentCoefficientFieldLinks"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow2 in modGlobal.gv_rs.Tables[sqlTableName2].Rows) { coefID = Strings.Trim((Information.IsDBNull(myRow2.Field <string>("coefID")) ? "" : myRow2.Field <string>("coefID"))); DDID = Strings.Trim((Information.IsDBNull(myRow2.Field <string>("DDID")) ? "" : myRow2.Field <string>("DDID"))); strtab = Strings.Trim((Information.IsDBNull(myRow2.Field <string>("Tab")) ? "" : myRow2.Field <string>("Tab"))); FileSystem.PrintLine(FileNum, string.Format("{0},{1},{2}", coefID, DDID, strtab)); //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); FileSystem.PrintLine(FileNum, "[INDICATORRISKADJUSTMENTCOEFFICIENTTRIGGERS]"); modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_IndicatorRiskAdjustmentCoefficientTriggers WHERE COefID in " + " (SELECT CoefID FROM tbl_Setup_IndicatorRiskAdjustmentCoefficients "; // WHERE Quarter = '" & quarter & "')" modGlobal.gv_sql = string.Format("{0} WHERE Quarter in ({1})) ", modGlobal.gv_sql, Quarters); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName3 = "tbl_Setup_IndicatorRiskAdjustmentCoefficientTriggers"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow3 in modGlobal.gv_rs.Tables[sqlTableName3].Rows) { triggerID = Strings.Trim((Information.IsDBNull(myRow3.Field <string>("triggerID")) ? "" : myRow3.Field <string>("triggerID"))); coefID = Strings.Trim((Information.IsDBNull(myRow3.Field <string>("coefID")) ? "" : myRow3.Field <string>("coefID"))); TriggerValue = Strings.Trim((Information.IsDBNull(myRow3.Field <string>("TriggerValue")) ? "" : myRow3.Field <string>("TriggerValue"))); strtab = Strings.Trim((Information.IsDBNull(myRow3.Field <string>("Tab")) ? "" : myRow3.Field <string>("Tab"))); FileSystem.PrintLine(FileNum, string.Format("{0},{1},{2},{3}", triggerID, coefID, TriggerValue, strtab)); //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); FileSystem.PrintLine(FileNum, "[INDICATORRISKADJUSTMENTCOEFFICIENTFACTORLINKS]"); modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_IndicatorRiskAdjustmentCoefficientFactorLinks WHERE COefID in " + " (SELECT CoefID FROM tbl_Setup_IndicatorRiskAdjustmentCoefficients "; // WHERE Quarter = '" & quarter & "')" modGlobal.gv_sql = string.Format("{0} WHERE Quarter in ({1} )) ", modGlobal.gv_sql, Quarters); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName4 = "tbl_Setup_IndicatorRiskAdjustmentCoefficientFactorLinks"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName4, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow4 in modGlobal.gv_rs.Tables[sqlTableName4].Rows) { coefID = Strings.Trim((Information.IsDBNull(myRow4.Field <string>("coefID")) ? "" : myRow4.Field <string>("coefID"))); FactorID = Strings.Trim((Information.IsDBNull(myRow4.Field <string>("FactorID")) ? "" : myRow4.Field <string>("FactorID"))); factortxt = Strings.Trim((Information.IsDBNull(myRow4.Field <string>("factortxt")) ? "" : myRow4.Field <string>("factortxt"))); FileSystem.PrintLine(FileNum, string.Format("{0},{1},{2}", coefID, FactorID, factortxt)); //LDW modGlobal.gv_rs.MoveNext(); } modGlobal.gv_rs.Dispose(); FileSystem.PrintLine(FileNum, "[INDICATORRISKADJUSTMENTCOEFFICIENTSMISSING]"); modGlobal.gv_sql = "Select * "; modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_IndicatorRiskAdjustmentCoefficientsMissing "; modGlobal.gv_sql = string.Format("{0} WHERE Quarter in ({1}) ", modGlobal.gv_sql, Quarters); //LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic); const string sqlTableName5 = "tbl_Setup_IndicatorRiskAdjustmentCoefficientsMissing"; modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName5, modGlobal.gv_rs); //LDW while (!modGlobal.gv_rs.EOF) foreach (DataRow myRow5 in modGlobal.gv_rs.Tables[sqlTableName5].Rows) { FactorID = Strings.Trim((Information.IsDBNull(myRow5.Field <string>("FactorID")) ? "" : myRow5.Field <string>("FactorID"))); Method = Strings.Trim((Information.IsDBNull(myRow5.Field <string>("Method")) ? "" : myRow5.Field <string>("Method"))); Quarter = Strings.Trim((Information.IsDBNull(myRow5.Field <string>("Quarter")) ? "" : myRow5.Field <string>("Quarter"))); FileSystem.PrintLine(FileNum, string.Format("{0},{1},{2}", FactorID, Method, Quarter)); //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)); } }