/// <summary>
/// Create Bulk Report request to Queue
/// </summary>
/// <param name="portfolioIDs"></param>
/// <param name="subreportype"></param>
/// <param name="fromDate"></param>
/// <returns></returns>
public void CreateBulkReportRequest(List <MFReportVo> mfReportVoList, MFReportEmailVo mfReportEmailVo, int parentRequestId, int taskId, int userId)
{
WERPTaskRequestManagementDao requestManagementDao = new WERPTaskRequestManagementDao();
try
{
requestManagementDao.CreateBulkReportRequest(mfReportVoList, mfReportEmailVo, parentRequestId, taskId, userId);
}
catch (BaseApplicationException ex)
{
throw (ex);
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "WERPTaskRequestManagementBo.cs:CreateBulkReportRequest()");
object[] objects = new object[3];
objects[0] = taskId;
objects[1] = userId;
objects[2] = parentRequestId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void ProcessAllCustomerRequest(string customerIds)
{
string[] customerids = customerIds.Split('~');
List <MFReportVo> mfReportVoList = null;
MFReportEmailVo mfReportEmailVo = new MFReportEmailVo();
int customerId = 0;
WERPTaskRequestManagementBo taskRequestManagementBo = new WERPTaskRequestManagementBo();
int parentrequestId = 0;
string[] reportTRange = reportTypeRange.Split('~');
string[] reportTAsON = reportTypeAsOn.Split('~');
try
{
foreach (string arrStr in customerids)
{
mfReportVoList = new List <MFReportVo>();
mfReportEmailVo = new MFReportEmailVo();
customerId = int.Parse(arrStr);
int groupCustomerId = 0;
if (isGroupHead)
{
groupCustomerId = customerId;
}
taskRequestManagementBo.CreateTaskRequest(1, userId, out parentrequestId);
custVo = customerBo.GetCustomer(customerId);
customerRMVo = adviserStaffBo.GetAdvisorStaffDetails(custVo.RmId);
foreach (string str in reportTAsON)
{
mfReportVoList.Add(GetReportInputData(str, customerId, groupCustomerId, ref dtFrom, ref dtTo, ref dtAsOn, "ASON"));
}
foreach (string str in reportTRange)
{
mfReportVoList.Add(GetReportInputData(str, customerId, groupCustomerId, ref dtFrom, ref dtTo, ref dtAsOn, "RANGE"));
}
mfReportEmailVo.AdviserId = adviserId;
mfReportEmailVo.CustomerId = custVo.CustomerId;
mfReportEmailVo.CustomerEmail = custVo.Email;
mfReportEmailVo.RMEmail = customerRMVo.Email;
mfReportEmailVo.ReportTypeName = "Mutual Fund Portfolio Statement";
taskRequestManagementBo.CreateBulkReportRequest(mfReportVoList, mfReportEmailVo, parentrequestId, 1, userId);
}
UpdateTaskRequestRecorder(requestRecorderId, "SUCCESS");
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
UpdateTaskRequestRecorder(requestRecorderId, Ex.Message);
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RequestCreatorBo:ProcessAllCustomerRequest(string customerIds)");
object[] objects = new object[2];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
/// <summary>
/// Create Bulk Report request to Queue
/// </summary>
/// <param name="portfolioIDs"></param>
/// <param name="subreportype"></param>
/// <param name="fromDate"></param>
/// <returns></returns>
public void CreateBulkReportRequest(List <MFReportVo> mfReportVoList, MFReportEmailVo mfReportEmailVo, int parentRequestId, int taskId, int userId)
{
Microsoft.Practices.EnterpriseLibrary.Data.Database db;
DbCommand cmdCreateReportRequest;
try
{
foreach (MFReportVo mfReportVo in mfReportVoList)
{
try
{
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdCreateReportRequest = db.GetStoredProcCommand("SPROC_CreateBulkReportRequest");
db.AddInParameter(cmdCreateReportRequest, "@TaskId", DbType.Int32, taskId);
db.AddInParameter(cmdCreateReportRequest, "@UserId", DbType.Int32, userId);
db.AddInParameter(cmdCreateReportRequest, "@ParentRequestId", DbType.Int32, parentRequestId);
db.AddInParameter(cmdCreateReportRequest, "@ReportName", DbType.String, mfReportVo.ReportName);
db.AddInParameter(cmdCreateReportRequest, "@FromDate", DbType.Date, mfReportVo.FromDate);
db.AddInParameter(cmdCreateReportRequest, "@Todate", DbType.Date, mfReportVo.ToDate);
db.AddInParameter(cmdCreateReportRequest, "@ReportType", DbType.String, mfReportVo.SubType);
db.AddInParameter(cmdCreateReportRequest, "@AdviserId", DbType.Int32, mfReportVo.AdviserId);
db.AddInParameter(cmdCreateReportRequest, "@CustomerId", DbType.Int32, mfReportVo.CustomerId);
db.AddInParameter(cmdCreateReportRequest, "@PortfolioIds", DbType.String, mfReportVo.PortfolioIds);
db.ExecuteNonQuery(cmdCreateReportRequest);
}
catch (BaseApplicationException ex)
{
throw (ex);
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "WERPTaskRequestManagementDao.cs:CreateBulkReportRequest()");
object[] objects = new object[10];
objects[0] = taskId;
objects[1] = userId;
objects[2] = parentRequestId;
objects[3] = mfReportVo.ReportName;
objects[4] = mfReportVo.FromDate;
objects[5] = mfReportVo.ToDate;
objects[6] = mfReportVo.SubType;
objects[7] = mfReportVo.AdviserId;
objects[8] = mfReportVo.CustomerId;
objects[9] = mfReportVo.PortfolioIds;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
db = DatabaseFactory.CreateDatabase("wealtherp");
cmdCreateReportRequest = db.GetStoredProcCommand("SPROC_CreateBulkMailReportRequest");
db.AddInParameter(cmdCreateReportRequest, "@UserId", DbType.Int32, userId);
db.AddInParameter(cmdCreateReportRequest, "@DependentRequestId", DbType.Int32, parentRequestId);
db.AddInParameter(cmdCreateReportRequest, "@ReportTypeName", DbType.String, mfReportEmailVo.ReportTypeName);
db.AddInParameter(cmdCreateReportRequest, "@AdviserId", DbType.Int32, mfReportEmailVo.AdviserId);
db.AddInParameter(cmdCreateReportRequest, "@CustomerId", DbType.Int32, mfReportEmailVo.CustomerId);
db.AddInParameter(cmdCreateReportRequest, "@CustomerEmail", DbType.String, mfReportEmailVo.CustomerEmail);
db.AddInParameter(cmdCreateReportRequest, "@RMEMail", DbType.String, mfReportEmailVo.RMEmail);
db.ExecuteNonQuery(cmdCreateReportRequest);
}
catch (BaseApplicationException ex)
{
throw (ex);
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "WERPTaskRequestManagementDao.cs:CreateBulkReportRequest()");
object[] objects = new object[3];
objects[0] = taskId;
objects[1] = userId;
objects[2] = parentRequestId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
