public IDictionary <string, string> UpdateTransactOrder(DataTable OnlineBondOrder, OnlineBondOrderVo OnlineBondOrderVo, int adviserId, int IssuerId, int OrderId, int seriesId) { IDictionary <string, string> OrderIds = new Dictionary <string, string>(); bool result = false; try { OrderIds = onlineBondDao.UpdateTransactOrder(OnlineBondOrder, OnlineBondOrderVo, adviserId, IssuerId, OrderId, seriesId); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "OnlineBondOrderBo.cs:onlineBOndtransact(OnlineBondOrderVo OnlineBondOrder)"); object[] objects = new object[1]; objects[0] = OnlineBondOrder; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(OrderIds); }
public IDictionary <string, string> CreateOfflineBondTransact(DataTable BondORder, int adviserId, OnlineBondOrderVo OnlineBondVo, int agentId, string agentCode, int userId, int EmpId) { //List<int> orderIds = new List<int>(); IDictionary <string, string> OrderIds = new Dictionary <string, string>(); Database db; DbCommand cmdOfflineBondTransact; try { DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt = BondORder.Copy(); ds.Tables.Add(dt); String sb; sb = ds.GetXml().ToString(); db = DatabaseFactory.CreateDatabase("wealtherp"); cmdOfflineBondTransact = db.GetStoredProcCommand("SPROC_OFF_OfflineBondTransaction"); db.AddInParameter(cmdOfflineBondTransact, "@xmlBondsOrder", DbType.Xml, sb); db.AddInParameter(cmdOfflineBondTransact, "@AdviserId", DbType.Int32, adviserId); db.AddInParameter(cmdOfflineBondTransact, "@AgentId", DbType.Int32, agentId); db.AddInParameter(cmdOfflineBondTransact, "@AgentCode", DbType.String, agentCode); db.AddInParameter(cmdOfflineBondTransact, "@UserId", DbType.Int32, userId); db.AddOutParameter(cmdOfflineBondTransact, "@Order_Id", DbType.Int32, 10); db.AddOutParameter(cmdOfflineBondTransact, "@application", DbType.Int32, 10); db.AddOutParameter(cmdOfflineBondTransact, "@aplicationNoStatus", DbType.String, 10); db.AddInParameter(cmdOfflineBondTransact, "@CustomerName", DbType.String, OnlineBondVo.CustomerName); db.AddInParameter(cmdOfflineBondTransact, "@CustomerPAN", DbType.String, OnlineBondVo.PanNo); db.AddInParameter(cmdOfflineBondTransact, "@CustomerType", DbType.String, OnlineBondVo.CustomerType); db.AddInParameter(cmdOfflineBondTransact, "@CustomerSubTypeId", DbType.Int32, OnlineBondVo.CustomerSubTypeId); db.AddInParameter(cmdOfflineBondTransact, "@DematBeneficiaryAccountNum", DbType.String, OnlineBondVo.DematBeneficiaryAccountNum); db.AddInParameter(cmdOfflineBondTransact, "@DematDepositoryName", DbType.String, OnlineBondVo.DematDepositoryName); db.AddInParameter(cmdOfflineBondTransact, "@DematDPId", DbType.String, OnlineBondVo.DematDPId); db.AddInParameter(cmdOfflineBondTransact, "@customerBankAccountID", DbType.Double, OnlineBondVo.BankAccountNo); db.AddInParameter(cmdOfflineBondTransact, "@EmpId", DbType.Int32, EmpId); if (db.ExecuteNonQuery(cmdOfflineBondTransact) != 0) { OrderIds.Add("Order_Id", db.GetParameterValue(cmdOfflineBondTransact, "Order_Id").ToString()); OrderIds.Add("application", db.GetParameterValue(cmdOfflineBondTransact, "application").ToString()); OrderIds.Add("aplicationNoStatus", db.GetParameterValue(cmdOfflineBondTransact, "aplicationNoStatus").ToString()); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "OnlineBondOrderDao.cs:UpdateOnlineBondTransact(VoOnlineOrderManagemnet.OnlineBondOrderVo BondORder)"); object[] objects = new object[1]; objects[0] = BondORder; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(OrderIds); }
public IDictionary <string, string> UpdateTransactOrder(DataTable BondORder, OnlineBondOrderVo OnlineBondOrderVo, int adviserId, int IssuerId, int OrderId, int seriesId) { IDictionary <string, string> OrderIds = new Dictionary <string, string>(); Database db; DbCommand cmdOnlineBondTransact; //bool result = false; try { db = DatabaseFactory.CreateDatabase("wealtherp"); cmdOnlineBondTransact = db.GetStoredProcCommand("SPROC_ONL_UpdateTransactOrder"); DataSet ds = new DataSet(); ds.Tables.Add(BondORder); String sb; sb = ds.GetXml().ToString(); db.AddInParameter(cmdOnlineBondTransact, "@xmlBondsOrder", DbType.Xml, sb); db.AddInParameter(cmdOnlineBondTransact, "@AdviserId", DbType.Int32, adviserId); db.AddInParameter(cmdOnlineBondTransact, "@IssuerId", DbType.Int32, IssuerId); db.AddInParameter(cmdOnlineBondTransact, "@orderId", DbType.Int32, OrderId); db.AddInParameter(cmdOnlineBondTransact, "@seriesId", DbType.Int32, seriesId); db.AddInParameter(cmdOnlineBondTransact, "@Quantity", DbType.Int32, OnlineBondOrderVo.Qty); db.AddInParameter(cmdOnlineBondTransact, "@Amount", DbType.Int32, OnlineBondOrderVo.Amount); //db.AddInParameter(cmdOnlineBondTransact, "@tenure", DbType.Int32, DBNull.Value); //db.AddInParameter(cmdOnlineBondTransact, "@MatDate", DbType.DateTime, DBNull.Value); db.AddOutParameter(cmdOnlineBondTransact, "@Order_Id", DbType.Int32, 10000); //db.AddInParameter(cmdOnlineBondTransact, "@CustomerId", DbType.String, BondORder.CustomerId); //db.AddInParameter(cmdOnlineBondTransact, "@PFISM_SchemeId", DbType.Int32, BondORder.PFISM_SchemeId); //db.AddInParameter(cmdOnlineBondTransact, "@PFISD_SeriesId", DbType.Int32, BondORder.PFISD_SeriesId); //db.AddInParameter(cmdOnlineBondTransact, "@PFIIM_IssuerId", DbType.String, BondORder.PFIIM_IssuerId); //db.AddInParameter(cmdOnlineBondTransact, "@Qty", DbType.Int32, BondORder.Qty); //db.AddInParameter(cmdOnlineBondTransact, "@Amount", DbType.Double, BondORder.Amount); //db.AddInParameter(cmdOnlineBondTransact, "@BankAccid", DbType.Double, BondORder.BankAccid); //db.ExecuteNonQuery(cmdOnlineBondTransact); //result = true; if (db.ExecuteNonQuery(cmdOnlineBondTransact) != 0) { OrderIds.Add("OrderId", db.GetParameterValue(cmdOnlineBondTransact, "Order_Id").ToString()); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "OnlineBondOrderDao.cs:UpdateOnlineBondTransact(VoOnlineOrderManagemnet.OnlineBondOrderVo BondORder)"); object[] objects = new object[1]; objects[0] = BondORder; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(OrderIds); }
public IDictionary <string, string> OfflineBOndtransact(DataTable OnlineBondOrder, int adviserId, OnlineBondOrderVo OnlineBondVo, int agentId, string agentCode, int userId, int EmpId) { IDictionary <string, string> OrderIds = new Dictionary <string, string>(); OfflineBondOrderDao offlineBondDao = new OfflineBondOrderDao(); //bool result = false; //int orderIds = 0; try { OrderIds = offlineBondDao.CreateOfflineBondTransact(OnlineBondOrder, adviserId, OnlineBondVo, agentId, agentCode, userId, EmpId); } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "OnlineBondOrderBo.cs:onlineBOndtransact(OnlineBondOrderVo OnlineBondOrder)"); object[] objects = new object[1]; objects[0] = OnlineBondOrder; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } return(OrderIds); }
public bool UpdateNCDDetails(int orderid, int userid, DataTable dtOrderDetails, string brokerCode, int agentId, OnlineBondOrderVo OnlineBondOrderVo, int EmpId) { Microsoft.Practices.EnterpriseLibrary.Data.Database db; DbCommand UpdateNCDDetailscmd; bool bResult = false; DataSet dsUpdateUpdateNCDDetails = new DataSet(); try { dsUpdateUpdateNCDDetails.Tables.Add(dtOrderDetails.Copy()); dsUpdateUpdateNCDDetails.DataSetName = "dtOrderDetailseDS"; dsUpdateUpdateNCDDetails.Tables[0].TableName = "dtOrderDetailsDT"; db = DatabaseFactory.CreateDatabase("wealtherp"); UpdateNCDDetailscmd = db.GetStoredProcCommand("SPROC_UpdateNCDOrder"); db.AddInParameter(UpdateNCDDetailscmd, "@xmlBondsOrder", DbType.Xml, dsUpdateUpdateNCDDetails.GetXml().ToString()); db.AddInParameter(UpdateNCDDetailscmd, "@orderId", DbType.Int32, orderid); db.AddInParameter(UpdateNCDDetailscmd, "@UserId", DbType.Int32, userid); db.AddInParameter(UpdateNCDDetailscmd, "@brokerCode", DbType.String, brokerCode); db.AddInParameter(UpdateNCDDetailscmd, "@AgentId", DbType.Int32, agentId); db.AddInParameter(UpdateNCDDetailscmd, "@CustomerName", DbType.String, OnlineBondOrderVo.CustomerName); db.AddInParameter(UpdateNCDDetailscmd, "@CustomerPAN", DbType.String, OnlineBondOrderVo.PanNo); db.AddInParameter(UpdateNCDDetailscmd, "@CustomerType", DbType.String, OnlineBondOrderVo.CustomerType); //db.AddInParameter(UpdateNCDDetailscmd, "@CustomerSubTypeId", DbType.Int32, OnlineBondOrderVo.CustomerSubTypeId); db.AddInParameter(UpdateNCDDetailscmd, "@DematBeneficiaryAccountNum", DbType.String, OnlineBondOrderVo.DematBeneficiaryAccountNum); db.AddInParameter(UpdateNCDDetailscmd, "@DematDepositoryName", DbType.String, OnlineBondOrderVo.DematDepositoryName); db.AddInParameter(UpdateNCDDetailscmd, "@DematDPId", DbType.String, OnlineBondOrderVo.DematDPId); db.AddInParameter(UpdateNCDDetailscmd, "@AID_Sequence", DbType.Int32, OnlineBondOrderVo.PFISM_SchemeId); db.AddInParameter(UpdateNCDDetailscmd, "@customerbankAccId", DbType.Int64, OnlineBondOrderVo.BankAccountNo); db.AddInParameter(UpdateNCDDetailscmd, "@EmpId", DbType.Int32, EmpId); db.ExecuteNonQuery(UpdateNCDDetailscmd); bResult = true; } catch (BaseApplicationException Ex) { throw Ex; } return(bResult); }
public bool UpdateNCDDetails(int orderid, int userid, DataTable dtOrderDetails, string brokerCode, int agentId, OnlineBondOrderVo OnlineBondOrderVo, int EmpId) { bool result = false; offlineNCDBackOfficeDao = new OfflineNCDIPOBackOfficeDao(); try { result = offlineNCDBackOfficeDao.UpdateNCDDetails(orderid, userid, dtOrderDetails, brokerCode, agentId, OnlineBondOrderVo, EmpId); } catch (BaseApplicationException Ex) { throw Ex; } return(result); }