public IEnumerable <City> GetCityByCountry(int id)
{
using (var ctx = new BabySitterContext())
{
return(ctx.City.Where(p => p.CountryId == id).ToList());
}
}
public PersonalInformation GetByResume(Resume resume)
{
using (var ctx = new BabySitterContext())
{
return(ctx.PersonelInformation.SingleOrDefault(p => p.ResumeId == resume.Id));
}
}
public IEnumerable <Country> GetAll()
{
using (var ctx = new BabySitterContext())
{
return(ctx.Country.ToList());
}
}
public void Delete(PersonalInformation personalInformation)
{
using (var ctx = new BabySitterContext())
{
ctx.PersonelInformation.Remove(personalInformation);
ctx.SaveChanges();
}
}
public void Delete(ContactInformation contactInformation)
{
using (var ctx = new BabySitterContext())
{
ctx.ContactInformation.Remove(contactInformation);
ctx.SaveChanges();
}
}
public void Update(PersonalInformation personalInformation)
{
using (var ctx = new BabySitterContext())
{
var entry = ctx.Entry(personalInformation);
entry.State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
public PersonalInformation Add(PersonalInformation personalInformation)
{
using (var ctx = new BabySitterContext())
{
var entry = ctx.PersonelInformation.Add(personalInformation);
ctx.SaveChanges();
return(entry);
}
}
public ContactInformation Add(ContactInformation contactInformation)
{
using (var ctx = new BabySitterContext())
{
var entry = ctx.ContactInformation.Add(contactInformation);
ctx.SaveChanges();
return(entry);
}
}