public static List <SubjectsDb> GetAll()
{
using (var db = new EZurnalsContext())
{
return(db.SubjectsDb.OrderBy(u => u.Name).ToList());
}
}
public static List <GradesDb> GetAll()
{
using (var db = new EZurnalsContext())
{
return(db.GradesDb.OrderByDescending(g => g.Grade).ToList());
}
}
public static List <GradesDb> GetSubjectGrades(string name)
{
using (var db = new EZurnalsContext())
{
var subject = db.SubjectsDb.FirstOrDefault(c => c.Name == name);
return(db.GradesDb.Where(i => i.SubjectId == subject.Id).ToList());
}
}
public static StudentsDb GetGrades(int oStudentId)
{
//katra studenta atzīmju saraksts
using (var db = new EZurnalsContext())
{
return(db.StudentsDb.Find(oStudentId));
}
}
public static void Create(string name)//kategorijas saglabāšana
{
using (var db = new EZurnalsContext())
{
db.SubjectsDb.Add(new SubjectsDb()
{
Name = name,
});
db.SaveChanges();
}
}
//varbūt arī Tabulā jāpārsauc Id kaut kā specifiskāk?
public static void Create(decimal grade, string comment, int oStudentId, int oSubjectId)
{
using (var db = new EZurnalsContext())
{
db.GradesDb.Add(new GradesDb()
{
Grade = grade,
Comment = comment,
StudentId = oStudentId,
SubjectId = oSubjectId,
});
db.SaveChanges();
}
}
public static void Create(string name, string surname, string klase, string birthYear)
{
using (var db = new EZurnalsContext())
{
db.StudentsDb.Add(new StudentsDb()
{
Name = name,
Surname = surname,
Klase = klase,
BirthYear = birthYear,
});
db.SaveChanges();
}
}
