/// <summary> /// Inserts a LibraryManagement.Domain.TransValue object into the datasource using a transaction. /// </summary> /// <param name="transactionManager"><see cref="TransactionManager"/> object</param> /// <param name="entity">LibraryManagement.Domain.TransValue object to insert.</param> /// <remarks> /// After inserting into the datasource, the LibraryManagement.Domain.TransValue object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> /// <returns>Returns true if operation is successful.</returns> /// <exception cref="System.Exception">The command could not be executed.</exception> /// <exception cref="System.Data.DataException">The <paramref name="transactionManager"/> is not open.</exception> /// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception> public override bool Insert(TransactionManager transactionManager, LibraryManagement.Domain.TransValue entity) { SqlDatabase database = new SqlDatabase(this._connectionString); DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(database, "dbo.tblTransValue_Insert", _useStoredProcedure); database.AddInParameter(commandWrapper, "@TransNum", DbType.StringFixedLength, entity.TransNum); database.AddInParameter(commandWrapper, "@Amount", DbType.Decimal, (entity.Amount.HasValue ? (object)entity.Amount : System.DBNull.Value)); database.AddInParameter(commandWrapper, "@Frcustomer", DbType.Decimal, (entity.Frcustomer.HasValue ? (object)entity.Frcustomer : System.DBNull.Value)); database.AddInParameter(commandWrapper, "@Forex", DbType.StringFixedLength, entity.Forex); int results = 0; //Provider Data Requesting Command Event OnDataRequesting(new CommandEventArgs(commandWrapper, "Insert", entity)); if (transactionManager != null) { results = Utility.ExecuteNonQuery(transactionManager, commandWrapper); } else { results = Utility.ExecuteNonQuery(database, commandWrapper); } entity.OriginalTransNum = entity.TransNum; entity.AcceptChanges(); //Provider Data Requested Command Event OnDataRequested(new CommandEventArgs(commandWrapper, "Insert", entity)); return(Convert.ToBoolean(results)); }
///<summary> /// A simple factory method to create a new <see cref="TransValue"/> instance. ///</summary> ///<param name="_transNum"></param> ///<param name="_amount"></param> ///<param name="_frcustomer"></param> ///<param name="_forex"></param> public static TransValue CreateTransValue(System.String _transNum, System.Decimal?_amount, System.Decimal?_frcustomer, System.String _forex) { TransValue newTransValue = new TransValue(); newTransValue.TransNum = _transNum; newTransValue.Amount = _amount; newTransValue.Frcustomer = _frcustomer; newTransValue.Forex = _forex; return(newTransValue); }
///<summary> /// Returns a Typed TransValue Entity ///</summary> protected virtual TransValue Copy(IDictionary existingCopies) { if (existingCopies == null) { // This is the root of the tree to be copied! existingCopies = new Hashtable(); } //shallow copy entity TransValue copy = new TransValue(); existingCopies.Add(this, copy); copy.SuppressEntityEvents = true; copy.TransNum = this.TransNum; copy.OriginalTransNum = this.OriginalTransNum; copy.Amount = this.Amount; copy.Frcustomer = this.Frcustomer; copy.Forex = this.Forex; copy.EntityState = this.EntityState; copy.SuppressEntityEvents = false; return(copy); }