private void cmdSelect_Click(object sender, EventArgs e)
{
frmImportSetup frmImportSetupCopy = new frmImportSetup();
try
{
if (rdcImportLayout.Tables[rdcImportLayoutTable].Rows.Count == 0)
{
return;
}
modGlobal.gv_importsetupid = rdcImportLayout.Tables[rdcImportLayoutTable].Rows[0]["ImportSetupID"].ToString();
frmImportSetupCopy.Show();
}
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));
}
this.Close();
}
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));
}
}
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));
}
}
