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