public static List<VendorData> QueryIt() { TaxesEntities context = new TaxesEntities(); var connectionStr = "mongodb://localhost"; var client = new MongoClient(connectionStr); var server = client.GetServer(); var db = server.GetDatabase("supermarketExtra"); var dbExpenses = db.GetCollection<MongoVendorExpense>(vendorCollectionString); var prodReport = db.GetCollection<MongoProductReport>(productColelctionString); List<VendorData> list = new List<VendorData>(); int month = 3; int year = 1998; var vendorsMongo = from p in dbExpenses.AsQueryable<MongoVendorExpense>() where p.Month == month && p.Year == year select p; foreach (var vendor in vendorsMongo) { decimal totalIncome = 0; decimal totalTaxes = 0; decimal Expenses = vendor.Amount; decimal result = 0; var products = from p in prodReport.AsQueryable<MongoProductReport>() where p.VendorName == vendor.VendorName select p; foreach (var product in products) { var res = from p in context.Taxes where p.ProductName == product.ProductName select p; decimal taxSize = Convert.ToDecimal(res.FirstOrDefault().TaxSize); decimal productTax = product.TotalIncomes * 0.01M * taxSize; totalTaxes += productTax; totalIncome += product.TotalIncomes - productTax; } result = totalIncome - totalTaxes - Expenses; list.Add(new VendorData(vendor.VendorName, totalIncome, totalTaxes, Expenses, result)); } return list; }
private static void PrintSQlDB() { TaxesEntities context = new TaxesEntities(); var query = from p in context.Taxes select p; Console.WriteLine("SQL DB:"); foreach (var data in query) { Console.WriteLine(data.ProductName + " has tax: " + data.TaxSize + "%"); } }
public static void InsertSQLiteData() { TaxesEntities context = new TaxesEntities(); context.Taxes.Add(new Tax() { ProductName = "Zagorka", TaxSize = 20 }); context.Taxes.Add(new Tax() { ProductName = "Kamenitza", TaxSize = 20 }); context.Taxes.Add(new Tax() { ProductName = "Amstel", TaxSize = 10 }); context.Taxes.Add(new Tax() { ProductName = "Korola", TaxSize = 20 }); context.SaveChanges(); }