Beispiel #1
0
   public MongoChatRepository(IConfigurationHelper configurationHelper,
 ISecurityManager securityManager)
   {
       _configurationHelper = configurationHelper;
         _securityManager = securityManager;
         _database = ConnectToDatabase();
   }
 public void Setup()
 {
     _server = Configuration.TestServer;
     _server.Connect();
     _database = Configuration.TestDatabase;
     _collection = Configuration.TestCollection;
 }
 public void TestFixtureSetup()
 {
     _server = Configuration.TestServer;
     _database = Configuration.TestDatabase;
     _collection = Configuration.TestCollection;
     _collection.Drop();
 }
        private void ConnectLocal(string dbName)
        {
            var client = new MongoClient(ConnStringLocal);
            var server = client.GetServer();

            this.Database = server.GetDatabase(dbName);
        }
 public void Setup()
 {
     _server = Configuration.TestServer;
     _primary = Configuration.TestServer.Primary;
     _database = Configuration.TestDatabase;
     _database.Drop();
 }
 public void Setup()
 {
     server = MongoServer.Create();
     server.Connect();
     server.DropDatabase("onlinetests");
     database = server["onlinetests"];
 }
Beispiel #7
0
 public HugRepository(string connectionString, string databaseName, IUserProfileRepository userProfileRepository)
 {
     _userProfileRepository = userProfileRepository;
     _server = MongoServer.Create(connectionString);
     _database = _server.GetDatabase(databaseName);
     _mongoCollection = _database.GetCollection<PenedatingMongoUser>("users");
 }
Beispiel #8
0
        public static void CoverDB(MongoDatabase oldDB, MongoDatabase newDB, string collName, params string[] files)
        {
            MongoCollection oldColl = oldDB.GetCollection(collName);
            MongoCollection newColl = newDB.GetCollection(collName);
            int count = 0;

            var players = oldColl.FindAllAs<BsonDocument>();
            foreach (var doc in players)
            {
                foreach (string filed in files)
                {
                    Change(doc, filed);
                }
                //分离Box中的一点券购买
                if (collName == "PlayerEx")
                {
                    BoxToBuy(doc);
                }
                else if (collName == "Pet")
                {
                    RemovePlayerName(doc);
                }

                newColl.Save(doc);
                count++;
            }
            Console.WriteLine(collName + "转换完成" + count);
        }
        public void Connect(string name = DefaultDbName)
        {
            var client = new MongoClient(DefaultConnectionString);
            var server = client.GetServer();

            this.Database = server.GetDatabase(name);
        }
Beispiel #10
0
        public MongoBase(string connectionString)
        {
            var _databaseName = MongoUrl.Create(connectionString).DatabaseName;
            var server = MongoServer.Create(connectionString);
            _mongoDatabase = server.GetDatabase(_databaseName);

        }
 public void Setup()
 {
     _server = Configuration.TestServer;
     _primary = Configuration.TestServer.Primary;
     _database = Configuration.TestDatabase;
     _collection = Configuration.TestCollection;
 }
 public void Setup()
 {
     server = MongoServer.Create("mongodb://localhost/?safe=true");
     server.Connect();
     database = server["onlinetests"];
     collection = database["testcollection"];
 }
 public void Setup()
 {
     _server = Configuration.TestServer;
     _server.Connect();
     _database = Configuration.TestDatabase;
     _database.Drop();
 }
 public PersonRepository()
 {
     string connectionString = "mongodb://localhost";
     _server = MongoServer.Create(connectionString);
     _peopleDb = _server.GetDatabase("Mono");
     _people = _peopleDb.GetCollection<Person>("Person");
 }
 public void TestFixtureSetUp()
 {
     _server = MongoServer.Create(ConnStr);
     if (_server.DatabaseExists(PropSetCollectionsDb))
         _server.DropDatabase(PropSetCollectionsDb);
     _testDb = _server.GetDatabase(PropSetCollectionsDb);
 }
 public AutoIncrementIdImplementation(long capacity, MongoDatabase mongo)
 {
     _currentHi = 0;
     _capacity = capacity;
     _mongo = mongo;
     _currentLo = capacity + 1;
 }
        public GridFsBlobStore(MongoDatabase database, ICounterService counterService)
        {
            _database = database;
            _counterService = counterService;

            LoadFormatsFromDatabase();
        }
Beispiel #18
0
 public MongoUtil()
 {
     connectionString = "mongodb://localhost";
     client  = new MongoClient(connectionString);
     server = client.GetServer();
     database = server.GetDatabase("testwechat");
 }
Beispiel #19
0
        public static void Test2(MongoDatabase db)
        {
            var d = new Dictionary<string, object>();
            var pp = new PortalPage { Title = "This is my test", Id = "test1" };
            var pc = new PortalPageColumn();
            pp.Columns.Add(pc);
            pc.Config["width"] = 200;
            d["open"] = "open listener";
            d["close"] = "close listener";
            d["interval"] = 500;
            pc.Config["listeners"] = d;

            d = new Dictionary<string, object>();
            d["open"] = "open listener";
            d["close"] = "close listener";
            d["interval"] = 500;
            pc.Config["listeners"] = d;

            var pt = new Portlet { Title = "test portlet 1", PortletClass = "GraphImage" };
            pt.Config["width"] = 200;
            pt.Config["height"] = 300;
            pt.Config["listeners"] = d;
            pc.Portlets.Add(pt);

            db.GetCollection<PortalPage>().Save(pp);

            var pp2 = db.GetCollection<PortalPage>().FindOneById(pp.Id);
            Console.WriteLine("p2: {0}", pp2.Title);
        }
 static MongoRepositoryContext() {
     settings = new MongoRepositorySettings();
     var url = new MongoUrl(ConfigurationManager.ConnectionStrings["SysDB"].ConnectionString);
     client = new MongoClient(url);
     server = client.GetServer();
     database = server.GetDatabase(url.DatabaseName);
 }
Beispiel #21
0
        public MongoContext()
        {
            var client = new MongoClient(ConfigurationManager.ConnectionStrings[DATABASE].ConnectionString);
            var server = client.GetServer();

            _database = server.GetDatabase(DATABASE);
        }
 public void TestFixtureSetup()
 {
     _database = Configuration.TestDatabase;
     var collectionSettings = new MongoCollectionSettings() { GuidRepresentation = GuidRepresentation.Standard };
     _collection = _database.GetCollection<C>("csharp714", collectionSettings);
     _collection.Drop();
 }
 public void Setup()
 {
     _server = Configuration.TestServer;
     _primary = _server.Instances.First(x => ReadPreference.Primary.MatchesInstance(x));
     _database = Configuration.TestDatabase;
     _collection = Configuration.TestCollection;
 }
 public void Setup()
 {
     _server = LegacyTestConfiguration.Server;
     _primary = _server.Instances.First(x => x.IsPrimary);
     _database = LegacyTestConfiguration.Database;
     _collection = LegacyTestConfiguration.Collection;
 }
Beispiel #25
0
        public IndexModule(MongoDatabase db)
        {
            var collection = db.GetCollection<Person>(typeof(Person).Name.ToLower() + "s");

            Get["/"] = parameters =>
                {
                    var value = new Random().Next(0, 999);
                    //SqlConnection connection = new SqlConnection("Data Source=10.0.122.14;Initial Catalog=srm4000;User ID=developers;Password=chicago");
                    //connection.Open();
                    //SqlCommand command = new SqlCommand("SELECT * FROM [TABLE] WHERE BATCHNO = " + value, connection);
                    //SqlDataReader reader = command.ExecuteReader();
                    //List<Person> people = new List<Person>();

                    //while (reader.Read())
                    //{
                    //    var person = new Person { BatchNo = (int)reader["BATCHNO"], Name = (string)reader["NAME"] };
                    //    people.Add(person);
                    //}
                    //reader.Close();
                    //connection.Close();
                    var foundit = collection.AsQueryable<Person>().Where(x => x.BatchNo == value).ToList();

                    return 200;
                };
        }
Beispiel #26
0
 public MdbAccount()
 {
     m_Client = new MongoClient(Configuration.Database.Url);
     m_Server = m_Client.GetServer();
     m_Database = m_Server.GetDatabase(Configuration.Database.Name);
     m_Collection = m_Database.GetCollection<Account>(MDBAccountTable);
 }
Beispiel #27
0
        public UseCaseUpdateTask(IAppConfig appConfig, IDataList<UseCase> useCases)
        {
            var url = new MongoUrl(appConfig.ProxyDbConnectionString);
            _db = new MongoClient(url).GetServer().GetDatabase(url.DatabaseName);

            _useCases = useCases;
        }
 public static void EstablishConnection()
 {
     client = new MongoClient(connectionString);
     server = client.GetServer();
     database = server.GetDatabase(DbName);
     entries = database.GetCollection<JSonReport>(collectionName);
 }
 public void TestFixtureSetup()
 {
     server = MongoServer.Create("mongodb://localhost/?safe=true");
     database = server["onlinetests"];
     collection = database["testcollection"];
     collection.Drop();
 }
 public void Setup()
 {
     server = MongoServer.Create("mongodb://localhost/?safe=true");
     server.Connect();
     server.DropDatabase("onlinetests");
     database = server["onlinetests"];
 }
        private void load_marks(string prn)
        {
            MongoClient            client = new MongoClient("mongodb://localhost");
            MongoServer            server = client.GetServer();
            MongoDatabase          db     = server.GetDatabase("NBA");
            MongoCursor <Students> put    = db.GetCollection <Students>("Students").Find(Query.EQ("prn", prn));
            bool f = false;

            txtprn.Text = prn;
            foreach (Students i in put)
            {
                lblStudentName.Text = i.student_name;
                academic_year       = i.academicyear;
                f = true;
                break;
            }
            if (!f)
            {
                MessageBox.Show("Record not found!");
                return;
            }
            MongoCursor <Marks> marks;

            f     = false;
            marks = db.GetCollection <Marks>("fe_marks").Find(Query.EQ("prn", prn));
            if (marks.Count() > 0)
            {
                f = true;
                tabControlMarks.Show();
                tabControlMarks.TabPages.Add(tabPage1);
                foreach (Marks i in marks)
                {
                    txt1seatno.Text = i.seat_no;
                    txt1sub1.Text   = i.sub1.ToString();
                    txt1sub2.Text   = i.sub2.ToString();
                    txt1sub3.Text   = i.sub3.ToString();
                    txt1sub4.Text   = i.sub4.ToString();
                    txt1sub5.Text   = i.sub5.ToString();
                    txt1sub6.Text   = i.sub6.ToString();
                    txt1sub7.Text   = i.sub7.ToString();
                    txt1sub8.Text   = i.sub8.ToString();
                    txt1sub9.Text   = i.sub9.ToString();
                    txt1sub10.Text  = i.sub10.ToString();
                    txt1sub11.Text  = i.sub11.ToString();
                    txt1sub12.Text  = i.sub12.ToString();
                    txt1sub13.Text  = i.sub13.ToString();
                    txt1sub14.Text  = i.sub14.ToString();
                    txt1sub15.Text  = i.sub15.ToString();
                    txt1sub16.Text  = i.sub16.ToString();
                    txt1sub17.Text  = i.sub17.ToString();
                    txt1sub18.Text  = i.sub18.ToString();
                    txt1sub19.Text  = i.sub19.ToString();
                    txt1sub20.Text  = i.sub20.ToString();
                    txt1sub21.Text  = i.sub21.ToString();
                    txt1sub22.Text  = i.sub22.ToString();
                    txt1sub23.Text  = i.sub23.ToString();
                    txt1sub24.Text  = i.sub24.ToString();
                }
            }
            marks = db.GetCollection <Marks>("se_marks").Find(Query.EQ("prn", prn));
            if (marks.Count() > 0)
            {
                f = true;
                tabControlMarks.Show();
                tabControlMarks.TabPages.Add(tabPage2);

                foreach (Marks i in marks)
                {
                    txt2seatno.Text = i.seat_no;
                    txt2sub1.Text   = i.sub1.ToString();
                    txt2sub2.Text   = i.sub2.ToString();
                    txt2sub3.Text   = i.sub3.ToString();
                    txt2sub4.Text   = i.sub4.ToString();
                    txt2sub5.Text   = i.sub5.ToString();
                    txt2sub6.Text   = i.sub6.ToString();
                    txt2sub7.Text   = i.sub7.ToString();
                    txt2sub8.Text   = i.sub8.ToString();
                    txt2sub9.Text   = i.sub9.ToString();
                    txt2sub10.Text  = i.sub10.ToString();
                    txt2sub11.Text  = i.sub11.ToString();
                    txt2sub12.Text  = i.sub12.ToString();
                    txt2sub13.Text  = i.sub13.ToString();
                    txt2sub14.Text  = i.sub14.ToString();
                    txt2sub15.Text  = i.sub15.ToString();
                    txt2sub16.Text  = i.sub16.ToString();
                    txt2sub17.Text  = i.sub17.ToString();
                    txt2sub18.Text  = i.sub18.ToString();
                    txt2sub19.Text  = i.sub19.ToString();
                    txt2sub20.Text  = i.sub20.ToString();
                    txt2sub21.Text  = i.sub21.ToString();
                    txt2sub22.Text  = i.sub22.ToString();
                    txt2sub23.Text  = i.sub23.ToString();
                    txt2sub24.Text  = i.sub24.ToString();
                }
            }

            marks = db.GetCollection <Marks>("te_marks").Find(Query.EQ("prn", prn));
            if (marks.Count() > 0)
            {
                f = true;
                tabControlMarks.Show();
                tabControlMarks.TabPages.Add(tabPage3);

                foreach (Marks i in marks)
                {
                    txt3seatno.Text = i.seat_no;
                    txt3sub1.Text   = i.sub1.ToString();
                    txt3sub2.Text   = i.sub2.ToString();
                    txt3sub3.Text   = i.sub3.ToString();
                    txt3sub4.Text   = i.sub4.ToString();
                    txt3sub5.Text   = i.sub5.ToString();
                    txt3sub6.Text   = i.sub6.ToString();
                    txt3sub7.Text   = i.sub7.ToString();
                    txt3sub8.Text   = i.sub8.ToString();
                    txt3sub9.Text   = i.sub9.ToString();
                    txt3sub10.Text  = i.sub10.ToString();
                    txt3sub11.Text  = i.sub11.ToString();
                    txt3sub12.Text  = i.sub12.ToString();
                    txt3sub13.Text  = i.sub13.ToString();
                    txt3sub14.Text  = i.sub14.ToString();
                    txt3sub15.Text  = i.sub15.ToString();
                    txt3sub16.Text  = i.sub16.ToString();
                    txt3sub17.Text  = i.sub17.ToString();
                    txt3sub18.Text  = i.sub18.ToString();
                    txt3sub19.Text  = i.sub19.ToString();
                    txt3sub20.Text  = i.sub20.ToString();
                    txt3sub21.Text  = i.sub21.ToString();
                    txt3sub22.Text  = i.sub22.ToString();
                    txt3sub23.Text  = i.sub23.ToString();
                    txt3sub24.Text  = i.sub24.ToString();
                }
            }

            marks = db.GetCollection <Marks>("be_marks").Find(Query.EQ("prn", prn));
            if (marks.Count() > 0)
            {
                f = true;
                tabControlMarks.Show();
                tabControlMarks.TabPages.Add(tabPage4);
                foreach (Marks i in marks)
                {
                    txt4seatno.Text = i.seat_no;
                    txt4sub1.Text   = i.sub1.ToString();
                    txt4sub2.Text   = i.sub2.ToString();
                    txt4sub3.Text   = i.sub3.ToString();
                    txt4sub4.Text   = i.sub4.ToString();
                    txt4sub5.Text   = i.sub5.ToString();
                    txt4sub6.Text   = i.sub6.ToString();
                    txt4sub7.Text   = i.sub7.ToString();
                    txt4sub8.Text   = i.sub8.ToString();
                    txt4sub9.Text   = i.sub9.ToString();
                    txt4sub10.Text  = i.sub10.ToString();
                    txt4sub11.Text  = i.sub11.ToString();
                    txt4sub12.Text  = i.sub12.ToString();
                    txt4sub13.Text  = i.sub13.ToString();
                    txt4sub14.Text  = i.sub14.ToString();
                    txt4sub15.Text  = i.sub15.ToString();
                    txt4sub16.Text  = i.sub16.ToString();
                    txt4sub17.Text  = i.sub17.ToString();
                    txt4sub18.Text  = i.sub18.ToString();
                    txt4sub19.Text  = i.sub19.ToString();
                    txt4sub20.Text  = i.sub20.ToString();
                    txt4sub21.Text  = i.sub21.ToString();
                    txt4sub22.Text  = i.sub22.ToString();
                    txt4sub23.Text  = i.sub23.ToString();
                    txt4sub24.Text  = i.sub24.ToString();
                }
            }
            if (!f)
            {
                MessageBox.Show("No Marks Entered!");
            }
        }
 internal CheckpointStore(MongoDatabase database)
 {
     collection = database.GetCollection <ProjectionCheckpointDto>("ProjectionCheckpoints");
 }
Beispiel #33
0
 internal EdificeMongoDbCollection(MongoDatabase db, string collectionName)
 {
     collection = db.GetCollection <Element>(collectionName);
 }
 public void OneTimeSetUp()
 {
     _server     = LegacyTestConfiguration.Server;
     _database   = LegacyTestConfiguration.Database;
     _collection = LegacyTestConfiguration.Collection;
 }
Beispiel #35
0
 internal VersioningRepository(MongoDatabase database)
 {
     collection = database.GetCollection <ProjectionVersionDto>("ProjectionVersions");
 }
Beispiel #36
0
 public void TestFixtureSetup()
 {
     _server     = Configuration.TestServer;
     _database   = Configuration.TestDatabase;
     _collection = Configuration.TestCollection;
 }
Beispiel #37
0
 public ScopeStore(MongoDatabase db, string collectionName) : base(db, collectionName)
 {
     _serializer = new ScopeSerializer();
 }
        private void load_subject()
        {
            string[]               sub11  = new string[24];
            string[]               sub12  = new string[24];
            string[]               sub21  = new string[24];
            string[]               sub22  = new string[24];
            string[]               sub31  = new string[24];
            string[]               sub32  = new string[24];
            string[]               sub41  = new string[24];
            string[]               sub42  = new string[24];
            MongoClient            client = new MongoClient("mongodb://localhost");
            MongoServer            server = client.GetServer();
            MongoDatabase          db     = server.GetDatabase("NBA");
            MongoCursor <Subjects> put    = db.GetCollection <Subjects>("Subjects").Find(Query.EQ("academic_year", academic_year)).SetSortOrder(SortBy.Ascending("srno"));
            int x11 = 0;
            int x12 = 0;
            int x21 = 0;
            int x22 = 0;
            int x31 = 0;
            int x32 = 0;
            int x41 = 0;
            int x42 = 0;

            foreach (Subjects i in put)
            {
                if (i.clas == "F.E." && i.semester == "Sem I")
                {
                    sub11[x11++] = i.Subject_Name;
                    sub11[x11++] = i.marks;
                }
                else if (i.clas == "F.E." && i.semester == "Sem II")
                {
                    sub12[x12++] = i.Subject_Name;
                    sub12[x12++] = i.marks;
                }
                else if (i.clas == "S.E." && i.semester == "Sem I")
                {
                    sub21[x21++] = i.Subject_Name;
                    sub21[x21++] = i.marks;
                }
                else if (i.clas == "S.E." && i.semester == "Sem II")
                {
                    sub22[x22++] = i.Subject_Name;
                    sub22[x22++] = i.marks;
                }
                else if (i.clas == "T.E." && i.semester == "Sem I")
                {
                    sub31[x31++] = i.Subject_Name;
                    sub31[x31++] = i.marks;
                }
                else if (i.clas == "T.E." && i.semester == "Sem II")
                {
                    sub32[x32++] = i.Subject_Name;
                    sub32[x32++] = i.marks;
                }
                else if (i.clas == "B.E." && i.semester == "Sem I")
                {
                    sub41[x41++] = i.Subject_Name;
                    sub41[x41++] = i.marks;
                }
                else if (i.clas == "B.E." && i.semester == "Sem II")
                {
                    sub42[x42++] = i.Subject_Name;
                    sub42[x42++] = i.marks;
                }
            }
            show_sub(sub11, x11, gb11);
            show_sub(sub12, x12, gb12);
            show_sub(sub21, x21, gb21);
            show_sub(sub22, x22, gb22);
            show_sub(sub31, x31, gb31);
            show_sub(sub32, x32, gb32);
            show_sub(sub41, x41, gb41);
            show_sub(sub42, x42, gb42);
        }
 public InvitationsController(IUoWData db)
 {
     this.db      = db;
     this.mongoDb = MongoClientFactory.GetDatabase();
 }
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            MongoClient             client = new MongoClient("mongodb://localhost");
            MongoServer             server = client.GetServer();
            MongoDatabase           db     = server.GetDatabase("NBA");
            MongoCollection <Marks> marks;

            marks = db.GetCollection <Marks>("fe_marks");
            if (marks.Count() > 0)
            {
                update(marks, "seat_no", txt1seatno.Text.Trim(), 0);

                update(marks, "sub1", txt1sub1.Text.Trim(), 0);
                update(marks, "sub2", txt1sub2.Text.Trim(), 0);
                update(marks, "sub3", txt1sub3.Text.Trim(), 0);
                update(marks, "sub4", txt1sub4.Text.Trim(), 0);
                update(marks, "sub5", txt1sub5.Text.Trim(), 0);
                update(marks, "sub6", txt1sub6.Text.Trim(), 0);
                update(marks, "sub7", txt1sub7.Text.Trim(), 0);
                update(marks, "sub8", txt1sub8.Text.Trim(), 0);
                update(marks, "sub9", txt1sub9.Text.Trim(), 0);
                update(marks, "sub10", txt1sub10.Text.Trim(), 0);
                update(marks, "sub11", txt1sub11.Text.Trim(), 0);
                update(marks, "sub12", txt1sub12.Text.Trim(), 0);
                update(marks, "sub13", txt1sub13.Text.Trim(), 0);
                update(marks, "sub14", txt1sub14.Text.Trim(), 0);
                update(marks, "sub15", txt1sub15.Text.Trim(), 0);
                update(marks, "sub16", txt1sub16.Text.Trim(), 0);
                update(marks, "sub17", txt1sub17.Text.Trim(), 0);
                update(marks, "sub18", txt1sub18.Text.Trim(), 0);
                update(marks, "sub19", txt1sub19.Text.Trim(), 0);
                update(marks, "sub20", txt1sub20.Text.Trim(), 0);
                update(marks, "sub21", txt1sub21.Text.Trim(), 0);
                update(marks, "sub22", txt1sub22.Text.Trim(), 0);
                update(marks, "sub23", txt1sub23.Text.Trim(), 0);
                update(marks, "sub24", txt1sub24.Text.Trim(), 0);
                cal_marks(gb11, "lbl1subm"); // calculate marks
                update(marks, "sem1_total", stud_tot_marks, 0);
                update(marks, "sem1_grade", grade(), 1);
                cal_marks(gb12, "lbl1subm"); // calculate marks
                update(marks, "sem2_total", stud_tot_marks, 0);
                update(marks, "sem2_grade", grade(), 1);
            }
            marks = db.GetCollection <Marks>("se_marks");
            if (marks.Count() > 0)
            {
                update(marks, "seat_no", txt2seatno.Text.Trim(), 0);

                update(marks, "sub1", txt2sub1.Text.Trim(), 0);
                update(marks, "sub2", txt2sub2.Text.Trim(), 0);
                update(marks, "sub3", txt2sub3.Text.Trim(), 0);
                update(marks, "sub4", txt2sub4.Text.Trim(), 0);
                update(marks, "sub5", txt2sub5.Text.Trim(), 0);
                update(marks, "sub6", txt2sub6.Text.Trim(), 0);
                update(marks, "sub7", txt2sub7.Text.Trim(), 0);
                update(marks, "sub8", txt2sub8.Text.Trim(), 0);
                update(marks, "sub9", txt2sub9.Text.Trim(), 0);
                update(marks, "sub10", txt2sub10.Text.Trim(), 0);
                update(marks, "sub11", txt2sub11.Text.Trim(), 0);
                update(marks, "sub12", txt2sub12.Text.Trim(), 0);
                update(marks, "sub13", txt2sub13.Text.Trim(), 0);
                update(marks, "sub14", txt2sub14.Text.Trim(), 0);
                update(marks, "sub15", txt2sub15.Text.Trim(), 0);
                update(marks, "sub16", txt2sub16.Text.Trim(), 0);
                update(marks, "sub17", txt2sub17.Text.Trim(), 0);
                update(marks, "sub18", txt2sub18.Text.Trim(), 0);
                update(marks, "sub19", txt2sub19.Text.Trim(), 0);
                update(marks, "sub20", txt2sub20.Text.Trim(), 0);
                update(marks, "sub21", txt2sub21.Text.Trim(), 0);
                update(marks, "sub22", txt2sub22.Text.Trim(), 0);
                update(marks, "sub23", txt2sub23.Text.Trim(), 0);
                update(marks, "sub24", txt2sub24.Text.Trim(), 0);
                cal_marks(gb21, "lbl2subm"); // calculate marks
                update(marks, "sem1_total", stud_tot_marks, 0);
                update(marks, "sem1_grade", grade(), 1);
                cal_marks(gb22, "lbl2subm"); // calculate marks
                update(marks, "sem2_total", stud_tot_marks, 0);
                update(marks, "sem2_grade", grade(), 1);
            }
            marks = db.GetCollection <Marks>("te_marks");
            if (marks.Count() > 0)
            {
                update(marks, "seat_no", txt3seatno.Text.Trim(), 0);

                update(marks, "sub1", txt3sub1.Text.Trim(), 0);
                update(marks, "sub2", txt3sub2.Text.Trim(), 0);
                update(marks, "sub3", txt3sub3.Text.Trim(), 0);
                update(marks, "sub4", txt3sub4.Text.Trim(), 0);
                update(marks, "sub5", txt3sub5.Text.Trim(), 0);
                update(marks, "sub6", txt3sub6.Text.Trim(), 0);
                update(marks, "sub7", txt3sub7.Text.Trim(), 0);
                update(marks, "sub8", txt3sub8.Text.Trim(), 0);
                update(marks, "sub9", txt3sub9.Text.Trim(), 0);
                update(marks, "sub10", txt3sub10.Text.Trim(), 0);
                update(marks, "sub11", txt3sub11.Text.Trim(), 0);
                update(marks, "sub12", txt3sub12.Text.Trim(), 0);
                update(marks, "sub13", txt3sub13.Text.Trim(), 0);
                update(marks, "sub14", txt3sub14.Text.Trim(), 0);
                update(marks, "sub15", txt3sub15.Text.Trim(), 0);
                update(marks, "sub16", txt3sub16.Text.Trim(), 0);
                update(marks, "sub17", txt3sub17.Text.Trim(), 0);
                update(marks, "sub18", txt3sub18.Text.Trim(), 0);
                update(marks, "sub19", txt3sub19.Text.Trim(), 0);
                update(marks, "sub20", txt3sub20.Text.Trim(), 0);
                update(marks, "sub21", txt3sub21.Text.Trim(), 0);
                update(marks, "sub22", txt3sub22.Text.Trim(), 0);
                update(marks, "sub23", txt3sub23.Text.Trim(), 0);
                update(marks, "sub24", txt3sub24.Text.Trim(), 0);
                cal_marks(gb31, "lbl3subm"); // calculate marks
                update(marks, "sem1_total", stud_tot_marks, 0);
                update(marks, "sem1_grade", grade(), 1);
                cal_marks(gb32, "lbl3subm"); // calculate marks
                update(marks, "sem2_total", stud_tot_marks, 0);
                update(marks, "sem2_grade", grade(), 1);
            }
            marks = db.GetCollection <Marks>("be_marks");
            if (marks.Count() > 0)
            {
                update(marks, "seat_no", txt4seatno.Text.Trim(), 0);

                update(marks, "sub1", txt4sub1.Text.Trim(), 0);
                update(marks, "sub2", txt4sub2.Text.Trim(), 0);
                update(marks, "sub3", txt4sub3.Text.Trim(), 0);
                update(marks, "sub4", txt4sub4.Text.Trim(), 0);
                update(marks, "sub5", txt4sub5.Text.Trim(), 0);
                update(marks, "sub6", txt4sub6.Text.Trim(), 0);
                update(marks, "sub7", txt4sub7.Text.Trim(), 0);
                update(marks, "sub8", txt4sub8.Text.Trim(), 0);
                update(marks, "sub9", txt4sub9.Text.Trim(), 0);
                update(marks, "sub10", txt4sub10.Text.Trim(), 0);
                update(marks, "sub11", txt4sub11.Text.Trim(), 0);
                update(marks, "sub12", txt4sub12.Text.Trim(), 0);
                update(marks, "sub13", txt4sub13.Text.Trim(), 0);
                update(marks, "sub14", txt4sub14.Text.Trim(), 0);
                update(marks, "sub15", txt4sub15.Text.Trim(), 0);
                update(marks, "sub16", txt4sub16.Text.Trim(), 0);
                update(marks, "sub17", txt4sub17.Text.Trim(), 0);
                update(marks, "sub18", txt4sub18.Text.Trim(), 0);
                update(marks, "sub19", txt4sub19.Text.Trim(), 0);
                update(marks, "sub20", txt4sub20.Text.Trim(), 0);
                update(marks, "sub21", txt4sub21.Text.Trim(), 0);
                update(marks, "sub22", txt4sub22.Text.Trim(), 0);
                update(marks, "sub23", txt4sub23.Text.Trim(), 0);
                update(marks, "sub24", txt4sub24.Text.Trim(), 0);
                cal_marks(gb41, "lbl4subm"); // calculate marks
                update(marks, "sem1_total", stud_tot_marks, 0);
                update(marks, "sem1_grade", grade(), 1);
                cal_marks(gb42, "lbl4subm"); // calculate marks
                update(marks, "sem2_total", stud_tot_marks, 0);
                update(marks, "sem2_grade", grade(), 1);
            }
        }
 public IStoreTimeouts CreateStore()
 {
     db = MongoDatabase.Create(ConnectionStrings.MongoDb);
     return(new MongoDbTimeoutStorage(ConnectionStrings.MongoDb, "timeouts"));
 }
Beispiel #42
0
 public TGUserDAO(MongoDatabase _mongoDB) : base(_mongoDB)
 {
     HasParent = false;
 }
 public void Setup()
 {
     _server   = Configuration.TestServer;
     _database = Configuration.TestDatabase;
 }
        private void CreateUserOrganizationRelation(Organization organization, User sqlUser, UserRoles role, MongoDatabase mongoDb)
        {
            var usersCollection = mongoDb.GetCollection(MongoCollections.Users);

            var mongoUser = usersCollection.FindOne(Query.EQ("_id", new ObjectId(sqlUser.MongoId)));

            var usersOrganizations = mongoDb.GetCollection(MongoCollections.UsersInOrganizations);

            UsersOrganizations newRelation = new UsersOrganizations()
            {
                UserId           = mongoUser["_id"].AsObjectId,
                OrganizationId   = organization.Id,
                OrganizationName = organization.Name,
                Username         = sqlUser.Username,
                Role             = role
            };

            usersOrganizations.Save(newRelation);
        }
Beispiel #45
0
 private void ConfigConnectionDataBase()
 {
     client   = new MongoClient("mongodb://localhost:27017");
     server   = client.GetServer();
     database = server.GetDatabase("book_library");
 }
 public void Setup()
 {
     server     = MongoServer.Create("mongodb://localhost/?safe=true");
     database   = server["driveronlinetests"];
     collection = database["test"];
 }
Beispiel #47
0
 public PublishedPostWithCommentsView(MongoDatabase mongoDatabase)
 {
     _mongoDatabase = mongoDatabase;
 }
Beispiel #48
0
 public SkillMapService(MongoDatabase mongoDatabase)
     : base(mongoDatabase)
 {
 }
Beispiel #49
0
 public PublishedPostsView(MongoDatabase mongoDatabase)
 {
     _mongoDatabase = mongoDatabase;
 }
Beispiel #50
0
 private MongoDb()
 {
     _mongoClient   = new MongoClient(MongoDbConnectionString);
     _mongoServer   = MongoClient.GetServer();
     _mongoDatabase = MongoServer.GetDatabase(MongoDbDatabaseName);
 }
Beispiel #51
0
 public UserRepository(
     MongoDatabase database,
     ILogger <MongoRepository <PHOTOnlineUser> > logger) : base(database, logger)
 {
 }
Beispiel #52
0
 public AdminPostsView(MongoDatabase mongoDatabase)
 {
     _mongoDatabase = mongoDatabase;
 }
Beispiel #53
0
    static void Main(string[] args)
    {
        // TO DO: Add your code here
        DateTime beginDate = new DateTime(2017, 3, 21);
        DateTime endDate   = new DateTime(2017, 3, 22);

        MongoClient   client   = new MongoClient("mongodb://*****:*****@"function(obj,prev){ prev.type=obj.type;}"),
                    null
                    );
                plateTypes.Clear();
                foreach (BsonDocument document in plates)
                {
                    plateTypes.Add((string)document["plate"], document["type"].ToInt32());
                }
            }
            lastMonthString = monthString;
            Dictionary <string, List <string> > plateDict = new Dictionary <string, List <string> >();
            foreach (BsonDocument document in collection.FindAll())
            {
                List <string> ls = null;
                if (!plateDict.TryGetValue((string)document["symbol"], out ls))
                {
                    ls = new List <string>();
                    plateDict.Add((string)document["symbol"], ls);
                }
                if (!(document["plate"] is BsonNull))
                {
                    ls.Add((string)document["plate"]);
                }
            }
            Dictionary <string, StatisItem> plateUpLimitStatis = new Dictionary <string, StatisItem>();


            //找出日线当天接近涨停股
            List <Instrument> toUpLimit = new List <Instrument>();
            foreach (Instrument instrument in InstrumentManager.Instruments)
            {
                if (instrument.SecurityType == "CS" && instrument.SecurityDesc.IndexOf('B') < 0)
                {
                    DailySeries series = instrument.GetDailySeries(curDate.AddMonths(-3), curDate);
                    //下面这里要求日线数大于20,是为了排除新股
                    if (series.Count > 20)
                    {
                        GMDaily gmDaily = (GMDaily)series[series.Count - 1];                    //最近一天的日线
                        if (gmDaily.Date != curDate)
                        {
                            continue;
                        }
                        //下面是对于st,*st的,因为名字判断不准确,故去掉
                        //if ((instrument.SecurityDesc.IndexOf("ST")>=0||instrument.SecurityDesc.IndexOf('S')>=0)
                        //&&(gmDaily.Close/gmDaily.LastClose>1.044)){
                        //	toUpLimit.Add(instrument);
                        //}
                        //下面是对于普通股
                        if (gmDaily.Close / gmDaily.LastClose > 1.094)
                        {
                            toUpLimit.Add(instrument);
                        }
                    }
                }
            }
            Console.WriteLine("今日除去20内的新股,有{0}只涨停", toUpLimit.Count);
            //读出Trade数据,确定是否真的涨停及涨停时间,交统计数据
            string dataPath = "e:/QDData";
            string path     = dataPath + "/" + curDate.Year.ToString() + "/" + curDate.Month.ToString();
            if (!Directory.Exists(path))
            {
                Console.WriteLine("Trade数据目录不存在!");
                return;
            }
            try {
                DataFile file = DataFile.Open(path);
                try {
                    foreach (Instrument instrument in toUpLimit)
                    {
                        Console.WriteLine(instrument.Symbol);
                        string name = instrument.Symbol + ".Trade";
                        if (!file.Series.Contains(name))
                        {
                            throw new Exception(instrument.Symbol + "的Trade数据不存在,请补充完整。");
                        }
                        FileSeries      series = file.Series[name];
                        ISeriesObject[] trades = series.GetArray(curDate, curDate.AddDays(1));
                        if (trades.Length <= 0)
                        {
                            continue;
                        }
                        GMTrade gmLastTrade = (GMTrade)trades[trades.Length - 1];                    //最后一笔交易数据
                        if (gmLastTrade.Price < gmLastTrade.UpperLimit)
                        {
                            continue;
                        }
                        foreach (ISeriesObject aTrade in trades)
                        {
                            GMTrade gmTrade = (GMTrade)aTrade;
                            if (gmTrade.Price == gmTrade.UpperLimit && gmTrade.DateTime >= curDate.Add(new TimeSpan(9, 25, 0)))
                            {
                                Console.WriteLine(instrument.Symbol + instrument.SecurityDesc + "在" + gmTrade.DateTime + "时涨停");
                                //板块统计
                                if (plateDict.ContainsKey(instrument.Symbol))
                                {
                                    List <string> plateList = plateDict[instrument.Symbol];
                                    foreach (string plate in plateList)
                                    {
                                        StatisItem si = null;
                                        if (!plateUpLimitStatis.TryGetValue(plate, out si))
                                        {
                                            si = new StatisItem();
                                            plateUpLimitStatis.Add(plate, si);
                                        }
                                        si.AddSymbol(instrument.Symbol, gmTrade.DateTime);
                                    }
                                }
                                break;
                            }
                        }
                    }
                }catch (Exception ex) {
                    throw ex;
                }
                finally{
                    file.Close();
                }
                //板块统计写入数据库
                MongoCollection <BsonDocument> collection1 = database.GetCollection <BsonDocument>("PlateUpLimitStatis");
                BsonElement[] eleArray = new BsonElement[1];
                eleArray[0] = new BsonElement("date", curDate.ToString("yyyy-MM-dd"));
                QueryDocument query = new QueryDocument(eleArray);
                collection1.Remove(query);
                foreach (KeyValuePair <string, StatisItem> kvp in plateUpLimitStatis)
                {
                    BsonElement[] eleArray1 = new BsonElement[5];
                    eleArray1[0] = new BsonElement("date", curDate.ToString("yyyy-MM-dd"));
                    eleArray1[1] = new BsonElement("plate", kvp.Key);
                    eleArray1[2] = new BsonElement("type", plateTypes[kvp.Key]);
                    eleArray1[3] = new BsonElement("count", kvp.Value.Count);

                    BsonArray bsonArray = new BsonArray(kvp.Value.Count);
                    foreach (KeyValuePair <string, DateTime> kvp1 in kvp.Value.Securities)
                    {
                        bsonArray.Add(new BsonDocument(new BsonElement[2] {
                            new BsonElement("symbol", kvp1.Key),
                            new BsonElement("time", kvp1.Value.ToString("yyyy-MM-dd HH:mm:ss"))
                        }));
                    }
                    eleArray1[4] = new BsonElement("securities", bsonArray);
                    BsonDocument insert = new BsonDocument(eleArray1);
                    collection1.Insert(insert);
                }
            }catch (Exception ex) {
                Console.WriteLine(ex.Message);
            }
            curDate = curDate.AddDays(1);
        }
    }
Beispiel #54
0
 public UnapprovedCommentsView(MongoDatabase mongoDatabase)
 {
     _mongoDatabase = mongoDatabase;
 }
 private void ExecuteMethod(MongoDatabase obj)
 {
     _regionManager.AddToRegion(RegionNames.TabControlRegion, _unity.Resolve <MainView>(new ParameterOverride("database", obj)));
 }
Beispiel #56
0
 public void TestFixtureSetUp()
 {
     _database = Configuration.TestDatabase;
     _gridFS   = _database.GridFS;
 }
Beispiel #57
0
 /// <summary>
 /// Initializes a new instance of the MongoGridFS class.
 /// </summary>
 /// <param name="database">The database containing the GridFS collections.</param>
 public MongoGridFS(
     MongoDatabase database
     )
     : this(database, MongoGridFSSettings.Defaults)
 {
 }
 public Repository(MongoDatabase db, string tblName)
 {
     database   = db;
     tableName  = tblName;
     collection = database.GetCollection <T>(tblName);
 }
Beispiel #59
0
 public IncidentRepository()
 {
     projectDB = getProjectDB();
 }
Beispiel #60
0
 public UsersController(MongoDatabase db)
 {
     _db = db;
 }