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); }
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(); } }
private void Child_Insert(Repository repository, int companyID) { LoadProperty(CompanyIDProperty, companyID); var dto = ToDTO(); repository.Insert(dto); LoadProperty(EmployeeStatusIDProperty, dto.EmployeeStatusID); }
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); }
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); } }
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 }); }
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); } }
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); } }
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; }
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 }); }
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); }
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")); } }
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")); } }
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(); } }); }
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(); }
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." }); } } }
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(); }
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); }
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); } }
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(); }
//=============================================================== 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); }
public override void Insert(CategoryInfo record) { Repository.Insert(record); LanguageCode = record.LanguageCode; ResetCache(); }
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); }
public int Insert(ProductType _ProductTypeDao) { return(ProductTypeRepository.Insert(_ProductTypeDao)); }
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); }
public void Add(Refer ReferDoctor) { _ReferRepository.Insert(ReferDoctor); }
public virtual int Insert(T objec) { return(repo.Insert(objec)); }
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); }
public void Insert(data.Objects.SnippetTema t) { _repo.Insert(t); _repo.Commit(); }
public void Insert(data.Iglesia t) { _repository.Insert(t); _repository.Commit(); }
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)); }
public virtual int Insert(T entity) { return(_repo.Insert(entity)); }
public void Insert(IDbConnection conn, ProcessEntity entity, IDbTransaction trans) { Repository.Insert <ProcessEntity>(conn, entity, trans); }
public void Insert(data.Departamento t) { _repo.Insert(t); _repo.Commit(); }
public virtual void Insert(TDomainModel domain) { Repository.Insert(ConvertToPersistenceModel(domain)); }
protected override Universe Add(Universe model) { Repository.Insert(new [] { model }); return(model); }
public void Insert(data.Objects.Quiz t) { _repo.Insert(t); _repo.Commit(); }
public int Insert(UserChallengeEnrollment _userChallengeEnrollment) { return(userChallengeEnrollmentProviderRepository.Insert(_userChallengeEnrollment)); }
protected internal virtual void Insert(TEntity entity) { Repository.Insert(entity); }
public new void Insert(Player player) => Repository.Insert(player);
public virtual int Insert(T obj) { return(_repository.Insert(obj)); }
public int Insert(PurchaseReceivedChallanTax _PurchaseReceivedChallanTax) { return(PurchaseReceivedChallanTaxDaoRepository.Insert(_PurchaseReceivedChallanTax)); }
public bool Insert(T model) { return(_repository.Insert(model)); }
public virtual int Insert(T entity) { return(repo_base.Insert(entity)); }