public bool spremeniStudenta(int id, string ime, string priimek, DateTime dt)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
sdbc.Configuration.ProxyCreationEnabled = false;
Student student = sdbc.studenti.Where(x => x.Id == id).First();
if (ime != "")
{
student.Ime = ime;
}
if (priimek != "")
{
student.Priimek = priimek;
}
if (dt.Year != 9999)
{
student.DatumRojstva = dt;
}
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
public bool spremeniPredmet(string kratica, string novaKratica, string naziv, int ects)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
sdbc.Configuration.ProxyCreationEnabled = false;
Predmet predmet = sdbc.predmeti.Where(x => x.Kratica == kratica).First();
if (novaKratica != "")
{
predmet.Kratica = novaKratica;
}
if (naziv != "")
{
predmet.Naziv = naziv;
}
if (ects != 0)
{
predmet.Ects = ects;
}
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
public bool dodajStudenta(string ime, string priimek, DateTime datum)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
Student student = new Student(ime, priimek, datum);
sdbc.studenti.Add(student);
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
public bool izbrisiPredmet(string kratica)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
Predmet predmet = sdbc.predmeti.Where(x => x.Kratica == kratica).First();
sdbc.predmeti.Remove(predmet);
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
public bool dodajPredmet(string naziv, string kratica, int ects)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
Predmet predmet = new Predmet(naziv, kratica, ects);
sdbc.predmeti.Add(predmet);
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
public bool izbrisiStudenta(int id)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
sdbc.Configuration.ProxyCreationEnabled = false;
Student student = sdbc.studenti.Where(x => x.Id == id).First();
sdbc.studenti.Remove(student);
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
public bool spremeniOcenoStudenta(int id, string kratica, int ocena)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
sdbc.Configuration.ProxyCreationEnabled = false;
Student student = sdbc.studenti.Where(x => x.Id == id).First();
Predmet predmet = sdbc.predmeti.Where(x => x.Kratica == kratica).First();
sdbc.studentiImajoPredmete.Where(x => x.Student_Id == student.Id && x.Predmet_Id == predmet.Id).First().ocena = ocena;
sdbc.SaveChanges();
return(true);
}
}
catch (EntityException ex)
{
return(false);
}
}
public bool odstraniStudentaIzPredmeta(int id, string kratica)
{
try
{
using (SolaDBContext sdbc = new SolaDBContext())
{
sdbc.Configuration.ProxyCreationEnabled = false;
Student student = sdbc.studenti.Where(x => x.Id == id).First();
Predmet predmet = sdbc.predmeti.Where(x => x.Kratica == kratica).First();
StudentImaPredmet sip = sdbc.studentiImajoPredmete.Where(x => x.Student.Id == student.Id && x.Predmet.Id == predmet.Id).First();
sdbc.studentiImajoPredmete.Remove(sip);
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
public bool dodajStudentuPredmet(int id, string kratica, int ocena)
{
try
{
StudentImaPredmet sip;
using (SolaDBContext sdbc = new SolaDBContext())
{
sdbc.Configuration.ProxyCreationEnabled = false;
Student student = sdbc.studenti.Where(x => x.Id == id).First();
Predmet predmet = sdbc.predmeti.Where(x => x.Kratica == kratica).First();
sip = new StudentImaPredmet(student.Id, predmet.Id, student, predmet, ocena);
sdbc.studentiImajoPredmete.Add(sip);
sdbc.SaveChanges();
}
return(true);
}
catch (EntityException ex)
{
return(false);
}
}
