예제 #1
0
 public static void InsertOnSubmit(this DbSet<Article> source, Article article)
 {
     if (article.ArticleID == default(int))
     {
         // New entity
         source.Add(article);
     }
     else
     {
         // Existing entity
         source.Attach(article);
     }
 }
예제 #2
0
        public ActionResult CreateArticle(int? categoryId, string title, string summary, string body, string country, string state, string city, DateTime? releaseDate, DateTime? expireDate, bool? approved, bool? listed, bool? commentsEnabled, bool? onlyForMembers)
        {
            TheBeerHouseDataContext dc = new TheBeerHouseDataContext();
            var categories = dc.Categories.GetCategories();

            if (categoryId.HasValue
                && !String.IsNullOrEmpty(title)
                && !String.IsNullOrEmpty(body))
            {
                try
                {
                    Article article = new Article
                    {
                        CategoryID = categoryId.Value,
                        Title = title,
                        Path = title.ToUrlFormat(),
                        Abstract = summary,
                        Body = body,
                        Country = country,
                        State = state,
                        City = city,
                        ReleaseDate = releaseDate ?? DateTime.Today,
                        ExpireDate = expireDate,
                        Approved = approved ?? false,
                        Listed = listed ?? false,
                        CommentsEnabled = commentsEnabled ?? false,
                        OnlyForMembers = onlyForMembers ?? false,
                        AddedBy = User.Identity.Name,
                        AddedDate = DateTime.Now
                    };

                    dc.Articles.InsertOnSubmit(article);
                    dc.SubmitChanges();

                    TempData["SuccessMessage"] = "Your article has been posted.";
                    return RedirectToAction("ViewArticle", new { id = article.ArticleID, path = article.Path });
                }
                catch (Exception exc)
                {
                    TempData["ErrorMessage"] = exc.Message;
                }
            }

            ViewData["categoryId"] = new SelectList(categories, "CategoryID", "Title", categoryId);
            ViewData["title"] = title;
            ViewData["summary"] = summary;
            ViewData["body"] = body;
            ViewData["country"] = new SelectList(Iso3166CountryCodes.CountryDictonary, "Key", "Value", country ?? "US");
            ViewData["state"] = state;
            ViewData["city"] = city;
            ViewData["releaseDate"] = releaseDate;
            ViewData["expireDate"] = expireDate;
            ViewData["approved"] = approved;
            ViewData["listed"] = listed;
            ViewData["commentsEnabled"] = commentsEnabled;
            ViewData["onlyForMembers"] = onlyForMembers;

            ViewData["PageTitle"] = "Create Article";

            return View("CreateArticle");
        }
예제 #3
0
 public static void DeleteOnSubmit(this DbSet<Article> source, Article article)
 {
     source.Remove(article);
 }