public List <ForecastDateMethod> GetSavedForecastDateCollection(SqlString companyCode, SqlString customerNumber, long rowCount) { const string RDBConnectionKey = "PWCConnectionString"; var pf = PersistenceFacade.GetInstance(); var connection = pf.GetDbConnection(RDBConnectionKey); var command = connection.CreateCommand(); command.CommandText = "savedForecastDateCollection_sel"; command.CommandType = CommandType.StoredProcedure; pf.AddCommandParameter(RDBConnectionKey, command, "company_code", companyCode); pf.AddCommandParameter(RDBConnectionKey, command, "customer_number", customerNumber); pf.AddCommandParameter(RDBConnectionKey, command, "row_count", rowCount); var savedForecastDateCollection = new List <ForecastDateMethod> { new ForecastDateMethod(string.Empty, string.Empty) }; using (var dr = command.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { savedForecastDateCollection.Add(new ForecastDateMethod(string.Format("{0:MM/dd/yyyy}", dr["POSSalesEndDate"]), dr["ForecastMethod"].ToString())); } } return(savedForecastDateCollection); }
public string GetDefaultSqlServerName() { var connection = PersistenceFacade.GetInstance().GetDbConnection("PWCConnectionString"); using (connection) { return(connection.DataSource); } }
private void dgvProductCategory_DataError(object sender, DataGridViewDataErrorEventArgs e) { if (e.Exception != null) { var additionalData = new StringBuilder("Context: "); additionalData.Append(e.Context.ToString()).Append("\n"); additionalData.Append("RowIndex: ").Append(e.RowIndex.ToString()).Append("\n"); additionalData.Append("ColumnIndex: ").Append(e.ColumnIndex.ToString()); PersistenceFacade.GetInstance().LogException(e.Exception, Environment.MachineName, additionalData.ToString()); e.ThrowException = true; } }
public override void Load() { if (ParameterCollection != null) { PersistenceFacade.GetInstance().Get(this, Parent.ObjectKey, ParameterCollection); } else { PersistenceFacade.GetInstance().Get(this, Parent.ObjectKey); } LoadSetVersion(); }
private void dgvBrand_DataError(object sender, DataGridViewDataErrorEventArgs e) { if (e.Exception == null) { return; } var additionalData = new StringBuilder("Context: "); additionalData.Append(e.Context.ToString()).Append("\n"); additionalData.Append("RowIndex: ").Append(e.RowIndex.ToString(CultureInfo.InvariantCulture)).Append("\n"); additionalData.Append("ColumnIndex: ").Append(e.ColumnIndex.ToString(CultureInfo.InvariantCulture)); PersistenceFacade.GetInstance().LogException(e.Exception, Environment.MachineName, additionalData.ToString()); e.ThrowException = true; }
public void HandleException(Form form, Exception ex, EventArgs e) { string additionalData = null; var errorPhrase = "Unexpected error occured."; var isConcurrencyConflict = false; if (ex is SqlException) { isConcurrencyConflict = ex.Message == "Timestamp mismatched"; additionalData = string.Format("Class: {0}, LineNumber: {1}, Number: {2}, Procedure: {3}, State: {4}", ((SqlException)ex).Class, ((SqlException)ex).LineNumber, ((SqlException)ex).Number, ((SqlException)ex).Procedure, ((SqlException)ex).State); errorPhrase = "SQL operation error occured."; } if (isConcurrencyConflict) { MessageBox.Show("Your changes cannot be saved since your original data has been changed by another user.\n\n1. Please review the refreshed data\n2. Apply your changes\n3. Save again.", "PWC Forecast", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { PersistenceFacade.GetInstance().LogException(ex, Environment.MachineName, additionalData); MessageBox.Show( string.Format( "{0}\nThe error has been logged into database.\nPlease notify System Administrator.\n\n{1}", errorPhrase, ex.Message), "PWC Forecast", MessageBoxButtons.OK, MessageBoxIcon.Error); } form.Cursor = Cursors.Arrow; //if (e is DataGridViewCellCancelEventArgs) // ((DataGridViewCellCancelEventArgs)e).Cancel = true; //else if (e is DataGridViewRowCancelEventArgs) // ((DataGridViewRowCancelEventArgs)e).Cancel = true; //else if (e is DataGridViewCellValidatingEventArgs) // ((DataGridViewCellValidatingEventArgs)e).Cancel = true; // all of the types above are derived from CancelEventArgs, so no need to check individually if (e is CancelEventArgs) { ((CancelEventArgs)e).Cancel = true; } else if (e is DataGridViewCellParsingEventArgs) { ((DataGridViewCellParsingEventArgs)e).ParsingApplied = false; } else if (e is DataGridViewCellFormattingEventArgs) { ((DataGridViewCellFormattingEventArgs)e).FormattingApplied = false; } }
public bool DoesForecastSalesRateExist(SqlString companyCode, SqlString customerNumber, SqlDateTime posWeekEndDateEnd) { const string RDBConnectionKey = "PWCConnectionString"; var pf = PersistenceFacade.GetInstance(); var connection = pf.GetDbConnection(RDBConnectionKey); using (connection) { var command = connection.CreateCommand(); command.CommandText = "doesForecastSalesRateExist_sel"; command.CommandType = CommandType.StoredProcedure; pf.AddCommandParameter(RDBConnectionKey, command, "company_code", companyCode); pf.AddCommandParameter(RDBConnectionKey, command, "customer_number", customerNumber); pf.AddCommandParameter(RDBConnectionKey, command, "pos_sales_end_date", posWeekEndDateEnd); return((int)command.ExecuteScalar() == 1); } }
public override void Commit(APersistenceObject persistenceObject) { PersistenceFacade.GetInstance().Delete(persistenceObject); persistenceObject.PreviousState = this; persistenceObject.State = DeletedState.GetInstance(); }
public void Commit() { if (_transactionObjectCollection.Count == 0) { return; } if (IsDistributedTransaction) { using (var ts = new TransactionScope(TransactionScopeOption.Required)) { try { _transactionObjectCollection.Sort(new ComparerExecutionSequence()); foreach (var obj in _transactionObjectCollection) { obj.IsDelayedCommit = false; obj.Commit(); } ts.Complete(); _isCommitted = true; } catch (Exception) { foreach (var obj in _transactionObjectCollection) { obj.IsDelayedCommit = false; obj.Refresh(); } throw; } finally { ClearEnlistedObjects(); } } } else { try { var pf = PersistenceFacade.GetInstance(); _localDbTransaction = pf.BeginLocalDbTransaction(_localRdbConnectionKey); _transactionObjectCollection.Sort(new ComparerExecutionSequence()); foreach (var obj in _transactionObjectCollection) { obj.IsDelayedCommit = false; obj.Commit(); } pf.CommitLocalDbTransacstion(_localRdbConnectionKey); _isCommitted = true; } catch (Exception) { if (_localDbTransaction != null) { _localDbTransaction.Rollback(); } foreach (var obj in _transactionObjectCollection) { obj.Refresh(); } throw; } finally { ClearEnlistedObjects(); } } }
public override void Commit(APersistenceObject persistenceObject) { PersistenceFacade.GetInstance().Insert(persistenceObject); persistenceObject.PreviousState = this; persistenceObject.State = OldCleanState.GetInstance(); }
public virtual void Load() { PersistenceFacade.GetInstance().Get(this, ParameterCollection); LoadSetVersion(); }
public virtual void LoadFromObject(object sourceObject) { PersistenceFacade.GetInstance().GetFromObject(this, sourceObject); MarkNew(); }
public virtual void Load(ObjectMapperType objectMapperType) { PersistenceFacade.GetInstance().Get(this, objectMapperType); MarkOldClean(); }
public virtual void Load() { PersistenceFacade.GetInstance().Get(this); MarkOldClean(); }