i don't know how to create attendance table, taking and editing attendance table
What I have tried:
this is my model
public class Student
{
[Key]
public int StudentID { get; set; }
[Required(ErrorMessage="Student RollNo is required", AllowEmptyStrings=false)]
public string RollNo { get; set; }
[Required(ErrorMessage = "please insert Image ", AllowEmptyStrings = false)]
public string ImgName { get; set; }
[Required(ErrorMessage = "Major is required ", AllowEmptyStrings = false)]
public string Major { get; set; }
[Required(ErrorMessage = "Student Firstname is required* ", AllowEmptyStrings = false)]
public string Firstname { get; set; }
[Required(ErrorMessage = "Student Lastname is required* ", AllowEmptyStrings = false)]
public string Lastname { get; set; }
[Required(ErrorMessage = "Select Student Gender* ", AllowEmptyStrings = false)]
public string Gender { get; set; }
[Required(ErrorMessage = "Student Date of Birth is required* ", AllowEmptyStrings = false)]
public DateTime DOB { get; set; }
[Required(ErrorMessage = "Student EmailAddress is required* ", AllowEmptyStrings = false)]
public string EmailAddress { get; set; }
[Required(ErrorMessage = "Phone Numberis required* ", AllowEmptyStrings = false)]
public string PhoneNumber { get; set; }
[Required(ErrorMessage = "Student Nationality is required* ", AllowEmptyStrings = false)]
public string Nationality { get; set; }
[Required(ErrorMessage = "Student Start Studying Date is required* ", AllowEmptyStrings = false)]
public DateTime StartStudying { get; set; }
[Required(ErrorMessage = "Student Finish Studying Date is required* ", AllowEmptyStrings = false)]
public DateTime FinishStudying { get; set; }
}
public class Attendance
{
[Key]
public int AttendanceID { get; set; }
public byte Attend { get; set; }
public string Comments{ get; set; }
public string StudentComment { get; set; }
public virtual TimeTable TimeTable { get; set; }
}
public class Class
{
[Key]
public int ClassID { get; set; }
[ForeignKey("Student")]
public int StudentID { get; set; }
[Required(ErrorMessage = " Classcode is required ", AllowEmptyStrings = false)]
public string Classcode { get; set; }
[Required(ErrorMessage = " Classname is required ", AllowEmptyStrings = false)]
public string Classname{ get; set; }
public virtual Student Student { get; set; }
}
public class Course
{
[Key]
public int CourseID { get; set; }
[ForeignKey("Semester")]
public int SemesterID { get; set; }
[Required(ErrorMessage = " CourseCode is required ", AllowEmptyStrings = false)]
public string CourseCode { get; set; }
[Required(ErrorMessage = " CourseName is required ", AllowEmptyStrings = false)]
public string CourseName { get; set; }
[Required(ErrorMessage = " CreditUnit is required ", AllowEmptyStrings = false)]
public int CreditUnit {get; set;}
public virtual Semester Semester { get; set; }
}
public class Lecturer
{
[Key]
public int LecturerID { get; set; }
[ForeignKey("Course")]
public int CourseID { get; set; }
[Required(ErrorMessage = " Fullname is required ", AllowEmptyStrings = false)]
public string LecturerName { get; set; }
[Required(ErrorMessage = "please insert Image ", AllowEmptyStrings = false)]
public string ImgName { get; set; }
[Required(ErrorMessage = " PhoneNumber is required ", AllowEmptyStrings = false)]
public string PhoneNumber { get; set; }
[Required(ErrorMessage = " EmailAddress is required ", AllowEmptyStrings = false)]
public string EmailAddress { get; set; }
[Required(ErrorMessage = " Start Working Date is required* ", AllowEmptyStrings = false)]
public DateTime StartWorking { get; set; }
public virtual Course Course { get; set; }
}
public class Semester
{
[Key]
public int SemesterID { get; set; }
[ForeignKey("Class")]
public int ClassID { get; set; }
[Required(ErrorMessage = " SemesterName is required ", AllowEmptyStrings = false)]
public string SemesterName { get; set; }
public int SemesterNumber { get; set; }
public DateTime StartDate { get; set; }
public DateTime EndDate { get; set; }
public virtual Class Class { get; set; }
}
public class TimeTable
{
[Key]
public int TimeTableID { get; set; }
[ForeignKey("Lecturer")]
public int LecturerID { get; set; }
public string RoomName { get; set;}
public string Slot { get; set;}
public string Day { get; set;}
public virtual Lecturer Lecturer { get; set; }
}
public class SAMSforms
{
public Student Student { get; set; }
public Class Class { get; set; }
public Semester Semester { get; set; }
public Course Course { get; set; }
public Lecturer Lecturer { get; set; }
public TimeTable TimeTable { get; set; }
public Attendance Attendance { get; set; }
}
public class ListSAMS
{
public List<student> Student { get; set; }
public List<class> Class { get; set; }
public List<semester> Semester { get; set; }
public List<course> Course { get; set; }
public List<lecturer> Lecturer { get; set; }
public List<timetable> TimeTable { get; set; }
public List<attendance> Attendance { get; set; }
}
public class StudentAttendancesTable
{
[Key]
public string StudentAttendancesTableID { get; set; }
public string RollNo { get; set; }
public string Major { get; set; }
public string SemesterName { get; set; }
public int SemesterNumber { get; set; }
public string Classcode { get; set; }
public string CourseCode { get; set; }
public string LecturerName { get; set; }
public byte Attend { get; set; }
public string Comments { get; set; }
public string StudentComment { get; set; }
public virtual Student Student { get; set; }
public virtual Semester Semester { get; set; }
public virtual Course Course { get; set; }
public virtual Class Class { get; set; }
public virtual Lecturer Lecturer { get; set; }
}