private bool GenerateReport(string destinationFolder, string fileName, GiftCertificateReportFilter filter) { var completePath = Path.Combine(destinationFolder, fileName); var dataGen = new ExportableDataGenerator <GiftCertificateReportOptumViewModel, GiftCertificateReportFilter>(_giftCerificateOptumReportService.GetGiftCertificateOptumReport, _logger); var model = dataGen.GetData(filter); if (model != null && !model.Collection.IsNullOrEmpty()) { _logger.Info("Writing Gift Certificate Report"); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <GiftCertificateReportOptumViewModel>(); _logger.Info("Record count" + model.Collection.Count()); DirectoryOperationsHelper.CreateDirectoryIfNotExist(destinationFolder); DirectoryOperationsHelper.DeleteFileIfExist(completePath); _baseExportableReportHelper.GenerateCsv(completePath, exporter, model.Collection); _logger.Info("completed Gift Certificate Report for account tag " + filter.Tag); _logger.Info("Destination Path: " + completePath); return(true); } return(false); }
private long GenerateFailedCustomerLogFile(IEnumerable <MergeCustomerUploadLog> failedCustomerList, string fileName) { try { var location = _mediaRepository.GetMergeCustomerUploadMediaFileLocation(); var failedFilePath = location.PhysicalPath + Path.GetFileNameWithoutExtension(fileName) + "_FailedCustomer.csv"; var modelData = Mapper.Map <IEnumerable <MergeCustomerUploadLog>, IEnumerable <MergeCustomerUploadLogViewModel> >(failedCustomerList); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <MergeCustomerUploadLogViewModel>(); WriteCsv(failedFilePath, exporter, modelData); var failedRecords = new FileInfo(failedFilePath); var file = new File { Path = failedRecords.Name, FileSize = failedRecords.Length, Type = FileType.Csv, UploadedBy = new OrganizationRoleUser(1), UploadedOn = DateTime.Now }; file = _fileRepository.Save(file); return(file.Id); } catch (Exception ex) { _logger.Error("Error while creating failed customers log file \n message: " + ex.Message + " stacktrace: " + ex.StackTrace); } return(0); }
public void CdImageStatusAsync(string id = null, CdImageStatusModelFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <CdImageStatusModel, CdImageStatusModelFilter>( _operationsReportingService.GetCdImageStatusmodel); var processmanager = new ExportableDataGeneratorProcessManager <CdImageStatusModel, CdImageStatusModelFilter>(); processmanager.Add(id, dataGen); Task.Factory.StartNew(() => { AsyncManager.Parameters["id"] = id; try { AsyncManager.Parameters["model"] = dataGen.GetData(filter); } catch (Exception) { AsyncManager.Parameters["model"] = null; } AsyncManager.OutstandingOperations.Decrement(); Thread.Sleep(5000); }); }
private void UpdateEligibilityUploadDetail(EligibilityUpload eligibilityUploadDomain, List <EligibilityUploadLogViewModel> failedRecordsList, string fileName) { if (failedRecordsList.Any()) { try { var location = _mediaRepository.GetEligibilityUploadMediaFileLocation(); var failedFilePath = location.PhysicalPath + Path.GetFileNameWithoutExtension(fileName) + "_Failed.csv"; var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <EligibilityUploadLogViewModel>(); WriteCsv(failedFilePath, exporter, failedRecordsList); var failedRecords = new FileInfo(failedFilePath); var file = new File { Path = failedRecords.Name, FileSize = failedRecords.Length, Type = FileType.Csv, UploadedBy = new OrganizationRoleUser(1), UploadedOn = DateTime.Now }; file = _fileRepository.Save(file); eligibilityUploadDomain.FailedUploadCount = failedRecordsList.Count(); eligibilityUploadDomain.LogFileId = file.Id; } catch (Exception ex) { _logger.Error("Exception Raised while creating failed records CSV\n message: " + ex.Message + " stacktrace: " + ex.StackTrace); } } _eligibilityUploadRepository.Save(eligibilityUploadDomain); }
public string CustomerScheduleExport(CustomerScheduleModelFilter filter, long userId) { var fileName = GetExportableFileName("CustomerSchedule"); var csvFilePath = Path.Combine(ExportableMediaLocation.PhysicalPath, fileName); var dataGen = new ExportableDataGenerator <EventCustomerScheduleModel, CustomerScheduleModelFilter>(_eventCustomerReportingService.GetCustomerScheduleModel, Logger); var model = dataGen.GetData(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <CustomerScheduleModel>(); var csvStringBuilder = _customerScheduleCsvHelper.GetPatientScheduledReport(model.Collection, exporter); var request = new GenericReportRequest { CsvFilePath = csvFilePath, Model = csvStringBuilder.ToString() }; var isGenerated = _baseReportService.GetResponse(request); if (!isGenerated) { return("CSV File Export failed!"); } return(_baseReportService.DownloadZipFile(ExportableMediaLocation, fileName, userId, Logger)); }
public string CallSkippedReportExport(CallSkippedReportFilter filter, long userId) { var dataGen = new ExportableDataGenerator <CallSkippedReportViewModel, CallSkippedReportFilter>(_callSkippedReportService.GetCallSkippedReport, Logger); var model = dataGen.GetData(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <CallSkippedReportViewModel>(); return(WriteCsv(GetExportableFileName("CallSkippedReport"), exporter, model.Collection, userId)); }
public string ExcludedCusomerReportExport(OutboundCallQueueFilter filter, long userId) { var dataGen = new ExportableDataGenerator <GmsExcludedCustomerViewModel, OutboundCallQueueFilter>(_excludedCustomerService.GetExcludedCustomers, Logger); var model = dataGen.GetData(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <GmsExcludedCustomerViewModel>(); return(WriteCsv(GetExportableFileName("ExcludedCustomerReport"), exporter, model.Collection, userId)); }
public string CustomerWithNoEventsInAreaReportExport(CustomerWithNoEventsInAreaReportModelFilter filter, long userId) { var dataGen = new ExportableDataGenerator <CustomerWithNoEventsInAreaReportModel, CustomerWithNoEventsInAreaReportModelFilter>(_callQueueService.GetCustomerWithNoEventsInArea, Logger); var model = dataGen.GetData(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <CustomerWithNoEventsInAreaReportModel>(); return(WriteCsv(GetExportableFileName("CustomerWithNoEventsInAreaReport"), exporter, model.Collection, userId)); }
public string DisqualifiedTestReportExport(DisqualifiedTestReportFilter filter, long userId) { var dataGen = new ExportableDataGenerator <DisqualifiedTestReportViewModel, DisqualifiedTestReportFilter>(_eventCustomerQuestionAnswerServcie.GetDisqualifiedTestReport, Logger); var model = dataGen.GetData(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <DisqualifiedTestReportViewModel>(); return(WriteCsv(GetExportableFileName("DisqualifiedTestReport"), exporter, model.Collection, userId)); }
public string PcpTrackingReportExport(PcpTrackingReportFilter pcpTrackingReportFilter, long userId) { var dataGen = new ExportableDataGenerator <PcpTrackingReportViewModel, PcpTrackingReportFilter>(_pcpTrackingReportService.GetPcpTrackingReport, Logger); var model = dataGen.GetData(pcpTrackingReportFilter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <PcpTrackingReportViewModel>(); return(WriteCsv(GetExportableFileName("PcpTrackingReport"), exporter, model.Collection, userId)); }
public string TestBookedReportExport(TestsBookedListModelFilter filter, long userId) { var dataGen = new ExportableDataGenerator <TestsBookedModel, TestsBookedListModelFilter>(_eventCustomerReportingService.GetTestsBooked, Logger); var model = dataGen.GetData(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <TestsBookedModel>(); return(WriteCsv(GetExportableFileName("TestBookedReport"), exporter, model.Collection, userId)); }
public string EventArchiveStatsExport(EventArchiveStatsFilter filter, long userId) { var dataGen = new ExportableDataGenerator <EventArchiveStatsViewModel, EventArchiveStatsFilter>(_eventArchiveStatsService.GetEventArchiveStats, Logger); var model = dataGen.GetData(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <EventArchiveStatsViewModel>(); return(WriteCsv(GetExportableFileName("EventArchiveStats"), exporter, model.Collection, userId)); }
private void MemberReportForCustomerNoTags(CorporateAccount account, DateTime dateFrom, DateTime dateTo, string directoryPath, IEnumerable <long> shippintOptionId) { var fileName = string.Format("MemberReport_{0}.csv", dateTo.ToString("yyyyMMdd")); var tagToExlude = new List <string>(); if (!_bcbsMiGapPatinetTags.IsNullOrEmpty()) { tagToExlude.AddRange(_bcbsMiGapPatinetTags); } if (!_bcbsMiRiskPatientTags.IsNullOrEmpty()) { tagToExlude.AddRange(_bcbsMiRiskPatientTags); } var filter = new MemberResultMailedReportFilter { DateFrom = dateFrom, DateTo = dateTo, HealthPlanId = account.Id, CustomTags = tagToExlude.ToArray(), ExcludeCustomerWithCustomTag = true, ShippingOptions = shippintOptionId, Tag = account.Tag }; _logger.Info("Generating MemberReport for " + account.Tag); var dataGen = new ExportableDataGenerator <BcbsMiMemberResultMailedReportViewModel, MemberResultMailedReportFilter>(_bcbsMiMemberResultMailedReportService.GetBcbsMiMemberResultMailedReport, _logger); var model = dataGen.GetData(filter); if (model != null && !model.Collection.IsNullOrEmpty()) { var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <BcbsMiMemberResultMailedReportViewModel>(); _logger.Info("Record count" + model.Collection.Count()); if (File.Exists(directoryPath + fileName)) { File.Delete(directoryPath + fileName); } _baseExportableReportHelper.GenerateCsv(directoryPath + fileName, exporter, model.Collection); _logger.Info("Destination file " + directoryPath + fileName); } else { _logger.Info("No Record Found for Tag" + account.Tag); } _logger.Info("Completed MemberReport for " + account.Tag); }
public string CallQueueCustomersReportExport(OutboundCallQueueFilter filter, long userId) { var dataGen = new ExportableDataGenerator <CallQueueCustomersReportModel, OutboundCallQueueFilter>(_callQueueCustomerReportService.GetCallQueueCustomers, Logger); var model = dataGen.GetData(filter); var listModel = model as CallQueueCustomersReportModelListModel; listModel = listModel ?? new CallQueueCustomersReportModelListModel(); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <CallQueueCustomersReportModel>(); var fileName = "CallQueueCustomers_" + listModel.HealthPlanName + "_" + listModel.CallQueueName + (model.Filter.EventId > 0 ? "_" + listModel.Filter.EventId : ""); return(WriteCsv(GetExportableFileName(fileName), exporter, model.Collection, userId)); }
public void PollForDiabeticRetinopathyParserlog() { try { if (DateTime.Today.DayOfWeek != _dayOfWeek) { _logger.Info(string.Format("todays day : {0}, export set to run on {1}", DateTime.Today.DayOfWeek, _dayOfWeek)); return; } var fromDate = DateTime.Today.AddDays(-1 * _numberOfDays); var toDate = DateTime.Today; _logger.Info("Diabetic Retinopathy Parser Log Report Started"); var filter = new DiabeticRetinopathyParserlogListModelFilter { DateFrom = fromDate, DateTo = toDate }; _logger.Info(string.Format("Generating report for filter diabetic retinopathy parser log : DateFrom: {0}, DateTo {1} ", filter.DateFrom, filter.DateTo)); var dataGen = new ExportableDataGenerator <DiabeticRetinopathyParserlogViewModel, DiabeticRetinopathyParserlogListModelFilter>(_diabeticRetinopathyParserlogService.GetDiabeticRetinopathyParserlog, _logger); var model = dataGen.GetData(filter); if (model != null) { var fileName = GetCsvFileName(filter); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <DiabeticRetinopathyParserlogViewModel>(); if (model.Collection != null && model.Collection.Any()) { _baseExportableReportHelper.GenerateCsv(fileName, exporter, model.Collection); } } _logger.Info(string.Format("Report Generation Completed. ")); } catch (Exception ex) { _logger.Error("Some Error Exception Occured while Generating Report"); _logger.Error("Message: " + ex.Message); _logger.Error("StackTrace: " + ex.StackTrace); _logger.Error(string.Format("Report Generation Completed ")); } }
public void StaffEventScheduleAsync(string id = null, EventStaffAssignmentListModelFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); filter.UserSessionModel = _sessionContext.UserSession; //used to make filter var dataGen = new ExportableDataGenerator <StaffEventSchedulingModel, EventStaffAssignmentListModelFilter>(_staffEventScheduleExportService.GetStaffScheduleForCsvExport); var processmanager = new ExportableDataGeneratorProcessManager <StaffEventSchedulingModel, EventStaffAssignmentListModelFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void ExcludedCustomersAsync(string id = null, OutboundCallQueueFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <GmsExcludedCustomerViewModel, OutboundCallQueueFilter>(_gmsExcludedCustomerService.GetExcludedCustomers); var processmanager = new ExportableDataGeneratorProcessManager <GmsExcludedCustomerViewModel, OutboundCallQueueFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void PreAssessmentReportAsync(string id = null, PreAssessmentReportFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <PreAssessmentReportViewModel, PreAssessmentReportFilter>(_preAssessmentReportingService.GetPreAssessmentReport); var processmanager = new ExportableDataGeneratorProcessManager <PreAssessmentReportViewModel, PreAssessmentReportFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void OutreachCallReportAsync(string id = null, OutreachCallReportModelFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <OutreachCallReportModel, OutreachCallReportModelFilter>(_callQueueService.GetOutreachCallReport); var processmanager = new ExportableDataGeneratorProcessManager <OutreachCallReportModel, OutreachCallReportModelFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void AgentConversionReportAsync(string id = null, AgentConversionReportFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <AgentConversionReportViewModel, AgentConversionReportFilter>(_callCenterReportService.GetAgentConversionReport); var processmanager = new ExportableDataGeneratorProcessManager <AgentConversionReportViewModel, AgentConversionReportFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void SearchHospitalFacilityEventsAsync(string id = null, HospitalPartnerEventListModelFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <HospitalPartnerEventViewModel, HospitalPartnerEventListModelFilter>(_hospitalPartnerService.GetHospitalFacilityEvents); var processmanager = new ExportableDataGeneratorProcessManager <HospitalPartnerEventViewModel, HospitalPartnerEventListModelFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void CallQueueSchedulingReportAsync(string id = null, CallQueueSchedulingReportFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <CallQueueSchedulingReportModel, CallQueueSchedulingReportFilter>(_callCenterReportService.GetHealthPlanCallQueueReport); var processmanager = new ExportableDataGeneratorProcessManager <CallQueueSchedulingReportModel, CallQueueSchedulingReportFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
// // GET: /Users/ExportableReports/ public void GetUserListAsync(string id = null, UserListModelFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <UserBasicInfoModel, UserListModelFilter>(_usersListModelRepository.GetUserListModelPaged); var processmanager = new ExportableDataGeneratorProcessManager <UserBasicInfoModel, UserListModelFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void CustomerAggregateResultSummaryAsync(string id = null, HospitalPartnerCustomerListModelFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <HospitalPartnerCustomerViewModel, HospitalPartnerCustomerListModelFilter>( _hospitalPartnerService.GetCustomerAggregateResultSummary, _logger); var processmanager = new ExportableDataGeneratorProcessManager <HospitalPartnerCustomerViewModel, HospitalPartnerCustomerListModelFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
public void ProspectCustomerAbandonedReportAsync(string id = null, ProspectCustomerListModelFilter filter = null) { if (id == null) { return; } AsyncManager.OutstandingOperations.Increment(); var dataGen = new ExportableDataGenerator <ProspectCustomerBasicInfoModel, ProspectCustomerListModelFilter>( _prospectCustomerService.GetAbandonedCustomers); var processmanager = new ExportableDataGeneratorProcessManager <ProspectCustomerBasicInfoModel, ProspectCustomerListModelFilter>(); processmanager.Add(id, dataGen); GetNewProcessStarted(filter, dataGen, id); }
private void UpdateMedicationUploadDetail(MedicationUpload medicationUpload, IReadOnlyCollection <MedicationUploadLog> failedRecordsList, string fileName) { if (failedRecordsList.Any()) { try { var location = _mediaRepository.GetMedicationUploadMediaFileLocation(); var failedFilePath = location.PhysicalPath + Path.GetFileNameWithoutExtension(fileName) + "_Failed.csv"; var modelData = Mapper.Map <IEnumerable <MedicationUploadLog>, IEnumerable <MedicationUploadLogViewModel> >(failedRecordsList); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <MedicationUploadLogViewModel>(); WriteCsv(failedFilePath, exporter, modelData); var failedRecords = new FileInfo(failedFilePath); var file = new File { Path = failedRecords.Name, FileSize = failedRecords.Length, Type = FileType.Csv, UploadedBy = new OrganizationRoleUser(1), UploadedOn = DateTime.Now }; file = _fileRepository.Save(file); medicationUpload.FailedUploadCount = failedRecordsList.Count(); medicationUpload.LogFileId = file.Id; } catch (Exception ex) { _logger.Error("Exception raised while creating failed customer records \n Message: " + ex.Message + "\n\tStack trace: " + ex.StackTrace); } } try { _medicationUploadRepository.Save(medicationUpload); } catch (Exception ex) { _logger.Error("Exception raised while saving medicationUpload \n Message: " + ex.Message + "\n\tStack trace: " + ex.StackTrace); } }
public ActionResult StaffEventScheduleCompleted(string id, StaffEventSchedulingListModel model) { if (id == null) { return(Content("Model can't be null.")); } if (model == null || model.Collection == null || !model.Collection.Any()) { return(Content("Model can't be null.")); } RemoveProcess(id); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <StaffEventSchedulingModel>(); var message = WriteCsv("StaffEventSchedule.csv", exporter, model.Collection, RequestSubcriberChannelNames.StaffEventAssignmentExportQueue, RequestSubcriberChannelNames.StaffEventAssignmentExportChannel); return(Content(message)); }
private void GenerateTestNotPerformedCsvByFilter(TestNotPerformedListModelFilter filter, CorporateAccount healthPlan) { _logger.Info(string.Format("Generating Report for filter : EventDateFrom: {0}, EventDateTo {1}, HealthPlanId {2} ", filter.EventDateFrom, filter.EventDateTo, filter.HealthPlanId)); var dataGen = new ExportableDataGenerator <TestNotPerformedViewModel, TestNotPerformedListModelFilter>(_testNotPerformedService.GetTestNotPerformed, _logger); var model = dataGen.GetData(filter); if (model != null) { var fileName = GetCsvFileName(filter, healthPlan); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <TestNotPerformedViewModel>(); if (model.Collection != null && model.Collection.Any()) { _baseExportableReportHelper.GenerateCsv(fileName, exporter, model.Collection); } } }
public ActionResult CdImageStatusCompleted(string id, CdImageStatusListModel model) { if (id == null) { return(Content("Model can't be null.")); } if (model == null || model.Collection == null || model.Collection.Count() < 1) { return(Content("Model can't be null.")); } RemoveProcess(id); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <CdImageStatusModel>(); var message = WriteCsv("CdImageStatus.csv", exporter, model.Collection, RequestSubcriberChannelNames.CdImageStatusQueue, RequestSubcriberChannelNames.CdImageStatusChannel); return(Content(message)); }
private void GenerateMemberStatusListCsvByFilter(MemberStatusListModelFilter filter, CorporateAccount account) { _logger.Info(string.Format("Generating Member Status Report for filter : Tag {0}", filter.Tag)); var dataGen = new ExportableDataGenerator <MemberStatusModel, MemberStatusListModelFilter>(_eventCustomerReportingService.GetMemberStatusReport, _logger); var model = dataGen.GetData(filter); if (model != null) { var fileName = GetCsvFileName(account); var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <MemberStatusModel>(); if (model.Collection != null && model.Collection.Any()) { _baseExportableReportHelper.GenerateCsv(fileName, exporter, model.Collection); } } }