public void Update(CLASSIFICATION classiObj)
{
using (var db = new swagbaseEntities1())
{
db.CLASSIFICATIONs.Attach(classiObj);
db.Entry(classiObj).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Update(AUTHOR authorObj)
{
using (var db = new swagbaseEntities1())
{
AUTHOR dummyAuthor = db.AUTHORs.Include("BOOKs").FirstOrDefault(a => a.Aid == authorObj.Aid);
db.AUTHORs.Attach(dummyAuthor);
dummyAuthor.BirthYear = authorObj.BirthYear;
dummyAuthor.FirstName = authorObj.FirstName;
dummyAuthor.LastName = authorObj.LastName;
//dummyAuthor.BOOKs.Clear();
//AUTHOR booksToDummy = authorObj.BOOKs.Select
db.Entry(dummyAuthor).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Add(BOOK bookObj)
{
using (var db = new swagbaseEntities1())
{
List <AUTHOR> auths = bookObj.AUTHORs.ToList();
bookObj.AUTHORs = null;
bookObj.CLASSIFICATION = null;
db.BOOKs.Add(bookObj);
foreach (AUTHOR a in auths)
{
db.AUTHORs.Attach(a);
a.BOOKs.Add(bookObj);
db.Entry(a).State = EntityState.Modified;
}
db.SaveChanges();
}
}