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 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 ICollection <AuthorBusiness> ReadAll() { using (var database = new LibrarySystemDbEntities2()) { var dbAuthor = database.Author.Where(a => a.isDeleted == false).ToList(); var result = new List <AuthorBusiness>(); foreach (var author in dbAuthor) { result.Add(Mapping.ConvertToBusinessEntity(author)); } return(result); } }
public ICollection <OwnerBusiness> ReadAll() { using (var database = new LibrarySystemDbEntities2()) { var dbOwner = database.Owner.Where(o => o.isDeleted == false).ToList(); var result = new List <OwnerBusiness>(); foreach (var owner in dbOwner) { result.Add(Mapping.ConvertToBusinessEntity(owner)); } return(result); } }
public ICollection <BookBusiness> ReadAll() { using (var database = new LibrarySystemDbEntities2()) { var dbBook = database.Book.Where(b => b.isDeleted == false).ToList(); var result = new List <BookBusiness>(); foreach (var book in dbBook) { result.Add(Mapping.ConvertToBusinessEntity(book)); } return(result); } }
public static void Main(string[] args) { var db = new LibrarySystemDbEntities2(); var author = db.Book.FirstOrDefault(b => b.Id == 3).Owner.Name; Console.WriteLine(author); var bookRepo = new BookRepository(); var authorRepo = new AuthorRepository(); var ownerRepo = new OwnerRepository(); //var bookUpdate3 = bookRepo.Read(3); //var bookUpdate4 = bookRepo.Read(4); //bookUpdate3.isDeleted = false; //bookUpdate4.isDeleted = false; //bookRepo.Update(bookUpdate3); //bookRepo.Update(bookUpdate4); //var owner1 = new OwnerBusiness(); //owner1.Name = "Alex Todorv"; //owner1.Gender = 0; //owner1.Email = "*****@*****.**"; //owner1.Address = "Sofia, Druzhba 2"; //owner1.UniqueIdNumber = "9406257845"; //owner1.isDeleted = false; var book1 = new BookBusiness { Name = "Test book", ISBN = 122445667, countPages = 120, AuthorId = 12, OwnerId = 4 }; //var author1 = new AuthorBusiness(); //author1.Name = "Hristo Botev"; //author1.isDeleted = false; //author1.Gender = 0; //var book3 = new BookBusiness { Name = "Pod Igoto", ISBN = 122445667, countPages = 230, Author = author1, Owner = new OwnerBusiness { Name = "Gosho Peshov", PhoneNumber = "08859494616", Email = "*****@*****.**" } }; bookRepo.Create(book1); //authorRepo.Create(author1); //bookRepo.Create(book3); //ownerRepo.Create(owner1); }
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(); } }