// Post Comment
public static long Add(Comment_Struct cmt, int Comments)
{
// *********************************************************//
// SCREENING Data Script: Updated in VSK 5.2
// *********************************************************//
if (Config.Get_ScreeningOption() == 1)
{
// screening, matching and replacing enabled
// the following script will screen content with matching words e.g "apple" -> "a***e"
cmt.Comment = DictionaryBLL.Process_Screening(cmt.Comment);
}
//// Stored Procedure Version
//SqlParameter CommentID = new SqlParameter("@CommentID", MySqlDbType.Int64);
//CommentID.Direction = ParameterDirection.Output;
//SqlHelper.ExecuteNonQuery(Config.ConnectionString, CommandType.StoredProcedure, "VSK_Comments_Post", CommentID, new SqlParameter("@VideoID", cmt.VideoID), new SqlParameter("@username", cmt.UserName), new SqlParameter("@comments", cmt.Comment), new SqlParameter("@date_added", DateTime.Now), new SqlParameter("@type", cmt.Type), new SqlParameter("@replyid", cmt.ReplyID), new SqlParameter("@profileid", cmt.ProfileID));
SqlConnection con = new SqlConnection(Config.ConnectionString);
// generate sql query
StringBuilder str = new StringBuilder();
str.Append("Insert Into comments(VideoID,username,_comment,added_date,type,replyid,profileid)values(@VideoID,@UserName,@Comments,@Date_Added,@Type,@ReplyID,@ProfileID);Select SCOPE_IDENTITY();");
// execute sql query
SqlCommand cmd = new SqlCommand(str.ToString(), con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@VideoID", cmt.VideoID));
cmd.Parameters.Add(new SqlParameter("@UserName", cmt.UserName));
cmd.Parameters.Add(new SqlParameter("@Comments", cmt.Comment));
cmd.Parameters.Add(new SqlParameter("@Type", cmt.Type));
cmd.Parameters.Add(new SqlParameter("@ReplyID", cmt.ReplyID));
cmd.Parameters.Add(new SqlParameter("@ProfileID", cmt.ProfileID));
cmd.Parameters.Add(new SqlParameter("@Date_Added", DateTime.Now));
if (con.State != ConnectionState.Open)
{
con.Open();
}
long id = Convert.ToInt64(cmd.ExecuteScalar());
string level = id.ToString();
if (cmt.ReplyID > 0)
{
long c = cmt.ReplyID - 1; // in order to order replies based on comment id / replies
level = c + "." + id.ToString();
}
// Update Level
//SqlHelper.ExecuteNonQuery(Config.ConnectionString, CommandType.StoredProcedure, "VSK_Comments_UpdateLevel", CommentID, new SqlParameter("@_CommentID", CommentID.Value), new SqlParameter("@_Level", level));
SqlHelper.ExecuteNonQuery(Config.ConnectionString, CommandType.Text, "Update comments set level=@Level WHERE CommentID=@CommentID;", new SqlParameter("@CommentID", id), new SqlParameter("@Level", level));
Comments++;
if (cmt.ProfileID != "")
{
members.Update_Value(cmt.ProfileID, "comments", Comments.ToString());
}
else
{
Update_Comment_Statistics(cmt.VideoID, cmt.Type, Comments);
}
return(id);
}
private static void ScreenContent(ApplicationDbContext context, JGN_Blogs entity)
{
if (Jugnoon.Settings.Configs.GeneralSettings.screen_content == 1)
{
entity.title = DictionaryBLL.Process_Screening(context, UtilityBLL.processNull(entity.title, 0));
entity.description = DictionaryBLL.Process_Screening(context, UtilityBLL.processNull(entity.description, 0));
entity.tags = DictionaryBLL.Process_Screening(context, UtilityBLL.processNull(entity.tags, 0));
}
}
// Note: PlayList Important Terms
// isEnabled:
// ........... 0: Disabled PlayList
// ........... 1: Enable PlayList
// isapproved:
// ........... 0: Not approved
// ........... 1: Approved
// Privacy:
// ........... 0: Private
// ........... 1: Public
// Videos:
// Store Statistic for no of videos available in playlist
public static async Task <bool> Add(ApplicationDbContext context, string userid, string title)
{
if (Jugnoon.Settings.Configs.GeneralSettings.screen_content == 1)
{
title = DictionaryBLL.Process_Screening(context, title);
}
var _entity = new JGN_User_Playlists()
{
userid = userid,
title = title,
created_at = DateTime.Now
};
context.Entry(_entity).State = EntityState.Added;
await context.SaveChangesAsync();
return(true);
}
public void ProcessRequest(HttpContext context)
{
var json = new StreamReader(context.Request.InputStream).ReadToEnd();
var responseMsg = new Dictionary <string, string>();
bool isUpdate = false;
int Records = 0;
string Keywords = "";
string Text = "";
string Order = "";
int PageNumnber = 0;
var _dictionaryobj = new DictionaryBLL();
var _ld_dictionary = JsonConvert.DeserializeObject <Dictionary_Struct>(json);
var _ld_dictionary_data = new Dictionary <string, DictionaryObject>();
if ((context.Request.Params["action"] != null))
{
switch (context.Request.Params["action"])
{
case "add":
// Authentication
if (!context.User.Identity.IsAuthenticated)
{
responseMsg["status"] = "error";
responseMsg["message"] = "Authentication Failed";
context.Response.Write(responseMsg);
return;
}
DictionaryBLL.Add(_ld_dictionary.Value, _ld_dictionary.Type);
responseMsg["status"] = "success";
responseMsg["message"] = "Operation Commit";
context.Response.Write(responseMsg);
break;
case "delete":
DictionaryBLL.Delete(_ld_dictionary.ID);
responseMsg["status"] = "success";
responseMsg["message"] = "Operation Commit";
context.Response.Write(responseMsg);
break;
case "load":
DictionaryBLL.Load(_ld_dictionary.Type);
responseMsg["status"] = "success";
context.Response.Write(responseMsg);
break;
case "return_value":
DictionaryBLL.Return_Values(_ld_dictionary.Type);
responseMsg["status"] = "success";
context.Response.Write(responseMsg);
break;
case "process_screening":
if (context.Request.Params["text"] != null)
{
Text = context.Request.Params["text"].ToString();
}
DictionaryBLL.Process_Screening(Text);
responseMsg["status"] = "success";
context.Response.Write(responseMsg);
break;
case "is_match":
if (context.Request.Params["text"] != null)
{
Text = context.Request.Params["text"].ToString();
}
if (context.Request.Params["keywords"] != null)
{
Keywords = context.Request.Params["keywords"].ToString();
}
DictionaryBLL.isMatch(Text, Keywords);
responseMsg["status"] = "success";
context.Response.Write(responseMsg);
break;
case "validate_search_word":
if (context.Request.Params["text"] != null)
{
Text = context.Request.Params["text"].ToString();
}
DictionaryBLL.Validate_Search_Word(Text);
responseMsg["status"] = "success";
context.Response.Write(responseMsg);
break;
}
}
else
{
// No action found
responseMsg["status"] = "error";
responseMsg["message"] = "No action found";
context.Response.Write(JsonConvert.SerializeObject(responseMsg));
}
}