static void Main(string[] args)
{
Console.WriteLine("Hello World!");
var context = new LibraryContext();
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
//context.Database.Migrate();
Console.WriteLine();
var author = context.Set <Author>()
.Include(x => x.Books)
.FirstOrDefault();
Console.WriteLine($"Author - First: {author.Name}; Books: {string.Join(",", author.Books.Select(b => b.Name))}");
Console.WriteLine();
Console.WriteLine($"Author - List");
var authors = context.Set <Author>().ToList();
authors.ForEach(a => Console.WriteLine(a.Name));
Console.WriteLine();
Console.WriteLine("Press enter to exit");
var h = Console.ReadLine();
context.Dispose();
}
private void SeedCategories(LibraryContext context)
{
var cat1 = new Category()
{
Id = 1,
Name = "Coursebook"
};
context.Set <Category>().AddOrUpdate(cat1);
var cat2 = new Category()
{
Id = 2,
Name = "Novel"
};
context.Set <Category>().AddOrUpdate(cat2);
var cat3 = new Category()
{
Id = 3,
Name = "Biography"
};
context.Set <Category>().AddOrUpdate(cat3);
context.SaveChanges();
}
public void Add(T t)
{
if (t != null)
{
_libDbContext.Set <T>().Add(t);
}
}
public void Add(T entity)
{
context.Set <T>().Add(entity);
context.SaveChanges();
//context.Entry(entity).State = System.Data.Entity.EntityState.Added;
}
public async Task <T> AddAsync(T entity, CancellationToken cancellationToken = default)
{
await _dbContext.Set <T>().AddAsync(entity);
await _dbContext.SaveChangesAsync(cancellationToken);
return(entity);
}
public async Task <ActionResult> Post(Author author)
{
await _libraryContext.Set <Author>().AddAsync(author);
await _libraryContext.SaveChangesAsync();
return(Ok());
}
public async Task <Book> Handle(GetBookByIdQuery query)
{
return(await _libraryContext.Set <Book>()
.Include(e => e.Author)
.Include(e => e.Category)
.Include(e => e.Country)
.Include(e => e.Language)
.Include(e => e.Publisher)
.SingleOrDefaultAsync(e => e.Id == query.Id));
}
public bool Insert(T obj)
{
try
{
_context.Set <T>().Add(obj);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
private void AddJsonDataToContext <T>(string fileName)
where T : class
{
var enumerable = _context.Set <T>()
.AsEnumerable();
var jsonReader = new JsonDataReader();
var freshData = jsonReader.GetJsonData <T>(fileName)
.Where(x => !PublicationExists(enumerable, x))
.ToArray();
if (freshData.Any())
{
_context.Set <T>().AddRange(freshData);
}
}
private void SeedBooks(LibraryContext context)
{
var book1 = new Book()
{
Id = 1,
CategoryId = 1,
Isbn = "9788325698679",
Title = "THINKING IN JAVA",
Author = "Eckel Bruce",
Page = 1256,
Publisher = "Helion",
PublicationYear = 2017,
Available = "Yes"
};
context.Set <Book>().AddOrUpdate(book1);
var book2 = new Book()
{
Id = 2,
CategoryId = 2,
Isbn = "9788127698879",
Title = "Crime and Punishment",
Author = "Fyodor Dostoyevsky",
Page = 320,
Publisher = "Bottom Of The Hill Publishing",
PublicationYear = 2005,
Available = "Yes"
};
context.Set <Book>().AddOrUpdate(book2);
var book3 = new Book()
{
Id = 3,
CategoryId = 3,
Isbn = "9788727658809",
Title = "Steve Jobs",
Author = "Isaacson Walter",
Page = 736,
Publisher = "Insignis",
PublicationYear = 2015,
Available = "Yes"
};
context.Set <Book>().AddOrUpdate(book3);
context.SaveChanges();
}
private void SeedOrders(LibraryContext context)
{
var idUser = context.Set <User>().Where(u => u.UserName == "Admin").FirstOrDefault().Id;
var order = new Order()
{
Id = 1,
UserId = idUser,
BookId = 1,
OrderDate = DateTime.Now,
ReceptionDate = DateTime.Now.AddDays(2),
ReturnDate = DateTime.Now.AddDays(30)
};
context.Set <Order>().AddOrUpdate(order);
context.SaveChanges();
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
var context = new LibraryContext();
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "Santiago Posteguillo"
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "Simon Scarrow"
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "Steven Pressfiel"
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "Orson Scott"
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "John Scalzi"
});
context.SaveChanges();
Console.WriteLine();
var author = context.Set <Author>().FirstOrDefault();
Console.WriteLine($"Author - First: {author.Name}");
Console.WriteLine();
Console.WriteLine($"Author - List");
var authors = context.Set <Author>().ToList();
authors.ForEach(a => Console.WriteLine(a.Name));
Console.WriteLine();
Console.WriteLine("Press any key to exit");
var h = Console.ReadLine();
context.Dispose();
}
public async Task <TEntity> CreateAsync(TEntity item)
{
await _context.Set <TEntity>().AddAsync(item);
await _context.SaveChangesAsync();
return(item);
}
public Librarian Add(Librarian libEntity)
{
DbEntityEntry dbEntityEntry = _context.Entry(libEntity);
if (dbEntityEntry != null && dbEntityEntry.State != EntityState.Detached)
{
dbEntityEntry.State = EntityState.Added;
}
var dbset = _context.Set <Librarian>();
dbset.Add(libEntity);
_context.SaveChanges();
return(libEntity);
}
public Cardholder Add(Cardholder libEntity)
{
DbEntityEntry dbEntityEntry = _context.Entry(libEntity);
if (dbEntityEntry != null && dbEntityEntry.State != EntityState.Detached)
{
dbEntityEntry.State = EntityState.Added;
}
var dbset = _context.Set <Cardholder>();
dbset.Add(libEntity);
_context.SaveChanges();
return(libEntity);
}
public CheckOutLog Add(CheckOutLog libEntity)
{
DbEntityEntry dbEntityEntry = _context.Entry(libEntity);
if (dbEntityEntry != null && dbEntityEntry.State != EntityState.Detached)
{
dbEntityEntry.State = EntityState.Added;
}
var newDbSet = _context.Set <CheckOutLog>();
newDbSet.Add(libEntity);
_context.SaveChanges();
return(libEntity);
}
public TEntidade ObterPorId(int id, params Expression <Func <TEntidade, object> >[] includeProperties)
{
if (includeProperties.Any())
{
return(Listar(includeProperties).FirstOrDefault(x => x.Id.ToString() == id.ToString()));
}
return(_context.Set <TEntidade>().Find(id));
}
public async Task <Book> Handle(CreateBookCommand command)
{
var book = new Book
{
CategoryId = command.CategoryId,
AuthorId = command.AuthorId,
Title = command.Title,
CountryId = command.CountryId,
LanguageId = command.LanguageId,
Description = command.Description,
PublisherId = command.PublisherId
};
_libraryContext.Set <Book>().Add(book);
await _libraryContext.SaveChangesAsync();
return(_libraryContext.Set <Book>()
.Include(e => e.Author)
.Include(e => e.Category)
.Include(e => e.Country)
.Include(e => e.Language)
.Include(e => e.Publisher)
.SingleOrDefault(e => e.Id == book.Id));
}
public void Update(TEntity entity)
{
if (_dbContext.Entry(entity).State == EntityState.Detached)
{
_dbContext.Attach(entity);
}
_dbContext.Set <TEntity>().Update(entity);
_dbContext.SaveChanges();
}
public async Task <int> Delete(Expression <Func <T, bool> > func)
{
var itemsToRemove = await context.Set <T>().Where(func).ToListAsync();
foreach (var item in itemsToRemove)
{
context.Set <T>().Remove(item);
}
return(await context.SaveChangesAsync());
}
public GenericRepository(LibraryContext _data)
{
this._data = _data;
_dbSet = _data.Set <T>();
}
public Repository(LibraryContext context)
{
this.context = context;
entities = context.Set <T>();
}
public virtual IEnumerable <T> GetAll()
{
return(_context.Set <T>());
}
public void Delete(T entity)
{
context.Set <T>().Remove(entity);
}
public GenericRepository(string connection)
{
_databaseLibraryContext = new LibraryContext(connection);
_dbSet = _databaseLibraryContext.Set <TEntity>();
}
public T Get(long id)
{
return(_context.Set <T>().Find(id));
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
var context = new LibraryContext();
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
//context.Database.Migrate();
context.Add(new Author()
{
Id = Guid.NewGuid(),
Name = "Santiago Posteguillo",
Books = new List <Book>()
{
new Book()
{
Id = Guid.NewGuid(),
Name = "Africanus"
},
new Book()
{
Id = Guid.NewGuid(),
Name = "Las legiones malditas"
}
}
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "Simon Scarrow"
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "Steven Pressfiel"
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "Orson Scott"
});
context.Add(new Author()
{
Id = Guid.NewGuid(), Name = "John Scalzi"
});
context.SaveChanges();
Console.WriteLine();
var author = context.Set <Author>()
.Include(x => x.Books)
.FirstOrDefault();
Console.WriteLine($"Author - First: {author.Name}; Books: {string.Join(",", author.Books.Select(b => b.Name))}");
Console.WriteLine();
Console.WriteLine($"Author - List");
var authors = context.Set <Author>().ToList();
authors.ForEach(a => Console.WriteLine(a.Name));
var books = context.Set <Book>().ToList();
Console.WriteLine();
Console.WriteLine("Press enter to exit");
var h = Console.ReadLine();
context.Dispose();
}
public TEntity Add(TEntity entity)
{
Context.Set <TEntity>().Add(entity);
Context.SaveChanges();
return(entity);
}
public CheckoutLogRepository()
{
_context = new LibraryContext();
_dbSet = _context.Set <CheckOutLog>();
}
public virtual void Add(params TEntity[] toAdd)
{
Context.Set <TEntity>().AddRange(toAdd);
}