Click here to Skip to main content
15,891,184 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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; }


}
Posted
Comments
[no name] 15-Mar-16 0:54am    
Please describe your requirement what you need exactly?
Ib Koji Phong 15-Mar-16 1:10am    
i need to create view to add student to class and then view take attendance(present, absent and leave radio button)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900