public Int64 updateData(likeDislikeBo likedislikebo) { try { query = "LIKE_DISLIKE_CLICK"; if (con.State == ConnectionState.Closed) { con.Open(); } cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@commentId",likedislikebo.commentId); cmd.Parameters.AddWithValue("@guid",likedislikebo.guId); cmd.Parameters.AddWithValue("@likeDislike",likedislikebo.likeDislike); Int64 issueId = Convert.ToInt64( cmd.ExecuteScalar()); return issueId; } catch { throw; } finally { if (con.State == ConnectionState.Open) con.Close(); cmd.Dispose(); } }
protected void ListComments_ItemCommand(object source, RepeaterCommandEventArgs e) { likeDislikeBo likedislikebo = new likeDislikeBo(); string btncmdname = e.CommandName.ToString(); Int64 commentId; try { commentId = Convert.ToInt64(e.CommandArgument); if (btncmdname == "like") { likedislikebo.guId = 44; /*** from session ***/ likedislikebo.commentId = commentId; likedislikebo.likeDislike = true; likedislikebal.updateData(likedislikebo); DataTable dt = new DataTable(); dt = (DataTable)commentbal.getComment(commentId); ((Label)e.Item.FindControl("LBLlikeCount")).Text = dt.Rows[0]["likeCount"].ToString(); ((Label)e.Item.FindControl("LBLdislikeCount")).Text = dt.Rows[0]["dislikeCount"].ToString(); } if (btncmdname == "dislike") { likedislikebo.guId = 44; likedislikebo.commentId = commentId; likedislikebo.likeDislike = false; likedislikebal.updateData(likedislikebo); DataTable dt = new DataTable(); dt = (DataTable)commentbal.getComment(commentId); ((Label)e.Item.FindControl("LBLlikeCount")).Text = dt.Rows[0]["likeCount"].ToString(); ((Label)e.Item.FindControl("LBLdislikeCount")).Text = dt.Rows[0]["dislikeCount"].ToString(); } } catch { throw; } finally { } }
protected void DataListComments_ItemCommand(object source, DataListCommandEventArgs e) { likeDislikeBo likedislikebo = new likeDislikeBo(); string btncmdname = e.CommandName.ToString(); Int64 commentId; try { commentId = Convert.ToInt64(e.CommandArgument); if (btncmdname == "like") { likedislikebo.guId = 1; /*** from session ***/ likedislikebo.commentId = commentId; likedislikebo.likeDislike = true; Int64 issueId = likedislikebal.updateData(likedislikebo); // DataListComments.DataSource = (DataTable)commentbal.getComments(issueId); // DataListComments.DataBind(); loadDataList(); } if (btncmdname == "dislike") { likedislikebo.guId = 1; likedislikebo.commentId = commentId; likedislikebo.likeDislike = false; likedislikebal.updateData(likedislikebo); Int64 issueId = likedislikebal.updateData(likedislikebo); //DataListComments.DataSource = (DataTable)commentbal.getComments(issueId); //DataListComments.DataBind(); loadDataList(); } } catch { throw; } finally { } }
private string likeDislike(Int64 commentId,Int64 guid,string val) { likeDislikeBo likedislikebo = new likeDislikeBo(); likedislikebo.commentId = commentId; likedislikebo.guId = guid; likedislikebo.likeDislike = true; if (val != " ") { if (val.ToString() == "like") likedislikebo.likeDislike = true; else if (val.ToString() == "dislike") likedislikebo.likeDislike = false; DataTable dt = new DataTable(); dt = (DataTable)(new LikeDislikeBAL()).updateData(likedislikebo); return ConvertToJason(dt); } return "eRRoR"; }
public DataTable updateData(likeDislikeBo likedislikebo) { try { query = "LIKE_DISLIKE_CLICK1"; if (con.State == ConnectionState.Closed) { con.Open(); } dap = new SqlDataAdapter(query, con); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@commentId", likedislikebo.commentId); dap.SelectCommand.Parameters.AddWithValue("@guid", likedislikebo.guId); dap.SelectCommand.Parameters.AddWithValue("@likeDislike", likedislikebo.likeDislike); DataTable dt = new DataTable(); dap.Fill(dt); return dt; } catch { throw; } finally { if (con.State == ConnectionState.Open) con.Close(); dap.Dispose(); } }
public DataTable updateData(likeDislikeBo likedislikebo) { try { query = "LIKE_DISLIKE_CLICK1"; if (con.State == ConnectionState.Closed) { con.Open(); } dap = new SqlDataAdapter(query, con); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@commentId", likedislikebo.commentId); dap.SelectCommand.Parameters.AddWithValue("@guid", likedislikebo.guId); dap.SelectCommand.Parameters.AddWithValue("@likeDislike", likedislikebo.likeDislike); DataTable dt = new DataTable(); dap.Fill(dt); return(dt); } catch { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } dap.Dispose(); } }
public DataTable updateData(likeDislikeBo likedislikebo) { try { return(likedislikedal.updateData(likedislikebo)); } catch { throw; } finally { } }
public DataTable updateData(likeDislikeBo likedislikebo) { try { return likedislikedal.updateData(likedislikebo); } catch { throw; } finally { } }
protected void ListComments_ItemCommand(object source, RepeaterCommandEventArgs e) { likeDislikeBo likedislikebo = new likeDislikeBo(); string btncmdname; Int64 commentId; try { btncmdname = e.CommandName.ToString(); commentId = Convert.ToInt64(e.CommandArgument); if (btncmdname == "like") { likedislikebo.guId = int.Parse(Session["guid"].ToString()); /*** from session ***/ likedislikebo.commentId = commentId; likedislikebo.likeDislike = true; DataTable dt = likedislikebal.updateData(likedislikebo); ((Label)e.Item.FindControl("LBLlikeCount")).Text = dt.Rows[0]["likeCount"].ToString(); ((Label)e.Item.FindControl("LBLdislikeCount")).Text = dt.Rows[0]["dislikeCount"].ToString(); } else if (btncmdname == "dislike") { likedislikebo.guId = int.Parse(Session["guid"].ToString()); likedislikebo.commentId = commentId; likedislikebo.likeDislike = false; DataTable dt = likedislikebal.updateData(likedislikebo); ((Label)e.Item.FindControl("LBLlikeCount")).Text = dt.Rows[0]["likeCount"].ToString(); ((Label)e.Item.FindControl("LBLdislikeCount")).Text = dt.Rows[0]["dislikeCount"].ToString(); } else if (btncmdname == "reportcomment") { reportbal.Comment_Report(commentId); ((Image)e.Item.FindControl("IMG_ReportComment")).ImageUrl = "../images/flag-red.png"; ((LinkButton)e.Item.FindControl("Report_Abuse_Comment")).Enabled = false; } else { } } catch { throw; } finally { } }
private string likeDislike(Int64 commentId, Int64 guid, string val) { likeDislikeBo likedislikebo = new likeDislikeBo(); likedislikebo.commentId = commentId; likedislikebo.guId = guid; likedislikebo.likeDislike = true; if (val != " ") { if (val.ToString() == "like") { likedislikebo.likeDislike = true; } else if (val.ToString() == "dislike") { likedislikebo.likeDislike = false; } DataTable dt = new DataTable(); dt = (DataTable)(new LikeDislikeBAL()).updateData(likedislikebo); return(ConvertToJason(dt)); } return("eRRoR"); }
protected void ListComments_ItemCommand(object source, RepeaterCommandEventArgs e) { likeDislikeBo likedislikebo = new likeDislikeBo(); string btncmdname; Int64 commentId; try { btncmdname = e.CommandName.ToString(); commentId = Convert.ToInt64(e.CommandArgument); if (btncmdname == "like") { likedislikebo.guId = int.Parse(Session["guid"].ToString()); /*** from session ***/ likedislikebo.commentId = commentId; likedislikebo.likeDislike = true; DataTable dt= likedislikebal.updateData(likedislikebo); ((Label)e.Item.FindControl("LBLlikeCount")).Text = dt.Rows[0]["likeCount"].ToString(); ((Label)e.Item.FindControl("LBLdislikeCount")).Text = dt.Rows[0]["dislikeCount"].ToString(); } else if (btncmdname == "dislike") { likedislikebo.guId = int.Parse(Session["guid"].ToString()); likedislikebo.commentId = commentId; likedislikebo.likeDislike = false; DataTable dt = likedislikebal.updateData(likedislikebo); ((Label)e.Item.FindControl("LBLlikeCount")).Text = dt.Rows[0]["likeCount"].ToString(); ((Label)e.Item.FindControl("LBLdislikeCount")).Text = dt.Rows[0]["dislikeCount"].ToString(); } else if (btncmdname == "reportcomment") { reportbal.Comment_Report(commentId); ((Image)e.Item.FindControl("IMG_ReportComment")).ImageUrl = "../images/flag-red.png"; ((LinkButton)e.Item.FindControl("Report_Abuse_Comment")).Enabled = false; } else { } } catch { throw; } finally { } }