public ActionResult UpdateDatabase()
        {
            ResponseNewsAppModels jsonModel    = new ResponseNewsAppModels();
            List <DisplayArticle> articleList  = new List <DisplayArticle>();
            List <Category>       categoryList = db.Categories.ToList();

            foreach (var category in categoryList)
            {
                string jsonObject = jsonModel.TransportJsonNewsWithApp(category.name);
                IEnumerable <NewArticle> listArticle = JsonConvert.DeserializeObject <IEnumerable <NewArticle> >(jsonObject) as IEnumerable <NewArticle>;

                foreach (var article in listArticle)
                {
                    displayArticle = new DisplayArticle
                    {
                        author      = article.newAuthor,
                        title       = article.newTitle,
                        description = article.newDescription,
                        url         = article.newUrl,
                        urlToImage  = article.newUrlToImage,
                        publishetAt = article.newPublishetAt,
                        source      = article.newSource.newName,
                        idCateogry  = category.idCategory
                    };

                    articleList.Add(displayArticle);
                }
            }
            db.Articles.AddRange(articleList);
            db.SaveChanges();
            var message = "Zaktualizowano wszystkie artykuły ";

            return(RedirectToAction("ControlPanel", new { information = message }));
        }
예제 #2
0
        // GET: JsonOperation

        public ActionResult Index()
        {
            ResponseNewsAppModels jsonModel = new ResponseNewsAppModels();

            string a          = Request.QueryString["category"];
            string jsonObject = jsonModel.TransportJsonNewsWithApp(Request.QueryString["category"]);
            IEnumerable <NewArticle> listArticle = JsonConvert.DeserializeObject <IEnumerable <NewArticle> >(jsonObject) as IEnumerable <NewArticle>;

            return(View(listArticle));
        }
        public ActionResult ControlPanel()
        {
            string category = Request.QueryString["category"];
            ResponseNewsAppModels jsonModel = new ResponseNewsAppModels();
            int idCategory = selectCategory(category);

            if (selectCategory(category) != 0)
            {
                var searchCategoryName = from categories in db.Categories
                                         where categories.idCategory == idCategory
                                         select categories.name;

                db.Articles.RemoveRange(db.Articles.Where(x => x.idCateogry == idCategory));
                db.SaveChanges();

                string jsonObject = jsonModel.TransportJsonNewsWithApp(Request.QueryString["category"]);
                IEnumerable <NewArticle> listArticle = JsonConvert.DeserializeObject <IEnumerable <NewArticle> >(jsonObject) as IEnumerable <NewArticle>;

                foreach (var article in listArticle)
                {
                    displayArticle.author      = article.newAuthor;
                    displayArticle.title       = article.newTitle;
                    displayArticle.description = article.newDescription;
                    displayArticle.url         = article.newUrl;
                    displayArticle.urlToImage  = article.newUrlToImage;
                    displayArticle.publishetAt = article.newPublishetAt;
                    displayArticle.source      = article.newSource.newName;
                    displayArticle.idCateogry  = idCategory;

                    db.Articles.Add(displayArticle);
                    db.SaveChanges();
                    db.Database.Connection.Close();
                }
            }
            return(View(db.Articles.ToList()));
        }