//removes the food item identifed by bfid public void removeFoodItem(long bfid) { FoodItemAccess fia = new FoodItemAccess(); if (fia.findId(bfid) != 0) { fia.removeFoodItem(bfid); } }
//returns the food items for the user identified by uid, that will expire between leftTime and rightTime public List <BFoodItem> getFoodListExp(long uid, DateTime leftTime, DateTime rightTime) { FoodItemAccess fia = new FoodItemAccess(); List <FoodItem> food_list = fia.getFoodListExp(uid, leftTime, rightTime); List <BFoodItem> bfood_list = new List <BFoodItem>(); foreach (FoodItem fi in food_list) { bfood_list.Add(convert_to_bfi(fi)); } return(bfood_list); }
//returns the food items for the user identified by uid public List <BFoodItem> getFoodList(long uid) { FoodItemAccess fia = new FoodItemAccess(); List <FoodItem> food_list = fia.get_food_list(uid); List <BFoodItem> bfood_list = new List <BFoodItem>(); foreach (FoodItem fi in food_list) { bfood_list.Add(convert_to_bfi(fi)); } return(bfood_list); }
public void Update(string umail) { FoodItemAccess fia = new FoodItemAccess(); List <FoodItem> foodList = fia.GetUnmarkedFoodItems(); if (foodList.Count > 0) { NotificationManager nm = new NotificationManager(); string message = nm.ComposeDueNotificationMessage(foodList); MailManager mailManager = new MailManager(); BMailBot bMailBot = mailManager.getBMailBot(); mailManager.sendMail(bMailBot.Username, bMailBot.Password, umail, "New Items Expired", message); fia.UpdateMarked(foodList); } }
//allows the user to set and update the consumption date. First checks if the date is valod //and if the item exists public int editConsDate(long bfid, DateTime?consDate) { FoodItemAccess fia = new FoodItemAccess(); if (fia.findId(bfid) != 0) { if (consDate == null) { fia.editConsDate(bfid, consDate); return(0); } BFoodItem bFoodItem = getBFoodItem(bfid); if (bFoodItem.PurchaseDate > consDate) { return(1); } fia.editConsDate(bfid, consDate); return(0); } return(2); }
//adds a food item in the database, respecting the validation rules public int addFoodItem(BFoodItem bFoodItem) { FoodItemAccess fia = new FoodItemAccess(); FoodItem latestFood = fia.findLatestFood(); //prevents from inserting duplicate elements on refresh if (!(latestFood.Name.Equals(bFoodItem.Name) && latestFood.PurchaseDate.Equals(bFoodItem.PurchaseDate) && latestFood.ExpDate.Equals(bFoodItem.ExpDate) && latestFood.Quantity.Equals(bFoodItem.Quantity))) { //Invalid Purchase date if (bFoodItem.PurchaseDate.Equals(DateTime.MinValue)) { return(1); } //Invalid Expiration date if (bFoodItem.ExpDate.Equals(DateTime.MinValue)) { return(2); } //Invalid Consumption date if (bFoodItem.ConsDate.Equals(DateTime.MinValue)) { return(3); } //Name can contain only english letters if (!Regex.IsMatch(bFoodItem.Name, @"^[a-zA-z]+$")) { return(4); } //Qunatity limits if (bFoodItem.Quantity < 0) { return(5); } if (bFoodItem.Quantity > 1000) { return(6); } //Calories limits if (bFoodItem.Calories < 0) { return(7); } if (bFoodItem.Calories > 1000000) { return(8); } if (bFoodItem.ConsDate > DateTime.Now) { return(9); } if (bFoodItem.PurchaseDate > DateTime.Now) { return(10); } //Successfully inserted fia.addFoodItem(convert_to_fi(bFoodItem)); return(0); } return(11); }
//returns the food item identifed by bfid public BFoodItem getBFoodItem(long bfid) { FoodItemAccess fia = new FoodItemAccess(); return(convert_to_bfi(fia.getFoodItem(bfid))); }