public List <Gorus> Liste(bool durum)
{
using IzbursContext db = new IzbursContext();
var Gorus = db.Gorus.Where(x => x.Durum == durum).OrderByDescending(x => x.Id).ToList();
return(Gorus);
}
public List <Basvuru> ListeDonem(int DonemId)
{
using IzbursContext db = new IzbursContext();
var data = db.Basvuru.Where(x => x.DonemID == DonemId).Include(x => x.OkulTuru).Include(x => x.Donem).Include(x => x.BursDurum).Include(x => x.Okul).Include(x => x.Bolum).Include(x => x.Sehir).ToList();
return(data);
}
public Basvuru GetirID(int id)
{
using IzbursContext db = new IzbursContext();
var data = db.Basvuru.Where(x => x.Id == id).Include(x => x.OkulTuru).Include(x => x.Donem).Include(x => x.BursDurum).Include(x => x.Okul).Include(x => x.Bolum).Include(x => x.Sehir).FirstOrDefault();
return(data);
}
public List <Galeri> GetirKatId(int KatId)
{
using IzbursContext db = new IzbursContext();
var galeri = db.Galeri.Where(x => x.GaleriKatId == KatId).Include(x => x.GaleriKat).OrderByDescending(x => x.Id).ToList();
return(galeri);
}
public List <Basvuru> Liste(string Tc)
{
using IzbursContext db = new IzbursContext();
var data = db.Basvuru.Where(x => x.TcKimlikNo == Tc).Include(x => x.OkulTuru).Include(x => x.Donem).Include(x => x.BursDurum).Include(x => x.Okul).Include(x => x.Bolum).Include(x => x.Sehir).ToList();
return(data);
}
public List <Galeri> liste_soneklenen(int Adet)
{
using IzbursContext db = new IzbursContext();
var galeri = db.Galeri.OrderByDescending(x => x.Id).Take(Adet).ToList();
return(galeri);
}
public Donem SonDonem()
{
using IzbursContext db = new IzbursContext();
var data = db.Donem.OrderByDescending(x => x.Id).FirstOrDefault();
return(data);
}
public List <Gorus> Liste()
{
using IzbursContext db = new IzbursContext();
var Gorus = db.Gorus.OrderByDescending(x => x.Id).ToList();
return(Gorus);
}
public List <Gorus> liste_soneklenen(int Adet, bool durum)
{
using IzbursContext db = new IzbursContext();
var Gorus = db.Gorus.Where(x => x.Durum == durum).OrderByDescending(x => x.Id).Take(Adet).ToList();
return(Gorus);
}
public List <Haber> CokOkunanHaber(int Adet)
{
using IzbursContext db = new IzbursContext();
var haber = db.Haber.OrderByDescending(x => x.Hit).Take(Adet).ToList();
//return View(grp.Select(null).OrderByDescending(x=>x.Id).Take(12).ToList());
return(haber);
}
public List <Haber> GetirKatId(int KatId, int Adet)
{
using IzbursContext db = new IzbursContext();
var haber = db.Haber.Where(x => x.HaberKatId == KatId & x.Durum == true).Include(x => x.Yorumlar).Include(x => x.HaberKat).Take(Adet).OrderByDescending(x => x.Id).ToList();
//haber.Yorumlar = db.Yorum.Where(x => x.HaberId == id).ToList();
return(haber);
}
public OgrenciBasvuru GetirBasvuruId(int BasvuruId)
{
using IzbursContext db = new IzbursContext();
var haber = db.OgrenciBasvuru.Where(x => x.BasvuruId == BasvuruId).Include(x => x.Basvuru).FirstOrDefault();
//haber.Yorumlar = db.Yorum.Where(x => x.HaberId == id).ToList();
return(haber);
}
public List <OgrenciBasvuru> GetirAppUserId(string AppUserId)
{
using IzbursContext db = new IzbursContext();
var haber = db.OgrenciBasvuru.Where(x => x.AppUserId == AppUserId).Include(x => x.Basvuru).ToList();
//haber.Yorumlar = db.Yorum.Where(x => x.HaberId == id).ToList();
return(haber);
}
public List <Haber> Liste()
{
using IzbursContext db = new IzbursContext();
var haber = db.Haber.Include(x => x.HaberKat).ToList();
//haber.Yorumlar = db.Yorum.Where(x => x.HaberId == id).ToList();
return(haber);
}
public List <Yorum> Liste()
{
using IzbursContext db = new IzbursContext();
var haber = db.Yorum.OrderByDescending(x => x.Durum).Include(x => x.Haber).ToList();
//haber.Yorumlar = db.Yorum.Where(x => x.HaberId == id).ToList();
return(haber);
}
public Haber GetirHaberId(int id)
{
using IzbursContext db = new IzbursContext();
var haber = db.Haber.Where(x => x.Id == id & x.Durum == true).Include(x => x.Yorumlar).FirstOrDefault();
//haber.Yorumlar = db.Yorum.Where(x => x.HaberId == id).ToList();
return(haber);
}
public bool Sil(Tablo tablo)
{
try
{
using var context = new IzbursContext();
context.Set <Tablo>().Remove(tablo);
context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public List <Yorum> listHaberId(int haberId)
{
using IzbursContext db = new IzbursContext();
return(db.Yorum.Where(x => x.HaberId == haberId & x.Durum == false).AsNoTracking().ToList());
}
public List <Transkript> Liste(string AppUserId, int DonemId)
{
using IzbursContext db = new IzbursContext();
return(db.Transkript.Where(x => x.AppUserId == AppUserId & x.DonemId == DonemId).Include(x => x.Donem).OrderByDescending(x => x.Id).ToList());
}
public List <Gorus> Liste(string AppUserId)
{
using IzbursContext db = new IzbursContext();
return(db.Gorus.Where(x => x.AppUserId == AppUserId).ToList());
}
public List <Tablo> GetirHepsi(int Adet)
{
using var context = new IzbursContext();
return(context.Set <Tablo>().Take(Adet).ToList());
}
public Tablo GetirIdile(int id)
{
using var context = new IzbursContext();
return(context.Set <Tablo>().Find(id));
}
public Ayar Getir()
{
using var context = new IzbursContext();
return(context.Ayar.ToList().FirstOrDefault());
}
