// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, JobOffersDbContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
context.Database.Migrate();
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthorization();
app.UseSession();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
}
public void DeleteCompanyById(int idCompanyToDelete)
{
using var db = new JobOffersDbContext();
var company = db.Companies.FirstOrDefault(x => x.Id == idCompanyToDelete);
if (company != null)
{
db.Companies.Remove(company);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("Company doesn't exist");
}
}
public List <Company> GetAllCompanies()
{
using var db = new JobOffersDbContext();
var companies = db.Companies
.Include(x => x.JobOffers).ToList();
if (companies != null)
{
return(companies);
}
else
{
throw new KeyNotFoundException("Companies don't exist");
}
}
public List <JobOffer> GetAllJobOffers()
{
using var db = new JobOffersDbContext();
var jobOffers = db.JobOffers
.Include(x => x.Company).ToList();
if (jobOffers != null)
{
return(jobOffers);
}
else
{
throw new KeyNotFoundException("JobOffers don't exist");
}
}
public void DeleteJobOfferById(int idJobOfferToDelete)
{
using var db = new JobOffersDbContext();
var jobOffer = db.JobOffers.FirstOrDefault(x => x.Id == idJobOfferToDelete);
if (jobOffer != null)
{
db.JobOffers.Remove(jobOffer);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("JobOffers don't exist");
}
}
public Company GetCompany(int idCompany)
{
using var db = new JobOffersDbContext();
var company = db.Companies
.Include(x => x.JobOffers).ToList()
.FirstOrDefault(company => company.Id == idCompany);
if (company != null)
{
return(company);
}
else
{
throw new KeyNotFoundException("Company doesn't exist");
}
}
public JobOffer GetJobOffer(int idJobOffer)
{
using var db = new JobOffersDbContext();
var jobOffer = db.JobOffers
.Include(x => x.Company).ToList()
.FirstOrDefault(x => x.Id == idJobOffer);
if (jobOffer != null)
{
return(jobOffer);
}
else
{
throw new KeyNotFoundException("JobOffer doesn't exist");
}
}
public List <JobOffer> GetJobOffersOnPostal(string postal)
{
using var db = new JobOffersDbContext();
var testError = db.JobOffers.FirstOrDefault(x => x.Company.Postal == postal);
if (testError != null)
{
var listOfJobOffersOnPostal = db.JobOffers
.Include(x => x.Company).ToList()
.Where(x => x.Company.Postal == postal).ToList();
return(listOfJobOffersOnPostal);
}
else
{
throw new KeyNotFoundException("No JobOffers at the postal");
}
}
public List <JobOffer> GetLast3PostedJobOffers()
{
using var db = new JobOffersDbContext();
var highestIdJobOffer = db.JobOffers.Max(x => x.Id);
var testError = db.JobOffers.FirstOrDefault(x => x.Id == highestIdJobOffer);
if (testError != null)
{
var jobOffers = db.JobOffers
.Include(x => x.Company).ToList()
.OrderByDescending(x => x.CreatedAt).Take(3).ToList();
return(jobOffers);
}
else
{
throw new KeyNotFoundException("JobOffers don't exist or not enough");
}
}
public void UpdateJobOfferById(int idJobOfferToChange, JobOffer newJobOfferValues)
{
using var db = new JobOffersDbContext();
var jobOffer = db.JobOffers.FirstOrDefault(x => x.Id == idJobOfferToChange);
if (jobOffer != null)
{
jobOffer.Name = newJobOfferValues.Name;
jobOffer.CompanyId = newJobOfferValues.CompanyId;
jobOffer.CreatedAt = newJobOfferValues.CreatedAt;
db.JobOffers.Update(jobOffer);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("JobOffers don't exist");
}
}
public void UpdateCompanyById(int idCompanyToChange, Company newCompanyValues)
{
using var db = new JobOffersDbContext();
var company = db.Companies.FirstOrDefault(x => x.Id == idCompanyToChange);
if (company != null)
{
company.Name = newCompanyValues.Name;
company.Street = newCompanyValues.Street;
company.Postal = newCompanyValues.Postal;
company.Town = newCompanyValues.Town;
db.Companies.Update(company);
db.SaveChanges();
}
else
{
throw new KeyNotFoundException("Company doesn't exist");
}
}
protected BaseRepository(JobOffersDbContext context)
{
dbContext = context;
dbSet = context.Set <T>();
}
public UserApplicationsRepository(JobOffersDbContext context)
: base(context)
{
}
public void CreateCompany(Company newCompany)
{
using var db = new JobOffersDbContext();
db.Companies.Add(newCompany);
db.SaveChanges();
}
public void CreateJobOffer(JobOffer newJobOffer)
{
using var db = new JobOffersDbContext();
db.JobOffers.Add(newJobOffer);
db.SaveChanges();
}
public UsersRepository(JobOffersDbContext context)
: base(context)
{
}
