public ProductRepository(CaloriesContext context) : base(context) { }
public InterpretationRepository(CaloriesContext context) { db = context; }
public EfRepository(CaloriesContext context) { db = context; }
public static void Initialize(CaloriesContext context) { context.Database.EnsureCreated(); if (context.Products.Any()) { return; } var genderInterpretations = new[] { new GenderInterpretation { Name = "Мужской", Type = 1 }, new GenderInterpretation { Name = "Женский", Type = 2 } }; foreach (var genderInterpretation in genderInterpretations) { context.GenderInterpretations.Add(genderInterpretation); } var unitOfMeasureInterpretations = new[] { new UnitOfMeasureInterpretation { Name = "гр", Type = 1 }, new UnitOfMeasureInterpretation { Name = "шт", Type = 2 } }; foreach (var unitOfMeasureInterpretation in unitOfMeasureInterpretations) { context.UnitOfMeasureInterpretations.Add(unitOfMeasureInterpretation); } var purposeInterpretations = new[] { new PurposeInterpretation { Name = "Сохранить вес", Type = 1 }, new PurposeInterpretation { Name = "Сбросить вес", Type = 2 }, new PurposeInterpretation { Name = "Набрать вес", Type = 3 } }; foreach (var purposeInterpretation in purposeInterpretations) { context.PurposeInterpretations.Add(purposeInterpretation); } var physicalActivityInterpretations = new[] { new PhysicalActivityInterpretation { Name = "Сидячий образ жизни", Type = 1 }, new PhysicalActivityInterpretation { Name = "Умеренная активность", Type = 2 }, new PhysicalActivityInterpretation { Name = "Средняя (занятия 3-5 раз в неделю)", Type = 3 }, new PhysicalActivityInterpretation { Name = "Активные люди (интенсивные нагрузки)", Type = 4 }, new PhysicalActivityInterpretation { Name = "Спортсмены (6-7 раз в неделю)", Type = 5 } }; foreach (var physicalActivityInterpretation in physicalActivityInterpretations) { context.PhysicalActivityInterpretations.Add(physicalActivityInterpretation); } var products = new[] { new Product { Name = "Творог", UnitOfMeasure = 2, Calorie = 200, Protein = 22, Fat = 1, Carbohydrate = 3, GlycemicIndex = 1, Weight = 100 }, new Product { Name = "Хлеб из цельной пшеницы ", UnitOfMeasure = 1, Calorie = 247, Protein = 13, Fat = 3, Carbohydrate = 35, GlycemicIndex = 14, Weight = 100 }, new Product { Name = "Баранки сдобные", UnitOfMeasure = 2, Calorie = 348, Protein = 8, Fat = 8, Carbohydrate = 60, GlycemicIndex = 42, Weight = 100 }, new Product { Name = "Котлеты рубленые, баранина", UnitOfMeasure = 1, Calorie = 240, Protein = 14, Fat = 15, Carbohydrate = 13, GlycemicIndex = 6, Weight = 100 }, new Product { Name = "Макароны из муки 1 сорта", UnitOfMeasure = 2, Calorie = 333, Protein = 1, Fat = 2, Carbohydrate = 68, GlycemicIndex = 34, Weight = 100 }, new Product { Name = "Гречка", UnitOfMeasure = 2, Calorie = 200, Protein = 22, Fat = 1, Carbohydrate = 3, GlycemicIndex = 1, Weight = 100 }, new Product { Name = "Банан", UnitOfMeasure = 1, Calorie = 340, Protein = 50, Fat = 3, Carbohydrate = 35, GlycemicIndex = 14, Weight = 150 }, new Product { Name = "Плов", UnitOfMeasure = 2, Calorie = 348, Protein = 8, Fat = 8, Carbohydrate = 60, GlycemicIndex = 42, Weight = 100 }, new Product { Name = "Картофель", UnitOfMeasure = 2, Calorie = 333, Protein = 1, Fat = 2, Carbohydrate = 68, GlycemicIndex = 34, Weight = 100 } }; foreach (var product in products) { context.Products.Add(product); } context.SaveChanges(); }