public async Task <Ocena> GetOcenaAsync(long id)
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Ocena.FindAsync(id));
}
}
public async Task <int> GetDepartmanCountAsync()
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Departman.CountAsync());
}
}
public async Task <int> GetSmerCountAsync()
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Smer.CountAsync());
}
}
public async Task <Smer> GetSmerAsync(long id)
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Smer.FindAsync(id));
}
}
public async Task <List <ChartData> > GetNajboljiStudenti()
{
using (var context = new StudentskaSluzbaDBContext())
{
throw new NotImplementedException();
}
}
public async Task <Referent> GetReferentAsync(long id)
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Referent.FindAsync(id));
}
}
public SmerDetails()
{
this.InitializeComponent();
var context = new StudentskaSluzbaDBContext();
PopuniListe();
}
public async Task <Departman> GetDepartmanAsync(long id)
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Departman.FindAsync(id));
}
}
public async Task <Profesor> GetProfesorAsync(long id)
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Profesor.FindAsync(id));
}
}
public async Task <List <ChartData> > GetProsecnaOcenaPoDepartmanu()
{
using (var context = new StudentskaSluzbaDBContext())
{
throw new NotImplementedException();
}
}
public async Task <Ispit> GetIspitAsync(long id)
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Ispit.FindAsync(id));
}
}
public async Task <IList <Profesor> > GetProfesorsAsync()
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Profesor
.AsNoTracking().ToListAsync());
}
}
public async Task AddStudentAsync(Student student)
{
using (var context = new StudentskaSluzbaDBContext())
{
await context.Student.AddAsync(student);
await context.SaveChangesAsync();
}
}
public async Task AddSmerAsync(Smer smer)
{
using (var context = new StudentskaSluzbaDBContext())
{
await context.Smer.AddAsync(smer);
await context.SaveChangesAsync();
}
}
public async Task AddIspitAsync(Ispit ispit)
{
using (var context = new StudentskaSluzbaDBContext())
{
await context.Ispit.AddAsync(ispit);
await context.SaveChangesAsync();
}
}
public async Task <int> UpdateOcenaAsync(Ocena ocena)
{
using (var context = new StudentskaSluzbaDBContext())
{
var entity = context.Ocena.FirstOrDefault(d => d.IdIspita == ocena.IdIspita);
entity.Ocena1 = ocena.Ocena1;
return(await context.SaveChangesAsync());
}
}
public async Task AddOCenaAsync(Ocena ocena)
{
using (var context = new StudentskaSluzbaDBContext())
{
await context.Ocena.AddAsync(ocena);
await context.SaveChangesAsync();
}
}
public async Task <Korisnik> LoginIspravan(string username, string password)
{
using (var context = new StudentskaSluzbaDBContext())
{
var rez = await context.Korisnik.FirstOrDefaultAsync(k => k.Username == username && k.Password == Enkripcija.Enkriptuj(password));
return(rez);
}
}
public async Task AddPredmetAsync(Predmet predmet)
{
using (var context = new StudentskaSluzbaDBContext())
{
await context.Predmet.AddAsync(predmet);
await context.SaveChangesAsync();
}
}
public async Task AddProfesorAsync(Profesor profesor)
{
using (var context = new StudentskaSluzbaDBContext())
{
await context.Profesor.AddAsync(profesor);
await context.SaveChangesAsync();
}
}
public IspitDetails()
{
this.InitializeComponent();
var context = new StudentskaSluzbaDBContext();
PopuniStudenteIPredmeteAsync();
Godine = new int[] { 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2025, 2026, 2027, 2028, 2029, 2030 };
Rokovi = new string[] { "Januar", "Februar", "Mart", "Jun", "Jul", "Septembar", "Oktobar", "Oktobar II", "Novembar" };
}
public async Task AddDepartmanAsync(Departman departman)
{
using (var context = new StudentskaSluzbaDBContext())
{
await context.Departman.AddAsync(departman);
await context.SaveChangesAsync();
}
}
public async Task <int> UpdateDepartmanAsync(Departman departman)
{
using (var context = new StudentskaSluzbaDBContext())
{
var entity = context.Departman.FirstOrDefault(d => d.IdDepartmana == departman.IdDepartmana);
entity.Naziv = departman.Naziv;
entity.IdSefaDepartmana = departman.IdSefaDepartmana;
return(await context.SaveChangesAsync());
}
}
public async Task <int> PromeniLozinku(Korisnik korisnik, string novaLozinka)
{
using (var context = new StudentskaSluzbaDBContext())
{
var entity = await context.Korisnik.FirstOrDefaultAsync(k => k.Username == korisnik.Username);
entity.Password = Enkripcija.Enkriptuj(novaLozinka);
return(await context.SaveChangesAsync());
}
}
public async Task <IList <Departman> > GetDepartmaniAsync()
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Departman
.AsNoTracking()
.Include(d => d.IdSefaDepartmanaNavigation)
.ToListAsync());
}
}
public async Task <IList <Predmet> > GetPredmetiAsync()
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Predmet
.AsNoTracking()
.Include(p => p.IdProfesoraNavigation)
.ToListAsync());
}
}
public async Task <IList <Referent> > GetReferentsAsync()
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Referent
.AsNoTracking()
.Include(r => r.UsernameReferentaNavigation)
.ToListAsync());
}
}
public async Task <IList <Student> > GetStudentsAsync()
{
using (var context = new StudentskaSluzbaDBContext())
{
return(await context.Student
.AsNoTracking()
.Include(s => s.IdSmeraNavigation)
.ThenInclude(d => d.IdDepartmanaNavigation)
.ToListAsync());
}
}
public async Task <int> DeleteStudentAsync(params Student[] students)
{
using (var context = new StudentskaSluzbaDBContext())
{
foreach (var s in students)
{
context.Student.Remove(s);
}
return(await context.SaveChangesAsync());
}
}
public async Task <int> DeleteDepartmanAsync(params Departman[] departmani)
{
using (var context = new StudentskaSluzbaDBContext())
{
foreach (var s in departmani)
{
context.Departman.Remove(s);
}
return(await context.SaveChangesAsync());
}
}
