public Product DeleteProduct(int productID)
{
Product dbEntry = context.Products.Find(productID);
if (dbEntry != null)
{
context.Products.Remove(dbEntry);
context.SaveChanges();
}
return(dbEntry);
}
public void SaveProduct(Product product)
{
if (product.ProductID == 0)
{
context.Products.Add(product);
}
else
{
Product dbEntry = context.Products.Find(product.ProductID);
if (dbEntry != null)
{
dbEntry.Name = product.Name;
dbEntry.Description = product.Description;
dbEntry.Price = product.Price;
dbEntry.Category = product.Category;
dbEntry.ImageData = product.ImageData;
dbEntry.ImageMimeType = product.ImageMimeType;
}
}
context.SaveChanges();
}
public ActionResult Create(Product product)
{
try
{
using (var context = new SportsStoreContext())
{
context.Products.Add(product);
context.SaveChanges();
}
return(RedirectToAction("List"));
}
catch
{
return(View());
}
}
public static void UpdateListPermissions()
{
SportsStoreContext db = new SportsStoreContext();
Assembly asm = Assembly.GetExecutingAssembly();
var permissions = (from type in asm.GetTypes()
where typeof(Controller).IsAssignableFrom(type)
from method in type.GetMethods()
where method.IsDefined(typeof(AuthorizePermissionAttribute))
select new Permission()
{
Name = type.ToString() + method.Name,
Description = method.GetCustomAttribute <AuthorizePermissionAttribute>().Description
}).ToList();
foreach (var dbPermission in db.Permissions)
{
var newPermission = permissions.FirstOrDefault(attributePermission =>
dbPermission.Name.Contains(attributePermission.Name) &&
attributePermission.Description == dbPermission.Description);
if (newPermission == null)
{
//Update the current permissions
dbPermission.Description = newPermission.Description;
permissions.Remove(newPermission);
}
else
{
//Removes unused permission
db.Permissions.Remove(dbPermission);
}
}
foreach (var permission in permissions)
{
db.Permissions.Add(permission);
}
db.SaveChanges();
}
public static void EnsurePopulated(IApplicationBuilder app)
{
SportsStoreContext context = app.ApplicationServices
.GetRequiredService <SportsStoreContext>();
var userManager = app.ApplicationServices
.GetRequiredService <UserManager <IdentityUser> >();
if (!context.Products.Any())
{
context.Products.AddRange(
new Product
{
Name = "Kayak",
Description = "A boat for one person",
Category = "Watersports",
Price = 275
},
new Product
{
Name = "Lifejacket",
Description = "Protective and fashionable",
Category = "Watersports",
Price = 48.95m
},
new Product
{
Name = "Soccer Ball",
Description = "FIFA-approved size and weight",
Category = "Soccer",
Price = 19.50m
},
new Product
{
Name = "Corner Flags",
Description = "Give your playing field a professional touch",
Category = "Soccer",
Price = 34.95m
},
new Product
{
Name = "Stadium",
Description = "Flat-packed 35,000-seat stadium",
Category = "Soccer",
Price = 79500
},
new Product
{
Name = "Thinking Cap",
Description = "Improve brain efficiency by 75%",
Category = "Chess",
Price = 16
},
new Product
{
Name = "Unsteady Chair",
Description = "Secretly give your opponent a disadvantage",
Category = "Chess",
Price = 29.95m
},
new Product
{
Name = "Human Chess Board",
Description = "A fun game for the family",
Category = "Chess",
Price = 75
},
new Product
{
Name = "Bling-Bling King",
Description = "Gold-plated, diamond-studded King",
Category = "Chess",
Price = 1200
}
);
context.SaveChanges();
}
if (userManager.FindByEmailAsync("*****@*****.**").GetAwaiter().GetResult() == null)
{
var user = new IdentityUser
{
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
LockoutEnabled = false
};
userManager.CreateAsync(user,
"Password@123").GetAwaiter().GetResult();
}
}