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