public void Post(int id_device, int id_user) { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); var filter = new BsonDocument("Id_Device", id_device); var documents = collect.Find(filter).ToList(); foreach (var item in documents) { var jsonWriterSettings = new JsonWriterSettings { OutputMode = JsonOutputMode.Strict }; // key part dynamic data = JObject.Parse(item.ToJson(jsonWriterSettings)); data.Id_User = id_user; string output = Newtonsoft.Json.JsonConvert.SerializeObject(data); BsonDocument document = BsonSerializer.Deserialize <BsonDocument>(output); collect.ReplaceOne(item, document); } }
public double GetAvgAll(string name) { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); var filter = new BsonDocument("Name", name); var documents = collect.Find(filter).ToList(); double[] myTable = new double[documents.Count]; for (int i = 0; i < documents.Count; i++) { var jsonWriterSettings = new JsonWriterSettings { OutputMode = JsonOutputMode.Strict }; // key part dynamic data = JObject.Parse(documents[i].ToJson(jsonWriterSettings)); myTable[i] = data.Value; } double myresult = myTable.Average(); return(myresult); }
// GET api/values public List <JObject> Get() { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); var documents = collect.Find(new BsonDocument()).ToList(); List <JObject> dataAll = new List <JObject>(); for (int i = 0; i < documents.Count; i++) { var jsonWriterSettings = new JsonWriterSettings { OutputMode = JsonOutputMode.Strict }; // key part var data = JObject.Parse(documents[i].ToJson(jsonWriterSettings)); dataAll.Add(data); } string json = Newtonsoft.Json.JsonConvert.SerializeObject(dataAll); return(dataAll); }
// DELETE api/values/5 public void Delete() { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); database.DropCollection(collectionName); }
// POST api/values public void Post(Device devices) { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); string output = Newtonsoft.Json.JsonConvert.SerializeObject(devices); BsonDocument document = BsonSerializer.Deserialize <BsonDocument>(output); collect.InsertOneAsync(document); }
// PUT api/values/5 public void Put(int id, User user) { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); var filter = new BsonDocument("Id_User", id); string output = Newtonsoft.Json.JsonConvert.SerializeObject(user); BsonDocument document = BsonSerializer.Deserialize <BsonDocument>(output); collect.ReplaceOne(filter, document); }
/* * // GET api/values/5 * public List<dynamic> Get(int id) * { * var bdd = new MongoClient("mongodb://localhost:27017"); * var database = bdd.GetDatabase("DBR"); * var collect = database.GetCollection<BsonDocument>("user"); * * var filter = new BsonDocument("Id_User", id); * var documents = collect.Find(filter).ToList(); * * List<dynamic> dataAll = new List<dynamic>(); * * for (int i = 0; i < documents.Count; i++) * { * var jsonWriterSettings = new JsonWriterSettings { OutputMode = JsonOutputMode.Strict }; // key part * dynamic data = JObject.Parse(documents[i].ToJson(jsonWriterSettings)); * dataAll.Add(data); * } * return dataAll; * }*/ // POST api/values public void Post(User user) { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); //var documents = collect.Find(new BsonDocument()).ToList(); user.Password = Crypto.GenerateSHA512String(user.Password); string output = Newtonsoft.Json.JsonConvert.SerializeObject(user); BsonDocument document = BsonSerializer.Deserialize <BsonDocument>(output); collect.InsertOneAsync(document); }
public string Post(string name, string password) { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); string message = "No Existant"; //var builder = Builders<BsonDocument>.Filter; //var filter = builder.Eq("Name", name) & builder.Eq("Password", password); var filter = new BsonDocument("Login", name); var documents = collect.Find(new BsonDocument(filter)).ToList(); List <dynamic> dataAll = new List <dynamic>(); for (int i = 0; i < documents.Count; i++) { var jsonWriterSettings = new JsonWriterSettings { OutputMode = JsonOutputMode.Strict }; // key part dynamic data = JObject.Parse(documents[i].ToJson(jsonWriterSettings)); if (data.Password == Crypto.GenerateSHA512String(password)) { message = "ok"; } else { message = "no"; } } string json = message.ToJson(); return(message); }
// GET api/values/5 public List <JObject> Get(int id) { BddConnector bddConnector = new BddConnector(); var myClient = bddConnector.myConnection(); var database = myClient.GetDatabase(dbName); var collect = database.GetCollection <BsonDocument>(collectionName); var filter = new BsonDocument("Id_Device", id); var documents = collect.Find(filter).ToList(); List <JObject> dataAll = new List <JObject>(); for (int i = 0; i < documents.Count; i++) { var jsonWriterSettings = new JsonWriterSettings { OutputMode = JsonOutputMode.Strict }; // key part var data = JObject.Parse(documents[i].ToJson(jsonWriterSettings)); dataAll.Add(data); } return(dataAll); }