public List <Account> getList()
{
using (RegisterSubjectDBContext db = new RegisterSubjectDBContext())
{
return(_users = db.Accounts.ToList());
}
}
//get facuty by id
public IEnumerable <Faculty> GetFacultyById(string id)
{
using (var context = new RegisterSubjectDBContext())
{
return(context.Faculties.Where(x => x.IdFaculty == id).ToList());
}
}
//get all facuty
public IEnumerable <Faculty> GetListFacuty()
{
using (var context = new RegisterSubjectDBContext())
{
return(context.Faculties.ToList());
}
}
public void RemoveAll(string id_student)
{
using (RegisterSubjectDBContext db = new RegisterSubjectDBContext())
{
List <ListCr> s = db.ListCrs.Where(x => x.IdStudent == id_student).ToList();
db.ListCrs.RemoveRange(s);
db.SaveChanges();
}
}
public void Remove(string id_cr, string id_student)
{
using (RegisterSubjectDBContext db = new RegisterSubjectDBContext())
{
ListCr s = db.ListCrs.SingleOrDefault(x => x.IdClassRegister == id_cr && x.IdStudent == id_student);
db.ListCrs.Remove(s);
db.SaveChanges();
}
}
public void RemoveAll(string id_gv)
{
using (RegisterSubjectDBContext db = new RegisterSubjectDBContext())
{
List <ClassRegister> s = db.ClassRegisters.Where(x => x.IdLecturers == id_gv).ToList();
db.ClassRegisters.RemoveRange(s);
db.SaveChanges();
}
}
public ListCrsController(RegisterSubjectDBContext context)
{
_context = context;
}
public ClassRegistersController(RegisterSubjectDBContext context)
{
_context = context;
}
public FacultiesController(RegisterSubjectDBContext context)
{
_context = context;
}
public DepartmentsController(RegisterSubjectDBContext context)
{
_context = context;
}
public AccountsController(RegisterSubjectDBContext context)
{
_context = context;
}
