public static bool Delete(int idLocation)
{
using (var _dbContext = new serti_dbContext())
{
var locationFiltered =
_dbContext.Location.FirstOrDefault(_location => _location.Id == idLocation);
if (locationFiltered == null)
{
return(false);
}
_dbContext.Remove(locationFiltered);
return(_dbContext.SaveChanges() > 0);
}
}
public static bool Delete(int idBook)
{
using (var _dbContext = new serti_dbContext())
{
var bookFiltered =
_dbContext.Book.FirstOrDefault(_book => _book.Id == idBook);
if (bookFiltered == null)
{
return(false);
}
_dbContext.Remove(bookFiltered);
return(_dbContext.SaveChanges() > 0);
}
}
public static bool Create(BookViewModel bookViewModel)
{
using (var _dbContext = new serti_dbContext())
{
var book = new Book()
{
IdLocation = (int)bookViewModel.LocationViewModel.Id,
VolumeNumber = bookViewModel.VolumeNumber,
Title = bookViewModel.Title,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
_dbContext.Book.Add(book);
return(_dbContext.SaveChanges() > 0);
}
}
public static bool Create(LocationViewModel locationViewModel)
{
using (var _dbContext = new serti_dbContext())
{
var location = new Location()
{
Shelf = locationViewModel.Shelf,
Room = locationViewModel.Room,
Bookseller = locationViewModel.Bookseller,
Position = locationViewModel.Position,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
_dbContext.Location.Add(location);
return(_dbContext.SaveChanges() > 0);
}
}
public static bool Update(BookViewModel bookViewModel)
{
using (var _dbContext = new serti_dbContext())
{
var bookFiltered =
_dbContext.Book.FirstOrDefault(_book => _book.Id == bookViewModel.Id);
if (bookFiltered == null)
{
return(false);
}
bookFiltered.VolumeNumber = bookViewModel.VolumeNumber;
bookFiltered.Title = bookFiltered.Title;
bookFiltered.UpdatedAt = DateTime.Now;
return(_dbContext.SaveChanges() > 0);
}
}
public static bool Update(LocationViewModel locationViewModel)
{
using (var _dbContext = new serti_dbContext())
{
var locationFiltered =
_dbContext.Location.FirstOrDefault(_location => _location.Id == locationViewModel.Id);
if (locationFiltered == null)
{
return(false);
}
locationFiltered.Shelf = locationViewModel.Shelf;
locationFiltered.Room = locationViewModel.Room;
locationFiltered.Bookseller = locationViewModel.Bookseller;
locationFiltered.Position = locationViewModel.Position;
locationFiltered.UpdatedAt = DateTime.Now;
return(_dbContext.SaveChanges() > 0);
}
}
public static List <LocationViewModel> Get()
{
using (var _dbContext = new serti_dbContext())
{
var locations = _dbContext.Location.AsQueryable();
//if(filter != null)
//{
// if (filter.Id != null)
// locations = locations.Where(location => location.Id == filter.Id);
//}
var locationsVm = locations.Select(location => new LocationViewModel
{
Id = location.Id,
Shelf = location.Shelf,
Room = location.Room,
Bookseller = location.Bookseller,
Position = location.Position
}).ToList();
return(locationsVm);
}
}
public static List <BookViewModel> Get()
{
using (var _dbContext = new serti_dbContext())
{
var books = _dbContext.Book.AsQueryable();
var booksVm = books.Select(book => new BookViewModel
{
Id = book.Id,
LocationViewModel = new LocationViewModel
{
Id = book.IdLocationNavigation.Id,
Shelf = book.IdLocationNavigation.Shelf,
Room = book.IdLocationNavigation.Room,
Bookseller = book.IdLocationNavigation.Bookseller,
Position = book.IdLocationNavigation.Position
},
VolumeNumber = book.VolumeNumber,
Title = book.Title,
}).ToList();
return(booksVm);
}
}
