public bool UpdateIPOBidOrderDetails(DataTable dtIPOBidTransactionDettails, int orderNo, string benificialAcc, string brokerCode, int userId, OnlineIPOOrderVo onlineIPOOrderVo, int EmpId)
{
bool bResult = false;
OfflineIPOOrderDao OfflineIPOOrderDao = new OfflineIPOOrderDao();
try
{
bResult = OfflineIPOOrderDao.UpdateIPOBidOrderDetails(dtIPOBidTransactionDettails, orderNo, benificialAcc, brokerCode, userId, onlineIPOOrderVo, EmpId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(bResult);
}
public int CreateIPOBidOrderDetails(int adviserId, int userId, DataTable dtIPOBidList, OnlineIPOOrderVo onlineIPOOrderVo, ref string applicationNo, ref string apllicationNoStatus)
{
int orderId = 0;
Database db;
DbCommand CreateIPOBidOrderCmd;
DataSet dsIssueBidList = new DataSet();
try
{
dsIssueBidList.Tables.Add(dtIPOBidList.Copy());
dsIssueBidList.DataSetName = "IssueBidsDS";
dsIssueBidList.Tables[0].TableName = "IssueBidsDT";
db = DatabaseFactory.CreateDatabase("wealtherp");
CreateIPOBidOrderCmd = db.GetStoredProcCommand("SPROC_ONL_CreateIPOBidOrderDetails");
db.AddInParameter(CreateIPOBidOrderCmd, "@AdviserId", DbType.Int32, adviserId);
db.AddInParameter(CreateIPOBidOrderCmd, "@UserId", DbType.Int32, userId);
db.AddInParameter(CreateIPOBidOrderCmd, "@C_CustomerId", DbType.Int32, onlineIPOOrderVo.CustomerId);
db.AddInParameter(CreateIPOBidOrderCmd, "@OrderDate", DbType.Date, onlineIPOOrderVo.OrderDate);
db.AddInParameter(CreateIPOBidOrderCmd, "@AIM_IssueId", DbType.Int32, onlineIPOOrderVo.IssueId);
db.AddInParameter(CreateIPOBidOrderCmd, "@PAG_AssetGroupCode", DbType.String, onlineIPOOrderVo.AssetGroup);
db.AddInParameter(CreateIPOBidOrderCmd, "@CO_IsDeclarationAccepted", DbType.Int16, onlineIPOOrderVo.IsDeclarationAccepted?1:0);
db.AddInParameter(CreateIPOBidOrderCmd, "@XMLIPOBids", DbType.Xml, dsIssueBidList.GetXml().ToString());
db.AddOutParameter(CreateIPOBidOrderCmd, "@OrderId", DbType.Int32, 1000000);
db.AddOutParameter(CreateIPOBidOrderCmd, "@ApplicationNo", DbType.String, 1000000);
db.AddOutParameter(CreateIPOBidOrderCmd, "@AplicationNoStatus", DbType.String, 1000000);
if (db.ExecuteNonQuery(CreateIPOBidOrderCmd) != 0)
{
orderId = Convert.ToInt32(db.GetParameterValue(CreateIPOBidOrderCmd, "OrderId").ToString());
applicationNo = db.GetParameterValue(CreateIPOBidOrderCmd, "@ApplicationNo").ToString();
apllicationNoStatus = db.GetParameterValue(CreateIPOBidOrderCmd, "@AplicationNoStatus").ToString();
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "DaoOnlineOrderManagement.cs:CreateIPOBidOrderDetails(int adviserId, int userId, DataTable dtIPOBidList)");
object[] objects = new object[1];
objects[0] = adviserId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(orderId);
}
public int CreateIPOBidOrderDetails(int adviserId, int userId, DataTable dtIPOBidList, OnlineIPOOrderVo onlineIPOOrderVo, int agentId, string agentCode, int EmpId)
{
int orderId = 0;
OfflineIPOOrderDao OfflineIPOOrderDao = new OfflineIPOOrderDao();
try
{
orderId = OfflineIPOOrderDao.CreateIPOBidOrderDetails(adviserId, userId, dtIPOBidList, onlineIPOOrderVo, agentId, agentCode, EmpId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "BoOnlineOrderManagement.cs:CreateIPOBidOrderDetails(int adviserId, int userId, DataTable dtIPOBidList)");
object[] objects = new object[2];
objects[0] = adviserId;
objects[1] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(orderId);
}
public bool UpdateIPOBidOrderDetails(DataTable dtIPOBidTransactionDettails, int orderNo, string benificialAcc, string brokerCode, int userId, OnlineIPOOrderVo onlineIPOOrderVo, int EmpId)
{
Database db;
DataSet dsIssueBidList = new DataSet();;
DbCommand cmdUpdateIPOBidOrderDetails;
bool bResult = false;
int count = 0;
try
{
dsIssueBidList.Tables.Add(dtIPOBidTransactionDettails.Copy());
dsIssueBidList.DataSetName = "IssueBidsDS";
dsIssueBidList.Tables[0].TableName = "IssueBidsDT";
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdUpdateIPOBidOrderDetails = db.GetStoredProcCommand("SPROC_OFF_UpdateIPOBidOrderDetails");
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@XMLIPOBids", DbType.Xml, dsIssueBidList.GetXml().ToString());
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@orderId", DbType.Int32, orderNo);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@benificialAcc", DbType.String, benificialAcc);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@brokerCode", DbType.String, brokerCode);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@UserId", DbType.Int32, userId);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@AgentCode", DbType.String, onlineIPOOrderVo.AgentNo);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@AgentId", DbType.Int32, onlineIPOOrderVo.AgentId);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@CustomerName", DbType.String, onlineIPOOrderVo.CustomerName);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@CustomerPAN", DbType.String, onlineIPOOrderVo.CustomerPAN);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@CustomerType", DbType.String, onlineIPOOrderVo.CustomerType);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@CustomerSubTypeId", DbType.Int32, onlineIPOOrderVo.CustomerSubTypeId);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@DematBeneficiaryAccountNum", DbType.String, onlineIPOOrderVo.DematBeneficiaryAccountNum);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@DematDepositoryName", DbType.String, onlineIPOOrderVo.DematDepositoryName);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@DematDPId", DbType.String, onlineIPOOrderVo.DematDPId);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@customerbankAccId", DbType.Int64, onlineIPOOrderVo.BankAccountNo);
db.AddInParameter(cmdUpdateIPOBidOrderDetails, "@EmpId", DbType.Int64, EmpId);
if (db.ExecuteNonQuery(cmdUpdateIPOBidOrderDetails) != 0)
{
bResult = true;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(bResult);
}
