Example #1
0
        private static void insereMunicipios()
        {
            var repMun = new Repository<Municipio>();

            var mun = new Municipio
            {
                Nome = "São Paulo",
                UnidadeFederacaoID = 35
            };
            repMun.Insert(mun);

            mun = new Municipio
            {
                Nome = "Florianópolis",
                UnidadeFederacaoID = 42
            };
            repMun.Insert(mun);

            mun = new Municipio
            {
                Nome = "Brasília",
                UnidadeFederacaoID = 53
            };
            repMun.Insert(mun);
        }
Example #2
0
        public ActionResult Here(int locationId)
        {
            // Get the data
            IRepository repository = new Repository(new CheckInDatabaseContext());

            var location = repository.GetById<Location>(locationId);
            if (location == null)
            {
                return new HttpNotFoundResult();
            }

            var username = HttpContext.User.Identity.Name;

            var user = repository.Query<ApplicationUser>().SingleOrDefault(u => u.UserName == username);
            if (user == null)
            {
                return new HttpNotFoundResult();
            }

            // make a new check in
            var checkIn = new CheckIn();
            checkIn.User = user;
            checkIn.Location = location;
            checkIn.Time = DateTime.Now;
            repository.Insert(checkIn);

            // check to see if this user meets any achievements
            var allCheckins = repository.Query<CheckIn>().Where(c => c.User.Id == user.Id);
            var allAchievements = repository.Query<Achievement>();
            var allLocationIds = repository.Query<Location>().Select(l => l.Id);

            // two in one day?
            if (!allAchievements.Any(a => a.Type == AchievementType.TwoInOneDay) && allCheckins.Count(c => EntityFunctions.TruncateTime(c.Time) == DateTime.Today) > 2)
            {
                var twoInOneDay = new Achievement { Type = AchievementType.TwoInOneDay, User = user, TimeAwarded = DateTime.Now };
                repository.Insert(twoInOneDay);
            }

            // all locations?
            var hasAll = false;
            foreach (var testLocationId in allLocationIds)
            {
                hasAll = hasAll || allCheckins.Any(c => c.Location.Id == testLocationId);
            }

            if (!allAchievements.Any(a => a.Type == AchievementType.AllLocations) && hasAll)
            {
                var allLocations = new Achievement { Type = AchievementType.AllLocations, User = user, TimeAwarded = DateTime.Now };
                repository.Insert(allLocations);
            }

            // some day we'll have hundreds of achievements!

            repository.SaveChanges();

            return RedirectToAction("Index");
        }
        public void BasicCrud()
        {
            using (var trans = DataSource.BeginTransaction())
            {

                var repo = new Repository<Employee, int>(trans, EmployeeTableName);

                var emp1 = new Employee() { FirstName = "Tom", LastName = "Jones", Title = "President" };
                var echo1 = repo.Insert(emp1);

                Assert.AreNotEqual(0, echo1.EmployeeKey, "EmployeeKey was not set");
                Assert.AreEqual(emp1.FirstName, echo1.FirstName, "FirstName");
                Assert.AreEqual(emp1.LastName, echo1.LastName, "LastName");
                Assert.AreEqual(emp1.Title, echo1.Title, "Title");

                echo1.MiddleName = "G";
                repo.Update(echo1);

                var emp2 = new Employee() { FirstName = "Lisa", LastName = "Green", Title = "VP Transportation", ManagerKey = echo1.EmployeeKey };
                var echo2 = repo.Insert(emp2);
                Assert.AreNotEqual(0, echo2.EmployeeKey, "EmployeeKey was not set");
                Assert.AreEqual(emp2.FirstName, echo2.FirstName, "FirstName");
                Assert.AreEqual(emp2.LastName, echo2.LastName, "LastName");
                Assert.AreEqual(emp2.Title, echo2.Title, "Title");
                Assert.AreEqual(emp2.ManagerKey, echo2.ManagerKey, "ManagerKey");

                var list = repo.GetAll();
                Assert.IsTrue(list.Any(e => e.EmployeeKey == echo1.EmployeeKey), "Employee 1 is missing");
                Assert.IsTrue(list.Any(e => e.EmployeeKey == echo2.EmployeeKey), "Employee 2 is missing");

                var get1 = repo.Get(echo1.EmployeeKey.Value);
                Assert.AreEqual(echo1.EmployeeKey, get1.EmployeeKey);



                var whereSearch1 = repo.Query("FirstName = @FN", new { FN = "Tom" });
                Assert.IsTrue(whereSearch1.Any(x => x.EmployeeKey == echo1.EmployeeKey), "Emp1 should have been returned");
                Assert.IsTrue(whereSearch1.All(x => x.FirstName == "Tom"), "Checking for incorrect return values");

                var whereSearch2 = repo.Query(new { FirstName = "Tom" });
                Assert.IsTrue(whereSearch2.Any(x => x.EmployeeKey == echo1.EmployeeKey), "Emp1 should have been returned");
                Assert.IsTrue(whereSearch2.All(x => x.FirstName == "Tom"), "Checking for incorrect return values");


                repo.Delete(echo2.EmployeeKey.Value);
                repo.Delete(echo1.EmployeeKey.Value);

                var list2 = repo.GetAll();
                Assert.AreEqual(list.Count - 2, list2.Count);

                trans.Commit();
            }

        }
Example #4
0
 private void Child_Insert(Repository repository, int companyID)
 {
     LoadProperty(CompanyIDProperty, companyID);
     var dto = ToDTO();
     repository.Insert(dto);
     LoadProperty(EmployeeStatusIDProperty, dto.EmployeeStatusID);
 }
Example #5
0
 public void InitializeDatabase()
 {
     var hmacSettings = IntegrationTestHelper.ReadHmacSettings();
     IntegrationTestInitializer.DatabaseCallback = conn =>
     {
         conn.CreateTableIfNotExists<AppMember>();
         conn.CreateTableIfNotExists<IdentityUserClaim>();
         conn.CreateTableIfNotExists<IdentityUserLogin>();
         conn.CreateTableIfNotExists<IdentityUserService>();
     };
     IntegrationTestInitializer.TestDataCallback = (sid, uid, aid, dbn, sec) =>
     {
         var userRepository = new Repository<AppMember>();
         var email = Guid.NewGuid().ToString() + "@test.local";
         userRepository.Insert(new AppMember { Id = hmacSettings.UserId, UserName = email, Email = email});
         var loginRepository = new Repository<IdentityUserLogin>();
         loginRepository.Insert(new IdentityUserLogin
         {
             LoginProvider = LoginProvider,
             ProviderKey = Guid.NewGuid().ToString(),
             UserId = hmacSettings.UserId 
         });
     };
     IntegrationTestInitializer.CreateTestDatabase(new Guid(hmacSettings.ServiceId), new Guid(hmacSettings.UserId), new Guid(hmacSettings.AppId), TestDbName, hmacSettings.Secret, TargetDbPath);
 }
Example #6
0
        public void Start()
        {
            var url = "http://www.translationdirectory.com/translation_jobs.php";
            Console.WriteLine("Url: " + url);
            var web = new HtmlWeb();
            var languageList = new List<LanguageModel>();
            var languagePairJobList = new List<LanguagePairJobModel>();
            try
            {
                var doc = web.Load(url);
                var nodes = doc.DocumentNode.SelectNodes(".//div").Where(k => k.Attributes.Contains("class") && k.Attributes["class"].Value.Contains("box_informer"));
                var stt = 0;
                foreach (var node in nodes)
                {
                    var childNodes = node.SelectNodes(".//tr");
                    foreach (var childNode in childNodes)
                    {
                        var language = new LanguageModel();
                        var languagePairJob = new LanguagePairJobModel();
                        var datahtml = childNode.SelectSingleNode(".//strong").InnerText;
                        if (datahtml.Contains("to"))
                        {
                            var checkLanguage = datahtml.Split(new string[] { "to" }, StringSplitOptions.None)[0].Trim();
                            if (languageList.Count(x => x.Name.Contains(checkLanguage)) == 0)
                            {
                                language.Name = checkLanguage;
                                languageList.Add(language);
                            }
                            var checkTarget = datahtml.Split(new string[] {"to"}, StringSplitOptions.None)[1];
                            if (languagePairJobList.Count(x => x.Source.Contains(checkLanguage) && x.Target.Contains(checkTarget)) == 0)
                            {
                                languagePairJob.Source = checkLanguage;
                                languagePairJob.Target = checkTarget.Split(new string[] { "Translation" }, StringSplitOptions.None)[0].Trim();
                                languagePairJobList.Add(languagePairJob);
                            }
                        }
                    }
                }

                Console.WriteLine("BEGIN INSERT INTO Language...");
                foreach (var item in languageList)
                {
                    var repoLanguage = new Repository<LanguageModel>("Language");
                    repoLanguage.Insert(item);
                }

                Console.WriteLine("BEGIN INSERT INTO LanguagePairJob...");
                foreach (var item in languagePairJobList)
                {
                    var repoLanguagePairJob = new Repository<LanguagePairJobModel>("LanguagePairJob");
                    repoLanguagePairJob.Insert(item);
                }

                Console.WriteLine("DONE!!!!");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex);
            }
        }
Example #7
0
 public static object RegistrarUsuario(string usuarioJSON)
 {
     using (var dataContext = new OBJ_REDDataContext())
     {
         var usuRepo = new Repository<Usuario>(dataContext);
         Usuario usuario = JsonConvert.DeserializeObject<Usuario>(usuarioJSON);
         usuario.Password = GenerarPassword();
         try
         {
             usuRepo.Insert(usuario);
             dataContext.SubmitChanges();
             Correo.EnviarCorreo(Tipo.NuevoUsuario, usuario);
             return (new
             {
                 valido = true,
                 mensaje = "Usuario correctamente registrado. La contraseña fue enviada a tu correo."
             });
         }
         catch (Exception)
         {
             return (new
             {
                 valido = false,
                 mensaje = "Hubo un error al intentar registrar tu usuario."
             });
         }
     }
 }
        public void Should_insert_new_record_and_populate_Id()
        {
            var orderDate = DateTime.Now.AddDays(-20);
            var requiredDate = DateTime.Now.AddDays(-10);
            var shippedDate = DateTime.Now.AddDays(-15);

            var newOrder = new Order
                               {
                                   CustomerID = "ABCDE",
                                   EmployeeID = 5,
                                   Freight = 12.13m,
                                   OrderDate = orderDate,
                                   RequiredDate = requiredDate,
                                   ShipName = "My Stuff",
                                   ShipAddress = "P.O. Box 123",
                                   ShipCity = "London",
                                   ShipPostalCode = "EC1 4RT",
                                   ShipCountry = "UK",
                                   ShipVia = 3,
                                   ShippedDate = shippedDate
                               };

            using (var context = new RepositoryTest())
            {
                var repo = new Repository<Order>(context);
                repo.Insert(newOrder);
            }

            Assert.AreEqual(10348, newOrder.OrderID);
        }
        private static void InsertTestData(Guid serviceId, Guid userId, Guid appId, string dbName, string secret)
        {
            var hmacUserRepository = new Repository<UserModel>();
            hmacUserRepository.Insert(new UserModel { Id = 1, ServiceId = serviceId, UserId = userId, AppId = appId, Enabled = true, CreatedAt = DateTime.UtcNow });

            var hmacAppRepository = new Repository<AppModel>();
            hmacAppRepository.Insert(new AppModel { Id = 1, ServiceId = serviceId, AppId = appId, CreatedAt = DateTime.UtcNow, Enabled = true, Name = dbName, Secret = secret });
        }
Example #10
0
        public void Join_example_with_transaction_insert()
        {
            Repository.DefaultConnectionString = @"Data source=.\SQLEXPRESS;Initial Catalog=WeenyMapper;Trusted_Connection=true";
            Repository.DefaultConvention = new BlogConvention();

            var myBlog = new Blog("My blog");

            var steve = new User("Steve", "password");

            var post1 = new BlogPost("Title 1", "Content 1 goes here") { Blog = myBlog, Author = steve };
            var post2 = new BlogPost("Title 2", "Content 2 goes here") { Blog = myBlog, Author = steve };
            var post3 = new BlogPost("Title 3", "Content 3 goes here") { Blog = myBlog, Author = steve };
            var post4 = new BlogPost("Title 4", "Content 4 goes here") { Blog = myBlog, Author = steve };

            using (var repository = new Repository())
            {
                using (var transaction = repository.BeginTransaction())
                {
                    repository.Insert(myBlog);
                    repository.Insert(steve);
                    repository.Insert(post1, post2, post3, post4);

                    transaction.Commit();
                }

                repository.Update<BlogPost>()
                          .Set(x => x.Title, "Updated title 2")
                          .Where(x => x.Id == post2.Id)
                          .Execute();

                repository.Delete<BlogPost>()
                          .Where(x => x.Id == post3.Id || x.Title == "Title 4")
                          .Execute();

                var actualBlog = repository.Find<Blog>().Where(x => x.Id == myBlog.Id)
                                           .Join(x => x.Posts, x => x.Blog)
                                           .OrderBy<BlogPost>(x => x.Title)
                                           .Execute();

                Assert.AreEqual("My blog", actualBlog.Name);
                Assert.AreEqual(2, actualBlog.Posts.Count);
                Assert.AreEqual("Title 1", actualBlog.Posts[0].Title);
                Assert.AreEqual("Updated title 2", actualBlog.Posts[1].Title);
            }
        }
Example #11
0
        static void Main(string[] args)
        {
            using (var context = new GamesStoreContext())
            {
                var parser = new GameParser();
                var repo = new Repository<GameDTO>(context);
                for (int i = 1; i <= 8; i++)
                {
                    using (var errorLog = new StreamWriter($"..\\..\\puzzles\\errorLog.txt"))
                    using (var reader = new StreamReader($"..\\..\\puzzles\\m2_{i}.pgn"))
                    {
                        var builder = new StringBuilder();
                        var line = string.Empty;
                        while (!reader.EndOfStream)
                        {
                            builder.Clear();
                            builder.AppendLine(line);
                            while (!reader.EndOfStream && !(line = reader.ReadLine()).Contains("Event"))
                            {
                                if (line.Contains("Date"))
                                {
                                    line = line.Replace("-", ".");
                                    line.Replace("\"?\"", "\"????\"");
                                }

                                // Skip [Round] as it's not properly parsed by pgn
                                if (line.Contains("Round")) continue;

                                builder.AppendLine(line);
                            }

                            var text = builder.ToString();
                            text = text.TrimEnd('\r', '\n');
                            try
                            {
                                foreach (var game in parser.Parse(text))
                                {
                                    var gameDto = new GameDTO()
                                    {
                                        PgnString = text
                                    };

                                    repo.Insert(gameDto);
                                    repo.Save();
                                }
                            }
                            catch (Exception ex)
                            {
                                errorLog.WriteLine($"File m2_{i}.pgn\n Error: {ex.Message}\n While parsing FEN: {text}");
                            }
                        }
                    }
                    Console.WriteLine($"File m2_{i}.pgn processed");
                }
            }
        }
        public void Execute(object state)
        {
            var logInfo = new LogInfo
            {
                MethodInstance = MethodBase.GetCurrentMethod(),
                ThreadInstance = Thread.CurrentThread
            };

            try
            {
                _log.Info("Scheduler Start: (AutoUpdateMonthlyRank)", logInfo);

                IRepository repo = new Repository();

                var iDay = DateTime.Today;

                var firstBetDate = repo.Single<Bet>(1).BetTime;

                while (!(iDay.Year <= firstBetDate.Year && iDay.Month < firstBetDate.Month))
                {
                    var winner = GamblerDW.GetTopGamblerMonthly(iDay, RankType.Winner);
                    var loser = GamblerDW.GetTopGamblerMonthly(iDay, RankType.Loser);
                    var rper = GamblerDW.GetTopGamblerMonthly(iDay, RankType.RP);

                    if (winner != null && loser != null)
                    {
                        var day = iDay;
                        var rank = repo.Query<Rank>(x => x.RankYear == day.Year && x.RankMonth == day.Month).FirstOrDefault();

                        if (rank != null)
                        {
                            //update
                            rank.Init(winner, loser, rper);

                            repo.Update(rank);
                        }
                        else
                        {
                            //insert
                            var instance = new Rank { RankYear = day.Year, RankMonth = day.Month };
                            instance.Init(winner, loser, rper);

                            repo.Insert(instance);
                        }
                    }
                    iDay = iDay.AddMonths(-1);
                }

                _log.Info("Scheduler End: (AutoUpdateMonthlyRank)", logInfo);
            }
            catch (Exception ex)
            {
                _log.Warn(ex, logInfo);
            }
        }
Example #13
0
        public static bool AddCountryHelper(CountryModel model)
        {
            var repo = new Repository<CountryModel>(DbCollection.Country);
            if (repo.Gets().Any(m => m.Name.Equals(model.Name)))
            {
                return false;
            }

            repo.Insert(model);
            return true;
        }
Example #14
0
        public void ShouldInsert()
        {
            // arrange
            Repository<string> r = new Repository<string>(m_session.Object);
            string s = "this";

            // act
            r.Insert(s);

            // assert
            m_session.Verify(x => x.Save((object)s));
        }
        public void InsertProducts()
        {
            using (IDataContextAsync context = new NorthwindContext())
            using (IUnitOfWorkAsync unitOfWork = new UnitOfWork(context))
            {
                IRepositoryAsync<Product> productRepository = new Repository<Product>(context, unitOfWork);

                var newProducts = new[]
                {
                    new Product {ProductName = "One", Discontinued = false, ObjectState = ObjectState.Added},
                    new Product {ProductName = "12345678901234567890123456789012345678901234567890", Discontinued = true, ObjectState = ObjectState.Added},
                    new Product {ProductName = "Three", Discontinued = true, ObjectState = ObjectState.Added},
                    new Product {ProductName = "Four", Discontinued = true, ObjectState = ObjectState.Added},
                    new Product {ProductName = "Five", Discontinued = true, ObjectState = ObjectState.Added}
                };

                foreach (var product in newProducts)
                {
                    try
                    {
                        productRepository.Insert(product);
                        unitOfWork.SaveChanges();
                    }
                    catch (DbEntityValidationException ex)
                    {
                        var sb = new StringBuilder();

                        foreach (var failure in ex.EntityValidationErrors)
                        {
                            sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());

                            foreach (var error in failure.ValidationErrors)
                            {
                                sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
                                sb.AppendLine();
                            }
                        }

                        Debug.WriteLine(sb.ToString());
                        TestContext.WriteLine(sb.ToString());
                    }
                    catch (Exception ex)
                    {
                        Debug.WriteLine(ex.Message);
                        TestContext.WriteLine(ex.Message);
                    }
                }

                var insertedProduct = productRepository.Query(x => x.ProductName == "One").Select().FirstOrDefault();
                Assert.IsTrue(insertedProduct.ProductName == "One");
            }
        }
        public void Should_Delete_An_Entity()
        {
            var repository = new Repository<Author>();
            var author = repository.Insert(new Author()
            {
                FirstName = "Bruce",
                LastName = "Wayne"
            });

            repository.Delete(author.Id);
            author = repository.GetById(author.Id);
            Assert.IsNull(author);
        }
 public ActionResult Add(string id)
 {
     var repo = new Repository<SuggestionModel>(DbCollection.SuggestionFriend);
     var userId = User.Identity.GetUserId();
     var suggestion = new SuggestionModel
     {
         UserId = userId,
         UserSuggestionId = id,
         Created = DateTime.Now.ToString(),
         Enable = true
     };
     repo.Insert(suggestion);
     return Json(new { result = true });
 }
Example #18
0
        public void InsertWithDictionary()
        {
            var repo = new Repository<Employee, int>(StrictDataSource, EmployeeTableName);

            var emp1 = new Dictionary<string, object>() { { "FirstName", "Tom" }, { "LastName", "Jones" }, { "Title", "President" } };
            var echo1 = repo.Insert(emp1);

            Assert.AreNotEqual(0, echo1.EmployeeKey, "EmployeeKey was not set");
            Assert.AreEqual(emp1["FirstName"], echo1.FirstName, "FirstName");
            Assert.AreEqual(emp1["LastName"], echo1.LastName, "LastName");
            Assert.AreEqual(emp1["Title"], echo1.Title, "Title");

            repo.Delete(echo1.EmployeeKey.Value);

        }
Example #19
0
        public void CanAny()
        {
            using (var database = new MongoDbTest())
            {
                var repository = new Repository<ToDoItem>(database.Database);

                var item = new ToDoItem() { Item = "Item", Title = "Title" };
                item = repository.Insert(item);

                Assert.NotNull(item);

                Assert.True(repository.Any(e => e.Title == "Title"));
                Assert.False(repository.Any(e => e.Title == "test"));
            }
        }
Example #20
0
        public void CanCount()
        {
            using (var database = new MongoDbTest())
            {
                var repository = new Repository<ToDoItem>(database.Database);

                var item = new ToDoItem() { Item = "Item", Title = "Title" };
                item = repository.Insert(item);

                Assert.NotNull(item);

                Assert.Equal(1, repository.Count(e => e.Title == "Title"));
                Assert.Equal(0, repository.Count(e => e.Title == "test"));
            }
        }
Example #21
0
 protected override void DataPortal_Insert()
 {
     ExceptionManager.Process(
         () =>
             {
                 using (var repository = new Repository())
                 {
                     var dto = ToDTO();
                     repository.Insert(dto);
                     LoadProperty(CompanyIDProperty, dto.CompanyID);
                     FieldManager.UpdateChildren(repository, dto.CompanyID);
                     repository.Save();
                 }
             });
 }
Example #22
0
        public void CanDelete()
        {
            using (var database = new MongoDbTest())
            {
                var repository = new Repository<ToDoItem>(database.Database);

                var item = new ToDoItem() { Item = "Item", Title = "Title" };
                item = repository.Insert(item);

                Assert.NotNull(item);

                Assert.NotNull(repository.Delete(item));

                Assert.Null(repository.ById(item.Id));
            }
        }
        public void Should_work_without_an_ioc_container()
        {
            // Arrange
            // Act
            using (var context = new CodeFirstTestDbContext())
            using (var contextAdapter = new ContextAdaptor<ICodeFirstTestDbContext>(context))
            using (var unitOfWork = new UnitOfWork<ICodeFirstTestDbContext>(contextAdapter))
            {
                var roleRepository = new Repository<ICodeFirstTestDbContext, Role>(contextAdapter);
                roleRepository.Insert(_role);
                unitOfWork.SaveChanges();
            }

            // Assert
            HasRole(_role.Name).Should().BeTrue();
            HasUser(_user.FirstName, _user.LastName).Should().BeTrue();
        }
Example #24
0
        public static object AgregarActividad(string actividadJSON, string preguntasJSON, string respuestasJSON)
        {
            Actividade actividad = JsonConvert.DeserializeObject<Actividade>(actividadJSON);
            List<Pregunta> preguntas = JsonConvert.DeserializeObject<List<Pregunta>>(preguntasJSON);
            List<Respuesta> respuestas = JsonConvert.DeserializeObject<List<Respuesta>>(respuestasJSON);

            foreach (Pregunta p in preguntas)
            {
                foreach (Respuesta r in respuestas)
                {
                    if (p.ID == r.FK_Pregunta)
                    {
                        p.Respuestas.Add(r);
                    }
                }
            }

            //Converting List to EntitySet
            var preguntasEntitySet = new EntitySet<Pregunta>();
            preguntasEntitySet.AddRange(preguntas);

            actividad.Preguntas = preguntasEntitySet;

            using (var dataContext = new OBJ_REDDataContext())
            {
                var actRepo = new Repository<Actividade>(dataContext);
                try
                {
                    actRepo.Insert(actividad);
                    dataContext.SubmitChanges();
                    return (new
                    {
                        valido = true,
                        mensaje = "Actividad guardada correctamente."
                    });
                }
                catch (Exception)
                {
                    return (new
                    {
                        valido = false,
                        mensaje = "Hubo un error al internar guardar la actividad."
                    });
                }
            }
        }
Example #25
0
        private static void insereEnderecos()
        {
            var repEnd = new Repository<Endereco>();

            var end = new Endereco
            {
                TipoLogradouro = "Rua",
                Logradouro = "Líbero Badaró",
                Numero = "425",
                Complemento = "Edifício Grande São Paulo",
                Bairro = "Centro",
                MunicipioID = 1,
                CEP = "01009-905"
            };

            repEnd.Insert(end);
        }
        public void Should_work_without_an_ioc_container()
        {
            // Arrange
            // Act
            using (var context = new TestDbEntities())
            using (var contextAdapter = new ContextAdaptor<ITestDbContext>(context))
            using (var unitOfWork = new UnitOfWork<ITestDbContext>(contextAdapter))
            {
                var accountRepository = new Repository<ITestDbContext, Account>(contextAdapter);
                accountRepository.Insert(_account);

                unitOfWork.SaveChanges();
            }

            // Assert
            HasAccount(_account.Name).Should().BeTrue();
            HasTransaction(_account.Name, _transaction.Description).Should().BeTrue();
        }
Example #27
0
        public void Start()
        {
            browserSession = new BrowserSession();
            var cookies = new CookieCollection();
            //cookies.Add(new Cookie("psortfilter", "0$all$/nha-dat-ban") { Domain = "batdongsan.com.vn" });
            browserSession.Cookies = cookies;

            ids = new List<int>();
            var pages = CountPages("http://batdongsan.com.vn/nha-dat-ban");
            for (var i = 1; i <= pages; i++)
            {
                Console.WriteLine("-------------PAGE " + i + "-------------");
                var url = i == 1
                    ? "http://batdongsan.com.vn/nha-dat-ban"
                    : "http://batdongsan.com.vn/nha-dat-ban/p" + i;

                var page = Count(url);
                Console.WriteLine("in page: " + page + ". " + bdsReport.Debug);

            }

            browserSession = new BrowserSession();
            cookies = new CookieCollection();
            //cookies.Add(new Cookie("psortfilter", "0$all$/nha-dat-cho-thue") { Domain = "batdongsan.com.vn" });
            browserSession.Cookies = cookies;

            pages = CountPages("http://batdongsan.com.vn/nha-dat-cho-thue");
            for (var i = 1; i <= pages; i++)
            {
                Console.WriteLine("-------------PAGE " + i + "-------------");
                var url = i == 1
                    ? "http://batdongsan.com.vn/nha-dat-cho-thue"
                    : "http://batdongsan.com.vn/nha-dat-cho-thue/p" + i;

                var page = Count(url);
                Console.WriteLine("in page: " + page + ". " + bdsReport.Debug);

            }

            var repo = new Repository<BdsReport>("bdsreports");
            repo.Insert(bdsReport);

            Console.WriteLine("***************TOTAL: " + bdsReport.Count);
        }
Example #28
0
        public void AddProductUPHInfo(UPHInfo itemui)
        {
            string methodName = MethodBase.GetCurrentMethod().Name;
            BaseLog.LoggingBegin(logger, methodName);
            try
            {

                Entity.Repository.Meta.IMESSKU.UPH items = new Entity.Repository.Meta.IMESSKU.UPH
                {
                    Process = itemui.Process,
                    Attend_normal = itemui.Attend_normal,
                    Family = itemui.Family,
                    ST = itemui.ST,
                    NormalUPH = itemui.NormalUPH,
                    Cycle = itemui.Cycle,
                    Remark = itemui.Remark,
                    Special = itemui.Special,
                    Editor = itemui.Editor,
                    Cdt = itemui.Cdt,
                    Udt = itemui.Udt

                };
                using (UnitOfWork uow = new UnitOfWork())
                {
                    IRepository<Entity.Repository.Meta.IMESSKU.UPH> ecoModelRep = new Repository<Entity.Repository.Meta.IMESSKU.UPH>("UPHDBServer");
                    ecoModelRep.Insert(items);
                    uow.Commit();
                }



            }
            catch (Exception e)
            {
                BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e);
                throw;
            }
            finally
            {
                BaseLog.LoggingEnd(logger, methodName);
            }

        }
Example #29
0
 public void FixErrorDefaultData()
 {
     var repo = new Repository<UserModel>(DbCollection.User);
     var repoShare = new Repository<ShareSettingModel>(DbCollection.ShareSetting);
     var users = repo.Gets().ToList();
     Console.WriteLine("BEGIN INSERT MISSING DATA...");
     foreach (var user in users)
     {
         Console.WriteLine("CHECK ShareSetting: " + user.UserName);
         var shareSetting = repoShare.Gets().FirstOrDefault(m => m.UserId.Equals(user.Id.ToString()));
         if (shareSetting == null)
         {
             Console.WriteLine("BEGIN INSERT ShareSetting: " + user.UserName);
             repoShare.Insert(new ShareSettingModel { UserId = user.Id.ToString() });
         }
     }
     Console.WriteLine("DONE!!!!");
     Console.ReadLine();
 }
Example #30
0
        //===============================================================
        public static void BatchInsertAndRemove(Repository<TestClass> repo)
        {
            var testObjects = Enumerable.Range(0, 5).Select(x => new TestClass(x.ToString(), x.ToString())).ToList();

            repo.RemoveAll(repo.Items);
            repo.SaveChanges();
            Assert.IsTrue(!repo.Items.Any());

            repo.Insert(testObjects);
            repo.SaveChanges();
            Assert.IsTrue(repo.Items.Any());
            Assert.IsTrue(repo.Items.ToList().All(x => testObjects.Exists(y => y.ID == x.ID)));

            // Remove all batch
            repo.RemoveAll();
            repo.SaveChanges();
            Assert.IsTrue(!repo.Items.Any());

            // Remove all without saving in between
            repo.Insert(testObjects);
            repo.RemoveAll();
            repo.SaveChanges();
            Assert.IsTrue(!repo.Items.Any());

            // Remove all with inserts before and after
            repo.Insert(testObjects);
            repo.RemoveAll();
            repo.Insert(testObjects);
            repo.RemoveAll();
            repo.SaveChanges();
            Assert.IsTrue(!repo.Items.Any());

            repo.Insert(testObjects);
            repo.SaveChanges();

            // Remove all by key
            repo.RemoveAllByKey(repo.Items.ToList().Select(x => new object[] { x.ID }));
            repo.SaveChanges();

            Assert.IsTrue(!repo.Items.Any());

            // Remove all by object
            repo.Insert(testObjects);
            repo.SaveChanges();

            repo.RemoveAll(testObjects);
            repo.SaveChanges();

            Assert.IsTrue(!repo.Items.Any());
        }
 protected override IEnumerable <RatingsPredictionSchedule> AddRange(params RatingsPredictionSchedule[] models)
 {
     Repository.Insert(models.ToList());
     return(models);
 }
Example #32
0
 public override void Insert(CategoryInfo record)
 {
     Repository.Insert(record);
     LanguageCode = record.LanguageCode;
     ResetCache();
 }
Example #33
0
 public void SaveWorkMeetingForm(string keyValue, WorkMeetingEntity entity, List <WorkmeetingmeasuresEntity> list, string ids)
 {
     entity.ID = keyValue;
     if (entity.MEETINGTYPE == "收工会")
     {
         var e = this.BaseRepository().FindEntity(entity.StartMeetingid);
         e.IsOver = 1;//开收工会闭环
         this.BaseRepository().Update(e);
         for (int i = 0; i < list.Count; i++)
         {
             list[i].Workmeetingid = keyValue;
         }
     }
     if (!string.IsNullOrEmpty(keyValue))
     {
         var res = new Repository <WorkmeetingmeasuresEntity>(DbFactory.Base());
         WorkMeetingEntity re = this.BaseRepository().FindEntity(keyValue);
         if (re == null)
         {
             entity.Create();
             if (this.BaseRepository().Insert(entity) > 0)
             {
                 for (int i = 0; i < list.Count; i++)
                 {
                     list[i].Create();
                     list[i].CreateDate = list[i].CreateDate.Value.AddSeconds(i);
                 }
                 res.Insert(list);
             }
         }
         else
         {
             entity.Modify(keyValue);
             entity.ids = null;
             if (this.BaseRepository().Update(entity) > 0)
             {
                 int count = res.ExecuteBySql(string.Format("delete from epg_workmeetingmeasures where workmeetingid='{0}'", entity.ID));
                 for (int i = 0; i < list.Count; i++)
                 {
                     list[i].Create();
                     list[i].CreateDate = list[i].CreateDate.Value.AddSeconds(i);
                 }
                 res.Insert(list);
             }
         }
     }
     else
     {
         //手机端传空Id,需要处理关联Id
         entity.Create();
         var res = new Repository <WorkmeetingmeasuresEntity>(DbFactory.Base());
         if (this.BaseRepository().Insert(entity) > 0)
         {
             for (int i = 0; i < list.Count; i++)
             {
                 if (!string.IsNullOrWhiteSpace(list[i].ID))
                 {
                     list[i].ID = "";
                 }
                 list[i].Workmeetingid = entity.ID;
                 list[i].Create();
                 list[i].CreateDate = list[i].CreateDate.Value.AddSeconds(i);
             }
             res.Insert(list);
         }
     }
     if (!string.IsNullOrWhiteSpace(ids))
     {
         var listids = ids.Split(',');
         for (int i = 0; i < listids.Length; i++)
         {
             var e = new DangerdataService().GetEntity(listids[i]);
             if (e != null)
             {
                 e.UserNum += 1;
                 new DangerdataService().SaveForm(e.ID, e);
             }
         }
     }
 }
 public void Add(TestSubcategory TestCatg)
 {
     _TestSubCatgeroryRepository.Insert(TestCatg);
 }
 public virtual void Insert(T entity)
 {
     Repository.Insert(entity);
 }
Example #36
0
 public int Insert(ProductType _ProductTypeDao)
 {
     return(ProductTypeRepository.Insert(_ProductTypeDao));
 }
Example #37
0
 public void Insert(CentroCostoExperimento obj)
 {
     repository = unitOfWork.Repository <CentroCostoExperimento>();
     repository.Insert(obj);
 }
 protected override IEnumerable <Universe> AddRange(params Universe[] models)
 {
     Repository.Insert(models);
     return(models);
 }
Example #39
0
 public void Add(Refer ReferDoctor)
 {
     _ReferRepository.Insert(ReferDoctor);
 }
Example #40
0
 public virtual int Insert(T objec)
 {
     return(repo.Insert(objec));
 }
Example #41
0
 private void AddUserToDB() => Repository.Insert(entity: new User
 {
     Name    = UserNameTextBox.Text,
     Surname = UserSurnameTextBox.Text,
     Age     = Convert.ToInt32(UserAgeTextBox.Text)
 });
 public void Create(T entity)
 {
     _repository.Insert(entity);
 }
Example #43
0
 public void Insert(data.Objects.SnippetTema t)
 {
     _repo.Insert(t);
     _repo.Commit();
 }
Example #44
0
 public void Insert(data.Iglesia t)
 {
     _repository.Insert(t);
     _repository.Commit();
 }
Example #45
0
 public void Insert(Conductor obj)
 {
     repository.Insert(obj);
 }
 public void Insert(GatherRuleInfo gatherRuleInfo)
 {
     _repository.Insert(gatherRuleInfo);
 }
 /// <summary>
 /// 新增流程记录
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="entity"></param>
 /// <param name="trans"></param>
 public int Insert(IDbConnection conn, ProcessEntity entity, IDbTransaction trans)
 {
     return(Repository.Insert <ProcessEntity>(conn, entity, trans));
 }
Example #48
0
 public virtual int Insert(T entity)
 {
     return(_repo.Insert(entity));
 }
Example #49
0
 public void Insert(IDbConnection conn, ProcessEntity entity, IDbTransaction trans)
 {
     Repository.Insert <ProcessEntity>(conn, entity, trans);
 }
Example #50
0
 public void Insert(data.Departamento t)
 {
     _repo.Insert(t);
     _repo.Commit();
 }
Example #51
0
 public virtual void Insert(TDomainModel domain)
 {
     Repository.Insert(ConvertToPersistenceModel(domain));
 }
 protected override Universe Add(Universe model)
 {
     Repository.Insert(new [] { model });
     return(model);
 }
Example #53
0
 public void Insert(data.Objects.Quiz t)
 {
     _repo.Insert(t);
     _repo.Commit();
 }
 public int Insert(UserChallengeEnrollment _userChallengeEnrollment)
 {
     return(userChallengeEnrollmentProviderRepository.Insert(_userChallengeEnrollment));
 }
Example #55
0
 protected internal virtual void Insert(TEntity entity)
 {
     Repository.Insert(entity);
 }
 public new void Insert(Player player) => Repository.Insert(player);
Example #57
0
 public virtual int Insert(T obj)
 {
     return(_repository.Insert(obj));
 }
 public int Insert(PurchaseReceivedChallanTax _PurchaseReceivedChallanTax)
 {
     return(PurchaseReceivedChallanTaxDaoRepository.Insert(_PurchaseReceivedChallanTax));
 }
Example #59
0
 public bool Insert(T model)
 {
     return(_repository.Insert(model));
 }
Example #60
0
 public virtual int Insert(T entity)
 {
     return(repo_base.Insert(entity));
 }