public Ad AddAd(string title, string version) { using (_context ?? new AdExpressDBContext()) { var ad = _context.Ads.Add(new Ad { Title = title, Version = version }); _context.SaveChanges(); return(ad); } }
public Ad SaveAd(Ad ad) { using (var context = new AdExpressDBContext()) { context.Set <Ad>().AddOrUpdate(ad); context.SaveChanges(); return(ad); } }
public Association SaveAssociation(Association association) { using (var context = new AdExpressDBContext()) { context.Entry(association).State = EntityState.Modified; context.SaveChanges(); return(association); } }
public Newspaper SaveNewspaper(Newspaper newspaper) { using (var context = new AdExpressDBContext()) { context.Entry(newspaper).State = EntityState.Modified; context.SaveChanges(); return(newspaper); } }
public void RemoveAd(Ad ad) { using (var context = new AdExpressDBContext()) { var p = context.Ads.SingleOrDefault(x => x.ID == ad.ID); if (p == null) { return; } context.Set <Ad>().Remove(p); context.SaveChanges(); } }
public void RemoveAssociation(Association association) { using (var context = new AdExpressDBContext()) { var p = context.Associations.SingleOrDefault(x => x.ID == association.ID); if (p == null) { return; } context.Associations.Remove(p); context.SaveChanges(); } }
public void RemoveNewspaper(Newspaper newspaper) { using (var context = new AdExpressDBContext()) { var p = context.Newspapers.SingleOrDefault(x => x.ID == newspaper.ID); if (p == null) { return; } context.Newspapers.Remove(p); context.SaveChanges(); } }
public Association AddAssociation(DateTime startDateTime, DateTime endDateTime, int adID, int newspaperID) { using (var context = new AdExpressDBContext()) { var ad = FindAd(adID); var newspaper = FindNewspaper(newspaperID); if (ad == null || newspaper == null) { return(null); } var association = context.Associations.Add(new Association { AdId = adID, StartDateTime = startDateTime, EndDateTime = endDateTime, NewspaperId = newspaperID, Ad = ad, Newspaper = newspaper }); context.SaveChanges(); return(association); } }