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