public static int GetNumberOfDrinksByType(int type) { using (var db = new DrinkDataBaseDataContext()) { return db.DRINKs.Where(c => c.FK_TYPE== type).Count(); } }
public static List<Dto.Type> SelectAllTypes() { using (var db = new DrinkDataBaseDataContext()) { return db.TYPEs.Select(c => new Dto.Type { NAME = c.NAME, PK_TYPE = c.PK_TYPE }).ToList(); } }
public static Dto.Type GetTypeName(int Id) { using (var db = new DrinkDataBaseDataContext()) { return db.TYPEs.Where(c => c.PK_TYPE == Id).Select(c=>new Dto.Type { PK_TYPE = c.PK_TYPE, NAME = c.NAME }).FirstOrDefault(); } }
public static List<Dto.Size> SelectAllSizes() { using (var db = new DrinkDataBaseDataContext()) { return db.SIZEs.Select(c => new Dto.Size { SIZETYPE = c.SIZETYPE, PK_SIZE = c.PK_SIZE }).ToList(); } }
public static Dto.Size GetSizeName(int Id) { using (var db = new DrinkDataBaseDataContext()) { return db.SIZEs.Where(c => c.PK_SIZE == Id).Select(c => new Dto.Size { PK_SIZE = c.PK_SIZE, SIZETYPE = c.SIZETYPE }).FirstOrDefault(); } }
public static List<Dto.Drink> SelectAllDrinks() { using (var db = new DrinkDataBaseDataContext()) { return db.DRINKs.Select(c => new Dto.Drink { FK_SIZE = c.FK_SIZE, NAME = c.NAME, FK_TYPE = c.FK_TYPE, PHOTO = c.PHOTO.ToArray(), PRICE = c.PRICE, PK_DRINK = c.PK_DRINK }).ToList(); } }
public static void CreateNewDrink(Dto.Drink drink) { using (var db = new DrinkDataBaseDataContext()) { var dbDrink = new Data.DRINK() { FK_SIZE = drink.FK_SIZE, NAME = drink.NAME, FK_TYPE = drink.FK_TYPE, PHOTO = drink.PHOTO, PRICE = drink.PRICE }; db.DRINKs.InsertOnSubmit(dbDrink); db.SubmitChanges(); } }