// Used by Win Service - Upload Result
//public Customer GetCustomerbyFilterforanEvent(string firstName, string lastName, DateTime? dob, long eventid)
//{
// var customers = _customerRepository.GetCustomerByFilters(firstName, lastName, 0, 0, string.Empty, string.Empty, null, string.Empty);
// var selectedCustomers = customers.FindAll(customer => customer.DateOfBirth.HasValue && (dob == null || (dob != null && customer.DateOfBirth.Value.Date == dob.Value.Date)));
// Customer customerForEvent = null;
// if (!selectedCustomers.IsNullOrEmpty())
// {
// selectedCustomers.ForEach(customer =>
// {
// var isCustomerRegistered = _eventCustomerService.IsCustomerRegisteredfortheGivenEvent(customer.CustomerId, eventid);
// if (isCustomerRegistered) customerForEvent = customer;
// });
// }
// return customerForEvent;
//}
public void MarkProspectCustomerConverted(long eventCustomerId)
{
var prospectCustomer = GetProspectCustomer(eventCustomerId);
if (prospectCustomer == null)
{
return;
}
prospectCustomer.IsConverted = true;
prospectCustomer.Status = (long)ProspectCustomerConversionStatus.Converted;
prospectCustomer.ConvertedOnDate = DateTime.Now;
_uniqueItemProspectCustomerRepository.Save(prospectCustomer);
}
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);
}
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);
}
private OrderDetail GetRefunTypeOrderLineItem(decimal amount, string reasonForRefund, long orderId, long customerId, long processedbyOrgRoleUserId)
{
var dataRecorder = new DataRecorderMetaData(processedbyOrgRoleUserId, DateTime.Now, null);
var refund = new Refund()
{
DataRecorderMetaData = dataRecorder,
Notes = reasonForRefund,
RefundReason = RefundReason.ProcessedRefundRequest,
Price = amount
};
refund = _refundRepository.Save(refund);
OrderItem orderItem = _orderItemRepository.SaveOrderItem(refund.Id, OrderItemType.RefundItem);
var orderDetail = new OrderDetail()
{
DataRecorderMetaData = dataRecorder,
Description = reasonForRefund,
DetailType = OrderItemType.RefundItem,
ForOrganizationRoleUserId = customerId,
OrderId = orderId,
OrderItemId = orderItem.Id,
OrderItemStatus =
(new OrderItemStatusFactory()).CreateOrderItemStatus(
OrderItemType.RefundItem, RefundItemStatus.Applied.StatusCode),
Price = amount,
Quantity = 1
};
return(orderDetail);
}
private void SaveFileInfoForCsvUpload(HealthPlanCallQueueCriteriaEditModel model, HealthPlanCallQueueCriteria criteria)
{
if (!model.UploadFileName.IsNullOrEmpty())
{
var file = new FileInfo(_mediaRepository.GetTempMediaFileLocation().PhysicalPath + model.UploadFileName);
var files = new File
{
Path = file.Name,
FileSize = file.Length,
Type = FileType.Csv,
UploadedBy = new OrganizationRoleUser(_sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId),
UploadedOn = file.CreationTime,
IsArchived = false
};
files = _fileRepository.Save(files);
var healthPlanCriteriaAssignmentUpload = new HealthPlanCriteriaAssignmentUpload
{
FileId = files.Id,
UploadTime = file.CreationTime,
UploadedByOrgRoleUserId = _sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId,
CriteriaId = criteria.Id
};
_healthPlanCriteriaAssignmentUploadRepository.Save(healthPlanCriteriaAssignmentUpload);
model.UploadFileName = null;
System.IO.File.Copy(_mediaRepository.GetTempMediaFileLocation().PhysicalPath + file.Name, _mediaRepository.GetMassAgentAssignmentUploadMediaFileLocation().PhysicalPath + file.Name);
}
}
public ProspectCustomer SaveProspectCustomer(ProspectCustomer prospectCustomer)
{
long prospectCustomerId = prospectCustomer.Id;
if (prospectCustomer.Id > 0 && prospectCustomer.CreatedOn == DateTime.MinValue)
{
prospectCustomer.CreatedOn = DateTime.Now;
}
prospectCustomer = _uniqueItemRepository.Save(prospectCustomer);
// If this is a new prospect customer, track this conversion.)
if (prospectCustomerId == 0)
{
long clickId = 0;
HttpCookie clickIdCookie = Context.Request.Cookies["advertiserClick"];
if (clickIdCookie != null)
{
long.TryParse(clickIdCookie.Value, out clickId);
}
// if there's a click ID, save which click caused the conversion to a prospective customer, and their prospect ID
if (clickId > 0)
{
IClickConversionRepository clickConversionRepository = new ClickConversionRepository();
clickConversionRepository.SaveProspectConversion(clickId, prospectCustomer.Id);
}
}
return(prospectCustomer);
}
private void SavePackage(PackageEditModel model)
{
Package packageinDb = null;
IEnumerable <PackageTest> packageTestsinDb = null;
var package = Mapper.Map <PackageEditModel, Package>(model);
if (model.ForOrderDisplayFile != null)
{
model.ForOrderDisplayFile = _fileRepository.Save(model.ForOrderDisplayFile);
package.ForOrderDisplayFileId = model.ForOrderDisplayFile.Id;
}
if (package.Id > 0)
{
packageinDb = _packageRepository.GetById(package.Id);
packageTestsinDb = _packageTestRepository.GetbyPackageId(package.Id);
package.DataRecorderMetaData = packageinDb.DataRecorderMetaData;
package.DataRecorderMetaData.DateModified = DateTime.Now;
package.DataRecorderMetaData.DataRecorderModifier = new OrganizationRoleUser(_sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId);
}
else
{
package.DataRecorderMetaData = new DataRecorderMetaData(_sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId, DateTime.Now, null);
}
using (var scope = new TransactionScope())
{
package = ((IUniqueItemRepository <Package>)_packageRepository).Save(package);
_packageRepository.SaveRolesforGivenPackageAvailability(package.Id, model.SelectedRoles);
if (model.SelectedTests != null && model.SelectedTests.Count() > 0)
{
var packageTests =
Mapper.Map <IEnumerable <PackageTestEditModel>, IEnumerable <PackageTest> >(model.SelectedTests);
foreach (var test in packageTests)
{
PackageTest packageTestInDb = null;
if (packageTestsinDb != null && packageTestsinDb.Count() > 0)
{
packageTestInDb = packageTestsinDb.Where(pt => pt.TestId == test.TestId).SingleOrDefault();
}
test.PackageId = package.Id;
if (packageTestInDb != null)
{
test.DateModified = DateTime.Now;
test.DateCreated = packageTestInDb.DateCreated;
}
else
{
test.DateCreated = DateTime.Now;
}
}
packageTests = _packageTestRepository.Save(packageTests);
}
scope.Complete();
}
}
private void UploadLoincFiles(IEnumerable <string> sourceFiles, string uploadMediaLocation, long typeId)
{
foreach (var sourceFile in sourceFiles)
{
try
{
using (var scope = new TransactionScope())
{
var fileName = Path.GetFileName(sourceFile);
var destinationFile = uploadMediaLocation + fileName;
System.IO.File.Move(sourceFile, destinationFile);
var fileInfo = new FileInfo(destinationFile);
var file = _fileRepository.Save(new File
{
Path = fileInfo.Name,
FileSize = fileInfo.Length,
Type = FileType.Csv,
UploadedBy = new OrganizationRoleUser(1),
UploadedOn = DateTime.Now
});
_outboundUploadRepository.Save(new OutboundUpload
{
FileId = file.Id,
TypeId = typeId,
StatusId = (long)OutboundUploadStatus.Pending,
UploadTime = DateTime.Now
});
scope.Complete();
}
}
catch (Exception exception)
{
_logger.Info("some exception occured while Moving File type : " + ((OutboundUploadType)typeId).GetDescription() + " and file name : " + sourceFile);
_logger.Info("message " + exception.Message);
_logger.Info("stack Trace " + exception.StackTrace);
}
}
}
public ProspectCustomerEditModel SaveProspectCustomer(ProspectCustomerEditModel model)
{
//since guid is unavailable for this screen , OnlineRequestStatus is set to valid directly.
var onlineRequestValidationModel = new OnlineRequestValidationModel()
{
RequestStatus = OnlineRequestStatus.Valid
};
model.RequestValidationModel = onlineRequestValidationModel;
if (onlineRequestValidationModel.RequestStatus != OnlineRequestStatus.Valid)
{
return(model);
}
var prospectCustomer = Mapper.Map <ProspectCustomerEditModel, ProspectCustomer>(model);
prospectCustomer.CreatedOn = DateTime.Now;
_prospectCustomerRepository.Save(prospectCustomer);
return(model);
}
private void UpdateProspectCustomer(TempCart tempCart, Customer customer)
{
if (tempCart.ProspectCustomerId.HasValue)
{
var prospectCustomer = _prospectCustomerRepository.GetById(tempCart.ProspectCustomerId.Value);
prospectCustomer.CustomerId = customer.CustomerId;
prospectCustomer.Tag = ProspectCustomerTag.OnlineSignup;
prospectCustomer.IsConverted = true;
prospectCustomer.Status = (long)ProspectCustomerConversionStatus.Converted;
prospectCustomer.ConvertedOnDate = DateTime.Now;
prospectCustomer.Address.StreetAddressLine1 = customer.Address.StreetAddressLine1;
prospectCustomer.Address.StreetAddressLine2 = customer.Address.StreetAddressLine2;
prospectCustomer.Address.City = customer.Address.City;
prospectCustomer.Address.State = _stateRepository.GetState(customer.Address.StateId).Name;
prospectCustomer.Address.ZipCode.Zip = customer.Address.ZipCode.Zip;
prospectCustomer.TagUpdateDate = DateTime.Now;
_prospectCustomerRepository.Save(prospectCustomer);
}
else
{
var prospectCustomer = ((IProspectCustomerRepository)_prospectCustomerRepository).GetProspectCustomerByCustomerId(customer.CustomerId);
if (prospectCustomer != null)
{
prospectCustomer.CustomerId = customer.CustomerId;
prospectCustomer.Tag = ProspectCustomerTag.OnlineSignup;
prospectCustomer.IsConverted = true;
prospectCustomer.Status = (long)ProspectCustomerConversionStatus.Converted;
prospectCustomer.ConvertedOnDate = DateTime.Now;
prospectCustomer.Address.StreetAddressLine1 = customer.Address.StreetAddressLine1;
prospectCustomer.Address.StreetAddressLine2 = customer.Address.StreetAddressLine2;
prospectCustomer.Address.City = customer.Address.City;
prospectCustomer.Address.State = _stateRepository.GetState(customer.Address.StateId).Name;
prospectCustomer.Address.ZipCode.Zip = customer.Address.ZipCode.Zip;
prospectCustomer.TagUpdateDate = DateTime.Now;
_prospectCustomerRepository.Save(prospectCustomer);
}
}
}
public JsonResult CreateResultArchive(string fileName, long fileSize)
{
var file = new File
{
Path = fileName,
Type = FileType.Compressed,
FileSize = fileSize,
UploadedBy = new OrganizationRoleUser(_session.UserSession.CurrentOrganizationRole.OrganizationRoleUserId),
UploadedOn = DateTime.Now
};
file = _fileRepository.Save(file);
var rapsUpload = new RapsUpload
{
FileId = file.Id,
UploadTime = DateTime.Now,
StatusId = (long)RapsUploadStatus.UploadStarted,
UploadedBy = _session.UserSession.CurrentOrganizationRole.OrganizationRoleUserId
};
rapsUpload = _rapsUploadRepository.Save(rapsUpload);
//update the file name
file.Path = _fileHelper.AddPostFixToFileName(file.Path, rapsUpload.Id.ToString());
_fileRepository.Save(file);
var editModel = new RapsFileUploadEditModel
{
File = file,
Id = rapsUpload.Id
};
return(Json(editModel, JsonRequestBehavior.AllowGet));
}
private UserLoginLog SaveLoginInfo(long userid, string sessionId, string deviceKey)
{
var userLoginLog = new UserLoginLog
{
UserId = userid,
LogInDateTime = DateTime.Now,
BrowserSession = sessionId,
BrowserName = " ",
SessionIP = ((HttpContextWrapper)Request.Properties["MS_HttpContext"]).Request.UserHostAddress,
DeviceKey = deviceKey,
RefferedUrl = Request.RequestUri
};
return(_uniqueItemRepository.Save(userLoginLog));
}
public Testimonial SaveTestimonial(Testimonial testimonial)
{
using (var transaction = new TransactionScope())
{
File file = null;
if (testimonial.TestimonialVideo != null)
{
file = _fileRepository.Save(testimonial.TestimonialVideo);
testimonial.TestimonialVideo.Id = file.Id;
}
testimonial = Save(testimonial);
testimonial.TestimonialVideo = file;
transaction.Complete();
return(testimonial);
}
}
public UserLoginLog SaveLoginInfo(long userId, string userName, string browserSessionId, string browserName, string sessionIp, Uri refferedUrl)
{
var userLoginLog = new UserLoginLog
{
UserId = userId,
LogInDateTime = DateTime.Now,
BrowserSession = browserSessionId,
BrowserName = browserName,
SessionIP = sessionIp,
RefferedUrl = refferedUrl
};
_singleSessionHelper.CreateAndStoreSessionToken(userName, browserSessionId);
return(_uniqueItemRepository.Save(userLoginLog));
}
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);
}
}
private File SaveLogFile(string logFilePath, StringBuilder csvStringBuilder)
{
WriteCsv(logFilePath, csvStringBuilder);
var failedRecords = new FileInfo(logFilePath);
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);
}
private void SaveFile(ExportableReportsQueue exportableReportsQueue, string fileName)
{
var filePath = _exportableMediaLocation.PhysicalPath + fileName;
var fileInfo = new FileInfo(filePath);
var file = new File
{
Path = fileName,
FileSize = fileInfo.Length,
Type = FileType.Compressed,
UploadedBy = new OrganizationRoleUser(exportableReportsQueue.RequestedBy),
UploadedOn = DateTime.Now
};
file = _fileRepository.Save(file);
exportableReportsQueue.FileId = file.Id;
UpdateExportReportEndTimeAndStaus(exportableReportsQueue, (long)ExportableReportStatus.Completed);
}
public CustomerCallNotes SaveCustomerNotes(long customerId, long eventId, string notes, long createdByOrgRoleUserId, CustomerRegistrationNotesType notesType, long?reasonId = null)
{
var customerRegistrationNotes = new CustomerCallNotes
{
CustomerId = customerId,
EventId = eventId > 0 ? eventId : (long?)null,
Notes = notes,
NotesType = notesType,
ReasonId = reasonId,
DataRecorderMetaData = new DataRecorderMetaData
{
DateCreated = DateTime.Now,
DataRecorderCreator = new OrganizationRoleUser(createdByOrgRoleUserId)
}
};
customerRegistrationNotes = _customerNotesRepository.Save(customerRegistrationNotes);
return(customerRegistrationNotes);
}
private void SaveRegistrationNotes(long customerId, string notes, long organizationRoleUserId)
{
if (customerId <= 0)
{
return;
}
var customerRegistrationNotes = new CustomerCallNotes
{
CustomerId = customerId,
EventId = null,
Notes = notes,
NotesType = CustomerRegistrationNotesType.AppointmentNote,
DataRecorderMetaData = new DataRecorderMetaData
{
DateCreated = DateTime.Now,
DataRecorderCreator = new OrganizationRoleUser(organizationRoleUserId)
}
};
_customerCallNotesRepository.Save(customerRegistrationNotes);
}
private void UpdateStaffScheduleUploadDetail(StaffEventScheduleUpload staffEventScheduleUploadDomain, List <StaffEventScheduleUploadLogViewModel> failedRecordsList, string fileName,
IEnumerable <StaffEventScheduleUploadLog> staffEventScheduleUploadLogCollection)
{
if (failedRecordsList.Any())
{
try
{
var location = _mediaRepository.GetStaffScheduleUploadMediaFileLocation();
var failedFilePath = location.PhysicalPath + Path.GetFileNameWithoutExtension(fileName) + "_Failed.csv";
var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <StaffEventScheduleUploadLogViewModel>();
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);
staffEventScheduleUploadDomain.FailedUploadCount = failedRecordsList.Count();
staffEventScheduleUploadDomain.LogFileId = file.Id;
if (!staffEventScheduleUploadLogCollection.IsNullOrEmpty())
{
staffEventScheduleUploadLogCollection.ForEach(x => x.UploadId = staffEventScheduleUploadDomain.Id);
_staffEventScheduleUploadLogRepository.Save(staffEventScheduleUploadLogCollection);
}
}
catch (Exception ex)
{
_logger.Error("Exception Raised while creating failed records CSV\n message: " + ex.Message + " stacktrace: " + ex.StackTrace);
}
}
_staffEventScheduleUploadRepository.Save(staffEventScheduleUploadDomain);
}
private void UpdateRapsUploadDetail(RapsUpload rapsUpload, List <RapsUploadLog> failedCustomerList, string fileName)
{
if (failedCustomerList.Any())
{
try
{
var location = _mediaRepository.GetRapsUploadMediaFileLocation();
var failedFilePath = location.PhysicalPath + Path.GetFileNameWithoutExtension(fileName) + "_FailedRaps.csv";
var modelData = Mapper.Map <IEnumerable <RapsUploadLog>, IEnumerable <RapsUploadLogViewModel> >(failedCustomerList);
var exporter = ExportableDataGeneratorProcessManager <ViewModelBase, ModelFilterBase> .GetCsvExporter <RapsUploadLogViewModel>();
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);
rapsUpload.FailedUploadCount = failedCustomerList.Count();
rapsUpload.LogFileId = file.Id;
}
catch (Exception ex)
{
_logger.Error("exception Raised While Creating Failed Customer Records \n message: " + ex.Message + " stack trace: " + ex.StackTrace);
}
}
_rapsUploadRepository.Save(rapsUpload);
}
private Core.Application.Domain.File SaveSignatureImage(string signatureBytes, long orgRoleUserId, MediaLocation signatureLocation, string fileName)
{
var filePath = Path.Combine(signatureLocation.PhysicalPath, fileName);
var imageBytes = Convert.FromBase64String(signatureBytes);
File.WriteAllBytes(filePath, imageBytes);
var fileInfo = new FileInfo(filePath);
var file = new Core.Application.Domain.File
{
Path = fileName,
FileSize = fileInfo.Length,
Type = FileType.Image,
UploadedBy = new OrganizationRoleUser(orgRoleUserId),
UploadedOn = DateTime.Now
};
file = _fileRepository.Save(file);
return(file);
}
public void SavePodDefaultTeamTester()
{
var podDefaultTeam = _repository.Save(_podDefaultTeam);
Assert.IsNull(podDefaultTeam);
}
public ActionResult Upload(SuspectConditionFileUploadEditModel model, HttpPostedFileBase suspectConditionUploadFile)
{
if (Request.Files.Count < 1 || suspectConditionUploadFile == null)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("No file has been uploaded. Please upload a csv file.");
return(View(model));
}
var uploadMediaLocation = _mediaRepository.GetSuspectConditionUploadMediaFileLocation();
model.SampleCsvMediaUrl = _mediaRepository.GetSamplesLocation().Url;
HttpPostedFileBase file = Request.Files[0];
var physicalPath = uploadMediaLocation.PhysicalPath;
var fileUploadedName = (Path.GetFileNameWithoutExtension(file.FileName) + Path.GetExtension(file.FileName)).Replace("'", "").Replace("&", "");
var fileName = (Path.GetFileNameWithoutExtension(fileUploadedName) + "_" + DateTime.Now.ToString("MMddyyyyhhmmss") + Path.GetExtension(fileUploadedName)).Replace("'", "").Replace("&", "");
var fullPath = physicalPath + fileName;
file.SaveAs(fullPath);
var csvReader = IoC.Resolve <ICsvReader>();
var customerTable = csvReader.ReadWithTextQualifier(fullPath);
if (customerTable.Rows.Count == 0)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Uploaded file has no data.");
return(View(model));
}
var columns = customerTable.Columns.Cast <DataColumn>().Select(x => x.ColumnName).ToArray();
var missingColumnNames = _suspectConditionUploadHelper.CheckForColumns(columns);
if (!string.IsNullOrEmpty(missingColumnNames))
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Missing Column Name(s) : " + missingColumnNames);
return(View(model));
}
var files = new Core.Application.Domain.File
{
Path = fileName,
FileSize = file.ContentLength,
Type = FileType.Csv,
UploadedBy = new OrganizationRoleUser(_session.UserSession.CurrentOrganizationRole.OrganizationRoleUserId),
UploadedOn = DateTime.Now
};
files = _fileRepository.Save(files);
var suspectConditionUpload = new SuspectConditionUpload
{
FileId = files.Id,
UploadTime = DateTime.Now,
StatusId = (long)SuspectConditionUploadStatus.UploadStarted,
UploadedBy = _session.UserSession.CurrentOrganizationRole.OrganizationRoleUserId,
TotalCount = customerTable.Rows.Count,
ParseStartTime = DateTime.Now
};
suspectConditionUpload = _suspectConditionUploadRepository.Save(suspectConditionUpload);
model.TotalRecords = customerTable.Rows.Count;
model.IsUploadSucceded = true;
model.IsParseSucceded = false;
model.FileName = fileName;
model.FailedRecordsFile = Path.GetFileNameWithoutExtension(fileName) + "_Failed" + ".csv";
if (suspectConditionUpload != null && suspectConditionUpload.Id > 0)
{
model.SuspectConditionUploadId = suspectConditionUpload.Id;
}
var failureRecords = uploadMediaLocation.PhysicalPath + model.FailedRecordsFile;
_suspectConditionUploadHelper.CreateHeaderFileRecord(failureRecords, customerTable);
return(View(model));
}
public void SavePersistsNewGiftCertificate()
{
GiftCertificate persistedGiftCertificate = _repository.Save(_giftCertificate);
Assert.AreEqual(_giftCertificate.Amount, persistedGiftCertificate.Amount);
}
public ActionResult Upload(CallUploadEditModel model)
{
var uploadMediaLocation = _mediaRepository.GetCallUploadMediaFileLocation();
model.UploadCsvMediaUrl = uploadMediaLocation.Url;
HttpPostedFileBase postedFile = Request.Files[0];
if (postedFile == null || postedFile.ContentLength < 1)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("No file has been uploaded. Please upload a csv file.");
return(View(model));
}
if (System.IO.Path.GetExtension(postedFile.FileName).ToLower() != ".csv")
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Please upload a csv file!");
return(View(model));
}
var physicalPath = uploadMediaLocation.PhysicalPath;
var fileContent = System.IO.Path.GetFileNameWithoutExtension(postedFile.FileName) + "_" + DateTime.Now.ToString("MMddyyyyhhmmss") + System.IO.Path.GetExtension(postedFile.FileName);
var fullPath = physicalPath + fileContent;
postedFile.SaveAs(fullPath);
var customerTable = _csvReader.ReadWithTextQualifier(fullPath);
if (customerTable.Rows.Count == 0)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Uploaded file has no data.");
return(View(model));
}
var missingColumnNames = _callUploadHelper.CheckForColumns(customerTable.Rows[0]);
if (!string.IsNullOrEmpty(missingColumnNames))
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Missing Column Name(s) : " + missingColumnNames);
return(View(model));
}
var file = new File
{
Path = fileContent,
FileSize = postedFile.ContentLength,
Type = FileType.Csv,
UploadedBy = new OrganizationRoleUser(_session.UserSession.CurrentOrganizationRole.OrganizationRoleUserId),
UploadedOn = DateTime.Now
};
file = _fileRepository.Save(file);
var callUpload = new CallUpload
{
FileId = file.Id,
UploadTime = DateTime.Now,
StatusId = (long)CallUploadStatus.Uploaded,
UploadedBy = _session.UserSession.CurrentOrganizationRole.OrganizationRoleUserId
};
callUpload = _callUploadRepository.Save(callUpload);
if (callUpload != null && callUpload.Id > 0)
{
model.FeedbackMessage = FeedbackMessageModel.CreateSuccessMessage("File Uploaded Successfull.");
}
return(View(model));
}
private Core.Application.Domain.File UploadFile(string sourceFile)
{
var files = CreateFileModel(sourceFile);
return(_fileRepository.Save(files));
}
public ActionResult Index(HttpPostedFileBase phoneNumberFileUpload)
{
var uploadDateTime = DateTime.Now;
var fileUploadName = @"PhoneNumberUpdate_" + uploadDateTime.ToString("yyyyMMddHHmmss") + "_" + _sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId + ".csv";
long uploadStatus = (long)PhoneNumberUploadStatus.FileNotFound;
var model = new CustomerPhoneNumberUpdateUploadViewModel();
model.FeedbackMessage = new FeedbackMessageModel();
HttpPostedFileBase file = Request.Files[0];
var tempMediaFileLocation = _mediaRepository.GetTempMediaFileLocation(); //will store file at Temp location first
var uploadMediaFileLocation = _mediaRepository.GetCustomerPhoneNumberUploadLocation();
var physicalPath = tempMediaFileLocation.PhysicalPath;
var fullpath = physicalPath + fileUploadName;
try
{
// we set uploadStatus as "FileNotFound" to indicate only UI error message , no DB logging
if (Request.Files.Count != 1 || phoneNumberFileUpload == null)
{
uploadStatus = (long)PhoneNumberUploadStatus.FileNotFound;
throw new Exception("No file has been uploaded. Please upload a csv file.");
}
var fileExtension = file.FileName.Split('.');
if ((fileExtension.Length >= 2 && fileExtension[fileExtension.Length - 1].ToLower() != "csv") || fileExtension.Length < 2)
{
uploadStatus = (long)PhoneNumberUploadStatus.FileNotFound;
throw new Exception("Uploaded file is not in CSV format");
}
try
{
file.SaveAs(fullpath);
}
catch (Exception)
{
uploadStatus = (long)PhoneNumberUploadStatus.UploadFailed;
throw;
}
var phoneNumberTable = _csvReader.ReadWithTextQualifier(fullpath);
System.IO.File.Copy(fullpath, uploadMediaFileLocation.PhysicalPath + fileUploadName);
//fullpath = uploadMediaFileLocation.PhysicalPath + fileUploadName;
if (phoneNumberTable.Rows.Count == 0)
{
uploadStatus = (long)PhoneNumberUploadStatus.FileNotFound;
throw new Exception("Uploaded file has no data");
}
var columns = phoneNumberTable.Columns.Cast <DataColumn>().Select(x => x.ColumnName).ToArray();
var missingColumnNames = _phoneNumberUpdateUploadHelper.CheckAllColumnExist(columns);
if (!string.IsNullOrEmpty(missingColumnNames))
{
uploadStatus = (long)PhoneNumberUploadStatus.FileNotFound;
var customString = missingColumnNames.Replace(PhoneNumberUpdateUploadLogColumn.CustomerId, "Customer Id")
.Replace(PhoneNumberUpdateUploadLogColumn.FirstName, "First Name").Replace(PhoneNumberUpdateUploadLogColumn.LastName, "Last Name")
.Replace(PhoneNumberUpdateUploadLogColumn.MemberId, "Member Id").Replace(PhoneNumberUpdateUploadLogColumn.PhoneNumber, "New Phone Number")
.Replace(PhoneNumberUpdateUploadLogColumn.PhoneType, "Phone Type").Replace(PhoneNumberUpdateUploadLogColumn.DOB, "Dob");
throw new Exception("Missing Column Name(s):" + customString);
}
var files = new File
{
Path = fileUploadName,
FileSize = file.ContentLength,
Type = FileType.Csv,
UploadedBy = new OrganizationRoleUser(_sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId),
UploadedOn = DateTime.Now,
IsArchived = false
};
files = _fileRepository.Save(files);
var customerPhoneNumberUpdateUpload = new CustomerPhoneNumberUpdateUpload
{
FileId = files.Id,
StatusId = (long)PhoneNumberUploadStatus.Uploaded,
SuccessUploadCount = 0,
FailedUploadCount = 0,
UploadTime = uploadDateTime,
ParseStartTime = null,
ParseEndTime = null,
UploadedByOrgRoleUserId = _sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId,
LogFileId = null
};
_customerPhoneNumberUpdateUploadRepository.Save(customerPhoneNumberUpdateUpload);
}
catch (Exception ex)
{
model.FeedbackMessage.MessageType = UserInterfaceMessageType.Error;
model.FeedbackMessage.Message = ex.Message;
if (uploadStatus == (long)PhoneNumberUploadStatus.UploadFailed)
{
model.FeedbackMessage.Message = "Upload Failed";
}
return(View("Index", model));
}
model.FeedbackMessage.Message = "Upload Success";
return(View("Index", model));
}
public ActionResult Create(PodEditModel podEditModel)
{
try
{
podEditModel.Territories = _territoryRepository.GetAllTerritoriesIdNamePair(TerritoryType.Pod);
podEditModel.Tests = _testRepository.GetAll();
if (ModelState.IsValid)
{
var pod = Mapper.Map <PodEditModel, Pod>(podEditModel);
pod.DataRecorderMetaData = new DataRecorderMetaData()
{
DataRecorderCreator = Mapper.Map <OrganizationRoleUserModel, OrganizationRoleUser>(_sessionContext.UserSession.CurrentOrganizationRole),
DateCreated = DateTime.Now
};
using (var scope = new TransactionScope())
{
pod = _podRepository.Save(pod);
var podTeam = new List <PodStaff>();
podEditModel.DefaultStaffAssigned.ToList().ForEach(dsa =>
{
var teamMember = Mapper.Map <PodStaffEditModel, PodStaff>(dsa);
teamMember.PodId = pod.Id;
teamMember.DataRecorderMetaData = new DataRecorderMetaData
{
DataRecorderCreator = Mapper.Map <OrganizationRoleUserModel, OrganizationRoleUser>(_sessionContext.UserSession.CurrentOrganizationRole),
DateCreated = DateTime.Now
};
podTeam.Add(teamMember);
});
if (!podEditModel.AssignedTerritories.IsNullOrEmpty())
{
((IPodRepository)_podRepository).SavePodTerritories(podEditModel.AssignedTerritories,
pod.Id);
}
// Need to check the DefaultPodTeam Issue.
podTeam = _podStaffAssignmentRepository.SaveMultiple(podTeam, pod.Id).ToList();
_podService.SavePodRooms(podEditModel.Rooms, pod.Id);
scope.Complete();
}
var newModel = new PodEditModel(_territoryRepository, _testRepository);
newModel.FeedbackMessage =
FeedbackMessageModel.CreateSuccessMessage(
"The POD information was saved successfully. You can add more PODs or close this page.");
return(View(newModel));
}
return(View(podEditModel));
}
catch (Exception exception)
{
podEditModel.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("System Error:" + exception);
return(View(podEditModel));
}
}
public ActionResult ScheduleUpload(HttpPostedFileBase scheduleUploadFile)
{
var model = new StaffEventScheduleUploadViewModel
{
FeedbackMessage = new FeedbackMessageModel(),
SampleCsvMediaUrl = _mediaRepository.GetSamplesLocation().Url + "StaffEventScheduleUploadSample.csv"
};
try
{
if (Request.Files.Count < 1 || scheduleUploadFile == null)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("No file has been uploaded. Please upload a csv file.");
return(View(model));
}
HttpPostedFileBase file = Request.Files[0];
var fileExtension = file.FileName.Split('.');
if ((fileExtension.Length >= 2 && fileExtension[fileExtension.Length - 1].ToLower() != "csv") || fileExtension.Length < 2)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("File uploaded is not a CSV");
return(View(model));
}
var uploadMediaLocation = _mediaRepository.GetStaffScheduleUploadMediaFileLocation();
var physicalPath = uploadMediaLocation.PhysicalPath;
var fileUploadedName = (Path.GetFileNameWithoutExtension(file.FileName) + Path.GetExtension(file.FileName)).Replace("'", "").Replace("&", "");
var fileName = (Path.GetFileNameWithoutExtension(fileUploadedName) + "_" + DateTime.Now.ToString("MMddyyyyhhmmss") + Path.GetExtension(fileUploadedName)).Replace("'", "").Replace("&", "");
var fullPath = physicalPath + fileName;
try
{
file.SaveAs(fullPath);
}
catch (Exception ex)
{
_logger.Error(string.Format("Staff Event Schedule Upload\nException occurred while saving file on server. FileName:{0} Path: {1}", fileUploadedName, fullPath));
_logger.Error(string.Format("Exception message: {0}\n\tStackTrace:{1}", ex.Message, ex.StackTrace));
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Some internal error occurred");
return(View(model));
}
var staffScheduleTable = _csvReader.ReadWithTextQualifier(fullPath);
if (staffScheduleTable.Rows.Count == 0)
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Uploaded file has no data.");
return(View(model));
}
var columns = staffScheduleTable.Columns.Cast <DataColumn>().Select(x => x.ColumnName).ToArray();
var missingColumnNames = CheckAllScheduleUploadColumnExist(columns);
if (!string.IsNullOrEmpty(missingColumnNames))
{
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Missing Column Name(s) : " + missingColumnNames);
return(View(model));
}
var files = new File
{
Path = fileName,
FileSize = file.ContentLength,
Type = FileType.Csv,
UploadedBy = new OrganizationRoleUser(_sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId),
UploadedOn = DateTime.Now
};
try
{
files = _fileRepository.Save(files);
}
catch (Exception ex)
{
_logger.Error(string.Format("Staff Event Schedule Upload\nException occurred while saving info in File table."));
_logger.Error(string.Format("Exception message: {0}\n\tStackTrace:{1}", ex.Message, ex.StackTrace));
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Some internal error occurred");
return(View(model));
}
var staffAssignmentUpload = new StaffEventScheduleUpload
{
FileId = files.Id,
UploadTime = DateTime.Now,
UploadedByOrgRoleUserId = _sessionContext.UserSession.CurrentOrganizationRole.OrganizationRoleUserId,
StatusId = (long)StaffEventScheduleParseStatus.Uploaded
};
try
{
staffAssignmentUpload = _staffEventScheduleUploadRepository.Save(staffAssignmentUpload);
}
catch (Exception ex)
{
_logger.Error(string.Format("Staff Event Schedule Upload\nException occurred while saving info in StaffEventScheduleUpload."));
_logger.Error(string.Format("Exception message: {0}\n\tStackTrace:{1}", ex.Message, ex.StackTrace));
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Some internal error occurred");
return(View(model));
}
if (staffAssignmentUpload != null && staffAssignmentUpload.Id > 0)
{
ModelState.Clear();
return(RedirectToAction("ScheduleUpload", "Schedule", new { message = "File uploaded successfully" }));
}
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("File upload failed");
return(View(model));
}
catch (Exception ex)
{
_logger.Error(string.Format("Staff Event Schedule Upload\nException occurred"));
_logger.Error(string.Format("Exception message: {0}\n\tStackTrace:{1}", ex.Message, ex.StackTrace));
model.FeedbackMessage = FeedbackMessageModel.CreateFailureMessage("Some internal error occurred");
return(View(model));
}
}
