public async Task <IActionResult> Create([FromForm] Book book)
{
book.Alias = Unsign.convertToUnSign(book.BookName.ToLower());
var createdBook = await _bookService.CreateAsync(book, Request);
return(Ok(createdBook));
}
public async Task <bool> Create([FromBody] JObject province)
{
var provinces = province["LtsItem"];
List <Province> lstprovince = provinces
.Select(sc =>
new Province()
{
Id = sc["abc"].ToString(),
Name = sc["name"].ToString().Trim(),
Alias = Unsign.convertToUnSign(sc["name"].ToString()).Trim()
}
).ToList();
await _provinceService.CreateManyAsync(lstprovince);
return(true);
}
public async Task <bool> Create([FromBody] JObject district)
{
var districts = district["LtsItem"];
List <District> lstDistrict = districts
.Select(sc =>
new District()
{
Id = sc["abc"].ToString(),
Name = sc["name"].ToString().Trim(),
Alias = Unsign.convertToUnSign(sc["name"].ToString()).Trim(),
ProvinceId = sc["tinh_abc"].ToString()
}
).ToList();
await _districtService.CreateManyAsync(lstDistrict);
return(true);
}
public async Task <bool> Create([FromBody] JObject ward)
{
var wards = ward["LtsItem"];
List <Ward> lstWard = wards
.Select(sc =>
new Ward()
{
Id = sc["abc"].ToString(),
Name = sc["name"].ToString().Trim(),
Alias = Unsign.convertToUnSign(sc["name"].ToString()).Trim(),
DistrictId = sc["huyen_abc"].ToString()
}
).ToList();
await _wardService.CreateManyAsync(lstWard);
return(true);
}
public async Task <ActionResult <EntityList <BooksViewModel> > > SearchBookByNameAdmin(
[FromQuery] string name,
[FromQuery] int page
)
{
var filter = Builders <Book> .Filter.Regex("Alias", new BsonRegularExpression(Unsign.convertToUnSign(name).ToLower()))
& Builders <Book> .Filter.Eq("DeleteAt", BsonNull.Value);
var books = await _bookService.SearchBooksAdminAsync(filter, Request, page);
return(Ok(books));
}
public async Task <ActionResult <EntityList <BooksViewModel> > > SearchBookByName(
[FromQuery] string name,
[FromQuery] string typeId,
[FromQuery] string sortPrice,
[FromQuery] string publishHouseId,
[FromQuery] string authorId,
[FromQuery] string tag,
[FromQuery] int page
)
{
var filter = Builders <Book> .Filter.Regex("Alias", new BsonRegularExpression(Unsign.convertToUnSign(name).ToLower()))
& Builders <Book> .Filter.Eq("DeleteAt", BsonNull.Value);
if (typeId != null)
{
filter = filter & Builders <Book> .Filter.Eq("TypeId", typeId);
}
if (publishHouseId != null)
{
filter = filter & Builders <Book> .Filter.Eq("PublishHouseId", publishHouseId);
}
if (authorId != null)
{
filter = filter & Builders <Book> .Filter.Eq("AuthorId", authorId);
}
if (tag != null)
{
filter = filter & Builders <Book> .Filter.Eq("Tag", tag);
}
SortDefinition <Book> sortDefinition = null;
if (sortPrice == "desc")
{
sortDefinition = Builders <Book> .Sort.Descending(x => x.Price);
}
else
{
sortDefinition = Builders <Book> .Sort.Ascending(x => x.Price);
}
var books = await _bookService.SearchBooksAsync(filter, sortDefinition, Request, page);
return(Ok(books));
}
