public LocalController(LocalContext context) { _context = context; if (_context.Local.Count() == 0) { _context.Local.Add(new LocalModel { Id = 1, Ambiente = "PacotesVersao", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\PacoteVersao" }); _context.SaveChanges(); _context.Local.Add(new LocalModel { Id = 2, Ambiente = "Dev", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\Dev" }); _context.SaveChanges(); _context.Local.Add(new LocalModel { Id = 3, Ambiente = "QA", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\QA" }); _context.SaveChanges(); _context.Local.Add(new LocalModel { Id = 4, Ambiente = "PP", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\PP" }); _context.SaveChanges(); _context.Local.Add(new LocalModel { Id = 5, Ambiente = "Prod", Localizacao = @"C:\Users\Douglas\Desktop\Versionamento\Prod" }); _context.SaveChanges(); } }
public static void DBSetter(string strFirst, string strSecond) { using (LocalContext lcsContext = new LocalContext()) { lcsContext.LcsStrings.Add(new Lcs(strFirst, strSecond));//Connection to DB for saving results lcsContext.SaveChanges(); } }
public async override Task OnConnectedAsync() { try{ var httpContext = Context.GetHttpContext(); var tokenValue = httpContext.Request.Query["access_token"].ToString(); var usuarionome = _help.retornaUsuario(tokenValue); var usuario = _banco.usuario.Where(d => d.nome == usuarionome && d.ativo == true).FirstOrDefault(); if (usuario != null) { usuario.ativo = false; _banco.SaveChanges(); } await base.OnConnectedAsync(); UsuarioModel novousaurio = new UsuarioModel(); novousaurio.ativo = true; novousaurio.nome = usuarionome; novousaurio.datacriacao = DateTime.Now; novousaurio.connectionId = Context.ConnectionId; _banco.usuario.Add(novousaurio); _banco.SaveChanges(); var listausuarios = _banco.usuario.Where(d => d.ativo == true).ToList(); await Clients.All.SendAsync("listausuarios", listausuarios); }catch (Exception e) { throw new System.InvalidOperationException("Erro"); } }
public void AddToFavourites(cc310_reference_centre_file file) { using (LocalContext context = factory.CreateLocalContext()) { if (!IsFileInFavorite(file.file_full_nm)) { context.cc310_reference_centre_file.Add(file); context.SaveChanges(); } } }
public void RemoveFromFavourites(string fileFullName) { using (LocalContext context = factory.CreateLocalContext()) { var targetFile = context.cc310_reference_centre_file.FirstOrDefault(i => i.file_full_nm == fileFullName); if (targetFile != null) { context.cc310_reference_centre_file.Remove(targetFile); context.SaveChanges(); } } }
public void HookedDbContext_AfterConstruction_CanRegisterNewHooks() { var context = new LocalContext(); context.RegisterHook(new TimestampPreInsertHook()); var entity = new TimestampedSoftDeletedEntity(); context.Entities.Add(entity); context.SaveChanges(); Assert.AreEqual(entity.CreatedAt.Date, DateTime.Today); }
public void HookedDbContext_CanLateBindPostActionHooks() { var context = new LocalContext(); context.RegisterHook(new TimestampPostInsertHook()); var tsEntity = new TimestampedSoftDeletedEntity(); tsEntity.CreatedAt = DateTime.Now; context.Entities.Add(tsEntity); context.SaveChanges(); Assert.AreEqual(DateTime.Today, tsEntity.ModifiedAt.Value.Date); }
public void HookedDbContext_ShouldNotHook_IfAnyChangedObjectsAreInvalid() { var context = new LocalContext(); context.RegisterHook(new TimestampPreInsertHook()); var tsEntity = new TimestampedSoftDeletedEntity(); var valEntity = new ValidatedEntity(); context.Entities.Add(tsEntity); context.ValidatedEntities.Add(valEntity); Assert.Throws <DbEntityValidationException>(() => context.SaveChanges()); Assert.AreNotEqual(tsEntity.CreatedAt.Date, DateTime.Today); }
public void HookedDbContext_MustCallHooks_WhenRunningSaveChanges() { var hooks = new IHook[] { new TimestampPreInsertHook() }; var context = new LocalContext(hooks); var entity = new TimestampedSoftDeletedEntity(); context.Entities.Add(entity); context.SaveChanges(); Assert.AreEqual(entity.CreatedAt.Date, DateTime.Today); }
public RetornoModel CriarSala(string nomesala, string usuario) { RetornoModel retorno = new RetornoModel(); try{ var idsala = _help.RandomString(6); SalaModel novasala = new SalaModel(); novasala.datacriacao = DateTime.Now; novasala.donosala = usuario; novasala.jogador1 = usuario; novasala.nomesala = nomesala; novasala.ativa = true; novasala.idsala = idsala; _local.sala.Add(novasala); _local.SaveChanges(); retorno.status = "OK"; retorno.resultado = idsala; return(retorno); }catch (Exception e) { return(retorno); } }
public void HookedDbContext_MustCallHooks_IfModelIsInvalidButUnchanged() { var context = new LocalContext(); context.RegisterHook(new TimestampPreInsertHook()); var tsEntity = new TimestampedSoftDeletedEntity(); var valEntity = new ValidatedEntity(); context.Entities.Add(tsEntity); context.Entry(valEntity).State = EntityState.Unchanged; Assert.DoesNotThrow(() => context.SaveChanges()); Assert.AreEqual(tsEntity.CreatedAt.Date, DateTime.Today); }
public void HookedDbContext_MustOnlyHookWhenObjectIsInTheSameState() { var context = new LocalContext(); context.RegisterHook(new TimestampPreInsertHook()); context.RegisterHook(new TimestampPreUpdateHook()); var tsEntity = new TimestampedSoftDeletedEntity(); tsEntity.CreatedAt = DateTime.Now; context.Entities.Add(tsEntity); context.SaveChanges(); Assert.AreEqual(DateTime.Today, tsEntity.CreatedAt.Date); Assert.IsFalse(tsEntity.ModifiedAt.HasValue); }
public void HookedDbContext_PostActionHookMethod_MustHaveTheContextPassedInTheMetadata() { var context = new LocalContext(); var postAction = A.Fake <PostInsertHook <ITimeStamped> >(); A.CallTo(() => postAction.HookStates).Returns(EntityState.Added); context.RegisterHook(postAction); // We aren't testing the hook here var entity = new TimestampedSoftDeletedEntity { CreatedAt = DateTime.Now }; context.Entities.Add(entity); context.SaveChanges(); A.CallTo(() => postAction.Hook(entity, A <HookEntityMetadata> .That.Matches(m => m.CurrentContext == context))).MustHaveHappened(); }
public Return CriarUsuario(Usuario user) { UsuarioValidator validator = new UsuarioValidator(_context); ValidationResult results = validator.Validate(user); if (!results.IsValid) { return(new Return(results.Errors)); } user.Senha = Hashing.HashMD5(user.Senha); user.DataCriacao = DateTime.Now; _context.Add(user); _context.SaveChanges(); return(new Return(user)); }
public void HookedDbContext_MustNotCallHooks_IfModelIsInvalid() { var hooks = new IHook[] { new TimestampPreInsertHook() }; var context = new LocalContext(hooks); var validatedEntity = new ValidatedEntity(); context.ValidatedEntities.Add(validatedEntity); try { context.SaveChanges(); } catch { } Assert.AreNotEqual(validatedEntity.CreatedAt.Date, DateTime.Today); }
static void Main() { Console.WriteLine("Attempting to make connection with ' DESKTOP-K3B9EQ2\\SQLEXPRESS '"); Console.Clear(); while (true) { Console.Write("Program for solving LCS problem \n Please enter 2 string separated with ',' : "); var input = Console.ReadLine(); string[] words = input.Split(','); if (words.Length == 2 && input.All(c => Char.IsLetterOrDigit(c) || c == ',')) { using (LocalContext lcsContext = new LocalContext()) { Lcs lcs = new Lcs(words[0], words[1]); lcsContext.LcsStrings.Add(new Lcs(words[0], words[1]));//saving results to DB Console.WriteLine("\nLast answers\n" + new string('-', 25)); var answs = (from answers in lcsContext.LcsStrings select answers).ToList(); //writes last 5 or less elements from DB lcsContext.LcsStrings.Skip(Math.Max(0, lcsContext.LcsStrings.Count() - 5)).ToList().ForEach(e => Console.WriteLine($"\nS1 : {e.FirstString}\nS2 : {e.SecondString}\nLCS: {e.AnswerString} \n")); Console.WriteLine(new string('-', 25) + "\nYour answer\n" + new string('-', 25)); lcs.LcsOut(); Console.WriteLine("\n" + new string('-', 25)); Console.WriteLine("Press 'Enter' for saving changes or close Console for discard"); Console.ReadKey(); lcsContext.SaveChanges(); } Environment.Exit(0); } else { Console.Clear(); Console.WriteLine("Wrong input, please try again \n"); } } }
public void HookedDbContext_ShouldHook_IfValidateBeforeSaveIsDisabled_AndChangedObjectsAreInvalid() { var context = new LocalContext(); context.Configuration.ValidateOnSaveEnabled = false; context.RegisterHook(new TimestampPreInsertHook()); var tsEntity = new TimestampedSoftDeletedEntity(); var valEntity = new ValidatedEntity(); context.Entities.Add(tsEntity); context.ValidatedEntities.Add(valEntity); Assert.IsTrue(context.GetValidationErrors().Any(x => !x.IsValid)); Assert.Throws <DbUpdateException>(() => context.SaveChanges()); Assert.AreEqual(tsEntity.CreatedAt.Date, DateTime.Today); Assert.AreEqual(valEntity.CreatedAt.Date, DateTime.Today); }
public void HookedDbContext_ShouldPostHook_IfNoExceptionIsHit() { var runCheckingHook = new RunCheckedPreInsertHook(); var hooks = new IHook[] { runCheckingHook, new TimestampPostInsertHook() }; var context = new LocalContext(hooks); var tsEntity = new TimestampedSoftDeletedEntity(); tsEntity.CreatedAt = DateTime.Now; context.Entities.Add(tsEntity); context.SaveChanges(); Assert.IsTrue(runCheckingHook.HasRun); Assert.AreEqual(DateTime.Today, tsEntity.ModifiedAt.Value.Date); }
public void HookedDbContext_ShouldNotPostHook_IfExceptionIsHit() { var runCheckingHook = new RunCheckedPreInsertHook(); var hooks = new IHook[] { runCheckingHook, new TimestampPostInsertHook() }; var context = new LocalContext(hooks); var valEntity = new ValidatedEntity(); valEntity.CreatedAt = DateTime.Now; context.ValidatedEntities.Add(valEntity); Assert.Throws <DbEntityValidationException>(() => context.SaveChanges()); Assert.IsFalse(runCheckingHook.HasRun); Assert.IsFalse(valEntity.ModifiedAt.HasValue); }
public void Add(T entity) { var temp = _localContext.Set <T>().Add(entity); _localContext.SaveChanges(); }
public virtual T Add(T t) { _context.Set <T>().Add(t); _context.SaveChanges(); return(t); }
public void Save() { context.SaveChanges(); }
public int SaveUser([FromBody] UserMaster user) { _context.Add(user); return(_context.SaveChanges()); }
public void AddElement(Lcs lcs) { context.LcsStrings.Add(lcs); context.SaveChanges(); }
public void Atualizar(Unidade local) { _context.Unidades.Update(local); var status = _context.SaveChanges(); }