internal List <InventoryStockVm> GetStockReportList(InventoryReportVm reportVm) { List <InventorySale> sales = _reportDal.GetSalesByReportVm(reportVm); List <Order> orders = _reportDal.GetOrdersByReportVm(reportVm); if (orders != null) { foreach (var item in orders) { foreach (var itemDes in item.OrderDetail) { InventoryStockVm stockVm = new InventoryStockVm(); if (StockReportList.Any(m => m.ItemName == itemDes.Item.Name) == false) { stockVm.ItemName = itemDes.Item.Name; stockVm.StockQuantity = _common.GetItemStockById(itemDes.Item.Id); stockVm.CategoryFullPath = GetCategoryFullPathById(itemDes.Item.Id); stockVm.Price = itemDes.Item.CostPrice; StockReportList.Add(stockVm); } } } } return(StockReportList.ToList()); }
internal InventoryIncomeVm GetIncomeVmByReportVm(InventoryReportVm reportVm) { decimal totalIncome = 0; decimal totalSales = 0; decimal totalOrder = 0; List <InventorySale> sales = _reportDal.GetSalesByReportVm(reportVm); List <Order> orders = _reportDal.GetOrdersByReportVm(reportVm); if (sales != null) { foreach (var item in sales) { totalSales = totalSales + item.Total; } } if (orders != null) { foreach (var item in orders) { totalOrder = totalOrder + item.Total; } } totalIncome = totalSales - totalOrder; InventoryIncomeVm incomeVm = new InventoryIncomeVm(); incomeVm.Sales = sales; incomeVm.Orders = orders; incomeVm.SalesTotal = totalSales; incomeVm.OrdersTotal = totalOrder; incomeVm.TotalIncome = totalIncome; return(incomeVm); }
public ActionResult SalesReport(InventoryReportVm reportVm) { List <InventorySale> inventorySales = _reportBll.GetSalesByReportVm(reportVm); _salesPdf = inventorySales; ViewBag.OutletId = _reportBll.GetOutlet(); return(View(inventorySales)); }
public ActionResult OrderReport(InventoryReportVm reportVm) { List <Order> orders = _reportBll.GetOrdersByReportVm(reportVm); OrdersPdf = orders; ViewBag.OutletId = _reportBll.GetOutlet(); return(View(orders)); }
public ActionResult Expense(InventoryReportVm reportVm) { List <Expense> Expenses = _reportBll.GetExpensesByReportVm(reportVm); ExpensesPdf = Expenses; ViewBag.OutletId = _reportBll.GetOutlet(); return(View(Expenses)); }
public ActionResult StockReport(InventoryReportVm reportVm) { List <InventoryStockVm> stockReportList = _reportBll.GetStockReportList(reportVm); _stockReportListPdf = stockReportList; ViewBag.OutletId = _reportBll.GetOutlet(); return(View(stockReportList)); }
public ActionResult IncomeReport(InventoryReportVm reportVm) { InventoryIncomeVm incomeVm = _reportBll.GetIncomeVmByReportVm(reportVm); _incomeVmForPdf = incomeVm; ViewBag.OutletId = _reportBll.GetOutlet(); return(View(incomeVm)); }
internal List <Order> GetOrdersByReportVm(InventoryReportVm reportVm) { var orders = _db.Orders.AsQueryable(); if (reportVm.OutletId != null) { orders = orders.Where(m => m.OutletId == reportVm.OutletId && m.IsDeleted == false).AsQueryable(); } if (reportVm.Code != null) { orders = orders.Where(m => m.Id == reportVm.Code && m.IsDeleted == false).AsQueryable(); } if (reportVm.FromDate != null) { orders = orders.Where(m => m.OrderDate >= reportVm.FromDate && m.IsDeleted == false).AsQueryable(); } if (reportVm.ToDate != null) { orders = orders.Where(m => m.OrderDate <= reportVm.ToDate && m.IsDeleted == false).AsQueryable(); } return(orders.ToList()); }
internal List <InventorySale> GetSalesByReportVm(InventoryReportVm reportVm) { var sales = _db.InventorySales.AsQueryable(); if (reportVm.OutletId != null) { sales = sales.Where(m => m.OutletId == reportVm.OutletId && m.IsDeleted == false).AsQueryable(); } if (reportVm.Code != null) { sales = sales.Where(m => m.Id == reportVm.Code && m.IsDeleted == false).AsQueryable(); } if (reportVm.FromDate != null) { sales = sales.Where(m => m.SaleDate >= reportVm.FromDate && m.IsDeleted == false).AsQueryable(); } if (reportVm.ToDate != null) { sales = sales.Where(m => m.SaleDate <= reportVm.ToDate && m.IsDeleted == false).AsQueryable(); } return(sales.ToList()); }
internal List <Expense> GetExpensesByReportVm(InventoryReportVm reportVm) { var expenses = _db.Expenses.AsQueryable(); if (reportVm.OutletId != null) { expenses = expenses.Where(m => m.OutletId == reportVm.OutletId && m.IsDeleted == false).AsQueryable(); } if (reportVm.Code != null) { expenses = expenses.Where(m => m.Id == reportVm.Code && m.IsDeleted == false).AsQueryable(); } if (reportVm.FromDate != null) { expenses = expenses.Where(m => m.ExpenseDate >= reportVm.FromDate && m.IsDeleted == false).AsQueryable(); } if (reportVm.ToDate != null) { expenses = expenses.Where(m => m.ExpenseDate <= reportVm.ToDate && m.IsDeleted == false).AsQueryable(); } return(expenses.ToList()); }
internal List <InventorySale> GetSalesByReportVm(InventoryReportVm reportVm) { List <InventorySale> sales = _reportDal.GetSalesByReportVm(reportVm); return(sales); }
internal List <Order> GetOrdersByReportVm(InventoryReportVm reportVm) { List <Order> orders = _reportDal.GetOrdersByReportVm(reportVm); return(orders); }
internal List <Expense> GetExpensesByReportVm(InventoryReportVm reportVm) { List <Expense> expenses = _reportDal.GetExpensesByReportVm(reportVm); return(expenses); }