/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus PerformBulkInsert(BulkInsertRequest bulkInsertRequest)
{
// Initialize
questStatus status = null;
// Read Filter
FilterId filterId = new FilterId(bulkInsertRequest.FilterId);
Filter filter = null;
FiltersMgr filtersMgr = new FiltersMgr(this.UserSession);
status = filtersMgr.Read(filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
bulkInsertRequest.Filter = filter;
// Determine if bulk insert filter procedure exists.
FilterProcedure filterProcedure = null;
status = _dbBulkInsertMgr.GetFilterProcedure(bulkInsertRequest, "Insert", out filterProcedure);
if (!questStatusDef.IsSuccessOrWarning(status))
{
return(status);
}
// Perform bulk insert filter procedure if exists.
if (questStatusDef.IsSuccess(status))
{
return(PerformBulkInsertFilterProcedure(bulkInsertRequest, filterProcedure));
}
// Validate bulk insert request
BulkInsertResponse bulkInsertResponse = null;
status = ValidateRequest(bulkInsertRequest, out bulkInsertResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Generate the SQL
status = _dbBulkInsertMgr.GenerateBulkInsertSQL(bulkInsertRequest);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Perform bulk insert.
status = _dbBulkInsertMgr.PerformBulkInsert(bulkInsertRequest);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
private void InitializeFilters()
{
_parameter = System.Linq.Expressions.Expression.Parameter(typeof(ServiceLog), "s");
_parameterSD = System.Linq.Expressions.Expression.Parameter(typeof(ServiceDone), "sd");
_parameterSU = System.Linq.Expressions.Expression.Parameter(typeof(SpareUsed), "su");
_filterDate = new FilterDate(_parameter);
_filterSearch = new FilterSearch(_parameter);
_filterStatus = new FilterId(_parameter);
_filterDept = new FilterId(_parameter);
_filterRepairer = new FilterId(_parameter);
_filterTypeModel = new FilterId(_parameter);
_filterModel = new FilterId(_parameter);
_filterSparesUsed = new FilterIdAnd(_parameterSU);
_filterServicesDone = new FilterIdAnd(_parameterSD);
_filters = new List <BL.IFilter>();
_filters.Add(_filterDate);
_filters.Add(_filterSearch);
_filters.Add(_filterStatus);
_filters.Add(_filterRepairer);
_filters.Add(_filterDept);
_filters.Add(_filterTypeModel);
_filters.Add(_filterModel);
_filterDate.FilterCreated += OnFilterChanged;
_filterSearch.FilterCreated += OnFilterChanged;
}
public questStatus Read(FilterId filterId, out FilterSQLViewModel filterSQLViewModel)
{
// Initialize
questStatus status = null;
filterSQLViewModel = null;
// Read filter
Quest.Functional.MasterPricing.Filter filter = null;
FilterMgr filterMgr = new FilterMgr(this.UserSession);
status = filterMgr.GetFilter(filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model
filterSQLViewModel = new FilterSQLViewModel();
BufferMgr.TransferBuffer(filter, filterSQLViewModel);
if (string.IsNullOrEmpty(filterSQLViewModel.SQL))
{
return(new questStatus(Severity.Warning, "Filter has no SQL"));
}
return(new questStatus(Severity.Success));
}
public questStatus Copy(FilterCopyViewModel viewModel, out FilterCopyViewModel filterCopyViewModel)
{
// Initialize
questStatus status = null;
filterCopyViewModel = null;
// Copy the filter.
FilterId filterId = new FilterId(viewModel.FilterId);
FilterId newFilterId = null;
FilterMgr filterMgr = new FilterMgr(this.UserSession);
status = filterMgr.Copy(filterId, out newFilterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Return new filter Id
filterCopyViewModel = new FilterCopyViewModel();
filterCopyViewModel.FilterId = viewModel.FilterId;
filterCopyViewModel.NewFilterId = newFilterId.Id;
return(new questStatus(Severity.Success));
}
public questStatus Read(DbMgrTransaction trans, FilterId filterId, out List <Quest.Functional.MasterPricing.FilterColumn> filterColumnList)
{
// Initialize
questStatus status = null;
filterColumnList = null;
// Perform read
List <Quest.Services.Dbio.MasterPricing.FilterColumns> _filterColumnsList = null;
status = read((MasterPricingEntities)trans.DbContext, filterId, out _filterColumnsList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterColumnList = new List <FilterColumn>();
foreach (Quest.Services.Dbio.MasterPricing.FilterColumns _filterColumn in _filterColumnsList)
{
Quest.Functional.MasterPricing.FilterColumn filterColumn = new Quest.Functional.MasterPricing.FilterColumn();
BufferMgr.TransferBuffer(_filterColumn, filterColumn);
filterColumnList.Add(filterColumn);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, FilterId filterId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((MasterPricingEntities)trans.DbContext, filterId);
if (bLogging)
{
FilterLog filterLog = new FilterLog();
filterLog.Database = "";
filterLog.Tableset = "";
filterLog.Name = "Filter.Id=" + filterId.Id.ToString();
filterLog.Event = "DELETE";
filterLog.Data = status.ToString();
FilterLogId filterLogId = null;
_dbFilterLogsMgr.Create(filterLog, out filterLogId);
}
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(FilterId filterId)
{
// Initialize
questStatus status = null;
// Perform delete.
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = delete(dbContext, filterId);
if (bLogging)
{
FilterLog filterLog = new FilterLog();
filterLog.Database = "";
filterLog.Tableset = "";
filterLog.Name = "Filter.Id=" + filterId.Id.ToString();
filterLog.Event = "DELETE";
filterLog.Data = status.ToString();
FilterLogId filterLogId = null;
_dbFilterLogsMgr.Create(filterLog, out filterLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
/*----------------------------------------------------------------------------------------------------------------------------------
* Filters
*---------------------------------------------------------------------------------------------------------------------------------*/
private questStatus create(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.Filter filter, out FilterId filterId)
{
// Initialize
filterId = null;
// Perform create
try
{
Quest.Services.Dbio.MasterPricing.Filters _filters = new Quest.Services.Dbio.MasterPricing.Filters();
BufferMgr.TransferBuffer(filter, _filters);
dbContext.Filters.Add(_filters);
dbContext.SaveChanges();
if (_filters.Id == 0)
{
return(new questStatus(Severity.Error, "Quest.Functional.MasterPricing.Filter not created"));
}
filterId = new FilterId(_filters.Id);
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus Create(Quest.Functional.MasterPricing.Filter filter, out FilterId filterId)
{
// Initialize
questStatus status = null;
filterId = null;
// Data rules.
// Create the filter
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
status = create(dbContext, filter, out filterId);
if (bLogging)
{
FilterLog filterLog = new FilterLog();
filterLog.Database = "";
filterLog.Tableset = "Tableset.Id=" + filter.TablesetId.ToString();
filterLog.Name = filter.Name == null ? "(null)" : filter.Name;
filterLog.Event = "CREATE";
filterLog.Data = status.ToString();
FilterLogId filterLogId = null;
_dbFilterLogsMgr.Create(filterLog, out filterLogId);
}
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
return(new questStatus(Severity.Success));
}
private questStatus update(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.Filter filter)
{
// Initialize
questStatus status = null;
try
{
// Read the record.
FilterId filterId = new FilterId(filter.Id);
Quest.Services.Dbio.MasterPricing.Filters _filters = null;
status = read(dbContext, filterId, out _filters);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Update the record.
BufferMgr.TransferBuffer(filter, _filters);
dbContext.SaveChanges();
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus Refresh(FilterId filterId)
{
// TODO: OPTIMIZE
// Initialize
questStatus status = null;
Filter filter = null;
// Get the filter.
status = GetFilter(filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Save the filter
status = Save(filterId, filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// TODO: Update the filter SQL - WHEN all this can be done in one transaction.
return(new questStatus(Severity.Success));
}
public questStatus Read(FilterId filterId, out List <Quest.Functional.MasterPricing.FilterItem> filterItemList)
{
// Initialize
questStatus status = null;
filterItemList = null;
// Perform read
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
List <Quest.Services.Dbio.MasterPricing.FilterItems> _filterItemsList = null;
status = read(dbContext, filterId, out _filterItemsList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
filterItemList = new List <FilterItem>();
foreach (Quest.Services.Dbio.MasterPricing.FilterItems _filterItem in _filterItemsList)
{
Quest.Functional.MasterPricing.FilterItem filterItem = new Quest.Functional.MasterPricing.FilterItem();
BufferMgr.TransferBuffer(_filterItem, filterItem);
filterItemList.Add(filterItem);
}
}
return(new questStatus(Severity.Success));
}
public FilterInfo(FilterId filterId, string name, Filter filter,
Action enterCommand)
{
this.filterId = filterId;
this.name = name;
this.filter = filter;
this.enterCommand = enterCommand;
}
/// <summary>
/// Initializes a new instance of the <see cref="AbstractFilterProcessor{TEventType, TClientMessage, TRegistrationRequest, TFilterResponse}"/> class.
/// </summary>
/// <param name="filterId">The unique <see cref="FilterId"/> for the event filter.</param>
/// <param name="converter">The <see cref="IEventConverter"/> to use to convert events.</param>
/// <param name="logger">The <see cref="ILogger"/> to use for logging.</param>
protected AbstractFilterProcessor(
FilterId filterId,
IEventConverter converter,
ILogger logger)
: base(logger)
{
Identifier = filterId;
_converter = converter;
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus PerformBulkUpdate(BulkUpdateRequest bulkUpdateRequest, out int numRows)
{
// Initialize
questStatus status = null;
numRows = -1;
// Get the filter
Filter filter = null;
FilterId filterId = new FilterId(bulkUpdateRequest.FilterId);
FilterMgr filterMgr = new FilterMgr(this.UserSession);
status = filterMgr.GetFilter(filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
bulkUpdateRequest.Filter = filter;
// Determine if bulk update filter procedure exists.
FilterProcedure filterProcedure = null;
status = _dbBulkUpdateMgr.GetFilterProcedure(bulkUpdateRequest, "Update", out filterProcedure);
if (!questStatusDef.IsSuccessOrWarning(status))
{
return(status);
}
// Perform bulk update filter procedure if exists.
if (questStatusDef.IsSuccess(status))
{
return(PerformBulkUpdateFilterProcedure(bulkUpdateRequest, filterProcedure));
}
// Generate the SQL
status = _dbBulkUpdateMgr.GenerateBulkUpdateSQL(bulkUpdateRequest);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Perform bulk update.
status = _dbBulkUpdateMgr.PerformBulkUpdate(bulkUpdateRequest, out numRows);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region Filters
//
// Filters
//
public questStatus DeleteFilter(FilterId filterId)
{
using (MasterPricingEntities dbContext = new MasterPricingEntities())
{
int numRows = dbContext.DeleteFilterById(filterId.Id);
if (numRows < 1)
{
return(new questStatus(Severity.Error, String.Format("Filter {0} was not deleted", filterId.Id)));
}
}
return(new questStatus(Severity.Success));
}
public bool Equals(FilterId other)
{
if (ReferenceEquals(null, other))
{
return(false);
}
if (ReferenceEquals(this, other))
{
return(true);
}
return(other._value == _value);
}
private void InitializeFilters()
{
_parameter = System.Linq.Expressions.Expression.Parameter(typeof(Repairer), "s");
_parameterServiceLog = System.Linq.Expressions.Expression.Parameter(typeof(ServiceLog), "s");
_filterSearch = new FilterSearch(_parameter);
_filterServiceLog = new FilterId(_parameterServiceLog);
_filters = new List <IFilter>();
_filters.Add(_filterSearch);
_filterSearch.FilterCreated += OnFilterChanged;
}
/// <summary>
/// Initializes a new instance of the <see cref="PublicEventFilterProcessor"/> class.
/// </summary>
/// <param name="filterId">The unique <see cref="FilterId"/> for the event filter.</param>
/// <param name="client">The <see cref="FiltersClient"/> to use to connect to the Runtime.</param>
/// <param name="reverseCallClients">The <see cref="IReverseCallClients"/> to use for creating instances of <see cref="IReverseCallClient{TClientMessage, TServerMessage, TConnectArguments, TConnectResponse, TRequest, TResponse}"/>.</param>
/// <param name="filter">The <see cref="ICanFilterPublicEvents"/> to use for filtering the events.</param>
/// <param name="converter">The <see cref="IEventConverter"/> to use to convert events.</param>
/// <param name="logger">The <see cref="ILogger"/> to use for logging.</param>
public PublicEventFilterProcessor(
FilterId filterId,
FiltersClient client,
IReverseCallClients reverseCallClients,
ICanFilterPublicEvents filter,
IEventConverter converter,
ILogger logger)
: base(filterId, converter, logger)
{
_client = client;
_reverseCallClients = reverseCallClients;
_filter = filter;
}
private void InitializeFilters()
{
_parameter = System.Linq.Expressions.Expression.Parameter(typeof(Dept), "s");
_parameterDevice = System.Linq.Expressions.Expression.Parameter(typeof(Device), "s");
_filterSearch = new FilterSearch(_parameter);
_filterDevice = new FilterId(_parameterDevice);
_filters = new List <IFilter>();
_filters.Add(_filterSearch);
_filterSearch.FilterCreated += OnFilterChanged;
}
public questStatus Delete(DbMgrTransaction trans, FilterId filterId, FilterViewId filterViewId)
{
// Initialize
questStatus status = null;
// Delete all tableTables in this table.
status = _dbFilterColumnsMgr.Delete(trans, filterId, filterViewId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, FilterId filterId)
{
// Initialize
questStatus status = null;
// Delete all procedureProcedures in this procedure.
status = _dbFilterProceduresMgr.Delete(trans, filterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(FilterId filterId)
{
// Initialize
questStatus status = null;
// Delete all viewViews in this filter.
status = _dbFilterViewsMgr.Delete(filterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, FilterId filterId)
{
// Initialize
questStatus status = null;
// TODO: DELETE ALL STUFF WITH A FILTER.
DbFilterMgr dbFilterMgr = new DbFilterMgr(this.UserSession);
status = dbFilterMgr.Delete(trans, filterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
private questStatus delete(MasterPricingEntities dbContext, FilterId filterId)
{
try
{
dbContext.Filters.RemoveRange(dbContext.Filters.Where(r => r.Id == filterId.Id));
dbContext.SaveChanges();
}
catch (System.Exception ex)
{
return(new questStatus(Severity.Fatal, String.Format("EXCEPTION: {0}.{1}: {2}",
this.GetType().Name, MethodBase.GetCurrentMethod().Name,
ex.InnerException != null ? ex.InnerException.Message : ex.Message)));
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(FilterId filterId)
{
// Initialize
questStatus status = null;
// Delete filter
DbFilterMgr dbFilterMgr = new DbFilterMgr(this.UserSession);
status = dbFilterMgr.Delete(filterId);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
/// <summary>
/// Initializes a new instance of the <see cref="EventFilterWithPartitionsProcessor"/> class.
/// </summary>
/// <param name="filterId">The unique <see cref="FilterId"/> for the event filter.</param>
/// <param name="scope">The <see cref="ScopeId"/> of the scope in the Event Store where the filter will run.</param>
/// <param name="client">The <see cref="FiltersClient"/> to use to connect to the Runtime.</param>
/// <param name="reverseCallClients">The <see cref="IReverseCallClients"/> to use for creating instances of <see cref="IReverseCallClient{TClientMessage, TServerMessage, TConnectArguments, TConnectResponse, TRequest, TResponse}"/>.</param>
/// <param name="filter">The <see cref="ICanFilterEventsWithPartition"/> to use for filtering the events.</param>
/// <param name="converter">The <see cref="IEventConverter"/> to use to convert events.</param>
/// <param name="logger">The <see cref="ILogger"/> to use for logging.</param>
public EventFilterWithPartitionsProcessor(
FilterId filterId,
ScopeId scope,
FiltersClient client,
IReverseCallClients reverseCallClients,
ICanFilterEventsWithPartition filter,
IEventConverter converter,
ILogger logger)
: base(filterId, converter, logger)
{
_scope = scope;
_client = client;
_reverseCallClients = reverseCallClients;
_filter = filter;
}
public questStatus GetFilter(DbMgrTransaction trans, FilterId filterId, out Filter filter)
{
// Initialize
questStatus status = null;
filter = null;
status = _dbFilterMgr.GetFilter(trans, filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Delete(DbMgrTransaction trans, FilterId filterId)
{
// Initialize
questStatus status = null;
// Perform delete in this transaction.
status = delete((MasterPricingEntities)trans.DbContext, filterId);
if (!questStatusDef.IsSuccess(status))
{
RollbackTransaction(trans);
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus Read(FilterId filterId, out Filter filter)
{
// Initialize
questStatus status = null;
filter = null;
// Read filter
status = _dbFiltersMgr.Read(filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
private void UpdateFilterValue(FilterId key, object value)
{
if (value == null)
{
if (_filters.ContainsKey(key))
_filters.Remove(key);
}
else
{
if (_filters.ContainsKey(key))
{
_filters[key] = value;
}
else
{
_filters.Add(key, value);
}
}
}
private void ChangeFilter(FilterTextBox source, FilterId tag,bool clear=false)
{
string value = source.FilterText != string.Empty ? source.FilterText : null;
if (clear)
value = null;
UpdateFilterValue(tag, value);
RefreshData();
}
