public void SearchPosts() { client = new RestClient(url + "/posts"); request = new RestRequest(Method.GET); response = client.Execute(request); var searchResult = PostModelList.FromJson(response.Content); }
public ActionResult Respondidos(PostModelList model) { try { return(View(model)); } catch (Exception) { return(MensagemDeErro()); } }
public PartialViewResult GetPosts() { try { PostModelList modelResult = new PostModelList(); modelResult.PostsList = new List <PostModelList>(); //carrrega a listagem. modelResult.PostsList = _postService.ListarNovosModels(); return(PartialView("PartialListagem", modelResult)); } catch (Exception) { return(PartialView("PartialListagem", null)); } }
public ActionResult UserPostList(PostModel objPostModel) { if (ModelState.IsValid) { string conString = @"Data Source=DESKTOP-4VMML1C\JUBAYERSQL;initial Catalog=LoginDB;Integrated Security=True;"; using (SqlConnection sqlCon = new SqlConnection(conString)) { sqlCon.Open(); DateTime now = DateTime.Now; string query = @"INSERT INTO tblPostText (PostText, UserId, Date) VALUES('" + objPostModel.PostText + "', '" + Session["UserID"] + "', '" + now.Date.ToString() + "');"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@PostText", objPostModel.PostText); sqlCmd.Parameters.AddWithValue("@UserId", Session["UserID"]); sqlCmd.Parameters.AddWithValue("@Date", now.Date.ToString()); SqlConnection myConnection2 = new SqlConnection(); myConnection2.ConnectionString = conString; sqlCmd.Connection = myConnection2; myConnection2.Open(); SqlDataReader reader2 = null; reader2 = sqlCmd.ExecuteReader(); myConnection2.Close(); //sqlCmd.ExecuteScalar(); PostModelList obPostModelList = new PostModelList(); if (true) { using (SqlConnection con = new SqlConnection(conString)) { //PostModelList obPostModelList = new PostModelList(); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = conString; SqlCommand sqlCmd2 = new SqlCommand(); sqlCmd2.CommandType = CommandType.Text; sqlCmd2.CommandText = "SELECT * FROM tblPostText"; sqlCmd2.Connection = myConnection; myConnection.Open(); reader = sqlCmd2.ExecuteReader(); PostModel obPostModel = new PostModel(); obPostModelList.PostModels = new List <PostModel>(); while (reader.Read()) { obPostModel = new PostModel(); obPostModel.ID = Convert.ToInt32(reader.GetValue(0)); obPostModel.PostText = reader.GetValue(1).ToString(); obPostModel.UserId = reader.GetValue(2).ToString();; obPostModel.DateTime = reader.GetValue(3).ToString(); obPostModel.UserName = reader.GetValue(4).ToString(); obPostModelList.PostModels.Add(obPostModel); } if (obPostModelList.PostModels.Count > 0) { for (int i = 0; i < obPostModelList.PostModels.Count; i++) { SqlConnection myConnection3 = new SqlConnection(); myConnection3.ConnectionString = conString; myConnection3.ConnectionString = conString; sqlCmd2 = new SqlCommand(); sqlCmd2.CommandType = CommandType.Text; sqlCmd2.CommandText = "SELECT * FROM tblComment2 where PostId=@PostId"; //string postId = obPostModelList.PostModels[i].ID.ToString(); sqlCmd2.Parameters.AddWithValue("@PostId", obPostModelList.PostModels[i].ID.ToString()); sqlCmd2.Connection = myConnection3; myConnection3.Open(); reader = sqlCmd2.ExecuteReader(); CommentModel obCommentModel = new CommentModel(); obPostModelList.PostModels[i].CommentModelList = new List <CommentModel>(); while (reader.Read()) { obCommentModel = new CommentModel(); obCommentModel.ID = Convert.ToInt32(reader.GetValue(0)); obCommentModel.PostId = Convert.ToInt32(reader.GetValue(0)).ToString(); obCommentModel.CommentText = Convert.ToInt32(reader.GetValue(2)); obCommentModel.UserID = reader.GetValue(3).ToString(); obCommentModel.DateTime = reader.GetValue(4).ToString(); obCommentModel.UserName = reader.GetValue(4).ToString(); obPostModelList.PostModels[i].CommentModelList.Add(obCommentModel); } myConnection3.Close(); } } myConnection.Close(); ViewBag.message = "Text Posted"; return(View("UserPostList", obPostModelList)); //return RedirectToAction("UserPostList"); } } } } return(View(objPostModel)); }
public ActionResult UserPostList() { string conString = @"Data Source=DESKTOP-4VMML1C\JUBAYERSQL;initial Catalog=LoginDB;Integrated Security=True;"; using (SqlConnection sqlCon = new SqlConnection(conString)) { sqlCon.Open(); using (SqlConnection con = new SqlConnection(conString)) { //PostModelList obPostModelList = new PostModelList(); SqlDataReader reader = null; SqlConnection myConnection = new SqlConnection(); myConnection.ConnectionString = conString; SqlCommand sqlCmd2 = new SqlCommand(); sqlCmd2.CommandType = CommandType.Text; sqlCmd2.CommandText = "SELECT * FROM tblPostText"; sqlCmd2.Connection = myConnection; myConnection.Open(); reader = sqlCmd2.ExecuteReader(); PostModel obPostModel = new PostModel(); PostModelList obPostModelList = new PostModelList(); obPostModelList.PostModels = new List <PostModel>(); while (reader.Read()) { obPostModel = new PostModel(); obPostModel.ID = Convert.ToInt32(reader.GetValue(0)); obPostModel.PostText = reader.GetValue(1).ToString(); obPostModel.UserId = reader.GetValue(2).ToString();; obPostModel.DateTime = reader.GetValue(3).ToString(); obPostModel.UserName = reader.GetValue(4).ToString(); obPostModelList.PostModels.Add(obPostModel); } if (obPostModelList.PostModels.Count > 0) { for (int i = 0; i < obPostModelList.PostModels.Count; i++) { SqlConnection myConnection3 = new SqlConnection(); myConnection3.ConnectionString = conString; myConnection3.ConnectionString = conString; sqlCmd2 = new SqlCommand(); sqlCmd2.CommandType = CommandType.Text; sqlCmd2.CommandText = "SELECT * FROM tblComment2 where PostId=@PostId"; //string postId = obPostModelList.PostModels[i].ID.ToString(); sqlCmd2.Parameters.AddWithValue("@PostId", obPostModelList.PostModels[i].ID.ToString()); sqlCmd2.Connection = myConnection3; myConnection3.Open(); reader = sqlCmd2.ExecuteReader(); CommentModel obCommentModel = new CommentModel(); obPostModelList.PostModels[i].CommentModelList = new List <CommentModel>(); while (reader.Read()) { obCommentModel = new CommentModel(); obCommentModel.ID = Convert.ToInt32(reader.GetValue(0)); obCommentModel.PostId = Convert.ToInt32(reader.GetValue(0)).ToString(); obCommentModel.CommentText = Convert.ToInt32(reader.GetValue(2)); obCommentModel.UserID = reader.GetValue(3).ToString(); obCommentModel.DateTime = reader.GetValue(4).ToString(); obCommentModel.UserName = reader.GetValue(4).ToString(); obPostModelList.PostModels[i].CommentModelList.Add(obCommentModel); } myConnection3.Close(); } } myConnection.Close(); ViewBag.message = "Text Posted"; return(View("UserPostList", obPostModelList)); //return RedirectToAction("UserPostList"); } } }
public ActionResult Listagem(PostModelList model) { return(View(model)); }