C# Pastebin - Nopaste - Paste - easy sharing of text and codes

Posted by b on Thu 2nd Sep 11:48 (modification of post by view diff)
download | new post

  1. public class EventViewModel
  2.     {
  3.         public Event Event { get; set; }
  4.         public List<Lookup> Types { get; set; }
  5.         public List<Lookup> Statuses { get; set; }
  6.         public List<Member> EventOrganisers { get; set; }
  7.         public List<Club> Clubs { get; set; }
  8.  
  9.         public void PopulateLookups()
  10.         {
  11.             MMDBEntities mmdb = new MMDBEntities();
  12.  
  13.             Types = mmdb.Lookups.Where(l => l.Type == "EventType").OrderBy(l => l.Order).ToList();
  14.  
  15.             Statuses = mmdb.Lookups.Where(l => l.Type == "EventStatus").OrderBy(l => l.Order).ToList();
  16.  
  17.             Clubs = mmdb.Clubs.OrderBy(c => c.Name).ToList();
  18.  
  19.             var members = from member in mmdb.Members
  20.                           join role in mmdb.Roles on member.MemberId equals role.MemberId
  21.                           where role.Value.Contains("Event Organiser")
  22.                           select member;
  23.  
  24.             EventOrganisers = members.ToList();
  25.         }
  26.     }
  27.  
  28. > Want the equivalent of
  29.  
  30. public class EventViewModel
  31.     {
  32.         public Event Event { get; set; }
  33.         public List<Lookup> Types { get; set; }
  34.         public List<Lookup> Statuses { get; set; }
  35.         public List<???> EventOrganisers { get; set; }
  36.         public List<Club> Clubs { get; set; }
  37.  
  38.         public void PopulateLookups()
  39.         {
  40.             MMDBEntities mmdb = new MMDBEntities();
  41.  
  42.             Types = mmdb.Lookups.Where(l => l.Type == "EventType").OrderBy(l => l.Order).ToList();
  43.  
  44.             Statuses = mmdb.Lookups.Where(l => l.Type == "EventStatus").OrderBy(l => l.Order).ToList();
  45.  
  46.             Clubs = mmdb.Clubs.OrderBy(c => c.Name).ToList();
  47.  
  48.             var members = from member in mmdb.Members
  49.                           join role in mmdb.Roles on member.MemberId equals role.MemberId
  50.                           where role.Value.Contains("Event Organiser")
  51.                           select member.MemberId, member.Field1 + member.Field2;
  52.  
  53.             EventOrganisers = members.ToList();
  54.         }
  55.     }

Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.

Syntax highlighting:

To highlight particular lines, prefix each line with @@


I'm Human
Remember me



Captcha required for posting