public void LoginUser() { SomethingsHereEntities entities = new SomethingsHereEntities(); LoginUser user = new LoginUser(); user.Answer = "Answer"; user.CreatedDate = DateTime.Now; user.Email = "*****@*****.**"; user.IsActive = true; user.Password = CryptoManager.Encrypt("123"); //user.Password = CryptoManager.Decrypt(user.Password); //sifreleme aes kullanılır public ve private key vardır user.Question = "Question"; user.Username = "******"; entities.LoginUser.Add(user); entities.SaveChanges(); LoginUserDetail loginUserDetail = new LoginUserDetail(); loginUserDetail.ID = user.ID; loginUserDetail.DeliveryAddress = "İzmir"; loginUserDetail.Fullname = "Mehmet Aydın Kıcırtı"; loginUserDetail.Gender = /*Convert.ToInt32(E_Gender.Male);*/ (int)E_Gender.Male; loginUserDetail.InvoiceAddress = "İzmir"; loginUserDetail.Phone = "0544083044"; entities.LoginUserDetail.Add(loginUserDetail); entities.SaveChanges(); }
public void CreateBrand() { List <string> brands = new List <string>(); brands.Add("İphone"); brands.Add("Samsung"); brands.Add("Nokia"); brands.Add("Lego"); brands.Add("Lg"); brands.Add("Bosch"); brands.Add("Adidas"); brands.Add("Asus"); brands.Add("Kodlab"); SomethingsHereEntities db = new SomethingsHereEntities(); foreach (string item in brands) { Brand brand = new Brand(); brand.Name = item; brand.IsActive = true; brand.Description = "This is desc for " + item; db.Brand.Add(brand); db.SaveChanges(); } }
public void CreateProductImages() { SomethingsHereEntities entities = new SomethingsHereEntities(); List <Product> products = new List <Product>(); products = entities.Product.ToList(); Random random = new Random(); foreach (var item in products) { int randomNumber = random.Next(0, 3); for (int i = 0; i < 3; i++) { ProductImage image = new ProductImage(); image.Name = (i + 1) + ".gif"; image.ProductID = item.ID; image.Type = (int)E_Type.GIF; image.ImagePath = "/ProductImages/" + (i + 1) + ".gif"; if (i == randomNumber) { image.IsActive = true; } else { image.IsActive = false; } entities.ProductImage.Add(image); } entities.SaveChanges(); } }
public void CreateCategory() { List <string> categories = new List <string>(); categories.Add("Beyaz Esya"); categories.Add("Elektronik"); categories.Add("Oyuncak"); categories.Add("Bilgisayar"); categories.Add("Aksesuar"); categories.Add("Kitap"); categories.Add("Otomobil"); categories.Add("Cep Telefonu"); categories.Add("Spor Malzemeleri"); SomethingsHereEntities db = new SomethingsHereEntities(); foreach (string item in categories) { Category category = new Category(); category.CategoryName = item; category.Description = "This is Desc for :" + item; category.IsActive = true; db.Category.Add(category); db.SaveChanges(); } }
public void CreateProduct() { SomethingsHereEntities entities = new SomethingsHereEntities(); List <Brand> brands = entities.Brand.ToList(); List <Supplier> suppliers = entities.Supplier.ToList(); Random random = new Random(); for (int i = 1; i < 1001; i++) { Product product = new Product(); product.BrandID = brands[random.Next(0, brands.Count)].ID; product.SupplierID = suppliers[random.Next(0, suppliers.Count)].ID; product.ProductName = "Product Name:" + i; product.Price = random.Next(1, 10000); if (i % 100 == 0) { product.Stock = 0; product.IsActive = false; } else { //bir döngünün icinde db saveschange yapmak icin kayıt sayısının 500 den kücük olması gerekir aksi takdirde dısarıda olması gerekir. product.Stock = random.Next(1, 1001); product.IsActive = true; } product.CreatedDate = DateTime.Now.AddDays(random.Next(1, 366)); entities.Product.Add(product); } entities.SaveChanges(); }
public void CreateSupplier() { List <string> supplier = new List <string>(); supplier.Add("apple Company"); supplier.Add("Electronic arts"); supplier.Add("Microsoft"); foreach (string item in supplier) { SomethingsHereEntities entities = new SomethingsHereEntities(); Supplier supplierGetir = new Supplier(); supplierGetir.Name = item; supplierGetir.ContactName = "Contact Text"; supplierGetir.Phone = "123456"; supplierGetir.StartDate = DateTime.Now; supplierGetir.IsActive = true; entities.Supplier.Add(supplierGetir); entities.SaveChanges(); } }
public void CreateProductProperty() { SomethingsHereEntities entities = new SomethingsHereEntities(); List <Product> products = entities.Product.ToList(); Random random = new Random(); foreach (Product item in products) { for (int i = 0; i < random.Next(1, 11); i++) { ProductProperty productProperty = new ProductProperty(); productProperty.IsActive = true; productProperty.Name = "Property" + item.ProductName + " " + i; productProperty.Value = "Value " + i; productProperty.ProductID = item.ID; entities.ProductProperty.Add(productProperty); } } entities.SaveChanges(); }