public async Task <IActionResult> OnGetAsync()
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
if (DeleteListId != 0)
{
var q = await _context.ProductList.FirstOrDefaultAsync(q => q.ID == DeleteListId);
_context.ProductList.Remove(q);
await _context.SaveChangesAsync();
}
else if (DeleteGroupId != 0)
{
var q = await _context.UserGroup.FirstOrDefaultAsync(q => q.ID == DeleteGroupId);
_context.UserGroup.Remove(q);
await _context.SaveChangesAsync();
}
else if (DeleteFromGroupId != 0)
{
var q = await _context.Member.FirstOrDefaultAsync(q => q.ID == DeleteFromGroupId);
_context.Member.Remove(q);
await _context.SaveChangesAsync();
}
if (userId != null)
{
List <ProductList> pList = new List <ProductList>();
var q = _context.Member.Where(q => q.UserId == userId).ToList();
foreach (var member in q)
{
var x = _context.UserGroup.FirstOrDefault(x => x.ID == member.UserGroupId);
var y = _context.ProductList.FirstOrDefault(y => y.ID == x.ProductListId);
if (y != null)
{
pList.Add(y);
}
}
ListOfProductLists = pList;
}
ListOfAllProductLists = await _context.ProductList.ToListAsync();
ListOfUserGroups = await _context.UserGroup.ToListAsync();
ListOfGroupsMemberIn = await _context.Member.Where(q => q.UserId == userId).ToListAsync();
ListOfUserLists = await _context.ProductList.Where(l => l.CreatedByUserId == userId).ToListAsync();
ListOfCreatedUserGroups = await _context.UserGroup.Where(l => l.CreatedByUserId == userId).ToListAsync();
return(Page());
}
public async Task <IActionResult> OnGetAsync()
{
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
if (BoughtProductId != 0)
{
var p = _context.Product.FirstOrDefault(p => p.ID == BoughtProductId);
p.Bought = true;
SelectedListId = p.ProductListId;
GetListProducts();
await _context.SaveChangesAsync();
}
else if (DeleteProductId != 0)
{
var p = _context.Product.FirstOrDefault(p => p.ID == DeleteProductId);
SelectedListId = p.ProductListId;
_context.Product.Remove(p);
await _context.SaveChangesAsync();
GetListProducts();
}
// GET SPECIFIC USER LISTS
if (userId != null)
{
List <ProductList> pList = new List <ProductList>();
var q = _context.Member.Where(q => q.UserId == userId).ToList();
foreach (var member in q)
{
var x = _context.UserGroup.FirstOrDefault(x => x.ID == member.UserGroupId);
var y = _context.ProductList.FirstOrDefault(y => y.ID == x.ProductListId);
if (y != null)
{
pList.Add(y);
}
}
ListOfProductLists = pList;
}
return(Page());
}