public JsonResult LandRegistryEnquiries(int customerId)
{
var b = new LandRegistryModelBuilder();
var landRegistryEnquiries = new List <LandRegistryEnquiryTitle>();
var customersLrs = this.serviceClient.Instance.LandRegistryLoad(customerId, this.context.UserId).Value;
var lrEnqs = customersLrs.Where(x => x.RequestType == LandRegistryRequestType.Enquiry.ToString())
.Select(x => x.Response);
foreach (var lr in lrEnqs)
{
try {
var lrModel = b.BuildEnquiryModel(lr);
landRegistryEnquiries.AddRange(lrModel.Titles);
} catch (Exception ex) {
Log.Info(ex, "Failed to build enquiry model.");
}
}
landRegistryEnquiries = landRegistryEnquiries.DistinctBy(x => x.TitleNumber)
.ToList();
return(Json(new {
titles = landRegistryEnquiries
}));
}
public PropertiesModelBuilder(IWorkplaceContext context)
{
this.context = context;
this.landRegistryModelBuilder = new LandRegistryModelBuilder();
this.fileRepo = ObjectFactory.GetInstance <NHibernateRepositoryBase <MP_AlertDocument> >();
this.serviceClient = new ServiceClient();
}
} // IsOwner
public static bool IsOwner(int customerID, string customerFullName, string response, string titleNumber)
{
if (string.IsNullOrWhiteSpace(customerFullName))
{
Library.Instance.Log.Warn(
"IsOwner: returning false for customer {0} because full name is empty.",
customerID
);
return(false);
} // if
var b = new LandRegistryModelBuilder();
var lrData = b.BuildResModel(response, titleNumber);
if (lrData.Proprietorship == null || lrData.Proprietorship.ProprietorshipParties == null)
{
return(false);
}
string lowerCasedFullName = customerFullName.ToLower();
foreach (ProprietorshipPartyModel proprietorshipParty in lrData.Proprietorship.ProprietorshipParties)
{
// We are taking the first part of the LR first name as it may contain
// both first and middle name, while we might be missing the middle name
if (string.IsNullOrEmpty(proprietorshipParty.PrivateIndividualForename))
{
continue;
}
if (string.IsNullOrEmpty(proprietorshipParty.PrivateIndividualSurname))
{
continue;
}
string firstPartOfFirstName = proprietorshipParty.PrivateIndividualForename;
int indexOfSpace = firstPartOfFirstName.IndexOf(' ');
if (indexOfSpace != -1)
{
firstPartOfFirstName = firstPartOfFirstName.Substring(0, indexOfSpace);
}
if (lowerCasedFullName.Contains(firstPartOfFirstName.ToLower()) &&
lowerCasedFullName.Contains(proprietorshipParty.PrivateIndividualSurname.ToLower())
)
{
// Customer is owner
return(true);
} // if
} // for each
return(false);
} // IsOwner
} // Execute
public void LinkLandRegistryAndAddress(int customerId, string response, int landRegistryId)
{
var customers = ObjectFactory.GetInstance <CustomerRepository>();
var customerAddressRepository = ObjectFactory.GetInstance <CustomerAddressRepository>();
var customer = customers.Get(customerId);
var bb = new LandRegistryModelBuilder();
LandRegistryResModel landRegistryResModel = bb.BuildResModel(response);
bool isOwnerAccordingToLandRegistry = IsOwner(customer, response, this.titleNumber);
if (isOwnerAccordingToLandRegistry)
{
var ownedProperties = new List <CustomerAddress>(customer.AddressInfo.OtherPropertiesAddresses);
if (customer.PropertyStatus.IsOwnerOfMainAddress)
{
if (customer.AddressInfo.PersonalAddress.Count == 1)
{
ownedProperties.Add(customer.AddressInfo.PersonalAddress.First());
}
} // if
foreach (CustomerAddress ownedProperty in ownedProperties)
{
bool foundMatching = false;
foreach (LandRegistryAddressModel propertyAddress in landRegistryResModel.PropertyAddresses)
{
if (propertyAddress.PostCode == ownedProperty.Postcode)
{
foundMatching = true;
break;
}
}
if (foundMatching)
{
ownedProperty.IsOwnerAccordingToLandRegistry = true;
customerAddressRepository.SaveOrUpdate(ownedProperty);
DB.ExecuteNonQuery(string.Format("UPDATE LandRegistry SET AddressId = {0} WHERE Id = {1}", ownedProperty.AddressId, landRegistryId), CommandSpecies.Text);
break;
}
} // for each
} // if
} // LinkLandRegistryAndAddress
} // IsOwner
private LandRegistryDataModel GetLandRegistryData(out LandRegistryDB landRegistry)
{
Log.Debug("GetLandRegistryData begin cId {0} titleNumber {1}", this.customerID, this.titleNumber);
//check cash
var landRegistryLoad = new LandRegistryLoad(this.customerID);
landRegistryLoad.Execute();
var customersLrs = landRegistryLoad.Result;
var cache = customersLrs.Where(x =>
x.TitleNumber == this.titleNumber &&
((x.RequestTypeEnum == LandRegistryRequestType.Res) || (x.RequestTypeEnum == LandRegistryRequestType.ResPoll)) &&
x.ResponseTypeEnum == LandRegistryResponseType.Success)
.OrderByDescending(x => x.InsertDate)
.FirstOrDefault();
if (cache != null)
{
var b = new LandRegistryModelBuilder();
var cacheModel = new LandRegistryDataModel {
Request = cache.Request,
Response = cache.Response,
Res = b.BuildResModel(cache.Response),
RequestType = cache.RequestTypeEnum,
ResponseType = cache.ResponseTypeEnum,
DataSource = LandRegistryDataSource.Cache
};
if (!cache.Owners.Any())
{
var owners = new List <LandRegistryOwnerDB>();
foreach (var owner in cacheModel.Res.Proprietorship.ProprietorshipParties)
{
var ownerDB = new LandRegistryOwnerDB {
LandRegistryId = cache.Id,
FirstName = owner.PrivateIndividualForename,
LastName = owner.PrivateIndividualSurname,
CompanyName = owner.CompanyName,
CompanyRegistrationNumber = owner.CompanyRegistrationNumber,
};
owners.Add(ownerDB);
DB.ExecuteNonQuery("LandRegistryOwnerDBSave", CommandSpecies.StoredProcedure, DB.CreateTableParameter("Tbl", ownerDB));
}
cache.Owners = owners;
}
landRegistry = cache;
return(cacheModel);
}
var isProd = CurrentValues.Instance.LandRegistryProd;
ILandRegistryApi lr;
if (isProd)
{
lr = new LandRegistryApi(
CurrentValues.Instance.LandRegistryUserName,
Encrypted.Decrypt(CurrentValues.Instance.LandRegistryPassword),
CurrentValues.Instance.LandRegistryFilePath);
}
else
{
lr = new LandRegistryTestApi();
}
LandRegistryDataModel model;
if (this.titleNumber != null)
{
model = lr.Res(this.titleNumber, this.customerID);
var customer = ObjectFactory.GetInstance <CustomerRepository>().Get(this.customerID);
var lrDB = new LandRegistryDB {
CustomerId = this.customerID,
InsertDate = DateTime.UtcNow,
TitleNumber = this.titleNumber,
Request = model.Request,
Response = model.Response,
RequestType = model.RequestType.ToString(),
ResponseType = model.ResponseType.ToString(),
AttachmentPath = model.Attachment != null ? model.Attachment.FilePath : null
};
int lrID = DB.ExecuteScalar <int>("LandRegistryDBSave", CommandSpecies.StoredProcedure, DB.CreateTableParameter("Tbl", lrDB));
var owners = new List <LandRegistryOwnerDB>();
if (model.ResponseType == LandRegistryResponseType.Success && model.Res != null && model.Res.Proprietorship != null && model.Res.Proprietorship.ProprietorshipParties != null)
{
foreach (var owner in model.Res.Proprietorship.ProprietorshipParties)
{
var ownerDB = new LandRegistryOwnerDB {
LandRegistryId = lrID,
FirstName = owner.PrivateIndividualForename,
LastName = owner.PrivateIndividualSurname,
CompanyName = owner.CompanyName,
CompanyRegistrationNumber = owner.CompanyRegistrationNumber,
};
owners.Add(ownerDB);
DB.ExecuteNonQuery("LandRegistryOwnerDBSave", CommandSpecies.StoredProcedure, DB.CreateTableParameter("Tbl", ownerDB));
}
lrDB.Owners = owners;
}
landRegistry = lrDB;
if (model.Attachment != null)
{
var fileRepo = ObjectFactory.GetInstance <NHibernateRepositoryBase <MP_AlertDocument> >();
var doc = new MP_AlertDocument {
BinaryBody = model.Attachment.AttachmentContent,
Customer = customer,
Description = "LandRegistry",
UploadDate = DateTime.UtcNow,
DocName = model.Attachment.FileName
};
fileRepo.SaveOrUpdate(doc);
model.Attachment.AttachmentContent = null;
}
}
else
{
landRegistry = null;
model = new LandRegistryDataModel {
Res = new LandRegistryResModel {
Rejection = new LandRegistryRejectionModel {
Reason = "Please perform enquiry first to retrieve title number"
}
},
ResponseType = LandRegistryResponseType.None
};
}
model.DataSource = LandRegistryDataSource.Api;
return(model);
} // GetLandRegistryData
} // Execute
private LandRegistryDataModel GetLandRegistryEnquiryData()
{
try {
//check cache
var landRegistryLoad = new LandRegistryLoad(this.customerID);
landRegistryLoad.Execute();
var customersLrs = landRegistryLoad.Result;
var cache = customersLrs.Where(x => x.RequestTypeEnum == LandRegistryRequestType.Enquiry).ToList();
if (cache.Any())
{
foreach (var landRegistry in cache)
{
var lrReq = Serialized.Deserialize <LandRegistryLib.LREnquiryServiceNS.RequestSearchByPropertyDescriptionV2_0Type>(landRegistry.Request);
Q1AddressType lrAddress = lrReq.Product.SubjectProperty.Address;
if (lrAddress.IsA(this.buildingNumber, this.buildingName, this.streetName, this.cityName, this.postCode))
{
var b = new LandRegistryModelBuilder();
var cacheModel = new LandRegistryDataModel {
Request = landRegistry.Request,
Response = landRegistry.Response,
Enquery = b.BuildEnquiryModel(landRegistry.Response),
RequestType = landRegistry.RequestTypeEnum,
ResponseType = landRegistry.ResponseTypeEnum,
DataSource = LandRegistryDataSource.Cache,
};
return(cacheModel);
} // if
} // for each
} // if
} catch (Exception ex) {
Log.Warn(ex, "Failed to retrieve land registry enquiry from cache.");
} // try
bool isProd = CurrentValues.Instance.LandRegistryProd;
ILandRegistryApi lr;
if (isProd)
{
lr = new LandRegistryApi(
CurrentValues.Instance.LandRegistryUserName,
Encrypted.Decrypt(CurrentValues.Instance.LandRegistryPassword),
CurrentValues.Instance.LandRegistryFilePath);
}
else
{
lr = new LandRegistryTestApi();
}
var model = lr.EnquiryByPropertyDescription(this.buildingNumber, this.buildingName, this.streetName, this.cityName, this.postCode, this.customerID);
var lrDB = new LandRegistryDB {
CustomerId = this.customerID,
InsertDate = DateTime.UtcNow,
Postcode = string.IsNullOrEmpty(this.postCode) ? string.Format("{3}{0},{1},{2}", this.buildingNumber, this.streetName, this.cityName, this.buildingName) : this.postCode,
Request = model.Request,
Response = model.Response,
RequestType = model.RequestType.ToString(),
ResponseType = model.ResponseType.ToString()
};
int lrID = DB.ExecuteScalar <int>("LandRegistryDBSave", CommandSpecies.StoredProcedure, DB.CreateTableParameter("Tbl", lrDB));
Log.Info("LandRegistryDBSave {0}", lrID);
model.DataSource = LandRegistryDataSource.Api;
return(model);
} // GetLandRegistryEnquiryData
