public PostDO ViewPostById(int id)
{
SqlConnection connectionToSql = null;
SqlCommand storedProcedure = null;
SqlDataReader reader = null;
PostDO postDO = new PostDO();
try
{
connectionToSql = new SqlConnection(_connectionString);
storedProcedure = new SqlCommand("POST_VIEW_BY_POST_ID", connectionToSql);
storedProcedure.CommandType = System.Data.CommandType.StoredProcedure;
storedProcedure.Parameters.AddWithValue("@PostID", id);
connectionToSql.Open();
reader = storedProcedure.ExecuteReader();
while (reader.Read())
{
postDO.PostId = (int)reader["PostID"];
postDO.UserId = (int)reader["UserID"];
postDO.ThreadId = (int)reader["ThreadID"];
postDO.Title = reader["Title"] as string;
postDO.CreationDate = (DateTime)reader["CreationDate"];
postDO.EditDate = (DateTime)reader["EditDate"];
postDO.Content = reader["Content"] as string;
}
}
catch (Exception ex)
{
Logger.Log("Fatal", ex.TargetSite.ToString(), ex.Message, ex.StackTrace);
throw ex;
}
return(postDO);
}
public void UpdatePost(PostDO form)
{
SqlConnection connectionToSql = null;
SqlCommand storedProcedure = null;
try
{
connectionToSql = new SqlConnection(_connectionString);
storedProcedure = new SqlCommand("POST_UPDATE", connectionToSql);
storedProcedure.CommandType = System.Data.CommandType.StoredProcedure;
storedProcedure.Parameters.AddWithValue("@PostID", form.PostId);
storedProcedure.Parameters.AddWithValue("@ThreadID", form.ThreadId);
storedProcedure.Parameters.AddWithValue("@EditDate", DateTime.Now);
storedProcedure.Parameters.AddWithValue("@Title", form.Title);
storedProcedure.Parameters.AddWithValue("@Content", form.Content);
connectionToSql.Open();
storedProcedure.ExecuteNonQuery();
}
catch (Exception ex)
{
Logger.Log("Fatal", ex.TargetSite.ToString(), ex.Message, ex.StackTrace);
throw ex;
}
finally
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
public List <PostDO> ViewAllPosts()
{
SqlConnection connectionToSql = null;
SqlCommand storedProcedure = null;
SqlDataReader reader = null;
List <PostDO> postList = new List <PostDO>();
try
{
connectionToSql = new SqlConnection(_connectionString);
storedProcedure = new SqlCommand("POST_VIEW_ALL", connectionToSql);
storedProcedure.CommandType = System.Data.CommandType.StoredProcedure;
connectionToSql.Open();
reader = storedProcedure.ExecuteReader();
while (reader.Read())
{
PostDO postDO = new PostDO();
postDO.PostId = (int)reader["PostID"];
postDO.UserId = (int)reader["UserID"];
postDO.ThreadId = (int)reader["ThreadID"];
postDO.CreationDate = (DateTime)reader["CreationDate"];
if (postDO.EditDate == null)
{
postDO.EditDate = postDO.CreationDate;
}
else
{
postDO.EditDate = (DateTime)reader["EditDate"];
}
postDO.Title = reader["Title"] as string;
postDO.Content = reader["Content"] as string;
postList.Add(postDO);
}
}
catch (Exception ex)
{
Logger.Log("Fatal", ex.TargetSite.ToString(), ex.Message, ex.StackTrace);
throw ex;
}
finally
{
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
return(postList);
}
public static PostDO PostPOToDO(PostPO from)
{
PostDO to = new PostDO();
to.PostId = from.PostId;
to.UserId = from.UserId;
to.Username = from.Username;
to.ThreadId = from.ThreadId;
to.CreationDate = from.CreationDate;
to.EditDate = from.EditDate;
to.Title = from.Title;
to.Content = from.Content;
return(to);
}
public ActionResult UpdatePost(int postId)
{
ActionResult response = null;
try
{
PostDO dataObject = _dataAccess.ViewPostById(postId);
PostPO displayObject = PostMapper.PostDOToPO(dataObject);
response = View(displayObject);
}
catch (Exception ex)
{
Logger.Log("Fatal", ex.TargetSite.ToString(), ex.Message, ex.StackTrace);
}
return(response);
}
public ActionResult UpdatePost(PostPO form)
{
ActionResult response = null;
int userId = 0;
int userRole = 0;
if (Session["RoleID"] != null)
{
//get the role ID and user ID from session
int.TryParse(Session["UserID"].ToString(), out userId);
int.TryParse(Session["RoleID"].ToString(), out userRole);
}
if (userId == form.UserId || userRole == 1 || userRole == 2)
{
if (ModelState.IsValid)
{
try
{
PostDO dataObject = PostMapper.PostPOToDO(form);
_dataAccess.UpdatePost(dataObject);
response = RedirectToAction("ViewPostsByThreadId", "Post", new { ThreadId = form.ThreadId });
}
catch (Exception ex)
{
Logger.Log("Fatal", ex.TargetSite.ToString(), ex.Message, ex.StackTrace);
}
}
else
{
response = View();
}
}
else
{
response = View(form);
}
return(response);
}
public ActionResult CarregarFBAPI(string accessToken)
{
PostDAO dao = new PostDAO();
var facebookClient = new FacebookClient();
var facebookService = new FacebookService(facebookClient);
var account = facebookService.GetAccount(accessToken);
var posts = facebookService.GetPosts(accessToken);
List <PostViewModel> viewModelList = new List <PostViewModel>();
foreach (var post in posts)
{
PostDO postDO = new PostDO()
{
Id = post.Id,
Message = post.Message,
Description = post.Description,
PermalinkUrl = post.PermalinkUrl,
CreatedTime = DateTime.Parse(post.CreatedTime, cultInf)
};
dao.Salvar(postDO);
PostViewModel vm = new PostViewModel()
{
Id = postDO.Id,
Message = postDO.Message,
Description = postDO.Description,
PermalinkUrl = postDO.PermalinkUrl,
CreatedTime = postDO.CreatedTime.ToString(cultInf)
};
viewModelList.Add(vm);
}
return(View("Posts", viewModelList));
}
public ActionResult AddPost(PostPO form)
{
ActionResult response = null;
if (ModelState.IsValid)
{
try
{
PostDO dataObject = PostMapper.PostPOToDO(form);
_dataAccess.AddPost(dataObject);
response = RedirectToAction("ViewPostsByThreadId", "Post", new { ThreadId = form.ThreadId });
}
catch (Exception ex)
{
Logger.Log("Fatal", ex.TargetSite.ToString(), ex.Message, ex.StackTrace);
}
}
else
{
response = View(form);
}
return(response);
}
