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>());
}