.NET Core 2.1 MVC application to mark attendance

• Question

• 

  

  0

  Sign in to vote

  Hello!

  I'm posting a bunch of details to be as clear as I can be so bear with me.

  I've recently started learning .NET Core & MVC by following some courses on Microsoft Virtual Academy & PluralSight. At the same time I'm using what I'm learning to create an application to Capture Attendance.

  I have googled and found a bunch of awsome examples from github, however I have decied to build my own to make it suit my requirements and to learn this technology more!

  The name of the application is quite descriptive, I need an application where I can create Members, Events. Then at any time I would like to be able to create an Event containing all of my Membersand mark these as Present or Absent.

  A colleague helped me design the database using EntityFramework, take a look at my models and the tables created based on them:

  public class Members
  {
      public int Id { get; set; }
      [DataType(DataType.Text)]
      public string FirstName { get; set; }
      [DataType(DataType.Text)]
      public string LastName { get; set; }
      [DataType(DataType.Text)]
      public string FullName { get; set; }
      [DataType(DataType.Date)]
      public DateTime DateOfBirth { get; set; }
      [DataType(DataType.EmailAddress)]
      public string Email { get; set; }
      [DataType(DataType.PhoneNumber)]
      public string TelephoneNumber { get; set; }
      public List<MemberToEvents> MemberToEvents { get; set; }
  }

  public class Events
  {
      public int Id { get; set; }
      [DataType(DataType.Date)]
      public DateTime EventDate { get; set; }
      public List<MemberToEvents> MemberToEvents { get; set; }
  }

  public class MemberToEvents
  {
      public int Id { get; set; }
      public bool Status { get; set; }
      public Events Event { get; set; }
      public Members Member { get; set; }
  }

  After scaffolding and deploying I get my tables created exactly as planned:

  • dbo.MemberToEvents
  • dbo.Events
  • dbo.Members

  So far so good, I can now create/view/edit/delete Members and Events.

  Now, using some View(?), I'm looking for a way to capture attendance status for all my members for a specific Event (date) and save it to my MemberToEvents table.

  My little knowledge of this technology is not helping to figure out a solution. Could you please help?
  I'm not posting my not working code because I know it's far from being usable.

  Thanks in advance!

  • Moved by Wendy ZangMicrosoft contingent staff Friday, March 22, 2019 8:52 AM related to MVC

  Wednesday, March 20, 2019 2:19 PM