public PhotoCommentCombined GetPhotoAndComments(int photoId) { PhotoCommentCombined photo = new PhotoCommentCombined(); SqlCommand cmd = new SqlCommand("select * from AllPhotos P Left join UserDetails U on U.Userid = P.userid Left join comments C on C.PhotoId = P.PhotoId where P.PhotoId = @photoId", sqlConnection); //cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@photoId", photoId); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sqlConnection.Open(); sda.Fill(dt); sqlConnection.Close(); int i = 0; photo.Comments = new List <Comments>(); foreach (DataRow dr in dt.Rows) { if (i == 0) { photo.Photo = new Photos { PhotoID = Convert.ToInt32(dr["photoID"]), UserId = Convert.ToInt32(dr["userid"]), Username = Convert.ToString(dr["username"]), ProfilePic = Convert.ToString(dr["profilepic"]), PhotoPath = Convert.ToString(dr["Path"]), LikedBy = (dr["LikedBy"]).ToString() /*.Trim(',').Split(',').Select(c => Convert.ToInt32((c != "") ? c : "0")).ToArray()*/, DisLikedBy = (dr["DislikedBy"]).ToString() /*.Trim(',').Split(',').Select(c => Convert.ToInt32((c != "") ? c : "0")).ToArray()*/, LovedBy = (dr["LovedBy"]).ToString() /*.Trim(',').Split(',').Select(c => Convert.ToInt32((c != "") ? c : "0")).ToArray()*/, DOU = Convert.ToDateTime(dr["dou"]), ContentType = Convert.ToString(dr["ContentType"]), Video = Convert.ToString(dr["Video"]), Gif = Convert.ToString(dr["Gif"]) } } ; if ((dr["CommentID"]).ToString() != "") { photo.Comments.Add(new Comments() { CommentID = Convert.ToInt32(dr["CommentID"]), UserId = Convert.ToInt32(dr["userid"]), PhotoID = Convert.ToInt32(dr["photoID"]), ProfilePic = Convert.ToString(dr["profilepic"]), Text = Convert.ToString(dr["text"]), LikedBy = Convert.ToString(dr["likedby"]), DislikedBy = Convert.ToString(dr["dislikedby"]), LovedBy = Convert.ToString(dr["lovedby"]) }); } i++; } return(photo); } }
public ActionResult DisplayPhoto(int photoId) { if (Session["UserID"] != null) { string userid = Session["UserID"].ToString(); bool result = photoService.SetTrending(photoId); PhotoCommentCombined photo = photoService.GetPhotoAndComments(photoId); ViewBag.UserId = Session["UserID"].ToString(); return(View(photo)); } else { return(RedirectToAction("Index", "Home")); } }