/// <summary> /// 用户信息导入 /// </summary> /// <returns></returns> public IActionResult ImportMemInfJob() { using var context = new SupermarketDbContext(); StreamReader sr = new StreamReader("test.txt"); string name, phone, password; for (int i = 0; i < 3; i++) { var member = new Member() { Credit = 0 }; name = sr.ReadLine(); member.Name = name; phone = sr.ReadLine(); member.Phone = phone; password = sr.ReadLine(); member.Password = password; context.Member.Add(member); context.SaveChanges(); } return(View()); }
public static void SeedRoles(SupermarketDbContext context, RoleManager <ApplicationRole> roleManager) { var roles = new List <ApplicationRole>() { new ApplicationRole() { Name = ApplicationUser.Roles.admin, NormalizedName = ApplicationUser.Roles.Admin }, new ApplicationRole() { Name = ApplicationUser.Roles.storeKeeper, NormalizedName = ApplicationUser.Roles.StoreKeeper }, new ApplicationRole() { Name = ApplicationUser.Roles.manager, NormalizedName = ApplicationUser.Roles.Manager }, }; roles.ForEach(role => { var dbRole = context.Roles.FirstOrDefault(r => r.Name == role.Name); if (dbRole == null) { context.Roles.Add(role); } }); context.SaveChanges(); }
public static void SeedProducts(SupermarketDbContext context) { var faker = new Faker(); string product1 = faker.Commerce.ProductName(); string product2 = faker.Commerce.ProductName(); string product3 = faker.Commerce.ProductName(); string product4 = faker.Commerce.ProductName(); var category = context.Categories.FirstOrDefault(p => p.Name == "Electronics"); var category2 = context.Categories.FirstOrDefault(p => p.Name == "Toiletries"); var category3 = context.Categories.FirstOrDefault(p => p.Name == "Miscellaneous"); var category4 = context.Categories.FirstOrDefault(p => p.Name == "Fashion"); var products = new List <Product>() { new Product() { Name = product1, QuantityInStock = faker.Random.Number(1, 9), UnitOfMeasurement = EUnitOfMeasurement.Kilogram, CategoryId = category.Id }, new Product() { Name = product2, QuantityInStock = faker.Random.Number(2, 12), UnitOfMeasurement = EUnitOfMeasurement.Kilogram, CategoryId = category2.Id }, new Product() { Name = product3, QuantityInStock = faker.Random.Number(3, 13), UnitOfMeasurement = EUnitOfMeasurement.Gram, CategoryId = category3.Id }, new Product() { Name = product4, QuantityInStock = faker.Random.Number(5, 15), UnitOfMeasurement = EUnitOfMeasurement.Kilogram, CategoryId = category4.Id } }; products.ForEach(product => { var dbProduct = context.Products.FirstOrDefault(p => p.Name == product.Name); if (dbProduct == null) { context.Products.Add(product); } }); context.SaveChanges(); }
public IActionResult MemberDisplay(string phonetail) { using var context = new SupermarketDbContext(); var members = new List <Member>(); members = context.Member.Where(x => x.Phone.Contains(phonetail)).ToList(); return(View("MemberDisplay", members)); }
/// <summary> /// 会员消费信息统计 /// </summary> /// <param name="memberid"></param> /// <returns></returns> public IActionResult MemberStatistics(int memberid) { using var context = new SupermarketDbContext(); var gooditems = new List <MemberGoodMapping>(); gooditems = context.MemberGoodMapping.Where(x => x.MemberId.Equals(memberid)).ToList(); return(View("memberstatistics", gooditems)); }
/// <summary> /// 查询会员消费记录 /// </summary> /// <param name="memberid"></param> /// <returns></returns> public IActionResult EnquiryShopJob(int memberid) { using var context = new SupermarketDbContext(); var shopItems = new List <MemberGoodMapping>(); shopItems = context.MemberGoodMapping.Where(x => x.MemberId.Equals(memberid)).ToList(); return(View("EnquiryShopJob", shopItems)); }
/// <summary> /// 会员制度管理 /// </summary> /// <param name="viplevelid"></param> /// <param name="levelrateafter"></param> /// <returns></returns> public IActionResult VipManageJob(int viplevelid, double levelrateafter) { using var context = new SupermarketDbContext(); var levelitems = context.Level.FirstOrDefault(x => x.Id.Equals(viplevelid)); levelitems.DiscountRate = levelrateafter; context.SaveChanges(); return(View()); }
/// <summary> /// 会员等级修改 /// </summary> /// <param name="memberid"></param> /// <param name="levelafter"></param> /// <returns></returns> public IActionResult MemberLevelChange(int memberid, int levelafter) { using var context = new SupermarketDbContext(); var levelitems = context.MemberLevelMapping.FirstOrDefault(x => x.MemberId.Equals(memberid)); levelitems.LevelId = levelafter; context.SaveChanges(); return(View()); }
/// <summary> /// 修改会员消费记录 /// </summary> /// <param name="memberid"></param> /// <param name="goodid"></param> /// <param name="quantity"></param> /// <returns></returns> public IActionResult AmendShopJob(int memberid, int goodid, int quantity) { using var context = new SupermarketDbContext(); var gooditems = context.MemberGoodMapping.FirstOrDefault(x => x.MemberId.Equals(memberid)); gooditems.GoodId = goodid; gooditems.Quantity = quantity; context.SaveChanges(); return(View()); }
public IActionResult MemAmendJob(string name, string phone, string password, string nameafter, string phoneafter, string passwordafter) { using var context = new SupermarketDbContext(); var members = context.Member.FirstOrDefault(x => x.Phone.Contains(phone)); members.Name = nameafter; members.Phone = phoneafter; members.Password = passwordafter; context.SaveChanges(); return(View()); }
/// <summary> /// 注销会员 /// </summary> /// <param name="phonetail"></param> /// <returns></returns> public IActionResult DeleteByOneString(string phonetail) { using var context = new SupermarketDbContext(); var members = context.Member.FirstOrDefault(x => x.Phone.Contains(phonetail)); var id = members.Id; var mem2 = context.MemberLevelMapping.FirstOrDefault(x => x.MemberId.Equals(id)); var mem3 = context.Statistics.FirstOrDefault(x => x.MemberId.Equals(id)); context.Remove(mem2); context.Remove(mem3); context.Remove(members); context.SaveChanges(); return(View()); }
public IActionResult MemberJob(string name, string phone, string password) { using var context = new SupermarketDbContext(); var member = new Member() { Credit = 0 }; member.Name = name; member.Phone = phone; member.Password = password; context.Member.Add(member); context.SaveChanges(); return(View()); }
/// <summary> /// 增加会员消费记录 /// </summary> /// <param name="memberid"></param> /// <param name="goodid"></param> /// <param name="quantity"></param> /// <returns></returns> public IActionResult RecordShopJob(int memberid, int goodid, int quantity) { using var context = new SupermarketDbContext(); var shopitems = new MemberGoodMapping() { Id = Guid.NewGuid().ToString(), CreateTime = DateTime.Now.ToString() }; shopitems.MemberId = memberid; shopitems.GoodId = goodid; shopitems.Quantity = quantity; //var find1 = context.Good.FirstOrDefault(x => x.Id.Equals(goodid)); //find1.Price context.MemberGoodMapping.Add(shopitems); context.SaveChanges(); return(View()); }
public static void SeedCategories(SupermarketDbContext context) { var categories = new List <Category>() { new Category() { Id = Guid.NewGuid(), Name = "Electronics" }, new Category() { Id = Guid.NewGuid(), Name = "Toiletries" }, new Category() { Id = Guid.NewGuid(), Name = "Miscellaneous" }, new Category() { Id = Guid.NewGuid(), Name = "Fashion" } }; categories.ForEach(category => { var dbCategory = context.Categories.FirstOrDefault(r => r.Name == category.Name); if (dbCategory == null) { context.Categories.Add(category); } }); context.SaveChanges(); }
public SendTem(SupermarketDbContext context) { _context = context; }
/// <summary> /// /// </summary> /// <param name="context"></param> /// <param name="hostingEnvironment"></param> public OrderController(SupermarketDbContext context, IHostingEnvironment hostingEnvironment) { _context = context; _hostingEnvironment = hostingEnvironment; }
/// <summary> /// /// </summary> /// <param name="context"></param> public WinnerController(SupermarketDbContext context) { _context = context; }
public BasketRepository(SupermarketDbContext context) { _context = context ?? throw new ArgumentNullException(nameof(context)); }
/// <summary> /// /// </summary> /// <param name="context"></param> public LotteryController(SupermarketDbContext context) { _context = context; }
/// <summary> /// /// </summary> /// <param name="context"></param> public AddressController(SupermarketDbContext context) { _context = context; }
/// <summary> /// 数据库连接 /// </summary> /// <param name="context"></param> public GoodsController(SupermarketDbContext context) { _context = context; }
public Token(SupermarketDbContext context) { _context = context; }
/// <summary> /// 配置数据库与文件流参数 /// </summary> /// <param name="context"></param> /// <param name="env"></param> public GoodsKindController(SupermarketDbContext context, IHostingEnvironment env) { _context = context; _Env = env; }
/// <summary> /// 初始化方法 /// </summary> /// <param name="context"></param> public DbInitializer(SupermarketDbContext context) { _context = context; //context.Database.EnsureCreated();//如果数据库不存在,那么它会创建,但不做任何事 }
public static void SeedUsers(SupermarketDbContext context, UserManager <ApplicationUser> userManager) { string password = "******"; var faker = new Faker(); var email = faker.Person.Email; var email2 = faker.Person.Email; var email3 = faker.Person.Email; var email4 = faker.Person.Email; var users = new List <ApplicationUser>() { new ApplicationUser { UserName = email, Email = email, EmailConfirmed = true, FullName = faker.Person.FullName }, new ApplicationUser { UserName = email2, Email = email2, EmailConfirmed = true, FullName = faker.Person.FullName }, new ApplicationUser { UserName = email3, Email = email3, EmailConfirmed = true, FullName = faker.Person.FullName }, new ApplicationUser { UserName = email4, Email = email4, EmailConfirmed = true, FullName = faker.Person.FullName } }; users.ForEach(user => { var dbUser = context.Users.FirstOrDefault(u => u.Email == user.Email); if (dbUser == null) { var result = userManager.CreateAsync(user, password).Result; if (!result.Succeeded) { Console.WriteLine("User Save Error: " + result.Errors.First().Description); } else { Console.WriteLine($"User { user.UserName } created"); } if (user.UserName.Contains("admin")) { result = userManager.AddToRoleAsync(user, ApplicationUser.Roles.Admin).Result; } else if (user.UserName.Contains("manager")) { result = userManager.AddToRoleAsync(user, ApplicationUser.Roles.Manager).Result; } else if (user.UserName.Contains("storeKeeper")) { result = userManager.AddToRoleAsync(user, ApplicationUser.Roles.StoreKeeper).Result; } if (!result.Succeeded) { Console.WriteLine("User to Role Error: " + result.Errors.First().Description); } } }); }
/// <summary> /// /// </summary> /// <param name="context"></param> public LoginController(SupermarketDbContext context) { _context = context; }
public ProductRepository(SupermarketDbContext context) : base(context) { }
public BaseRepository(SupermarketDbContext context) { _context = context; }
/// <summary> /// 数据库连接 /// </summary> /// <param name="context"></param> public AppCartController(SupermarketDbContext context) { _context = context; }
public CategoryRepository(SupermarketDbContext context) : base(context) { }