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);
}
