public bool SaveCampaignsCategories(int campaignId = 0, List <Category> categories = null) { try { var campaign = db.Campaign.FirstOrDefault(c => c.Id == campaignId); foreach (var category in categories) { var cat = db.Category.FirstOrDefault(c => c.Id == category.Id); CampaignCategoryMapping campaignCategoryMapping = new CampaignCategoryMapping() { Category = cat, Campaign = campaign }; db.CampaignCategoryMapping.Add(campaignCategoryMapping); } db.SaveChanges(); return(true); } catch { return(false); } }
protected override void Seed(DatabaseContext context) { #region Veritabanı oluşurken örnek verileri kaydet #region Kategoriler Category category1 = new Category() { Title = "Telefon" }; context.Category.Add(category1); Category category2 = new Category() { Title = "Bilgisayar" }; context.Category.Add(category2); context.SaveChanges(); var telefon = context.Category.FirstOrDefault(c => c.Id == 1); Category category3 = new Category() { Title = "Apple", Parent = telefon }; context.Category.Add(category3); Category category4 = new Category() { Title = "Beyaz Eşya" }; context.Category.Add(category4); Category category5 = new Category() { Title = "Mutfak Eşyaları" }; context.Category.Add(category5); Category category6 = new Category() { Title = "Motosiklet" }; context.Category.Add(category6); context.SaveChanges(); #endregion #region Ürünler var telefonCat = context.Category.FirstOrDefault(c => c.Id == 1); var apple = context.Category.FirstOrDefault(c => c.Id == 3); var bilgisayar = context.Category.FirstOrDefault(c => c.Id == 2); var beyazesya = context.Category.FirstOrDefault(c => c.Id == 4); var mutfakesyalari = context.Category.FirstOrDefault(c => c.Id == 5); var motosiklet = context.Category.FirstOrDefault(c => c.Id == 6); Product product1 = new Product() { Title = "IPhone 4s", Price = 999, Category = apple }; context.Product.Add(product1); Product product2 = new Product() { Title = "IPhone 5s", Price = 1999, Category = apple }; context.Product.Add(product2); Product product3 = new Product() { Title = "IPhone 6s", Price = 2599, Category = apple }; context.Product.Add(product3); Product product4 = new Product() { Title = "IPhone 7s", Price = 2999, Category = apple }; context.Product.Add(product4); Product product5 = new Product() { Title = "IPhone 8s", Price = 3333, Category = apple }; context.Product.Add(product5); Product product6 = new Product() { Title = "Vestel Venus", Price = 750, Category = telefonCat }; context.Product.Add(product6); Product product7 = new Product() { Title = "Asus nw978x", Price = 2999, Category = bilgisayar }; context.Product.Add(product7); Product product8 = new Product() { Title = "Lenovo l8xm8", Price = 3499, Category = bilgisayar }; context.Product.Add(product8); Product product9 = new Product() { Title = "Çamaşır Makinası", Price = 4878, Category = beyazesya }; context.Product.Add(product9); Product product10 = new Product() { Title = "HTC xyz", Price = 789, Category = telefonCat }; context.Product.Add(product10); Product product11 = new Product() { Title = "Tencere", Price = 4000, Category = mutfakesyalari }; context.Product.Add(product11); Product product12 = new Product() { Title = "Kask", Price = 1000, Category = motosiklet }; context.Product.Add(product12); Product product13 = new Product() { Title = "Dizlik", Price = 1500, Category = motosiklet }; context.Product.Add(product13); Product product14 = new Product() { Title = "Bot", Price = 2000, Category = motosiklet }; context.Product.Add(product14); context.SaveChanges(); #endregion #region Sepete ürün ekle #region Sepet1 ShoppingCart.Entities.Cart.ShoppingCart cart1 = new Entities.Cart.ShoppingCart() { }; context.ShoppingCart.Add(cart1); context.SaveChanges(); var cart1db = context.ShoppingCart.FirstOrDefault(x => x.Id == 1); var cartIphone4s = context.Product.FirstOrDefault(x => x.Title == "IPhone 4s"); var cartIphone5s = context.Product.FirstOrDefault(x => x.Title == "IPhone 5s"); var cartIphone6s = context.Product.FirstOrDefault(x => x.Title == "IPhone 6s"); var cartIphone7s = context.Product.FirstOrDefault(x => x.Title == "IPhone 7s"); var cartIphone8s = context.Product.FirstOrDefault(x => x.Title == "IPhone 8s"); var lenovoLaptop = context.Product.FirstOrDefault(x => x.Title == "Lenovo l8xm8"); var htcTelefon = context.Product.FirstOrDefault(x => x.Title == "HTC xyz"); ShoppingCartDetail cart1Product1 = new ShoppingCartDetail() { Product = cartIphone4s, Quantity = 2, ShoppingCart = cart1db }; ShoppingCartDetail cart1Product2 = new ShoppingCartDetail() { Product = cartIphone5s, Quantity = 2, ShoppingCart = cart1db }; ShoppingCartDetail cart1Product3 = new ShoppingCartDetail() { Product = cartIphone6s, Quantity = 3, ShoppingCart = cart1db }; ShoppingCartDetail cart1Product4 = new ShoppingCartDetail() { Product = cartIphone7s, Quantity = 1, ShoppingCart = cart1db }; ShoppingCartDetail cart1Product5 = new ShoppingCartDetail() { Product = cartIphone8s, Quantity = 1, ShoppingCart = cart1db }; ShoppingCartDetail cart1Product6 = new ShoppingCartDetail() { Product = lenovoLaptop, Quantity = 1, ShoppingCart = cart1db }; ShoppingCartDetail cart1Product7 = new ShoppingCartDetail() { Product = htcTelefon, Quantity = 1, ShoppingCart = cart1db }; context.ShoppingCartDetail.Add(cart1Product1); context.ShoppingCartDetail.Add(cart1Product2); context.ShoppingCartDetail.Add(cart1Product3); context.ShoppingCartDetail.Add(cart1Product4); context.ShoppingCartDetail.Add(cart1Product5); context.ShoppingCartDetail.Add(cart1Product6); context.ShoppingCartDetail.Add(cart1Product7); context.SaveChanges(); #endregion #region Sepet2 ShoppingCart.Entities.Cart.ShoppingCart cart2 = new Entities.Cart.ShoppingCart() { }; context.ShoppingCart.Add(cart2); context.SaveChanges(); var cart2db = context.ShoppingCart.FirstOrDefault(x => x.Id == 2); var tencere = context.Product.FirstOrDefault(x => x.Title == "Tencere"); ShoppingCartDetail cart2Product1 = new ShoppingCartDetail() { Product = tencere, Quantity = 2, ShoppingCart = cart2db }; context.ShoppingCartDetail.Add(cart2Product1); context.SaveChanges(); #endregion #region Sepet3 ShoppingCart.Entities.Cart.ShoppingCart cart3 = new Entities.Cart.ShoppingCart() { }; context.ShoppingCart.Add(cart3); context.SaveChanges(); var cart3db = context.ShoppingCart.FirstOrDefault(x => x.Id == 3); var kask = context.Product.FirstOrDefault(x => x.Title == "Kask"); var dizlik = context.Product.FirstOrDefault(x => x.Title == "Dizlik"); var bot = context.Product.FirstOrDefault(x => x.Title == "Bot"); ShoppingCartDetail cart3Product1 = new ShoppingCartDetail() { Product = kask, Quantity = 1, ShoppingCart = cart3db }; ShoppingCartDetail cart3Product2 = new ShoppingCartDetail() { Product = dizlik, Quantity = 1, ShoppingCart = cart3db }; ShoppingCartDetail cart3Product3 = new ShoppingCartDetail() { Product = bot, Quantity = 1, ShoppingCart = cart3db }; context.ShoppingCartDetail.Add(cart3Product1); context.ShoppingCartDetail.Add(cart3Product2); context.ShoppingCartDetail.Add(cart3Product3); context.SaveChanges(); #endregion #endregion #region İndirim Ekle #region İndirim 1 Campaign campaign1 = new Campaign() { DiscountValue = 20.0, ProductCount = 3, DiscountType = DiscountType.Rate }; context.Campaign.Add(campaign1); context.SaveChanges(); var appleCatForCampaign = context.Category.FirstOrDefault(c => c.Title == "Apple"); var dbCampaign1 = context.Campaign.FirstOrDefault(c => c.Id == 1); CampaignCategoryMapping campaignCategoryMapping1 = new CampaignCategoryMapping() { Category = appleCatForCampaign, Campaign = dbCampaign1 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping1); #endregion #region İndirim 2 Campaign campaign2 = new Campaign() { DiscountValue = 50.0, ProductCount = 5, DiscountType = DiscountType.Rate }; context.Campaign.Add(campaign2); context.SaveChanges(); var dbCampaign2 = context.Campaign.FirstOrDefault(c => c.Id == 2); CampaignCategoryMapping campaignCategoryMapping2 = new CampaignCategoryMapping() { Category = appleCatForCampaign, Campaign = dbCampaign2 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping2); #endregion #region İndirim 3 Campaign campaign3 = new Campaign() { DiscountValue = 5.0, ProductCount = 5, DiscountType = DiscountType.Amount }; context.Campaign.Add(campaign3); context.SaveChanges(); var dbCampaign3 = context.Campaign.FirstOrDefault(c => c.Id == 3); CampaignCategoryMapping campaignCategoryMapping3 = new CampaignCategoryMapping() { Category = appleCatForCampaign, Campaign = dbCampaign3 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping3); context.SaveChanges(); #endregion #region İndirim 4 Campaign campaign4 = new Campaign() { DiscountValue = 70, ProductCount = 25, DiscountType = DiscountType.Rate }; context.Campaign.Add(campaign4); context.SaveChanges(); var dbCampaign4 = context.Campaign.FirstOrDefault(c => c.Id == 4); CampaignCategoryMapping campaignCategoryMapping4 = new CampaignCategoryMapping() { Category = appleCatForCampaign, Campaign = dbCampaign4 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping4); context.SaveChanges(); #endregion #region İndirim 5 var beyazEsyaCatForCampaign = context.Category.FirstOrDefault(c => c.Title == "Beyaz Eşya"); Campaign campaign5 = new Campaign() { DiscountValue = 50, ProductCount = 1, DiscountType = DiscountType.Rate }; context.Campaign.Add(campaign5); context.SaveChanges(); var dbCampaign5 = context.Campaign.FirstOrDefault(c => c.Id == 5); CampaignCategoryMapping campaignCategoryMapping5 = new CampaignCategoryMapping() { Category = beyazEsyaCatForCampaign, Campaign = dbCampaign5 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping5); context.SaveChanges(); #endregion #region İndirim 6 Campaign campaign6 = new Campaign() { DiscountValue = 15, ProductCount = 5, DiscountType = DiscountType.Rate }; context.Campaign.Add(campaign6); context.SaveChanges(); var dbCampaign6 = context.Campaign.FirstOrDefault(c => c.Id == 6); var telefonCatForCampaign = context.Category.FirstOrDefault(c => c.Title == "Telefon"); CampaignCategoryMapping campaignCategoryMapping6 = new CampaignCategoryMapping() { Category = telefonCatForCampaign, Campaign = dbCampaign6 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping6); context.SaveChanges(); #endregion #region İndirim 7 Campaign campaign7 = new Campaign() { DiscountValue = 10, ProductCount = 2, DiscountType = DiscountType.Rate }; context.Campaign.Add(campaign7); context.SaveChanges(); var dbCampaign7 = context.Campaign.FirstOrDefault(c => c.Id == 7); var motosikletCatForCampaign = context.Category.FirstOrDefault(c => c.Title == "Motosiklet"); CampaignCategoryMapping campaignCategoryMapping7 = new CampaignCategoryMapping() { Category = motosikletCatForCampaign, Campaign = dbCampaign7 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping7); context.SaveChanges(); #endregion #region İndirim 8 Campaign campaign8 = new Campaign() { DiscountValue = 20, ProductCount = 2, DiscountType = DiscountType.Rate }; context.Campaign.Add(campaign8); context.SaveChanges(); var dbCampaign8 = context.Campaign.FirstOrDefault(c => c.Id == 8); CampaignCategoryMapping campaignCategoryMapping8 = new CampaignCategoryMapping() { Category = motosikletCatForCampaign, Campaign = dbCampaign8 }; context.CampaignCategoryMapping.Add(campaignCategoryMapping8); context.SaveChanges(); #endregion #endregion #region Kupon Ekle Coupon coupon = new Coupon() { DiscountType = DiscountType.Rate, MinAmount = 2000, DiscountValue = 10 }; context.Coupon.Add(coupon); context.SaveChanges(); #endregion #endregion }