public List <Models.Profile> ListAll()
{
using (var db = new hotdogEntities()){
var viewProfiles = (
from profiles in db.Profiles
select new Models.Profile()
{
ProfileID = (int)profiles.ProfileID,
Name = profiles.Name,
Bio = profiles.Bio,
Picture = profiles.Picture
}
);
return(viewProfiles.ToList());
}
/*
* List<Models.Profile> viewProfiles = new List<Models.Profile>();
* Models.HotDog viewHotDog = new Models.HotDog();
* List<DAL.Profile> modelProfiles = db.Profiles.ToList();
*
* foreach (DAL.Profile modelProfile in modelProfiles) {
* Models.Profile viewProfile = new Models.Profile()
* {
* Bio=modelProfile.Bio,
* Name=modelProfile.Name,
* Picture=modelProfile.Picture,
* ProfileID = Convert.ToInt32(modelProfile.ProfileID)
* };
*
* viewProfiles.Add(viewProfile);
* }
* return viewProfiles;
*/
}
public Models.Profile Get(int id)
{
using (var db = new hotdogEntities()){
var profile = (
from profiles in db.Profiles
from hotdogs in profiles.HotDogs
where profiles.ProfileID == id
select new Models.Profile()
{
ProfileID = (int)profiles.ProfileID,
Name = profiles.Name,
Bio = profiles.Bio,
Picture = profiles.Picture,
HotDogListTmp = (
from p in db.Profiles
from hd in p.HotDogs
select new Models.HotDog()
{
HotDogID = (int)hd.HotDogID,
HotDogName = hd.Name,
LastTimeAte = hd.LastAte,
LastPlaceAte = hd.LastPlaceAte
}
),
FavoriteHotDog = db.HotDogs
.Where(x => x.HotDogID == profiles.HotDogID)
.Select(h => new Models.HotDog()
{
HotDogID = (int)h.HotDogID,
HotDogName = h.Name,
LastTimeAte = h.LastAte,
LastPlaceAte = h.LastPlaceAte
}).FirstOrDefault()
}).FirstOrDefault();
//hack to convert IEnumerable to a list
profile.HotDogList = profile.HotDogListTmp.ToList();
return(profile);
}
/*
* DAL.Profile modelProfile = db.Profiles.Find(id);
* DAL.HotDog modelHotdog = db.HotDogs.Find(modelProfile.HotDogID);
*
* ICollection<DAL.HotDog> modelFavoriteHotDogList = modelProfile.HotDogs;
* List<Models.HotDog> viewFavoritHotDogList = new List<Models.HotDog>();
* foreach (DAL.HotDog favoriteHotDog in modelFavoriteHotDogList) {
* Models.HotDog modelFavoriteHotDog = new Models.HotDog() {
* HotDogID = Convert.ToInt32(favoriteHotDog.HotDogID),
* HotDogName = favoriteHotDog.Name,
* LastPlaceAte = favoriteHotDog.LastPlaceAte,
* LastTimeAte = favoriteHotDog.LastAte,
* Rating = 5
* };
* viewFavoritHotDogList.Add(modelFavoriteHotDog);
* }
*
* Models.HotDog viewHotdog = new Models.HotDog(){
* HotDogID= Convert.ToInt32(modelHotdog.HotDogID),
* HotDogName=modelHotdog.Name,
* LastPlaceAte=modelHotdog.LastPlaceAte,
* LastTimeAte=modelHotdog.LastAte,
* Rating=5
* };
* Models.Profile viewProfile = new Models.Profile() {
* Bio = modelProfile.Bio,
* ProfileID = Convert.ToInt32(modelProfile.ProfileID),
* Name = modelProfile.Name,
* Picture = modelProfile.Picture,
* FavoriteHotDog = viewHotdog,
* HotDogList = viewFavoritHotDogList
* };
*
* return viewProfile;
*/
}
