public async Task <PagedResultDto <GetMenuForViewDto> > GetAll(GetAllForLookupTableInput input)
{
var filteredMasterAmenitieses = _menuRepository.GetAll()
.WhereIf(!string.IsNullOrWhiteSpace(input.Filter), e => false || e.MenuDescription.Contains(input.Filter) || e.MenuName.Contains(input.Filter))
.WhereIf(!string.IsNullOrWhiteSpace(input.MenuDescriptionFilter), e => e.MenuDescription == input.MenuDescriptionFilter)
.WhereIf(!string.IsNullOrWhiteSpace(input.MenuNameFilter), e => e.MenuName == input.MenuNameFilter);
var pagedAndFilteredMasterAmenitieses = filteredMasterAmenitieses
.OrderBy(input.Sorting ?? "id asc")
.PageBy(input);
var masterAmenitieses = from o in pagedAndFilteredMasterAmenitieses
select new GetMenuForViewDto()
{
Menu = new MenuDto
{
MenuDescription = o.MenuDescription,
MenuName = o.MenuName,
IsPerent = o.IsPerent,
ParentId = o.ParentId,
Id = o.Id
}
};
var totalCount = await filteredMasterAmenitieses.CountAsync();
return(new PagedResultDto <GetMenuForViewDto>(
totalCount,
await masterAmenitieses.ToListAsync()
));
}
public async Task <PagedResultDto <QuotationUnitPriceQuotationLookupTableDto> > GetAllQuotationForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_quotationRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.QuotationNumber.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var quotationList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <QuotationUnitPriceQuotationLookupTableDto>();
foreach (var quotation in quotationList)
{
lookupTableDtoList.Add(new QuotationUnitPriceQuotationLookupTableDto
{
Id = quotation.Id,
DisplayName = quotation.QuotationNumber?.ToString()
});
}
return(new PagedResultDto <QuotationUnitPriceQuotationLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ClientUnitPriceClientLookupTableDto> > GetAllClientForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_clientRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.ClientName.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var clientList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ClientUnitPriceClientLookupTableDto>();
foreach (var client in clientList)
{
lookupTableDtoList.Add(new ClientUnitPriceClientLookupTableDto
{
Id = client.Id,
DisplayName = client.ClientName?.ToString()
});
}
return(new PagedResultDto <ClientUnitPriceClientLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <EmailSysStatusLookupTableDto> > GetAllSysStatusForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_sysStatusRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => (e.Name != null ? e.Name.ToString():"").Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var sysStatusList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <EmailSysStatusLookupTableDto>();
foreach (var sysStatus in sysStatusList)
{
lookupTableDtoList.Add(new EmailSysStatusLookupTableDto
{
Id = sysStatus.Id,
DisplayName = sysStatus.Name?.ToString()
});
}
return(new PagedResultDto <EmailSysStatusLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <MachineLookupTableDto> > GetAllMachinesForLookupTable(GetAllForLookupTableInput input)
{
var query = _machineRepository.GetAll();
if (!string.IsNullOrEmpty(input.Filter))
{
query = query.Where(x => x.NameEn.ToLower().Contains(input.Filter.ToLower()));
}
var totalCount = await query.CountAsync();
var machineList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <MachineLookupTableDto>();
foreach (var machine in machineList)
{
lookupTableDtoList.Add(new MachineLookupTableDto
{
Id = machine.Id,
Name = machine.NameEn?.ToString(),
IpAddress = machine.IpAddress?.ToString()
});
}
return(new PagedResultDto <MachineLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ClientsLookupTableDto> > GetAllPassengerForLookupTable(GetAllForLookupTableInput input)
{
string defaultLanguage = "en";
string currentLang = await SettingManager.GetSettingValueForUserAsync(AppSettings.DefaultCurrentLanguage, AbpSession.ToUserIdentifier());
if (!string.IsNullOrWhiteSpace(currentLang))
{
defaultLanguage = currentLang;
}
var query = _clientsRepository.GetAll().Join(_countrysRepository.GetAll(), cu => cu.ClientCountry,
p => p.country_alpha2_code, (cu, p) => new { cu, p })
.WhereIf(!string.IsNullOrWhiteSpace(input.Filter),
e => e.cu.ClientFirstName.ToString().Contains(input.Filter) ||
e.cu.ClientLastName.ToString().Contains(input.Filter) || e.cu.ClientEmail.ToString().Contains(input.Filter) ||
e.p.country_name.ToString().Contains(input.Filter) ||
(e.cu.ClientFirstName.ToString() + " " + e.cu.ClientLastName.ToString()).Contains(input.Filter)
).Where(x => x.p.lang.ToUpper() == defaultLanguage.ToUpper())
.Select(x => new ClientsDetails
{
ClientEmail = x.cu.ClientEmail,
CountryName = x.p.country_name,
ClientName = x.cu.ClientFirstName + " " + x.cu.ClientLastName,
DOB = x.cu.ClientDOB,
Id = x.cu.Id,
});
var clientListTemp = query.ToList();
var reservationClients = _reservationsClientsRepository.GetAll().Where(x => x.ReservationId == input.ReservationId && x.CabinIdentificator == input.CabinIdentificator);
foreach (var client in reservationClients)
{
var itemIndex = clientListTemp.FindIndex(x => x.Id == client.ClientId);
if (itemIndex >= 0)
{
var item = clientListTemp.ElementAt(itemIndex);
item.IsSelectDisable = true;
if (client.ReservationHolder)
{
item.IsReservationHolder = true;
}
}
}
query = clientListTemp.AsQueryable();
var totalCount = query.Count();
var clientList = query
.PageBy(input)
.ToList();
var lookupTableDtoList = new List <ClientsLookupTableDto>();
foreach (var client in clientList)
{
lookupTableDtoList.Add(new ClientsLookupTableDto
{
Id = client.Id,
DisplayName = client.ClientName,
Email = client.ClientEmail,
Country = client.CountryName,
IsSelectDisable = client.IsSelectDisable,
IsReservationHolder = client.IsReservationHolder
});
}
return(new PagedResultDto <ClientsLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ClientsCruiseMasterAmenitiesLookupTableDto> > GetAllCruiseMasterAmenitiesForLookupTable(GetAllForLookupTableInput input)
{
string defaultCurrentLanguage = await SettingManager.GetSettingValueForUserAsync(AppSettings.DefaultCurrentLanguage, AbpSession.ToUserIdentifier());
if (string.IsNullOrWhiteSpace(defaultCurrentLanguage))
{
defaultCurrentLanguage = "EN";
}
var query = _lookup_cruiseMasterAmenitiesRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.DisplayName.ToString().Contains(input.Filter)
).Where(x => x.ParentId == input.Parentid && x.Lang.ToUpper() == defaultCurrentLanguage.ToUpper());
var totalCount = await query.CountAsync();
var cruiseMasterAmenitiesList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ClientsCruiseMasterAmenitiesLookupTableDto>();
foreach (var cruiseMasterAmenities in cruiseMasterAmenitiesList)
{
lookupTableDtoList.Add(new ClientsCruiseMasterAmenitiesLookupTableDto
{
Id = cruiseMasterAmenities.Id,
DisplayName = cruiseMasterAmenities.DisplayName?.ToString()
});
}
return(new PagedResultDto <ClientsCruiseMasterAmenitiesLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <EmployeeVacationLeaveTypeLookupTableDto> > GetAllLeaveTypeForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_leaveTypeRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.NameAr.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var leaveTypeList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <EmployeeVacationLeaveTypeLookupTableDto>();
foreach (var leaveType in leaveTypeList)
{
lookupTableDtoList.Add(new EmployeeVacationLeaveTypeLookupTableDto
{
Id = leaveType.Id,
DisplayName = leaveType.NameAr?.ToString()
});
}
return(new PagedResultDto <EmployeeVacationLeaveTypeLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <FlightJetLookupTableDto> > GetAllJetForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_jetRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.JetType != null && e.JetType.Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var jetList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <FlightJetLookupTableDto>();
foreach (var jet in jetList)
{
lookupTableDtoList.Add(new FlightJetLookupTableDto
{
Id = jet.Id,
DisplayName = jet.JetType?.ToString()
});
}
return(new PagedResultDto <FlightJetLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <FlightCityLookupTableDto> > GetAllCityForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_cityRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Name != null && e.Name.Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var cityList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <FlightCityLookupTableDto>();
foreach (var city in cityList)
{
lookupTableDtoList.Add(new FlightCityLookupTableDto
{
Id = city.Id,
Code = city.Code,
DisplayName = city.Name?.ToString()
});
}
return(new PagedResultDto <FlightCityLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <PbLinkProPbEbookLookupTableDto> > GetAllPbEbookForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_pbEbookRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.EbookName.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var pbEbookList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <PbLinkProPbEbookLookupTableDto>();
foreach (var pbEbook in pbEbookList)
{
lookupTableDtoList.Add(new PbLinkProPbEbookLookupTableDto
{
Id = pbEbook.Id,
DisplayName = pbEbook.EbookName?.ToString()
});
}
return(new PagedResultDto <PbLinkProPbEbookLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <EmployeeVacationUserLookupTableDto> > GetAllUserForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_userRepository.GetAll()
.WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Name.Contains(input.Filter) || e.FingerCode.Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var userList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <EmployeeVacationUserLookupTableDto>();
foreach (var user in userList)
{
lookupTableDtoList.Add(new EmployeeVacationUserLookupTableDto
{
Id = user.Id,
DisplayName = user.Name?.ToString(),
FingerCode = user.FingerCode
});
}
return(new PagedResultDto <EmployeeVacationUserLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <LocationCredentialLocationLookupTableDto> > GetAllLocationForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_locationRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.TitleAr.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var locationList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <LocationCredentialLocationLookupTableDto>();
foreach (var location in locationList)
{
lookupTableDtoList.Add(new LocationCredentialLocationLookupTableDto
{
Id = location.Id,
DisplayName = location.TitleAr?.ToString()
});
}
return(new PagedResultDto <LocationCredentialLocationLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ApprovalTeamLookupTableDto> > GetAllTeamForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_teamRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => (e.Name != null ? e.Name.ToString() : "").Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var teamList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ApprovalTeamLookupTableDto>();
foreach (var team in teamList)
{
lookupTableDtoList.Add(new ApprovalTeamLookupTableDto
{
Id = team.Id,
DisplayName = team.Name?.ToString()
});
}
return(new PagedResultDto <ApprovalTeamLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <DocumentServiceLookupTableDto> > GetAllServiceForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_serviceRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Name.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var serviceList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <DocumentServiceLookupTableDto>();
foreach (var service in serviceList)
{
lookupTableDtoList.Add(new DocumentServiceLookupTableDto
{
Id = service.Id,
DisplayName = service.Name?.ToString()
});
}
return(new PagedResultDto <DocumentServiceLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <CustomerCurrencyLookupTableDto> > GetAllCurrencyForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_currencyRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Code.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var currencyList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <CustomerCurrencyLookupTableDto>();
foreach (var currency in currencyList)
{
lookupTableDtoList.Add(new CustomerCurrencyLookupTableDto
{
Id = currency.Id,
DisplayName = currency.Code?.ToString()
});
}
return(new PagedResultDto <CustomerCurrencyLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <TransactionLogTransactionLookupTableDto> > GetAllTransactionForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_transactionRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Transaction_Date.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var transactionList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <TransactionLogTransactionLookupTableDto>();
foreach (var transaction in transactionList)
{
lookupTableDtoList.Add(new TransactionLogTransactionLookupTableDto
{
Id = transaction.Id,
});
}
return(new PagedResultDto <TransactionLogTransactionLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <OrderedProductQuotationItemLookupTableDto> > GetAllQuotationItemForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_quotationItemRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Description.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var quotationItemList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <OrderedProductQuotationItemLookupTableDto>();
foreach (var quotationItem in quotationItemList)
{
lookupTableDtoList.Add(new OrderedProductQuotationItemLookupTableDto
{
Id = quotationItem.Id,
DisplayName = quotationItem.Description?.ToString()
});
}
return(new PagedResultDto <OrderedProductQuotationItemLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <UomLookupTableDto> > GetAllUomForLookupTable(GetAllForLookupTableInput input)
{
//using (_unitOfWorkManager.Current.DisableFilter(AbpDataFilters.MustHaveTenant, AbpDataFilters.MayHaveTenant)) // BYPASS TENANT FILTER to include Users
//{
//var tenantInfo = await TenantManager.GetTenantInfo();
//var crossTenantPermissions = await TenantManager.GetCrossTenantPermissions(tenantInfo, "Uom");
var query = _uomRepository
.GetAll()
//.WhereIf(tenantInfo.Tenant.Id != 0 && crossTenantPermissions != null, e => crossTenantPermissions.Contains((int)e.TenantId)) // CROSS TENANT AUTH
.WhereIf(!string.IsNullOrWhiteSpace(input.Filter), e => e.UnitOfMeasurement.Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var uomList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <UomLookupTableDto>();
foreach (var uom in uomList)
{
lookupTableDtoList.Add(new UomLookupTableDto
{
Id = uom.Id,
DisplayName = uom.UnitOfMeasurement?.ToString()
});
}
return(new PagedResultDto <UomLookupTableDto>(
totalCount,
lookupTableDtoList
));
//}
}
public async Task <PagedResultDto <ProjectInstructionProjectLookupTableDto> > GetAllProjectForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_projectRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => (e.Name != null ? e.Name.ToString():"").Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var projectList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ProjectInstructionProjectLookupTableDto>();
foreach (var project in projectList)
{
lookupTableDtoList.Add(new ProjectInstructionProjectLookupTableDto
{
Id = project.Id,
DisplayName = project.Name?.ToString()
});
}
return(new PagedResultDto <ProjectInstructionProjectLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ClientsLookupTableDto> > GetAllClientsForLookupTable(GetAllForLookupTableInput input)
{
string defaultLanguage = "en";
string currentLang = await SettingManager.GetSettingValueForUserAsync(AppSettings.DefaultCurrentLanguage, AbpSession.ToUserIdentifier());
if (!string.IsNullOrWhiteSpace(currentLang))
{
defaultLanguage = currentLang;
}
var query = _clientsRepository.GetAll().Join(_countrysRepository.GetAll(), cu => cu.ClientCountry,
p => p.country_alpha2_code, (cu, p) => new { cu, p })
.WhereIf(!string.IsNullOrWhiteSpace(input.Filter),
e => e.cu.ClientFirstName.ToString().Contains(input.Filter) ||
e.cu.ClientLastName.ToString().Contains(input.Filter) || e.cu.ClientEmail.ToString().Contains(input.Filter) ||
e.p.country_name.ToString().Contains(input.Filter) ||
(e.cu.ClientFirstName.ToString() + " " + e.cu.ClientLastName.ToString()).Contains(input.Filter)
).Where(x => x.p.lang.ToUpper() == defaultLanguage.ToUpper())
.Select(x => new ClientsDetails
{
ClientEmail = x.cu.ClientEmail,
CountryName = x.p.country_name,
ClientName = x.cu.ClientFirstName + " " + x.cu.ClientLastName,
DOB = x.cu.ClientDOB,
Age = DateTime.Now.Year - x.cu.ClientDOB.Year,
Id = x.cu.Id,
});
query = query.Where(x => x.Age > 18);
var totalCount = await query.CountAsync();
var clientList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ClientsLookupTableDto>();
foreach (var client in clientList)
{
lookupTableDtoList.Add(new ClientsLookupTableDto
{
Id = client.Id,
DisplayName = client.ClientName,
Email = client.ClientEmail,
Country = client.CountryName
});
}
return(new PagedResultDto <ClientsLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <Organizations.Dtos.LocationLookupTableDto> > GetAllLocationForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_locationRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.LocationName.Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var locationList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <Organizations.Dtos.LocationLookupTableDto>();
foreach (var loc in locationList)
{
lookupTableDtoList.Add(new Organizations.Dtos.LocationLookupTableDto
{
Id = loc.Id,
DisplayName = loc.LocationName
});
}
return(new PagedResultDto <Organizations.Dtos.LocationLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <MachineOrganizationUnitLookupTableDto> > GetAllOrganizationUnitForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_organizationUnitRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.DisplayName.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var organizationUnitList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <MachineOrganizationUnitLookupTableDto>();
foreach (var organizationUnit in organizationUnitList)
{
lookupTableDtoList.Add(new MachineOrganizationUnitLookupTableDto
{
Id = organizationUnit.Id,
DisplayName = organizationUnit.DisplayName?.ToString()
});
}
return(new PagedResultDto <MachineOrganizationUnitLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <TeamReferenceTypeLookupTableDto> > GetAllReferenceTypeForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_referenceTypeRepository.GetAll()
.WhereIf(!string.IsNullOrWhiteSpace(input.Filter), e => (e.Name != null ? e.Name.ToString() : "").Contains(input.Filter))
.WhereIf(!string.IsNullOrWhiteSpace(input.ReferenceTypeGroupFilter), e => e.ReferenceTypeGroup == input.ReferenceTypeGroupFilter);
var totalCount = await query.CountAsync();
var referenceTypeList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <TeamReferenceTypeLookupTableDto>();
foreach (var referenceType in referenceTypeList)
{
lookupTableDtoList.Add(new TeamReferenceTypeLookupTableDto
{
Id = referenceType.Id,
DisplayName = referenceType.Name?.ToString()
});
}
return(new PagedResultDto <TeamReferenceTypeLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ContactAssetOwnerLookupTableDto> > GetAllAssetOwnerForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_assetOwnerRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Name.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var assetOwnerList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ContactAssetOwnerLookupTableDto>();
foreach (var assetOwner in assetOwnerList)
{
lookupTableDtoList.Add(new ContactAssetOwnerLookupTableDto
{
Id = assetOwner.Id,
DisplayName = assetOwner.Name?.ToString()
});
}
return(new PagedResultDto <ContactAssetOwnerLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <AgePoliciesCruiseMasterAmenitiesLookupTableDto> > GetAllCruiseMasterAmenitiesForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_cruiseMasterAmenitiesRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.DisplayName.ToString().Contains(input.Filter)
).Where(x => x.ParentId == 67);
var totalCount = await query.CountAsync();
var cruiseMasterAmenitiesList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <AgePoliciesCruiseMasterAmenitiesLookupTableDto>();
foreach (var cruiseMasterAmenities in cruiseMasterAmenitiesList)
{
lookupTableDtoList.Add(new AgePoliciesCruiseMasterAmenitiesLookupTableDto
{
Id = cruiseMasterAmenities.Id,
DisplayName = cruiseMasterAmenities.DisplayName?.ToString()
});
}
return(new PagedResultDto <AgePoliciesCruiseMasterAmenitiesLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ManualTransactionMachineLookupTableDto> > GetAllMachineForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_machineRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.NameEn.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var machineList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ManualTransactionMachineLookupTableDto>();
foreach (var machine in machineList)
{
lookupTableDtoList.Add(new ManualTransactionMachineLookupTableDto
{
Id = machine.Id,
DisplayName = machine.NameEn?.ToString()
});
}
return(new PagedResultDto <ManualTransactionMachineLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <WorkOrderUpdateWorkOrderActionLookupTableDto> > GetAllWorkOrderActionForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_workOrderActionRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Action.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var workOrderActionList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <WorkOrderUpdateWorkOrderActionLookupTableDto>();
foreach (var workOrderAction in workOrderActionList)
{
lookupTableDtoList.Add(new WorkOrderUpdateWorkOrderActionLookupTableDto
{
Id = workOrderAction.Id,
DisplayName = workOrderAction.Action?.ToString()
});
}
return(new PagedResultDto <WorkOrderUpdateWorkOrderActionLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <ClientUnitPriceProductCategoryLookupTableDto> > GetAllProductCategoryForLookupTable(GetAllForLookupTableInput input)
{
var query = _lookup_productCategoryRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.Material.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var productCategoryList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <ClientUnitPriceProductCategoryLookupTableDto>();
foreach (var productCategory in productCategoryList)
{
lookupTableDtoList.Add(new ClientUnitPriceProductCategoryLookupTableDto
{
Id = productCategory.Id,
DisplayName = productCategory.Material?.ToString()
});
}
return(new PagedResultDto <ClientUnitPriceProductCategoryLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
public async Task <PagedResultDto <DepartamentoLookupTableDto> > GetAllDepartamentoForLookupTable(GetAllForLookupTableInput input)
{
var query = _departamentoRepository.GetAll().WhereIf(
!string.IsNullOrWhiteSpace(input.Filter),
e => e.NOMBRE_DEPARTAMENTO.ToString().Contains(input.Filter)
);
var totalCount = await query.CountAsync();
var departamentoList = await query
.PageBy(input)
.ToListAsync();
var lookupTableDtoList = new List <DepartamentoLookupTableDto>();
foreach (var departamento in departamentoList)
{
lookupTableDtoList.Add(new DepartamentoLookupTableDto
{
Id = departamento.Id,
DisplayName = departamento.NOMBRE_DEPARTAMENTO?.ToString()
});
}
return(new PagedResultDto <DepartamentoLookupTableDto>(
totalCount,
lookupTableDtoList
));
}
