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));
}
}
