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)); }