public IActionResult Details(int id)
{
Blog blog = BlogService.GetBlogDetails(id);
BlogDetailsModel model = ModelConverter.ConvertToDetailsModel(blog);
model.SidebarData = BlogService.GetSidebarData();
if (User.Identity.IsAuthenticated)
{
BlogLikeModel blogLike = model.BlogLikes.FirstOrDefault(x => x.UserId == Convert.ToInt32(User.FindFirst("Id").Value));
if (blogLike != null)
{
if (blogLike.Status)
{
model.LikeStatus = BlogLikeStatus.Liked;
}
else
{
model.LikeStatus = BlogLikeStatus.Disliked;
}
}
}
return(View(model));
}
public IHttpActionResult GetAll()
{
BlogDetailsModel modelDetails = new BlogDetailsModel();
BlogListViewModel mainModel = new BlogListViewModel();
List <BlogDetailsModel> listOfModel = new List <BlogDetailsModel>();
DataTable dt = null;
db.openConnection("Connection.Database.Blog");
try
{
paramName = new string[] { };
paramValue = new string[] { };
dt = db.executePROC("spGetAllBlogNoFilterCRUD", paramName, paramValue);
for (int i = 0; i < dt.Rows.Count; i++)
{
modelDetails = new BlogDetailsModel();
modelDetails.id = Convert.ToInt32(dt.Rows[i]["ID_BLOG"].ToString());
modelDetails.userID = Convert.ToInt32(dt.Rows[i]["ID_MODERADOR"].ToString());
modelDetails.userName = dt.Rows[i]["NM_USUARIO"].ToString();
modelDetails.psnID = dt.Rows[i]["PSN_ID"].ToString();
modelDetails.title = dt.Rows[i]["DS_TITULO"].ToString();
modelDetails.registerDate = Convert.ToDateTime(dt.Rows[i]["DT_BLOG"].ToString());
modelDetails.registerDateFormatted = dt.Rows[i]["DT_BLOG_FORMATADA"].ToString();
modelDetails.registerTime = dt.Rows[i]["HR_BLOG"].ToString();
modelDetails.text = dt.Rows[i]["DS_TEXTO_BLOG"].ToString();
modelDetails.registerDateTimeFormatted = Convert.ToInt64(modelDetails.registerDate.ToString("yyyyMMdd") + modelDetails.registerTime.Replace(":", ""));
listOfModel.Add(modelDetails);
}
mainModel.listOfBlog = listOfModel;
mainModel.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel));
}
catch (Exception ex)
{
mainModel = new BlogListViewModel();
mainModel.listOfBlog = new List <BlogDetailsModel>();
mainModel.returnMessage = "errorGetAll_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel));
}
finally
{
db.closeConnection();
modelDetails = null;
mainModel = null;
listOfModel = null;
dt = null;
}
}
public static Blog ToModel(this BlogDetailsModel blog)
{
return(new Blog()
{
Title = blog.Title,
Author = blog.Author,
TravelDate = blog.TravelDate,
ImageURL = blog.ImageURL,
EntryDate = blog.EntryDate,
Text = blog.Text
});
}
public IHttpActionResult GetDetails(string id)
{
BlogDetailsModel modelDetails = new BlogDetailsModel();
BlogListViewModel mainModel = new BlogListViewModel();
List <BlogDetailsModel> listOfModel = new List <BlogDetailsModel>();
DataTable dt = null;
db.openConnection("Connection.Database.Blog");
try
{
string[] pkID = id.Split(Convert.ToChar("|"));
paramName = new string[] { "pIdUser", "pIdBlog" };
paramValue = new string[] { pkID[0], pkID[1] };
dt = db.executePROC("spGetBlog", paramName, paramValue);
if (dt.Rows.Count > 0)
{
modelDetails.id = Convert.ToInt32(dt.Rows[0]["ID_BLOG"].ToString());
modelDetails.userID = Convert.ToInt32(dt.Rows[0]["ID_MODERADOR"].ToString());
modelDetails.userName = dt.Rows[0]["NM_USUARIO"].ToString();
modelDetails.psnID = dt.Rows[0]["PSN_ID"].ToString();
modelDetails.title = dt.Rows[0]["DS_TITULO"].ToString();
modelDetails.registerDate = Convert.ToDateTime(dt.Rows[0]["DT_BLOG"].ToString());
modelDetails.registerDateFormatted = dt.Rows[0]["DT_BLOG_FORMATADA"].ToString();
modelDetails.registerTime = dt.Rows[0]["HR_BLOG"].ToString();
modelDetails.text = dt.Rows[0]["DS_TEXTO_BLOG"].ToString();
}
modelDetails.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, modelDetails));
}
catch (Exception ex)
{
mainModel = new BlogListViewModel();
mainModel.returnMessage = "errorGetBlogDetails_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, mainModel));
}
finally
{
db.closeConnection();
modelDetails = null;
mainModel = null;
listOfModel = null;
dt = null;
}
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BlogDetailsModel blog = context.Post.Where(i => i.ID == id && i.isValid).Select(i => new BlogDetailsModel
{
ID = i.ID,
Name = i.Name,
Image = i.Image,
Text = i.Text,
addedDate = i.AddedDate,
Comments = i.Comment.Where(k => k.isValid).Select(j => new BlogCommentModel
{
CommentID = j.ID,
Name = j.Name,
Text = j.Text,
Image = j.Image,
AddedDate = j.AddedDate,
CommentResponses = j.CommentResponse.Where(k => k.isValid).Select(k => new BlogCommentResponseModel
{
Name = k.Name,
Text = k.Text,
Image = k.Image,
AddedDate = k.AddedDate
}).ToList()
}).ToList(),
}).FirstOrDefault();
if (blog == null)
{
return(HttpNotFound());
}
ViewBag.Title = string.Format("{0} » {1}", title, blog.Name);
ViewBag.Value = blog.Name;
return(View(blog));
}
public IActionResult Details(BlogDetailsModel model)
{
if (model.CommentFromPage == null)
{
if (ModelState.IsValid)
{
db.Newsletters.Add(model.Newsletter);
db.SaveChanges();
return(RedirectToAction("Index", "Blog"));
}
}
if (model.Newsletter == null)
{
if (ModelState.IsValid)
{
db.CommentFromPages.Add(model.CommentFromPage);
db.SaveChanges();
return(RedirectToAction("Index", "Blog"));
}
}
return(View(model));
}
public IHttpActionResult blog(BlogDetailsModel model)
{
db.openConnection("Connection.Database.Blog");
DataTable dt = null;
var objFunctions = new Commons.functions();
try
{
if (model.actionUser.ToLower() == "dellcrud")
{
paramName = new string[] { "pIdUser", "pIdBlog" };
paramValue = new string[] { Convert.ToString(model.userID), Convert.ToString(model.id) };
dt = db.executePROC("spDeleteBlog", paramName, paramValue);
model.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
else if (model.actionUser.ToLower() == "save" && model.id > 0)
{
paramName = new string[] { "pIdUser", "pIdBlog", "pTitle", "pText" };
paramValue = new string[] { Convert.ToString(model.userID), Convert.ToString(model.id),
model.title, model.text + "@[LONGTEXT-TYPE]" };
dt = db.executePROC("spUpdateBlog", paramName, paramValue);
model.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = model.id }, model));
}
else if (model.actionUser.ToLower() == "save" && model.id == 0)
{
paramName = new string[] { "pIdUser", "pTitle", "pDate", "pHour", "pText" };
paramValue = new string[] { Convert.ToString(model.userID), model.title,
model.registerDate.ToString("dd/MM/yyyy") + ";[DATE-TYPE]", model.registerTime, model.text + "@[LONGTEXT-TYPE]" };
dt = db.executePROC("spAddBlog", paramName, paramValue);
model.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = model.id }, model));
}
else if (model.actionUser.ToLower() == "sendWarningEmail")
{
//coding
model.returnMessage = "ModeratorSuccessfully";
return(CreatedAtRoute("DefaultApi", new { id = model.id }, model));
}
else
{
return(StatusCode(HttpStatusCode.NotAcceptable));
}
}
catch (Exception ex)
{
model.returnMessage = "errorPostBlog_" + ex.Message;
return(CreatedAtRoute("DefaultApi", new { id = 0 }, model));
}
finally
{
db.closeConnection();
dt = null;
objFunctions = null;
}
}
