internal static void GenerateExcel() { using (TaxesEntities taxesEntities = new TaxesEntities()) { IQueryable <ExcelProductReport> searchQuery = from e in taxesEntities.Expences join r in taxesEntities.Reports on e.VendorName equals r.VendorName join t in taxesEntities.Taxes on r.ProductName equals t.ProductName where e.CurrentMoth.Month == DateTime.Now.Month group new { e, r, t } by new { e.VendorName, } into grouped select new ExcelProductReport { VendorName = grouped.Key.VendorName, Income = grouped.Sum(x => x.r.TotalIncome), Expences = grouped.Sum(x => x.e.CurrentExpence), Taxes = grouped.Sum(x => x.t.Tax1) }; GenerateExcel(searchQuery, "../../report.xlsx"); } }
public static void FillSQLite() { using (TaxesEntities taxes = new TaxesEntities()) { var mongo = new MongoDBProvider(); var allExpences = mongo.ListAllExpenses(); var allReporst = mongo.ListAllReports(); foreach (var report in allReporst) { Report reportToInsert = new Report(); reportToInsert.TotalIncome = report.TotalIncomes; reportToInsert.TotalQuantitySold = report.TotalQuantitySold; reportToInsert.VendorName = report.VendorName; reportToInsert.ProductName = report.ProductName; taxes.Reports.Add(reportToInsert); } taxes.SaveChanges(); foreach (var expence in allExpences) { Expence expenceToInsert = new Expence(); expenceToInsert.CurrentExpence = expence.CurrentExpense; expenceToInsert.CurrentMoth = expence.CurrentMonth; expenceToInsert.VendorName = expence.VendorName; taxes.Expences.Add(expenceToInsert); } taxes.SaveChanges(); } }