public static void GetPushTransaction() { string timestamp = DateTime.UtcNow.Date.Month.ToString() + "/" + DateTime.UtcNow.Date.Day.ToString() + "/" + DateTime.UtcNow.Date.Year.ToString(); int count = 0; MongoDatabase db = ConnectToMongoDB(); var transaction = db.GetCollection<RawBsonDocument>("Transaction"); var query = Query.EQ("timestamp", timestamp); var transactions = transaction.Find(query); Console.WriteLine("Pushing Transaction data"); foreach (var value in transactions) { AzureDcClient client = new AzureDcClient(); transactionsType tr = new transactionsType(); tr.name = value[1].ToString(); tr.cost = Double.Parse(value[2].ToString()); tr.quantity = value[3].ToString(); tr.storeID = Double.Parse(value[4].ToString()); client.InsertTransaction(tr, value[5].ToString()); } Console.WriteLine("Product Transaction pushed. Total of " + count + " transactions inserted\n"); }
public void InsertData(Transaction transaction,string userID) { transactionsType tr = new transactionsType(); tr.name = transaction.Name; tr.ID = transaction.ID; tr.cost = transaction.cost; tr.quantity = transaction.quantity; tr.storeID = transaction.storeID; AzureDcClient client = new AzureDcClient(); string res = client.InsertTransaction(tr, userID); //MongoDatabase db = ConnectToMongoDB(); //var collection = db.GetCollection<BsonDocument>("Transaction"); //var id3 = ObjectId.GenerateNewId(); //BsonDocument transaction = new BsonDocument() // .Add("_id", id3) // .Add("name", tr.Name) // .Add("cost", tr.cost) // .Add("storeID", tr.storeID) // .Add("quantity", tr.quantity); //collection.Insert(transaction); }