public static Topics GetSingle(int Id)
{
Topics topic = null;
// 1) Create the connection
SqlConnection connection = new SqlConnection();
connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
// 2) Open the connection
connection.Open();
// 3) Execute query
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = string.Format("select * from topics where id = '{0}'", Id);
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.Read())
{
topic = new Topics();
topic.Id = Convert.ToInt32(dataReader["Id"]);
topic.Name = Convert.ToString(dataReader["Name"]);
topic.SubjectId = Convert.ToInt32(dataReader["SubjectId"]);
topic.BranchId = Convert.ToInt32(dataReader["BranchId"]);
if (dataReader["ParentId"] != DBNull.Value)
{
topic.ParentId = Convert.ToInt32(dataReader["ParentId"]);
}
topic.Subjects = SubjectsDA.GetSingle(topic.SubjectId);
topic.ParentTopics = TopicsDA.GetSingle(topic.ParentId);
}
// 4) Close the connection
connection.Close();
return(topic);
}
public async Task AddTopic(WebSocketTopic topic, CancellationToken cancellationToken = default)
{
var type = topic.GetType();
var fieldInfo = type.GetField(topic.ToString());
var attribute =
fieldInfo.GetCustomAttribute(typeof(WebSocketTopicStringValueAttribute), false) as WebSocketTopicStringValueAttribute;
Topics.Add(attribute.Value);
var addTopicObject = new
{
command = WebSocketCommands.AddTopics,
topics = new List <object>()
{
new { topic = attribute.Value }
}
};
await Send(JsonConvert.SerializeObject(addTopicObject), cancellationToken);
}
public void SaveATopic()
{
_topicTestName = Guid.NewGuid().ToString().Substring(0, 20);
var newTopic = new Topics()
{
Created_On = DateTime.Now,
TopicName = _topicTestName
};
using (var svc = new TopicServices())
{
svc.SaveTopic(newTopic);
}
using (var db = new TraqnoteEntities())
{
Assert.AreEqual(_topicTestName,
db.topics.FirstOrDefault(x => x.topic_name == _topicTestName).topic_name);
}
}
/// <summary>
/// 获取主题信息列表
/// </summary>
/// <param name="pageSize">页面大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="startNumber">置顶帖数量</param>
/// <returns></returns>
public List <TopicInfo> GetTopicInfoList(int pageSize, int pageIndex, int startNumber)
{
List <TopicInfo> topicList = new List <TopicInfo>();
if (orderStr == "" && direct == 1)
{
topicList = Topics.GetTopicList(forumid, pageSize, pageIndex, startNumber, 600, config.Hottopic, forum.Autoclose,
forum.Topictypeprefix, condition);
}
else
{
if (direct == 0 && orderStr == string.Empty)
{
orderStr = "lastpostid";
}
topicList = Topics.GetTopicList(forumid, pageSize, pageIndex, startNumber, 600, config.Hottopic, forum.Autoclose,
forum.Topictypeprefix, condition, orderStr, direct);
}
return(topicList);
}
/// <summary>
/// Trata de suscribir a un topic que recibe como parámetro
/// </summary>
/// <param name="topic"></param>
public static void Suscribir(Topic topic)
{
try
{
client.SubscribeAsync(topic.Nombre, (MQTTnet.Protocol.MqttQualityOfServiceLevel)topic.QOS);
//client.Subscribe(new string[] { topic.Nombre }, new byte[] { topic.QOS });
//Desuscribir(topic);
if (Topics.FirstOrDefault(x => x.Nombre == topic.Nombre && x.IdHandler == topic.IdHandler) != null)
{
}
else
{
Topics.Add(topic);
}
}
catch (Exception ex)
{
new Log().Escribir(ex);
}
}
//get random tweet with topic
public virtual Tweet getTweet(Topics topic)
{
List <Tweet> temp = new List <Tweet>();
foreach (Tweet tweet in this.Tweets)
{
if (tweet.Topic == topic)
{
temp.Add(tweet);
}
}
if (temp.Count == 0)
{
return(null);
}
else
{
return(temp[rand.Next(temp.Count - 1)]);
}
}
//get tweets with topic XY
public virtual List <Tweet> getTweetsWithTopic(Topics topic)
{
List <Tweet> temp = new List <Tweet>();
foreach (Tweet tweet in this.Tweets)
{
if (tweet.Topic == topic)
{
temp.Add(tweet);
}
}
if (temp.Count == 0)
{
return(null);
}
else
{
return(temp);
}
}
public async Task <IActionResult> OnGetAsync()
{
var topicsTask = LoadTopics();
var groupsTask = LoadGroups();
// load all in parallel
await Task.WhenAll(
topicsTask,
groupsTask
);
Topics = topicsTask.Result;
Sequences = groupsTask.Result;
var title = Topics.Select(t => t.Title).ToDelimitedString("; ");
// shared layout title
ViewData["TopicTitle"] = $" - {title}";
return(Page());
}
public async Task <ActionResult <Topics> > PostTopics(Topics topics)
{
_context.Topics.Add(topics);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (TopicsExists(topics.TopicId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetTopics", new { id = topics.TopicId }, topics));
}
/// <summary>
/// Add a new internal topic.
/// </summary>
/// <param name="name">Topic Name</param>
/// <param name="topicCreationConfig"></param>
public KafkaStreamOptions AddTopic(string name, TopicCreationConfig topicCreationConfig = null)
{
var config = new TopicConfig {
IsExternal = false, Name = name
};
if (topicCreationConfig != null)
{
config.AutoCreate = topicCreationConfig.AutoCreate;
config.Partitions = topicCreationConfig.Partitions;
config.ReplicationFactor = topicCreationConfig.ReplicationFactor;
if (topicCreationConfig.RetentionPeriodInMs.HasValue)
{
config.RetentionPeriodInMs = topicCreationConfig.RetentionPeriodInMs;
}
}
Topics.Add(config);
return(this);
}
private void AllDelete_Click(object sender, EventArgs e)
{
#region 全部删除
if (this.CheckCookie())
{
string topiclist = "";
DataTable dt = Topics.GetAuditTopicList(ViewState["condition"].ToString());
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
topiclist += dr["tid"].ToString() + ",";
}
TopicAdmins.DeleteTopics(topiclist.TrimEnd(','), false);
}
this.RegisterStartupScript("", "<script>alert('提交成功');window.location.href='forum_auditingtopic.aspx';</script>");
}
#endregion
}
/// <summary>
/// Add a new external topic.
/// </summary>
/// <param name="type">The data type that this contract will use.</param>
/// <param name="name">Topic Name</param>
/// <param name="topicCreationConfig"></param>
public KafkaStreamOptions AddExternalTopic(
Type type,
string name,
TopicCreationConfig topicCreationConfig = null
)
{
var config = new TopicConfig {
IsExternal = true, Name = name, ExternalContractType = type
};
if (topicCreationConfig != null)
{
config.AutoCreate = topicCreationConfig.AutoCreate;
config.Partitions = topicCreationConfig.Partitions;
config.ReplicationFactor = topicCreationConfig.ReplicationFactor;
}
Topics.Add(config);
return(this);
}
/// <summary>
/// Publishes a new message to the specified event on the bus.
/// </summary>
/// <param name="message">The message to publish.</param>
public virtual Task Publish(Message message)
{
if (message == null)
{
throw new ArgumentNullException("message");
}
Topic topic;
if (Topics.TryGetValue(message.Key, out topic))
{
topic.Store.Add(message);
ScheduleTopic(topic);
}
Counters.MessageBusMessagesPublishedTotal.Increment();
Counters.MessageBusMessagesPublishedPerSec.Increment();
return(TaskAsyncHelper.Empty);
}
private void SelectPass_Click(object sender, EventArgs e)
{
#region 对选中的主题设置为通过审核
if (this.CheckCookie())
{
string tidlist = DNTRequest.GetString("tid");
if (tidlist != "")
{
//UpdateUserCredits(tidlist);
Topics.PassAuditNewTopic(tidlist);
base.RegisterStartupScript("", "<script>window.location='forum_auditnewtopic.aspx';</script>");
}
else
{
base.RegisterStartupScript("", "<script>alert('您未选中任何选项');window.location='forum_auditnewtopic.aspx';</script>");
}
}
#endregion
}
/// <summary>
/// 新增
/// </summary>
public void AddTopics()
{
string author = Request["author"];
string title = Request["title"];
string content = Request["content"];
if (string.IsNullOrEmpty(author))
{
author = "匿名";
}
Topics one = new Topics();
one.Title = title.Trim();
one.Author = author.Trim();
one.Content = content.Trim();
one.UserHostAddress = System.Web.HttpContext.Current.Request.UserHostAddress;
one.AddDate = DateTime.Now;
one.LastModifyDate = DateTime.Now;
one.UserName = System.Web.HttpContext.Current.User.Identity.Name;
topicsService.AddEntity(one);
}
private void LoadTopics()
{
if (TopicsInitialize())
{
string query = "SELECT * FROM `Topics`;";
var reader_temp = SQL.ExecuteQuery(query);
MySqlDataReader reader;
if (reader_temp.Item2)
{
reader = reader_temp.Item1;
DataTable dt = new DataTable();
dt.Load(reader);
string topic;
foreach (DataRow row in dt.Rows)
{
topic = row["Topic"].ToString();
Topics.Add(topic);
}
}
}
}
public static IQueryable <dynamic> GetTopics(Topics searchCrit)
{
BDIIDataContext dc = new BDIIDataContext();
var res = from el in dc.Topics
join ol in dc.Teachers on el.TeacherID equals ol.ID
join il in dc.Users on ol.UserID equals il.ID
where
((el.ID == searchCrit.ID) || (searchCrit.ID == 0))
&&
(el.Title.StartsWith(searchCrit.Title) || string.IsNullOrEmpty(searchCrit.Title))
select new
{
el.ID,
el.Title,
el.Status,
il.Name,
il.Surname
};
return(res);
}
protected void TopicViewItemCommand(object sender, FormViewCommandEventArgs e)
{
switch (e.CommandName)
{
case "prev":
_topic = Topics.GetNextPrevTopic(_topic.Id, "prev");
if (Session["TOPIC"].ToString() != _topic.Id.ToString())
{
Response.Redirect("~/Content/Forums/topic.aspx?TOPIC=" + _topic.Id, true);
}
break;
case "next":
_topic = Topics.GetNextPrevTopic(_topic.Id, "next");
if (Session["TOPIC"].ToString() != _topic.Id.ToString())
{
Response.Redirect("~/Content/Forums/topic.aspx?TOPIC=" + _topic.Id, true);
}
break;
}
}
public void DeletePost(string topicid, string replyid, string jsonform)
{
var form = HttpUtility.UrlDecode(jsonform);
System.Collections.Specialized.NameValueCollection formresult = HttpUtility.ParseQueryString(form);
string reason = formresult["ctl00$txtReason"];
int adminmodid = Convert.ToInt32(formresult["ctl00$hdnModerator"]);
if (!String.IsNullOrEmpty(topicid))
{
Topics.Delete(Convert.ToInt32(topicid));
}
if (!String.IsNullOrEmpty(replyid))
{
Replies.DeleteReply(Convert.ToInt32(replyid));
}
if (!string.IsNullOrEmpty(reason) && Config.UseEmail)
{
ProcessModeration(1, Convert.ToInt32(topicid), Convert.ToInt32(replyid), adminmodid, reason);
}
}
public static bool Add(Topics topic)
{
// 1) Create the connection
SqlConnection connection = new SqlConnection();
connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnection"].ConnectionString;
// 2) Open the connection
connection.Open();
// 3) Execute query
SqlCommand command = new SqlCommand();
command.Connection = connection;
if (topic.ParentId == 0)
{
command.CommandText = string.Format("insert into topics(name,subjectid,branchId,parentid) values('{0}','{1}','{2}',NULL)", topic.Name, topic.SubjectId, topic.BranchId);
}
if (topic.ParentId != 0)
{
command.CommandText = string.Format("insert into topics(name,subjectid,parentid,branchId) values('{0}','{1}','{2}','{3}')", topic.Name, topic.SubjectId, topic.ParentId, topic.BranchId);
}
int rowsAffected = command.ExecuteNonQuery();
// 4) Close the connection
connection.Close();
if (rowsAffected == 0)
{
return(false);
}
else
{
return(true);
}
}
internal Topic GetTopic(string key)
{
Topic topic;
int oldState;
do
{
if (BeforeTopicCreated != null)
{
BeforeTopicCreated(key);
}
topic = Topics.GetOrAdd(key, _createTopic);
if (BeforeTopicMarked != null)
{
BeforeTopicMarked(key, topic);
}
// If the topic was dying revive it to the NoSubscriptions state. This is used to ensure
// that in the scaleout case that even if we're publishing to a topic with no subscriptions
// that we keep it around in case a user hops nodes.
oldState = Interlocked.CompareExchange(ref topic.State, TopicState.NoSubscriptions, TopicState.Dying);
if (AfterTopicMarked != null)
{
AfterTopicMarked(key, topic, topic.State);
}
// If the topic is currently dead then we're racing with the DestroyTopicCore function, therefore
// loop around until we're able to create a new topic
} while (oldState == TopicState.Dead);
if (AfterTopicMarkedSuccessfully != null)
{
AfterTopicMarkedSuccessfully(key, topic);
}
return(topic);
}
public ActionResult EliminarTop(string name)
{
Session["UserIDG"] = Session["UserIDG"];
Session["UserID"] = Session["UserID"];
Session["User"] = Session["User"];
string texto = "Estas seguro de Eliminar el topic?";
string titulo = "Eliminar Topic";
MessageBoxButtons button = MessageBoxButtons.YesNoCancel;
MessageBoxIcon icon = MessageBoxIcon.Question;
DialogResult result = MessageBox.Show(texto, titulo, button, icon);
Comments comments = new Comments();
Topics topic = new Topics();
topic = topic.getTopicsByName(name);
if (result.Equals(System.Windows.Forms.DialogResult.Yes))
{
if (!comments.DeleteCommentsByIDTopic(topic.id_topic))
{
MessageBox.Show("Comentario de " + topic.id_topic + "no eliminado");
return(Redirect("GeneralCat"));
}
String sql = "Delete from Topic where nameTopic = '" + name + "'";
int retorno = 0;
using (SqlConnection connection = BD.getConnection())
{
SqlCommand Comando = new SqlCommand(string.Format(sql), connection);
retorno = Comando.ExecuteNonQuery();
connection.Close();
}
if (retorno > 0)
{
MessageBox.Show("Topic Borrado Con Exito!!", "Eliminado", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("No se pudo borrar el Topic", "Fallo!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
return(RedirectToAction("GeneralCat", new { name = Session["CatName"] }));
}
protected virtual void Dispose(bool disposing)
{
if (disposing && _gcRunning != GCState.Disposed)
{
// Stop the broker from doing any work
_broker.Dispose();
// Spin while we wait for the timer to finish if it's currently running
while (Interlocked.CompareExchange(ref _gcRunning, GCState.Disposed, GCState.Idle) == GCState.Running)
{
Thread.Sleep(250);
}
// Remove all topics
Topics.Clear();
if (_gcTimer != null)
{
_gcTimer.Dispose();
}
}
}
private async void StartStudy()
{
if (CurrentStudy == null || (CurrentStudy.CurrentState != TwitterStudyStates.Pending &&
CurrentStudy.CurrentState != TwitterStudyStates.Revision))
{
MessageBox.Show("Only can start a service when it is pending or in a revision");
return;
}
StartOperation("Starting Study");
try
{
await
_service.StartStudyAsync(new StartStudyRequest(CurrentStudy.Id, Topics.Split(','), Time, EmployeeId));
await LoadEmployeeData();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
StopOperation();
}
// POST: api/Topics
public IHttpActionResult Post(Topics topic)
{
// using (var conn = new NpgsqlConnection("Host = localhost; Port = 5432; Username = postgres; Database = invokeTest; "))
using (var conn = new NpgsqlConnection("Host = localhost; Port = 5555; Username = db_201617z_va_proekt_invoke_mk_owner; Password = invoke_finki; Database = db_201617z_va_proekt_invoke_mk"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
// Insert some data
cmd.CommandText = "INSERT INTO invoke.topics " +
"(topicsname,topicsdescription,topicsdatewithtime,usersid,forumsid) " +
$"VALUES('{topic.TopicName}','{topic.TopicDescription}','NOW()',{topic.UserID},{topic.ForumID});";
cmd.ExecuteNonQuery();
}
return(Ok("Added topic"));
}
}
/// <summary>
/// 更新主题相关信息
/// </summary>
/// <param name="postmessage"></param>
private void UpdateTopicInfo(string postmessage)
{
int hide = (ForumUtils.IsHidePost(postmessage) && usergroupinfo.Allowhidecode == 1) ? 1 : 0;
if (hide == 1 && topic.Hide != 1)
{
topic.Hide = hide;
Topics.UpdateTopicHide(topicid);
}
//更新topic的attention为0
if (Moderators.IsModer(useradminid, userid, topic.Fid) && topic.Attention == 1)
{
Topics.UpdateTopicAttentionByTidList(topicid.ToString(), 0);
}
else if (topic.Posterid != -1 && userid == topic.Posterid)
{
Topics.UpdateTopicAttentionByTidList(topicid.ToString(), 1);
}
Topics.UpdateTopicReplyCount(topicid);
}
public ActionResult GeneralCat(string name)
{
Session["UserIDG"] = Session["UserIDG"];
Session["UserID"] = Session["UserID"];
Session["User"] = Session["User"];
Session["CatName"] = name;
Categorias cat = new Categorias();
int id = cat.getIDCatName(name);
List <Topics> topics = new List <Topics>();
Topics top = new Topics();
List <string> items = new List <string>();
topics = top.getAllTopicsByCatID(id);
for (int i = 0; i < topics.Count; i++)
{
items.Add(topics[i].name);
}
ViewBag.Items = items;
ViewData["TCount"] = topics.Count;
return(View());
}
private void AddTopics(Topics topic, TreeNodeCollection nodes)
{
TreeNode node = new TreeNode();
node.Text = topic.Name;
int TopicId = topic.Id;
node.NavigateUrl = string.Format("~/User/Download.aspx?Id={0}&branch={1}", TopicId, branchId);
nodes.Add(node);
// Get current topic's children
List <Topics> children = TopicsBL.GetAllByTopics(topic.Id);
if (children.Count > 1)
{
foreach (Topics childTopic in children)
{
AddTopics(childTopic, node.ChildNodes);
}
}
}
/// <summary>
/// 设置查询条件
/// </summary>
private void SetCondition()
{
#region 对搜索条件进行检索
condition = Topics.GetTopicCountCondition(out type, DNTRequest.GetString("type", true), newtopic);
if (forumid > 0)
{
condition += " AND fid =" + forumid;
}
else
{
//验证重新生成的版块id列表是否合法(需要放入sql语句查询)
if (!Utils.IsNumericList(forums))
{
AddErrLine("版块ID不合法或没有该版块访问权限");
}
condition += " AND fid IN(" + forums + ")";
}
#endregion
}
public async Task <IActionResult> Create([Bind("TopicName,Description,StartDate,EndDate, isFeatured, Rules")] TopicViewModel model, string returnUrl = null)
{
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
var rules = model.Rules;
var request = new SearchRequest
{
Query = ElasticsearchQueryBuilder.QueryBuilder(JObject.Parse(rules)),
Size = 50
};
var topic = new Topics
{
TopicName = model.TopicName,
Description = model.Description,
DateCreated = DateTime.Now,
StartDate = model.StartDate,
EndDate = model.EndDate,
Rules = model.Rules,
ESRequest = _client.RequestResponseSerializer.SerializeToString(request),
isFeatured = model.isFeatured
};
try
{
_context.Add(topic);
var result = await _context.SaveChangesAsync();
}
catch (DbUpdateException /* ex */)
{
//Log the error (uncomment ex variable name and write a log.)
ModelState.AddModelError("", "Unable to save changes. " +
"Try again, and if the problem persists, " +
"see your system administrator.");
}
}
StatusMessage = "Thêm mới chủ đề thành công!";
return(RedirectToAction(nameof(Index)));
//return View("Index", model);
}