public Sponsor GetSponsor(int id)
{
using (var context = new JobbiesContext(_connectionString))
{
return context.Sponsors.FirstOrDefault(c => c.Id == id);
}
}
public Listing GetListing(int id)
{
using (var context = new JobbiesContext(_connectionString))
{
return(context.Listings.FirstOrDefault(c => c.Id == id));
}
}
public Listing GetListing(int id)
{
using (var context = new JobbiesContext(_connectionString))
{
return context.Listings.FirstOrDefault(c => c.Id == id);
}
}
public Sponsor GetSponsor(int id)
{
using (var context = new JobbiesContext(_connectionString))
{
return(context.Sponsors.FirstOrDefault(c => c.Id == id));
}
}
public List<Listing> GetListings()
{
var results = new List<Listing>();
using (JobbiesContext context = new JobbiesContext(_connectionString))
{
results = context.GetTable<Listing>().ToList();
}
return results;
}
public List <Listing> GetListings()
{
var results = new List <Listing>();
using (JobbiesContext context = new JobbiesContext(_connectionString))
{
results = context.GetTable <Listing>().ToList();
}
return(results);
}
public Applicant Add(Applicant applicant)
{
using (var context = new JobbiesContext(_connectionString))
{
context.Applicants.InsertOnSubmit(applicant);
context.SubmitChanges();
}
//TODO: return updated applicant with ID
return applicant;
}
public Applicant Add(Applicant applicant)
{
using (var context = new JobbiesContext(_connectionString))
{
context.Applicants.InsertOnSubmit(applicant);
context.SubmitChanges();
}
//TODO: return updated applicant with ID
return(applicant);
}
public List <Listing> GetListings(int sponsorId)
{
var results = new List <Listing>();
using (JobbiesContext context = new JobbiesContext(_connectionString))
{
var things =
from sponsors in context.Sponsors
join listings in context.Listings
on sponsors.Id equals listings.SponsorId
select listings;
results = things.ToList();
}
return(results);
}
public List<Listing> GetListings(int sponsorId)
{
var results = new List<Listing>();
using (JobbiesContext context = new JobbiesContext(_connectionString))
{
var things =
from sponsors in context.Sponsors
join listings in context.Listings
on sponsors.Id equals listings.SponsorId
select listings;
results = things.ToList();
}
return results;
}
