public GuideDetailsResult Handle(GuideDetailsQuery query)
{
GuideDetailsResult guideDetailsResult = new GuideDetailsResult();
try
{
Contracts.DataModels.Redemption.Redemption_GuideDetails GuideDetails = _GuideDetailsRepository.Get(query.GuideId);
Contracts.DataModels.User GuideMaster = _UserRepository.Get(GuideDetails.UserId);
var GuideFinanceMappings = _GuideFinanceMappingsRepository.GetAllByGuideId(GuideDetails.Id);
var GuideServices = _GuideServicesRepository.GetAllByGuideId(GuideDetails.Id);
var GuidePlaceMappings = _GuidePlaceMappingsRepository.GetAllByGuideId(GuideDetails.Id);
var GuideDocumentMappings = _GuideDocumentMappingsRepository.GetAllByGuideId(GuideDetails.Id);
guideDetailsResult.GuideMaster = new GuideMaster();
guideDetailsResult.GuideMaster.emailId = GuideMaster.Email;
guideDetailsResult.GuideMaster.firstName = GuideMaster.FirstName;
guideDetailsResult.GuideMaster.Id = GuideMaster.Id;
guideDetailsResult.GuideMaster.lastName = GuideMaster.LastName;
guideDetailsResult.GuideMaster.phoneCode = GuideMaster.PhoneCode;
guideDetailsResult.GuideMaster.phoneNumber = GuideMaster.PhoneNumber;
guideDetailsResult.GuideMasterDetail = new GuideMasterDetail();
guideDetailsResult.GuideMasterDetail.ApprovedBy = GuideDetails.ApprovedBy;
guideDetailsResult.GuideMasterDetail.ApprovedUtc = GuideDetails.ApprovedUtc;
guideDetailsResult.GuideMasterDetail.ApproveStatusId = GuideDetails.ApproveStatusId;
guideDetailsResult.GuideMasterDetail.Id = GuideDetails.Id;
guideDetailsResult.GuideMasterDetail.IsEnabled = GuideDetails.IsEnabled;
guideDetailsResult.GuideMasterDetail.LanguageId = GuideDetails.LanguageId;
guideDetailsResult.MasterFinanceDetails = new List <MasterFinanceDetails>();
foreach (Contracts.DataModels.Redemption.Redemption_GuideFinanceMappings GuideFinanceMapping in GuideFinanceMappings)
{
Contracts.DataModels.Redemption.MasterFinanceDetails masterFinanceDetails = _MasterFinanceDetailsRepository.Get(GuideFinanceMappings.ToList()[0].MasterFinanceDetailId);
FIL.Contracts.QueryResults.Redemption.MasterFinanceDetails masterFinanceDetail = new MasterFinanceDetails();
masterFinanceDetail.AccountNumber = masterFinanceDetails.AccountNumber;
masterFinanceDetail.AccountTypeId = (int)masterFinanceDetails.AccountTypeId;
masterFinanceDetail.BankAccountTypeId = (int)masterFinanceDetails.BankAccountTypeId;
masterFinanceDetail.BankName = masterFinanceDetails.BankName;
masterFinanceDetail.BranchCode = masterFinanceDetails.BranchCode;
masterFinanceDetail.CountryId = masterFinanceDetails.CountryId;
masterFinanceDetail.CurrenyId = masterFinanceDetails.CurrenyId;
masterFinanceDetail.Id = masterFinanceDetails.Id;
masterFinanceDetail.RoutingNumber = masterFinanceDetails.RoutingNumber;
masterFinanceDetail.StateId = masterFinanceDetails.StateId;
masterFinanceDetail.TaxId = masterFinanceDetails.TaxId;
guideDetailsResult.MasterFinanceDetails.Add(masterFinanceDetail);
}
guideDetailsResult.GuideServices = new List <GuideServices>();
foreach (Contracts.DataModels.Redemption.Redemption_GuideServices GuideService in GuideServices)
{
FIL.Contracts.QueryResults.Redemption.GuideServices obj = new GuideServices();
obj.GuideId = GuideService.GuideId;
obj.Id = GuideService.Id;
obj.IsEnabled = GuideService.IsEnabled;
obj.Notes = GuideService.Notes;
obj.ServiceId = GuideService.ServiceId;
guideDetailsResult.GuideServices.Add(obj);
}
guideDetailsResult.GuidePlaceMappings = new List <GuidePlaceMappings>();
foreach (Contracts.DataModels.Redemption.Redemption_GuidePlaceMappings GuidePlaceMapping in GuidePlaceMappings)
{
FIL.Contracts.QueryResults.Redemption.GuidePlaceMappings obj = new GuidePlaceMappings();
obj.ApprovedBy = GuidePlaceMapping.ApprovedBy;
obj.ApprovedUtc = GuidePlaceMapping.ApprovedUtc;
obj.ApproveStatusId = GuidePlaceMapping.ApproveStatusId;
obj.EventId = GuidePlaceMapping.EventId;
obj.GuideId = GuidePlaceMapping.GuideId;
obj.Id = GuidePlaceMapping.Id;
obj.IsEnabled = GuidePlaceMapping.IsEnabled;
guideDetailsResult.GuidePlaceMappings.Add(obj);
}
guideDetailsResult.GuideDocumentMappings = new List <GuideDocumentMappings>();
foreach (Contracts.DataModels.Redemption.Redemption_GuideDocumentMappings GuideDocumentMapping in GuideDocumentMappings)
{
FIL.Contracts.QueryResults.Redemption.GuideDocumentMappings obj = new GuideDocumentMappings();
obj.DocumentID = GuideDocumentMapping.DocumentID;
obj.DocumentSouceURL = GuideDocumentMapping.DocumentSouceURL;
obj.GuideId = GuideDocumentMapping.GuideId;
obj.Id = GuideDocumentMapping.Id;
obj.IsEnabled = GuideDocumentMapping.IsEnabled;
guideDetailsResult.GuideDocumentMappings.Add(obj);
}
}
catch (Exception ex)
{
_logger.Log(Logging.Enums.LogCategory.Error, ex);
return(new GuideDetailsResult());
}
return(guideDetailsResult);
}
protected override async Task <ICommandResult> Handle(GuideDetailsCommand command)
{
GuideDetailsCommandResult guideDetailsCommandResult = new GuideDetailsCommandResult();
try
{
var user = _UserRepository.GetByEmailAndChannel(command.EmailId, Contracts.Enums.Channels.Feel, Contracts.Enums.SignUpMethods.None);
var country = _countryRepository.GetByAltId(new Guid(command.TaxCountry));
if (user == null)
{
user = new FIL.Contracts.DataModels.User
{
AltId = Guid.NewGuid(),
Email = command.EmailId,
Password = Guid.NewGuid().ToString(),
RolesId = 20,// new guideID in Guid
CreatedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow,
UserName = command.EmailId,
FirstName = command.FirstName,
LastName = command.LastName,
PhoneCode = command.CountryCode,
PhoneNumber = command.MobileNo,
ChannelId = Contracts.Enums.Channels.Feel,
SignUpMethodId = Contracts.Enums.SignUpMethods.None,
IsEnabled = true,
LockOutEnabled = false,
AccessFailedCount = 0,
LoginCount = 0,
PhoneConfirmed = true,
IsActivated = true
};
user = _UserRepository.Save(user);
}
var zipCode = _zipcodeRepository.GetByZipcode(command.ZipCode);
if (zipCode == null)
{
zipCode = new Zipcode
{
AltId = Guid.NewGuid(),
CityId = command.CityId,
CreatedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow,
IsEnabled = true,
Postalcode = command.ZipCode,
ModifiedBy = command.ModifiedBy
};
zipCode = _zipcodeRepository.Save(zipCode);
}
var userAddress = _userAddressDetailRepository.GetByUserId(user.Id).FirstOrDefault();
UserAddressDetail userAddressDetail = new UserAddressDetail
{
Id = userAddress != null ? userAddress.Id : 0,
AddressLine1 = command.AddressLineOne,
AddressLine2 = command.AddressLineTwo,
AddressTypeId = Contracts.Enums.AddressTypes.Billing,
AltId = Guid.NewGuid(),
FirstName = user.FirstName,
LastName = user.LastName,
IsEnabled = true,
CityId = command.CityId,
PhoneCode = user.PhoneCode,
UserId = user.Id,
IsDefault = true,
PhoneNumber = user.PhoneNumber,
Zipcode = zipCode.Id,
CreatedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow
};
if (userAddress != null)
{
userAddress.UpdatedUtc = DateTime.UtcNow;
userAddress.ModifiedBy = command.ModifiedBy;
userAddress.UpdatedBy = command.ModifiedBy;
}
userAddressDetail = _userAddressDetailRepository.Save(userAddressDetail);
var guideDetails = _GuideDetailsRepository.GetByUserId(user.Id);
Redemption_GuideDetails GuideDetails = new Redemption_GuideDetails
{
ApproveStatusId = Contracts.Enums.ApproveStatus.Pending,
Id = guideDetails != null ? guideDetails.Id : 0,
IsEnabled = false,
UserAddressDetailId = userAddressDetail.Id,
LanguageId = String.Join(",", command.LanguageIds.ToArray()),
UserId = user.Id,
CreatedBy = command.ModifiedBy,
ModifiedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow
};
if (guideDetails != null)
{
guideDetails.UpdatedUtc = DateTime.UtcNow;
guideDetails.ModifiedBy = command.ModifiedBy;
guideDetails.UpdatedBy = command.ModifiedBy;
}
GuideDetails = _GuideDetailsRepository.Save(GuideDetails);
foreach (int eventId in command.EventIDs)
{
Redemption_GuidePlaceMappings GuidePlaceMappings = new Redemption_GuidePlaceMappings
{
ApproveStatusId = 1,
EventId = Convert.ToInt64(eventId),
GuideId = GuideDetails.Id,
IsEnabled = true,
CreatedBy = command.ModifiedBy,
ModifiedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow
};
GuidePlaceMappings = _GuidePlaceMappings.Save(GuidePlaceMappings);
}
var guideServices = _GuideServicesRepository.GetAllByGuideId(GuideDetails.Id);
if (guideServices != null)
{
foreach (Contracts.DataModels.Redemption.Redemption_GuideServices service in guideServices)
{
_GuideServicesRepository.Delete(service);
}
}
foreach (Contracts.DataModels.Redemption.Services service in command.Services)
{
var currentService = service;
currentService.Id = 0;
currentService.IsEnabled = true;
currentService.CreatedBy = command.ModifiedBy;
currentService.CreatedUtc = DateTime.UtcNow;
currentService = _ServicesRepository.Save(service);
Redemption_GuideServices GuideServices = new Redemption_GuideServices
{
GuideId = GuideDetails.Id,
IsEnabled = true,
Notes = command.Notes,
ServiceId = currentService.Id,
CreatedBy = command.ModifiedBy,
ModifiedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow
};
GuideServices = _GuideServicesRepository.Save(GuideServices);
}
MasterFinanceDetails masterFinanceDetails = new MasterFinanceDetails
{
AccountNumber = command.AccountNumber,
AccountTypeId = command.AccountType,
BankAccountTypeId = command.BankAccountType,
BankName = command.BankName,
BranchCode = command.SwiftCode,
CountryId = country.Id,
CurrenyId = command.CurrencyId,
IsEnabled = true,
StateId = command.State,
TaxId = command.TaxNumber,
RoutingNumber = command.RoutingNumber,
CreatedBy = command.ModifiedBy,
ModifiedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow
};
masterFinanceDetails = _MasterFinanceDetailsRepository.Save(masterFinanceDetails);
var AllGuideFinanceMappings = _GuideFinanceMappingsRepository.GetAllByGuideId(GuideDetails.Id);
foreach (Contracts.DataModels.Redemption.Redemption_GuideFinanceMappings guideFinanceMappings in AllGuideFinanceMappings)
{
_GuideFinanceMappingsRepository.Delete(guideFinanceMappings);
}
Redemption_GuideFinanceMappings GuideFinanceMappings = new Redemption_GuideFinanceMappings
{
GuideId = GuideDetails.Id,
IsEnabled = true,
CreatedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow,
MasterFinanceDetailId = masterFinanceDetails.Id
};
GuideFinanceMappings = _GuideFinanceMappingsRepository.Save(GuideFinanceMappings);
var guideDocuments = _guideDocumentMappingsRepository.GetAllByGuideId(GuideDetails.Id);
foreach (Contracts.DataModels.Redemption.Redemption_GuideDocumentMappings guideDocumentMappings in guideDocuments)
{
_guideDocumentMappingsRepository.Delete(guideDocumentMappings);
}
var guideDocument = new Redemption_GuideDocumentMappings
{
GuideId = GuideDetails.Id,
IsEnabled = true,
CreatedBy = command.ModifiedBy,
ModifiedBy = command.ModifiedBy,
CreatedUtc = DateTime.UtcNow,
DocumentID = command.Document,
DocumentSouceURL = "",
};
_guideDocumentMappingsRepository.Save(guideDocument);
return(new GuideDetailsCommandResult
{
UserId = user.Id,
Success = true
});
}
catch (Exception ex)
{
_logger.Log(Logging.Enums.LogCategory.Error, ex);
return(new GuideDetailsCommandResult
{
Success = false
});
}
}
