public void DeleteComment(int commentId) { var db = new TooksCmsDAL(); db.ArticleComments.Remove(db.ArticleComments.Single(c => c.ArticleCommentId == commentId)); db.SaveChanges(); }
public void DeleteRoute(int id) { var db = new TooksCmsDAL(); db.StaticRoutes.Remove(db.StaticRoutes.Single(r => r.Id == id)); db.SaveChanges(); }
public IBulletin InsertContent(IBulletin data) { var db = new TooksCmsDAL(); var b = db.Bulletins.SingleOrDefault(b_ => b_.BulletinId == data.BulletinId); b.BulletinContents.Add(BulletinContent.CreateBulletinContent(data)); db.SaveChanges(); return(b); }
public IPageVisit InsertPageVisit(IPageVisit data) { var db = new TooksCmsDAL(); var s = PageVisit.CreatePageVisit(data); db.PageVisits.Add(s); db.SaveChanges(); return(s); }
public ICategory InsertCategory(ICategory data) { var db = new TooksCmsDAL(); var c = Category.CreateCategory(data); db.Categories.Add(c); db.SaveChanges(); return(c); }
public IArticle InsertContent(IArticle data) { var db = new TooksCmsDAL(); var a = db.Articles.SingleOrDefault(a_ => a_.ArticleId == data.ArticleId); a.UpdateContent(data); db.SaveChanges(); return(a); }
public IWeddingGuest AddGuest(IWeddingGuest guest) { var db = new TooksCmsDAL(); var g = db.Guest1.Add(Guest1.CreatGuest(guest)); db.SaveChanges(); return(g); }
public void InsertEvent(IEventLog data) { var db = new TooksCmsDAL(); var e = EventLog.CreateEventLog(data); db.EventLogs.Add(e); db.SaveChanges(); }
public IFoodChoice AddFoodChoice(IFoodChoice choice) { var db = new TooksCmsDAL(); var f = db.FoodChoices.Add(FoodChoice.CreateFoodChoice(choice)); db.SaveChanges(); return(f); }
public void RemoveGadgetLink(IGadgetInfo data) { var db = new TooksCmsDAL(); var gl = db.Gadget2Role2AreaType.Single(gl_ => gl_.AreaType.AreaType1 == data.AreaType && gl_.GadgetId == data.GadgetId && gl_.Role.RoleName == data.RoleName); db.Gadget2Role2AreaType.Remove(gl); db.SaveChanges(); }
public IRating UpdateRating(IRating data) { var db = new TooksCmsDAL(); var r = db.Ratings.First(r_ => r_.RatingId == data.RatingId); r.Update(data); db.SaveChanges(); return(r); }
/// <summary> /// Inserts a new user into the DAL. /// </summary> /// <param name="data">DTO to create from</param> /// <returns>An User DAL object</returns> /// <exception cref="System.ArgumentException">Errors in data will result in an exception being thrown</exception> public IUser InsertUser(IUser data) { var db = new TooksCmsDAL(); var u = User.CreateUser(data); db.Users.Add(u); db.SaveChanges(); return(u); }
/// <summary> /// Inserts a new guest into the DAL. /// </summary> /// <param name="data">DTO to create from</param> /// <returns>An Guest DAL object</returns> /// <exception cref="System.ArgumentException">Errors in data will result in an exception being thrown</exception> public IGuest InsertGuest(IGuest data) { var db = new TooksCmsDAL(); var g = Guest.CreateGuest(data); db.Guests.Add(g); db.SaveChanges(); return(g); }
/// <summary> /// Inserts a new address into the DAL. /// </summary> /// <param name="data">DTO to create from</param> /// <returns>An Address DAL object</returns> /// <exception cref="System.ArgumentException">Errors in data will result in an exception being thrown</exception> public IAddress InsertAddress(IAddress data) { var db = new TooksCmsDAL(); var address = Address.CreateAddress(data); db.Addresses.Add(address); db.SaveChanges(); return(address); }
/// <summary> /// Inserts a new contact info into the DAL. /// </summary> /// <param name="data">DTO to create from</param> /// <returns>An ContactInfo DAL object</returns> /// <exception cref="System.ArgumentException">Errors in data will result in an exception being thrown</exception> public IContactInfo InsertContact(IContactInfo data) { var db = new TooksCmsDAL(); var contactInfo = ContactInfo.CreateContactInfo(data); db.ContactInfoes.Add(contactInfo); db.SaveChanges(); return(contactInfo); }
public void RemoveGalleryTagLink(ITag tag, int galleryId) { var db = new TooksCmsDAL(); var t = db.Tags.FirstOrDefault(t_ => t_.TagId == tag.TagId); if (t != null) { t.Galleries.Remove(db.Galleries.First(g => g.GalleryId == galleryId)); } db.SaveChanges(); }
public void RemoveArticleTagLink(ITag tag, int articleId) { var db = new TooksCmsDAL(); var t = db.Tags.FirstOrDefault(t_ => t_.TagId == tag.TagId); if (t != null) { t.Articles.Remove(db.Articles.First(a => a.ArticleId == articleId)); } db.SaveChanges(); }
public int Insert(IBulletin data) { var db = new TooksCmsDAL(); var b = Bulletin.CreateBulletin(data); db.Bulletins.Add(b); db.SaveChanges(); return(b.BulletinId); }
public IRating InsertRating(IRating data) { var db = new TooksCmsDAL(); var r = Rating.CreateRating(data); db.Ratings.Add(r); db.SaveChanges(); return(r); }
public IStaticRoute CreateRoute(IStaticRoute data) { var db = new TooksCmsDAL(); var r = StaticRoute.CreateStaticRoute(data); db.StaticRoutes.Add(r); db.SaveChanges(); return(r); }
public int Insert(IArticle data) { var db = new TooksCmsDAL(); var a = Article.CreateArticle(data); db.Articles.Add(a); db.SaveChanges(); return(a.ArticleId); }
/// <summary> /// Inserts a new email into the DAL. /// </summary> /// <param name="data">DTO to create from</param> /// <returns>An Email DAL object</returns> /// <exception cref="System.ArgumentException">Errors in data will result in an exception being thrown</exception> public IEmail InsertEmail(IEmail data) { var db = new TooksCmsDAL(); var e = Email.CreateEmail(data); db.Emails.Add(e); db.SaveChanges(); return(e); }
public IArticleComment InsertComment(IArticleComment data) { var db = new TooksCmsDAL(); var ac = ArticleComment.CreateArticleComment(data); db.ArticleComments.Add(ac); db.SaveChanges(); return(ac); }
public IWeddingGuest SaveGuest(IWeddingGuest guest) { var db = new TooksCmsDAL(); var g = db.Guest1.Single(_g => _g.GuestId == guest.GuestId); g.Update(guest); db.SaveChanges(); return(g); }
public IContactForm InsertContactForm(IContactForm data) { var db = new TooksCmsDAL(); var cf = ContactForm.CreateContactForm(data); db.ContactForms.Add(cf); db.SaveChanges(); return(cf); }
public IFoodChoice SaveFoodChoice(IFoodChoice choice) { var db = new TooksCmsDAL(); var fc = db.FoodChoices.Single(_fc => _fc.FoodChoiceId == choice.FoodChoiceId); fc.Update(choice); db.SaveChanges(); return(fc); }
public void Rsvp(IRsvp rsvp) { var db = new TooksCmsDAL(); var f = db.FoodChoices.Add(FoodChoice.CreateFoodChoice(rsvp.FoodChoice)); var g = db.Guest1.Single(_g => _g.GuestId == rsvp.GuestId); g.RSVP(rsvp); db.SaveChanges(); }
public void CreateRatingLink(IRatingLink link) { var db = new TooksCmsDAL(); db.DeleteRatingLinks(link.ArticleTypeId, link.CategoryId); foreach (var rating in link.RatingIds) { CreateRatingLink(db, rating.Value.RatingId, link.ArticleTypeId, link.CategoryId, rating.Key); } db.SaveChanges(); }
public IGalleryImage InsertGalleryImage(IGalleryImage data) { var db = new TooksCmsDAL(); var g = GalleryImage.CreateGalleryImage(data); db.GalleryImages.Add(g); db.SaveChanges(); return(g); }
public IGadgetInfo AddGadgetLink(int gadgetId, int areaType, int roleId) { var db = new TooksCmsDAL(); var gl = new Gadget2Role2AreaType { GadgetId = gadgetId, RoleId = roleId, AreaTypeId = areaType }; db.Gadget2Role2AreaType.Add(gl); db.SaveChanges(); return(db.GetGadgetInfo(roleId, gadgetId, areaType).First()); }