private static string[][] GetData()
{
// var db = new SQLiteDatabase(@"..\..\ProductsTaxes.sqlite");
var db = new GirlsTaxesEntities();
DataTable table;
//String query = "select * from ProductTaxes";
//table = db.GetDataTable(query);
List <GirlsTax> ptList = db.GirlsTaxes.Select(n => n).ToList();
var mysqlContext = new GirlAgencyMySql.Data.MySql();
var girlsExpences = mysqlContext.Orders.Select(v => new
{
FirstName = v.Girl.FirstName,
LastName = v.Girl.LastName,
Income = v.Girl.PricePerHour * v.Duration
//Expense = v.Expenses.Select(e => e.Money).FirstOrDefault(),
//Income = mysqlContext.Products.Where(p => p.VendorId == v.Id).Select(p => p.Income).FirstOrDefault(),
//Products = mysqlContext.Products.Where(p => p.VendorId == v.Id).Select(p => p.Id)
}).ToList();
List <string[]> dataList = new List <string[]>();
for (int i = 0; i < girlsExpences.Count; i++)
{
decimal vendorTax = 0;
foreach (var product in girlsExpences[i].FirstName)
{
foreach (var productTax in ptList)
{
if (productTax.id == product)
{
vendorTax += Convert.ToDecimal(productTax.Tax) / 100 * girlsExpences[i].Income;
}
}
}
string[] dataObj =
{
girlsExpences[i].FirstName.ToString(),
girlsExpences[i].Income.ToString(),
//(girlsExpences[i]. ?? 0).ToString(),
vendorTax.ToString(),
//(girlsExpences[i].Income - (girlsExpences[i].Expense ?? 0) - vendorTax).ToString()
};
dataList.Add(dataObj);
}
return(dataList.ToArray());
}
private static string[][] GetData()
{
// var db = new SQLiteDatabase(@"..\..\ProductsTaxes.sqlite");
var db = new GirlsTaxesEntities();
DataTable table;
//String query = "select * from ProductTaxes";
//table = db.GetDataTable(query);
List<GirlsTax> ptList = db.GirlsTaxes.Select(n=>n).ToList();
var mysqlContext = new GirlAgencyMySql.Data.MySql();
var girlsExpences = mysqlContext.Orders.Select(v => new
{
FirstName = v.Girl.FirstName,
LastName = v.Girl.LastName,
Income = v.Girl.PricePerHour * v.Duration
//Expense = v.Expenses.Select(e => e.Money).FirstOrDefault(),
//Income = mysqlContext.Products.Where(p => p.VendorId == v.Id).Select(p => p.Income).FirstOrDefault(),
//Products = mysqlContext.Products.Where(p => p.VendorId == v.Id).Select(p => p.Id)
}).ToList();
List<string[]> dataList = new List<string[]>();
for (int i = 0; i < girlsExpences.Count; i++)
{
decimal vendorTax = 0;
foreach (var product in girlsExpences[i].FirstName)
{
foreach (var productTax in ptList)
{
if (productTax.id == product)
{
vendorTax += Convert.ToDecimal(productTax.Tax) / 100 * girlsExpences[i].Income;
}
}
}
string[] dataObj =
{
girlsExpences[i].FirstName.ToString(),
girlsExpences[i].Income.ToString(),
//(girlsExpences[i]. ?? 0).ToString(),
vendorTax.ToString(),
//(girlsExpences[i].Income - (girlsExpences[i].Expense ?? 0) - vendorTax).ToString()
};
dataList.Add(dataObj);
}
return dataList.ToArray();
}
