예제 #1
0
        public String GetJSONPosts()
        {
            String sql = "SELECT TOP 3 * FROM appadmin.Blogs ORDER BY CreatedOn DESC";

            List <Blog> blogs = SqlFuDAL.FindObjectsByType <Blog>(sql);

            List <Tag>     tags    = new List <Tag>();
            PostCollection postCol = new PostCollection();

            sql = @"SELECT t.TagName, t.TagURL
FROM appadmin.Tags t
INNER JOIN appadmin.BlogTags bt ON t.ID = bt.TagID
WHERE bt.BlogID = {0}";

            foreach (Blog blog in blogs)
            {
                String query = String.Format(sql, blog.ID);
                //Build Post:
                tags      = SqlFuDAL.FindObjectsByType <Tag>(query);
                blog.Tags = tags;
                //massage CreatedOn property to contain just date part
                blog.CreatedOnDate = blog.CreatedOn.ToShortDateString();
                postCol.Posts.Add(blog);
            }

            String     json     = JsonConvert.SerializeObject(postCol);
            JsonResult jsonData = new JsonResult {
                Data = JsonConvert.DeserializeObject(json)
            };

            return(jsonData.Data.ToString());
        }
예제 #2
0
        public String GetJSONWorkshop(String labName)
        {
            Workshop   workshop = SqlFuDAL.FindWorkshopByLabName(labName);
            String     json     = JsonConvert.SerializeObject(workshop);
            JsonResult jsonData = new JsonResult {
                Data = JsonConvert.DeserializeObject(json)
            };

            return(jsonData.Data.ToString());
        }
예제 #3
0
 public static void InitializeDatabase()
 {
     SqlFuDAL.CreateTable <Participant>();
     SqlFuDAL.CreateTable <Article>();
     SqlFuDAL.CreateTable <Blog>();
     SqlFuDAL.CreateTable <Tag>();
     SqlFuDAL.CreateBlogTagsLinkerTable();
     SqlFuDAL.CreateTable <Conference>();
     SqlFuDAL.CreateTable <Cooperator>();
 }
예제 #4
0
        public String GetJSONCooperators(String type)
        {
            List <Cooperator>    cooperators   = SqlFuDAL.FindCooperatorsByType(type);
            CooperatorCollection cooperatorCol = new CooperatorCollection();

            cooperatorCol.Cooperators = cooperators;

            String     json     = JsonConvert.SerializeObject(cooperatorCol);
            JsonResult jsonData = new JsonResult {
                Data = JsonConvert.DeserializeObject(json)
            };

            return(jsonData.Data.ToString());
        }
예제 #5
0
        public String GetJSONConferences()
        {
            List <Conference>    conferences   = SqlFuDAL.FindObjectsByType <Conference>();
            ConferenceCollection conferenceCol = new ConferenceCollection();

            conferenceCol.Conferences = conferences;

            String     json     = JsonConvert.SerializeObject(conferenceCol);
            JsonResult jsonData = new JsonResult {
                Data = JsonConvert.DeserializeObject(json)
            };

            return(jsonData.Data.ToString());
        }
예제 #6
0
        /// <summary>
        /// Returns all articles found in database.
        /// </summary>
        /// <returns></returns>
        public String GetJSONArticles()
        {
            List <Article>    articles   = SqlFuDAL.FindObjectsByType <Article>();
            ArticleCollection articleCol = new ArticleCollection();

            articleCol.Articles = articles;

            String     json     = JsonConvert.SerializeObject(articleCol);
            JsonResult jsonData = new JsonResult {
                Data = JsonConvert.DeserializeObject(json)
            };

            return(jsonData.Data.ToString());
        }
예제 #7
0
        public String GetJSONArticle(int id)
        {
            Article article = SqlFuDAL.FindArticleById(id);

            ArticleCollection articleCol = new ArticleCollection();

            articleCol.Articles = new List <Article>()
            {
                article
            };

            String     json     = JsonConvert.SerializeObject(articleCol);
            JsonResult jsonData = new JsonResult {
                Data = JsonConvert.DeserializeObject(json)
            };

            return(jsonData.Data.ToString());
        }
예제 #8
0
        public String GetJSONParticipants()
        {
            //build json object to populate Participants view:
            //query Participants table to retrieve needed info
            List <Participant> participants = SqlFuDAL.FindObjectsByType <Participant>();

            //perform any needed translation into JSON friendly object here:
            ParticipantCollection participantCol = new ParticipantCollection();

            participantCol.Participants = participants.Where(p => p.IsActive).ToList();
            String json = JsonConvert.SerializeObject(participantCol);

            JsonResult jsonData = new JsonResult {
                Data = JsonConvert.DeserializeObject(json)
            };

            //return JSON object back to the view
            return(jsonData.Data.ToString());
        }
예제 #9
0
        public ActionResult Article(int id)
        {
            Article article = SqlFuDAL.FindArticleById(id);

            return(View(article));
        }
예제 #10
0
        public ActionResult Articles()
        {
            List <Article> articles = SqlFuDAL.FindObjectsByType <Article>();

            return(View(articles));
        }