public void CheckInsertOrNotForKitchen() { InventoryKitchenStockReportDAO aInventoryKitchenStockReportDao = new InventoryKitchenStockReportDAO(); bool check = aInventoryKitchenStockReportDao.CheckInsertOrNotForKitchen(); if (check) { InsertInventoryKitchenStock(); } }
public void InsertInventoryKitchenStock() { List <InventoryStockReport> aInventoryStockReports = new List <InventoryStockReport>(); DateTime todate = DateTime.Today; DateTime fromdate = todate.AddDays(-1); todate = todate.AddSeconds(-1); aInventoryStockReports = GetTodayReport(fromdate, todate); InventoryKitchenStockReportDAO aInventoryKitchenStockReportDao = new InventoryKitchenStockReportDAO(); aInventoryKitchenStockReportDao.InsertInventoryKitchenStock(aInventoryStockReports); }
public List <InventoryStockReport> GetSaleReport(List <InventoryStockReport> aInventoryStockReports, DateTime fromdate, DateTime todate) { InventoryKitchenStockReportDAO aInventoryStockReportDao = new InventoryKitchenStockReportDAO(); List <InventoryStockReport> aList = new List <InventoryStockReport>(); aList = aInventoryStockReportDao.GetSaleReport(fromdate, todate); foreach (InventoryStockReport report in aInventoryStockReports) { report.BalancePrice = report.BalanceQty * report.UnitPrice; foreach (InventoryStockReport stockReport in aList) { if (stockReport.Date == report.Date && stockReport.ItemId == report.ItemId) { report.SaleQty = stockReport.SaleQty; report.Price = stockReport.Price; } } } List <InventoryStockReport> aList2 = new List <InventoryStockReport>(); foreach (InventoryStockReport stockReport in aList) { int flag = 0; foreach (InventoryStockReport report in aInventoryStockReports) { if (stockReport.Date == report.Date && stockReport.ItemId == report.ItemId) { flag = 1; } } if (flag == 0) { InventoryItem aInventoryItem = aInventoryItemBll.GetInventoryItem(stockReport.ItemId); stockReport.ItemName = aInventoryItem.ItemName; stockReport.CategoryName = aInventoryItem.CategoryName; aList2.Add(stockReport); } } aInventoryStockReports.AddRange(aList2); return(aInventoryStockReports); }
public List <InventoryStockReport> GetInventoryKitchenStockReportBetweenDate(DateTime fromdate, DateTime todate) { List <InventoryStockReport> aInventoryStockReports = new List <InventoryStockReport>(); List <InventoryStockReport> aInventoryStockReports1 = new List <InventoryStockReport>(); InventoryKitchenStockReportDAO aInventoryStockReportDao = new InventoryKitchenStockReportDAO(); aInventoryStockReports = aInventoryStockReportDao.GetInventoryKitchenStockReportBetweenDate(fromdate, todate); if (todate >= DateTime.Today) { DateTime todate1 = DateTime.Today.AddDays(1); DateTime fromdate1 = DateTime.Today; todate1 = todate.AddSeconds(-1); aInventoryStockReports1 = GetTodayReport(fromdate1, todate1); foreach (InventoryStockReport report in aInventoryStockReports1) { aInventoryStockReports.Add(report); } } aInventoryStockReports = GetSaleReport(aInventoryStockReports, fromdate, todate); return(aInventoryStockReports); }