public static List <Zahtevi> ListaZahteva()
{
InformacioniSistemBanakaEntities banakaEntities = new InformacioniSistemBanakaEntities();
List <Zahtevi> zahtevi = (from z in banakaEntities.Zahtevi select z).ToList();
return(zahtevi);
}
public static bool BrisiBanku(int id)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
try
{
Banka banka = (from a in db.Banka
where a.BankaID == id
select a).Single();
if (banka != null)
{
var a = banka.Licenca.StatusLicence;
if (a == 0)
{
banka.Licenca.StatusLicence = 1;
}
if (a == 1)
{
banka.Licenca.StatusLicence = 0;
}
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public static int VratiStatusLicence(int id)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
try
{
Banka banka = (from a in db.Banka
where a.BankaID == id
select a).Single();
if (banka != null)
{
if (banka.Licenca.StatusLicence == 0)
{
return(0);
}
if (banka.Licenca.StatusLicence == 1)
{
return(1);
}
}
return(1);
}
catch (Exception)
{
return(0);
}
}
public static List <VlasnickaStrukturaBanke> ListaVlasnika()
{
InformacioniSistemBanakaEntities banakaEntities = new InformacioniSistemBanakaEntities();
List <VlasnickaStrukturaBanke> vlasnistvobanaka = (from b in banakaEntities.VlasnickaStrukturaBanke select b).ToList();
return(vlasnistvobanaka);
}
public static List <Zahtevi> PrikaziZahtevePoKorisniku(int sifra)
{
InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities();
List <Zahtevi> zahtevi = (from z in db.Zahtevi where z.KorisnikID == sifra select z).ToList();
return(zahtevi);
}
public static List <Banka> ListaAktivnihBanaka()
{
InformacioniSistemBanakaEntities banakaEntities = new InformacioniSistemBanakaEntities();
List <Banka> banke = (from b in banakaEntities.Banka where b.Licenca.StatusLicence == 1
select b).ToList();
return(banke);
}
public static List <Banka> ListaBanaka()
{
InformacioniSistemBanakaEntities banakaEntities = new InformacioniSistemBanakaEntities();
List <Banka> banke = (from b in banakaEntities.Banka
select b).ToList();
return(banke);
}
public static SelectList PopuniBankeID1()
{
InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities();
IEnumerable <SelectListItem> banke = (from b in db.Banka where b.BankaID != (from a in db.VlasnickaStrukturaBanke select a.BankaID).FirstOrDefault() select b).AsEnumerable().Select(b => new SelectListItem()
{
Text = b.Naziv, Value = b.BankaID.ToString()
});
return(new SelectList(banke, "Value", "Text", Sifra));
}
public static SelectList PopuniBankeID()
{
InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities();
IEnumerable <SelectListItem> banke = (from b in db.Banka select b).AsEnumerable().Select(b => new SelectListItem()
{
Text = b.Naziv, Value = b.BankaID.ToString()
});
return(new SelectList(banke, "Value", "Text", Sifra));
}
public static KombinovaniViewModel PrikaziZahtevPoSifri(int sifra)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
KombinovaniViewModel zahteviposifri = (from z in db.Zahtevi where z.ZahtevID == sifra select new KombinovaniViewModel {
Email = z.Korisnici.Email, OpisZahteva = z.OpisZahteva, KorisnikID = z.KorisnikID, Naziv = z.Banka.Naziv, NazivKorisnika = z.Korisnici.NazivKorisnika, ZahtevID = z.ZahtevID, BankaID = z.BankaID
}).Single();
return(zahteviposifri);
}
}
public static SelectList PopuniStatusLicence()
{
InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities();
IEnumerable <SelectListItem> licence = (from l in db.Licenca select l).AsEnumerable().Select(l => new SelectListItem()
{
Text = l.StatusLicence.ToString(), Value = l.LicencaID.ToString()
});
return(new SelectList(licence, "Value", "Text", Sifra));
}
public static SelectList PopuniStatusBanke()
{
InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities();
IEnumerable <SelectListItem> statusibanke = (from s in db.StatusBanke select s).AsEnumerable().Select(s => new SelectListItem()
{
Text = s.Status, Value = s.StatusID.ToString()
});
return(new SelectList(statusibanke, "Value", "Text", Sifra));
//dbEntitet.Dispose();
}
public static SelectList PopuniVrsteBanaka()
{
InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities();
IEnumerable <SelectListItem> vrstebanaka = (from s in db.VrstaBanke select s).AsEnumerable().Select(s => new SelectListItem()
{
Text = s.Tip, Value = s.VrstaID.ToString()
});
return(new SelectList(vrstebanaka, "Value", "Text", Sifra));
//dbEntitet.Dispose();
}
public static SelectList PopuniSifreKorisnika()
{
InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities();
IEnumerable <SelectListItem> sifrekorisnika = (from s in db.Korisnici select s).AsEnumerable().Select(s => new SelectListItem()
{
Text = s.NazivKorisnika, Value = s.KorisnikId.ToString()
});
return(new SelectList(sifrekorisnika, "Value", "Text", Sifra));
//dbEntitet.Dispose();
}
public static Banka PrikaziBankupoId(int id)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
Banka banka = (from a in db.Banka
where a.BankaID == id
select a).Single();
return(banka);
}
}
public static List <KombinovaniViewModel> ListaZahteva()
{
InformacioniSistemBanakaEntities banakaEntities = new InformacioniSistemBanakaEntities();
List <KombinovaniViewModel> zahtevi = (from b in banakaEntities.Zahtevi
select new KombinovaniViewModel {
ZahtevID = b.ZahtevID, BankaID = b.BankaID, KorisnikID = b.KorisnikID, OpisZahteva = b.OpisZahteva, Naziv = b.Banka.Naziv, NazivKorisnika = b.Korisnici.NazivKorisnika, Email = (from k in banakaEntities.Korisnici where b.KorisnikID == k.KorisnikId select k.Email).FirstOrDefault()
}).ToList();
return(zahtevi);
}
public static void DodajVlasnistvo(VlasnickaStrukturaBanke vlasnistvobanke)
{
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
try
{
db.VlasnickaStrukturaBanke.Add(vlasnistvobanke);
db.SaveChanges();
}
catch (Exception)
{
}
}
}
public static void UbaciZahtev(Zahtevi zahtev)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
try
{
db.Zahtevi.Add(zahtev);
db.SaveChanges();
}
catch
{
}
}
}
public static void DodajBanku(Banka banka)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
try
{
db.Banka.Add(banka);
db.SaveChanges();
}
catch (Exception)
{
}
}
}
public static void GenerisiLicencuId(Licenca licenca)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
try
{
db.Licenca.Add(licenca);
db.SaveChanges();
}
catch (Exception)
{
}
}
}
public static VlasnickaStrukturaBanakaViewModel VlasnistvoBanke(int id)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
VlasnickaStrukturaBanakaViewModel vlasnistvo = (from v in db.VlasnickaStrukturaBanke
where v.BankaID == id
select new VlasnickaStrukturaBanakaViewModel {
BankaID = v.BankaID, NazivBanaka = v.Banka.Naziv, NazivVlasnika = "", Procenat = v.Procenat, Sediste = v.Banka.Sediste, VlasniciBanke = v.VlasniciBanke
}).Single();
if (vlasnistvo.VlasniciBanke != null)
{
vlasnistvo.NazivVlasnika = (from n in db.Banka where vlasnistvo.VlasniciBanke == n.BankaID select n.Naziv).FirstOrDefault();
}
return(vlasnistvo);
}
}
public static List <VlasnickaStrukturaBanakaViewModel> ListaVlasnika1()
{
InformacioniSistemBanakaEntities banakaEntities = new InformacioniSistemBanakaEntities();
List <VlasnickaStrukturaBanakaViewModel> vlasnickaStrukturaBanakaViewModels = (from b in banakaEntities.VlasnickaStrukturaBanke select new VlasnickaStrukturaBanakaViewModel {
BankaID = b.BankaID, VlasniciBanke = b.VlasniciBanke, Procenat = b.Procenat, NazivBanaka = b.Banka.Naziv, NazivVlasnika = "", Sediste = b.Banka.Sediste
}).ToList();
foreach (var i in vlasnickaStrukturaBanakaViewModels)
{
if (i.VlasniciBanke != null)
{
i.NazivVlasnika = (from k in banakaEntities.Banka where i.VlasniciBanke == k.BankaID select k.Naziv).FirstOrDefault();
}
}
return(vlasnickaStrukturaBanakaViewModels);
}
public static void IzmeniVlasnistvo1(VlasnickaStrukturaBanke novovlasnistvo)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
VlasnickaStrukturaBanke izmenav = (from v in db.VlasnickaStrukturaBanke
where v.BankaID == novovlasnistvo.BankaID
select v).Single();
izmenav.VlasniciBanke = novovlasnistvo.VlasniciBanke;
izmenav.Procenat = novovlasnistvo.Procenat;
try
{
db.SaveChanges();
}
catch
{
}
}
}
public static void IzmeniBanku(Banka banka)
{
using (InformacioniSistemBanakaEntities db = new InformacioniSistemBanakaEntities())
{
Banka izmena = (from a in db.Banka
where a.BankaID == banka.BankaID
select a).Single();
izmena.Naziv = banka.Naziv;
izmena.Sediste = banka.Sediste;
izmena.GodinaOsnivanja = banka.GodinaOsnivanja;
izmena.StatusID = banka.StatusID;
izmena.VrstaID = banka.VrstaID;
izmena.Vlasnistvo = banka.Vlasnistvo;
izmena.Godisnjiprofit = banka.Godisnjiprofit;
izmena.UkupnaAktivaiUkupniDug = banka.UkupnaAktivaiUkupniDug;
try
{
db.SaveChanges();
}
catch
{
}
}
}
