private questStatus update(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.FilterProcedureParameter filterProcedureParameter) { // Initialize questStatus status = null; try { // Read the record. FilterProcedureParameterId filterProcedureParameterId = new FilterProcedureParameterId(filterProcedureParameter.Id); Quest.Services.Dbio.MasterPricing.FilterProcedureParameters _filterProcedureParameters = null; status = read(dbContext, filterProcedureParameterId, out _filterProcedureParameters); if (!questStatusDef.IsSuccess(status)) { return(status); } // Update the record. BufferMgr.TransferBuffer(filterProcedureParameter, _filterProcedureParameters); 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)); }
/*---------------------------------------------------------------------------------------------------------------------------------- * FilterProcedureParameters *---------------------------------------------------------------------------------------------------------------------------------*/ private questStatus create(MasterPricingEntities dbContext, Quest.Functional.MasterPricing.FilterProcedureParameter filterProcedureParameter, out FilterProcedureParameterId filterProcedureParameterId) { // Initialize filterProcedureParameterId = null; // Perform create try { Quest.Services.Dbio.MasterPricing.FilterProcedureParameters _filterProcedureParameters = new Quest.Services.Dbio.MasterPricing.FilterProcedureParameters(); BufferMgr.TransferBuffer(filterProcedureParameter, _filterProcedureParameters, true); dbContext.FilterProcedureParameters.Add(_filterProcedureParameters); dbContext.SaveChanges(); if (_filterProcedureParameters.Id == 0) { return(new questStatus(Severity.Error, "Quest.Functional.MasterPricing.FilterProcedureParameter not created")); } filterProcedureParameterId = new FilterProcedureParameterId(_filterProcedureParameters.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, FilterProcedureParameterId filterProcedureParameterId) { // Initialize questStatus status = null; // Delete filterProcedureParameter status = _dbFilterProcedureParametersMgr.Delete(trans, filterProcedureParameterId); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
private questStatus delete(MasterPricingEntities dbContext, FilterProcedureParameterId filterProcedureParameterId) { try { dbContext.FilterProcedureParameters.RemoveRange(dbContext.FilterProcedureParameters.Where(r => r.Id == filterProcedureParameterId.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(DbMgrTransaction trans, FilterProcedureParameterId filterProcedureParameterId) { // Initialize questStatus status = null; // Perform delete in this transaction. status = delete((MasterPricingEntities)trans.DbContext, filterProcedureParameterId); if (!questStatusDef.IsSuccess(status)) { RollbackTransaction(trans); return(status); } return(new questStatus(Severity.Success)); }
public questStatus Read(DbMgrTransaction trans, FilterProcedureParameterId filterProcedureParameterId, out FilterProcedureParameter filterProcedureParameter) { // Initialize questStatus status = null; filterProcedureParameter = null; // Read filterProcedureParameter status = _dbFilterProcedureParametersMgr.Read(trans, filterProcedureParameterId, out filterProcedureParameter); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public questStatus Delete(FilterProcedureParameterId filterProcedureParameterId) { // Initialize questStatus status = null; // Perform delete. using (MasterPricingEntities dbContext = new MasterPricingEntities()) { status = delete(dbContext, filterProcedureParameterId); if (!questStatusDef.IsSuccess(status)) { return(status); } } return(new questStatus(Severity.Success)); }
public questStatus Read(DbMgrTransaction trans, FilterProcedureParameterId filterProcedureParameterId, out Quest.Functional.MasterPricing.FilterProcedureParameter filterProcedureParameter) { // Initialize questStatus status = null; filterProcedureParameter = null; // Perform read Quest.Services.Dbio.MasterPricing.FilterProcedureParameters _filterProcedureParameters = null; status = read((MasterPricingEntities)trans.DbContext, filterProcedureParameterId, out _filterProcedureParameters); if (!questStatusDef.IsSuccess(status)) { return(status); } filterProcedureParameter = new Quest.Functional.MasterPricing.FilterProcedureParameter(); BufferMgr.TransferBuffer(_filterProcedureParameters, filterProcedureParameter); return(new questStatus(Severity.Success)); }
/*================================================================================================================================== * Properties *=================================================================================================================================*/ #endregion #region Public Methods /*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.Database database, FilterProcedure filterProcedure, out FilterProcedureId filterProcedureId) { // Initialize questStatus status = null; filterProcedureId = null; // Create filterProcedure status = _dbFilterProceduresMgr.Create(trans, filterProcedure, out filterProcedureId); if (!questStatusDef.IsSuccess(status)) { return(status); } // Store parameters for procedure List <FilterProcedureParameter> filterProcedureParameterList = null; status = GetStoredProdecureParameters(database, filterProcedure.Name, out filterProcedureParameterList); if (!questStatusDef.IsSuccess(status)) { return(status); } FilterProcedureParametersMgr filterProcedureParametersMgr = new FilterProcedureParametersMgr(this.UserSession); foreach (FilterProcedureParameter filterProcedureParameter in filterProcedureParameterList) { filterProcedureParameter.FilterProcedureId = filterProcedureId.Id; FilterProcedureParameterId filterProcedureParameterId = null; status = filterProcedureParametersMgr.Create(trans, database, filterProcedureParameter, out filterProcedureParameterId); if (!questStatusDef.IsSuccess(status)) { return(status); } } return(new questStatus(Severity.Success)); }
private questStatus read(MasterPricingEntities dbContext, FilterProcedureParameterId filterProcedureParameterId, out Quest.Services.Dbio.MasterPricing.FilterProcedureParameters filterProcedureParameter) { // Initialize filterProcedureParameter = null; try { filterProcedureParameter = dbContext.FilterProcedureParameters.Where(r => r.Id == filterProcedureParameterId.Id).SingleOrDefault(); if (filterProcedureParameter == null) { return(new questStatus(Severity.Error, String.Format("ERROR: {0}.{1}: {2}", this.GetType().Name, MethodBase.GetCurrentMethod().Name, String.Format("Id {0} not found", filterProcedureParameterId.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 Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.Database database, FilterProcedureParameter filterProcedureParameter, out FilterProcedureParameterId filterProcedureParameterId) { // Initialize questStatus status = null; filterProcedureParameterId = null; // Create filterProcedureParameter status = _dbFilterProcedureParametersMgr.Create(trans, filterProcedureParameter, out filterProcedureParameterId); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
public questStatus Create(DbMgrTransaction trans, Quest.Functional.MasterPricing.FilterProcedureParameter filterProcedureParameter, out FilterProcedureParameterId filterProcedureParameterId) { // Initialize questStatus status = null; filterProcedureParameterId = null; // Data rules. // Create the filterProcedureParameter in this transaction. status = create((MasterPricingEntities)trans.DbContext, filterProcedureParameter, out filterProcedureParameterId); if (!questStatusDef.IsSuccess(status)) { return(status); } return(new questStatus(Severity.Success)); }
/*================================================================================================================================== * Properties *=================================================================================================================================*/ #endregion #region Public Methods /*================================================================================================================================== * Public Methods *=================================================================================================================================*/ public questStatus Create(Quest.Functional.MasterPricing.FilterProcedureParameter filterProcedureParameter, out FilterProcedureParameterId filterProcedureParameterId) { // Initialize questStatus status = null; filterProcedureParameterId = null; // Data rules. // Create the filterProcedureParameter using (MasterPricingEntities dbContext = new MasterPricingEntities()) { status = create(dbContext, filterProcedureParameter, out filterProcedureParameterId); if (!questStatusDef.IsSuccess(status)) { return(status); } } return(new questStatus(Severity.Success)); }