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());
}
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());
}
public static void InitializeDatabase()
{
SqlFuDAL.CreateTable <Participant>();
SqlFuDAL.CreateTable <Article>();
SqlFuDAL.CreateTable <Blog>();
SqlFuDAL.CreateTable <Tag>();
SqlFuDAL.CreateBlogTagsLinkerTable();
SqlFuDAL.CreateTable <Conference>();
SqlFuDAL.CreateTable <Cooperator>();
}
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());
}
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());
}
/// <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());
}
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());
}
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());
}
public ActionResult Article(int id)
{
Article article = SqlFuDAL.FindArticleById(id);
return(View(article));
}
public ActionResult Articles()
{
List <Article> articles = SqlFuDAL.FindObjectsByType <Article>();
return(View(articles));
}
