public int UpdateBrokeragePayment(BO.SaleBrokerageBO brokerage) { int _ID; try { DatabaseAccess.OpenConnection(true); var _ourParams = DatabaseAccess.ExecuteProcedureDML("P_Sale_BrokeragePayment", new List <DAL.DatabaseParameter>() { new DAL.DatabaseParameter("@BDID", DAL.ParameterDirection.In, DAL.DataType.Int, brokerage.BDID), new DAL.DatabaseParameter("@PayDate", DAL.ParameterDirection.In, DAL.DataType.Date, brokerage.PayDate), new DAL.DatabaseParameter("@PayComments", DAL.ParameterDirection.In, DAL.DataType.String, brokerage.PayComments, 1000) }); DatabaseAccess.CommitTransaction(); _ID = brokerage.BDID; _ourParams = null; } catch { DatabaseAccess.RollbackTransaction(); throw; } finally { DatabaseAccess.CloseConnection(); } return(_ID); }
public int AddBrokerage(BO.SaleBrokerageBO brokerage) { int _ID; try { DatabaseAccess.OpenConnection(true); var _ourParams = DatabaseAccess.ExecuteProcedureDML("P_Sale_AddBrokerage", new List <DAL.DatabaseParameter>() { new DAL.DatabaseParameter("@BDID", DAL.ParameterDirection.InOut, DAL.DataType.Int, brokerage.BDID), new DAL.DatabaseParameter("@SaleID", DAL.ParameterDirection.In, DAL.DataType.Int, brokerage.SaleID), new DAL.DatabaseParameter("@BrokerID", DAL.ParameterDirection.In, DAL.DataType.Int, brokerage.BrokerID), new DAL.DatabaseParameter("@Brokerage", DAL.ParameterDirection.In, DAL.DataType.Decimal, brokerage.Brokerage) }); DatabaseAccess.CommitTransaction(); _ID = Convert.ToInt32(_ourParams["@BDID"]); _ourParams = null; } catch { DatabaseAccess.RollbackTransaction(); throw; } finally { DatabaseAccess.CloseConnection(); } return(_ID); }