private bool ParseMemberUploadbyAces(string file, CorporateAccount corporateAccount, List <long> customerList, IEnumerable <Language> languages, IEnumerable <Lab> labs)
{
try
{
_logger.Info("Start converting data from CSV to data table :" + DateTime.Now);
var mediaLocation = _mediaRepository.GetMemberUploadbyAcesFolderLocation();
var fileToParse = GetFileName(file, mediaLocation);
var memberData = GetRows(fileToParse);
var corportateUpload = _memberUploadByAcesHelper.Upload(fileToParse, corporateAccount);
if (memberData == null)
{
return(false);
}
var rowCountInFile = memberData.Rows.Count;
_logger.Info("Data coverted from CSV to Data Table :" + DateTime.Now + " & Row count is : " + rowCountInFile);
if (IsAnyColumnMissing(memberData))
{
return(false);
}
//var failedCustomers = new List<MemberUploadbyAcesFailedCustomerModel>();
var adjustOrderCustomer = new List <EventCusomerAdjustOrderViewModel>();
var rows = memberData.AsEnumerable();
var orgRoleUser = new OrganizationRoleUser()
{
Id = OrgRoleUserId, RoleId = OrgRoleId
};
var corporateModel = new CorporateUploadEditModel {
Tag = corporateAccount.Tag, CorporateAccountId = corporateAccount.Id, UploadCorporateId = corportateUpload.Id
};
var accountAdditionalFields = _accountAdditionalFieldRepository.GetAccountAdditionalFieldsEditModelByAccountId(corporateAccount.Id);
var index = 1;
var customerIdWithSameAcesId = new List <CustomerWithDuplicateAcesModel>();
foreach (DataRow row in rows)
{
_logger.Info(index + " out of " + rowCountInFile + " processing");
var customerEditModel = CreateEditModel(row);
if (customerEditModel == null)
{
continue;
}
var sb = new StringBuilder();
try
{
_logger.Info("Record: First Name :" + customerEditModel.FirstName + ", Last Name :" + customerEditModel.LastName + " and ACES Id :" + customerEditModel.AcesId);
var customerWithDuplicateAcesModel = new CustomerWithDuplicateAcesModel();
_corporateUploadService.CorporateUploadDataRow(customerEditModel, languages, labs, null, corporateModel, accountAdditionalFields,
adjustOrderCustomer, orgRoleUser, OrgRoleId, customerList, (long)MemberUploadSource.Aces, sb, corportateUpload.Id, out customerWithDuplicateAcesModel);
if (customerWithDuplicateAcesModel != null && customerWithDuplicateAcesModel.CustomerId > 0)
{
customerIdWithSameAcesId.Add(customerWithDuplicateAcesModel);
}
}
catch (Exception ex)
{
customerEditModel.ErrorMessage = sb.ToString();
if (!string.IsNullOrEmpty(ex.Message))
{
customerEditModel.ErrorMessage += " Error Message: " + ex.Message;
}
_logger.Error("While Saving customer");
_logger.Error(customerEditModel.ErrorMessage);
//var model = _memberUploadbyAcesFailedCustomerFactory.Create(customerEditModel);
//failedCustomers.Add(model);
}
_logger.Info(index + " out of " + rowCountInFile + " completed");
var memberUploadParseDetail = _memberUploadParseDetailFactory.GetDomain(customerEditModel, corportateUpload.Id);
_memberUploadParseDetailRepository.Save(memberUploadParseDetail);
index++;
}
if (!customerIdWithSameAcesId.IsNullOrEmpty())
{
_customerWithDuplicateAcesIdFileGenerator.GenerateCsvFile(corportateUpload.Id, customerIdWithSameAcesId);
}
var failedRecords = _memberUploadParseDetailRepository.GetByCorporateUploadId(corportateUpload.Id, false);
var failedCustomers = _memberUploadParseDetailFactory.GetMemberUploadbyAcesFailedCustomerListModel(failedRecords, corportateUpload.SourceId);
CreateFailedUploadFile(file, mediaLocation, failedCustomers, corportateUpload);
CreateAdjustOrderUploadFile(file, mediaLocation, adjustOrderCustomer, corportateUpload);
corportateUpload.ParseStatus = (int)MemberUploadParseStatus.Start;
corportateUpload = _memberUploadByAcesHelper.UpdateCorporateUpload(corportateUpload, failedCustomers.Count(), rowCountInFile);
if (corportateUpload.SuccessfullUploadCount > 0)
{
_logger.Info("Set IsTermByAbsence is True");
corportateUpload.IsTermByAbsence = true;
_corporateUploadRepository.Save(corportateUpload);
_logger.Info("Publishing: Corporate Upload Id: " + corportateUpload.Id);
_memberTermByAbsencePublisher.PublishCorporateUpload(corportateUpload.Id);
_logger.Info("Publish Successfully: Corporate Upload Id: " + corportateUpload.Id);
}
return(failedCustomers.Any() || accountAdditionalFields.Any() || customerList.Any());
}
catch (Exception ex)
{
_logger.Error(string.Format("Error occurred while processing the {0}.\nMessage: {1}\n\tStackTrace: {2}", file, ex.Message, ex.StackTrace));
return(false);
}
}
