Exemplo n.º 1
0
        /// <summary>
        /// Get data in database
        /// </summary>
        /// <param name="key">Primary Key</param>
        /// <returns>read data</returns>
        public City Get(CityKey key)
        {
            if (key == null || (key.CountryId == 0 && string.IsNullOrWhiteSpace(key.ZipCode) && key.Id == 0))
            {
                return(null);
            }

            var rowList = _dbContext.City.Where(m => 1 == 1);

            if (key.CountryId > 0)
            {
                rowList = rowList.Where(m => m.CountryId == key.CountryId);
            }
            if (!string.IsNullOrWhiteSpace(key.ZipCode))
            {
                rowList = rowList.Where(m => m.ZipCode == key.ZipCode);
            }
            if (key.Id > 0)
            {
                rowList = rowList.Where(m => m.Id == key.Id);
            }

            var row = rowList.FirstOrDefault();

            if (row != null)
            {
                return(CityTransformer.ToBean(row));
            }
            return(null);
        }
Exemplo n.º 2
0
        /// <summary>
        /// Find data in database
        /// </summary>
        /// <returns></returns>
        public List <City> Find(CityCriteria cityCriteria = null)
        {
            List <City>          resultList = null;
            IQueryable <CityRow> rowList    = _dbContext.City;

            CriteriaTransformer.CompleteQuery(ref rowList, cityCriteria);

            if (rowList != null)
            {
                foreach (var row in rowList)
                {
                    if (resultList == null)
                    {
                        resultList = new List <City>();
                    }
                    resultList.Add(CityTransformer.ToBean(row));
                }
            }
            return(resultList);
        }