private void frmTableEditLookup_Load(object sender, EventArgs e) { frmLookupSetup frmLookupSetupCopy = new frmLookupSetup(); this.CenterToParent(); try { if (frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows.Count > 0) { if (!Information.IsDBNull(frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["Id"])) { txtID.Text = frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["Id"].ToString(); } if (!Information.IsDBNull(frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["FIELDVALUE"])) { txtLookupValue.Text = frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["FIELDVALUE"].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 cmdEdit_Click(object sender, EventArgs e) { frmLookupSetup frmLookupSetupCopy = new frmLookupSetup(); string gv_Command = null; try { if (string.IsNullOrEmpty(txtID.Text) | Information.IsDBNull(txtID.Text)) { RadMessageBox.Show("ID cannot be blank"); return; } gv_Command = "Update tbl_Setup_miscLookupList set "; gv_Command = gv_Command + " ID = '" + txtID.Text + "',"; gv_Command = gv_Command + " FieldValue = '" + txtLookupValue.Text + "'"; gv_Command = gv_Command + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, gv_Command); modGlobal.gv_sql = " update tbl_setup_savedadhocreportcriteria "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " update tbl_setup_submitcleanuprecord "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " update tbl_setup_submitcriteria "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["LookupID"]; DALcop.ExecuteCommand(modGlobal.gv_cn.ConnectionString, modGlobal.gv_sql); modGlobal.gv_sql = " update tbl_setup_tablevalidation "; modGlobal.gv_sql = modGlobal.gv_sql + " set [value] = '" + txtID.Text + "'"; modGlobal.gv_sql = modGlobal.gv_sql + " Where lookupid = " + frmLookupSetupCopy.rdcLookupList.Tables[rdcLookupListTable].Rows[0]["LookupID"]; 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)); } }