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