public IHttpActionResult GetAllReceptionists(int page = Page, int pagesize = PageSize)
{
PagedResultsDto users = _userFacade.GetAllUsers(UserId, page, pagesize, Enums.RoleType.Receptionist);
var data = Mapper.Map <List <ReceptionistModel> >(users.Data);
return(PagedResponse("GetAllReceptionists", page, pagesize, users.TotalCount, data));
}
public PagedResultsDto GetAllSizes(string language, long userId, int page, int pageSize)
{
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = _repository.Query(x => !x.Size.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Size.Restaurant.RestaurantAdminId == userId).Select(x => x.Size).Count(x => !x.IsDeleted);
List <Size> sizes;
if (pageSize > 0)
{
sizes = _repository.Query(x => !x.Size.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Size.Restaurant.RestaurantAdminId == userId).Select(x => x.Size)
.OrderBy(x => x.SizeId).Skip((page - 1) * pageSize)
.Take(pageSize).ToList();
}
else
{
sizes = _repository.Query(x => !x.Size.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Size.Restaurant.RestaurantAdminId == userId).Select(x => x.Size)
.OrderBy(x => x.SizeId).ToList();
}
results.Data = Mapper.Map <List <Size>, List <SizeDto> >(sizes);
//results.Data = Mapper.Map<List<Size>, List<SizeDto>>(sizes, opt =>
//{
// opt.BeforeMap((src, dest) =>
// {
// foreach (Size size in src)
// {
// size.SizeTranslations = size.SizeTranslations
// .Where(x => x.Language.ToLower() == language.ToLower()).ToList();
// }
// }
// );
//});
return(results);
}
public IHttpActionResult GetAllBranches(int page = Page, int pagesize = PageSize)
{
PagedResultsDto branches = _branchFacade.GetAllBranches(Language, UserId, page, pagesize);
var data = Mapper.Map <List <BranchModel> >(branches.Data);
return(PagedResponse("GetAllBranches", page, pagesize, branches.TotalCount, data));
}
public IHttpActionResult GetAllTypes(int page = Page, int pagesize = PageSize)
{
PagedResultsDto TypeObj = _TypeFacade.GetAllTypes(page, pagesize, TenantId);
var data = Mapper.Map <List <TypeModel> >(TypeObj.Data);
return(PagedResponse("GetAllTypes", page, pagesize, TypeObj.TotalCount, data, TypeObj.IsParentTranslated));
}
public IHttpActionResult GetAllRoom(int page = Page, int pagesize = PageSize)
{
PagedResultsDto rooms = _roomFacade.GetAllRoom(UserId, page, pagesize);
var data = Mapper.Map <List <RoomModel> >(rooms.Data);
return(PagedResponse("GetAllRoom", page, pagesize, rooms.TotalCount, data));
}
public PagedResultsDto GetAllRestaurantWaiters(long restaurantId, int page, int pageSize, string language)
{
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = _repository.Query(x => !x.IsDeleted && x.RestaurantId == restaurantId).Select().Count();
var waiters = _repository
.Query(x => !x.IsDeleted && x.RestaurantId == restaurantId).Select()
.OrderBy(x => x.RestaurantId).Skip((page - 1) * pageSize)
.Take(pageSize).ToList();
results.Data = Mapper.Map <List <RestaurantWaiter>, List <RestaurantWaiterDTO> >(waiters);
//results.Data = Mapper.Map<List<RestaurantWaiter>, List<RestaurantWaiterDTO>>(waiters, opt =>
//{
// opt.BeforeMap((src, dest) =>
// {
// foreach (RestaurantWaiter waiter in src)
// {
// waiter.Branch.BranchTranslations = waiter.Branch.BranchTranslations
// .Where(x => x.Language.ToLower() == language.ToLower()).ToList();
// }
// }
// );
//});
return(results);
}
public IHttpActionResult GetAllOwners(int page = Page, int pagesize = PageSize)
{
PagedResultsDto OwnerObj = _OwnerFacade.GetAllOwners(page, pagesize, TenantId);
var data = Mapper.Map <List <OwnerModel> >(OwnerObj.Data);
return(PagedResponse("GetAllOwners", page, pagesize, OwnerObj.TotalCount, data, OwnerObj.IsParentTranslated));
}
public IHttpActionResult GetAllRequests(int page = Page, int pagesize = PageSize, long roomId = 0, long featureId = 0, string from = "", string to = "")
{
PagedResultsDto requests = _requestFacade.GetAllRequests(UserId, page, pagesize, UserRole, roomId, featureId, from, to);
var data = Mapper.Map <List <RequestModel> >(requests.Data);
return(PagedResponse("GetAllRequests", page, pagesize, requests.TotalCount, data));
}
public IHttpActionResult GetAllBuilding(int page = Page, int pagesize = PageSize)
{
PagedResultsDto buildings = _buildingFacade.GetAllBuilding(UserId, page, pagesize);
var data = Mapper.Map <List <BuildingModel> >(buildings.Data);
return(PagedResponse("GetAllBuilding", page, pagesize, buildings.TotalCount, data));
}
public IHttpActionResult GetAllCountries(int page = Page, int pagesize = PageSize)
{
PagedResultsDto CountryObj = _CountryFacade.GetAllCountrys(page, pagesize, TenantId);
var data = Mapper.Map <List <CountryModel> >(CountryObj.Data);
return(PagedResponse("GetAllCountries", page, pagesize, CountryObj.TotalCount, data, CountryObj.IsParentTranslated));
}
public IHttpActionResult GetAllFloor(int page = Page, int pagesize = PageSize)
{
PagedResultsDto floor = _floorFacade.GetAllFloor(UserId, page, pagesize);
var data = Mapper.Map <List <FloorModel> >(floor.Data);
return(PagedResponse("GetAllFloor", page, pagesize, floor.TotalCount, data));
}
public PagedResultsDto GetActivatedCategoriesByMenuId(string language, long menuId, int page, int pageSize)
{
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = _repository.Query(x => !x.Category.IsDeleted && x.Category.IsActive && x.Language.ToLower() == language.ToLower() && x.Category.MenuId == menuId).Select(x => x.Category).Count(x => !x.IsDeleted);
List <Category> categories;
if (pageSize > 0)
{
categories = _repository.Query(x => !x.Category.IsDeleted && x.Category.IsActive && x.Language.ToLower() == language.ToLower() && x.Category.MenuId == menuId).Select(x => x.Category)
.OrderBy(x => x.CategoryId).Skip((page - 1) * pageSize)
.Take(pageSize).ToList();
}
else
{
categories = _repository.Query(x => !x.Category.IsDeleted && x.Category.IsActive && x.Language.ToLower() == language.ToLower() && x.Category.MenuId == menuId).Select(x => x.Category)
.OrderBy(x => x.CategoryId).ToList();
}
results.Data = Mapper.Map <List <Category>, List <CategoryDTO> >(categories);
//results.Data = Mapper.Map<List<Category>, List<CategoryDTO>>(categories, opt =>
//{
// opt.BeforeMap((src, dest) =>
// {
// foreach (Category category in src)
// {
// category.CategoryTranslations = category.CategoryTranslations
// .Where(x => x.Language.ToLower() == language.ToLower()).ToList();
// }
// }
// );
//});
return(results);
}
public PagedResultsDto GetAllFeatures(long adminId, int page, int pageSize)
{
var user = _userService.Find(adminId);
if (user == null)
{
throw new ValidationException(ErrorCodes.UserNotFound);
}
if (user.IsDeleted)
{
throw new ValidationException(ErrorCodes.UserDeleted);
}
if (!user.IsActive)
{
throw new ValidationException(ErrorCodes.UserDeactivated);
}
var featuresCount = _featureService.Query(x => !x.IsDeleted && x.CreationBy == adminId).Select().Count();
var features = Mapper.Map <List <FeatureDto> >(_featureService.GetAllFeaturesAdminId(adminId, page, pageSize));
PagedResultsDto results = new PagedResultsDto
{
TotalCount = featuresCount,
Data = features
};
return(results);
}
public PagedResultsDto GetActivatedItemsByCategoryId(string language, long categoryId, int page, int pageSize)
{
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = _repository.Query(x => !x.Item.IsDeleted && x.Item.IsActive && x.Language.ToLower() == language.ToLower() && x.Item.CategoryId == categoryId).Select(x => x.Item).Count(x => !x.IsDeleted);
List <Item> items;
if (pageSize > 0)
{
items = _repository.Query(x => !x.Item.IsDeleted && x.Item.IsActive && x.Language.ToLower() == language.ToLower() && x.Item.CategoryId == categoryId).Select(x => x.Item)
.OrderBy(x => x.ItemId).Skip((page - 1) * pageSize)
.Take(pageSize).ToList();
}
else
{
items = _repository.Query(x => !x.Item.IsDeleted && x.Item.IsActive && x.Language.ToLower() == language.ToLower() && x.Item.CategoryId == categoryId).Select(x => x.Item)
.OrderBy(x => x.ItemId).ToList();
}
results.Data = Mapper.Map <List <Item>, List <ItemDTO> >(items);
//results.Data = Mapper.Map<List<Item>, List<ItemDTO>>(items, opt =>
//{
// opt.BeforeMap((src, dest) =>
// {
// foreach (Item item in src)
// {
// item.ItemTranslations = item.ItemTranslations
// .Where(x => x.Language.ToLower() == language.ToLower()).ToList();
// }
// }
// );
//});
return(results);
}
public PagedResultsDto GetAllMenusByRestaurantAdminId(string language, long restaurantAdminId, int page, int pageSize)
{
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = _repository.Query(x => !x.Menu.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Menu.Restaurant.RestaurantAdminId == restaurantAdminId).Select(x => x.Menu).Count(x => !x.IsDeleted);
List <Menu> menus;
if (pageSize > 0)
{
menus = _repository.Query(x => !x.Menu.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Menu.Restaurant.RestaurantAdminId == restaurantAdminId).Select(x => x.Menu)
.OrderBy(x => x.MenuId).Skip((page - 1) * pageSize)
.Take(pageSize).ToList();
}
else
{
menus = _repository.Query(x => !x.Menu.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Menu.Restaurant.RestaurantAdminId == restaurantAdminId).Select(x => x.Menu)
.OrderBy(x => x.MenuId).ToList();
}
results.Data = Mapper.Map <List <Menu>, List <MenuDTO> >(menus);
//results.Data = Mapper.Map<List<Menu>, List<MenuDTO>>(menus, opt =>
//{
// opt.BeforeMap((src, dest) =>
// {
// foreach (Menu menu in src)
// {
// menu.MenuTranslations = menu.MenuTranslations
// .Where(x => x.Language.ToLower() == language.ToLower()).ToList();
// }
// }
// );
//});
return(results);
}
public IHttpActionResult GetAllOnlineBackages(int page = Page, int pagesize = PageSize)
{
PagedResultsDto BackageObj = _BackageFacade.GetAllOnlineBackages(page, pagesize, TenantId);
var data = Mapper.Map <List <BackageModel> >(BackageObj.Data);
if (data != null)
{
foreach (var item in data)
{
item.ImagesURL = new List <string>();
string path = HostingEnvironment.MapPath("~/Images/") + "\\" + "Backage-" + item.BackageId;
var imageCounter = Directory.Exists(path) ? Directory
.GetFiles(path)
.Count(x => !Path.GetFileName(x).Contains("thumb")) : -1;
int id = 1;
while (id < imageCounter + 1)
{
item.ImagesURL.Add(Url.Link("BackageImage", new { BackageId = item.BackageId, imageId = id }));
id++;
}
}
}
return(Ok(data));
return(PagedResponse("GetAllOnlineBackages", page, pagesize, BackageObj.TotalCount, data, BackageObj.IsParentTranslated));
}
public PagedResultsDto GetAllBranchesByRestaurantAdminId(string language, long restaurantAdminId, int page, int pageSize)
{
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = _repository.Query(x => !x.Branch.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Branch.Restaurant.RestaurantAdminId == restaurantAdminId).Select(x => x.Branch).Count(x => !x.IsDeleted);
List <Branch> branches;
if (pageSize > 0)
{
branches = _repository.Query(x => !x.Branch.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Branch.Restaurant.RestaurantAdminId == restaurantAdminId).Select(x => x.Branch)
.OrderBy(x => x.BranchId).Skip((page - 1) * pageSize)
.Take(pageSize).ToList();
}
else
{
branches = _repository.Query(x => !x.Branch.IsDeleted && x.Language.ToLower() == language.ToLower() && x.Branch.Restaurant.RestaurantAdminId == restaurantAdminId).Select(x => x.Branch)
.OrderBy(x => x.BranchId).ToList();
}
results.Data = Mapper.Map <List <Branch>, List <BranchDto> >(branches);
//results.Data = Mapper.Map<List<Branch>, List<BranchDto>>(branches, opt =>
//{
// opt.BeforeMap((src, dest) =>
// {
// foreach (Branch branch in src)
// {
// branch.BranchTranslations = branch.BranchTranslations
// .Where(x => x.Language.ToLower() == language.ToLower()).ToList();
// }
// }
// );
//});
return(results);
}
public IHttpActionResult GetAllAbout(int page = Page, int pagesize = PageSize)
{
PagedResultsDto AboutObj = _AboutFacade.GetAllAbouts(page, pagesize, TenantId);
var data = Mapper.Map <List <AboutModel> >(AboutObj.Data);
return(Ok(data));
return(PagedResponse("GetAllAbout", page, pagesize, AboutObj.TotalCount, data, AboutObj.IsParentTranslated));
}
public PagedResultsDto GetAllActiveFeatures(long adminId, int page, int pageSize, string role)
{
var user = _userService.Find(adminId);
if (user == null)
{
throw new ValidationException(ErrorCodes.UserNotFound);
}
if (user.IsDeleted)
{
throw new ValidationException(ErrorCodes.UserDeleted);
}
if (!user.IsActive)
{
throw new ValidationException(ErrorCodes.UserDeactivated);
}
int featuresCount = 0;
List <FeatureDto> features = null;
if (role == Enums.RoleType.Admin.ToString())
{
featuresCount = _featureService.Query(x => !x.IsDeleted && x.CreationBy == adminId).Select().Count();
features = Mapper.Map <List <FeatureDto> >(_featureService.GetAllActiveFeaturesAdminId(adminId, page, pageSize));
//PagedResultsDto results = new PagedResultsDto
//{
// TotalCount = featuresCount,
// Data = features
//};
//return results;
}
else if (role == Enums.RoleType.Room.ToString())
{
var room = _roomService.Find(adminId);
featuresCount = _featureService.Query(x => !x.IsDeleted && x.CreationBy == room.AdminId).Select().Count();
//features = Mapper.Map<List<FeatureDto>>(_featureService.GetAllActiveFeaturesAdminId(room.AdminId, page, pageSize));
features = Mapper.Map <List <Feature>, List <FeatureDto> >(_featureService.GetAllActiveFeaturesAdminId(room.AdminId, page, pageSize), opt =>
{
opt.BeforeMap((src, dest) =>
{
foreach (Feature feature in src)
{
feature.Restaurants = feature.Restaurants.Where(x => x.IsActive && !x.IsDeleted)
.ToList();
}
}
);
});
}
PagedResultsDto results = new PagedResultsDto
{
TotalCount = featuresCount,
Data = features
};
return(results);
}
public IHttpActionResult GetAllCareerForms(int page = Page, int pagesize = PageSize)
{
var getAllDataForCareerForm = _careerFormService.GetAllCareerForms(page, pagesize, TenantId);
var careerFormList = Mapper.Map <List <CareerFormModel> >(getAllDataForCareerForm.Data);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = getAllDataForCareerForm.TotalCount;
results.Data = Mapper.Map <List <CareerFormModel>, List <CareerFormDto> >(careerFormList);
return(PagedResponse("GetAllCareerForms", Page, PageSize, results.TotalCount, careerFormList, results.IsParentTranslated));
}
public PagedResultsDto GetActivatedBackgroundByUserId(long userId, int page, int pageSize)
{
var query = Queryable().Where(x => x.IsActive && x.UserId == userId);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = query.Select(x => x).Count();
results.Data = Mapper.Map <List <Background>, List <BackgroundDto> >(query.OrderBy(x => x.BackgroundId).Skip((page - 1) * pageSize)
.Take(pageSize).ToList());
return(results);
}
public PagedResultsDto GeFeatureDetails(long featureControlId, int page, int pageSize)
{
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = _featureDetailService.Query(x => !x.IsDeleted && x.FeatureControlId == featureControlId).Select().Count();
results.Data = Mapper.Map <List <FeatureDetailDto> >(_featureDetailService
.Query(x => !x.IsDeleted && x.FeatureControlId == featureControlId).Select()
.OrderBy(x => x.FeatureControlId).Skip((page - 1) * pageSize).Take(pageSize).ToList());
return(results);
}
/// <summary>
/// 返回分页后信息
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="pagedResults"></param>
/// <returns></returns>
protected JsonResult JsonForGridPaging <T>(PagedResultsDto <T> pagedResults)
{
return(Json(new
{
total = pagedResults.pagerInfo.PageCount,
page = pagedResults.pagerInfo.Pageindex,
records = pagedResults.pagerInfo.RecordCount,
rows = pagedResults.Data
}));
}
public IHttpActionResult GetAllNewsletters(int page = Page, int pagesize = PageSize)
{
var getAllDataForNewsletter = _NewsletterService.GetAllNewsLetters(page, pagesize, TenantId);
var NewsletterList = Mapper.Map <List <NewsLetterModel> >(getAllDataForNewsletter.Data);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = getAllDataForNewsletter.TotalCount;
results.Data = Mapper.Map <List <NewsLetterModel>, List <NewsLetterDto> >(NewsletterList);
return(PagedResponse("GetAllNewsletters", Page, PageSize, results.TotalCount, NewsletterList, results.IsParentTranslated));
}
public PagedResultsDto GetAllUsers(int page, int pageSize, int tenantId)
{
var query = Queryable().Where(x => x.IsActive && !x.IsSystemUser && (x.TenantId == tenantId)).OrderBy(x => x.UserId);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = query.Count(); //_repository.Query(x => !x.IsDeleted).Select().Count(x => !x.IsDeleted);
var modelReturn = query.OrderBy(x => x.UserId).Skip((page - 1) * pageSize).Take(pageSize).ToList();
results.Data = Mapper.Map <List <User>, List <UserDto> >(modelReturn);
return(results);
}
public IHttpActionResult GetAllOnlineRelatedNewsById(long newsId, int page = Page, int pagesize = PageSize)
{
PagedResultsDto NewsObj = _newsFacade.GetAllOnlineRelatedNewsById(newsId, page, pagesize, TenantId);
var data = Mapper.Map <List <NewsModel> >(NewsObj.Data);
foreach (var news in data)
{
news.Image = Url.Link("NewsImage", new { NewsId = news.NewsId, imageId = news.NewsId });
}
return(Ok(data));
}
public PagedResultsDto GetOfferByCityId(long cityId)
{
var query = Queryable().Where(x => x.CityId == cityId).OrderByDescending(x => x.OfferId);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = query.Select(x => x).Count();
var modelReturn = query.OrderByDescending(x => x.OfferId).ToList();
results.Data = Mapper.Map <List <Offer>, List <OfferDto> >(modelReturn);
return(results);
}
public PagedResultsDto GetAllCareers(int page, int pageSize, int tenantId)
{
var query = Queryable().Where(x => !x.IsDeleted && (x.TenantId == tenantId || x.TenantId == null)).OrderBy(x => x.CareerId);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = query.Select(x => x).Count();
var modelReturn = query.OrderBy(x => x.CareerId).Skip((page - 1) * pageSize).Take(pageSize).ToList();
results.Data = Mapper.Map <List <Career>, List <CareerDto> >(modelReturn);
return(results);
}
public PagedResultsDto GetAllHotelReservations(int page, int pageSize, int tenantId)
{
var query = Queryable().Where(x => x.TenantId == tenantId).OrderBy(x => x.HotelReservationId);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = query.Select(x => x).Count();
var modelReturn = query.OrderBy(x => x.HotelReservationId).Skip((page - 1) * pageSize).Take(pageSize).ToList();
results.Data = Mapper.Map <List <HotelReservation>, List <HotelReservationDto> >(modelReturn);
return(results);
}
public PagedResultsDto GetAllOnlineRelatedOffersById(long OfferId, int page, int pageSize, int tenantId)
{
var query = Queryable().Where(x => !x.IsDeleted && x.OfferId != OfferId && (x.TenantId == tenantId)).OrderBy(x => Guid.NewGuid()).Take(10);
PagedResultsDto results = new PagedResultsDto();
results.TotalCount = query.Select(x => x).Count();
var modelReturn = query.OrderBy(x => x.OfferId).Skip((page - 1) * pageSize).Take(pageSize).ToList();
results.Data = Mapper.Map <List <Offer>, List <OfferDto> >(modelReturn);
return(results);
}
