static void LoadVendor()
{
ParadiseSupermarketChainEntities sqlCon = new ParadiseSupermarketChainEntities();
using (sqlCon)
{
MongoWriter mongo = new MongoWriter("Expenses");
XmlReader reader = new XmlReader("E:\\Vendor-Expenses.xml");
while (reader.ReadNextSale())
{
while (reader.ReadNextExpenses())
{
mongo.WriteExpenses(reader.Vendor, reader.Month, reader.Expenses);
var expence = new EntityFramework.Data.Expenses()
{
Expenses1 = decimal.Parse(reader.Expenses),
ExpensesDate = DateTime.Parse(reader.Month)
};
int vendorIdd = 1;
var VendorId =
from vendor in sqlCon.Vendors
where vendor.Name == reader.Vendor
select new
{
Id = vendor.Id
};
var vendorIdc = sqlCon.Vendors.Where(v => v.Name == reader.Vendor).FirstOrDefault();
expence.VendorId = vendorIdd;
sqlCon.Expenses.Add(expence);
sqlCon.SaveChanges();
}
}
}
}
