private async Task AddUserNotes()
        {
            var jsonText = File.ReadAllText("./Services/userNotes.json");
            var users    = JsonConvert.DeserializeObject <List <UserNotesDto> >(jsonText);

            foreach (var usernote in users)
            {
                var ns = new List <Note>();

                foreach (var n in usernote.Notes)
                {
                    ns.Add(new Note {
                        title = n.title, date = n.date
                    });
                }
                var u = new User
                {
                    //   id = usernote.id,
                    bio       = usernote.bio,
                    name      = usernote.name,
                    birthDate = usernote.birthDate,
                    avatar    = usernote.avatar,
                    Notes     = ns
                };

                _context.Users.Add(u);
                _context.SaveChanges();
            }
        }
示例#2
0
        public IActionResult Post([FromBody] ShoppingCartItem shoppingCartItem)
        {
            var shoppingCart = _dbContext.ShoppingCartItems.FirstOrDefault(s => s.ProductId == shoppingCartItem.ProductId && s.CustomerId == shoppingCartItem.CustomerId);

            if (shoppingCart != null)
            {
                shoppingCart.Qty        += shoppingCartItem.Qty;
                shoppingCart.TotalAmount = shoppingCart.Price * shoppingCart.Qty;
            }
            else
            {
                var sCart = new ShoppingCartItem()
                {
                    CustomerId  = shoppingCartItem.CustomerId,
                    ProductId   = shoppingCartItem.ProductId,
                    Price       = shoppingCartItem.Price,
                    Qty         = shoppingCartItem.Qty,
                    TotalAmount = shoppingCartItem.TotalAmount
                };
                _dbContext.ShoppingCartItems.Add(sCart);
            }

            _dbContext.SaveChanges();

            return(StatusCode(StatusCodes.Status201Created));
        }
示例#3
0
        public IActionResult Post([FromBody] Order order)
        {
            order.IsOrderCompleted = false;
            order.OrderPlaced      = DateTime.Now;
            _dbContext.Orders.Add(order);
            _dbContext.SaveChanges();

            var shoppingCartItems = _dbContext.ShoppingCartItems.Where(cart => cart.CustomerId == order.userId);

            foreach (var item in shoppingCartItems)
            {
                var orderDetail = new OrderDetail()
                {
                    Price       = item.Price,
                    TotalAmount = item.TotalAmount,
                    Qty         = item.Qty,
                    ProductId   = item.ProductId,
                    OrderId     = order.Id,
                };
                _dbContext.OrderDetails.Add(orderDetail);
            }

            _dbContext.SaveChanges();
            _dbContext.ShoppingCartItems.RemoveRange(shoppingCartItems);
            _dbContext.SaveChanges();

            return(Ok(new { OrderId = order.Id }));
        }
        public async Task <IActionResult> Register(AppInstallations AppInstallations)
        {
            var userWithSameEmail = _dbContext.AppInstallations.SingleOrDefault(u => u.userId == AppInstallations.userId && u.DeviceID == AppInstallations.DeviceID);

            if (userWithSameEmail != null)
            {
                var AppInstallation = _dbContext.AppInstallations.Where(s => s.AppInstId == userWithSameEmail.AppInstId);
                _dbContext.AppInstallations.RemoveRange(AppInstallations);
                _dbContext.SaveChanges();
            }
            var AppInstallationsObj = new AppInstallations
            {
                AppInstId       = Guid.NewGuid(),
                userId          = AppInstallations.userId,
                DeviceID        = AppInstallations.DeviceID,
                DeviceOS        = AppInstallations.DeviceOS,
                DeviceOSVersion = AppInstallations.DeviceOSVersion,
                DeviceModel     = AppInstallations.DeviceModel,
                DeviceNickName  = AppInstallations.DeviceNickName,
                InstallDate     = AppInstallations.InstallDate,
                InstallType     = AppInstallations.InstallType,
                LastAuthDate    = AppInstallations.LastAuthDate,
                AppVersion      = AppInstallations.AppVersion,
                RegId           = AppInstallations.RegId,
                MasterSyncReq   = AppInstallations.MasterSyncReq,
                InstStatus      = AppInstallations.InstStatus
            };

            _dbContext.AppInstallations.Add(AppInstallationsObj);
            await _dbContext.SaveChangesAsync();

            return(StatusCode(StatusCodes.Status201Created));
        }
示例#5
0
        public IActionResult Delete(string CityID)
        {
            var City = _dbContext.City.Where(s => s.CityID.ToString() == CityID);

            _dbContext.City.RemoveRange(City);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#6
0
        public IActionResult Delete(string OfferID)
        {
            var Offers = _dbContext.Offers.Where(s => s.OfferID.ToString() == OfferID);

            _dbContext.Offers.RemoveRange(Offers);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#7
0
        public IActionResult Delete(string RegionID)
        {
            var Region = _dbContext.Region.Where(s => s.RegionID.ToString() == RegionID);

            _dbContext.Region.RemoveRange(Region);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#8
0
        public IActionResult Delete(string SchoolID)
        {
            var Schools = _dbContext.Schools.Where(s => s.SchoolID.ToString() == SchoolID);

            _dbContext.Schools.RemoveRange(Schools);
            _dbContext.SaveChanges();
            return(Ok());
        }
        public IActionResult Delete(string VehicleID)
        {
            var DeliveryVehicles = _dbContext.DeliveryVehicles.Where(s => s.VehicleID.ToString() == VehicleID);

            _dbContext.DeliveryVehicles.RemoveRange(DeliveryVehicles);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#10
0
        public IActionResult Delete(string ItemAddOnID)
        {
            var ItemAddOns = _dbContext.ItemAddOns.Where(s => s.ItemAddOnID.ToString() == ItemAddOnID);

            _dbContext.ItemAddOns.RemoveRange(ItemAddOns);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#11
0
        public IActionResult Delete(string ADMINMastID)
        {
            var ADMINMast = _dbContext.ADMINMast.Where(s => s.AdminID.ToString() == ADMINMastID);

            _dbContext.ADMINMast.RemoveRange(ADMINMast);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#12
0
        public IActionResult Delete(string UserSubscriptionID)
        {
            var UserSubscriptions = _dbContext.UserSubscriptions.Where(s => s.UserSubscriptionID.ToString() == UserSubscriptionID);

            _dbContext.UserSubscriptions.RemoveRange(UserSubscriptions);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#13
0
        public IActionResult Delete(string vendorItemID)
        {
            var VendorItems = _dbContext.VendorItems.Where(s => s.vendorItemID.ToString() == vendorItemID);

            _dbContext.VendorItems.RemoveRange(VendorItems);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#14
0
        private static void ClearDatabase(FoodDbContext _context)
        {
            var productCategories = _context.Products.ToList();

            _context.Products.RemoveRange(productCategories);

            var productItems = _context.ProductItems.ToList();

            _context.ProductItems.RemoveRange(productItems);

            var orderItems = _context.OrderItems.ToList();

            _context.OrderItems.RemoveRange(orderItems);

            var orders = _context.Orders.ToList();

            _context.Orders.RemoveRange(orders);

            var customers = _context.Customers.ToList();

            _context.Customers.RemoveRange(customers);

            //var users = _context.Users.ToList();
            //var userRoles = _context.UserRoles.ToList();

            //foreach (var user in users)
            //{
            //    if (!userRoles.Any(r => r.UserId == user.Id))
            //    {
            //        _context.Users.Remove(user);
            //    }
            //}

            _context.SaveChanges();
        }
示例#15
0
        public void TestExample()
        {
            var dbOptions = new DbContextOptionsBuilder <FoodDbContext>()
                            .UseInMemoryDatabase(databaseName: "MyTestDatabase")
                            .Options;

            using (var context = new FoodDbContext(dbOptions))
            {
                context.FoodItems.Add(new FoodEntity()
                {
                    Id = 999, Calories = 1300, Type = "Starter", Name = "Pizza", Created = DateTime.Now
                });
                context.SaveChanges();

                var host = new WebHostBuilder()
                           .UseContentRoot(GetApplicationRoot())
                           .UseStartup <StartupFake>()
                           .ConfigureServices(services =>
                {
                    services.AddSingleton(context);
                });

                using (var server = new TestServer(host))
                {
                    var httpClient = server.CreateClient();

                    var response = httpClient.GetAsync("/api/v1/foods/999").Result;

                    response.EnsureSuccessStatusCode();
                }
            }
        }
示例#16
0
        public IActionResult Delete(string AdminRegionID)
        {
            var AdminRegions = _dbContext.AdminRegions.Where(s => s.AdminRegionID.ToString() == AdminRegionID);

            _dbContext.AdminRegions.RemoveRange(AdminRegions);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#17
0
        public IActionResult Delete(string DeliveryBoyID)
        {
            var DeliveryBoy = _dbContext.DeliveryBoys.Where(s => s.DeliveryBoyID.ToString() == DeliveryBoyID);

            _dbContext.DeliveryBoys.RemoveRange(DeliveryBoy);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#18
0
        public IActionResult Delete(string SubscriptionScheduleID)
        {
            var SubscriptionSchedule = _dbContext.SubscriptionSchedule.Where(s => s.SubSchID.ToString() == SubscriptionScheduleID);

            _dbContext.SubscriptionSchedule.RemoveRange(SubscriptionSchedule);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#19
0
        public IActionResult Delete(string ModeName)
        {
            var ModeTypes = _dbContext.ModeTypes.Where(s => s.ModeName.ToString() == ModeName);

            _dbContext.ModeTypes.RemoveRange(ModeTypes);
            _dbContext.SaveChanges();
            return(Ok());
        }
        public IActionResult Delete(string FamilyMemberDetailsID)
        {
            var FamilyMemberDetails = _dbContext.FamilyMemberDetails.Where(s => s.FamMembID.ToString() == FamilyMemberDetailsID);

            _dbContext.FamilyMemberDetails.RemoveRange(FamilyMemberDetails);
            _dbContext.SaveChanges();
            return(Ok());
        }
示例#21
0
        public async Task EnsureSeedData()
        {
            _context.Database.EnsureCreated();

            _context.Users.RemoveRange(_context.Users);
            _context.SaveChanges();

            if (_context.Users.Any())
            {
                return; // DB is seeded.
            }

            // Creates Roles.
            await _roleManager.CreateAsync(new IdentityRole("administrator"));

            await _roleManager.CreateAsync(new IdentityRole("user"));

            // Adds Roles to Role Claims.
            var adminRole = await _roleManager.FindByNameAsync("administrator");

            var userRole = await _roleManager.FindByNameAsync("user");

            await _roleManager.AddClaimAsync(adminRole, new Claim(JwtClaimTypes.Role, "administrator"));

            await _roleManager.AddClaimAsync(userRole, new Claim(JwtClaimTypes.Role, "user"));

            // Seeds an admin user.
            var user = new IdentityUser
            {
                AccessFailedCount  = 0,
                Email              = "*****@*****.**",
                EmailConfirmed     = false,
                LockoutEnabled     = true,
                NormalizedEmail    = "*****@*****.**",
                NormalizedUserName = "******",
                TwoFactorEnabled   = false,
                UserName           = "******"
            };

            var result = await _userManager.CreateAsync(user, "admin");

            if (result.Succeeded)
            {
                var adminUser = await _userManager.FindByNameAsync(user.UserName);

                // Assigns the 'administrator' role.
                await _userManager.AddToRoleAsync(adminUser, "administrator");

                // Assigns claims.
                var claims = new List <Claim> {
                    new Claim(type: JwtClaimTypes.Name, value: user.UserName),
                    new Claim(type: JwtClaimTypes.Email, value: user.Email),
                };
                await _userManager.AddClaimsAsync(adminUser, claims);
            }
        }
示例#22
0
        public ActionResult Create(Food food)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    db.Foods.Add(food);
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }
            }
            catch (RetryLimitExceededException /* dex */)
            {
                //Log the error (uncomment dex variable name and add a line here to write a log.)
                ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
            }

            return(View(food));
        }
示例#23
0
        public IActionResult Post([FromBody] Category category)
        {
            var stream   = new MemoryStream(category.ImageArray);
            var guid     = Guid.NewGuid().ToString();
            var file     = $"{guid}.jpg";
            var folder   = "wwwroot";
            var response = FilesHelper.UploadImage(stream, folder, file);

            if (!response)
            {
                return(BadRequest());
            }
            else
            {
                category.ImageUrl = file;
                _dbContext.Categories.Add(category);
                _dbContext.SaveChanges();
                return(StatusCode(StatusCodes.Status201Created));
            }
        }
示例#24
0
        public IActionResult Delete(int id)
        {
            var category = _dbContext.Categories.Find(id);

            if (category == null)
            {
                return(NotFound("No category found against this id..."));
            }
            else
            {
                _dbContext.Categories.Remove(category);
                _dbContext.SaveChanges();
                return(Ok("Category deleted..."));
            }
        }
示例#25
0
        public IActionResult Delete(int id)
        {
            var product = _dbContext.Products.Find(id);

            if (product == null)
            {
                return(NotFound("No product found against this id..."));
            }
            else
            {
                _dbContext.Products.Remove(product);
                _dbContext.SaveChanges();
                return(Ok("Product deleted..."));
            }
        }
示例#26
0
        private static void CreateAdminRole(FoodDbContext context, RoleManager <IdentityRole> _roleManager, UserManager <IdentityUser> _userManager)
        {
            bool roleExists = _roleManager.RoleExistsAsync("Admin").Result;

            if (roleExists)
            {
                return;
            }

            var role = new IdentityRole()
            {
                Name = "Admin"
            };

            _roleManager.CreateAsync(role).Wait();

            var userRole = new IdentityRole()
            {
                Name = "User"
            };

            _roleManager.CreateAsync(userRole).Wait();

            var user = new IdentityUser()
            {
                UserName = "******",
                Email    = "*****@*****.**"
            };

            string adminPassword = "******";
            var    userResult    = _userManager.CreateAsync(user, adminPassword).Result;

            if (userResult.Succeeded)
            {
                _userManager.AddToRoleAsync(user, "Admin").Wait();
            }

            context.SaveChanges();
        }
示例#27
0
 public int Commit()
 {
     return(db.SaveChanges());
 }
示例#28
0
 public int Add(Restaurant restaurant)
 {
     _dbContext.Restaurants.Add(restaurant);
     _dbContext.SaveChanges();
     return(restaurant.RestaurantId);
 }
示例#29
0
 public bool Save()
 {
     return(_foodDbContext.SaveChanges() >= 0);
 }
示例#30
0
        public async Task EnsureSeedData(UserManager <IdentityUser> userManager,
                                         RoleManager <IdentityRole> roleManager,
                                         ILoggerFactory loggerFactory,
                                         FoodDbContext context)
        {
            context.Database.EnsureCreated();

            context.Users.RemoveRange(context.Users);
            context.SaveChanges();

            if (context.Users.Any())
            {
                return; // Db has been seeded.
            }

            // Creates Roles.
            await roleManager.CreateAsync(new IdentityRole("administrator"));

            await roleManager.CreateAsync(new IdentityRole("user"));

            // Adds Roles to Role Claims.
            var adminRole = await roleManager.FindByNameAsync("administrator");

            var userRole = await roleManager.FindByNameAsync("user");

            await roleManager.AddClaimAsync(adminRole, new Claim(JwtClaimTypes.Role, "administrator"));

            await roleManager.AddClaimAsync(userRole, new Claim(JwtClaimTypes.Role, "user"));

            // Seeds an admin user.
            var user = new IdentityUser
            {
                AccessFailedCount  = 0,
                Email              = "*****@*****.**",
                EmailConfirmed     = false,
                LockoutEnabled     = true,
                NormalizedEmail    = "*****@*****.**",
                NormalizedUserName = "******",
                TwoFactorEnabled   = false,
                UserName           = "******"
            };

            var result = await userManager.CreateAsync(user, "admin");

            if (result.Succeeded)
            {
                var adminUser = await userManager.FindByNameAsync(user.UserName);

                // Assigns the 'administrator' role.
                await userManager.AddToRoleAsync(adminUser, "administrator");

                // Assigns claims.
                var claims = new List <Claim> {
                    new Claim(type: JwtClaimTypes.Name, value: user.UserName),
                    new Claim(type: JwtClaimTypes.Email, value: user.Email),
                };
                await userManager.AddClaimsAsync(adminUser, claims);
            }

            context.FoodItems.Add(new FoodItem()
            {
                Calories = 1000, Name = "Lasagne", Created = DateTime.Now
            });
            context.FoodItems.Add(new FoodItem()
            {
                Calories = 1100, Name = "Hamburger", Created = DateTime.Now
            });
            context.FoodItems.Add(new FoodItem()
            {
                Calories = 1200, Name = "Spaghetti", Created = DateTime.Now
            });
            context.FoodItems.Add(new FoodItem()
            {
                Calories = 1300, Name = "Pizza", Created = DateTime.Now
            });
        }