static void Main() { MongoClient mongoClient = new MongoClient("mongodb://localhost/"); MongoServer mongoServer = mongoClient.GetServer(); MongoDatabase supermarket = mongoServer.GetDatabase("teamwork-sidecar"); MongoCollection expences = supermarket.GetCollection("expences"); using (var db = new SupermarketDB()) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load("../../../../fileVendors-Expenses.xml"); string salePath = "/sales/sale"; XmlNodeList sales = xmlDoc.SelectNodes(salePath); int count = 1; foreach (XmlElement item in sales) { string name = item.GetAttribute("vendor"); Vendor vendor = db.Vendors.First(x => x.VendorName == name); if (vendor != null) { var expencesss = item.SelectNodes("expenses"); foreach (XmlElement expence in expencesss) { string month = expence.GetAttribute("month"); decimal amount = decimal.Parse(expence.InnerText); var vendorExpence = new VendorExpence(); vendorExpence.VendorId = vendor.ID; vendorExpence.Month = month; vendorExpence.Ammount = amount; db.VendorExpence.Add(vendorExpence); // used for MongoDB vendorExpence.Id = count++; AddExpenceToMongoDB(expences, vendorExpence); } } } db.SaveChanges(); } }
static void AddExpenceToMongoDB(MongoCollection expences, VendorExpence vendorExpence) { expences.Insert(vendorExpence); }