public void Create(AuthorBusiness item)
{
using (var database = new LibrarySystemDbEntities2())
{
var dbObject = Mapping.ConvertToDataEntity(item);
database.Author.Add(dbObject);
database.SaveChanges();
}
}
public void Delete(int id)
{
using (var database = new LibrarySystemDbEntities2())
{
var dbAuthor = database.Author.FirstOrDefault(a => a.Id == id);
if (dbAuthor.isDeleted != true)
{
dbAuthor.isDeleted = true;
}
database.SaveChanges();
}
}
public void Delete(int id)
{
using (var database = new LibrarySystemDbEntities2())
{
var dbBook = database.Book.FirstOrDefault(b => b.Id == id);
if (dbBook.isDeleted != true)
{
dbBook.isDeleted = true;
}
database.SaveChanges();
}
}
public void Update(AuthorBusiness item)
{
using (var database = new LibrarySystemDbEntities2())
{
var dbAuthor = database.Author.FirstOrDefault(a => a.Id == item.Id);
dbAuthor.Name = item.Name;
dbAuthor.Birthdate = item.Birthdate;
dbAuthor.Gender = item.Gender;
dbAuthor.isDeleted = item.isDeleted;
if (dbAuthor.isDeleted == null)
{
dbAuthor.isDeleted = false;
}
database.SaveChanges();
}
}
public void Update(OwnerBusiness item)
{
using (var database = new LibrarySystemDbEntities2())
{
var dbOwner = database.Owner.FirstOrDefault(a => a.Id == item.Id);
dbOwner.Name = item.Name;
dbOwner.Email = item.Email;
dbOwner.Address = item.Address;
dbOwner.PhoneNumber = item.PhoneNumber;
dbOwner.UniqueIdNumber = item.UniqueIdNumber;
dbOwner.Gender = item.Gender;
dbOwner.isDeleted = item.isDeleted;
if (dbOwner.isDeleted == null)
{
dbOwner.isDeleted = false;
}
database.SaveChanges();
}
}
public void Update(BookBusiness item)
{
using (var database = new LibrarySystemDbEntities2())
{
AuthorRepository authorRepo = new AuthorRepository();
OwnerRepository ownerRepo = new OwnerRepository();
var dbBook = database.Book.FirstOrDefault(b => b.Id == item.Id);
dbBook.Name = item.Name;
dbBook.ISBN = item.ISBN;
dbBook.countPages = item.countPages;
dbBook.datePublished = item.datePublished;
dbBook.isDeleted = item.isDeleted;
if (dbBook.isDeleted == null)
{
dbBook.isDeleted = false;
}
dbBook.Author = Mapping.ConvertToDataEntity(authorRepo.Read(item.AuthorId));
dbBook.Owner = Mapping.ConvertToDataEntity(ownerRepo.Read(item.OwnerId));
database.SaveChanges();
}
}
