Esempio n. 1
0
        }         // 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
Esempio n. 2
0
        }         // 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