public void AddUserDetails(string username, string Phone, string Website, bool EmailConfirmed)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
int count = (from x in data.Students
where x.Username.Equals(username)
select x).Count();
if (count != 0)
{
Student s = data.Students.First(x => x.Username.Equals(username));
s.Mobile = Phone;
s.Website = Website;
s.EmailConfirmed = EmailConfirmed;
data.SaveChanges();
return;
}
count = (from x in data.Teachers
where x.Username.Equals(username)
select x).Count();
if (count != 0)
{
Teacher t = data.Teachers.First(x => x.Username.Equals(username));
t.Mobile = Phone;
t.Website = Website;
t.EmailConfirmed = EmailConfirmed;
data.SaveChanges();
}
}
}
public void SavePIN(string username, string PIN)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
int count = (from x in data.Students
where x.Username.Equals(username)
select x).Count();
if (count != 0)
{
data.Students.First(x => x.Username.Equals(username)).PasswordResetPIN = PIN;
data.SaveChanges();
}
else
{
count = (from x in data.Teachers
where x.Username.Equals(username)
select x).Count();
if (count != 0)
{
data.Teachers.First(x => x.Username.Equals(username)).PasswordResetPIN = PIN;
data.SaveChanges();
}
}
}
}
public void AddAssignment(Course course, Assignment assignment, List <AssignmentQuestion> questions)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Course c = data.Courses.Find(course.Id);
c.Assignments.Add(assignment);
data.SaveChanges();
foreach (AssignmentQuestion q in questions)
{
assignment.Questions.Add(q);
}
data.SaveChanges();
}
}
public void AddQiuz(Course course, Quiz quiz, List <QuizQuestion> questions)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Course c = data.Courses.Find(course.Id);
c.Quizzes.Add(quiz);
data.SaveChanges();
foreach (QuizQuestion q in questions)
{
quiz.Questions.Add(q);
}
data.SaveChanges();
}
}
public void AddTeacher(Teacher teacher)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
data.Teachers.Add(teacher);
data.SaveChanges();
}
}
public void SaveDiscussion(int cid, Discussion discussion)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Course c = data.Courses.Find(cid);
c.Discussions.Add(discussion);
data.SaveChanges();
}
}
public void ChangePassword(int sId, string Password)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Student s = data.Students.Find(sId);
s.Password = Password;
data.SaveChanges();
}
}
public void ChangePassword(int tId, string Password)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Teacher t = data.Teachers.Find(tId);
t.Password = Password;
data.SaveChanges();
}
}
public void MakeAnnouncement(int cid, Announcement announcement)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Course c = data.Courses.Find(cid);
c.Announcements.Add(announcement);
data.SaveChanges();
}
}
public void AddComment(int did, DiscussionComment comment)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Discussion d = data.Discussions.Find(did);
d.Comments.Add(comment);
data.SaveChanges();
}
}
public void AddStudentByEmail(string Email)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Student s = new Student {
Email = Email, EmailConfirmed = false
};
data.Students.Add(s);
data.SaveChanges();
}
}
public void AddCourse(string username, string title)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Course c = new Course();
c.Title = title;
c.Active = true;
data.Teachers.First(x => x.Username.Equals(username)).Courses.Add(c);
data.SaveChanges();
}
}
public void SetActive(int id, bool active)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Course c = data.Courses.Find(id);
if (c != null)
{
c.Active = active;
data.SaveChanges();
}
}
}
public void ChangePassword(string username, string Password)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
int count = (from x in data.Students
where x.Username.Equals(username)
select x).Count();
if (count != 0)
{
data.Students.First(x => x.Username.Equals(username)).Password = Password;
data.SaveChanges();
return;
}
count = (from x in data.Teachers
where x.Username.Equals(username)
select x).Count();
if (count != 0)
{
data.Teachers.First(x => x.Username.Equals(username)).Password = Password;
data.SaveChanges();
}
}
}
public void SaveEmailConfirmationPIN(string Email, string PIN)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
int count = (from x in data.Students
where x.Email.Equals(Email)
select x).Count();
if (count != 0)
{
data.Students.First(x => x.Email.Equals(Email)).EmailConfirmationPIN = PIN;
data.SaveChanges();
}
}
}
public void SaveQuizSolution(int quizId, int studentId, List <QuizQuestionSolution> solutions)
{
if (!DoesSolutionExist(quizId, studentId))
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
int correct = 0, attempted = 0, marks = 0;
for (int i = 0; i < solutions.Count; i++)
{
QuizQuestion ques = data.QuizQuestions.Find(solutions[i].QuizQuestionId);
if (solutions[i].SelectedOption != 0)
{
attempted++;
}
solutions[i].IsCorrect = (ques.CorrectOption == solutions[i].SelectedOption);
if (solutions[i].IsCorrect)
{
correct++;
marks += ques.Marks;
}
}
QuizSolution solution = new QuizSolution();
solution.StudentId = studentId;
solution.QuizId = quizId;
solution.Correct = correct;
solution.Attempted = attempted;
solution.Marks = marks;
data.QuizSolutions.Add(solution);
data.SaveChanges();
foreach (var s in solutions)
{
solution.QuestionSolutions.Add(s);
}
data.SaveChanges();
}
}
}
public void EnrollStudent(string Email, int cid)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
Course c = data.Courses.Find(cid);
int count = (from x in c.Students
where x.Email.Equals(Email)
select x).Count();
if (count == 0)
{
c.Students.Add(data.Students.First(x => x.Email.Equals(Email)));
data.SaveChanges();
}
}
}
public void SaveStudentData(string Email, Student s)
{
using (VCDataModelContainer data = new VCDataModelContainer())
{
int count = (from x in data.Students
where x.Email.Equals(Email)
select x).Count();
if (count != 0)
{
Student s1 = data.Students.First(x => x.Email.Equals(Email));
s1.EmailConfirmationPIN = "";
s1.EmailConfirmed = s.EmailConfirmed;
s1.FirstName = s.FirstName;
s1.Gender = s.Gender;
s1.LastName = s.LastName;
s1.Mobile = s.Mobile;
s1.Password = s.Password;
s1.Username = s.Username;
s1.Website = s.Website;
data.SaveChanges();
}
}
}