List<UserModel> getUsersByCategoryFromDatabase()
{
List<UserModel> list_user=new List<UserModel>();
for (int i = 0; i < categoryCount; i++)
{
if (category[i])
{
List<ItemTable> list = db.Items.Where(c => c.CategoryId == i + 1).ToList<ItemTable>();
foreach (ItemTable item in list)
{
UserTable user = db.Users.First(c => c.Id == item.UserId);
UserModel userModel = new UserModel()
{
AvatarUri = user.AvatarUri,
UserName = user.UserName,
Latitude=(double)user.Latitude,
Longitude = (double)user.Longitude,
Category = i,
Id=user.Id,
Address=user.Address
};
// Geocode(userModel.Address,user.Id);
if (!list_user.Any(c => c.Id == user.Id))
list_user.Add(userModel);
}
}
}
return list_user;
}
public List<UserModel> getChooseUser(ObservableCollection<RecyclePlanModel> listPlanModel)
{
List<UserModel> list = new List<UserModel>(); ;
foreach(RecyclePlanModel moel in listPlanModel)
{
UserTable user = db.Users.First(c => c.Id == moel.UserId);
UserModel userModel = new UserModel()
{
AvatarUri = user.AvatarUri,
UserName = user.UserName,
Latitude=(double)user.Latitude,
Longitude = (double)user.Longitude,
//Category = i,
Id=user.Id,
Address=user.Address
};
list.Add(userModel);
}
return list;
}