private void frmValidationCopyCriteria_Load(object sender, EventArgs e)
{
frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup();
this.CenterToParent();
try
{
SetTableValidationMessageID();
//If frmTableValidationSetupCopy.rdcValidationErrors.Resultset!MessageType = "ERROR" Then
RefreshErrorList();
//Else
RefreshWarningList();
lblCopyFrom.Text = frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].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));
}
}
public void RefreshFieldList()
{
frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup();
var LIndex = 0;
int Field_ListIndex = -1;
try
{
modGlobal.gv_sql = "Select * from tbl_setup_DataDef ";
modGlobal.gv_sql = string.Format("{0} where BaseTableID = {1}", modGlobal.gv_sql, Support.GetItemData(frmTableValidationSetupCopy.cboTableList,
frmTableValidationSetupCopy.cboTableList.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_status);
}
modGlobal.gv_sql = modGlobal.gv_sql + " order by FieldName ";
//retrieve the list of dynamic fields
//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);
cboFieldList.Items.Clear();
LIndex = -1;
//LDW while (!modGlobal.gv_rs.EOF)
foreach (DataRow myRow1 in modGlobal.gv_rs.Tables[sqlTableName2].Rows)
{
LIndex = LIndex + 1;
Field_ListIndex = LIndex;
//LDW cboFieldList.Items.Add(new ListBoxItem(modGlobal.gv_rs.rdoColumns["FieldName"].Value, modGlobal.gv_rs.rdoColumns["DDID"].Value));
cboFieldList.Items.Add(string.Format("{0} {1}", myRow1.Field <string>("FieldName"), myRow1.Field <string>("DDID")));
//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 SetTableValidationMessageID()
{
frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup();
try
{
int ii_TableValidationMessageID = Convert.ToInt32(frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["TableValidationMessageID"]);
}
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)
{
frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup();
var i = 0;
int newmsgid = 0;
try
{
int NewValID = modDBSetup.FindMaxRecID("tbl_Setup_TableValidationMessage", "TableValidationMessageID");
if (string.IsNullOrEmpty(txtMessage.Text))
{
RadMessageBox.Show("Please define a validation message.");
return;
}
if (opt1Save.IsChecked == false & opt2Delete.IsChecked == false & lstFieldstoValidate.Items.Count == 0)
{
//LDW RadMessageBox.Show("Please define when this validation should occur.");
DialogResult ds1 = RadMessageBox.Show(this, "Please define when this validation should occur.", "Add Message Error", MessageBoxButtons.OK, RadMessageIcon.Error);
this.Text = ds1.ToString();
return;
}
modGlobal.gv_sql = "Insert into tbl_Setup_TableValidationMessage(TableValidationMessageID, BaseTableid, Message, MessageType, UserAction, State, RecordStatus)";
modGlobal.gv_sql = string.Format("{0} values ( {1}, ", modGlobal.gv_sql, NewValID);
modGlobal.gv_sql = string.Format("{0}{1},", modGlobal.gv_sql, Support.GetItemData(frmTableValidationSetupCopy.cboTableList, frmTableValidationSetupCopy.cboTableList.SelectedIndex));
string refTxtMessage = txtMessage.Text;
modGlobal.gv_sql = string.Format("{0} '{1}',", modGlobal.gv_sql, modGlobal.ConvertApastroph(refTxtMessage));
modGlobal.gv_sql = string.Format("{0} '{1}',", modGlobal.gv_sql, modGlobal.gv_Action);
if (opt1Save.IsChecked == true)
{
modGlobal.gv_sql = modGlobal.gv_sql + " 'Saving Record', ";
}
else if (opt2Delete.IsChecked == true)
{
modGlobal.gv_sql = modGlobal.gv_sql + " 'Deleting Record', ";
}
else
{
modGlobal.gv_sql = modGlobal.gv_sql + " Null, ";
}
if (!string.IsNullOrEmpty(modGlobal.gv_State))
{
modGlobal.gv_sql = string.Format("{0} '{1}', ", modGlobal.gv_sql, modGlobal.gv_State);
}
else
{
modGlobal.gv_sql = modGlobal.gv_sql + " Null, ";
}
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);
if (lstFieldstoValidate.Items.Count > 0)
{
modGlobal.gv_sql = "Select max(tablevalidationmessageid) as newid ";
modGlobal.gv_sql = modGlobal.gv_sql + " from tbl_Setup_tablevalidationmessage ";
//LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic);
const string sqlTableName1 = "tbl_Setup_tablevalidationmessage";
modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs);
newmsgid = Convert.ToInt32(modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["newid"]);
for (i = 1; i <= lstFieldstoValidate.Items.Count; i++)
{
NewValID = modDBSetup.FindMaxRecID("tbl_setup_tablevalidationAfterFieldUpdate", "tablevalidationAfterFieldUpdateID");
modGlobal.gv_sql = "insert into tbl_setup_tablevalidationAfterFieldUpdate ";
modGlobal.gv_sql = modGlobal.gv_sql + " (tablevalidationAfterFieldUpdateID, tablevalidationmessageid, ddid)";
modGlobal.gv_sql = string.Format("{0} values ({1}, {2}, {3})", modGlobal.gv_sql, NewValID, newmsgid,
Support.GetItemData(lstFieldstoValidate, i - 1));
//LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql);
DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql);
}
}
modGlobal.gv_Action = "Add";
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 cmdUpdate_Click(object sender, EventArgs e)
{
frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup();
int NewValID = 0;
var i = 0;
int msgid = 0;
try
{
if (string.IsNullOrEmpty(txtMessage.Text))
{
//LDW RadMessageBox.Show("Please define a validation message.");
DialogResult ds1 = RadMessageBox.Show(this, "Please define a validation message.", "Update", MessageBoxButtons.OK, RadMessageIcon.Error);
this.Text = ds1.ToString();
return;
}
if (opt1Save.IsChecked == false & opt2Delete.IsChecked == false & lstFieldstoValidate.Items.Count == 0)
{
//LDW RadMessageBox.Show("Please define when this validation should occur.");
DialogResult ds2 = RadMessageBox.Show(this, "Please define when this validation should occur.", "Update", MessageBoxButtons.OK, RadMessageIcon.Error);
this.Text = ds2.ToString();
return;
}
string refTxtMessage = txtMessage.Text;
modGlobal.gv_sql = "Update tbl_setup_TableValidationMessage ";
modGlobal.gv_sql = modGlobal.gv_sql + " set ";
modGlobal.gv_sql = string.Format("{0} Message = '{1}',", modGlobal.gv_sql, modGlobal.ConvertApastroph(refTxtMessage));
modGlobal.gv_sql = modGlobal.gv_sql + " UserAction = ";
if (opt1Save.IsChecked == true)
{
modGlobal.gv_sql = modGlobal.gv_sql + " 'Saving Record' ";
}
else if (opt2Delete.IsChecked)
{
modGlobal.gv_sql = modGlobal.gv_sql + " 'Deleting Record' ";
}
else
{
modGlobal.gv_sql = modGlobal.gv_sql + " null ";
}
if (Strings.UCase(modGlobal.gv_Action) == "ERROR")
{
modGlobal.gv_sql = string.Format("{0} Where TableValidationMessageID = {1}", modGlobal.gv_sql,
frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["TableValidationMessageID"]);
}
else
{
modGlobal.gv_sql = string.Format("{0} Where TableValidationMessageID = {1}", modGlobal.gv_sql,
frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["TableValidationMessageID"]);
}
//LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql);
DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql);
modGlobal.gv_sql = "Delete tbl_setup_TableValidationAfterFieldUpdate ";
if (Strings.UCase(modGlobal.gv_Action) == "ERROR")
{
modGlobal.gv_sql = string.Format("{0} Where TableValidationMessageID = {1}", modGlobal.gv_sql,
frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["TableValidationMessageID"]);
}
else
{
modGlobal.gv_sql = string.Format("{0} Where TableValidationMessageID = {1}", modGlobal.gv_sql,
frmTableValidationSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["TableValidationMessageID"]);
}
DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql);
if (opt3UpdateField.IsChecked)
{
if (lstFieldstoValidate.Items.Count > 0)
{
if (Strings.UCase(modGlobal.gv_Action) == "ERROR")
{
msgid = Convert.ToInt32(frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["TableValidationMessageID"]);
}
else
{
msgid = Convert.ToInt32(frmTableValidationSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["TableValidationMessageID"]);
}
for (i = 1; i <= lstFieldstoValidate.Items.Count; i++)
{
NewValID = modDBSetup.FindMaxRecID("tbl_setup_tablevalidationAfterFieldUpdate", "tablevalidationAfterFieldUpdateID");
modGlobal.gv_sql = "insert into tbl_setup_tablevalidationAfterFieldUpdate ";
modGlobal.gv_sql = modGlobal.gv_sql + " (tablevalidationAfterFieldUpdateID, tablevalidationmessageid, ddid)";
modGlobal.gv_sql = string.Format("{0} values ({1}, {2}, {3})", modGlobal.gv_sql, NewValID, msgid, Support.GetItemData(lstFieldstoValidate, i - 1));
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));
}
}
private void frmTableValidationUpdateMsg_Load(object sender, EventArgs e)
{
frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup();
this.CenterToParent();
try
{
RefreshFieldList();
cboFieldList.Enabled = false;
lstFieldstoValidate.Enabled = false;
if (Strings.UCase(modGlobal.gv_Action) == "ERROR")
{
txtMessage.Text = frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["Message"].ToString();
if (frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["UserAction"].ToString() == "Saving Record")
{
opt1Save.IsChecked = true;
}
else if (frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["UserAction"].ToString() == "Deleting Record")
{
opt2Delete.IsChecked = true;
}
else
{
opt3UpdateField.IsChecked = true;
cboFieldList.Enabled = true;
lstFieldstoValidate.Enabled = true;
modGlobal.gv_sql = "Select tv.*, dd.fieldname from ";
modGlobal.gv_sql = modGlobal.gv_sql + " tbl_setup_TableValidationAfterFieldUpdate as tv ";
modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_setup_DataDef as dd ";
modGlobal.gv_sql = modGlobal.gv_sql + " on tv.ddid = dd.ddid ";
modGlobal.gv_sql = string.Format("{0} where tv.TableValidationMessageID = {1}", modGlobal.gv_sql,
frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["TableValidationMessageID"]);
//LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic);
const string sqlTableName2 = "tbl_setup_TableValidationAfterFieldUpdate";
modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName2, modGlobal.gv_rs);
RefreshSelectedFields(sqlTableName2);
}
}
else
{
txtMessage.Text = frmTableValidationSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["Message"].ToString();
if (frmTableValidationSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["UserAction"].ToString() == "Saving Record")
{
opt1Save.IsChecked = true;
}
else if (frmTableValidationSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["UserAction"].ToString() == "Deleting Record")
{
opt2Delete.IsChecked = true;
}
else
{
opt3UpdateField.IsChecked = true;
cboFieldList.Enabled = true;
lstFieldstoValidate.Enabled = true;
modGlobal.gv_sql = "Select tv.*, dd.fieldname from ";
modGlobal.gv_sql = modGlobal.gv_sql + " tbl_setup_TableValidationAfterFieldUpdate as tv ";
modGlobal.gv_sql = modGlobal.gv_sql + " inner join tbl_setup_DataDef as dd ";
modGlobal.gv_sql = modGlobal.gv_sql + " on tv.ddid = dd.ddid ";
modGlobal.gv_sql = string.Format("{0} where tv.TableValidationMessageID = {1}", modGlobal.gv_sql,
frmTableValidationSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["TableValidationMessageID"]);
//LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic);
const string sqlTableName3 = "tbl_setup_TableValidationAfterFieldUpdate";
modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName3, modGlobal.gv_rs);
RefreshSelectedFields(sqlTableName3);
}
}
}
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));
}
}
private void cmdAdd_Click(object sender, EventArgs e)
{
frmTableValidationSetup frmTableValidationSetupCopy = new frmTableValidationSetup();
string DestFieldType = null;
try
{
int NewCritID = modDBSetup.FindMaxRecID("tbl_Setup_TableValidationAction", "TableValidationActionID");
if (lstFieldList.SelectedIndex < 0)
{
//LDW RadMessageBox.Show("Select a field from the list.");
DialogResult ds1 = RadMessageBox.Show(this, "Select a field from the list.", "Add", MessageBoxButtons.OK, RadMessageIcon.Error);
this.Text = ds1.ToString();
return;
}
if (optBlank.IsChecked == false & optZero.IsChecked == false)
{
//LDW RadMessageBox.Show("Select either Blank or Zero from the options.");
DialogResult ds2 = RadMessageBox.Show(this, "Select either Blank or Zero from the options.", "Add", MessageBoxButtons.OK, RadMessageIcon.Error);
this.Text = ds2.ToString();
return;
}
modGlobal.gv_sql = "Select FieldType from tbl_setup_Datadef ";
modGlobal.gv_sql = string.Format("{0} where DDID = {1}", modGlobal.gv_sql, Support.GetItemData(lstFieldList, lstFieldList.SelectedIndex));
//LDW modGlobal.gv_rs = modGlobal.gv_cn.OpenResultset(modGlobal.gv_sql, RDO.ResultsetTypeConstants.rdOpenStatic);
const string sqlTableName1 = "tbl_setup_Datadef";
modGlobal.gv_rs = DALcop.DalConnectDataSet(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql, sqlTableName1, modGlobal.gv_rs);
DestFieldType = modGlobal.gv_rs.Tables[sqlTableName1].Rows[0]["FieldType"].ToString();
modGlobal.gv_rs.Dispose();
if (Strings.UCase(Strings.Mid(DestFieldType, 1, 3)) != "NUM" & optZero.IsChecked == true)
{
//LDW RadMessageBox.Show("This field cannot be set to zero, because it is not a numeric field.");
DialogResult ds3 = RadMessageBox.Show(this, "This field cannot be set to zero, because it is not a numeric field.", "Add", MessageBoxButtons.OK, RadMessageIcon.Error);
this.Text = ds3.ToString();
return;
}
modGlobal.gv_sql = "Insert into tbl_Setup_TableValidationAction ";
modGlobal.gv_sql = modGlobal.gv_sql + " (TableValidationActionID, TableValidationMessageID, ddid, setvalue) ";
modGlobal.gv_sql = modGlobal.gv_sql + " Values (";
modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, NewCritID);
if (modGlobal.gv_Action == "ERROR")
{
modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, frmTableValidationSetupCopy.rdcValidationErrors.Tables[rdcValidationErrorsTable].Rows[0]["TableValidationMessageID"]);
}
else
{
modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, frmTableValidationSetupCopy.rdcValidationWarnings.Tables[rdcValidationWarningsTable].Rows[0]["TableValidationMessageID"]);
}
modGlobal.gv_sql = string.Format("{0}{1}, ", modGlobal.gv_sql, Support.GetItemData(lstFieldList, lstFieldList.SelectedIndex));
if (optZero.IsChecked == true)
{
modGlobal.gv_sql = modGlobal.gv_sql + " '0'";
}
else
{
modGlobal.gv_sql = modGlobal.gv_sql + " 'Null'";
}
modGlobal.gv_sql = modGlobal.gv_sql + ")";
//LDW modGlobal.gv_cn.Execute(modGlobal.gv_sql);
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));
}
}
