public CustomerPhoneNumberListModel Create(IEnumerable <FileModel> fileModels, IEnumerable <CustomerPhoneNumberUpdateUpload> phoneNumberUploads, IEnumerable <OrderedPair <long, string> > uploadedbyAgentNameIdPair)
{
var model = new CustomerPhoneNumberListModel();
var collection = new List <CustomerPhoneNumberUpdateUploadViewModel>();
foreach (var phoneNumberUpload in phoneNumberUploads)
{
var agentName = "N/A";
if (uploadedbyAgentNameIdPair != null && uploadedbyAgentNameIdPair.Any())
{
agentName = uploadedbyAgentNameIdPair.Single(ap => ap.FirstValue == phoneNumberUpload.UploadedByOrgRoleUserId).SecondValue;
}
var successFile = (from f in fileModels where f.Id == phoneNumberUpload.FileId select f).Single();
FileModel failedFile = null;
if (phoneNumberUpload.LogFileId.HasValue)
{
failedFile = (from f in fileModels where f.Id == phoneNumberUpload.LogFileId select f).Single();
}
var customerPhoneNumberUpdateUploadViewModel = new CustomerPhoneNumberUpdateUploadViewModel
{
File = successFile,
SuccessfullCustomer = phoneNumberUpload.SuccessUploadCount,
FailedCustomer = phoneNumberUpload.FailedUploadCount,
UploadTime = phoneNumberUpload.UploadTime,
FailedFile = failedFile,
Status = ((PhoneNumberUploadStatus)phoneNumberUpload.StatusId).GetDescription(),
UploadedBy = agentName,
};
collection.Add(customerPhoneNumberUpdateUploadViewModel);
}
model.Collection = collection;
return(model);
}
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));
}
