public void Delete(ProviderAward entity) { var data = (from proAwa in _context.ProviderAwards where proAwa.ProviderId == entity.ProviderId && proAwa.AwardId == entity.AwardId select proAwa).FirstOrDefault(); if (data != null) { _context.ProviderAwards.Remove(data); } else { throw new Exception("Award does not exist."); } }
public void AddProviderAward(ProviderAward entity) { var award = (from proAwa in _context.ProviderAwards join awa in _context.Awards on proAwa.AwardId equals awa.AwardId where proAwa.ProviderId == entity.ProviderId && awa.AwardId == entity.AwardId select proAwa).FirstOrDefault(); if (award == null) { _context.ProviderAwards.Add(entity); } else { throw new Exception("Award already added"); } }