public void Delete()
        {
            int customerID = 16;
            // Creating an unit of word cause to use one dbcontext.
            CustomerUnitOfWork unitOfWork = new CustomerUnitOfWork();

            GenericRepository <Customer.DataLayer.Customer> repCustomer =
                unitOfWork.GetRepoInstance <Customer.DataLayer.Customer>();
            int expctedCount = repCustomer.Count();

            Customer.DataLayer.Customer customer = unitOfWork.GetRepoInstance <Customer.DataLayer.Customer>().GetAll().Where(c => c.CustomerID == customerID).Single();
            unitOfWork.GetRepoInstance <Customer.DataLayer.Customer>().Delete(customer);
            unitOfWork.SaveChanges();

            Assert.AreEqual(--expctedCount, repCustomer.Count());
        }
        public void Insert()
        {
            // Arrange:
            // Web API posts CustomerViewModel via json format and will be deserialized into CustomerViewModel
            CustomerViewModel customer = new CustomerViewModel();

            customer.FirstName    = "nameTest";
            customer.LastName     = "familyTest";
            customer.CityName     = "Hamedan";
            customer.ProvinceName = "Hamedan";

            // Creating an unit of work.
            CustomerUnitOfWork unitOfWork = new CustomerUnitOfWork();

            // Mapping ViewModel to Model to provide database format model
            Customer.DataLayer.Customer entityCustomer = Mapper.Map <CustomerViewModel, Customer.DataLayer.Customer>(customer);

            // Find city and province entity
            City     city     = unitOfWork.GetRepoInstance <City>().GetAll().Where(s => s.CityName == customer.CityName).Single();
            Province province = unitOfWork.GetRepoInstance <Province>().GetAll().Where(s => s.ProvinceName == customer.ProvinceName).Single();

            city.Province = province;

            // change city becuase city is a new city in mapping and we don't want to create new city.
            entityCustomer.City = city;

            // Creating a customer item.
            //Customer.DataLayer.Customer c = new Customer.DataLayer.Customer()
            //{
            //    FirstName = "test",
            //    LastName = "test",
            //    City = city,
            //};

            GenericRepository <Customer.DataLayer.Customer> repCustomer =
                unitOfWork.GetRepoInstance <Customer.DataLayer.Customer>();

            int expctedCount = repCustomer.Count();

            repCustomer.Insert(entityCustomer);
            repCustomer.Save();

            Assert.AreEqual(++expctedCount, repCustomer.Count());
        }
        public void Test08_Count()
        {
            int result = 0;
            var filter = new SampleEntity()
            {
                Name = "roberto"
            };

            using (var repos = new GenericRepository <SampleEntity>(DatabaseEngine.SQLite, connString))
            {
                result = repos.Count(filter);
            }

            Assert.True(result > 0);
        }
示例#4
0
        private bool AddNewDays()
        {
            bool b   = false;
            var  now = DateTime.Now;
            int  cnt = weatherRepository.Count(i => i.Date > now);

            if (cnt < ndays)
            {
                var days = weatherRepository.FindAllAsQueryable(i => i.Date > now).ToList();
                days = Enumerable.Range(1, ndays).Select(i => new DbWeatherInfo(now.AddDays(i))).Where(i => !days.Any(j => j.Date == i.Date)).ToList();
                weatherRepository.Insert(days);
                b = true;
            }

            return(b);
        }
        public TableauMetadataFactory(GenericRepository <TableauBlob> blobsRepo)
        {
            _blobs = blobsRepo.All();
            _xmls  = new List <TableauXml>();

            double count = blobsRepo.Count();
            double i     = 1;

            foreach (var b in _blobs)
            {
                _xmls.Add(new TableauXml()
                {
                    Id = b.Id, RepositoryId = b.RepositoryId, SiteId = b.SiteId, Xml = TableauFileReader.GetXML(b), SourceType = b.SourceType
                });
                var per_complete = Math.Round((i / count) * 100, 0);
                Console.Write("\r{0}% Parsing is Completed", per_complete);
                i++;
            }

            Console.WriteLine("");
        }
示例#6
0
        protected override async Task <IEnumerable <Transaction> > Paginate()
        {
            if (coudSyncSetting != null && coudSyncSetting.Enabled)
            {
                var skip = (page.CurrentPage - 1) * page.PageCount;

                if (transactionRepository.Count(x => x.AccountId.Equals(page.AccountId)) > skip)
                {
                    var c = GetCachedFilteredTransactions(skip);
                    return(await Task.FromResult(c));
                }
            }

            page.Transactions.Clear();

            await Task.Delay(500);

            page = await transactionServiceClient.Page(page);

            var transasctionsResult = MapPageToEntity(page);

            return(transasctionsResult);
        }
示例#7
0
 public int Count()
 {
     return(_repository.Count());
 }
 public int Count()
 {
     return(_repository.Count().Result);
 }