public static SafeModeResult UpdateOne <T>(string connectionString, string databaseName, string collectionName, T entity)
        {
            MongoServer server = MongoServer.Create(connectionString);

            //获取数据库或者创建数据库(不存在的话)。
            MongoDatabase database = server.GetDatabase(databaseName);

            SafeModeResult result;

            using (server.RequestStart(database))//开始连接数据库。
            {
                MongoCollection <BsonDocument> myCollection = database.GetCollection <BsonDocument>(collectionName);

                result = myCollection.Save(entity);
            }

            return(result);
        }
Exemple #2
0
        public void Where_Contains_RegularExpression()
        {
            string      connectionString = "mongodb://localhost";
            MongoServer server           = MongoServer.Create(connectionString);
            var         database         = server.GetDatabase("MongoDBTests");

            var          data = database.GetCollection("Where_BsonJavascript");
            BsonDocument doc  = new BsonDocument();

            doc["value"] = "ab'|cdef";
            data.Insert(doc);

            var query = QueryBuilder.Query.Matches("value", new BsonRegularExpression(Regex.Escape("ab'|c"), "i"));

            doc = data.Find(query).FirstOrDefault();
            Assert.IsNotNull(doc);
            Assert.AreEqual("ab'|cdef", doc["value"].ToString());
        }
Exemple #3
0
        public void TestUploadStreamFile2GridFS()
        {
            var server = MongoServer.Create("mongodb://*****:*****@"D:\Download\FileTestUpload\Hello2.txt", FileMode.Open, FileAccess.Read);

            System.IO.Stream strm = fs;

            MongoGridFS file            = new MongoGridFS(db);
            MongoGridFSCreateOptions op = new MongoGridFSCreateOptions();

            op.Aliases = new string[] { "Home" };

            var upFile = file.Upload(strm, "SayHi", op);

            Console.WriteLine("MD5: {0}", upFile.MD5);
        }
Exemple #4
0
 public MongoRepository(string connectionString, string dbName, string collectionName)
 {
     ConnectionString = connectionString;
     DatabaseName     = dbName;
     CollectionName   = collectionName;
     try
     {
         server     = MongoServer.Create(connectionString);
         database   = server.GetDatabase(dbName, SafeMode.True);
         collection = database.GetCollection(collectionName);
         server.Ping();
     }
     catch
     {
         throw new Exception("Проблема с сервером БД");
         //return null;
     }
 }
        public static Station GetCurrentStation(ObjectId RideId)
        {
            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);
            var db = server.GetDatabase("TransportSystem");

            var collectionRide = db.GetCollection <Ride>("Ride");

            var Ride = (from r in collectionRide.AsQueryable <Ride>() where r.Id == RideId select r).FirstOrDefault();

            if (Ride == null)
            {
                return(null);
            }
            var Station = Ride.CurrentStation != null?db.FetchDBRefAs <Station>(Ride.CurrentStation) : null;

            return(Station);
        }
Exemple #6
0
        public void Where_Contains_Javascript()
        {
            string      connectionString = "mongodb://localhost";
            MongoServer server           = MongoServer.Create(connectionString);
            var         database         = server.GetDatabase("MongoDBTests");

            var          data = database.GetCollection("Where_BsonJavascript");
            BsonDocument doc  = new BsonDocument();

            doc["value"] = "abcdef";
            data.Insert(doc);

            var query = QueryBuilder.Query.Where(new BsonJavaScript("this.value.toString().toLowerCase().indexOf('abc') != -1"));

            doc = data.Find(query).FirstOrDefault();
            Assert.IsNotNull(doc);
            Assert.AreEqual("abcdef", doc["value"].ToString());
        }
        public void GetDataFromReplica()
        {
            var server = MongoServer.Create("mongodb://PC_011:10001,PC_011:10002,PC_011:10003");

            var db    = server.GetDatabase("test");
            var posts = db.GetCollection("foo");

            var where = Query.EQ("age", 245774);

            var list = posts.Find(where).ToList();

            Console.WriteLine("Count: {0}", list.Count());

            //foreach (var item in list)
            //{
            //    Console.WriteLine("---- data: {0}", item[1]);
            //}
        }
Exemple #8
0
        private void button2_Click(object sender, EventArgs e)
        {
            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);
            var db = server.GetDatabase("kosarka");

            var collection = db.GetCollection <Kosarkas>("kosarkasi");

            var query = Query.And(
                Query.EQ("ime", textBox1.Text),
                Query.EQ("prezime", textBox2.Text)
                );

            //      string sl = pictureBox1.ImageLocation;

            Image img = pictureBox1.Image;

            byte[] bytes = (byte[])(new ImageConverter()).ConvertTo(img, typeof(byte[]));

            if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && textBox4.Text != "" && textBox5.Text != "" && textBox6.Text != "" && textBox7.Text != "" && img != null)
            {
                var update = MongoDB.Driver.Builders.Update.Set("pozicija", textBox3.Text)
                             .Set("brojnadresu", textBox4.Text)
                             .Set("visina", textBox5.Text)
                             .Set("tezina", textBox6.Text)
                             .Set("koledz", textBox7.Text)
                             .Set("slika", bytes);
                collection.Update(query, update);

                textBox1.Text     = "";
                textBox2.Text     = "";
                textBox3.Text     = "";
                textBox4.Text     = "";
                textBox5.Text     = "";
                textBox6.Text     = "";
                textBox7.Text     = "";
                pictureBox1.Image = null;
            }

            else
            {
                MessageBox.Show("Popuni sva polja ime/prezime/pozicija/broj na dresu/visina/tezina/koledz/slika) !!");
            }
        }
Exemple #9
0
        private void button4_Click(object sender, EventArgs e)
        {
            placeholderLbl.Visible = false;
            dataGridView1.Visible  = true;

            igracOpcija2Pnl.BackColor = System.Drawing.Color.FromArgb(253, 185, 39);
            igracOpcija1Pnl.BackColor = igracOpcija3Pnl.BackColor = igracOpcija4Pnl.BackColor = igracOpcija5Pnl.BackColor = System.Drawing.Color.Transparent;

            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);
            var db = server.GetDatabase("kosarka");

            var collection = db.GetCollection("kosarkasi");

            var query =
                from kosarkasi in collection.AsQueryable <Kosarkas>()
                where kosarkasi.pozicija == textBox8.Text
                orderby kosarkasi.ime, kosarkasi.prezime
            select kosarkasi;


            dataGridView1.Rows.Clear();
            dataGridView1.ColumnCount     = 3;
            dataGridView1.Columns[0].Name = "Ime";
            dataGridView1.Columns[1].Name = "Prezime";
            dataGridView1.Columns[2].Name = "Klub";

            string nazivkluba;

            foreach (Kosarkas kos in query)
            {
                if (kos.Klub != null)
                {
                    Klub klub = db.FetchDBRefAs <Klub>(kos.Klub);
                    nazivkluba = klub.naziv;
                }
                else
                {
                    nazivkluba = "";
                }

                dataGridView1.Rows.Add(kos.ime, kos.prezime, nazivkluba);
            }
        }
Exemple #10
0
        private void connectBtn_Click(object sender, EventArgs e)
        {
            if (dbNameTxtBox.Text == "")
            {
                MessageBox.Show("Please enter database name!");
                dbStatusLbl.Text = "Connection error!";
                return;
            }

            if (collectionNameTxtBox.Text == "")
            {
                MessageBox.Show("Please enter collection name!");
                dbStatusLbl.Text = "Connection error!";
                return;
            }

            try
            {
                System.Diagnostics.Process.Start("mongod.exe"); //Preparing
                server = MongoServer.Create(connectionString);  //Connect to server
                if (server.DatabaseExists(dbNameTxtBox.Text))
                {
                    database = server.GetDatabase(dbNameTxtBox.Text); //Get database that name is taken from user
                    if (database.CollectionExists(collectionNameTxtBox.Text))
                    {
                        collection        = database.GetCollection <BsonDocument>(collectionNameTxtBox.Text);
                        dbStatusLbl.Text  = "Mongodb is ready.";
                        groupBox2.Enabled = true;
                    }
                    else
                    {
                        dbStatusLbl.Text = "Collection does not exist.";
                    }
                }
                else
                {
                    dbStatusLbl.Text = "Database does not exist.";
                }
            }
            catch (Exception)
            {
                dbStatusLbl.Text = "Connection error!";
            }
        }
Exemple #11
0
        public void CastTest()
        {
            var server     = MongoServer.Create();
            var db         = server.GetDatabase("test");
            var collection = db.GetCollection <Base>("castTest");

            collection.Drop();

            var t1 = new T1 {
                Id = Guid.NewGuid(), A = "T1.A", B = "T1.B"
            };
            var t2 = new T2 {
                Id = Guid.NewGuid(), A = "T2.A"
            };

            collection.Insert(t1);
            collection.Insert(t2);

            var query = from t in collection.AsQueryable()
                        where t is T1 && ((T1)t).B == "T1.B"
                        select t;

            var translatedQuery = MongoQueryTranslator.Translate(query);

            Assert.IsInstanceOf <SelectQuery>(translatedQuery);
            Assert.AreSame(collection, translatedQuery.Collection);
            Assert.AreSame(typeof(Base), translatedQuery.DocumentType);

            var selectQuery = (SelectQuery)translatedQuery;

            Assert.AreEqual("(Base t) => ((t is T1) && ((T1)t.B == \"T1.B\"))", ExpressionFormatter.ToString(selectQuery.Where));
            Assert.IsNull(selectQuery.OrderBy);
            Assert.IsNull(selectQuery.Projection);
            Assert.IsNull(selectQuery.Skip);
            Assert.IsNull(selectQuery.Take);

            Assert.AreEqual("{ \"_t\" : \"T1\", \"B\" : \"T1.B\" }", selectQuery.BuildQuery().ToString());

            var results = query.ToList();

            Assert.That(results.Count, Is.EqualTo(1));
            Assert.That(results[0], Is.InstanceOf(typeof(T1)));
            Assert.That(results[0].A, Is.EqualTo("T1.A"));
        }
        private void btnObrisi_Click(object sender, EventArgs e)
        {
            if (listaZaposlenih.SelectedItems.Count == 0)
            {
                MessageBox.Show("Izaberite zaposlenog koga zelite da obrisete!", "Obavestenje", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            DialogResult msgResult = MessageBox.Show("Da li ste sigurni da zelite da izvrsite brisanje?", "Upit", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (msgResult == DialogResult.Yes)
            {
                String id = listaZaposlenih.SelectedItems[0].SubItems[0].Text;

                var connectionString = "mongodb://localhost/?safe=true";
                var server           = MongoServer.Create(connectionString);
                var db = server.GetDatabase("MongoNBP");

                var collectionStanice   = db.GetCollection <VremenskaStanica>("vremenske_stanice");
                var collectionZaposleni = db.GetCollection <Zaposleni>("korisnici");
                var query = Query.EQ("_id", new ObjectId(id));

                var              result = collectionZaposleni.Find(query).ToList <Zaposleni>();
                Zaposleni        z      = result[0];
                VremenskaStanica s      = db.FetchDBRefAs <VremenskaStanica>(z.VremenskaStanica);
                foreach (MongoDBRef zaposleniRef in s.Odgovorni.ToList())
                {
                    Zaposleni tmp = db.FetchDBRefAs <Zaposleni>(zaposleniRef);
                    if (tmp != null && z.Id == tmp.Id)
                    {
                        s.Odgovorni.Remove(zaposleniRef);
                    }
                }
                collectionStanice.Save <VremenskaStanica>(s);
                collectionZaposleni.Remove(query);

                MessageBox.Show("Uspesno ste obrisali vremensku stanicu!", "Obavestenje", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.PopuniTabeluOdgPodacima();
            }
            else
            {
                return;
            }
        }
        public List <xmlDataSources> findALLStatus_Server()
        {
            try
            {
                List <xmlDataSources> ClaimReport_Server = new List <xmlDataSources>();

                MongoServer     server      = MongoServer.Create(connectionString);
                MongoDatabase   db1         = server.GetDatabase(DB_NAME);
                MongoCollection collection1 = db1.GetCollection("KM_BiotechnologyXML_XmlStaus");
                MongoCollection <BsonDocument> employees = db1.GetCollection <BsonDocument>("KM_BiotechnologyXML_XmlStaus");

                foreach (BsonDocument emp in employees.FindAll())
                {
                    xmlDataSources item = new xmlDataSources();

                    #region 数据
                    if (emp.Contains("_id"))
                    {
                        item.Id = (emp["_id"].ToString());
                    }
                    if (emp.Contains("Rack_ID"))
                    {
                        item.Rack_ID = (emp["Rack_ID"].ToString());
                    }

                    if (emp.Contains("Input_Date"))
                    {
                        item.Input_Date = (emp["Input_Date"].AsString);
                    }

                    #endregion

                    ClaimReport_Server.Add(item);
                }
                return(ClaimReport_Server);
            }
            catch (Exception ex)
            {
                MessageBox.Show("信息读取异常, 请检查网络或IP是否正确配置" + ex);
                return(null);

                throw ex;
            }
        }
Exemple #14
0
        /// <summary>
        /// When overridden in a derived class, deletes all user-profile data for profiles in which the last activity date occurred before the specified date.
        /// </summary>
        /// <param name="authenticationOption">One of the <see cref="T:System.Web.Profile.ProfileAuthenticationOption"/> values, specifying whether anonymous, authenticated, or both types of profiles are deleted.</param>
        /// <param name="userInactiveSinceDate">A <see cref="T:System.DateTime"/> that identifies which user profiles are considered inactive. If the <see cref="P:System.Web.Profile.ProfileInfo.LastActivityDate"/>  value of a user profile occurs on or before this date and time, the profile is considered inactive.</param>
        /// <returns>
        /// The number of profiles deleted from the data source.
        /// </returns>
        public override int DeleteInactiveProfiles(ProfileAuthenticationOption authenticationOption, DateTime userInactiveSinceDate)
        {
            int deleteCount = 0;

            MongoServer   server     = MongoServer.Create(connectionString); // connect to the mongoDB url.
            MongoDatabase ProviderDB = server.GetDatabase(pMongoProviderDatabaseName, SafeMode.True);

            MongoCollection <BsonDocument> profiles = ProviderDB.GetCollection(pMongoProviderProfileCollectionName);


            try
            {
                var query = Query.And(Query.EQ("ApplicationNameLowerCase", pApplicationName.ToLower()),
                                      Query.LTE("LastActivityDate", userInactiveSinceDate));

                switch (authenticationOption)
                {
                case ProfileAuthenticationOption.Anonymous:
                    query = Query.And(query, Query.EQ("IsAnonymous", true));
                    break;

                case ProfileAuthenticationOption.Authenticated:
                    query = Query.And(query, Query.EQ("IsAnonymous", false));
                    break;

                default:
                    break;
                }
            }
            catch (Exception e)
            {
                if (WriteExceptionsToEventLog)
                {
                    WriteToEventLog(e, "DeleteInactiveProfiles");
                    throw new ProviderException(exceptionMessage, e);
                }
                else
                {
                    throw e;
                }
            }

            return(deleteCount);
        }
        /// <summary>
        /// 数据添加
        /// <para>多个添加</para>
        /// <remarks>数据库不存在创建数据库</remarks>
        /// </summary>
        /// <typeparam name="T">泛型对象</typeparam>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <param name="databaseName">数据库名称</param>
        /// <param name="collectionName">集合名称</param>
        /// <param name="entitys">实体对象集合</param>
        /// <returns>安全模式的结果集合</returns>
        public static IEnumerable <SafeModeResult> Insert <T>(string connectionString, string databaseName, string collectionName, IEnumerable <T> entitys)
        {
            if (string.IsNullOrEmpty(connectionString) ||
                string.IsNullOrEmpty(databaseName) ||
                string.IsNullOrEmpty(collectionName) ||
                null == entitys)
            {
                return(null);
            }
            IEnumerable <SafeModeResult> result;
            MongoServer   server   = MongoServer.Create(connectionString);
            MongoDatabase database = server.GetDatabase(databaseName);

            using (server.RequestStart(database)) {
                MongoCollection <BsonDocument> myCollection = database.GetCollection <BsonDocument>(collectionName);
                result = myCollection.InsertBatch(entitys);
            }
            return(result);
        }
        /// <summary>
        /// 数据更新
        /// <para>实体更新</para>
        /// <remarks>数据库不存在创建数据库</remarks>
        /// </summary>
        /// <typeparam name="T">泛型对象</typeparam>
        /// <param name="connectionString">数据库连接字符串</param>
        /// <param name="databaseName">数据库名称</param>
        /// <param name="collectionName">集合名称</param>
        /// <param name="entity">实体对象</param>
        /// <returns>安全模式的结果</returns>
        public static SafeModeResult Update <T>(string connectionString, string databaseName, string collectionName, T entity)
        {
            if (string.IsNullOrEmpty(connectionString) ||
                string.IsNullOrEmpty(databaseName) ||
                string.IsNullOrEmpty(collectionName) ||
                null == entity)
            {
                return(null);
            }
            MongoServer    server   = MongoServer.Create(connectionString);
            MongoDatabase  database = server.GetDatabase(databaseName);
            SafeModeResult result;

            using (server.RequestStart(database)) {
                MongoCollection <BsonDocument> myCollection = database.GetCollection <BsonDocument>(collectionName);
                result = myCollection.Save(entity);
            }
            return(result);
        }
Exemple #17
0
        public void Knjige()
        {
            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);
            var database         = server.GetDatabase("Biblioteka");

            var collection = database.GetCollection <Knjiga>("knjige");

            MongoCursor <Knjiga> knjige = collection.FindAll();

            List <Knjiga> listaKnjiga = new List <Knjiga>();

            foreach (Knjiga k in knjige.ToArray <Knjiga>())
            {
                listaKnjiga.Add(k);
            }
            dataGridView1.DataSource = listaKnjiga;
            Sakrij();
        }
Exemple #18
0
        public static IEnumerable <SafeModeResult> InsertAll <T>(string connectionString, string databaseName, string collectionName, IEnumerable <T> entitys)
        {
            IEnumerable <SafeModeResult> result = null;

            if (null == entitys)
            {
                return(null);
            }
            MongoServer server = MongoServer.Create(connectionString);
            //获取数据库或者创建数据库(不存在的话)。
            MongoDatabase database = server.GetDatabase(databaseName);

            using (server.RequestStart(database))//开始连接数据库。
            {
                MongoCollection <BsonDocument> myCollection = database.GetCollection <BsonDocument>(collectionName);
                result = myCollection.InsertBatch(entitys);
            }
            return(result);
        }
Exemple #19
0
        /// <summary>
        ///
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="connectionString"></param>
        /// <param name="databaseName"></param>
        /// <param name="collectionName"></param>
        /// <param name="query">条件查询。 调用示例:Query.Matches("Title", "感冒") 或者 Query.EQ("Title", "感冒") 或者Query.And(Query.Matches("Title", "感冒"),Query.EQ("Author", "yanc")) 等等</param>
        /// <param name="update">更新设置。调用示例:Update.Set("Title", "yanc") 或者 Update.Set("Title", "yanc").Set("Author", "yanc2") 等等</param>
        /// <returns></returns>
        public static SafeModeResult UpdateAll <T>(string connectionString, string databaseName, string collectionName, IMongoQuery query, IMongoUpdate update)
        {
            SafeModeResult result;

            if (null == query || null == update)
            {
                return(null);
            }
            MongoServer server = MongoServer.Create(connectionString);
            //获取数据库或者创建数据库(不存在的话)。
            MongoDatabase database = server.GetDatabase(databaseName);

            using (server.RequestStart(database))//开始连接数据库。
            {
                MongoCollection <BsonDocument> myCollection = database.GetCollection <BsonDocument>(collectionName);
                result = myCollection.Update(query, update, UpdateFlags.Multi);
            }
            return(result);
        }
Exemple #20
0
        public void Query()
        {
            string      connectionString = "mongodb://localhost";
            MongoServer server           = MongoServer.Create(connectionString);
            var         database         = server.GetDatabase("MongoDBTests");

            var          data = database.GetCollection("Where_BsonJavascript");
            BsonDocument doc  = new BsonDocument();

            doc["value"] = 10;

            data.Insert(doc);

            var query = QueryBuilder.Query.GT("value", BsonValue.Create(9)).LT(BsonValue.Create(11));

            doc = data.Find(query).FirstOrDefault();
            Assert.IsNotNull(doc);
            Assert.AreEqual(10, doc["value"].ToInt32());
        }
Exemple #21
0
        private void registerDoctorOrSister_Click(object sender, EventArgs e)
        {
            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);
            var db = server.GetDatabase("CookingBook");


            var   collection = db.GetCollection <Kuvar>("kuvari");
            Kuvar k          = new Kuvar();

            k.ime        = name.Text.ToString();
            k.prezime    = surname.Text.ToString();
            k.ID_Kartice = IdCard.Text.ToString();
            k.sifra      = password.Text.ToString();

            collection.Insert(k);

            this.Close();
        }
Exemple #22
0
        public MongoDataProvider(string joinParentId, string mongoConnectionString, string databaseName, string safeMode)
        {
            bool parsedSafeMode;

            SafeMode = SafeMode.Create(bool.TryParse(safeMode, out parsedSafeMode) ? parsedSafeMode : false);

            JoinParentId = new ID(joinParentId);

            Server = MongoServer.Create(mongoConnectionString);

            Db = Server.GetDatabase(databaseName);

            Items = Db.GetCollection <Item>("items", SafeMode);

            Items.EnsureIndex(IndexKeys.Ascending(new[] { "ParentID" }));
            Items.EnsureIndex(IndexKeys.Ascending(new[] { "TemplateID" }));

            EnsureNotEmpty();
        }
Exemple #23
0
        public MainContext()
        {
            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);

            database = server.GetDatabase("cardMage");

            Cartas       = database.GetCollection <Carta>("cartas");
            Baralhos     = database.GetCollection <Baralho>("baralhos");
            UserProfiles = database.GetCollection <UserProfile>("usuarios");

            if (Cartas.Count() <= 0)
            {
                Baralhos.RemoveAll();
                Cartas.RemoveAll();
                UserProfiles.RemoveAll();
                Seed();
            }
        }
Exemple #24
0
        public Pocetak()
        {
            InitializeComponent();
            listView1.Columns.Add("IME");
            listView1.AutoArrange = true;
            listView1.View        = View.Details;
            var connectionString         = "mongodb://localhost/?safe=true";
            var server                   = MongoServer.Create(connectionString);
            var database                 = server.GetDatabase("nesto1");
            var collection               = database.GetCollection <Partija>("ggg");
            MongoCursor <Partija> igraci = collection.FindAll();

            foreach (Partija r in igraci.ToArray())
            {
                string[] row          = { r.ime };
                var      listViewItem = new ListViewItem(row);
                listView1.Items.Add(listViewItem);
            }
        }
        private void DodajUtakmicu_Load(object sender, EventArgs e)
        {
            this.BackgroundImage       = Image.FromFile("../../slike/pozadina4.jpg");
            this.BackgroundImageLayout = ImageLayout.Stretch;


            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);
            var db = server.GetDatabase("fudbal");

            List <String> listak = new List <String>();

            foreach (MongoDBRef klubRef in L.Klubovi.ToList())
            {
                Klub klub = db.FetchDBRefAs <Klub>(klubRef);
                cbxH.Items.Add(klub.Ime);
                cbxA.Items.Add(klub.Ime);
            }
        }
Exemple #26
0
        public void TestAddToSetEach()
        {
            var server     = MongoServer.Create("mongodb://localhost/?safe=true");
            var database   = server["onlinetests"];
            var collection = database.GetCollection <C>("csharp111");

            collection.RemoveAll();
            var c = new C {
                InnerObjects = new List <D>()
            };

            collection.Insert(c);
            var id = c.Id;

            var query  = Query.EQ("_id", id);
            var update = Update.AddToSet("InnerObjects", 1);

            collection.Update(query, update);
            var d1 = new D {
                X = 1
            };

            update = Update.AddToSetWrapped("InnerObjects", d1);
            collection.Update(query, update);

            var d2 = new D {
                X = 2
            };
            var d3 = new D {
                X = 3
            };

            update = Update.AddToSetEachWrapped("InnerObjects", d1, d2, d3);
            collection.Update(query, update);

            var document = collection.FindOneAs <BsonDocument>();
            var json     = document.ToJson();
            var expected = "{ 'InnerObjects' : [1, { 'X' : 1 }, { 'X' : 2 }, { 'X' : 3 }], '_id' : { '$oid' : '#ID' } }"; // server put _id at end?

            expected = expected.Replace("#ID", id.ToString());
            expected = expected.Replace("'", "\"");
            Assert.AreEqual(expected, json);
        }
        static void Main(string[] args)
        {
            MongoServer   server;
            MongoDatabase moviesDb;

            server   = MongoServer.Create();
            moviesDb = server.GetDatabase("movies_db");

            //Create some data
            var movie1 = new Movie {
                Title = "Indiana Jones and the Raiders of the Lost Ark", Year = "1981"
            };

            movie1.AddActor("Harrison Ford");
            movie1.AddActor("Karen Allen");
            movie1.AddActor("Paul Freeman");

            var movie2 = new Movie {
                Title = "Star Wars: Episode IV - A New Hope", Year = "1977"
            };

            movie2.AddActor("Mark Hamill");
            movie2.AddActor("Harrison Ford");
            movie2.AddActor("Carrie Fisher");

            var movie3 = new Movie {
                Title = "Das Boot", Year = "1981"
            };

            movie3.AddActor("Jürgen Prochnow");
            movie3.AddActor("Herbert Grönemeyer");
            movie3.AddActor("Klaus Wennemann");

            //Insert the movies into the movies_collection
            var moviesCollection = moviesDb.GetCollection <Movie>("movies_collection");
            //moviesCollection.Insert(movie1);
            //moviesCollection.Insert(movie2);
            //moviesCollection.Insert(movie3);

            var query = Query.EQ("Year", "1981");

            var movieFound = moviesDb.GetCollection <Movie>("movies_collection").Drop();
        }
Exemple #28
0
        public static String VratiSlobodnuCeliju(String zatvorID)
        {
            var connectionString = "mongodb://localhost/?safe=true";
            var server           = MongoServer.Create(connectionString);
            var database         = server.GetDatabase("sistemzatvora");

            var collection1 = database.GetCollection <Celija>("celije");

            var query = Query.EQ("ZatvorID", zatvorID);

            foreach (Celija c in collection1.Find(query).ToList())
            {
                if (c.Popunjenost < c.Kapacitet)
                {
                    return(c.Id.ToString());
                }
            }
            return(null);
        }
Exemple #29
0
        public Logon()
        {
            InitializeComponent();
            ArrayList     list     = new ArrayList();
            MongoServer   server   = MongoServer.Create();
            MongoDatabase exerHist = server.GetDatabase("exerHist");

            names = exerHist.GetCollection <BsonDocument>("names");
            var query = new QueryDocument();

            foreach (BsonDocument name in names.Find(query))
            {
                string nameToAdd = name["name"].ToString();
                list.Add(nameToAdd);
                searchList.Add(nameToAdd.ToLower());
            }
            list.Sort();
            nameCB.ItemsSource = list;
        }
Exemple #30
0
        internal static MongoServer GetMongoServer()
        {
            var serverAddress = (ServerPort != 0)
                                ? new MongoServerAddress(ServerHost, ServerPort)
                                : new MongoServerAddress(ServerHost);
            var connectionStringBuilder = new MongoConnectionStringBuilder
            {
                Server           = serverAddress,
                ConnectTimeout   = ConnectTimeout,
                SocketTimeout    = SocketTimeout,
                WaitQueueTimeout = WaitQueueTimeout,
                SafeMode         = (SafeMode)
                                        ? MongoDB.Driver.SafeMode.True
                                        : MongoDB.Driver.SafeMode.False
            };

            return(MongoServer
                   .Create(connectionStringBuilder.ToServerSettings()));
        }