public ActionResult AddNewPost() { SQLServerConnector sqlServerConnector = new SQLServerConnector(); List <PostDataCarousel> listPosts; listPosts = sqlServerConnector.getPostsList(); ViewBag.ListOfPosts = listPosts; return(View(listPosts)); }
public ActionResult Index() { IndexModel indexModel = new IndexModel(); SQLServerConnector sqlServerConnector = new SQLServerConnector(); List <PostDataCarousel> postList; postList = sqlServerConnector.getTopPostsList(3); //ViewBag.ListOfPosts = postList; indexModel.PostDataCarousels = postList; //return View(postList); return(View(indexModel)); }
}// End of ConfirmedDeletePost public ActionResult EditPost(String postID) { SQLServerConnector sqlServerConnector = new SQLServerConnector(); List <PostDataCarousel> listPosts; PostDataCarousel postDataCarouselForEdit; String sqlCriteria = "aaz01 = '" + postID + "'"; listPosts = sqlServerConnector.getPostsListOnDemand(sqlCriteria); postDataCarouselForEdit = listPosts[0]; ViewBag.PostDataForEdit = postDataCarouselForEdit; return(View("EditPost", postDataCarouselForEdit)); }
public ActionResult ConfirmedDeletePost(String postID) { SQLServerConnector sqlServerConnector = new SQLServerConnector(); List <PostDataCarousel> listPosts = new List <PostDataCarousel>(); String result = sqlServerConnector.ConfirmedDelete(postID); if (result == "SUCCESS") { listPosts = sqlServerConnector.getPostsList(); } ViewBag.ListOfPosts = listPosts; return(RedirectToAction("AddNewPost", "Post")); }// End of ConfirmedDeletePost
public ActionResult UpdatePost([Bind(Include = "Aaz01,Aaz02,Aaz03")] PostDataCarousel postdatacarousel) { SQLServerConnector sqlServerConnector = new SQLServerConnector(); postdatacarousel.Aaz05 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); String result = sqlServerConnector.ConfirmedEdit(postdatacarousel); List <PostDataCarousel> listPosts = new List <PostDataCarousel>(); if (result == "SUCCESS") { listPosts = sqlServerConnector.getPostsList(); } ViewBag.ListOfPosts = listPosts; return(RedirectToAction("AddNewPost", "Post")); }
public ActionResult Create([Bind(Include = "aaz02,aaz03 ")] PostDataCarousel postdatacarousel) { SQLServerConnector sqlServerConnector = new SQLServerConnector(); List <PostDataCarousel> listPosts; listPosts = sqlServerConnector.getPostsList(); postdatacarousel.Aaz01 = DateTime.Now.ToString("yyyyMMddHHmmss"); //postdatacarousel.Aaz02 = ""; //postdatacarousel.Aaz03 = ""; postdatacarousel.Aaz05 = DateTime.Now.ToString("yyyy-MM-dd "); String result = sqlServerConnector.InsertPostData(postdatacarousel); return(RedirectToAction("AddNewPost", "Post")); }//Create
}//Create public ActionResult DeletePost(String postID) { String sqlCriteria = ""; if (postID != null && !postID.IsEmpty()) { if (postID.StartsWith("*")) { postID = postID.Remove(1, 1); } if (postID.EndsWith("*")) { postID = postID.Remove(postID.Length - 1, postID.Length); } sqlCriteria = "aaz01 LIKE '%" + postID + "%' "; } SQLServerConnector sqlServerConnector = new SQLServerConnector(); List <PostDataCarousel> listPosts; listPosts = sqlServerConnector.getPostsListOnDemand(sqlCriteria); ViewBag.ListOfPosts = listPosts; return(View("ConfirmDelete", listPosts)); }//End of DeletePost