static public Usuari SelectUser(String correu) { //_client = new MongoClient(); //database = _client.GetDatabase("prova"); var client = new MongoClient("mongodb://localhost"); var coll = client.GetServer().GetDatabase("prova").GetCollection("Usuaris"); var query = Query.EQ("mail", correu); var doc2 = coll.FindOne(query); MongoDB.Bson.BsonValue valueName = null; MongoDB.Bson.BsonValue valueBirth = null; MongoDB.Bson.BsonValue valueMail = null; if (doc2 != null) { valueName = doc2["name"]; valueMail = doc2["mail"]; valueBirth = doc2["birthdate"]; } bool comp = false; if (valueMail != null && valueName != null) { if (valueMail.AsString == correu) { user.name = valueName.AsString; user.mail = valueMail.AsString; user.birthdate = valueBirth.AsString; } } return(user); }
static protected bool SelectLogIn(string correu, string pw) { //_client = new MongoClient(); //database = _client.GetDatabase("prova"); var client = new MongoClient("mongodb://localhost"); var coll = client.GetServer().GetDatabase("prova").GetCollection("Usuaris"); /*gustos.Add(new BsonDocument{ //Codi per a posar un array dintre del document * {"tastes", tast} * });*/ //var collection = _database.GetCollection<BsonDocument>("Usuaris"); //var filter = Builders<BsonDocument>.Filter.Eq("name", user.name); //var count = 0; //var batch = new BsonDocument(); //using (var cursor = await collection.FindAsync(filter)) //{ // while (await cursor.MoveNextAsync()) // { // batch= cursor.Current; // foreach (var document in batch) // { // // process document // count++; // } // } //} var query = Query.EQ("mail", correu); var doc2 = coll.FindOne(query); MongoDB.Bson.BsonValue valueMail = null; MongoDB.Bson.BsonValue valuePw = null; if (doc2 != null) { valueMail = doc2["mail"]; valuePw = doc2["pw"]; } bool comp = false; if (valueMail != null && valuePw != null) { if (valueMail.AsString == correu && Encrypt.Desencriptar(valuePw.AsString, "") == pw) { comp = true; } } return(comp); }
private void AddToTrxActions(IList <TrxAction> trxActions, BsonDocument actionDoc) { string act_digest = actionDoc.GetValue("block_num").AsInt32.ToString() + "-" + actionDoc.GetValue("receipt").AsBsonDocument.GetValue("act_digest").AsString; BsonDocument asBsonDocument = actionDoc.GetValue("act").AsBsonDocument; string account = asBsonDocument.GetValue("account").AsString; string name = asBsonDocument.GetValue("name").AsString; string data_hex = string.Empty; MongoDB.Bson.BsonValue data = MongoDB.Bson.BsonNull.Value; BsonValue dataValue; BsonValue hexDataValue; if (asBsonDocument.TryGetValue("hex_data", out hexDataValue) && asBsonDocument.TryGetValue("data", out dataValue)) { data = dataValue; data_hex = hexDataValue.AsString; } else if (asBsonDocument.TryGetValue("hex_data", out hexDataValue)) { data_hex = hexDataValue.AsString; } else if (asBsonDocument.TryGetValue("data", out dataValue)) { data_hex = dataValue.AsString; } string trx_id = actionDoc.GetValue("trx_id").AsString; int block_num = actionDoc.GetValue("block_num").AsInt32; string block_time = actionDoc.GetValue("block_time").AsString; TrxAction trxAction = new TrxAction() { act_digest = act_digest, trx_id = trx_id, block_num = (long)block_num, block_time = block_time, account = account, name = name, data = data, data_hex = data_hex }; if (trxActions.Any <TrxAction>((Func <TrxAction, bool>)(ad => ad.act_digest == act_digest))) { return; } trxActions.Add(trxAction); }
public async Task ReSetAppliedTransactionsAsync() { var collection = this.m_Database.GetCollection <BsonDocument>(this.m_TrxActionsCollectionName); using (var cursor = await collection.FindAsync <BsonDocument>(new BsonDocument("data_error", true))) { while (true) { if (await cursor.MoveNextAsync()) { foreach (BsonDocument bsonDocument in cursor.Current) { BsonDocument document = bsonDocument; MongoDB.Bson.BsonValue _id = document.GetValue("_id"); string account = document.GetValue("account").AsString; string name = document.GetValue("name").AsString; string data_hex = document.GetValue("data_hex").AsString; bool has_hex = !string.IsNullOrEmpty(data_hex); MongoDB.Bson.BsonValue data = (MongoDB.Bson.BsonValue)null; if (has_hex) { string parsedData = await this.m_ABIService.ParseAsync(account, name, data_hex); if (!string.IsNullOrEmpty(parsedData)) { data = BsonDocument.Parse(parsedData).GetValue("args"); } } bool flag = has_hex && data == (MongoDB.Bson.BsonValue)BsonNull.Value; if (!flag) { document["data"] = data; document["data_error"] = (MongoDB.Bson.BsonValue)flag; await collection.ReplaceOneAsync(new BsonDocument("_id", _id), document, this.m_UpdateOptions); } _id = (MongoDB.Bson.BsonValue)null; data = (MongoDB.Bson.BsonValue)null; document = (BsonDocument)null; } } else { break; } } } }