public static void Seed(EshopDbContext context) { context.Vendors.RemoveRange(context.Vendors); context.SaveChanges(); // init seed data Random random = new Random(); var vendors = new List <Vendor>(); for (int i = 0; i < 250; i++) { var dic = LoremNET.Lorem.Words(1).ToUpper(); vendors.Add(new Vendor() { Id = Guid.NewGuid(), Name = LoremNET.Lorem.Words(2), Director = LoremNET.Lorem.Words(2), Ico = (int)LoremNET.Lorem.Number(123456789, 99999999), Dic = dic.Length > 12 ? dic.Substring(0, 11) : dic, ContactId = ContactSeeder.GenerateContact(context) }); } context.Vendors.AddRange(vendors); context.SaveChanges(); }
public static void Seed(EshopDbContext context) { context.ProductStates.RemoveRange(context.ProductStates); context.SaveChanges(); var productStates = new List <ProductState>(); productStates.Add(new ProductState() { Id = new Guid("403d3f4d-3dcf-4516-8720-fc5f9db11b1d"), Name = "New", Code = 0 }); productStates.Add(new ProductState() { Id = new Guid("c44cd351-69ea-4e20-80be-aecaa6d377dc"), Name = "In Catalog", Code = 1 }); productStates.Add(new ProductState() { Id = new Guid("a7055d5f-d404-4756-94f9-9bd7271626ad"), Name = "Archived", Code = 2 }); context.ProductStates.AddRange(productStates); context.SaveChanges(); }
public TEntity Create(TEntity item) { var entity = _dbSet.Add(item); _context.SaveChanges(); return(entity); }
public ActionResult Create([Bind(Include = "Id,CategoryId,CompanyId,ModelName,Description")] Product product) { if (ModelState.IsValid) { _db.Products.Add(product); _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryId = new SelectList(_db.Categories, "Id", "Name", product.CategoryId); ViewBag.CompanyId = new SelectList(_db.Companies, "Id", "PersianName", product.CompanyId); return(View(product)); }
public async Task <ApiResult <bool> > Delete(Guid Id) { var user = await _userManager.FindByIdAsync(Id.ToString()); if (user == null) { return(new ApiErrorResult <bool>("Người dùng không tồn tại !")); } if (_context.Orders.Where(x => x.UserId == Id).FirstOrDefault() == null) { await _userManager.DeleteAsync(user); return(new ApiSuccessResult <bool>("Xóa thành công", true)); } else { user.Status = Data.Enums.Status.InActive; user.PhoneNumber = ""; user.Email = ""; user.FirstName = ""; user.LastName = ""; _context.SaveChanges(); return(new ApiSuccessResult <bool>("Xóa thành công dữ liệu người dùng", true)); } }
public static void Seed(EshopDbContext context) { context.OrderStates.RemoveRange(context.OrderStates); context.SaveChanges(); var orderStates = new List <OrderState>(); orderStates.Add(new OrderState() { Id = new Guid("251bffe2-9397-4424-97f9-95059b3d2262"), Name = "New", Code = 0 }); orderStates.Add(new OrderState() { Id = new Guid("67aaa8f5-bb86-4dd2-bb8c-369a803fddbf"), Name = "Processing", Code = 1 }); orderStates.Add(new OrderState() { Id = new Guid("60b720b7-6e0d-4139-8de6-ef6f111c690e"), Name = "Pending Payment", Code = 2 }); orderStates.Add(new OrderState() { Id = new Guid("0b9bf938-8376-49b3-94fb-4e444522d507"), Name = "Canceled", Code = 3 }); orderStates.Add(new OrderState() { Id = new Guid("c5f9d229-1c83-428a-8e88-9afac4cc0147"), Name = "Complete", Code = 4 }); context.OrderStates.AddRange(orderStates); context.SaveChanges(); }
public async Task <ApiResult <bool> > Delete(int orderId) { var order = await _context.Orders.FindAsync(orderId); if (order != null) { _context.Orders.Remove(order); if (_context.SaveChanges() != 0) { return(new ApiSuccessResult <bool>()); } return(new ApiErrorResult <bool>()); } else { return(new ApiErrorResult <bool>()); } }
public static void Seed(EshopDbContext context) { context.Roles.RemoveRange(context.Roles); context.UserRoles.RemoveRange(context.UserRoles); context.SaveChanges(); var roles = new List <Role>(); roles.Add(new Role() { Id = new Guid("9d8329f1-82f5-4cbb-ba4b-955211457707"), Name = "Administrator", Code = "Admin" }); roles.Add(new Role() { Id = new Guid("4e7f583f-d4f1-4d7a-833e-693fbf99b6e9"), Name = "Manager", Code = "Manager" }); roles.Add(new Role() { Id = new Guid("7446d1fb-a305-440c-b6d9-53769dc1e08a"), Name = "Seller", Code = "Seller" }); roles.Add(new Role() { Id = new Guid("7bf2bcb3-9eb0-4e0d-a88b-9a6937bdee85"), Name = "Customer", Code = "Customer" }); context.Roles.AddRange(roles); context.SaveChanges(); }
public static void Seed(EshopDbContext context) { context.Products.RemoveRange(context.Products); context.SaveChanges(); // init seed data Random random = new Random(); const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 "; var vendors = context.Vendors.ToList(); var products = new List <Product>(); // Category 1 - GUID 25320c5e-f58a-4b1f-b63a-8ee07a840bdf for (int i = 0; i < 10; i++) { products.Add(new Product() { Id = Guid.NewGuid(), Name = LoremNET.Lorem.Words(2), Description = LoremNET.Lorem.Words(random.Next(4, 10)), Price = random.NextDouble() * (10.2 - 2550.4) + 2550.4, CategoryId = new Guid("25320c5e-f58a-4b1f-b63a-8ee07a840bdf"), ProductStateId = new Guid("c44cd351-69ea-4e20-80be-aecaa6d377dc"), VendorId = vendors[random.Next(0, 249)].Id, ProductNumber = LoremNET.Lorem.Words(1), ProductCode = LoremNET.Lorem.Words(1), StockCount = random.Next(0, 100) }); } // Category 1.1 - GUID a3749477-f823-4124-aa4a-fc9ad5e79cd6 for (int i = 0; i < 20; i++) { products.Add(new Product() { Id = Guid.NewGuid(), Name = LoremNET.Lorem.Words(2), Description = LoremNET.Lorem.Words(random.Next(4, 10)), Price = random.NextDouble() * (10.2 - 255.4) + 10.2 * -1, CategoryId = new Guid("a3749477-f823-4124-aa4a-fc9ad5e79cd6"), VendorId = vendors[random.Next(0, 249)].Id, ProductStateId = new Guid("c44cd351-69ea-4e20-80be-aecaa6d377dc"), ProductNumber = LoremNET.Lorem.Words(1), ProductCode = LoremNET.Lorem.Words(1), StockCount = random.Next(0, 100) }); } // Category 2 - GUID 60188a2b-2784-4fc4-8df8-8919ff838b0b for (int i = 0; i < 10000; i++) { products.Add(new Product() { Id = Guid.NewGuid(), Name = LoremNET.Lorem.Words(2), Description = LoremNET.Lorem.Words(random.Next(4, 10)), Price = random.NextDouble() * (10.2 - 255.4) + 10.2 * -1, CategoryId = new Guid("60188a2b-2784-4fc4-8df8-8919ff838b0b"), ProductStateId = new Guid("c44cd351-69ea-4e20-80be-aecaa6d377dc"), VendorId = vendors[random.Next(0, 249)].Id, ProductNumber = LoremNET.Lorem.Words(1), ProductCode = LoremNET.Lorem.Words(1), StockCount = random.Next(0, 100) }); } context.Products.AddRange(products); context.SaveChanges(); }
public bool Save() { return(_context.SaveChanges() >= 0); }
public static void Seed(EshopDbContext context) { context.Users.RemoveRange(context.Users); context.SaveChanges(); // init seed data Random random = new Random(); var users = new List <User>(); var user = new User() { Id = new Guid("c5e75dd1-1661-424d-8745-e9a002563c27"), Username = "******", Password = PasswordHasher.CreateHash("admin123", "AN>1w`YqLNgY})adEzwyQI&qblGW}[5%9MH9de'Ov:R(}U?g/au!>#Mtxk=>@d"), Email = "*****@*****.**", Firstname = "Jarmil", Lastname = "Prdel", ContactId = ContactSeeder.GenerateContact(context) }; users.Add(user); RolesSeeder.MapUserRole(context, user.Id, new Guid("9d8329f1-82f5-4cbb-ba4b-955211457707")); // administrator RolesSeeder.MapUserRole(context, user.Id, new Guid("4e7f583f-d4f1-4d7a-833e-693fbf99b6e9")); // manager RolesSeeder.MapUserRole(context, user.Id, new Guid("7446d1fb-a305-440c-b6d9-53769dc1e08a")); // seller // other dashboard managers for (int i = 0; i < 10; i++) { user = new User() { Id = Guid.NewGuid(), Username = LoremNET.Lorem.Words(1), Email = LoremNET.Lorem.Email(), Password = PasswordHasher.CreateHash("Test123", "AN>1w`YqLNgY})adEzwyQI&qblGW}[5%9MH9de'Ov:R(}U?g/au!>#Mtxk=>@d"), Firstname = LoremNET.Lorem.Words(1), Lastname = LoremNET.Lorem.Words(1), ContactId = ContactSeeder.GenerateContact(context) }; users.Add(user); RolesSeeder.MapUserRole(context, user.Id, new Guid("4e7f583f-d4f1-4d7a-833e-693fbf99b6e9")); // manager } // customers for (int i = 0; i < 4000; i++) { var customer = new User() { Id = Guid.NewGuid(), Username = LoremNET.Lorem.Words(1), Email = LoremNET.Lorem.Email(), Password = PasswordHasher.CreateHash("Test123", "AN>1w`YqLNgY})adEzwyQI&qblGW}[5%9MH9de'Ov:R(}U?g/au!>#Mtxk=>@d"), Firstname = LoremNET.Lorem.Words(1), Lastname = LoremNET.Lorem.Words(1), ContactId = ContactSeeder.GenerateContact(context) }; users.Add(customer); RolesSeeder.MapUserRole(context, customer.Id, new Guid("7bf2bcb3-9eb0-4e0d-a88b-9a6937bdee85")); // customer } context.Users.AddRange(users); context.SaveChanges(); }
public static void Seed(EshopDbContext context) { context.Categories.RemoveRange(context.Categories); context.SaveChanges(); // init seed data var categories = new List <Category>(); var category1 = new Category() { Id = new Guid("25320c5e-f58a-4b1f-b63a-8ee07a840bdf"), Name = "Category 1", }; categories.Add(category1); categories.Add(new Category() { Id = new Guid("a3749477-f823-4124-aa4a-fc9ad5e79cd6"), Name = "Category 1.1", ParentId = category1.Id }); categories.Add(new Category() { Id = Guid.NewGuid(), Name = "Category 1.2", ParentId = category1.Id }); categories.Add(new Category() { Id = Guid.NewGuid(), Name = "Category 1.3", ParentId = category1.Id }); var category2 = new Category() { Id = new Guid("60188a2b-2784-4fc4-8df8-8919ff838b0b"), Name = "Category 2" }; categories.Add(category2); categories.Add(new Category() { Id = Guid.NewGuid(), Name = "Category 2.1", ParentId = category2.Id }); categories.Add(new Category() { Id = Guid.NewGuid(), Name = "Category 2.2", ParentId = category2.Id }); categories.Add(new Category() { Id = Guid.NewGuid(), Name = "Category 3", }); categories.Add(new Category() { Id = Guid.NewGuid(), Name = "Category 4", }); context.Categories.AddRange(categories); context.SaveChanges(); }
public async Task <ApiResult <bool> > Create(ProductCreateRequest request) { List <Language> languages = await _context.Languages.ToListAsync(); List <ProductTranslation> productTranslations = new List <ProductTranslation>(); foreach (var language in languages) { if (request.LanguageId == language.Id) { productTranslations.Add(new ProductTranslation() { Name = request.Name, Description = request.Description, Details = request.Details, SeoDescription = request.SeoDescription, SeoTitle = request.SeoTitle, SeoAlias = request.SeoAlias, LanguageId = request.LanguageId }); } else { productTranslations.Add(new ProductTranslation() { Name = "", Description = "", Details = "", SeoDescription = "", SeoTitle = "", SeoAlias = "", LanguageId = language.Id }); } } var product = new Product() { Price = request.Price, OriginalPrice = request.Price, Stock = request.Stock, ViewCount = 0, DateCreated = DateTime.Now, IsFeatured = request.isFeatured, ProductTranslations = productTranslations }; if (request.ThumbnailImage != null) { product.ProductImages = new List <ProductImage>() { new ProductImage() { Caption = "Thumbnail image", DateCreated = DateTime.Now, FileSize = request.ThumbnailImage.Length, ImagePath = await this.SaveFile(request.ThumbnailImage), SortOrder = 1 } }; } _context.Products.Add(product); if (_context.SaveChanges() == 0) { return(new ApiErrorResult <bool>("Đăng kí không thành công")); } return(new ApiSuccessResult <bool>()); }