Ejemplo n.º 1
0
        public IEnumerable <ManufacturedHomePark> GetAll(string parkCode, string parkName, string contactName, out int resultCount, int pageNumber = 1, int pageSize = 50)
        {
            List <ManufacturedHomePark> results = new List <ManufacturedHomePark>();

            var query = from homepark in _context.AsmtmobileHomeParks
                        join nameAddress in _context.AsmtmasterNameAddress on homepark.ContactNameCode equals nameAddress.NameCode
                        into homeparkDetails
                        from nameAddressRecord in homeparkDetails.DefaultIfEmpty()
                        where (string.IsNullOrWhiteSpace(parkCode) || homepark.MhparkCode.ToLower().Trim() == parkCode.ToLower().Trim()) &&
                        (string.IsNullOrWhiteSpace(parkName) || homepark.Name.ToLower().Trim().Contains(parkName.ToLower().Trim())) &&
                        (string.IsNullOrWhiteSpace(contactName) || nameAddressRecord.Name.ToLower().Trim().Contains(contactName.ToLower().Trim()))
                        select ManufacturedHomeParkMapper.Map(homepark, nameAddressRecord);

            if (pageNumber > 0)
            {
                resultCount = query.Count();
                results     = query.Skip((pageNumber - 1) * pageSize)
                              .Take(pageSize)
                              .OrderBy(t => t.MhparkCode)
                              .ToList();
            }
            else
            {
                results = query.OrderBy(t => t.MhparkCode)
                          .ToList();
                resultCount = results.Count();
            }

            return(results);
        }
Ejemplo n.º 2
0
        public ManufacturedHomeParkDetails Details(int id)
        {
            var homepark = (from homeparkRecord in _context.AsmtmobileHomeParks
                            join valueMasterRecord in _context.AsmtrealPropertyAssessedValueMaster on homeparkRecord.ParcelNumber
                            equals valueMasterRecord.ParcelNumber into homepark_valueMasterRecord
                            join nameAddress in _context.AsmtmasterNameAddress on homeparkRecord.ContactNameCode
                            equals nameAddress.NameCode into homepark_nameAddressRecord
                            where homeparkRecord.Id == id
                            from valueMasterRecord in homepark_valueMasterRecord.DefaultIfEmpty()
                            from nameAddressRecord in homepark_nameAddressRecord.DefaultIfEmpty()
                            select ManufacturedHomeParkMapper.Map(homeparkRecord, nameAddressRecord, valueMasterRecord)
                            ).SingleOrDefault();

            return(homepark);
        }