// 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) { }