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 Members
and
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!