/// <summary>
        /// The find persons.
        /// </summary>
        /// <param name="passport">
        /// The passport.
        /// </param>
        /// <param name="sort">
        /// The sort.
        /// </param>
        /// <param name="direction">
        /// The direction.
        /// </param>
        /// <param name="skip">
        /// The skip.
        /// </param>
        /// <returns>
        /// The <see cref="List"/>.
        /// </returns>
        public static List<Passport> FindPassports(Passport passport, int sort, bool direction, int skip)
        {
            List<Passport> list = new List<Passport>();

            //using (var db = new PassContext())
            {
                if (passport.Surname != string.Empty) sort = 2;
                // IQueryable<Passport> query = db.Passports;
                foreach (var item in GenerateQuery(passport, Sorting(sort, direction)).Skip(skip).Take(20).ToList())
                {
                    list.Add(
                        new Passport
                            {
                                Name = item.Name,
                                Surname = item.Surname,
                                Address = item.Address,
                                Birthday = item.Birthday,
                                Patronymic = item.Patronymic,
                                PassportNumber = item.PassportNumber,
                                Sex = item.Sex,
                                City = item.City,
                                IssuedBy = item.IssuedBy,
                                DateOfIssue = item.DateOfIssue,
                                Code = item.Code
                            });
                }

                return list;
            }
        }
        /// <summary>
        /// The post.
        /// </summary>
        /// <param name="data">
        /// The data.
        /// </param>
        /// <returns>
        /// The <see cref="List"/>.
        /// </returns>
        public List<Passport> Post(Passport data)
        {
            List<Passport> pass = new List<Passport>();

            // pass = PassportRepository.FindPersons(data);
            return pass;
        }
Пример #3
0
        /// <summary>
        /// The generate query.
        /// </summary>
        /// <param name="passport">
        /// The passport.
        /// </param>
        /// <param name="query">
        /// The query.
        /// </param>
        /// <returns>
        /// The <see cref="IQueryable"/>.
        /// </returns>
        private static IQueryable <Passport> GenerateQuery(Passport passport, IQueryable <Passport> query)
        {
            //var db = new PassContext();
            if (passport.Name != string.Empty)
            {
                query = query.Where(a => a.Name == passport.Name);
            }

            if (passport.Surname != string.Empty)
            {
                query = query.Where(a => a.Surname == passport.Surname);
                //query = query.Where(a=>a.Surname
            }

            if (passport.Patronymic != string.Empty)
            {
                query = query.Where(a => a.Patronymic == passport.Patronymic);
            }

            if (passport.PassportNumber != string.Empty)
            {
                query = query.Where(a => a.PassportNumber == passport.PassportNumber);
            }

            if (passport.Sex != string.Empty)
            {
                query = query.Where(a => a.Sex == passport.Sex);
            }

            if (passport.Birthday != new DateTime())
            {
                query = query.Where(a => a.Birthday.CompareTo(passport.Birthday) == 0);
            }

            if (passport.City != string.Empty)
            {
                query = query.Where(a => a.City == passport.City);
            }

            if (passport.Address != string.Empty)
            {
                query = query.Where(a => a.Address == passport.Address);
            }

            if (passport.IssuedBy != string.Empty)
            {
                query = query.Where(a => a.IssuedBy.Contains(passport.IssuedBy));
            }

            if (passport.DateOfIssue != new DateTime())
            {
                query = query.Where(a => a.DateOfIssue.CompareTo(passport.DateOfIssue) == 0);
            }

            if (passport.Code != string.Empty)
            {
                query = query.Where(a => a.Code.Contains(passport.Code));
            }

            return(query);
        }
        /// <summary>
        /// The generate query.
        /// </summary>
        /// <param name="passport">
        /// The passport.
        /// </param>
        /// <param name="query">
        /// The query.
        /// </param>
        /// <returns>
        /// The <see cref="IQueryable"/>.
        /// </returns>
        private static IQueryable<Passport> GenerateQuery(Passport passport, IQueryable<Passport> query)
        {
            //var db = new PassContext();
            if (passport.Name != string.Empty)
            {
                query = query.Where(a => a.Name == passport.Name);
            }

            if (passport.Surname != string.Empty)
            {
                query = query.Where(a => a.Surname == passport.Surname);
                //query = query.Where(a=>a.Surname
            }

            if (passport.Patronymic != string.Empty)
            {
                query = query.Where(a => a.Patronymic == passport.Patronymic);
            }

            if (passport.PassportNumber != string.Empty)
            {
                query = query.Where(a => a.PassportNumber == passport.PassportNumber);
            }

            if (passport.Sex != string.Empty)
            {
                query = query.Where(a => a.Sex == passport.Sex);
            }

            if (passport.Birthday != new DateTime())
            {
                query = query.Where(a => a.Birthday.CompareTo(passport.Birthday) == 0);
            }

            if (passport.City != string.Empty)
            {
                query = query.Where(a => a.City == passport.City);
            }

            if (passport.Address != string.Empty)
            {
                query = query.Where(a => a.Address == passport.Address);
            }

            if (passport.IssuedBy != string.Empty)
            {
                query = query.Where(a => a.IssuedBy.Contains(passport.IssuedBy));
            }

            if (passport.DateOfIssue != new DateTime())
            {
                query = query.Where(a => a.DateOfIssue.CompareTo(passport.DateOfIssue) == 0);
            }

            if (passport.Code != string.Empty)
            {
                query = query.Where(a => a.Code.Contains(passport.Code));
            }

            return query;
        }