private void frmSubmissionCopyCriteria_Load(object sender, EventArgs e)
{
frmSubmissionSetup frmSubmissionSetupCopy = new frmSubmissionSetup();
this.CenterToParent();
try
{
RefreshColumnList();
RefreshSetList();
modGlobal.gv_sql = "Select CriteriaTitle from tbl_setup_SubmitCriteria ";
modGlobal.gv_sql = string.Format("{0} where submitcriteriaid = {1}", modGlobal.gv_sql,
Support.GetItemData(frmSubmissionSetupCopy.lstSummaryDef, frmSubmissionSetupCopy.lstSummaryDef.SelectedIndex));
//LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic);
const string sqlTableName1 = "tbl_setup_SubmitCriteria";
modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs);
lblCopyFrom.Text = modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["CriteriaTitle"].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 cmdUpdate_Click(object sender, EventArgs e)
{
frmSubmissionSetup frmSubmissionSetupCopy = new frmSubmissionSetup();
try
{
if (cboIndicators.SelectedIndex < 0)
{
RadMessageBox.Show("Please select an indicator.");
return;
}
if (string.IsNullOrEmpty(txtMessage.Text))
{
RadMessageBox.Show("Please define a validation message for the report.");
return;
}
modGlobal.gv_sql = "Update tbl_setup_SubmitValidation ";
modGlobal.gv_sql = modGlobal.gv_sql + " set IndicatorID = " + Support.GetItemData(cboIndicators, cboIndicators.SelectedIndex) + ",";
modGlobal.gv_sql = modGlobal.gv_sql + " Message = '" + modGlobal.ConvertApastroph(txtMessage.Text) + "',";
modGlobal.gv_sql = modGlobal.gv_sql + " ValType = '" + modGlobal.gv_Action + "' ";
if (modGlobal.gv_Action == "ERROR")
{
modGlobal.gv_sql = modGlobal.gv_sql + " Where SubmitValID = " + frmSubmissionSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["SubmitValID"];
}
else
{
modGlobal.gv_sql = modGlobal.gv_sql + " Where SubmitValID = " + frmSubmissionSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["SubmitValID"];
}
DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql);
modGlobal.gv_Action = "Update";
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 RefreshSetDef()
{
frmSubmissionSetup frmSubmissionSetupCopy = new frmSubmissionSetup();
try
{
modGlobal.gv_sql = "Select JoinOperator from tbl_setup_SubmitCriteria ";
modGlobal.gv_sql = string.Format("{0} where SubGroupID = {1}", modGlobal.gv_sql, frmSubmissionSetupCopy.rdcSubmissionFieldList.Tables[rdcSubmissionFieldListTable].Rows[0]["subgroupid"]);
modGlobal.gv_sql = string.Format("{0} and CriteriaSet = {1}", modGlobal.gv_sql, Support.GetItemData(cboSet, cboSet.SelectedIndex));
//LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic);
const string sqlTableName2 = "tbl_setup_SubmitCriteria";
modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs);
if (modGlobal.gv_rs.Tables[sqlTableName2].Rows.Count == 0)
{
cboJoinOperator.Text = "";
cboJoinOperator.Enabled = true;
}
else
{
cboJoinOperator.Text = modGlobal.gv_rs.Tables[sqlTableName2].Rows[0]["JoinOperator"].ToString();
cboJoinOperator.Enabled = false;
}
modGlobal.gv_rs.Dispose();
}
catch (Exception ex)
{
const string errorMessage = "Oops...Something went wrong... ";
// Create an EventLog instance and assign its source.
EventLog appLog = new EventLog();
appLog.Source = "CopSetup";
appLog.WriteEntry(errorMessage + "Source: " + ex.Source + "=>" + "TargetSite: " + ex.TargetSite + "Exception #: " + ex.HResult + " => " + "Error Message: " +
ex.Message + " => " + "Inner Exception: " + ex.InnerException + " => " + "Stack Trace: " + ex.StackTrace, EventLogEntryType.Error, 1002);
RadMessageBox.Show(errorMessage + String.Format(format: "Exception: {0} => Inner Exception: {1}", arg0: ex.Message, arg1: ex.InnerException));
}
}
private void cmdCopy_Click(object sender, EventArgs e)
{
frmSubmissionSetup frmSubmissionSetupCopy = new frmSubmissionSetup();
int NewCritID;
try
{
if (cboSet.SelectedIndex < 0 | cboColumns.SelectedIndex < 0 | (cboJoinOperator.SelectedIndex < 0 & string.IsNullOrEmpty(cboJoinOperator.Text)))
{
RadMessageBox.Show("Define the definition of the new criteria.");
}
else
{
//copy the criteria
modGlobal.gv_Action = "Add";
NewCritID = modDBSetup.FindMaxRecID("tbl_Setup_SubmitCriteria", "SubmitCriteriaID");
modGlobal.gv_sql = " insert into tbl_Setup_SubmitCriteria (";
modGlobal.gv_sql = modGlobal.gv_sql + " SubmitCriteriaID, ";
modGlobal.gv_sql = modGlobal.gv_sql + " SubGroupID, ";
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 + " [Value], ";
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, ";
modGlobal.gv_sql = modGlobal.gv_sql + " Criteriaset ";
modGlobal.gv_sql = modGlobal.gv_sql + " ) ";
modGlobal.gv_sql = modGlobal.gv_sql + " select ";
modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, NewCritID);
modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, Support.GetItemData(cboColumns, cboColumns.SelectedIndex));
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 + " [Value], ";
modGlobal.gv_sql = modGlobal.gv_sql + " LookupID, ";
modGlobal.gv_sql = modGlobal.gv_sql + " LookupTableID, ";
modGlobal.gv_sql = modGlobal.gv_sql + " DateUnit, ";
modGlobal.gv_sql = string.Format("{0} '{1}', ", modGlobal.gv_sql, cboJoinOperator.Text);
modGlobal.gv_sql = modGlobal.gv_sql + Support.GetItemData(cboSet, cboSet.SelectedIndex);
modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_SubmitCriteria ";
modGlobal.gv_sql = string.Format("{0} where SubmitCriteriaID = {1}", modGlobal.gv_sql,
Support.GetItemData(frmSubmissionSetupCopy.lstSummaryDef, frmSubmissionSetupCopy.lstSummaryDef.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));
}
}
public void RefreshColumnList()
{
frmSubmissionSetup frmSubmissionSetupCopy = new frmSubmissionSetup();
int thisSubGroup = 0;
var i = 0;
try
{
modGlobal.gv_sql = "Select g.*, ";
modGlobal.gv_sql = modGlobal.gv_sql + " r.GroupRowID, r.Title as GroupRow, r.ShowOnReport as ShowRowonReport, ";
modGlobal.gv_sql = modGlobal.gv_sql + " c.SubGroupID, c.Title as GroupCol, c.IndicatorID, ";
modGlobal.gv_sql = modGlobal.gv_sql + " c.AggregateFunction, c.showonreport as showcolonreport ";
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) ";
modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_Setup_SubmitSubGroup as c ";
modGlobal.gv_sql = modGlobal.gv_sql + " on r.GroupRowID = c.GroupRowID ";
if (string.IsNullOrEmpty(modGlobal.gv_State))
{
modGlobal.gv_sql = modGlobal.gv_sql + " Where (g.State = '' or g.State is null) ";
}
else
{
modGlobal.gv_sql = string.Format("{0} Where g.state = '{1}'", modGlobal.gv_sql, 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 = string.Format("{0} and g.RecordStatus = '{1}'", modGlobal.gv_sql, modGlobal.gv_status);
}
modGlobal.gv_sql = modGlobal.gv_sql + " order by g.ordernumber, r.ordernumber, c.ordernumber ";
//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);
//Display the list of fields
i = -1;
cboColumns.Items.Clear();
//LDW while (!modGlobal.gv_rs.EOF)
foreach (DataRow myRow4 in modGlobal.gv_rs.Tables[sqlTableName4].Rows)
{
i = i + 1;
cboColumns.Items.Add(new ListBoxItem(myRow4.Field <string>("GroupName") + " / " + myRow4.Field <int>("GroupRow")
+ " / " + myRow4.Field <string>("GroupCol"), myRow4.Field <int>("subgroupid")).ToString());
if (myRow4.Field <int>("subgroupid") == Convert.ToInt32(frmSubmissionSetupCopy.rdcSubmissionFieldList.Tables[rdcSubmissionFieldListTable].Rows[0]["subgroupid"]))
{
thisSubGroup = i;
}
//LDW modGlobal.gv_rs.MoveNext();
}
modGlobal.gv_rs.Dispose();
cboColumns.SelectedIndex = thisSubGroup;
}
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));
}
}
