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);
}
