//date_str format ddmmyyyy public async Task <List <FoodMini> > GetAllSumFoodByNotStatusStr(string date_str, string status1, string status2) { List <FoodMini> list2 = new List <FoodMini>(); ProductFirebaseHelper productFirebaseHelper = new ProductFirebaseHelper(); List <Product> listProduct = await productFirebaseHelper.GetAllProduct(); var allFoods = await GetAllFood(date_str); if (allFoods != null && listProduct != null) { int totalQ = 0; for (int k = 0; k < listProduct.Count; k++) { totalQ = 0; Models.Product pro = listProduct[k]; for (int i = 0; i < allFoods.Count; i++) { FoodMini fMini = allFoods[i]; if (fMini.NameEn != null && fMini.NameEn.Equals(pro.NameEn)) { totalQ = totalQ + fMini.Quantity; } } FoodMini resultFMini = new FoodMini(); resultFMini.Name = pro.Name; resultFMini.NameEn = pro.NameEn; resultFMini.Quantity = totalQ; resultFMini.QuantityStr = "จำนวนทั้งหมด " + totalQ; list2.Add(resultFMini); } } return(list2); }
public async System.Threading.Tasks.Task <string> adjustRemainStockAsync(string foodName) { string alertMessage = ""; ProductFirebaseHelper productFirebase = new ProductFirebaseHelper(); MaterialFirebaseHelper materialFirebaseHelper = new MaterialFirebaseHelper(); MaterialDetailFirebaseHelper detailFirebaseHelper = new MaterialDetailFirebaseHelper(); MaterialSourceFirebaseHelper sourceFirebaseHelper = new MaterialSourceFirebaseHelper(); Models.Product pro = await productFirebase.GetProductByNameEn(foodName); if (pro != null) { Models.MaterialHeader header = await materialFirebaseHelper.GetMaterialByProductId(pro.ID.ToString()); List <Models.MaterialDetail> listDetail = await detailFirebaseHelper.GetAllMaterialByHeader(convertObject(header.ID)); for (int i = 0; i < listDetail.Count; i++) { Models.MaterialDetail detail = listDetail[i]; Models.MaterialSource source = await sourceFirebaseHelper.GetMaterialSourceByID(convertObject(detail.MaterialID)); source.Quantity = source.Quantity - detail.Quantity; if (source.Quantity < 0) { if (alertMessage.Trim().Length == 0) { alertMessage = "สินค่า " + foodName + " วัตุดิบ " + source.NameEn + " หมด"; } else { alertMessage = alertMessage + " วัตุดิบ " + source.NameEn + " หมด"; } } else if (source.Quantity <= source.QuantityAlert) { if (alertMessage.Trim().Length == 0) { alertMessage = "สินค่า " + foodName + " วัตุดิบ " + source.NameEn + " เหลือน้อยกว่าที่กำหนดไว้" + source.QuantityAlert; } else { alertMessage = alertMessage + " วัตุดิบ " + source.NameEn + " เหลือน้อยกว่าที่กำหนดไว้ " + source.QuantityAlert; } } } } return(alertMessage); }