public CommentsBEL AddComment(CommentsBEL commentBEL)
{
CommentsBEL CommentsDetails = new CommentsBEL();
DataSet ds = null;
try
{
SqlParameter[] SqlParms = new SqlParameter[6];
SqlParms[0] = new SqlParameter("@UserId", SqlDbType.NVarChar, 50);
SqlParms[0].Direction = ParameterDirection.Input;
SqlParms[0].Value = commentBEL.userId;
SqlParms[1] = new SqlParameter("@PostId", SqlDbType.NVarChar, 50);
SqlParms[1].Direction = ParameterDirection.Input;
SqlParms[1].Value = commentBEL.postId;
SqlParms[2] = new SqlParameter("@Comment", SqlDbType.NVarChar, 1500);
SqlParms[2].Direction = ParameterDirection.Input;
SqlParms[2].Value = commentBEL.commentText;
SqlParms[3] = new SqlParameter("@Avatar", SqlDbType.NVarChar, 800);
SqlParms[3].Direction = ParameterDirection.Input;
SqlParms[3].Value = commentBEL.avatar;
SqlParms[4] = new SqlParameter("@Error", SqlDbType.NVarChar, 500);
SqlParms[4].Direction = ParameterDirection.Output;
SqlParms[5] = new SqlParameter("@CommentID", SqlDbType.NVarChar, 50);
SqlParms[5].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "Add_NewComments", SqlParms);
//&& Convert.ToString(SqlParms[5].Value) != "0"
if (ds == null && ds.Tables.Count <= 0)
{
CommentsDetails.userId = "";
CommentsDetails.commentId = "0";
CommentsDetails.ErrorMessage = Convert.ToString(SqlParms[4].Value) + " Data Not Found";
}
else if (Convert.ToString(SqlParms[4].Value) == string.Empty)
{
CommentsDetails.postId = ds.Tables[0].Rows[0]["Post_ID"].ToString();
CommentsDetails.userId = ds.Tables[0].Rows[0]["User_Id"].ToString();
CommentsDetails.commentText = ds.Tables[0].Rows[0]["Text"].ToString();
CommentsDetails.commentId = ds.Tables[0].Rows[0]["Comment_id"].ToString();
CommentsDetails.avatar = ds.Tables[0].Rows[0]["Avatar"].ToString();
CommentsDetails.likes = "0";
CommentsDetails.ErrorMessage = string.Empty;
// ResultDTO. = Convert.ToString(SqlParms[5].Value);
}
else
{
CommentsDetails.userId = "";
CommentsDetails.commentId = "0";
CommentsDetails.ErrorMessage = Convert.ToString(SqlParms[4].Value);
}
}
catch (Exception ex)
{
CommentsDetails.userId = "";
CommentsDetails.commentId = "0";
CommentsDetails.ErrorMessage = "DataBase Error Occured : " + ex.Message;
}
return(CommentsDetails);
}
public List <PostsBEL> GetAllPosts()
{
List <PostsBEL> Posts = new List <PostsBEL>();
try
{
DataSet ds = null;
SqlParameter[] SqlParms = new SqlParameter[1];
SqlParms[0] = new SqlParameter("@Error", SqlDbType.NVarChar, 150);
SqlParms[0].Direction = ParameterDirection.Output;
//SqlParms[7] = new SqlParameter("@UserId", SqlDbType.NVarChar, 20);
//SqlParms[7].Direction = ParameterDirection.Output;
ds = SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "Get_AllPosts", SqlParms);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
CommentsBEL c = new CommentsBEL();
/*Posts = (from DataRow Post in ds.Tables[0].Rows
*
* select new PostsBEL
* {
* /* userId = Convert.ToString(parkingrow["User_id"]),
* postId = Convert.ToString(parkingrow["Menu_id"]),
* postDescription = Convert.ToString(parkingrow["Menu_description"]),
*
* post.a Comments
*
* Success = true,
* ErrorMessage = "",
* }
* ).ToList<PostsBEL>();
*/
PostsBEL post; // = new PostsBEL();
List <CommentsBEL> comments; // = new List<CommentsBEL>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
post = new PostsBEL();
comments = new List <CommentsBEL>();
post.postId = ds.Tables[0].Rows[i]["Post_id"].ToString();
post.postName = ds.Tables[0].Rows[i]["PostName"].ToString();
post.postDescription = ds.Tables[0].Rows[i]["PostDescription"].ToString();
post.postedByUName = ds.Tables[0].Rows[i]["postedby"].ToString();
post.userId = ds.Tables[0].Rows[i]["postedByUid"].ToString();
post.dateCreated = ds.Tables[0].Rows[i]["PostCreatedOn"].ToString();
post.avatar = ds.Tables[0].Rows[i]["PostAvatar"].ToString();
post.likes = ds.Tables[0].Rows[i]["likes"].ToString();
post.Success = true;
//c = new CommentsBEL();
for (int k = i; k < ds.Tables[0].Rows.Count; k++)
{
if (post.postId == ds.Tables[0].Rows[k]["CPostId"].ToString())
{
c = new CommentsBEL();
c.commentId = ds.Tables[0].Rows[k]["Comment_id"].ToString();
c.commentText = ds.Tables[0].Rows[k]["comment"].ToString();
c.CommentedByUName = ds.Tables[0].Rows[k]["CommentedByName"].ToString();
c.userId = ds.Tables[0].Rows[k]["commentedByUid"].ToString();
c.likes = ds.Tables[0].Rows[k]["Commentlikes"].ToString();
c.avatar = ds.Tables[0].Rows[k]["CommentAvatar"].ToString();
c.dateCreated = ds.Tables[0].Rows[k]["CommentDate"].ToString();
c.postId = ds.Tables[0].Rows[k]["CPostid"].ToString();
comments.Add(c);
i = k;
}
}
post.Comments = comments;
// i = k;
//po
Posts.Add(post);
}
return(Posts);
}
else
{
Posts.Add(new PostsBEL()
{
Success = false, ErrorMessage = Convert.ToString(SqlParms[1].Value)
});
return(Posts);
}
}
catch (Exception ex)
{
Posts.Add(new PostsBEL()
{
Success = false, ErrorMessage = Convert.ToString(ex.Message.ToString())
});
return(Posts);
}
// return AvailableParkings;
}
public HttpResponseMessage AddComment(AddCommentViewModel vm)
{
var res = new HttpResponseMessage();
JObject jContent = new JObject();
Random ran = new Random();
if (vm != null)
{
// vm.Password = Secure.Encrypt(vm.Password);// Secure.Encrypt("TWuser@" + Convert.ToString(ran.Next(1000, 9999)));
// vm.ConfirmPassword = Secure.Encrypt(vm.Password);
if (ModelState.IsValid)
{
try
{
CommentsBEL objCommentBEL = new CommentsBEL();
objCommentBEL.userId = vm.userId;
objCommentBEL.postId = vm.postId;
objCommentBEL.commentText = vm.commentText;
objCommentBEL.avatar = vm.Avatar;
// objPostBEL. = vm.Mobile;
UserDetailsDAL objUserDAL = new UserDetailsDAL();
CommentsBEL ulvm = new CommentsBEL(objUserDAL.AddComment(objCommentBEL));
if (ulvm.commentId != "0")
{
res.StatusCode = HttpStatusCode.Created;
jContent = new JObject(
new JProperty("result",
new JObject(
new JProperty("Success", true),
new JProperty("Message", "Post added successfully"),
new JProperty("CommentId", ulvm.commentId))));
}
else
{
res.StatusCode = HttpStatusCode.BadRequest;
jContent = new JObject(
new JProperty("result",
new JObject(
new JProperty("Success", false),
new JProperty("Message", ulvm.ErrorMessage),
new JProperty("ErrorMessage", ulvm.ErrorMessage),
new JProperty("CommentId", ulvm.commentId))));
}
}
catch (Exception ex)
{
res.StatusCode = HttpStatusCode.BadRequest;
jContent = new JObject(
new JProperty("result",
new JObject(
new JProperty("Success", false),
new JProperty("Message", ex.Message),
new JProperty("ErrorMessage", ex.InnerException.ToString()),
new JProperty("CommentId", null))));
}
}
else
{
var errorList = (from item in ModelState
where item.Value.Errors.Any()
select item.Value.Errors[0].ErrorMessage).ToList();
res.StatusCode = HttpStatusCode.BadRequest;
jContent = new JObject(
new JProperty("result",
new JObject(
new JProperty("Success", false),
new JProperty("Message", "Invalid Input"),
new JProperty("ErrorMessage", errorList),
new JProperty("CommentId", null))));
}
}
res.Content = new StringContent(jContent.ToString());
return(res);
}
