public HttpResponseMessage UpdateGrocery(Grocery grocery)
{
using (Models.MyHealthBuddyEntities dbContext = new Models.MyHealthBuddyEntities())
{
Models.Grocery newGrocery = dbContext.Groceries.SingleOrDefault(item => item.GroceryID == grocery.GroceryID);
if (newGrocery != null)
{
newGrocery.GroceryName = grocery.GroceryName;
newGrocery.ExpiryDate = grocery.ExpiryDate;
newGrocery.Calories = grocery.Calories;
newGrocery.Quantity = grocery.Quantity;
newGrocery.UserID = grocery.UserID;
newGrocery.GroceryMasterID = grocery.GroceryMasterID;
dbContext.Entry(newGrocery).State = System.Data.Entity.EntityState.Modified;
try
{
dbContext.SaveChanges();
return(Request.CreateResponse <string>(HttpStatusCode.OK, "Update Success!"));
}
catch (Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.PreconditionFailed, e));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.PreconditionFailed, "Record mismatch while trying to update!"));
}
}
}
public HttpResponseMessage DeleteGrocery(int groceryID)
{
using (Models.MyHealthBuddyEntities dbContext = new Models.MyHealthBuddyEntities())
{
Models.Grocery groceryToDelete = dbContext.Groceries.SingleOrDefault(item => item.GroceryID == groceryID);
if (groceryToDelete != null)
{
dbContext.Groceries.Remove(groceryToDelete);
dbContext.SaveChanges();
return(Request.CreateResponse <string>(HttpStatusCode.OK, "Delete Success!"));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.PreconditionFailed, "Record not found while trying to delete!"));
}
}
}
public int AddGrocery(Grocery grocery)
{
Models.Grocery newGrocery = new Models.Grocery()
{
GroceryName = grocery.GroceryName,
ExpiryDate = grocery.ExpiryDate,
Calories = grocery.Calories,
Quantity = grocery.Quantity,
UserID = grocery.UserID,
GroceryMasterID = grocery.GroceryMasterID
};
using (Models.MyHealthBuddyEntities dbContext = new Models.MyHealthBuddyEntities())
{
dbContext.Groceries.Add(newGrocery);
dbContext.SaveChanges();
return(newGrocery.GroceryID);
}
}
public List <GroceryMaster> Get(string groceryKeyword)
{
List <GroceryMaster> groceries = null;
if (!String.IsNullOrWhiteSpace(groceryKeyword))
{
using (Models.MyHealthBuddyEntities dbContext = new Models.MyHealthBuddyEntities())
{
groceries = dbContext.GroceryMasters.Where(x => x.GroceryName.StartsWith(groceryKeyword)).Select(groceryMaster => new GroceryMaster()
{
BarcodeId = groceryMaster.BarcodeID, GroceryName = groceryMaster.GroceryName
}).ToList();
if (groceries == null || groceries.Count <= 0)
{
groceries = dbContext.GroceryMasters.Where(x => x.GroceryName.Contains(groceryKeyword)).Select(groceryMaster => new GroceryMaster()
{
BarcodeId = groceryMaster.BarcodeID, GroceryName = groceryMaster.GroceryName
}).ToList();
}
}
}
return(groceries);
}
