public List <Entity> GetirHepsi()
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Set <Entity>().ToList());
}
}
public Entity GetirIdile(int id)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Set <Entity>().Find(id));
}
}
public List <Hasta> GetirileAppUserId(int appUserId)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Where(x => x.AppUserId == appUserId).ToList());
}
}
public int GetirTamamlanmisHastaSayisi()
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Where(x => x.Durum).Count());
}
}
public List <Bildirim> GetirOkunmayanlar(int appUserId)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Bildirimler.Where(x => x.AppUserId == appUserId && !x.Durum).ToList());
}
}
public int GetirAktifHastaSayisiAppUserId(int appUserId)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Where(x => x.AppUserId == appUserId && !x.Durum).Count());
}
}
public int GetirEkipOlmayanHasta()
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Where(x => x.AppUserId == null && !x.Durum).Count());
}
}
public int GetirOkunmayanBildirimSayisi(int appUserId)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Bildirimler.Where(x => x.AppUserId == appUserId && !x.Durum).Count());
}
}
public int GetirToplamRaporSayisi()
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Raporlar.Count());
}
}
public void Sil(Entity entity)
{
using (var context = new CoronaHastaTakipContext())
{
context.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Deleted;
context.SaveChanges();
}
}
public List <Hasta> GetirTumTablolar()
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Include(x => x.AppUser).Include(x => x.Aciliyet).Include(x => x.Raporlar)
.Where(x => !x.Durum).OrderByDescending(x => x.TestTarihi).ToList());
}
}
public Hasta GetirAciliyetileHastaListesiById(int id)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Include(x => x.Aciliyet).FirstOrDefault(x => !x.Durum &&
x.Id == id));
}
}
public List <Hasta> GetirAciliyetIleHastaListesi()
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Include(x => x.Aciliyet).Where(x => !x.Durum).
OrderByDescending(x => x.TestTarihi).ToList());
}
}
public List <Hasta> GetirTumTablolarByFilter(Expression <Func <Hasta, bool> > filter)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Include(x => x.AppUser).Include(x => x.Aciliyet).Include(x => x.Raporlar)
.Where(filter).OrderByDescending(x => x.TestTarihi).ToList());
}
}
public Hasta GetirRaporlarIleUserById(int id)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Hastalar.Include(x => x.Raporlar).Include(x => x.AppUser).Include(x => x.Aciliyet)
.FirstOrDefault(x => x.Id == id));
}
}
public Rapor GetirHastaIleAciliyetById(int id)
{
using (var context = new CoronaHastaTakipContext())
{
return(context.Raporlar.Include(x => x.Hasta).ThenInclude(x => x.Aciliyet)
.FirstOrDefault(x => x.Id == id));
}
}
public int GetirRaporSayisiAppUserId(int appUserId)
{
using (var context = new CoronaHastaTakipContext())
{
var result = context.Hastalar.Include(x => x.Raporlar).Where(x => x.AppUserId == appUserId);
return(result.SelectMany(x => x.Raporlar).Count());
}
}
public List <Hasta> GetirIyilestirilenHastalar(out int toplamSayfa, int aktifSayfa = 1)
{
using (var context = new CoronaHastaTakipContext())
{
var result = context.Hastalar.Include(x => x.Aciliyet).Include(x => x.AppUser).Include(x => x.Raporlar)
.Where(x => x.Durum);
toplamSayfa = (int)Math.Ceiling((double)result.Count() / 3);
return(result.Skip((aktifSayfa - 1) * 6).Take(6).ToList());
}
}
public List <AppUser> GetirAdminOlmayanlar(out int toplamSayfa, int aktifSayfa = 1)
{
using (var context = new CoronaHastaTakipContext())
{
var result = from user in context.Users
join userRoles in context.UserRoles on user.Id equals userRoles.UserId
join roles in context.Roles on userRoles.RoleId equals roles.Id
where roles.Name == "Ekip"
select new AppUser()
{
Id = user.Id,
Name = user.Name,
Surname = user.Surname,
Email = user.Email,
UserName = user.UserName
};
toplamSayfa = (int)Math.Ceiling((double)result.Count() / 3);
result = result.Skip((aktifSayfa - 1) * 3).Take(3);
return(result.ToList());
}
}
