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