public override ListModel partialUpdate(int foodId, ListModel data)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
UserShoppingList list = entities.UserShoppingLists.FirstOrDefault(item => item.USER_ID == Globals.UserId.Value && item.FOOD_ID == foodId);
List <PropertyInfo> listProperties = list.GetType().GetProperties().ToList();
foreach (var dataProp in data.GetType().GetProperties())
{
var dataPropValue = dataProp.GetValue(data);
if (dataPropValue != null && dataProp.Name != "version")
{
var listProp = listProperties.Find(item => item.Name == ListMapping[dataProp.Name]);
if (listProp != null)
{
listProp.SetValue(list, dataPropValue);
}
}
}
entities.SaveChanges();
return(new ListModel
{
ownerId = Globals.UserId.Value,
itemId = list.FOOD_ID,
itemName = list.FOOD_NAME,
itemUnit = list.MEASUREMENT_NAME,
value = list.QUANTITY.Value
});
}
}
public IEnumerable <RecipeModel> List()
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return(entities.Recipes.Select(r => new RecipeModel
{
RecipeId = r.RecipeId,
RecipeName = r.RecipeName
}).ToList());
}
}
public IEnumerable <FoodModel> Ingrediants()
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return(entities.Foods.Select(r => new FoodModel
{
FoodId = r.FoodId,
FoodName = r.FoodName
}).ToList());
}
}
public IEnumerable <FoodModel> List()
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return(entities.Foods.Select(item => new FoodModel
{
FoodId = item.FoodId,
FoodName = item.FoodName
}).ToList());
}
}
void getUser(string token)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
User user = entities.Users.SingleOrDefault(p => p.Token == token);
if (user != null)
{
Globals.UserId = user.UserId;
}
}
}
public IEnumerable <UserModel> List()
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return(entities.Users.Select(item => new UserModel
{
Name = item.DisplayName,
Email = item.Email,
Password = item.Password
}).ToList());
}
}
public FoodModel Single(int id)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
Food food = entities.Foods.FirstOrDefault(item => item.FoodId == id);
return(new FoodModel
{
FoodId = food.FoodId,
FoodName = food.FoodName
});
}
}
public IEnumerable <FoodModel> Partial(string pre)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return(entities.Foods
//.TakeWhile(item => item.FoodName.IndexOf(prefix) != -1)
.Select(item => new FoodModel
{
FoodId = item.FoodId,
FoodName = item.FoodName
}).ToList());
}
}
public override bool Delete(int foodId)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
UserShoppingList list = entities.UserShoppingLists.SingleOrDefault(item => item.USER_ID == Globals.UserId && item.FOOD_ID == foodId);
if (list != null)
{
entities.UserShoppingLists.Remove(list);
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
};
}
public override ListModel[] GetAll()
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return((from a in entities.UserShoppingLists
where a.USER_ID == Globals.UserId
select new ListModel
{
ownerId = a.USER_ID,
itemId = a.FOOD_ID,
itemName = a.FOOD_NAME,
itemUnit = a.MEASUREMENT_NAME,
itemUnitId = a.MEASURMENT_ID.Value,
value = a.QUANTITY.Value
}).ToArray());
}
}
public override ListModel[] GetAll()
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
var result = (from a in entities.MissingLists
join b in entities.MissingListDetails on a.ID equals b.LIST_ID
where a.CREATED_BY == Globals.UserId.Value
select new ListModel
{
ownerId = a.CREATED_BY,
itemId = b.Food.FoodId,
itemName = b.Food.FoodName,
itemUnit = b.MeasurementUnit.UnitName,
value = b.QUANTITY
}).ToArray();
return(result);
};
}
public RecipeModel ById(int id)
{
try
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
IQueryable <Ingredient> ingredient = entities.Ingredients.Where(p => p.RecipeId == id);
List <IngrediantModel> ingModelList = new List <IngrediantModel>();
ingredient.ToList().ForEach(p =>
{
ingModelList.Add(new IngrediantModel
{
Name = p.Food.FoodName,
Measure = p.MeasurementUnit.UnitName,
Quantity = p.Quantity
});
});
Recipe recipe = entities.Recipes.FirstOrDefault(r => r.RecipeId == id);
if (recipe != null)
{
return(new RecipeModel
{
RecipeId = recipe.RecipeId,
RecipeName = recipe.RecipeName,
Ingrediants = ingModelList,
PreparationMethod = recipe.PreparationMethod
});
}
else
{
return(null);
}
}
}
catch
{
return(null);
}
}
public string Login([FromBody] LoginInfo login)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
User user = entities.Users.FirstOrDefault(p => p.Name == login.userName && p.Password == login.password);
if (user != null)
{
Globals.UserId = user.UserId;
string token = Convert.ToBase64String(Encoding.ASCII.GetBytes(string.Format("{0}:{1}", login.userName, login.password)));
user.Token = token;
entities.SaveChanges();
return(token);
}
else
{
return(null);
}
}
}
public Response GetUnits()
{
try
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return(new SuccessResponse <UnitModel[]>
{
results = entities.MeasurementUnits.Select(item => new UnitModel
{
unitId = item.UnitId,
unitName = item.UnitName
}).ToArray()
});
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public override ListModel GetSingle(int foodId)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
UserShoppingList list = entities.UserShoppingLists.SingleOrDefault(item => item.USER_ID == Globals.UserId.Value && item.FOOD_ID == foodId);
if (list != null)
{
return(new ListModel
{
ownerId = Globals.UserId.Value,
itemId = list.FOOD_ID,
itemName = list.FOOD_NAME,
itemUnit = list.MEASUREMENT_NAME,
value = list.QUANTITY.Value
});
}
else
{
return(new ListModel());
}
}
}
public Response Search(string searchValue)
{
try
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
return(new SuccessResponse <FoodModel[]>
{
results = (from a in entities.Foods
where a.FoodName.Contains(searchValue)
select new FoodModel
{
FoodId = a.FoodId,
FoodName = a.FoodName
}).ToArray()
});
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public override void Add(ListModel data)
{
using (MyBuyListEntities entities = new MyBuyListEntities())
{
Food food = entities.Foods.Where(item => item.FoodId == data.itemId).SingleOrDefault();
if (food != null)
{
UserShoppingList _new = new UserShoppingList
{
FOOD_ID = food.FoodId,
FOOD_NAME = food.FoodName,
CATEGORY_ID = food.FoodCategoryId,
CATEGORY_NAME = food.FoodCategory.FoodCategoryName,
QUANTITY = 0,
USER_ID = Globals.UserId.Value,
ACTIVE = true,
CAN_DELETE = true
};
entities.UserShoppingLists.Add(_new);
entities.SaveChanges();
}
}
}
