} //end function
public StudentSemester StudentSemesterSelectByID(int intSemesterID)
{
try
{
string sp_name = "StudentSemesterSelectByID";
comStudentSemester.Parameters.AddWithValue("SemesterID", intSemesterID);
ConnectAndExecute(sp_name); //no parameter will send to stored procedure
if (dsStudentSemester.Tables[0].Rows.Count == 1)
{
DataRow drStudentSemester = dsStudentSemester.Tables[0].Rows[0];
StudentSemester objStudentSemester = new StudentSemester();
objStudentSemester.SemesterID = Convert.ToInt64(drStudentSemester["SemesterID"]);
objStudentSemester.SemesterName = Convert.ToString(drStudentSemester["SemesterName"]);
objStudentSemester.AddByID = Convert.ToInt64(drStudentSemester["AddByID"]);
objStudentSemester.IsEnabled = Convert.ToBoolean(drStudentSemester["IsEnabled"]);
objStudentSemester.AddDateTime = Convert.ToDateTime(drStudentSemester["AddDateTime"]);
objStudentSemester.Remarks = Convert.ToString(drStudentSemester["Remarks"]);
objStudentSemester.LastUpdateID = Convert.ToInt64(drStudentSemester["LastUpdateID"]);
objStudentSemester.LastUpdateDateTime = Convert.ToDateTime(drStudentSemester["LastUpdateDateTime"]);
return(objStudentSemester);
}
return(null);
}
catch (Exception ex)
{
SetError(ex.Message);
return(null);
} //end try
} //end function
public async Task <bool> AddLectorAsync(int subjectId, int semesterId, string email)
{
var lector = this.userRepository
.All()
.FirstOrDefault(u => u.Email == email && u.Role == "Lector");
if (lector == null)
{
return(false);
}
var userSubject = new StudentSubject
{
StudentId = lector.Id,
SubjectId = subjectId,
};
await this.userSubjectRepository.AddAsync(userSubject);
await this.userSubjectRepository.SaveChangesAsync();
var userSemester = new StudentSemester
{
StudentId = lector.Id,
SemesterId = semesterId,
};
await this.userSemesterRepository.AddAsync(userSemester);
await this.userSemesterRepository.SaveChangesAsync();
return(true);
}
public async Task <StudentSemester> CreateStudentSemesterAsync(StudentSemester studentSemester)
{
await _smContext.AddAsync(studentSemester);
await _smContext.SaveChangesAsync();
return(studentSemester);
}
public async Task RegisterUserToSemesterAsync(string userId, int semesterId)
{
var userSemester = new StudentSemester
{
StudentId = userId,
SemesterId = semesterId,
};
await this.studentSemesterRepository.AddAsync(userSemester);
await this.studentSemesterRepository.SaveChangesAsync();
var student = await this.userRepository.All().FirstOrDefaultAsync(u => u.Id == userId);
student.SemesterNumber++;
await this.userRepository.SaveChangesAsync();
}
public async Task CreateAsync(int semesterId, string name, decimal price, string emails)
{
var subject = new Subject()
{
Name = name,
Price = price,
SemesterId = semesterId,
};
await this.subjectRepository.AddAsync(subject);
await this.subjectRepository.SaveChangesAsync();
if (emails != null)
{
var lectorsEmail = emails.Split().ToList();
foreach (var lectorEmail in lectorsEmail)
{
var lector = this.userRepository
.All()
.FirstOrDefault(l => l.Email == lectorEmail && l.Role == "Lector");
if (lector == null)
{
continue;
}
var lectorSubject = new StudentSubject
{
Student = lector,
Subject = subject,
};
await this.studentSubjectRepository.AddAsync(lectorSubject);
var lectorSemester = new StudentSemester
{
Student = lector,
SemesterId = semesterId,
};
await this.studentSemesterRepository.AddAsync(lectorSemester);
}
await this.studentSubjectRepository.SaveChangesAsync();
await this.studentSemesterRepository.SaveChangesAsync();
}
}
public async Task <IActionResult> AddStudentSemester(string submit, StudentSemesterViewModel viewModel)
{
var studentSemester = new StudentSemester
{
StudentId = viewModel.Id,
SemesterId = viewModel.SemesterId,
};
if (submit == "Add")
{
try
{
await context.AddAsync(studentSemester);
await context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (Exception)
{
if (viewModel.SemesterId == 0)
{
return(NotFound("Please select a semester!"));
}
var semester = context.Semesters.
Where(x => x.Id == viewModel.SemesterId)
.Select(s => s.SemesterName)
.FirstOrDefault();
return(NotFound($"This student has {semester}"));
}
}
try
{
context.Remove(studentSemester);
await context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
catch (Exception)
{
return(NotFound("The student doesn`t have such semester!"));
}
}
///////////////////////////////////////////////////////////////////////////////////////////
//Private Methods///////////////////////////////////////////////////////////////////////////
//DB to Model//
private void GenerateModelList()
{
StudentSemesterList.Clear();
foreach (DataRow drStudentSemester in dsStudentSemester.Tables[0].Rows)
{
StudentSemester objStudentSemester = new StudentSemester();
objStudentSemester.SemesterID = Convert.ToInt64(drStudentSemester["SemesterID"]);
objStudentSemester.SemesterName = Convert.ToString(drStudentSemester["SemesterName"]);
objStudentSemester.AddByID = Convert.ToInt64(drStudentSemester["AddByID"]);
objStudentSemester.IsEnabled = Convert.ToBoolean(drStudentSemester["IsEnabled"]);
objStudentSemester.AddDateTime = Convert.ToDateTime(drStudentSemester["AddDateTime"]);
objStudentSemester.Remarks = Convert.ToString(drStudentSemester["Remarks"]);
objStudentSemester.LastUpdateID = Convert.ToInt64(drStudentSemester["LastUpdateID"]);
objStudentSemester.LastUpdateDateTime = Convert.ToDateTime(drStudentSemester["LastUpdateDateTime"]);
StudentSemesterList.Add(objStudentSemester);
}
}
public static Int64 InsertUpdateStudentSemester(StudentSemester objIUStudentSemester)
{
Int64 new_id = objIUStudentSemester.InsertUpdateStudentSemester();
return(new_id);
}
public void AddFakeStudent()
{
_dbContext.Database.EnsureDeleted();
_dbContext.Database.EnsureCreated();
Teacher teacherAsma = new Teacher()
{
Name = "Asma Naveed"
};
Teacher teacherAqeel = new Teacher()
{
Name = "Muhammad Aqeel"
};
Semester sem6 = new Semester()
{
Season = "F",
Title = "Semester 6",
Year = 2020
};
Course hciCourse = new Course()
{
Code = "001",
Name = "Human Computer Interaction"
};
Course svvCourse = new Course()
{
Code = "002",
Name = "Software V&V"
};
Exam exam = new Exam()
{
Name = "Assignment#1",
Date = DateTime.Now,
TotalMarks = 10
};
Exam exam2 = new Exam()
{
Name = "Assignment#1",
Date = DateTime.Now,
TotalMarks = 10
};
var studentExams = new List <StudentExam>()
{
new StudentExam()
{
Exam = exam,
ObtainedMarks = 8,
},
new StudentExam()
{
Exam = exam,
ObtainedMarks = 9,
},
new StudentExam()
{
Exam = exam,
ObtainedMarks = 1,
},
new StudentExam()
{
Exam = exam,
ObtainedMarks = 3,
},
};
SemesterCourse hciSemesterCourse = new SemesterCourse()
{
Teacher = teacherAsma,
Course = hciCourse,
StudentExams = studentExams,
Attendances = GetRandomAttendances(200)
};
var studentExams2 = new List <StudentExam>();
studentExams2.Add(new StudentExam()
{
Exam = exam2, ObtainedMarks = 1
});
SemesterCourse svvSemesterCourse = new SemesterCourse()
{
Teacher = teacherAqeel,
Course = svvCourse,
StudentExams = studentExams2,
Attendances = GetRandomAttendances(200)
};
var studentSemester = new StudentSemester()
{
Semester = sem6,
Courses = new List <SemesterCourse>()
{
hciSemesterCourse,
svvSemesterCourse,
},
Description = "Fall 2020",
Title = "Semester #6",
Gpa = 3.8
};
var studentSemester2 = new StudentSemester()
{
Semester = sem6,
Courses = new List <SemesterCourse>(),
Description = "Fall 2019",
Title = "Semester #5",
Gpa = 3.7
};
var studentSemester3 = new StudentSemester()
{
Semester = sem6,
Courses = new List <SemesterCourse>(),
Description = "Fall 2019",
Title = "Semester #4",
Gpa = 3.6
};
Student newStudent = new Student
{
Email = "*****@*****.**",
Name = "Usama Bin Tariq",
RollNo = "053",
Password = "******",
Year = 17,
Program = "BCSE",
Season = "F",
Semesters = new List <StudentSemester>()
{
studentSemester,
studentSemester2,
studentSemester3
}
};
_dbContext.Students.Add(newStudent);
_dbContext.SaveChanges();
newStudent.CurrentSemester = studentSemester;
_dbContext.SaveChanges();
}
