public async Task <IList <Korisnik> > GetKorisnikeProjektaAsync(long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Korisnik.Where(a => a.Projekat.Any(b => b.IDProjekta == IDProjekta)).ToListAsync()); } }
public async Task <int> GetProjekatCountAsync() { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Projekat.CountAsync()); } }
public async Task <IList <Projekat> > GetProjekteKorisnikaAsync(string KorisnickoIme) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Projekat.Where(a => a.Korisnik.Any(b => b.KorisnickoIme == KorisnickoIme)).ToListAsync()); } }
public async Task <IList <Projekat> > GetProjekteAsync() { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Projekat.AsNoTracking().ToListAsync()); } }
public async Task <bool> DokumentImaPDFFajl(long IDDokumenta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.PDF.FirstOrDefaultAsync(p => p.IDDokumenta == IDDokumenta) != default(PDF)); } }
public async Task <IList <Trosak> > GetTroskoveProjektaAsync(long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Trosak.Where(a => a.IDProjekta == IDProjekta).ToListAsync()); } }
public async Task <IList <Trosak> > GetTroskovePodkategorijeAsync(long IDProjekta, string Podkategorija) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Trosak.Where(a => a.IDProjekta == IDProjekta && a.Podkategorija == Podkategorija).ToListAsync()); } }
public async Task <int> GetKorisniciCountAsync() { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Korisnik.CountAsync()); } }
public async Task <IList <Zahtev> > GetZahtevePrimaocaAsync(string KorisnickoIme, long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Zahtev.Where(a => a.IDProjekta == IDProjekta && a.KorisnickoImePrimaoca == KorisnickoIme).ToListAsync()); } }
public async Task <Projekat> GetProjekatAsync(long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Projekat.FindAsync(IDProjekta)); } }
public async Task <IList <Zahtev> > GetZahteveProjektaAsync(long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Zahtev.Where(a => a.IDProjekta == IDProjekta).ToListAsync()); } }
public async Task <Korisnik> GetKorisnikAsync(string KorisnickoIme) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Korisnik.FindAsync(KorisnickoIme)); } }
public async Task <PDF> GetPDFAsync(long IDDokumenta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.PDF.FindAsync(IDDokumenta)); } }
public async Task <Trosak> GetTrosakAsync(long IDTroska) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Trosak.FindAsync(IDTroska)); } }
public async Task <IList <Dokumentacija> > GetDokumentaProjekta(long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Dokumentacija.Where(a => a.IDProjekta == IDProjekta).ToListAsync()); } }
public async Task <Dokumentacija> GetDokumentAsync(long IDDokumenta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Dokumentacija.FindAsync(IDDokumenta)); } }
public async Task <IList <Korisnik> > GetKorisniciAsync() { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Korisnik.AsNoTracking().ToListAsync()); } }
public async Task AddGeneralniTrosakAsync(GeneralniTrosak generalniTrosak) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { _context.GeneralniTrosak.Add(generalniTrosak); await _context.SaveChangesAsync(); } }
public async Task AddKorisnikAsync(Korisnik korisnik) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { _context.Korisnik.Add(korisnik); await _context.SaveChangesAsync(); } }
public async Task AddAktivnostAsync(Aktivnost aktivnost) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { _context.Aktivnost.Add(aktivnost); await _context.SaveChangesAsync(); } }
public async Task AddDokumentAsync(Dokumentacija dokument) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { _context.Dokumentacija.Add(dokument); await _context.SaveChangesAsync(); } }
public async Task <IList <Aktivnost> > GetAktivnostiAsync(string vrstaKorisnika) { // TODO: Mora da se uzme u obzir i tip korisnika using (ExtentBazaEntities _context = new ExtentBazaEntities()) { return(await _context.Aktivnost.OrderByDescending(a => a.IDAktivnosti).ToListAsync()); } }
public async Task <Korisnik> LoginApp(string username, string password) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { var obj = await _context.Korisnik.FirstOrDefaultAsync(a => a.KorisnickoIme == username && a.Lozinka == password); return(obj); } }
public async Task <int> GetCenaTroskaAsync(long IDTroska) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { var pom = await _context.Trosak.Where(a => a.IDTroska == IDTroska).Select(a => a.Cena).SingleOrDefaultAsync(); return(pom.GetValueOrDefault()); } }
public async Task <int> GetBrojUplataAsync(long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { var pom = await _context.GeneralniTrosak.Where(a => a.IDProjekta == IDProjekta).Select(a => a.BrojUplata).SingleOrDefaultAsync(); return(pom.GetValueOrDefault()); } }
public async Task <string> GetProcenteAsync(long IDProjekta) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { var pom = await _context.GeneralniTrosak.Where(a => a.IDProjekta == IDProjekta).Select(a => a.Procenti).SingleOrDefaultAsync(); return(pom); } }
public async Task <int> PromeniLozinku(Korisnik korisnik, string novaLozinka) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { var obj = await _context.Korisnik.FirstOrDefaultAsync(a => a.KorisnickoIme == korisnik.KorisnickoIme); obj.Lozinka = novaLozinka; return(await _context.SaveChangesAsync()); } }
public async Task <int> UpdatePDFAsync(PDF pdf) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { var obj = await _context.PDF.FirstOrDefaultAsync(a => a.IDDokumenta == pdf.IDDokumenta); obj.PDFFajl = pdf.PDFFajl; return(await _context.SaveChangesAsync()); } }
public async Task AddTrosakAsync(Trosak trosak, Korisnik korisnik) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { _context.Trosak.Add(trosak); await _context.SaveChangesAsync(); // Dodaj aktivnost o tome da je kreiran dodat novi trosak await AddAktivnostAsync(new Aktivnost { IDProjekta = trosak.IDProjekta, Poruka = $"{korisnik.PunoIme} je dodao novi trosak {trosak}" }); } }
public async Task AddTroskoveAsync(params Trosak[] trosak) { using (ExtentBazaEntities _context = new ExtentBazaEntities()) { foreach (var t in trosak) { _context.Trosak.Add(t); } await _context.SaveChangesAsync(); } }