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);
}
