public LichtBildController( IOptions <LichtBildConfiguration> lichtBildConfiguration, LichtBildConnector lichtBildConnector, MongoDBConnector mongoDBConnector, OpenDataHubConnector openDataHupConnector ) { this._lichtBildConnector = lichtBildConnector; this._lichtBildConfiguration = lichtBildConfiguration; this._mongoDBConnector = mongoDBConnector; this._openDataHupConnector = openDataHupConnector; }
public GastronomyController( OpenDataHubConnector openDataHupConnector, MongoDBConnector mongoDBConnector ) { this._openDataHupConnector = openDataHupConnector; _mongoDBConnector = mongoDBConnector; var mapperConfig = new MapperConfiguration(cfg => cfg.CreateMap <Gastronomy, MergedGastronomy>()); mapper = mapperConfig.CreateMapper(); }
public void CheckDevice(NetworkMessage message) { DeviceDataMessage msg = message.ReadMessage <DeviceDataMessage>(); DeviceIdentification deviceIdentification = msg.DeviceIdentification; var db = MongoDBConnector.GetInstance().GetDatabase(); var collection = db.GetCollection <BsonDocument>("Devices"); var results = collection.Find(new BsonDocument { { "DevId", deviceIdentification.DevId } }).ToList(); int addr = -1; if (results.Count > 0) { foreach (var result in results) { if (result["ScreenWidth"].AsInt32 == deviceIdentification.ScreenWidth && result["ScreenHeight"].AsInt32 == deviceIdentification.ScreenHeight && result["DeviceClass"].AsInt32 == (int)deviceIdentification.DeviceClass) { addr = result["id"].AsInt32; } } } if (addr == -1) { var value = collection.Find(new BsonDocument()).Sort(new BsonDocument { { "id", -1 } }).Limit(1).Project(Builders <BsonDocument> .Projection.Exclude("_id").Include("id")); int maxid; if (value.Count() > 0) { maxid = JsonUtility.FromJson <int>(value.ToJson()); } else { maxid = 0; } var document = new BsonDocument { { "id", maxid + 1 }, { "DevId", deviceIdentification.DevId }, { "ScreenWidth", deviceIdentification.ScreenWidth }, { "ScreenHeight", deviceIdentification.ScreenHeight }, { "DeviceClass", deviceIdentification.DeviceClass } }; collection.InsertOne(document); addr = maxid; } NetworkServer.SendToClient(message.conn.connectionId, MyMsgType.DeviceId, new IntegerMessage(addr)); }
public MainWindow() { MongoDBConnector.CreateSession("nliis"); _openFileDialog = new OpenFileDialog { DefaultExt = "txt", CheckFileExists = true, Multiselect = false }; InitializeComponent(); Sentences.SelectionChanged += BuildSyntaxTree; DocumentService.Language = "English"; }
void Page_Load(Object sender, EventArgs e) { if (!IsPostBack) { MongoDBConnector connector = new MongoDBConnector (); var collection = connector.GetCollection<User> ("Users"); var query = Query.EQ ("id", (ObjectId)Cache.Get ("currentUser")); var result = collection.FindOne (query); if (result != null) { cachedUser = result; ContentPlaceHolder.Page.Title = cachedUser.email; } else { //Response.Redirect("/Default.aspx"); } } }
public void read() { Console.WriteLine("Connecting...."); string dbname = System.Configuration.ConfigurationManager.AppSettings["mongodatabase"]; MongoDBConnector getCon = new MongoDBConnector(); MongoServer con = getCon.GetCon(); try { con.Connect(); Console.WriteLine("Connected\n"); var db = con.GetDatabase("est"); using (con.RequestStart(db)) { var collection = db.GetCollection <BsonDocument>("user_login"); var query = new QueryDocument(); foreach (BsonDocument record in collection.Find(query)) { BsonElement Id = record.GetElement("id"); BsonElement Fname = record.GetElement("fname"); BsonElement Lname = record.GetElement("lname"); BsonElement Password = record.GetElement("password"); Console.WriteLine("{0}\t{1}" + " " + "{2}\t{3}", Id.Value.ToString(), Fname.Value.ToString(), Lname.Value.ToString(), Password.Value.ToString()); } con.Disconnect(); } } catch (MongoException e) { Console.WriteLine("\tError: " + e.HResult.ToString() + "\n\t has occurred: " + e.Message.ToString()); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { if (con.State == MongoServerState.Connected) { con.Disconnect(); } } }
bool VerifyCredentials(string email, string password) { MongoDBConnector dbConnector = new MongoDBConnector (); var collection = dbConnector.GetCollection<User> ("Users"); var q = Query.EQ ("email", email); var queryResult = collection.FindOne (q); if (queryResult != null) { return queryResult.password == password; } return false; }
ObjectId GetUserByEmail(string email) { MongoDBConnector dbConnector = new MongoDBConnector (); var collection = dbConnector.GetCollection<User> ("Users"); var q = Query.EQ ("email", email); var queryResult = collection.FindOne (q); if (queryResult == null) throw new Exception ("User Not Found"); return queryResult.Id; }
void Page_Load(Object sender, EventArgs e) { if (!IsPostBack) { if (Cache.Get ("currentUser") != null) { LoginStatus.Text = "Cached User Exists"; Response.Redirect (@"~/Profile.aspx"); } else { if ((Request.Browser.Cookies)) { if (Request.Cookies.Get ("com.xdegtyarev.kickstart.login.email") != null && Request.Cookies.Get ("com.xdegtyarev.kickstart.login.password") != null) { if (VerifyCredentials (Request.Cookies.Get ("com.xdegtyarev.kickstart.login.email").Value, Request.Cookies.Get ("com.xdegtyarev.kickstart.login.password").Value)) { LoginStatus.Text = "Login from Cookies"; Cache.Insert ("currentUser", GetUserByEmail (Request.Cookies.Get ("com.xdegtyarev.kickstart.login.email").Value)); //No need to save cookies can extend cookie expiration Response.Redirect ("/Profile.aspx"); } else { //Empty Cookies } } } } MongoDBConnector connector = new MongoDBConnector (); var roles = connector.GetCollection<Role> ("Roles"); if (roles.Count () > 0) { List<String> l = new List<String> (); foreach (var o in roles.FindAll()) { l.Add (o.type); } AcountTypeDropdownList.DataSource = l; AcountTypeDropdownList.DataBind (); } else { RegisterButton.Visible = false; } } }
public PlayerController() { var connector = new MongoDBConnector(); _playerService = new PlayerService(connector.GetDatabase()); }
bool EmailNotRegistered(string mail) { MongoDBConnector dbConnector = new MongoDBConnector (); var collection = dbConnector.GetCollection<User> ("Users"); var q = Query.EQ ("email", mail); return collection.Find (q).Count () == 0; }
public static Result SaveObjects(List <Object> objects) { Result result = new Result() { Code = ResultCode.Success }; try { foreach (Object obj in objects) { //new object to be saved... BsonDocument doc = GetBSONDocument(obj); //get if any existing object from db... //FilterDefinition<BsonDocument> fc = Builders<BsonDocument>.Filter.Eq(Constants.AttribObjectId,obj.Id); FilterDefinition <BsonDocument> fc = Builders <BsonDocument> .Filter.And(new FilterDefinition <BsonDocument>[] { Builders <BsonDocument> .Filter.Eq(Constants.AttribObjectId, obj.Id), Builders <BsonDocument> .Filter.Lt(Constants.AttribTimestamp, new BsonTimestamp((long)obj.Timestamp)) }); BsonDocument existing = MongoDBConnector.FindOne <BsonDocument>(obj.Type, fc); //find - ObjectId, order by timestamp desc top 1 if (existing != null) { existing.Remove("_id"); foreach (BsonElement e in doc.Elements) { existing[e.Name] = e.Value; } doc = existing; } Task.Run(() => MongoDBConnector.insert <BsonDocument>(doc, obj.Type)).Wait(); #region "Update future records" //to update future records if any.. BsonDocument filterCriteria = new BsonDocument(); filterCriteria.Add(Constants.AttribObjectId, obj.Id); filterCriteria.Add(Constants.AttribTimestamp, new BsonDocument().Add("$gte", new BsonTimestamp((long)obj.Timestamp))); List <BsonDocument> docs = null; try { docs = MongoDBConnector.find <BsonDocument>(obj.Type, filterCriteria); } catch { //no docs found... } if (docs != null) { foreach (BsonDocument futureDoc in docs) { bool changed = false; foreach (BsonElement e in doc.Elements) { if (futureDoc.Elements.Where(fe => fe.Name == e.Name).Count() == 0) { futureDoc.Add(e); changed = true; } } if (changed) { fc = Builders <BsonDocument> .Filter.Eq("_id", futureDoc.GetElement("_id").Value); Task.Run(() => MongoDBConnector.ReplaceOne <BsonDocument>(obj.Type, fc, futureDoc)).Wait(); } } } #endregion } } catch { result.Code = ResultCode.Error; } return(result); }
public DishController( MongoDBConnector mongoDBConnector ) { this._mongoDBConnector = mongoDBConnector; }
public void AddUser(NetworkMessage message) { StoredUserMessage msg = message.ReadMessage <StoredUserMessage>(); StoredUser user = msg.User; user.TestGroup = _config.TestGroup; //Generate random code: string code; var resultDb = MongoDBConnector.GetInstance().GetResultsDatabase(); var registeredUsersCollection = resultDb.GetCollection <BsonDocument>("Users"); int count; do { code = GenRandomCode(); count = registeredUsersCollection.Find(new BsonDocument { { "_id", code } }).Limit(1).ToList().Count; } while (count != 0); user.Code = code; var db = MongoDBConnector.GetInstance().GetDatabase(); var collection = db.GetCollection <BsonDocument>("Users"); var document = new BsonDocument { { "Name", user.Name }, { "TestGroup", user.TestGroup }, { "Code", user.Code }, { "Questionarie", new BsonDocument { { "AgeGroup", user.Results.AgeGroup }, { "TouchFrequency", user.Results.TouchFrequency }, { "None", user.Results.None }, { "Smaller5", user.Results.Smaller5 }, { "Smaller11", user.Results.Smaller11 }, { "Greater11", user.Results.Greater11 }, { "Activities", user.Results.Activities }, { "ColorPerception", user.Results.ColorPerception } } } }; collection.InsertOne(document); var devices = (user.Results.None.ToInt() << 3) + (user.Results.Smaller5.ToInt() << 2) + (user.Results.Smaller11.ToInt() << 1) + user.Results.Greater11.ToInt(); document = new BsonDocument { { "_id", code }, { "AgeGroup", user.Results.AgeGroup }, { "ColorPerception", user.Results.ColorPerception }, { "TouchFrequency", user.Results.TouchFrequency }, { "Activities", user.Results.Activities }, { "Devices", devices } }; registeredUsersCollection.InsertOne(document); var filter = Builders <BsonDocument> .Filter.Eq("_id", "UserCount"); var update = Builders <BsonDocument> .Update.Inc("Count", 1); resultDb.GetCollection <BsonDocument>("counters").FindOneAndUpdate(filter, update); }
public static ObjectState FindObjectState(string type, string id, double timestamp) { ObjectState objStateResult = new ObjectState() { Code = ResultCode.Success }; FilterDefinition <BsonDocument> fc = Builders <BsonDocument> .Filter.And(new FilterDefinition <BsonDocument>[] { Builders <BsonDocument> .Filter.Eq(Constants.AttribObjectId, id), Builders <BsonDocument> .Filter.Lte(Constants.AttribTimestamp, new BsonTimestamp((long)timestamp)) }); BsonDocument objState; try { objState = MongoDBConnector.FindOne <BsonDocument>(type, fc); } catch { objStateResult.Code = ResultCode.Error; return(objStateResult); } if (objState != null) { if (type.Equals("Invoice")) { //find the latest order record... BsonElement beOrderId = objState.Elements.Where(e => e.Name == "order_id").FirstOrDefault(); if (beOrderId != null) { fc = Builders <BsonDocument> .Filter.Eq("ObjectId", beOrderId.Value.ToString()); BsonDocument bOrder = MongoDBConnector.FindOne <BsonDocument>("Order", fc); if (bOrder != null) { bOrder.Remove("_id"); bOrder.Remove(Constants.AttribTimestamp); bOrder.Remove(Constants.AttribObjectId); objState.Add("OrderDetails", bOrder); } } //find the latest product records... BsonElement beProductIds = objState.Elements.Where(e => e.Name == "product_ids").FirstOrDefault(); if (beProductIds != null) { IEnumerable <string> productIds = ((BsonArray)beProductIds.Value).Select(e => e.ToString()).Distinct(); BsonDocument filterCriteria = new BsonDocument(); filterCriteria.Add("ObjectId", new BsonDocument("$in", new BsonArray(productIds))); IEnumerable <BsonDocument> bProducts = MongoDBConnector.find <BsonDocument>("Product", filterCriteria); if (bProducts != null && bProducts.Count() > 0) { bProducts = bProducts.GroupBy(d => d.GetElement(Constants.AttribObjectId).Value) .Select(grp => grp.OrderByDescending(d1 => d1.GetElement(Constants.AttribTimestamp)).First()); BsonArray baProducts = new BsonArray(bProducts); foreach (BsonDocument bdoc in baProducts) { bdoc.Remove("_id"); bdoc.Remove(Constants.AttribTimestamp); } objState.Add(new BsonElement("Products", baProducts)); } } } objState.Remove("_id"); objState.Remove(Constants.AttribTimestamp); objState.Remove(Constants.AttribObjectId); objStateResult.state = objState.ToJson().Replace(":", "=>"); } else { objStateResult.Code = ResultCode.NoRecordFound; return(objStateResult); } return(objStateResult); }
ObjectId CreateAccount(string emailField, string passwordField, string selectedValue) { MongoDBConnector dbConnector = new MongoDBConnector (); var collection = dbConnector.GetCollection<User> ("Users"); var roles = dbConnector.GetCollection<Role> ("Roles"); var q = Query.EQ ("type", selectedValue); var user = new User {email = emailField, password = passwordField, role = roles.FindOne(q).Id}; collection.Insert (user); collection.Save (user); return user.Id; }
public FarmerController( MongoDBConnector mongoDBConnector ) { this._mongoDBConnector = mongoDBConnector; }
public ValuesController(MongoDBConnector mongoDBConnector) { _mongoDBConnector = mongoDBConnector; }
public LinearSearchService() { MongoDBConnector.CreateSession("nliis"); }
public override void DictDeserialize(IDictionary <string, object> docu, Scenario scenario = Scenario.Database) { base.DictDeserialize(docu); var doc = docu as FreeDocument; if (doc.Children != null) { var items = doc.Children; foreach (var item in items) { var proces = new ProcessTask(); proces.Project = this; proces.DictDeserialize(item); Tasks.Add(proces); } } if (docu["DBConnections"] != null) { var items = docu["DBConnections"] as FreeDocument; if (items?.Children != null) { foreach (var item in items.Children) { var type = item["TypeName"].ToString(); var conn = PluginProvider.GetObjectByType <IDataBaseConnector>(type) as DBConnectorBase; if (conn == null) { continue; } conn.DictDeserialize(item); DBConnections.Add(conn); } } } if (DBConnections.FirstOrDefault(d => d.TypeName == "文件管理") == null) { var filemanager = new FileManager() { Name = "最近打开的文件" }; DBConnections.Add(filemanager); } if (DBConnections.FirstOrDefault(d => d.TypeName == "MongoDB") == null) { var mongo = new MongoDBConnector() { Name = "MongoDB连接器" }; mongo.DBName = "hawk"; DBConnections.Add(mongo); } if (DBConnections.FirstOrDefault(d => d.TypeName == "SQLite数据库") == null) { var sqlite = new SQLiteDatabase() { Name = "SQLite数据库" }; sqlite.DBName = "hawk-sqlite"; DBConnections.Add(sqlite); } }
public override void DictDeserialize(IDictionary <string, object> docu, Scenario scenario = Scenario.Database) { base.DictDeserialize(docu); var doc = docu as FreeDocument; if (doc.Children != null) { var items = doc.Children; foreach (var item in items) { var proces = new ProcessTask(); proces.Project = this; proces.DictDeserialize(item); Tasks.Add(proces); } } if (docu["DBConnections"] != null) { var items = docu["DBConnections"] as FreeDocument; if (items?.Children != null) { foreach (var item in items.Children) { var type = item["TypeName"].ToString(); var conn = PluginProvider.GetObjectByType <IDataBaseConnector>(type) as DBConnectorBase; if (conn == null) { continue; } conn.DictDeserialize(item); DBConnections.Add(conn); } } } if (docu["RunningTasks"] != null) { var tasks = docu["RunningTasks"] as FreeDocument; SavedRunningTasks = tasks?.Children; } if (docu["Parameters"] != null) { var tasks = docu["Parameters"] as FreeDocument; if (tasks != null) { Parameters.AddRange(tasks?.Children?.Select(d => { var param = new ParameterItem(); param.UnsafeDictDeserialize(d); return(param); })); } } ConfigSelector.SelectItem = docu["ParameterName"].ToString(); if (DBConnections.FirstOrDefault(d => d.TypeName == GlobalHelper.Get("FileManager")) == null) { var filemanager = new FileManager { Name = GlobalHelper.Get("recent_file") }; DBConnections.Add(filemanager); } if (DBConnections.FirstOrDefault(d => d.TypeName == "MongoDB") == null) { var mongo = new MongoDBConnector { Name = "MongoDB连接器" }; mongo.DBName = "hawk"; DBConnections.Add(mongo); } if (DBConnections.FirstOrDefault(d => d.TypeName == GlobalHelper.Get("SQLiteDatabase")) == null) { var sqlite = new SQLiteDatabase { Name = GlobalHelper.Get("SQLiteDatabase") }; sqlite.DBName = "hawk-sqlite"; DBConnections.Add(sqlite); } }
public static MongoDBConnector GetInstance() { return(_instance ?? (_instance = new MongoDBConnector())); }