public Ad FindAd(int?id) { using (var context = new AdExpressDBContext()) { return(context.Ads.SingleOrDefault(ad => ad.ID == id)); } }
public Newspaper FindNewspaper(int?id) { using (var context = new AdExpressDBContext()) { return(context.Newspapers.SingleOrDefault(n => n.ID == id)); } }
public Association FindAssociation(int?id) { using (var context = new AdExpressDBContext()) { return(context.Associations.SingleOrDefault(ad => ad.ID == id)); } }
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[] GetAllAssociations() { var assoications = new List <Association>(); using (var context = new AdExpressDBContext()) { var query = ( from a in context.Associations join b in context.Newspapers on a.NewspaperId equals b.ID join c in context.Ads on a.AdId equals c.ID orderby a.StartDateTime select new { ID = a.ID, AdId = a.AdId, NewspaperId = a.NewspaperId, EndDateTime = a.EndDateTime, StartDateTime = a.StartDateTime, Newspaper = b, Ad = c }).ToArray(); foreach (var VARIABLE in query) { assoications.Add(new Association { ID = VARIABLE.ID, Ad = VARIABLE.Ad, EndDateTime = VARIABLE.EndDateTime, AdId = VARIABLE.AdId, Newspaper = VARIABLE.Newspaper, NewspaperId = VARIABLE.NewspaperId, StartDateTime = VARIABLE.StartDateTime }); } return(assoications.ToArray()); } }
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); } }
public AddExpressWcfService(AdExpressDBContext adExpressDbContext) { _context = adExpressDbContext; }