private questStatus update(MasterPricingEntities dbContext, Quest.Functional.Logging.FilterLog filterLog) { // Initialize questStatus status = null; try { // Read the record. FilterLogId filterLogId = new FilterLogId(filterLog.Id); Quest.Services.Dbio.MasterPricing.FilterLogs _filterLog = null; status = read(dbContext, filterLogId, out _filterLog); if (!questStatusDef.IsSuccess(status)) { return(status); } // Update the record. BufferMgr.TransferBuffer(filterLog, _filterLog); 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(DeleteLogItemsViewModel deleteLogItemsViewModel) { // Initialize questStatus status = null; // Build id list List <FilterLogId> filterLogIdList = new List <FilterLogId>(); foreach (BaseId baseId in deleteLogItemsViewModel.Items) { FilterLogId filterLogId = new FilterLogId(baseId.Id); filterLogIdList.Add(filterLogId); } // Delete items FilterLogsMgr filterLogsMgr = new FilterLogsMgr(this.UserSession); status = filterLogsMgr.Delete(filterLogIdList); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
/*---------------------------------------------------------------------------------------------------------------------------------- * FilterLogs *---------------------------------------------------------------------------------------------------------------------------------*/ private questStatus create(MasterPricingEntities dbContext, Quest.Functional.Logging.FilterLog filterLog, out FilterLogId filterLogId) { // Initialize filterLogId = null; // Initialize filterLog.UserSessionId = this.UserSession.Id; filterLog.Username = this.UserSession.User.Username; filterLog.Created = DateTime.Now; // Perform create try { Quest.Services.Dbio.MasterPricing.FilterLogs _filterLog = new Quest.Services.Dbio.MasterPricing.FilterLogs(); BufferMgr.TransferBuffer(filterLog, _filterLog); dbContext.FilterLogs.Add(_filterLog); dbContext.SaveChanges(); if (_filterLog.Id == 0) { return(new questStatus(Severity.Error, "Quest.Functional.Logging.FilterLog not created")); } filterLogId = new FilterLogId(_filterLog.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 questStatus Delete(DbMgrTransaction trans, TablesetId tablesetId) { // Initialize questStatus status = null; // Perform delete in this transaction. status = delete((MasterPricingEntities)trans.DbContext, tablesetId); if (bLogging) { FilterLog filterLog = new FilterLog(); filterLog.Database = ""; filterLog.Tableset = ""; filterLog.Name = "TablesetId.Id=" + tablesetId.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 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)); }
public questStatus Delete(TablesetId tablesetId) { // Initialize questStatus status = null; // Perform delete. using (MasterPricingEntities dbContext = new MasterPricingEntities()) { status = delete(dbContext, tablesetId); if (bLogging) { FilterLog filterLog = new FilterLog(); filterLog.Database = ""; filterLog.Tableset = ""; filterLog.Name = "Tableset.Id=" + tablesetId.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)); }
public questStatus Update(DbMgrTransaction trans, Quest.Functional.MasterPricing.Filter filter) { // Initialize questStatus status = null; bool bCreateTransaction = trans == null; // Perform update in this transaction. status = update((MasterPricingEntities)trans.DbContext, filter); 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 = "UPDATE"; 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 ExecuteFilter(RunFilterRequest runFilterRequest, out ResultsSet resultsSet) { // TODO: business rules about what can/cannot be saved. // Initialize questStatus status = null; resultsSet = null; DbResultsMgr dbResultsMgr = new DbResultsMgr(this.UserSession); // Execute the filter status = dbResultsMgr.ExecuteFilter(runFilterRequest, out resultsSet); if (bLogging) { FilterLog filterLog = new FilterLog(); filterLog.Database = ""; filterLog.Tableset = ""; filterLog.Name = "FilterId=" + runFilterRequest.FilterId.ToString(); filterLog.Event = "EXECUTE"; filterLog.Data = String.Format("RowLimit: {0} ColLimit: {1} PageNumber: {2} PageSize: {3} Result rows: {4} questStatus: {5}", runFilterRequest.RowLimit, runFilterRequest.ColLimit, runFilterRequest.PageNumber, runFilterRequest.PageSize, resultsSet == null ? "(N/A)" : resultsSet.NumRows.ToString(), status.ToString()); FilterLogId filterLogId = null; _dbFilterLogsMgr.Create(filterLog, out filterLogId); } if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public questStatus Run(RunFilterRequest runFilterRequest, Filter filter, out ResultsSet resultsSet) { // Initialize questStatus status = null; resultsSet = null; // Run the filter DbResultsMgr dbResultsMgr = new DbResultsMgr(this.UserSession); status = dbResultsMgr.Run(runFilterRequest, filter, out resultsSet); if (bLogging) { FilterLog filterLog = new FilterLog(); filterLog.Database = ""; filterLog.Tableset = ""; filterLog.Name = "FilterId=" + runFilterRequest.FilterId.ToString(); filterLog.Event = "RUN"; filterLog.Data = String.Format("RowLimit: {0} ColLimit: {1} PageNumber: {2} PageSize: {3} Result rows: {4} questStatus: {5}", runFilterRequest.RowLimit, runFilterRequest.ColLimit, runFilterRequest.PageNumber, runFilterRequest.PageSize, resultsSet.NumRows, status.ToString()); FilterLogId filterLogId = null; _dbFilterLogsMgr.Create(filterLog, out filterLogId); } if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
/*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus Save(FilterId filterId, Filter filter) { // Initialize questStatus status = null; Mgr mgr = new Mgr(this.UserSession); DbMgrTransaction trans = null; FiltersMgr filtersMgr = new FiltersMgr(this.UserSession); ColumnsMgr columnMgr = new ColumnsMgr(this.UserSession); try { // Validate filter status = Verify(filterId, filter); if (!questStatusDef.IsSuccess(status)) { return(status); } // BEGIN TRANSACTION status = mgr.BeginTransaction("SaveFilter" + Guid.NewGuid().ToString(), out trans); if (!questStatusDef.IsSuccess(status)) { return(status); } // Save the filter status = Save(trans, filterId, filter); if (!questStatusDef.IsSuccess(status)) { mgr.RollbackTransaction(trans); if (bLogging) { Filter _filter = null; status = filtersMgr.Read(filterId, out _filter); if (!questStatusDef.IsSuccess(status)) { return(status); } FilterLog filterLog = new FilterLog(); filterLog.Database = ""; filterLog.Tableset = "Tableset.Id=" + filter.TablesetId.ToString(); filterLog.Name = _filter.Name; filterLog.Event = "SAVE"; filterLog.Data = status.ToString(); FilterLogId filterLogId = null; _dbFilterLogsMgr.Create(filterLog, out filterLogId); } return(status); } // COMMIT TRANSACTION status = mgr.CommitTransaction(trans); if (!questStatusDef.IsSuccess(status)) { return(status); } // Logging if (bLogging) { Filter _filter = null; status = filtersMgr.Read(filterId, out _filter); if (!questStatusDef.IsSuccess(status)) { return(status); } FilterLog filterLog = new FilterLog(); filterLog.Database = ""; filterLog.Tableset = "Tableset.Id=" + filter.TablesetId.ToString(); filterLog.Name = _filter.Name; filterLog.Event = "SAVE"; filterLog.Data = status.ToString(); FilterLogId filterLogId = null; _dbFilterLogsMgr.Create(filterLog, out filterLogId); } // TODO: REFACTOR TO GET ALL-IN-ONE TRANSACTION // Generate filter SQL Filter filterWithSQL = null; DbFilterMgr dbFilterMgr = new DbFilterMgr(this.UserSession); status = dbFilterMgr.GenerateFilterSQL(filterId, out filterWithSQL); if (!questStatusDef.IsSuccess(status)) { return(status); } // Update filter status = filtersMgr.Update(filterWithSQL); if (!questStatusDef.IsSuccess(status)) { return(status); } } catch (System.Exception ex) { if (trans != null) { mgr.RollbackTransaction(trans); } 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)); }