public Tip_zaposlenika TipZaposlenikaAdmin() { using (var db = new BankaEntities()) { return(db.Tip_zaposlenika.FirstOrDefault(x => x.Naziv.Equals("Administrator"))); } }
public List <Tip_zaposlenika> DohvatiSveVrsteZaposlenih() { using (var db = new BankaEntities()) { return(db.Tip_zaposlenika.ToList()); } }
public List <Klijent> DohvatiSveKlijente() { using (var db = new BankaEntities()) { return(db.Klijent.ToList()); } }
public List <Zaposlenik> DohvatiZaposlenike() { using (BankaEntities db = new BankaEntities()) { return(db.Zaposlenik.ToList()); } }
public override string[] GetRolesForUser(string username) { BankaEntities db = new BankaEntities(); var Kullanici = db.Kullanicis.FirstOrDefault(x => x.TcKimlik == username); return(new string[] { Kullanici.KullaniciTipi.ToString() }); }
public Tip_zaposlenika TipZaposlenikaObican() { using (var db = new BankaEntities()) { return(db.Tip_zaposlenika.FirstOrDefault(x => x.Naziv.Equals("Obican"))); } }
public List <Zaposlenik> DohvatiOdabraneTipoveZaposlenika(Tip_zaposlenika tip) { using (var db = new BankaEntities()) { db.Tip_zaposlenika.Attach(tip); return(tip.Zaposlenik.ToList()); } }
public void DodajKlijentaUBazu(Klijent noviKlijent) { using (var db = new BankaEntities()) { db.Klijent.Add(noviKlijent); db.SaveChanges(); } }
// GET: Profilim public ActionResult Index() { using (BankaEntities db = new BankaEntities()) { var model = db.Kullanicis.Include(x => x.KullaniciTipleri).Where(x => x.TcKimlik == this.HttpContext.User.Identity.Name).ToList(); return(View(model)); } }
public List <Kredit_> DohvatiSveAktivneKrediteKorisnika(Klijent klijent) { using (var db = new BankaEntities()) { db.Klijent.Attach(klijent); return(klijent.Kredit_.Where(x => x.Status.Equals(1)).ToList()); } }
public ActionResult Index() { using (BankaEntities db = new BankaEntities()) { var model = db.Kullanicis.Include(x => x.KullaniciTipleri).ToList(); return(View(model)); } }
public ActionResult Hesap() { using (BankaEntities db = new BankaEntities()) { var model = db.Hesaps.Include(x => x.Bakiyes).Where(x => x.KullaniciId == Convert.ToInt32(this.HttpContext.User.Identity.Name)).ToList(); return(View(model)); } }
public List <Stednja> DohvatiStednjeKlijenta(Klijent k) { using (var db = new BankaEntities()) { db.Klijent.Attach(k); return(k.Stednja.ToList()); } }
public List <Stednja> DohvatiAktivneStednjeKlijenta(Klijent klijent) { using (var db = new BankaEntities()) { db.Klijent.Attach(klijent); return(klijent.Stednja.Where(x => x.Status > 0).ToList()); } }
public ActionResult HesapHareket(int id) { using (BankaEntities db = new BankaEntities()) { var model = db.Hesaps.Include(x => x.HesapHareketleris).ToList(); return(View(model)); } }
public ActionResult Hareketler(int id) { using (BankaEntities db = new BankaEntities()) { List <HesapHareketleri> h = db.HesapHareketleris.Where(x => x.KaynakID == id).ToList(); return(View(h)); } }
public void AzurirajStatusStednje(Stednja s) { using (var db = new BankaEntities()) { db.Stednja.Attach(s); s.Status = 0; db.SaveChanges(); } }
public void Unos(Zaposlenik novi) { using (var db = new BankaEntities()) { db.Tip_zaposlenika.Attach(novi.Tip_zaposlenika); db.Zaposlenik.Add(novi); db.SaveChanges(); } }
public void Izbrisi(Zaposlenik zaposlenik) { using (BankaEntities db = new BankaEntities()) { db.Zaposlenik.Attach(zaposlenik); db.Zaposlenik.Remove(zaposlenik); db.SaveChanges(); } }
public void dodajStednju(Stednja s, Klijent k) { using (var db = new BankaEntities()) { db.Klijent.Attach(k); db.Zaposlenik.Attach(Zaposlenik.PrijavljeniZaposlenik); db.Stednja.Add(s); db.SaveChanges(); } }
// GET: Hesap public ActionResult Index() { using (BankaEntities db = new BankaEntities()) { Kullanici k = db.Kullanicis.Where(x => x.TcKimlik == this.HttpContext.User.Identity.Name).FirstOrDefault(); var model = db.Hesaps.Include(x => x.Bakiyes).Where(m => m.KullaniciId == k.Id).ToList(); return(View("Hesap", model)); } }
public ActionResult HareketMiktari(int id) { using (BankaEntities db = new BankaEntities()) { var hesap = db.Hesaps.Where(x => x.KullaniciId == id).Select(x => x.Id).ToList(); List <HesapHareketleri> model = db.HesapHareketleris.Where(m => hesap.Contains(m.KaynakID)).ToList(); return(View("HareketMiktari", model)); } }
public ActionResult Gonder() { using (BankaEntities db = new BankaEntities()) { HesapKontrolViewModel Gonderilicek = new HesapKontrolViewModel(); Gonderilicek.HareketTipleri = db.HareketTipleris.ToList(); return(View("Gonder", Gonderilicek)); } }
public ActionResult Yeni() { using (BankaEntities db = new BankaEntities()) { var model = new HesapKontrolViewModel() { Kullanici = db.Kullanicis.ToList() }; return(View("Yeni", model)); } }
public ActionResult Yeni() { using (BankaEntities db = new BankaEntities()) { var model = new KullaniciFormViewModel() { KullaniciTipleri = db.KullaniciTipleris.ToList() }; return(View("Kayit", model)); } }
public ActionResult Guncelle(int id) { using (BankaEntities db = new BankaEntities()) { var model = new KullaniciFormViewModel() { KullaniciTipleri = db.KullaniciTipleris.ToList(), Kullanici = db.Kullanicis.Find(id) }; return(View("Guncelle", model)); } }
public ActionResult Guncelle(int id) { using (BankaEntities db = new BankaEntities()) { var model = new HesapKontrolViewModel() { Kullanici = db.Kullanicis.ToList(), Hesap = db.Hesaps.Find(id) }; return(View("Guncelle", model)); } }
public ActionResult Sil(int id) { using (BankaEntities db = new BankaEntities()) { var SilinecekKullanici = db.Kullanicis.Find(id); if (SilinecekKullanici == null) { return(HttpNotFound()); } db.Kullanicis.Remove(SilinecekKullanici); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Profilim(Kullanici Kullanici) { using (BankaEntities db = new BankaEntities()) { if (Kullanici.Id == 0)//ekleme { db.Kullanicis.Add(Kullanici); } else //güncelle { db.Entry(Kullanici).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Kayit(Hesap Hesap) { using (BankaEntities db = new BankaEntities()) { if (Hesap.Id == 0)//ekleme { db.Hesaps.Add(Hesap); } else //güncelle { db.Entry(Hesap).State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); return(RedirectToAction("Index")); } }