public List <Knihovna> GetAll()
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
return(db.Knihovna.ToList());
}
}
public List <SkolaZaci> GetAll()
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
return(db.SkolaZacis.ToList());
}
}
public List <Knihovna> GetAllNepujcene()
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
return(db.Knihovna.Where(i => i.ZapujcenoID == null).ToList());
}
}
public SkolaZaci GetZakById(int id)
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
return(db.SkolaZacis.FirstOrDefault(z => z.Id == id));
}
}
public List <SkolaZaci> GetZaciWithPrijmeni(string prijmeni)
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
return(db.SkolaZacis.Where(z => z.Prijmeni == prijmeni).ToList());
}
}
public void DeleteZak(int id)
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
db.SkolaZacis.Remove(db.SkolaZacis.First(s => s.Id == id));
db.SaveChanges();
}
}
public void AddZak(SkolaZaci zak)
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
db.SkolaZacis.Add(zak);
db.SaveChanges();
}
}
public void VratitKnihuOdZaka(int idKnihy, int idZaka)
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
db.InfoOZapujceni.First(i => i.KnihovnaID == idKnihy && i.SkolaZaciID == idZaka && i.DatumVraceni == null).DatumVraceni = DateTime.Now;
db.Knihovna.Find(idKnihy).ZapujcenoID = null;
db.SaveChanges();
}
}
public List <InfoOZapujceni> GetInfoOZapujceni()
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
List <InfoOZapujceni> output = db.InfoOZapujceni.ToList();
foreach (InfoOZapujceni info in output)
{
var a = info.Knihovna;
var b = info.SkolaZaci;
}
return(output);
}
}
public void PujcitKnihuZakovi(int idKnihy, int idZaka)
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
db.Knihovna.Find(idKnihy).ZapujcenoID = idZaka;
db.InfoOZapujceni.Add(new InfoOZapujceni
{
DatumZapujceni = DateTime.Now,
KnihovnaID = idKnihy,
SkolaZaciID = idZaka
});
db.SaveChanges();
}
}
public List <Knihovna> GetAllOnZak(int idZaka)
{
using (DatabaseSchoolEntities db = new DatabaseSchoolEntities())
{
List <Knihovna> output = db.Knihovna.Where(k => k.SkolaZaci.Id == idZaka).ToList();
if (output.Count >= 1)
{
// To make SkolaZaci property available
var a = output.First().SkolaZaci;
}
return(output);
}
}
