public static void EnsurePopulated(IApplicationBuilder app) { TechnoStoreDbContext context = app.ApplicationServices.CreateScope().ServiceProvider .GetRequiredService <TechnoStoreDbContext>(); if (context.Database.GetPendingMigrations().Any()) { context.Database.Migrate(); } if (!context.OrderDetails.Any()) { context.OrderDetails.AddRange( new OrderDetail() { OrderId = 1, ProductId = 1, Price = 1, Quantity = 1 } ); context.SaveChanges(); } }
public static void EnsurePopulated(IApplicationBuilder app) { TechnoStoreDbContext context = app.ApplicationServices.CreateScope().ServiceProvider .GetRequiredService <TechnoStoreDbContext>(); if (context.Database.GetPendingMigrations().Any()) { context.Database.Migrate(); } if (!context.Payments.Any()) { context.Payments.AddRange( new Payment() { PaymentType = "Kredi / Banka Kartı" }, new Payment() { PaymentType = "Kapıda Ödeme" }, new Payment() { PaymentType = "Havale" } ); context.SaveChanges(); } }
public static void EnsurePopulated(IApplicationBuilder app) { TechnoStoreDbContext context = app.ApplicationServices.CreateScope().ServiceProvider .GetRequiredService <TechnoStoreDbContext>(); if (context.Database.GetPendingMigrations().Any()) { context.Database.Migrate(); } if (!context.Coupons.Any()) { context.Coupons.AddRange( new Coupon() { Code = "COUPONFIRST", EndDate = DateTime.Now, DiscountPercentage = 30, IsActive = true }, new Coupon() { Code = "COUPONSECOND", EndDate = new DateTime(2020, 12, 25), DiscountPercentage = 30, IsActive = true } ); context.SaveChanges(); } }
public static void EnsurePopulated(IApplicationBuilder app) { TechnoStoreDbContext context = app.ApplicationServices.CreateScope().ServiceProvider .GetRequiredService <TechnoStoreDbContext>(); if (context.Database.GetPendingMigrations().Any()) { context.Database.Migrate(); } if (!context.Shippers.Any()) { context.Shippers.AddRange( new Shipper() { CompanyName = "Yurtiçi Kargo", Phone = "444 99 99" }, new Shipper() { CompanyName = "Aras Kargo", Phone = "444 25 52" }, new Shipper() { CompanyName = "MNG Kargo", Phone = "444 06 06" }, new Shipper() { CompanyName = "Sürat Kargo", Phone = "0850 202 0 202" }, new Shipper() { CompanyName = "PTT Kargo", Phone = "444 17 88" }, new Shipper() { CompanyName = "UPS", Phone = "444 00 33" } ); context.SaveChanges(); } }
public static void EnsurePopulated(IApplicationBuilder app) { TechnoStoreDbContext context = app.ApplicationServices.CreateScope().ServiceProvider .GetRequiredService <TechnoStoreDbContext>(); if (context.Database.GetPendingMigrations().Any()) { context.Database.Migrate(); } if (!context.Categories.Any()) { context.Categories.AddRange( new Category() { Name = "Gaming Laptop", Description = "Yüksek miktarda işlem gücü gerektiren video oyunlarını oynamak için tasarlanmış kişisel bilgisayarlar.", }, new Category() { Name = "Ev - Ofis Laptop'ları", Description = "Günlük temel düzeyde kullanımı temel alan ev - ofis bilgisayarları.", }, new Category() { Name = "İkisi Bir Arada", Description = "Hem normal hem de dokunmatik işleve sahip bilgisayarlar" } ); context.SaveChanges(); } }
public static void EnsurePopulated(IApplicationBuilder app) { TechnoStoreDbContext context = app.ApplicationServices.CreateScope().ServiceProvider .GetRequiredService <TechnoStoreDbContext>(); if (EnumerableExtensions.Any(context.Database.GetPendingMigrations())) { context.Database.Migrate(); } if (!EnumerableExtensions.Any(context.Products)) { context.Products.AddRange( new Product() { Name = "Asus X515JF-BR070T", Vendor = "Asus", RealPrice = 12200, UnitPrice = 4898, UnitInStock = 10, CategoryId = 2, SKU = "TSV00000X5TSR", ProcessorVendor = "Intel", ProcessorType = "Intel Core i3 1005G1", GraphicsCard = "Intel UHD Graphics", DiscCapacity = "256 GB", MemoryCapacity = "4 GB", Description = "Asus X515JF-BR070T Intel Core i3 1005G1 4GB 256GB SSD Windows 10 Home 15.6 Taşınabilir Bilgisayar", Image1 = "format_webp (1).jpg", Image2 = "format_webp (3).jpg", Image3 = "format_webp (4).jpg" }, new Product() { Name = "MSI GF63 Thin 9SCSR-1053XTR", Vendor = "MSI", RealPrice = 14751, UnitPrice = 7776, UnitInStock = 25, CategoryId = 1, SKU = "TSV00000X9GRY", ProcessorVendor = "Intel", ProcessorType = "Intel Core i5 9300H", GraphicsCard = "NVIDIA GTX 1650Ti", DiscCapacity = "256 GB", MemoryCapacity = "8 GB", Description = "MSI GF63 Thin 9SCSR-1053XTR Intel Core i5 9300H 8GB 256GB SSD GTX 1650Ti Freedos 15.6\" FHD Taşınabilir Bilgisayar", Image1 = "msigf63_1.jpg", Image2 = "msigf63_2.jpg", Image3 = "msigf63_3.jpg" }, new Product() { Name = "Dell Vostro 3501", Vendor = "Dell", RealPrice = 6250, UnitPrice = (decimal)(5999.4), UnitInStock = 100, CategoryId = 2, SKU = "TSV00000X9GRQ", ProcessorVendor = "Intel", ProcessorType = "Intel Core i3 1005G1", GraphicsCard = "Intel UHD Graphics", DiscCapacity = "1 TB", MemoryCapacity = "8 GB", Description = "Dell Vostro 3501 Intel Core i3 1005G1 8GB 256GB SSD Windows 10 Home 15.6\" FHD Taşınabilir Bilgisayar FB05W82N", Image1 = "Dell Vostro 3501_1.jpg", Image2 = "Dell Vostro 3501_2.jpg", Image3 = "Dell Vostro 3501_3.jpg" }, new Product() { Name = "Apple Macbook Pro M1", Vendor = "Apple", RealPrice = 20100, UnitPrice = (decimal)(14298.99), UnitInStock = 3, CategoryId = 2, SKU = "TSV00000OSBNX", ProcessorVendor = "Apple", ProcessorType = "M1", GraphicsCard = "AMD Radeon Pro 5600M", DiscCapacity = "256 GB", MemoryCapacity = "8 GB", Description = "Apple Macbook Pro M1 Çip 8GB 256GB macOS 13\" QHD Taşınabilir Bilgisayar Uzay Grisi MYD82TU/A", Image1 = "Apple Macbook Pro M1_1.jpg", Image2 = "Apple Macbook Pro M1_2.jpg", Image3 = "Apple Macbook Pro M1_3.jpg" }, new Product() { Name = "Lenovo IdeaPad Creator 5", Vendor = "Lenovo", RealPrice = 10000, UnitPrice = 9699, UnitInStock = 30, CategoryId = 1, SKU = "TSV00000LK9W1", ProcessorVendor = "Intel", ProcessorType = "Intel Core i5 10300H", GraphicsCard = "NVIDIA GTX 1650Ti", DiscCapacity = "512 GB", MemoryCapacity = "16 GB", Description = "Lenovo IdeaPad Creator 5 Intel Core i5 10300H 16GB 512GB SSD GTX 1650Ti Freedos 15.6'\' FHD Taşınabilir Bilgisayar 82D4002KTX", Image1 = "Lenovo IdeaPad Creator 5_1.jpg", Image2 = "Lenovo IdeaPad Creator 5_2.jpg", Image3 = "Lenovo IdeaPad Creator 5_3.jpg" }, new Product() { Name = "Asus TUF Gaming A15 FA506II-BQ200", Vendor = "Asus", RealPrice = 12200, UnitPrice = 10114, UnitInStock = 60, CategoryId = 1, SKU = "TSV00000UMKL4", ProcessorVendor = "AMD", ProcessorType = "AMD Ryzen 7 4800H", GraphicsCard = "NVIDIA GTX1650Ti", DiscCapacity = "1 TB", MemoryCapacity = "8 GB", Description = "Asus TUF Gaming A15 FA506II-BQ200 AMD Ryzen 7 4800H 8GB 1TB + 256GB SSD GTX1650Ti FreeDos 15.6\" FHD Taşınabilir Bilgisayar", Image1 = "Asus TUF Gaming A15 FA506II-BQ200_1.jpg", Image2 = "Asus TUF Gaming A15 FA506II-BQ200_2.jpg", Image3 = "Asus TUF Gaming A15 FA506II-BQ200_3.jpg" } ); context.SaveChanges(); } }
public EfOrderRepository(TechnoStoreDbContext db) { _db = db; }
public EfCouponRepository(TechnoStoreDbContext dbContext) { _dbContext = dbContext; }
public HomeService(TechnoStoreDbContext dbContext) { _dbContext = dbContext; }
public EfProductRepository(TechnoStoreDbContext context) { _context = context; }
public EfOrderDetailRepository(TechnoStoreDbContext dbContext) { _dbContext = dbContext; }
public EfPaymentRepository(TechnoStoreDbContext dbContext) { _dbContext = dbContext; }
public void Update(Table table) { using var db = new TechnoStoreDbContext(); db.Set <Table>().Update(table); db.SaveChanges(); }
public EfShipperRepository(TechnoStoreDbContext dbContext) { _dbContext = dbContext; }
public EfAddressRepository(TechnoStoreDbContext context) { _context = context; }
public EfCategoryRepository(TechnoStoreDbContext context) { _context = context; }
public List <Table> GetAllOrders() { using var db = new TechnoStoreDbContext(); return(db.Set <Table>().ToList()); }
public Table GetOrderWithId(int id) { using var db = new TechnoStoreDbContext(); return(db.Set <Table>().Find(id)); }