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