public void Add(AUTHOR authobj)
{
using (var db = new Libdb())
{
db.AUTHOR.Add(authobj);
db.Entry(authobj).State = EntityState.Added;
db.SaveChanges();
}
}
public void Update(BOOK bookObj)
{
using (var db = new Libdb())
{
db.BOOK.Attach(bookObj);
db.Entry(bookObj).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(AUTHOR authobj)
{
using (var db = new Libdb())
{
db.AUTHOR.Attach(authobj);
db.Entry(authobj).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(ADMINISTRATOR adminobj)
{
using (var db = new Libdb())
{
db.ADMINISTRATOR.Attach(adminobj);
db.Entry(adminobj).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Create(ADMINISTRATOR admin)
{
using (var db = new Libdb())
{
db.ADMINISTRATOR.Add(admin);
db.Entry(admin).State = EntityState.Added;
db.SaveChanges();
}
}
public void Delete(BOOK book)
{
using (var db = new Libdb())
{
var bk = db.BOOK.FirstOrDefault(b => b.ISBN == book.ISBN);
bk.AUTHOR.Clear();
db.BOOK.Remove(bk);
db.SaveChanges();
}
}
public void Delete(ADMINISTRATOR admin)
{
using (var db = new Libdb())
{
db.ADMINISTRATOR.Attach(admin);
db.ADMINISTRATOR.Remove(admin);
db.Entry(admin).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void Remove(AUTHOR auth)
{
using (var db = new Libdb())
{
var au = db.AUTHOR.FirstOrDefault(a => a.Aid == auth.Aid);
au.BOOK.Clear();
db.AUTHOR.Remove(au);
db.SaveChanges();
}
}
public void Add(BOOK bk)
{
using (var db = new Libdb())
{
var authors = bk.AUTHOR;
bk.AUTHOR = new List <AUTHOR>();
db.BOOK.Add(bk);
foreach (var author in authors)
{
bk.AUTHOR.Add(author);
db.Entry(author).State = EntityState.Unchanged;
}
db.SaveChanges();
}
}