public static Dto.Drink GetDrinkById(int id) { using (var db = new DrinkzAppBDDataContext()) { return db.Drinks.Where(c => c.PK_DRINK == id).Select(c => new Dto.Drink { CREATION_DATE = c.CREATION_DATE, FK_CATEGORY = c.FK_CATEGORY, NAME = c.NAME, DESCRIPTION = c.DESCRIPTION, FK_PROFILE = c.PK_PROFILE, HOWTO = c.HOWTO, LIKES = c.LIKES, PK_DRINK = c.PK_DRINK, VIEWS = c.VIEWS, YOUTUBE_URL = c.YOUTUBE_URL }).FirstOrDefault(); } }
public static List<Dto.Drink> GetAllDrinks() { using (var db = new DrinkzAppBDDataContext()) { return db.Drinks.Select(c=> new Dto.Drink { CREATION_DATE = c.CREATION_DATE, DESCRIPTION = c.DESCRIPTION, FK_CATEGORY = c.FK_CATEGORY, NAME = c.NAME, FK_PROFILE = c.PK_PROFILE, HOWTO = c.HOWTO, LIKES = c.LIKES, PK_DRINK = c.PK_DRINK, VIEWS = c.VIEWS, YOUTUBE_URL = c.YOUTUBE_URL }).ToList(); } }
public static int CreateNewProfile(Dto.Profile profile) { using (var db = new DrinkzAppBDDataContext()) { var dbProfile = new Data.Profile() { DEVICE_ID = profile.DEVICE_ID, FACEBOOK_ID = profile.FACEBOOK_ID, NAME = profile.NAME, URL_IMAGE = profile.URL_IMAGE, OS_ID = profile.OS_ID }; db.Profiles.InsertOnSubmit(dbProfile); db.SubmitChanges(); return dbProfile.PK_PROFILE; } }
public static void CreateNewDrink(Dto.Drink drink) { using (var db = new DrinkzAppBDDataContext()) { var dbDrink = new Data.Drink() { CREATION_DATE = drink.CREATION_DATE, FK_CATEGORY = drink.FK_CATEGORY, NAME = drink.NAME, DESCRIPTION = drink.DESCRIPTION, HOWTO = drink.HOWTO, LIKES = drink.LIKES, PK_PROFILE = drink.FK_PROFILE, VIEWS = drink.VIEWS, YOUTUBE_URL = drink.YOUTUBE_URL, }; db.Drinks.InsertOnSubmit(dbDrink); db.SubmitChanges(); } }