protected override void DisposeCore()
{
if (dbContext != null)
{
dbContext.Dispose();
}
}
protected void Refresh()
{
if (dbEntities != null)
{
dbEntities.Dispose();
}
dbEntities = LibraryEntities.Instance();
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
db.Dispose();
}
base.Dispose(disposing);
}
protected virtual void Dispose(bool disposing)
{
if (!this._disposed)
{
if (disposing)
{
_dbContext.Dispose();
}
}
this._disposed = true;
}
public void AddAuthor(String Name)
{
var db = new LibraryEntities();
Author author = new Author();
author.Name = Name;
db.Authors.Add(author);
db.SaveChanges();
db.Dispose();
}
public void AddBook(string Title, int AuthorId)
{
var db = new LibraryEntities();
Book book = new Book();
book.Title = Title;
book.AuthorId = AuthorId;
db.Books.Add(book);
db.SaveChanges();
db.Dispose();
}
public void AddMember(String Name, String Address, int ContactNo)
{
var db = new LibraryEntities();
Member mb = new Member();
mb.Name = Name;
mb.Address = Address;
mb.ContactNo = ContactNo;
db.Members.Add(mb);
db.SaveChanges();
db.Dispose();
}
public void AddBookIssue(string IssueDate, int MemberId, int BookId)
{
var db = new LibraryEntities();
BookIssue book = new BookIssue();
book.IssueDate = IssueDate;
book.MemberId = MemberId;
book.BookId = BookId;
db.BookIssues.Add(book);
db.SaveChanges();
db.Dispose();
}
protected override void Dispose(bool disposing)
{
_context.Dispose();
}
