public bool CreateRealEstateTransaction(RealEstateVo realEstateVo, string userId) { RealEstateDao realEstateDao = new RealEstateDao(); bool bResult = false; try { bResult = realEstateDao.CreateRealEstateTransaction(realEstateVo, userId); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "RealEstateBo.cs:CreateRealEstateTransaction()"); object[] objects = new object[2]; objects[0] = realEstateVo; objects[1] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }
public List <RealEstateVo> GetRealEstateTransactions(string accountId) { List <RealEstateVo> realEstateTransactionsList = null; RealEstateVo realEstateVo = new RealEstateVo(); Database db; DbCommand getRealEstateTransactionsCmd; DataSet dsGetRealEstateTransactions; DataTable dtGetRealEstateTransactions; try { db = DatabaseFactory.CreateDatabase("wealtherp"); getRealEstateTransactionsCmd = db.GetStoredProcCommand("getCustomerRealEstateTransactions"); db.AddInParameter(getRealEstateTransactionsCmd, "@CA_AccountId", DbType.String, accountId.ToString()); dsGetRealEstateTransactions = db.ExecuteDataSet(getRealEstateTransactionsCmd); if (dsGetRealEstateTransactions.Tables[0].Rows.Count > 0) { dtGetRealEstateTransactions = dsGetRealEstateTransactions.Tables[0]; realEstateTransactionsList = new List <RealEstateVo>(); foreach (DataRow dr in dtGetRealEstateTransactions.Rows) { realEstateVo = new RealEstateVo(); realEstateVo.TransactionId = dr["CIRET_TransactionId"].ToString(); realEstateVo.Name = dr["CIRET_Name"].ToString(); realEstateVo.InvestmentCode = dr["IC_InvestmentCode"].ToString(); realEstateVo.BuySell = dr["CIRET_BuySell"].ToString(); realEstateVo.TransactionDate = DateTime.Parse(dr["CIRET_TransactionDate"].ToString()); realEstateVo.Quantity = float.Parse(dr["CIRET_Quantity"].ToString()); realEstateVo.TransactionRate = float.Parse(dr["CIRET_TransactionRate"].ToString()); realEstateVo.MeasureCode = dr["IC_MeasurCode"].ToString(); realEstateTransactionsList.Add(realEstateVo); } } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "RealEstateDao.cs:GetRealEstateTransactions()"); object[] objects = new object[1]; objects[0] = accountId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(realEstateTransactionsList); }
public bool CreateRealEstateTransaction(RealEstateVo realEstateVo, string userId) { bool bResult = false; Database db; DbCommand createRealEstateTransaction; try { db = DatabaseFactory.CreateDatabase("wealtherp"); createRealEstateTransaction = db.GetStoredProcCommand("createRealEstateTransaction"); db.AddInParameter(createRealEstateTransaction, "@CIRET_TransactionId", DbType.String, realEstateVo.TransactionId); db.AddInParameter(createRealEstateTransaction, "@CIRET_Name", DbType.String, realEstateVo.Name); db.AddInParameter(createRealEstateTransaction, "@IC_InvestmentCode", DbType.String, realEstateVo.InvestmentCode); db.AddInParameter(createRealEstateTransaction, "@CIRET_TransactionDate", DbType.DateTime, realEstateVo.TransactionDate); db.AddInParameter(createRealEstateTransaction, "@CIRET_Quantity", DbType.Decimal, realEstateVo.Quantity); db.AddInParameter(createRealEstateTransaction, "@CIRET_TransactionRate", DbType.Decimal, realEstateVo.TransactionRate); db.AddInParameter(createRealEstateTransaction, "@CA_AccountId", DbType.String, realEstateVo.AccountId); db.AddInParameter(createRealEstateTransaction, "@IC_MeasurCode", DbType.String, realEstateVo.MeasureCode); db.AddInParameter(createRealEstateTransaction, "@CIRET_BuySell", DbType.String, realEstateVo.BuySell); db.AddInParameter(createRealEstateTransaction, "@CIRET_CreatedBy", DbType.String, userId); db.AddInParameter(createRealEstateTransaction, "@CIRET_ModifiedBy", DbType.String, userId); if (db.ExecuteNonQuery(createRealEstateTransaction) != 0) { bResult = true; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "RealEstateDao.cs:CreateRealEstateTransaction()"); object[] objects = new object[2]; objects[0] = realEstateVo; objects[1] = userId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(bResult); }