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;
}
