public void Atualizar(Colaborador cliente) { _db.Update(cliente); _db.SaveChanges(); }
public void Create(Product product) { _db.Products.Add(product); _db.SaveChanges(); }
public bool Insert(Empresa empresa) { Context.Empresas.Add(empresa); Context.SaveChanges(); return(true); }
public void AssignUserToGroup() { Console.Clear(); var groupViews = new GruposView(); var user = this.SelectUser(); Console.Clear(); var group = groupViews.SelectGroup(); if (user == null || group == null) { System.Console.WriteLine("\n\t---> Error seleccionando el grupo o el usuario."); return; } try { System.Console.Write($"\n---> ¿Seguro desea asignar el usuario {user.Nombre} al grupo {group.Nombre}? s/n: "); var opcion = Console.ReadLine(); if (opcion != "s") { return; } } catch (System.Exception) { return; } using (_context = new AppDataContext()) { // FORMA 1: user.UsuarioGrupo.Add(new UserGroup { Usuario = user, Grupo = group }); _context.Usuarios.Update(user); // FORMA 2: //var userGroup = new UserGroup{Usuario = user, Grupo = group}; //_context.UsuariosGrupos.Add(new UserGroup{UserId = user.Id, GroupId = group.Id}); try { _context.SaveChanges(); System.Console.WriteLine("\n---> Asignacion correcta."); Console.Write("---> Presione ENTER para continuar... "); Console.ReadLine(); } catch (System.Exception) { System.Console.WriteLine("\n\t---> Error. Probablemente el usuario ya pertenezca al grupo."); System.Console.ReadLine(); return; } return; } }
public void Add(Vaga model) { _context.Vagas.Add(model); _context.SaveChanges(); }
public bool Insert(Funcionario funcionario) { Context.Funcionarios.Add(funcionario); Context.SaveChanges(); return(true); }
static void Main(string[] args) { #region Objetos var informatica = new Categoria { Id = 1, Titulo = "Informática" }; var artesMarciais = new Categoria { Id = 2, Titulo = "Artes Marciais" }; var ciencias = new Categoria { Id = 3, Titulo = "Ciências" }; var andre = new Autor { Id = 1, Nome = "André Baltieri" }; var bruce = new Autor { Id = 2, Nome = "Bruce Wayne" }; var peter = new Autor { Id = 3, Nome = "Peter Parker" }; var tony = new Autor { Id = 4, Nome = "Tony Stark" }; var devapi = new Livro { Id = 1, Titulo = "Desenvolvendo APIs com WebApi", CategoriaId = 1 }; var ninjitsu = new Livro { Id = 2, Titulo = "Os segredos do Ninjitsu", CategoriaId = 2 }; var aranhas = new Livro { Id = 3, Titulo = "O segredo das aranhas", CategoriaId = 3 }; var robotica = new Livro { Id = 4, Titulo = "Robótica avançada", CategoriaId = 3 }; #endregion #region Context using (AppDataContext db = new AppDataContext()) { db.Categorias.Add(informatica); db.Categorias.Add(artesMarciais); db.Categorias.Add(ciencias); db.Autores.Add(andre); db.Autores.Add(bruce); db.Autores.Add(peter); db.Autores.Add(tony); db.Livros.Add(devapi); db.Livros.Add(ninjitsu); db.Livros.Add(aranhas); db.Livros.Add(robotica); devapi.Autores.Add(andre); devapi.Autores.Add(tony); devapi.Autores.Add(bruce); ninjitsu.Autores.Add(bruce); devapi.Autores.Add(tony); aranhas.Autores.Add(peter); devapi.Autores.Add(tony); robotica.Autores.Add(tony); db.SaveChanges(); } #endregion #region Categorias using (AppDataContext db = new AppDataContext()) { Console.WriteLine("Categorias"); foreach (Categoria categoria in db.Categorias) { Console.WriteLine( String.Format("{0} - {1}", categoria.Id, categoria.Titulo)); } } #endregion Console.WriteLine(Environment.NewLine); #region Autores using (AppDataContext db = new AppDataContext()) { Console.WriteLine("Autores"); foreach (Autor autor in db.Autores) { Console.WriteLine( String.Format("{0} - {1}", autor.Id, autor.Nome)); } } #endregion Console.WriteLine(Environment.NewLine); #region Livros using (AppDataContext db = new AppDataContext()) { Console.WriteLine("Livros"); foreach (Livro livro in db.Livros) { Console.WriteLine( String.Format("{0} - {1}", livro.Id, livro.Titulo)); } } #endregion Console.WriteLine(Environment.NewLine); #region Tudo using (AppDataContext db = new AppDataContext()) { Console.WriteLine("Tudo"); foreach (Categoria categoria in db.Categorias.Include("Livros") .Include("Livros.Autores") .ToList()) { Console.WriteLine("Categoria: " + categoria.Titulo); foreach (Livro livro in categoria.Livros) { Console.WriteLine("\tLivro: " + livro.Titulo); foreach (Autor autor in livro.Autores) { Console.WriteLine("\t\tAutor: " + autor.Nome); } } Console.WriteLine(Environment.NewLine); } } #endregion Console.ReadKey(); }
public int addVideo(Video vid) { _db.Videos.Add(vid); _db.SaveChanges(); return(vid.id); }
public static void Initializer(IServiceProvider serviceProvider) { using (var context = new AppDataContext(serviceProvider.GetRequiredService <DbContextOptions <AppDataContext> >())) { //Agregando Artistas ala BD: if (context.Artistas.Any()) { return; } context.Artistas.AddRange ( new Artista { Nombre = "Luis Miguel" }, new Artista { Nombre = "Ricardo Argona" }, new Artista { Nombre = "Kalimba" }); context.SaveChanges(); //Agregando Albumes a la BD: if (context.Albums.Any()) { return; } context.Albums.AddRange ( new Album { ArtistaId = context.Artistas.FirstOrDefault(a => a.Nombre.Equals("Kalimba")).ArtistaId, Titulo = "Mi Otro YO", Precio = 555, }, new Album { ArtistaId = context.Artistas.FirstOrDefault(a => a.Nombre.Equals("Kalimba")).ArtistaId, Titulo = "Aerosoul", Precio = 275, }, new Album { ArtistaId = context.Artistas.FirstOrDefault(a => a.Nombre.Equals("Ricardo Argona")).ArtistaId, Titulo = "Circo solead", Precio = 180, }, new Album { ArtistaId = context.Artistas.FirstOrDefault(a => a.Nombre.Equals("Luis Miguel")).ArtistaId, Titulo = "Romance", Precio = 290, } ); context.SaveChanges(); } }
/// <summary> /// Note: you must first run the following SQL on your database for SNAPSHOT ISOLATION to be enabled: /// ALTER DATABASE ConcurrencyTestingEFCoreDb SET ALLOW_SNAPSHOT_ISOLATION ON /// </summary> /// <param name="stateInfo"></param> public void Snapshot(Object stateInfo) { TestInput testData = (TestInput)stateInfo; Console.WriteLine("{0} Running Transaction: IsolationLevel.Snapshot", testData.UserName); using (var _context = new AppDataContext()) { using (var transaction = _context.Database.BeginTransaction(System.Data.IsolationLevel.Snapshot)) { try { TestItem item = _context.TestItems.Find(testData.RecordId); int originalValue = item.Value; Console.WriteLine("{0} has read record {1}", testData.UserName, item.Id, item.Value); item.Value += 2; item.ModifiedBy = testData.UserName; item.Modified = DateTime.Now; Console.WriteLine("{0} is updating record {1}, setting Value:{2} + 2", testData.UserName, item.Id, originalValue); // now try to update the read lock to an exclusive lock _context.SaveChanges(); Console.WriteLine("{0} about to Commit Transaction", testData.UserName); transaction.Commit(); Console.WriteLine("{0} has Committed Transaction", testData.UserName); } catch (System.Data.SqlClient.SqlException ex) { Console.WriteLine("{0} - Error Info: {1}", testData.UserName, GetExceptionMessage(ex)); try { transaction.Rollback(); } catch (Exception ex1) { Console.WriteLine("{0} - Error trying to roll back transaction: {1}", testData.UserName, GetExceptionMessage(ex1)); } } catch (Exception ex) { Console.WriteLine("{0} Transaction failed. Error Info: {1}", testData.UserName, GetExceptionMessage(ex)); try { transaction.Rollback(); Console.WriteLine("{0} Transaction Rolled Back", testData.UserName); } catch (Exception ex1) { Console.WriteLine("{0} - Error Info: ", testData.UserName, GetExceptionMessage(ex1)); } } finally { testData.countDownEvent.Signal(); } } } }
public virtual void Create(T entity) { context.Set <T>().Add(entity); context.SaveChanges(); }
public void Create(Modalidade modalidade) { _contexto.Modalidades.Add(modalidade); _contexto.SaveChanges(); }
public void Update(ClientesDTO clientes) { _Context.Entry <ClientesDTO>(clientes).State = System.Data.Entity.EntityState.Modified; _Context.SaveChanges(); }
public BookReview AddUserReview(BookReview review) { _db.BookReviews.Add(review); _db.SaveChanges(); return(review); }
public void Create(Book book) { _context.Books.Add(book); _context.SaveChanges(); }
public void Create(User user) { _context.Users.Add(user); _context.SaveChanges(); }
public void Add(TEntity obj) { _context.Set <TEntity>().Add(obj); _context.SaveChanges(); }
static void Main(string[] args) { #region +Instances (Models) #region +Processors var processor_amd_fx = new Processor { Id = 1, Description = "FX9320" }; var processor_intel_corei7 = new Processor { Id = 2, Description = "COREI7" }; var processor_qualcomm = new Processor { Id = 3, Description = "QUALCOMM" }; #endregion #region +Computers var computer_amd = new Computer { Id = 1, HostName = "HOST-AMD", ProcessorId = 1 }; var computer_intel = new Computer { Id = 2, HostName = "HOST-INTEL", ProcessorId = 2 }; var computer_raspberry = new Computer { Id = 3, HostName = "HOST-RASPBERRY", ProcessorId = 3 }; #endregion #region +OS var os_linux = new OS { Id = 1, Description = "Linux" }; var os_windows = new OS { Id = 2, Description = "Windows" }; var os_macOS = new OS { Id = 3, Description = "macOS" }; #endregion #region +Profiles var profile1 = new Profile { UID = Guid.NewGuid(), Name = "Profile #1" }; var profile2 = new Profile { UID = Guid.NewGuid(), Name = "Profile #2" }; #endregion #endregion #region +Persistence using (var db = new AppDataContext()) { if (!db.Processors.Any()) { /* Computers */ db.Computers.AddRange(new Computer[] { computer_amd, computer_intel, computer_raspberry }); /* OSes */ db.OperatingSystems.AddRange(new OS[] { os_linux, os_macOS, os_windows }); /* Processors */ db.Processors.AddRange(new Processor[] { processor_amd_fx, processor_intel_corei7, processor_qualcomm }); /* Profiles */ db.Profiles.AddRange(new Profile[] { profile1, profile2 }); /* Relationship Samples */ computer_amd.OperatingSystems.Add(os_linux); computer_amd.OperatingSystems.Add(os_windows); computer_intel.OperatingSystems.Add(os_macOS); computer_raspberry.OperatingSystems.Add(os_linux); /* Commit */ db.SaveChanges(); } } #endregion #region +Populate using (var db = new AppDataContext()) { io.WriteLine("[Computers]"); foreach (var computer in db.Computers.Select(s => new { Id = s.Id, HostName = s.HostName })) { io.WriteLine($"ID: {computer.Id} HostName: {computer.HostName}"); } io.WriteLine(); io.WriteLine("[Processors]"); foreach (var processor in db.Processors.AsNoTracking()) { io.WriteLine($"ID: {processor.Id} ProcessorName: {processor.Description}"); } io.WriteLine(); io.WriteLine("[OS -> Computer]"); foreach (var os in db.OperatingSystems.Include("Computers")) { io.WriteLine($"ID: {os.Id} OS Name: {os.Description}"); foreach (var computer in os.Computers) { io.WriteLine($"\t ID: {computer.Id} HostName: {computer.HostName}"); } } io.WriteLine(); io.WriteLine("[Computer -> OS]"); foreach (var computer in db.Computers.Include("OperatingSystems")) { io.WriteLine($"ID: {computer.Id} HostName: {computer.HostName}"); foreach (var os in computer.OperatingSystems) { io.WriteLine($"\t ID: {os.Id} OS Name: {os.Description}"); } } } #endregion io.ReadKey(); }
public void SaveChange() { _context.SaveChanges(); }
public User Add(User user) { _context.Users.Add(user); _context.SaveChanges(); return(GetByEmail(user.Email)); }
public void Save(Customer customer) { _db.Customers.Add(customer); _db.SaveChanges(); }
public void Create(Contact contact) { _context.Contacts.Add(contact); _context.SaveChanges(); }
public bool Insert(Funcao funcao) { Context.Funcoes.Add(funcao); Context.SaveChanges(); return(true); }
public virtual void Save() { _context.SaveChanges(); }
protected void SaveChanges(int userId = 0) { TrackChanges(userId); _dbContext.SaveChanges(); }
public void RemoveUserFromGroup() { Console.Clear(); Console.WriteLine("\n---> QUITAR USUARIOS DE GRUPOS:"); Console.WriteLine("==============================="); var User = this.SelectUser(); if (User == null) { Console.WriteLine("\n---> Usuario Inexistente"); Console.Write("\n---> Presione ENTER para continuar... "); Console.ReadLine(); return; } List <Group> grupos; using (_context = new AppDataContext()) { grupos = _context.Grupos .Include(g => g.UsuarioGrupo) .Where(g => g.UsuarioGrupo.Any(ug => ug.UserId == User.Id)) .ToList(); } System.Console.WriteLine($"\n\t---> Usuario: {User.Nombre}"); if (grupos.Count == 0) { System.Console.WriteLine("\t -> El usuario no posee grupos."); Console.Write("\n---> Presione ENTER para continuar... "); Console.ReadLine(); return; } foreach (var grupo in grupos) { System.Console.WriteLine($"\t {grupo.Id} -> {grupo.Nombre}"); } System.Console.Write("\n---> Seleccione un grupo: "); var IdGrupo = int.Parse(Console.ReadLine()); using (_context = new AppDataContext()) { var grupo = _context.Grupos.FirstOrDefault(g => g.Id == IdGrupo); UserGroup userGroup = new UserGroup { GroupId = grupo.Id, UserId = User.Id }; _context.UsuariosGrupos.Remove(userGroup); _context.SaveChanges(); } Console.Write("\n---> Presione ENTER para continuar... "); Console.ReadLine(); }
public void Commit() { _context.SaveChanges(); }
public int Save() { return(Db.SaveChanges()); }
public void Criar(User user) { _context.Users.Add(user); /* SaveChanges vai persistir no banco */ _context.SaveChanges(); }
public void SaveChanges() { _appDataContext.SaveChanges(); }