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"));
}
}
