public List <ComentarioModel> Consultar(Guid idProntuario)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
return(db.Comentarios.Where(x => x.IdProntuario == idProntuario).ToList());
}
}
public List <DiscussaoModel> Consultar(Guid idForum)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
return(db.Discussoes.Where(x => x.IdForum == idForum).ToList());
}
}
public Models.AnuncioWebmotors Consultar(int id)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
return(db.tb_AnuncioWebmotors.Where(x => x.ID == id).FirstOrDefault());
}
}
public List <AnexoModel> Consultar(Guid idUsuario)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
return(db.Anexos.Where(x => x.IdUsuario == idUsuario).ToList());
}
}
public DiaaDiaModel Consultar(Guid idPaciente)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
return(db.DiaaDia.Where(x => x.IdPaciente == idPaciente).FirstOrDefault());
}
}
public List <ContatoModel> Consultar(Guid idPaciente)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
return(db.Contatos.Where(x => x.IdPaciente == idPaciente).ToList());
}
}
public List <Models.AnuncioWebmotors> Consultar()
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
return(db.tb_AnuncioWebmotors.ToList());
}
}
public void Remover(Models.AnuncioWebmotors car)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.tb_AnuncioWebmotors.Remove(car);
db.SaveChanges();
}
}
public void Atualizar(Models.Anuncio car)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.tb_Anuncio.Update(car);
db.SaveChanges();
}
}
public void Incluir(Models.Anuncio car)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.tb_Anuncio.Add(car);
db.SaveChanges();
}
}
public Guid Salvar(ContatoModel contato)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.Contatos.Add(contato);
db.SaveChanges();
return(contato.Id);
}
}
public Guid Salvar(CirurgiaModel cirurgia)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.Cirurgias.Add(cirurgia);
db.SaveChanges();
return(cirurgia.Id);
}
}
public Guid Salvar(DiscussaoModel discussao)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.Discussoes.Add(discussao);
db.SaveChanges();
return(discussao.Id);
}
}
private void InitializeUsers()
{
using (var context = new MainContextFactory().CreateDbContext())
{
var defaultAdmin = context.Users.FirstOrDefault(x => x.Id == 1);
// TODO: Figure out how to create a default user using the ApplicationUserService
}
}
public Guid Salvar(DiaaDiaModel diaaDia)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.DiaaDia.Add(diaaDia);
db.SaveChanges();
return(diaaDia.Id);
}
}
public Guid Salvar(AnexoModel anexo)
{
using (var db = new MainContextFactory().CreateDbContext(null))
{
db.Anexos.Add(anexo);
db.SaveChanges();
return(anexo.Id);
}
}
public async Task InitializeUsers()
{
using (var context = new MainContextFactory().CreateDbContext())
{
var userCount = context.Users.Select(x => 1).Count();
if (userCount == 0)
{
await GenerateDefaultUser();
}
}
}
private void RefreshUsers()
{
using (var context = new MainContextFactory().CreateDbContext())
{
_users = context.Users
.Select(x => new UserDto()
{
UserId = x.Id,
Username = x.UserName
})
.ToList();
}
}
private async Task <IEnumerable <ApplicationEnumDto> > GetAsync()
{
using (var context = new MainContextFactory().CreateDbContext())
{
return(await context.ApplicationEnums
.Select(x => new ApplicationEnumDto()
{
ApplicationEnumId = x.ApplicationEnumId,
Category = x.Category,
Name = x.Name,
SubCategory = x.SubCategory,
Value = x.Value,
ValueType = x.ValueType
})
.ToListAsync());
}
}
public ApplicationContext(
Authorizer authorizer,
Navigator navigator,
MainContextFactory mainContextFactory,
AuthorizationContextFactory authorizationContextFactory
)
{
_authorizer = authorizer;
_navigator = navigator;
_mainContextFactory = mainContextFactory;
_authorizationContextFactory = authorizationContextFactory;
_authorizationStateSubscription = _authorizer
.States()
.Subscribe(ObserveAuthorizationNavigation);
_boardNavigationSubscription = _navigator
.BoardNavigations()
.Subscribe(ObserveBoardNavigation);
}
