public IActionResult GetAttraction([FromQuery] AttractionSM attractionSM, [FromQuery] DefaultSearch defaultSearch)
{
try
{
var list = _IAtrractionService.GetAllAtrraction(null, _ => _.City, _ => _.Category);
if (!String.IsNullOrWhiteSpace(attractionSM.City))
{
list = list.Where(_ => _.City.Name.ToLower() == attractionSM.City.ToLower());
}
if (!String.IsNullOrWhiteSpace(attractionSM.Name))
{
list = list.Where(_ => _.Name.ToLower().Contains(attractionSM.Name.ToLower()));
}
if (attractionSM.IsTemporarityClosed != null)
{
list = list.Where(_ => _.IsTemporarityClosed == attractionSM.IsTemporarityClosed);
}
if (!String.IsNullOrWhiteSpace(attractionSM.Category))
{
list = list.Where(_ => _.Category.Name.ToLower() == attractionSM.Category.ToLower());
}
int total = list.ToList().Count();
switch (defaultSearch.SortBy)
{
case "name":
list = GenericSorter.Sort(list, _ => _.Name, defaultSearch.SortDir);
break;
case "category":
list = GenericSorter.Sort(list, _ => _.Category.Name, defaultSearch.SortDir);
break;
case "city":
list = GenericSorter.Sort(list, _ => _.City.Name, defaultSearch.SortDir);
break;
default:
list = GenericSorter.Sort(list, _ => _.CreateAt, defaultSearch.SortDir);
break;
}
var data = list.Skip(defaultSearch.PageIndex)
.Take(defaultSearch.PageSize)
.Select(_ => _mapper.Map <AttractionVM>(_))
.ToList();
return(Ok(new { data, total }));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
public IQueryable <Order> GetList(IGenericQuery <Order> queryParam)
{
IQueryable <Order> query = this._context.Orders.Where(queryParam.Filters.Query());
IGenericSorter <Order> sort = null;
// TODO: create a fabric
if (queryParam.SortItem != null)
{
sort = new GenericSorter <Order>(query, queryParam.SortItem.OrderBys);
}
else
{
sort = new StringGenericSorter <Order>(query, queryParam.SortQuery);
}
query = sort.Sort();
return(query);
}
public IList <CultureExtended> GetAll(out int recordCount, string sortType = null, int startRowIndex = -1, int maximumRows = -1)
{
using (var context = new ImobeNetContext())
{
var result = (from c in context.Culture
join i in context.Icon on c.IDIcon equals i.IDIcon
//where c.Status == (short)Enums.StatusType.Active
orderby c.Name
select new CultureExtended
{
Name = c.Name,
IDCulture = c.IDCulture,
CreateDate = c.CreateDate,
CreatedBy = c.CreatedBy,
ModifiedBy = c.ModifiedBy,
ModifyDate = c.ModifyDate,
Status = c.Status,
IDIcon = i.IDIcon.Value,
IconPath = i.Path,
IconName = i.Name,
}).ToList();
var query = result.AsQueryable();
recordCount = result.Count();
if (sortType != null && sortType.Length > 0)
{
query = GenericSorter.GetListSort(query, sortType);
}
if (startRowIndex > -1 && maximumRows > -1)
{
query = query.Distinct().Skip(startRowIndex).Take(maximumRows);
}
return(query.ToList());
}
}
public IActionResult GetTicketType([FromQuery] TicketTypeSM ticketType, [FromQuery] DefaultSearch defaultSearch)
{
try
{
var list = _ITicketTypeService.GetAllTicketType(_ => _.IsDelete == ticketType.IsDelete, _ => _.Atrraction, _ => _.Atrraction.City, _ => _.Atrraction.Category, _ => _.Tickets);
if (!String.IsNullOrWhiteSpace(ticketType.Name))
{
list = list.Where(_ => _.Name.ToLower().Contains(ticketType.Name.ToLower()));
}
if (!String.IsNullOrWhiteSpace(ticketType.Attraction))
{
list = list.Where(_ => _.Atrraction.Name.ToLower().Contains(ticketType.Attraction.ToLower()));
}
if (!String.IsNullOrWhiteSpace(ticketType.City))
{
list = list.Where(_ => _.Atrraction.City.Name.ToLower().Contains(ticketType.City.ToLower()));
}
if (ticketType.CategoryId != 0)
{
list = list.Where(_ => _.Atrraction.Category.Id == ticketType.CategoryId);
}
if (ticketType.PriceFrom != 0 && ticketType.PriceTo != 0)
{
list = list.Where(_ => _.AdultPrice >= ticketType.PriceFrom && _.AdultPrice <= ticketType.PriceTo);
}
int total = list.Count();
switch (defaultSearch.SortBy)
{
case "name":
list = GenericSorter.Sort(list, _ => _.Name, defaultSearch.SortDir);
break;
case "attraction":
list = GenericSorter.Sort(list, _ => _.Atrraction.Name, defaultSearch.SortDir);
break;
case "city":
list = GenericSorter.Sort(list, _ => _.Atrraction.City.Name, defaultSearch.SortDir);
break;
case "adultPrice":
list = GenericSorter.Sort(list, _ => _.AdultPrice, defaultSearch.SortDir);
break;
case "childrenPrice":
list = GenericSorter.Sort(list, _ => _.ChildrenPrice, defaultSearch.SortDir);
break;
default:
list = GenericSorter.Sort(list, _ => _.CreateAt, defaultSearch.SortDir);
break;
}
var data = list.Skip(defaultSearch.PageIndex)
.Take(defaultSearch.PageSize)
.Select(_ => _mapper.Map <TicketTypeVM>(_))
.ToList();
return(Ok(new { data, total }));
}
catch (Exception e)
{
return(BadRequest(e.Message));
}
}
