public IList<Sponsor> GetSponsors(int eventId) { using (var db = new CC.Data.CCDB()) { var e = db.Events.Find(eventId); if (e == null) throw new ArgumentException("Event not found"); var result = new List<Sponsor>(); // results.Add(new Sponsor { ID = 1, Name = "Microsoft" }); // results.Add(new Sponsor { ID = 2, Name = "DevExpress" }); foreach (var s in e.Sponsors.OrderBy(sp => Guid.NewGuid())) { Sponsor sponsor = new Sponsor(); Mapper.CopyProperties(s, sponsor); result.Add(sponsor); } return result; } }
public Sponsor GetSponsor(int id) { using (var db = new CC.Data.CCDB()) { var sponsor = db.Sponsors.Find(id); Sponsor result = new Sponsor(); Mapper.CopyProperties(sponsor, result); return result; } }
public void UpdateSponsor(Sponsor sponsor) { using (var db = new CC.Data.CCDB()) { var s = db.Sponsors.Find(sponsor.ID); s.Name = sponsor.Name; s.Description = sponsor.Description; s.WebsiteUrl = sponsor.WebsiteUrl; s.SponsorshipLevel = sponsor.SponsorshipLevel; //s.ImageUrl = sponsor.ImageUrl; s.Image = sponsor.Image; db.SaveChanges(); } }
public void CreateSponsor(Sponsor sponsor) { using (var db = new CC.Data.CCDB()) { db.Sponsors.Add(sponsor.Map()); db.SaveChanges(); } }
public static Sponsor Map(this Data.Sponsor s) { Sponsor sponsor = new Sponsor { ID = s.ID, EventID = s.Event_ID, Name = s.Name, Description = s.Description, WebsiteUrl = s.WebsiteUrl, SponsorshipLevel = s.SponsorshipLevel, //ImageUrl = s.ImageUrl }; return sponsor; }