public List <InventoryStockReport> GetInventoryStockReportBetweenDateForKitchen(DateTime fromdate, DateTime todate)
{
List <InventoryStockReport> aInventoryStockReports = new List <InventoryStockReport>();
try
{
this.OpenConnection();
string sqlComm = String.Format(SqlQueries.GetQuery(Query.GetInventoryStockReportBetweenDateForKitchen), fromdate,
todate);
IDataReader aReader = this.ExecuteReader(sqlComm);
if (aReader != null)
{
while (aReader.Read())
{
InventoryStockReport aReport = new InventoryStockReport();
aReport = ReaderToReadAllStock(aReader);
aInventoryStockReports.Add(aReport);
}
}
}
catch (Exception ex)
{
throw new Exception("GetInventoryStockReportBetweenDateForKitchen()", ex);
}
finally
{
this.CloseConnection();
}
return(aInventoryStockReports);
}
private InventoryStockReport ReaderToReadSaleReport(IDataReader aReader)
{
InventoryStockReport aStockReport = new InventoryStockReport();
try
{
aStockReport.Date = Convert.ToDateTime(aReader["date"]);
}
catch
{
}
try
{
aStockReport.ItemId = Convert.ToInt32(aReader["item_id"]);
}
catch
{
}
try
{
aStockReport.SaleQty = Convert.ToDouble(aReader["item_qty"]);
}
catch
{
}
try
{
aStockReport.Price = Convert.ToDouble(aReader["sale_price"]);
}
catch
{
}
return(aStockReport);
}
public ActionResult InventoryStockReport()
{
List <InventoryStockReport> InventoryStockList = new List <InventoryStockReport>();
Property p = new Property();
DataSet ds = new DataSet();
p.OnTable = "GetInventoryStockRecord";
ds = dl.GetInventoryStockReport_sp(p);
try
{
foreach (DataRow item in ds.Tables[0].Rows)
{
InventoryStockReport m = new InventoryStockReport();
m.ItemName = item["ItemName"].ToString();
m.Category = item["Category"].ToString();
m.SupplierName = item["SupplierName"].ToString();
m.StoreName = item["StoreName"].ToString();
m.AvailableQuantity = item["AvailableQuantity"].ToString();
m.Quantity = item["Quantity"].ToString();
InventoryStockList.Add(m);
}
ViewBag.InventoryStockList = InventoryStockList;
}
catch (Exception ex)
{
}
return(View());
}
public List <InventoryStockReport> GetAllKitchenStockForReport()
{
List <InventoryStockReport> aReports = new List <InventoryStockReport>();
try
{
this.OpenConnection();
string sqlComm = String.Format(SqlQueries.GetQuery(Query.AllInventoryKitchenStock));
IDataReader aReader = this.ExecuteReader(sqlComm);
if (aReader != null)
{
while (aReader.Read())
{
InventoryStockReport aReport = new InventoryStockReport();
aReport = ReaderToReadAllStock(aReader);
aReports.Add(aReport);
}
}
}
catch (Exception ex)
{
throw new Exception("GetAllKitchenStockForReport()", ex);
}
finally
{
this.CloseConnection();
}
return(aReports);
}
private InventoryStockReport ReaderToReadAllStock(IDataReader aReader)
{
InventoryStockReport aStockReport = new InventoryStockReport();
try
{
aStockReport.CategoryId = Convert.ToInt32(aReader["category_id"]);
}
catch
{
}
try
{
aStockReport.CategoryName = (aReader["category_name"]).ToString();
}
catch
{
}
try
{
aStockReport.ItemId = Convert.ToInt32(aReader["item_id"]);
}
catch
{
}
try
{
aStockReport.ItemName = (aReader["item_name"]).ToString();
}
catch
{
}
try
{
aStockReport.BalanceQty = Convert.ToDouble(aReader["stock"]);
}
catch
{
}
try
{
aStockReport.Unit = (aReader["unit"]).ToString();
}
catch
{
}
try
{
aStockReport.UnitPrice = Convert.ToDouble(aReader["unit_price"]);
}
catch
{
}
return(aStockReport);
}
private void LoadData()
{
InventoryPurchaseBLL aInventoryPurchaseBll = new InventoryPurchaseBLL();
List <InventoryPurchase> aInventoryPurchases = new List <InventoryPurchase>();
aInventoryPurchases = aInventoryPurchaseBll.GetInventoryPurchaseById(itemId);
aInventoryPurchases = aInventoryPurchases.OrderByDescending(a => a.Date).ToList();
DateTime fromdate = DateTime.Now.Date;
DateTime todate = DateTime.Now.Date;
todate = todate.AddDays(1);
fromdate = fromdate.Date;
todate = todate.Date;
todate = todate.AddSeconds(-1);
List <InventoryStockReport> aInventoryStockReports = new List <InventoryStockReport>();
InventoryStockReportBLL aBll = new InventoryStockReportBLL();
aInventoryStockReports = aBll.GetInventoryStockReportBetweenDate(fromdate, todate);
InventoryStockReport aInventoryStockReport = aInventoryStockReports.SingleOrDefault(a => a.ItemId == itemId);
List <InventoryPurchase> tempInventoryPurchases = new List <InventoryPurchase>();
double sum = 0;
foreach (InventoryPurchase inventoryPurchase in aInventoryPurchases)
{
sum += inventoryPurchase.Quantity;
if (sum >= aInventoryStockReport.BalanceQty)
{
double qty = sum - aInventoryStockReport.BalanceQty;
inventoryPurchase.Quantity -= qty;
tempInventoryPurchases.Add(inventoryPurchase);
break;
}
else
{
tempInventoryPurchases.Add(inventoryPurchase);
}
}
var item = tempInventoryPurchases.Select(a => new { ItemName = a.Item.ItemName, Qty = a.Quantity, ExpireDate = a.ExpireDate, PurchaseDate = a.Date }).ToList();
itemShowDataGridView.DataSource = item;
}
private InventoryStockReport ReaderToReadAllStock(IDataReader aReader)
{
InventoryStockReport aStockReport = new InventoryStockReport();
try
{
aStockReport.CategoryId = Convert.ToInt32(aReader["category_id"]);
}
catch
{
}
try
{
aStockReport.CategoryName = (aReader["category_name"]).ToString();
}
catch
{
}
try
{
aStockReport.ItemId = Convert.ToInt32(aReader["item_id"]);
}
catch
{
}
try
{
aStockReport.ItemName = (aReader["item_name"]).ToString();
}
catch
{
}
try
{
aStockReport.BalanceQty = Convert.ToDouble(aReader["balance"]);
}
catch
{
}
try
{
aStockReport.SendQty = Convert.ToDouble(aReader["send"]);
}
catch
{
}
try
{
aStockReport.ReceivedQty = Convert.ToDouble(aReader["received"]);
}
catch
{
}
try
{
aStockReport.DamageQty = Convert.ToDouble(aReader["damage"]);
}
catch
{
}
try
{
aStockReport.Date = Convert.ToDateTime(aReader["date"]);
}
catch
{
}
return(aStockReport);
}
