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(); } }