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);
}
}
