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