public List <Advert> GetAllByUserId(int userId) { using (var context = new AdvertsEntities()) { return(context.Adverts.Where(x => x.UserId == userId).ToList()); } }
public List <Advert> GetAll() { using (var context = new AdvertsEntities()) { return(context.Adverts.ToList()); } }
public User FindByEmail(string email) { using (var context = new AdvertsEntities()) { var item = context.Users.FirstOrDefault(s => s.Email == email); return(item); } }
public Advert Add(Advert advert) { using (var context = new AdvertsEntities()) { context.Adverts.Add(advert); context.SaveChanges(); } return(GetById(advert.Id)); }
public User Add(User user) { using (var context = new AdvertsEntities()) { context.Users.Add(user); context.SaveChanges(); } return(GetById(user.Id)); }
public Advert GetById(int advertId) { using (var context = new AdvertsEntities()) { var item = context.Adverts.Where(s => s.Id == advertId).FirstOrDefault(); if (item == null) { throw new NullReferenceException($"Advert {advertId} not found"); } return(item); } }
public User GetById(int userId) { using (var context = new AdvertsEntities()) { var item = context.Users.FirstOrDefault(s => s.Id == userId); if (item == null) { throw new NullReferenceException($"User {userId} not found"); } return(item); } }
public List <User> FindByEmail(string email) { using (var context = new AdvertsEntities()) { var item = context.Users.Where(s => s.Email == email).ToList(); if (item == null) { throw new NullReferenceException($"User {email} not found"); } return(item); } }
public void Delete(int advertId) { using (var context = new AdvertsEntities()) { var item = context.Adverts.FirstOrDefault(s => s.Id == advertId); if (item == null) { throw new NullReferenceException($"Advert {advertId} not found"); } context.Adverts.Remove(item); context.SaveChanges(); } }
public Advert Update(Advert advert) { using (var context = new AdvertsEntities()) { var item = context.Adverts.Where(s => s.Id == advert.Id).FirstOrDefault(); if (item == null) { throw new NullReferenceException($"Advert {advert.Id} not found"); } context.Entry(item).CurrentValues.SetValues(advert); context.SaveChanges(); } return(advert); }
public User Update(User user) { using (var context = new AdvertsEntities()) { var item = context.Users.FirstOrDefault(s => s.Id == user.Id); if (item == null) { throw new NullReferenceException($"User {user.Id} not found"); } context.Entry(item).CurrentValues.SetValues(user); context.SaveChanges(); } return(user); }
public void Delete(int advertId) { var item = GetById(advertId); if (item == null) { throw new NullReferenceException($"Advert {advertId} not found"); } using (var context = new AdvertsEntities()) { context.Adverts.Remove(item); context.SaveChanges(); } }
public User Update(User user) { var item = GetById(user.Id); if (item == null) { throw new NullReferenceException($"User {user.Id} not found"); } using (var context = new AdvertsEntities()) { context.Entry(item).CurrentValues.SetValues(user); } return(user); }