public University GetByID(int id)
{
using (var db = new LibraryTestContext())
{
return(db.Universities.FirstOrDefault(t => t.UniversityId == id));
}
}
public void Create(University university)
{
using (var db = new LibraryTestContext())
{
db.Universities.Add(university);
db.SaveChanges();
}
}
public void DeleteUniversity(int id)
{
using (var db = new LibraryTestContext())
{
var university = db.Universities.Where(t => t.UniversityId == id).FirstOrDefault();
db.Entry(university).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public ICollection <University> GetUniversities()
{
ICollection <University> universities;
using (var db = new LibraryTestContext())
{
universities = db.Universities.ToList();
}
return(universities);
}
public ICollection <Book> GetBooks()
{
ICollection <Book> books;
using (LibraryTestContext db1 = new LibraryTestContext())
{
books = (from d in db1.Books
select d).ToList();
}
return(books);
}
public void UpdateUniversity(University updatedUniversity)
{
using (var db = new LibraryTestContext())
{
var university = db.Universities.Where(t => t.UniversityId == updatedUniversity.UniversityId).FirstOrDefault();
if (university != null)
{
university.Name = updatedUniversity.Name;
university.Address = updatedUniversity.Address;
db.SaveChanges();
}
}
}
public LibraryController()
{
db = new LibraryTestContext();
}
public StudentController()
{
db = new LibraryTestContext();
}
