public ActionResult JsonAction2()
{
var mongoServSettings = new MongoDB.Driver.MongoServerSettings();
mongoServSettings.Server = new MongoDB.Driver.MongoServerAddress("localhost");
var mongoServer = new MongoDB.Driver.MongoServer(mongoServSettings);
mongoServer.Connect();
var db = mongoServer.GetDatabase("monitera");
var collection = db.GetCollection<db>("dbo.post");
//collection.Insert(new db { gender = "m"});
var pozitif = Query<db>.Where(f => f.sentimentid == 1);
var notr = Query<db>.Where(f => f.sentimentid == 2);
var negatif = Query<db>.Where(f => f.sentimentid == 3);
var poznotr = Query<db>.Where(f => f.sentimentid == 4);
var negnotr = Query<db>.Where(f => f.sentimentid == 5);
var poz = collection.Count(pozitif);
var no = collection.Count(notr);
var ne = collection.Count(negatif);
var pn = collection.Count(poznotr);
var nn = collection.Count(negnotr);
var oranlar = (new[]{
new{
Durum = "Pozitif",
value = poz
},
new {
Durum = "Nötr",
value = no
},
new {
Durum = "Negatif",
value = ne
},
new {
Durum = "Pozitif - Nötr",
value = pn
},
new {
Durum = "Negatif - Nötr",
value = nn
}
}
);
return Json(oranlar, JsonRequestBehavior.AllowGet);
}
#pragma warning restore
private TCommandResult RunCommandAs <TCommandResult>(
IMongoCommand command,
IBsonSerializer <TCommandResult> resultSerializer) where TCommandResult : CommandResult
{
var readerSettings = new BsonBinaryReaderSettings
{
Encoding = _settings.ReadEncoding ?? MongoDefaults.ReadEncoding,
GuidRepresentation = _settings.GuidRepresentation
};
var writerSettings = new BsonBinaryWriterSettings
{
Encoding = _settings.WriteEncoding ?? MongoDefaults.WriteEncoding,
GuidRepresentation = _settings.GuidRepresentation
};
var readPreference = _settings.ReadPreference;
if (readPreference != ReadPreference.Primary)
{
if (_server.ProxyType == MongoServerProxyType.Unknown)
{
_server.Connect();
}
if (_server.ProxyType == MongoServerProxyType.ReplicaSet && !CanCommandBeSentToSecondary.Delegate(command.ToBsonDocument()))
{
readPreference = ReadPreference.Primary;
}
}
var flags = (readPreference == ReadPreference.Primary) ? QueryFlags.None : QueryFlags.SlaveOk;
var commandOperation = new CommandOperation <TCommandResult>(
_name,
readerSettings,
writerSettings,
command,
flags,
null, // options
readPreference,
resultSerializer);
var connection = _server.AcquireConnection(readPreference);
try
{
return(commandOperation.Execute(connection));
}
finally
{
_server.ReleaseConnection(connection);
}
}
protected void btnGetConnlections_Click(object sender, EventArgs e)
{
BsonDocument docFind = new BsonDocument();
MongoDB.Driver.MongoServer server = MongoDB.Driver.MongoServer.Create(ConfigurationManager.AppSettings["mongoDBConfig"]);
server.Connect();
//获取指定数据库
MongoDB.Driver.MongoDatabase db = server.GetDatabase(ConfigurationManager.AppSettings["mongoDBName"].ToString());
string collection = txtCollection.Text.Trim();
//获取表
MongoDB.Driver.MongoCollection <BsonDocument> col = db.GetCollection <BsonDocument>(collection);
lblCollections.Text = "表大小:" + col.GetTotalDataSize() / (1024 * 1024) + "M";//db['119004logs'].totalIndexSize()+db['119004logs'].dataSize()
this.listBoxCollections.DataSource = col.Database.GetCollectionNames();
listBoxCollections.DataBind();
lblDataBaseCount.Text = "数据库大小为：" + db.GetStats().StorageSize / (1024 * 1024) + "M";
}
protected void btnGetIndex_Click(object sender, EventArgs e)
{
BsonDocument docFind = new BsonDocument();
MongoDB.Driver.MongoServer server = MongoDB.Driver.MongoServer.Create(ConfigurationManager.AppSettings["mongoDBConfig"]);
server.Connect();
//获取指定数据库
MongoDB.Driver.MongoDatabase db = server.GetDatabase(ConfigurationManager.AppSettings["mongoDBName"].ToString());
string collection = txtCollection.Text.Trim();
//获取表
MongoDB.Driver.MongoCollection <BsonDocument> col = db.GetCollection <BsonDocument>(collection);
GetIndexesResult indexsResult = col.GetIndexes();
string strIndexs = string.Empty;
for (int i = 0; i < indexsResult.Count; i++)
{
strIndexs += indexsResult[i].Key.ToString() + "；";
}
txtGetIndexs.Text = strIndexs;
}
public bool IsConnected()
{
if (m_Connected == false || m_Server.State != MongoServerState.Connected)
{
if (m_TryingToReconnect == false)
{
lock (m_Client)
{
if (m_TryingToReconnect == true)
{
return(false);
}
else
{
m_TryingToReconnect = true;
}
}
m_Connected = false;
(new System.Threading.Tasks.Task(() =>
{
try
{
m_Server.Connect();
if (m_Server.State == MongoServerState.Connected)
{
m_Connected = true;
}
}
catch (Exception)
{
}
lock (m_Client)
{
m_TryingToReconnect = false;
}
})).Start();
}
}
return(m_Connected == true && m_Server.State == MongoServerState.Connected);
}
public ActionResult JsonAction()
{
var mongoServSettings = new MongoDB.Driver.MongoServerSettings();
mongoServSettings.Server = new MongoDB.Driver.MongoServerAddress("localhost");
var mongoServer = new MongoDB.Driver.MongoServer(mongoServSettings);
mongoServer.Connect();
var db = mongoServer.GetDatabase("monitera");
var collection = db.GetCollection<db>("dbo.post");
//collection.Insert(new db { gender = "m"});
var erkek = Query<db>.Where( f => f.gender == "e");
var kadin = Query<db>.Where( f => f.gender == "k");
var erk = collection.Count(erkek);
var k = collection.Count(kadin);
var chartData = (new[]{
new{
Gender = "Male",
value = erk
},
new {
Gender = "Female",
value = k
}
}
);
return Json(chartData, JsonRequestBehavior.AllowGet);
}
public override void ActivateOptions()
{
try
{
var mongoConnectionString = new StringBuilder(string.Format("Server={0}:{1}", Host, Port));
if (!string.IsNullOrEmpty(UserName) && !string.IsNullOrEmpty(Password))
{
// use MongoDB authentication
mongoConnectionString.AppendFormat(";Username={0};Password={1}", UserName, Password);
}
connection = MongoServer.Create(mongoConnectionString.ToString());
connection.Connect();
var db = connection.GetDatabase(DatabaseName);
collection = db.GetCollection(CollectionName);
}
catch (Exception e)
{
ErrorHandler.Error("Exception while initializing MongoDB Appender", e, ErrorCode.GenericFailure);
}
}
public ActionResult JsonAction3()
{
var mongoServSettings = new MongoDB.Driver.MongoServerSettings();
mongoServSettings.Server = new MongoDB.Driver.MongoServerAddress("localhost");
var mongoServer = new MongoDB.Driver.MongoServer(mongoServSettings);
mongoServer.Connect();
var db = mongoServer.GetDatabase("monitera");
var collection = db.GetCollection<db>("dbo.post");
//collection.Insert(new db { gender = "m"});
var cs = Query<db>.Where(f => f.sourceid == 1);
var cs1 = Query<db>.Where(f => f.sourceid == 2);
var cs2 = Query<db>.Where(f => f.sourceid == 25);
var cs3 = Query<db>.Where(f => f.sourceid == 31);
var cs4 = Query<db>.Where(f => f.sourceid== 19);
var tw = collection.Count(cs);
var ff = collection.Count(cs1);
var face = collection.Count(cs2);
var rss = collection.Count(cs3);
var blog = collection.Count(cs4);
var kaynaklar = (new[]{
new{
Kaynak = "Twitter",
value = tw
},
new {
Kaynak = "FriendFeed",
value = ff
},
new {
Kaynak = "Facebook",
value = face
},
new {
Kaynak = "HaberRss",
value = rss
},
new {
Kaynak = "Blog",
value = blog
}
}
);
return Json(kaynaklar, JsonRequestBehavior.AllowGet);
}