// advance counting with different settings
public static int Count_Comments(string search, string username, string type, int isEnabled, int isApproved, int filteroption)
{
StringBuilder query = new StringBuilder();
string logic = CommentsBLL.Return_Comment_Admin_Logic(search, username, type, isEnabled, isApproved, filteroption);
query.Append("SELECT Count(commentid) FROM comments" + logic);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(Config.ConnectionString, CommandType.Text, query.ToString(), new SqlParameter("@search", search), new SqlParameter("@username", username), new SqlParameter("@type", type), new SqlParameter("@isenabled", isEnabled), new SqlParameter("@isapproved", isApproved))));
}
public ActionResult action()
{
var json = new StreamReader(Request.Body).ReadToEnd();
var data = JsonConvert.DeserializeObject <List <CommentEntity> >(json);
CommentsBLL.ProcessAction(_context, data);
return(Ok(new { status = "success", message = SiteConfig.generalLocalizer["_records_processed"].Value }));
}
public ActionResult proc()
{
var json = new StreamReader(Request.Body).ReadToEnd();
var data = JsonConvert.DeserializeObject <JGN_Comments>(json);
data = CommentsBLL.Process(_context, data);
return(Ok(new { status = "success", record = data, message = SiteConfig.generalLocalizer["_record_created"].Value }));
}
private void BindList()
{
int pagesize = Convert.ToInt32(drp_pagesize.SelectedValue);
string search = "";
if (txt_search.Text != "")
{
search = txt_search.Text;
}
//if (this.TotalRecords == 0)
this.TotalRecords = CommentsBLL.Count_Comments(search, this.UserName, drp_type.SelectedValue, Convert.ToInt32(drp_isenable.SelectedValue), Convert.ToInt32(drp_approve.SelectedValue), Convert.ToInt32(drp_filter.SelectedValue));
if (this.TotalRecords == 0)
{
// no record exist
pnl_main.Visible = false;
pnl_norecord.Visible = true;
lbl_records.InnerHtml = "<h4>0 records found</h4>";
return;
}
List <Comment_Struct> list = CommentsBLL.Load_Comments(search, this.UserName, drp_type.SelectedValue, Convert.ToInt32(drp_isenable.SelectedValue), Convert.ToInt32(drp_approve.SelectedValue), Convert.ToInt32(drp_filter.SelectedValue), drp_order.SelectedValue, this.PageNumber, pagesize);
if (list.Count > 0)
{
ViewState["script_value"] = "";
//int count = int.Parse(list.Count.ToString());
if (this.TotalRecords > 1)
{
lbl_records.InnerHtml = "<h4>" + this.TotalRecords + " records found</h4>";
}
else
{
lbl_records.InnerHtml = this.TotalRecords + " record found";
}
// setup pagination
Pagination_Process.Process_Pagination(MyList, rptPages, lnk_Prev, lnk_Next, pagesize, this.PageNumber, list, this.TotalRecords);
pnl_main.Visible = true;
pnl_norecord.Visible = false;
}
else
{
pnl_main.Visible = false;
pnl_norecord.Visible = true;
lbl_records.InnerHtml = "<h4>0 records found</h4>";
}
}
public async Task <ActionResult> load()
{
var json = new StreamReader(Request.Body).ReadToEnd();
var data = JsonConvert.DeserializeObject <CommentEntity>(json);
var _posts = await CommentsBLL.LoadItems(_context, data);
var _records = 0;
if (data.id == 0)
{
_records = await CommentsBLL.Count(_context, data);
}
return(Ok(new { posts = _posts, records = _records }));
}
protected void UpdateApproved(int status)
{
// Check whether admin section is in readonly mode.
if (!Config.isAdminActionAllowed())
{
Response.Redirect(Config.GetUrl("adm/sc/Default.aspx?action_error=true"));
return;
}
int index;
bool flg = false;
for (index = 0; index < MyList.Items.Count; index++)
{
CheckBox select_chk;
select_chk = (CheckBox)MyList.Items[index].FindControl("chk_inbox");
if (select_chk.Checked)
{
long id = Convert.ToInt64(((Label)MyList.Items[index].FindControl("lbl_id")).Text);
long contentid = Convert.ToInt64(((Label)MyList.Items[index].FindControl("lbl_contentid")).Text);
int type = Convert.ToInt32(((Label)MyList.Items[index].FindControl("lbl_type")).Text);
string profileid = ((Label)MyList.Items[index].FindControl("lbl_profileid")).Text;
int OldValue = Convert.ToInt32(((Label)MyList.Items[index].FindControl("lbl_isapproved")).Text);
CommentsBLL.Update_Action(id, OldValue, status, contentid, profileid, type, "isapproved", true);
if (flg == false)
{
flg = true;
}
}
}
if (flg == false)
{
Config.ShowMessageV2(msg, "please select record", "Info!", 2);
}
else
{
if (status == 1)
{
Config.ShowMessageV2(msg, "selected records have been approved successfully", "Success!", 1);
}
else
{
Config.ShowMessageV2(msg, "selected records have been dis approved successfully", "Success!", 1);
}
}
BindList();
}
// Load photos in admin section
public static List <Comment_Struct> Load_Comments(string search, string username, string type, int isEnabled, int isApproved, int filteroption, string order, int PageNumber, int PageSize)
{
SqlConnection con = new SqlConnection(Config.ConnectionString);
if (con.State != ConnectionState.Open)
{
con.Open();
}
List <Comment_Struct> _items = new List <Comment_Struct>();
Comment_Struct _item;
// Query Building
StringBuilder str = new StringBuilder();
StringBuilder query = new StringBuilder();
string logic = CommentsBLL.Return_Comment_Admin_Logic(search, username, type, isEnabled, isApproved, filteroption);
query.Append("commentid,videoid,username,_comment,added_date,isenabled,type,points,isapproved,replyid,profileid FROM comments" + logic);
// implement paging script for differnt data sources.
switch (Site_Settings.Pagination_Type)
{
case 0:
// SQL SERVER 2005 or Later Supported Query
str.Append(Pagination_Process.Prepare_SQLSERVER2005_Pagination(query.ToString(), order, PageNumber, PageSize));
break;
case 1:
// MySQL Supported Query
string mysql_query = "SELECT " + query.ToString() + " ORDER BY " + order;
str.Append(Pagination_Process.Prepare_MySQL_Pagination(mysql_query, PageNumber, PageSize));
break;
case 2:
// SQL SERVER 2000 Supported Query
string normal_query = "SELECT " + query.ToString() + " ORDER BY " + order;
str.Append(normal_query);
break;
}
// execute sql query
SqlCommand video_cmd = new SqlCommand(str.ToString(), con);
video_cmd.Parameters.Add(new SqlParameter("@search", search));
video_cmd.Parameters.Add(new SqlParameter("@username", username));
video_cmd.Parameters.Add(new SqlParameter("@type", type));
video_cmd.Parameters.Add(new SqlParameter("@isenabled", isEnabled));
video_cmd.Parameters.Add(new SqlParameter("@isapproved", isApproved));
SqlDataReader reader = video_cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
_item = new Comment_Struct();
_item.CommentID = (long)reader["commentid"];
_item.Comment = reader["_comment"].ToString();
_item.UserName = reader["username"].ToString();
_item.VideoID = (long)reader["videoid"];
_item.isEnabled = Convert.ToInt32(reader["isenabled"]);
_item.isApproved = Convert.ToInt32(reader["isapproved"]);
_item.Type = Convert.ToInt32(reader["type"]);
_item.ReplyID = (long)reader["replyid"];
_item.Points = Convert.ToInt32(reader["points"]);
_item.Added_Date = (DateTime)reader["added_date"];
_item.ProfileID = reader["profileid"].ToString();
_items.Add(_item);
}
reader.Close();
con.Close(); con.Dispose();
return(_items);
}
private void Load_Comments()
{
StringBuilder str = new StringBuilder();
// store comment flags
int TotalPages = 1;
if (this.TotalComments > this.PageSize)
{
TotalPages = (int)Math.Ceiling((double)this.TotalComments / this.PageSize);
}
str.Append("<span style=\"display:none;\" id=\"cmt_tcmts\">" + this.TotalComments + "</span>\n"); // store total pages info in <span>
str.Append("<span style=\"display:none;\" id=\"cmt_tpages\">" + TotalPages + "</span>\n"); // store total pages info in <span>
str.Append("<span style=\"display:none;\" id=\"cmt_psize\">" + PageSize + "</span>\n"); // store page size infor in <span>
str.Append("<span style=\"display:none;\" id=\"cmt_pnum\">1</span>\n"); // current page index <span>
if (this.TotalComments == 0)
{
str.Append("<div class=\"bx_msg\">");
str.Append("<h4>Be the first to post comment on this " + ContentType.ToLower() + "!</h4>");
str.Append("</div>");
lst.InnerHtml = str.ToString();
return;
}
// check for comments
List <Comment_Struct> _list = CommentsBLL.Fetch_Comments_V2(this.ContentID, this.ProfileID, this.Type, this.PageNumber, this.PageSize, this.Order, this.ShowAuthorPhoto);
if (_list.Count > 0)
{
// load comments
int i = 0;
str.Append("<div class=\"item\">");
for (i = 0; i <= _list.Count - 1; i++)
{
// set post layout
CmtItem postitem = new CmtItem();
postitem.Height = 50;
postitem.Width = 50;
postitem.ShowDate = true;
postitem.ShowAuthor = true;
postitem.ShowAuthorImage = this.ShowAuthorPhoto;
postitem.Height = this.Height;
postitem.Width = this.Width;
postitem.isAdmin = this.isAdmin;
postitem.isHoverEffect = true;
postitem.isRoundCorners = false;
postitem.LeftWidth = 8; // %
postitem.RightWidth = 91; // %
postitem.ShowReplyLink = true;
postitem.ShowVotes = true;
postitem.AuthorUserName = this.AuthorUserName; // Author Of Post
string PosterUserName = "";
if (Page.User.Identity.IsAuthenticated)
{
PosterUserName = Page.User.Identity.Name;
}
postitem.PosterUserName = PosterUserName; // Currently logged in User
postitem.ShowReplyLink = this.ShowReplyLink;
postitem.ShowVotes = this.ShowVoteLink;
postitem.isHoverEffect = this.HoverEffect;
postitem.TemplateID = this.TemplateID;
str.Append(postitem.Process(_list[i]));
}
if (this.PaginationType == 1)
{
str.Append("<div id=\"cmt_load_cnt\"></div>\n"); // load more comment container
}
str.Append("<div id=\"cmt_loading\"></div>\n"); // show loading progres
str.Append("<div class=\"clear\"></div>"); // clear floating items
str.Append("</div>");
// ********************************************
// PAGINATION SCRIPT
// ********************************************
pg.Visible = false;
apg.Visible = false;
if (TotalPages > 1)
{
switch (this.PaginationType)
{
case 0:
// jquery ajax pagination
apg.Visible = true;
apagination1.TotalRecords = this.TotalComments;
apagination1.PageSize = this.PageSize;
apagination1.PageNumber = this.PageNumber;
apagination1.LoadHandler = Config.GetUrl("modules/comments/hdr/load.ashx");
apagination1.LoadParams = this.Load_Params;
apagination1.LoadContainer = lst.ClientID;
apagination1.LoadStatusContainer = "cmt_loading";
apagination1.BindPagination();
break;
case 1:
// jquery load more pagination
str.Append("<div id=\"cmt_more\" class=\"item_pad_4 bx_br_both\" style=\"padding:5px 0px;\">\n");
str.Append("<span class=\"ui-icon ui-icon-triangle-1-s\" style=\"float: left; margin-right: .3em;\"></span><a id=\"cmt_ld_more\" href=\"#\" class=\"bold\" title=\"load more comments\">Load more...</a>\n");
str.Append("</div>\n");
break;
case 2:
// normal pagination
pg.Visible = true;
pagination1.TotalRecords = this.TotalComments;
pagination1.PageSize = this.PageSize;
pagination1.PageNumber = this.PageNumber;
pagination1.Default_Url = this.DefaultUrl;
pagination1.Pagination_Url = this.PaginationUrl;
pagination1.BindPagination();
break;
}
}
}
else
{
str.Append("<div class=\"bx_msg\">");
str.Append("<h4>Be the first to post comment on this " + ContentType.ToLower() + "!</h4>");
str.Append("</div>");
}
lst.InnerHtml = str.ToString();
}
