private void btn_ok_Click(object sender, EventArgs e) { try { this.Cursor = Cursors.WaitCursor; if (_presenter.CurrentViewStatus.Equals(ViewStatus.Add)) { if (!this.ValidateChildren()) { return; } LoggingFilterDS ds = new LoggingFilterDS(); LoggingFilterDS.T_IC_LOGGING_FILTERRow newRow = ds.T_IC_LOGGING_FILTER .NewT_IC_LOGGING_FILTERRow(); if (ultraOptionSet.Value.Equals(FilterCategory.Instrumentation.ToString())) { newRow.CATEGORY = FilterCategory.Instrumentation.ToString(); } else if(ultraOptionSet.Value.Equals(FilterCategory.Monitoring.ToString())) { newRow.CATEGORY = FilterCategory.Monitoring.ToString(); } newRow.USER_ID = ultraComboEditorUserName.Value.ToString(); newRow.FLAG = 1; HiiP.Framework.Common.Client.Utility.UpdateIConnectCommonFields(newRow); ds.T_IC_LOGGING_FILTER.AddT_IC_LOGGING_FILTERRow(newRow); _presenter.UpdateLoggingFilter(ds); } this.SetDirtyStatus(false); _presenter.OnCloseView(); } catch (Exception ex) { if (ExceptionManager.Handle(ex)) throw; } finally { this.Cursor = Cursors.Default; } }
public void UpdateLoggingFilter(LoggingFilterDS ds) { DbCommand insertCommand = null; DbCommand updateCommand = null; DbCommand deleteCommand = null; string databaseName = ((DatabaseSettings)ConfigurationManager. GetSection("dataConfiguration")).DefaultDatabase; Database db = DatabaseFactory.CreateDatabase(databaseName); if (ds.T_IC_LOGGING_FILTER.Select(string.Empty, string.Empty, DataViewRowState.Added).Length > 0) { insertCommand = db.GetStoredProcCommand("P_IC_LOGGING_FILTER_I"); db.AddInParameter(insertCommand, "Category", DbType.String, "CATEGORY", DataRowVersion.Current); db.AddInParameter(insertCommand, "User_ID", DbType.String, "USER_ID", DataRowVersion.Current); db.AddInParameter(insertCommand, "Flag", DbType.Int32, "FLAG", DataRowVersion.Current); db.AddInParameter(insertCommand, "Version_No", DbType.Int32, "VERSION_NO", DataRowVersion.Current); db.AddInParameter(insertCommand, "Transaction_ID", DbType.String, AppContext.Current.TransactionID); db.AddInParameter(insertCommand, "Created_By", DbType.String, AppContext.Current.UserName); db.AddInParameter(insertCommand, "Created_Time", DbType.DateTime, DateTime.Now); } if (ds.T_IC_LOGGING_FILTER.Select(string.Empty, string.Empty, DataViewRowState.ModifiedCurrent).Length > 0) { updateCommand = db.GetStoredProcCommand("P_IC_LOGGING_FILTER_U"); db.AddInParameter(updateCommand, "Category", DbType.String, "CATEGORY", DataRowVersion.Current); db.AddInParameter(updateCommand, "User_ID", DbType.String, "USER_ID", DataRowVersion.Current); db.AddInParameter(updateCommand, "Flag", DbType.Int32, "FLAG", DataRowVersion.Current); db.AddInParameter(updateCommand, "Originalversion_no", DbType.Int32, "VERSION_NO", DataRowVersion.Original); db.AddInParameter(updateCommand, "Transaction_ID", DbType.String, AppContext.Current.TransactionID); db.AddInParameter(updateCommand, "Last_Updated_By", DbType.String, AppContext.Current.UserName); db.AddInParameter(updateCommand, "Last_Updated_Time", DbType.DateTime, DateTime.Now); } if (ds.T_IC_LOGGING_FILTER.Select(string.Empty, string.Empty, DataViewRowState.Deleted).Length > 0) { deleteCommand = db.GetStoredProcCommand("P_IC_LOGGING_FILTER_D"); db.AddInParameter(deleteCommand, "Category", DbType.String, "CATEGORY", DataRowVersion.Original); db.AddInParameter(deleteCommand, "User_ID", DbType.String, "USER_ID", DataRowVersion.Original); db.AddInParameter(deleteCommand, "Version_No", DbType.Int32, "VERSION_NO", DataRowVersion.Original); db.AddInParameter(deleteCommand, "Transaction_ID", DbType.String, AppContext.Current.TransactionID); db.AddInParameter(deleteCommand, "Last_Updated_By", DbType.String, AppContext.Current.UserName); db.AddInParameter(deleteCommand, "Last_Updated_Time", DbType.DateTime, DateTime.Now); } db.UpdateDataSet(ds, "T_IC_LOGGING_FILTER", insertCommand, updateCommand, deleteCommand, UpdateBehavior.Standard); }
public LoggingFilterDS RetrieveLoggingFilter(string category) { LoggingFilterDS ds = new LoggingFilterDS(); Helper.Fill(ds.T_IC_LOGGING_FILTER, "P_IC_LOGGING_FILTER_S", category); return ds; }
public void UpdateLoggingFilter(LoggingFilterDS ds) { _settingsDA.UpdateLoggingFilter(ds); }