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