public void AddBookAuthor(bookauthor newBookAuthor) { using (var dbModel = new LMSDataModelEntities()) { dbModel.bookauthors.AddObject(newBookAuthor); dbModel.ObjectStateManager.ChangeObjectState(newBookAuthor, System.Data.EntityState.Added); var saveCount = dbModel.SaveChanges(); if (saveCount < 1) { throw new Exception("Fail to insert new book author " + newBookAuthor.author.FirstName + " " +newBookAuthor.book.Title + " into DB"); } } }
public void AddBookLoan(studentbookloan newBookLoan) { using (var dbModel = new LMSDataModelEntities()) { dbModel.studentbookloans.AddObject(newBookLoan); dbModel.ObjectStateManager.ChangeObjectState(newBookLoan, System.Data.EntityState.Added); var saveCount = dbModel.SaveChanges(); if (saveCount < 1) { throw new Exception("Fail to insert new book loan " + newBookLoan.book.Title + " into DB"); } } }
public void AddBook(book newBook) { using (var dbModel = new LMSDataModelEntities()) { dbModel.books.AddObject(newBook); dbModel.ObjectStateManager.ChangeObjectState(newBook, System.Data.EntityState.Added); var saveCount = dbModel.SaveChanges(); if (saveCount < 1) { throw new Exception("Fail to insert Book " + newBook.Title + " in to DB"); } } }
public void AddDepartment(department newDepartment) { using (var dbModel = new LMSDataModelEntities()) { dbModel.departments.AddObject(newDepartment); dbModel.ObjectStateManager.ChangeObjectState(newDepartment, System.Data.EntityState.Added); var saveCount = dbModel.SaveChanges(); if (saveCount < 1) { throw new Exception("Fail to insert new department " + newDepartment.Name + " into DB"); } } }
public void UpdateStudentBookLoan(studentbookloan loanToUpdate) { using (var dbModel = new LMSDataModelEntities()) { //dbModel.Refresh(RefreshMode.ClientWins, dbModel.studentbookloans); loanToUpdate.book = null; loanToUpdate.student = null; loanToUpdate.systemuser = null; dbModel.studentbookloans.AddObject(loanToUpdate); dbModel.ObjectStateManager.ChangeObjectState(loanToUpdate, System.Data.EntityState.Modified); var saveCount = dbModel.SaveChanges(); if (saveCount < 1) { throw new Exception("Fail to Update Loan in DB"); } } }
public void UpdateBook(book bookToUpdate) { using (var dbModel = new LMSDataModelEntities()) { bookToUpdate.bookauthors = null; bookToUpdate.department = null; bookToUpdate.publisher = null; bookToUpdate.studentbookloans = null; bookToUpdate.systemuser = null; dbModel.books.AddObject(bookToUpdate); dbModel.ObjectStateManager.ChangeObjectState(bookToUpdate, System.Data.EntityState.Modified); var saveCount = dbModel.SaveChanges(); if (saveCount < 1) { throw new Exception("Fail to Update Book " + bookToUpdate.Title + "in DB"); } } }
public void AddSystemUser(systemuser newUser) { using (var dbModel = new LMSDataModelEntities()) { dbModel.systemusers.AddObject(newUser); dbModel.ObjectStateManager.ChangeObjectState(newUser, System.Data.EntityState.Added); var saveCount = dbModel.SaveChanges(); if (saveCount < 1) { throw new Exception("Fail to insert system user " + newUser.FirstName + " " + newUser.LastName + " into DB"); } } }
public void AddPublisher(publisher newPublisher) { using (var dbModel = new LMSDataModelEntities()) { dbModel.publishers.AddObject(newPublisher); dbModel.ObjectStateManager.ChangeObjectState(newPublisher, System.Data.EntityState.Added); var savecount = dbModel.SaveChanges(); if (savecount < 1) { throw new Exception("Fail to insert Publisher " + newPublisher.Name + " into DB"); } } }