public async Task <AdmsBot> Get(AdmsBot adms)
{
using Kurosawa_DiaContext context = new Kurosawa_DiaContext();
return(await context.AdmsBots.AsNoTracking().SingleOrDefaultAsync(x => x.Usuario.ID == adms.Usuario.ID));
//using (Kurosawa_DiaContext context = new Kurosawa_DiaContext())
//{
// return (await context.AdmsBots.FromSqlRaw("call LerAdms({0})", adms.Usuario.ID).ToListAsync()).FirstOrDefault();
//}
}
internal static async Task<TiposAdms> CheckAdm(DiscordUser usuario)
{
AdmsBot usuarioAdm = await new AdmsBotDAO().Get(new AdmsBot
{
Usuario = new Usuarios
{
ID = usuario.Id
}
}) ?? new AdmsBot
{
Permissao = (usuario.Id == IDOwner) ? TiposAdms.Dono : TiposAdms.Nenhuma
};
return usuarioAdm.Permissao;
}
public async Task Atualizar(AdmsBot adms)
{
using Kurosawa_DiaContext context = new Kurosawa_DiaContext();
AdmsBot admsBot = await context.AdmsBots.SingleOrDefaultAsync(x => x.Usuario.ID == adms.Usuario.ID);
if (admsBot != null)
{
admsBot.Permissao = adms.Permissao;
await context.SaveChangesAsync();
}
else
{
await context.AdmsBots.AddAsync(new AdmsBot
{
CodUsuario = (await context.Usuarios.AsNoTracking().SingleOrDefaultAsync(x => x.ID == adms.Usuario.ID)).Cod,
Permissao = adms.Permissao
});
await context.SaveChangesAsync();
}
//using (Kurosawa_DiaContext context = new Kurosawa_DiaContext())
//{
// //IDbContextTransaction transation = await context.Database.BeginTransactionAsync(IsolationLevel.Snapshot);
// //await context.Database.ExecuteSqlRawAsync("call AtualizarAdm({0}, {1})", adms.Usuario.ID, adms.Permissao);
// //_ = context.AdmsBots.FromSqlRaw("call AtualizarAdm({0}, {1})", adms.Usuario.ID, adms.Permissao);
// //await transation.CommitAsync();
// MySqlCommand command = await context.GetMysqlCommand();
// command.CommandText = "call AtualizarAdm(@ui, @up)";
// command.Parameters.AddWithValue("@ui", adms.Usuario.ID);
// command.Parameters.AddWithValue("@up", adms.Permissao);
// await command.ExecuteNonQueryAsync();
//}
}
