public async Task <IActionResult> BookClass(int id)
{
List <MemberClassViewModel> memberClassViewModel = new List <MemberClassViewModel>();
var classlist = _context.Classes.OrderBy(c => c.ClassName).Select(x => new { Id = x.Id, Value = x.ClassName });
var listData = await(_context.Classes.Select(x =>
new
{
x.Id,
x.ClassName,
}
).ToListAsync());
//var listData = await
//(from Classes in _context.Classes join classesbooked in _context.ClassesBooked on Classes.Id equals classesbooked.ClassID
// select new
// {
// Classes.Id,
// Classes.ClassName,
// classesbooked.MemberID
// }
// ).ToListAsync();
listData.ForEach
(x =>
{
MemberClassViewModel Obj = new MemberClassViewModel();
Obj.ClassID = x.Id;
Obj.MemberID = id;
Obj.ClassName = x.ClassName;
//Obj.ClassName = new Microsoft.AspNetCore.Mvc.Rendering.SelectList(classlist, "Id", "Value");
memberClassViewModel.Add(Obj);
}
);
return(View(memberClassViewModel));
}
public async Task <IActionResult> CancelClass(int id)
{
//
List <MemberClassViewModel> memberClassViewModel = new List <MemberClassViewModel>(); //declared my VIewModel instance
var listData = await(from classessbooked in _context.ClassesBooked
join classes in _context.Classes on classessbooked.ClassID equals classes.Id
where (classessbooked.MemberID == id)
select new MemberClassViewModel
{
ClassID = classessbooked.Id,
ClassName = classes.ClassName,
MemberID = id
}
).ToListAsync();
//listData.First().MemberIDs = (from member in _context.Members
// join classesbooked in _context.ClassesBooked on member.Id equals classesbooked.MemberID
// where id == classesbooked.ClassID
// select new { member.Id })
// .Select(x => x.Id).ToList();
listData.ForEach(x =>
{
MemberClassViewModel Obj = new MemberClassViewModel();
Obj.ClassID = x.ClassID;
Obj.ClassName = x.ClassName;
Obj.MemberID = x.MemberID;
memberClassViewModel.Add(Obj);
}
);
return(View(memberClassViewModel));
}
