public IActionResult EditarUsuario([FromBody] Usuarios u) { try { var context = new postgresContext(); u.IdTipoUsuarioNavigation = null; u.Senha = context.Usuarios.FirstOrDefault(x => x.IdUsuario == u.IdUsuario).Senha; context.Usuarios.Update(u); context.SaveChanges(); context.Dispose(); return(new ResultWithBody { Code = System.Net.HttpStatusCode.OK, Body = "Alteração de Usuário - Usuário Alterado", }); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.Unauthorized, Body = ex.Message, }); } }
public IActionResult Comentarios([FromBody] Comentarios comentario) { try { var context = new postgresContext(); context.Comentarios.Add(comentario); context.SaveChanges(); context.Dispose(); return(new ResultWithBody { Code = System.Net.HttpStatusCode.OK, Body = "Inserção de Cometarios - Comentario Inserido!", }); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.InternalServerError, Body = "GetFurnaces - Fatal error retrieving furnaces configuration", }); } }
public async Task UpdatesNpgSql() { var toUpdate = NpgSqlIds.Take(2) .ToDictionary(key => key, value => DateTime.UtcNow.AddDays(value + 1)); using (var db = new postgresContext()) { var result = await db.Efcoretest.BulkUpdateAsync(toUpdate.Select(x => x.Key), id => new Efcoretest { Modifieddate = toUpdate[id] }); Assert.Equal(toUpdate.Count, result); } using (var db = new postgresContext()) { var updated = await db.Efcoretest .Where(x => toUpdate.Select(y => y.Key).Contains(x.Id)) .ToListAsync(); Assert.Equal(toUpdate.Count, updated.Count); foreach (var u in updated) { Assert.Contains(u.Id, toUpdate.Select(x => x.Key)); var expected = toUpdate[u.Id]; var actual = u.Modifieddate; Assert.Equal(expected.ToString("d"), actual.ToString("d")); } } }
public IActionResult CriarUsuario([FromBody] Usuarios u) { try { var context = new postgresContext(); context.Usuarios.Add(u); context.SaveChanges(); context.Dispose(); return(new ResultWithBody { Code = System.Net.HttpStatusCode.OK, Body = "Inclusão de Usuário - Usuário Inserido", }); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.Unauthorized, Body = ex.Message, }); } }
public async Task RemovesNpgSql() { var toDelete = NpgSqlIds.Skip(5).Take(5).ToList(); using (var db = new postgresContext()) { var entities = await db.Efcoretest .Where(e => toDelete.Contains(e.Id)) .ToListAsync(); Assert.NotEmpty(entities); } using (var db = new postgresContext()) { var result = await db.Efcoretest .Where(e => e.Name.Contains(nameof(BulkRemoveTests))) .BulkRemoveAsync(toDelete); Assert.Equal(5, result); } using (var db = new postgresContext()) { var entities = await db.Efcoretest .Where(e => toDelete.Contains(e.Id)) .ToListAsync(); Assert.Empty(entities); } }
public IActionResult FinlizarCarrinho([FromBody] Usuarios usuario) { try { var context = new postgresContext(); var objs = context.CarrinhoCompras.Where(x => x.IdUsuario == usuario.IdUsuario && x.Finalizado == false).ToList(); foreach (CarrinhoCompras c in objs) { c.Finalizado = true; context.CarrinhoCompras.Update(c); var prod = context.Produtos.FirstOrDefault(a => a.IdProduto == c.IdProduto); prod.Quantidade -= c.Quantidade; context.Produtos.Update(prod); } context.SaveChanges(); context.Dispose(); return(new ResultWithBody { Code = System.Net.HttpStatusCode.OK, Body = "Compra Realizada!", }); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.InternalServerError, Body = "GetFurnaces - Fatal error retrieving furnaces configuration", }); } }
public IActionResult EditarProduto([FromBody] Produtos p) { try { var context = new postgresContext(); context.Produtos.Update(p); context.SaveChanges(); context.Dispose(); return(new ResultWithBody { Code = System.Net.HttpStatusCode.OK, Body = "Edição de Produto - Produto Editado!", }); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.InternalServerError, Body = "GetFurnaces - Fatal error retrieving furnaces configuration", }); } }
public IActionResult DeletarUsuario(int idUsuario) { try { var context = new postgresContext(); var usuario = context.Usuarios.FirstOrDefault(x => x.IdUsuario == idUsuario); context.Remove(usuario); context.SaveChanges(); context.Dispose(); return(new ResultWithBody { Code = System.Net.HttpStatusCode.OK, Body = "Exclusão de Usuário - Usuário Excluído", }); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.Unauthorized, Body = ex.Message, }); } }
public async Task CreatesNpgSql() { var toCreate = new List <Efcoretest>(); for (var i = 0; i < 10; i++) { toCreate.Add(new Efcoretest { Name = i == 0 ? null : $"{nameof(BulkAddTests)}_{i}", Createddate = DateTime.UtcNow, Modifieddate = DateTime.UtcNow }); } using (var db = new postgresContext()) { await db.Efcoretest.BulkAddAsync(toCreate); foreach (var e in toCreate) { var added = await db.Efcoretest.FindAsync(e.Id); Assert.NotNull(added); Assert.Equal(e.Name, added.Name); } } }
public IActionResult Listar() { try { var context = new postgresContext(); var usrs = context.Usuarios.Include(x => x.IdTipoUsuarioNavigation).ToList(); context.Dispose(); if (usrs != null) { usrs = usrs.Select(e => { var ret = e; e.Senha = ""; return(e); }).ToList(); } return(new ObjectResult(usrs)); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.Unauthorized, Body = ex.Message, }); } }
public static void EnsureDatabaseCreated() { var optionsBuilder = new DbContextOptionsBuilder(); if (HostingEnvironment.IsDevelopment()) { optionsBuilder.UseSqlServer(Configuration["Data:dev:DataContext"]); } else if (HostingEnvironment.IsStaging()) { optionsBuilder.UseSqlServer(Configuration["Data:staging:DataContext"]); } else if (HostingEnvironment.IsProduction()) { optionsBuilder.UseSqlServer(Configuration["Data:live:DataContext"]); } var context = new postgresContext(optionsBuilder.Options); context.Database.EnsureCreated(); optionsBuilder = new DbContextOptionsBuilder(); if (HostingEnvironment.IsDevelopment()) { optionsBuilder.UseSqlServer(Configuration["Data:dev:TransientContext"]); } else if (HostingEnvironment.IsStaging()) { optionsBuilder.UseSqlServer(Configuration["Data:staging:TransientContext"]); } else if (HostingEnvironment.IsProduction()) { optionsBuilder.UseSqlServer(Configuration["Data:live:TransientContext"]); } new postgresContext(optionsBuilder.Options).Database.EnsureCreated(); }
public IActionResult Logar([FromBody] Usuarios u) { try { var context = new postgresContext(); var usuario = context.Usuarios.Where(x => x.Email == u.Email).FirstOrDefault(); context.Dispose(); if (usuario == null || usuario.Senha != u.Senha) { throw new Exception("Senha ou usuário incorretos."); } usuario.Senha = ""; return(new ObjectResult(usuario)); } catch (Exception ex) { Console.WriteLine("[error] ConfigController - GetFurnaces - {0} - {1}", ex.Message, ex.StackTrace.Replace(Environment.NewLine, " ")); return(new ResultWithBody { Code = System.Net.HttpStatusCode.Unauthorized, Body = ex.Message, }); } }
public void character_item_add(CharactersItem char_item) { using (postgresContext db = new postgresContext()) { db.CharactersItems.Add(char_item); db.SaveChanges(); } }
public Account account_get_by_id(int acc_id) { using (postgresContext db = new postgresContext()) { var account = db.Accounts.FirstOrDefault(d => d.Id == acc_id); return(account); } }
public Item item_get_by_id(int item_id) { using (postgresContext db = new postgresContext()) { var item = db.Items.FirstOrDefault(a => a.Id == item_id); return(item); } }
public List <Item> items_print() { using (postgresContext db = new postgresContext()) { var items = db.Items.ToList(); return(items); } }
public List <Character> character_print() { using (postgresContext db = new postgresContext()) { var characters = db.Characters.ToList(); return(characters); } }
private void InitCompanyTable(postgresContext context) { var json = File.ReadAllText(".\\TestData\\company_data.json"); List <Company> model = JsonConvert.DeserializeObject <List <Company> >(json); context.AddRange(model); context.SaveChanges(); }
public string getDescr() { using (postgresContext db = new postgresContext()) { string desc = db.game_descr.ToList()[0].description; return(desc); } }
public IActionResult Index() { using (var db = new postgresContext()) { } return(View()); }
public Character character_get_by_id(int id) { using (postgresContext db = new postgresContext()) { var character = db.Characters.Find(id); return(character); } }
public List <Account> account_print() { using (postgresContext db = new postgresContext()) { var directors = db.Accounts.ToList(); return(directors); } }
public Repository(postgresContext db) { _db = db; if (_db != null) { _dbSet = _db.Set <T>(); } }
public void Login() { using (var db = new postgresContext()) { User user = db.User.AsEnumerable() .Where(p => p.Name == "malik" && p.Password == "chanbaz").FirstOrDefault(); Assert.AreNotEqual(user, null); } }
public void item_edit(Item item) { using (postgresContext db = new postgresContext()) { var a = item_get_by_id(item.Id); a = item; db.SaveChanges(); } }
public string GetID() { var email = _httpContextAccessor.HttpContext.User.Identity.Name; using (var db = new postgresContext()) { return(db.AspNetUsers.Single(x => x.Email == email).Id); } }
public void deleteUpg(int getId) { using (postgresContext db = new postgresContext()) { var upgrade = db.upgrades.ToList().Where(el => el.id == getId).ToList()[0]; db.upgrades.Remove(upgrade); db.SaveChanges(); } }
public void account_edit(Account acc) { using (postgresContext db = new postgresContext()) { var d = account_get_by_id(acc.Id); d = acc; db.SaveChanges(); } }
public void character_edit(Character char_) { using (postgresContext db = new postgresContext()) { var m = character_get_by_id(char_.Id); m = char_; db.SaveChanges(); } }
public int character_add(Character char_) { using (postgresContext db = new postgresContext()) { db.Characters.Add(char_); db.SaveChanges(); var m = db.Characters.Max(m => m.Id); return(m); } }