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