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