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