public async Task <ActionResult <List <Advertisement> > > Get([FromQuery] JobsParameter jobsParameter)
{
if (jobsParameter.advertisementTitle == null && jobsParameter.JobType == null && jobsParameter.Location == null)
{
var jobs = await _advertisementService.GetAdvertisemetsAsync();
return(Ok(jobs));
}
else
{
AdvertisementContext _context = new AdvertisementContext();
// var jobs = await _context.Advertisements.Where(c => c.JobType.ToLower() == jobsParameter.JobType.ToLower()
//&& c.AdvertisementTitle.ToLower() == jobsParameter.JobTitle.ToLower() && c.Location == jobsParameter.Location).ToListAsync();
var result = _context.Advertisements.AsQueryable();
if (jobsParameter != null)
{
if (!string.IsNullOrEmpty(jobsParameter.Location))
{
result = result.Where(x => x.Location.ToLower() == jobsParameter.Location.ToLower());
}
if (!string.IsNullOrEmpty(jobsParameter.JobType))
{
result = result.Where(x => x.JobType.ToLower() == jobsParameter.JobType.ToLower());
}
if (!string.IsNullOrEmpty(jobsParameter.advertisementTitle))
{
result = result.Where(x => x.AdvertisementTitle.ToLower().Contains(jobsParameter.advertisementTitle.ToLower()));
}
}
return(Ok(await result.ToListAsync()));
}
}
public UserService(AdvertisementContext context, IConfiguration configuration
, IDividingService dividingService, IBannerService bannerService)
{
_configuration = configuration;
_context = context;
_dividingDividingService = dividingService;
_bannerService = bannerService;
}
public AdvertisementRepository(AdvertisementContext context)
{
_context = context;
}
public DividingService(AdvertisementContext context)
{
_context = context;
}
public ProfileController(UserManager <User> userManager, SignInManager <User> signInManager, AdvertisementContext adb)
{
_userManager = userManager;
_signInManager = signInManager;
_adb = adb;
}
public ShopController(AdvertisementContext adb, UserManager <User> userManager)
{
_adb = adb;
_userManager = userManager;
}
public ProfitAdvController(AdvertisementContext context)
{
_context = context;
}
public AboutMeServiceImpl(UserContext consumerContext, AdvertisementContext advertisementContext)
{
_consumerContext = consumerContext;
_advertisementContext = advertisementContext;
}
public UserController(AdvertisementContext context)
{
_context = context;
}
public AdvMarkController(AdvertisementContext context)
{
_context = context;
}
public AdvertisementService(AdvertisementContext context) : base(context)
{
}
public AccountController(AdvertisementContext context)
{
_context = context;
}