public static List<AddStudentSearchModel> AddStudentSearch(string lastName, int gradeLevelKey)
{
using (var db = new SWC_LMSEntities())
{
var results =
from l in db.LmsUsers
join g in db.GradeLevels
on l.GradeLevelId equals g.GradeLevelId
select new
{
l.FirstName,
l.LastName,
l.GradeLevelId,
g.GradeLevelName
};
var modelList = new List<AddStudentSearchModel>();
foreach (var x in results)
{
var model = new AddStudentSearchModel
{
FirstName = x.FirstName,
LastName = x.LastName,
GradeLevelKey = Convert.ToInt32(x.GradeLevelId),
GradeLevelName = x.GradeLevelName
};
modelList.Add(model);
}
return modelList.Where(x => x.LastName.ToUpper().Contains(lastName.ToUpper()) ||
x.GradeLevelKey == gradeLevelKey).ToList();
}
}
public static List<string> GetUserRoles(int id)
{
var db = new SWC_LMSEntities();
var roles = db.LmsUserSelectRoleNames(id);
var userRoles = roles.TakeWhile(n => n != null);
return userRoles.ToList();
}
public ActionResult EditUser(LmsUser user)
{
var db = new SWC_LMSEntities();
db.UpdateUser(user.LastName, user.FirstName, user.SuggestedRole, user.UserId);
return RedirectToAction("AdminDashboard");
}
public static List <AddStudentSearchModel> AddStudentSearch(string lastName, int gradeLevelKey)
{
using (var db = new SWC_LMSEntities())
{
var results =
from l in db.LmsUsers
join g in db.GradeLevels
on l.GradeLevelId equals g.GradeLevelId
select new
{
l.FirstName,
l.LastName,
l.GradeLevelId,
g.GradeLevelName
};
var modelList = new List <AddStudentSearchModel>();
foreach (var x in results)
{
var model = new AddStudentSearchModel
{
FirstName = x.FirstName,
LastName = x.LastName,
GradeLevelKey = Convert.ToInt32(x.GradeLevelId),
GradeLevelName = x.GradeLevelName
};
modelList.Add(model);
}
return(modelList.Where(x => x.LastName.ToUpper().Contains(lastName.ToUpper()) ||
x.GradeLevelKey == gradeLevelKey).ToList());
}
}
public static List <LmsUserSelectCourseNameAndCurrentGrade_Result> GetCourseAndGrade(int userId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.LmsUserSelectCourseNameAndCurrentGrade(userId).ToList();
return(results);
}
}
public static int GetUserIdByEmail(string email)
{
var db = new SWC_LMSEntities();
var id = from l in db.LmsUsers
where l.Email == email
select l.UserId;
return id.FirstOrDefault();
}
GetAssignmentNamePercentageScoredAndLetterGrade(int userId, int courseId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.LmsUserAndCourseIdSelectGradesForCourse(userId, courseId).ToList();
return(results);
}
}
public static string GetId(string email)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetGuid(email).FirstOrDefault();
return(results);
}
}
public List <GetCourseInfo_Result> GetCourseInfo(int courseId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetCourseInfo(courseId).ToList();
return(results);
}
}
public int GetCurrentStudentCountInCourse(int courseId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetStudentsInCourse(courseId).Count();
return(results);
}
}
public static List<LmsUserAndCourseIdSelectGradesForCourse_Result> GetAssignmentNamePercentageScoredAndLetterGrade(int userId, int courseId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.LmsUserAndCourseIdSelectGradesForCourse(userId, courseId).ToList();
return results;
}
}
public string GetSubjectNameSproc(int subjectId)
{
using (var db = new SWC_LMSEntities())
{
var result = db.GetSubjectName(subjectId);
return(result.FirstOrDefault());
}
}
public static List <string> GetUserRoles(int id)
{
var db = new SWC_LMSEntities();
var roles = db.LmsUserSelectRoleNames(id);
var userRoles = roles.TakeWhile(n => n != null);
return(userRoles.ToList());
}
public ActionResult EditUser(LmsUser user)
{
var db = new SWC_LMSEntities();
db.UpdateUser(user.LastName, user.FirstName, user.SuggestedRole, user.UserId);
return(RedirectToAction("AdminDashboard"));
}
public List <GetCoursesByTeacherId_Result> GetClassesByTeacherId(int userId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetCoursesByTeacherId(userId).ToList();
return(results);
}
}
public static string GetId(string email)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetGuid(email).FirstOrDefault();
return results;
}
}
public static List<LmsUserSelectCourseNameAndCurrentGrade_Result> GetCourseAndGrade(int userId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.LmsUserSelectCourseNameAndCurrentGrade(userId).ToList();
return results;
}
}
public ActionResult AddAssignment(Assignment model)
{
using (var db = new SWC_LMSEntities())
{
db.Assignments.Add(model);
db.SaveChanges();
}
return RedirectToAction("CourseGradebook", "Teacher", new{courseId=model.CourseId});
}
public static void InsertNewUserToDb(RegisterViewModel rvm, string id)
{
using (var db = new SWC_LMSEntities())
{
var output = new ObjectParameter("UserId", typeof(int));
db.LmsUserInsert(id, rvm.FirstName, rvm.LastName, rvm.Email,
rvm.GradeLevel, rvm.Role, output);
}
}
public static string GetCourseNameByCourseId(int courseId)
{
var db = new SWC_LMSEntities();
var id = from c in db.Courses
where c.CourseId == courseId
select c.CourseName;
return id.FirstOrDefault();
}
public static int GetUserIdByEmail(string email)
{
var db = new SWC_LMSEntities();
var id = from l in db.LmsUsers
where l.Email == email
select l.UserId;
return(id.FirstOrDefault());
}
public static void InsertNewUserToDb(RegisterViewModel rvm, string id)
{
using (var db = new SWC_LMSEntities())
{
var output = new ObjectParameter("UserId", typeof(int));
db.LmsUserInsert(id, rvm.FirstName, rvm.LastName, rvm.Email,
rvm.GradeLevel, rvm.Role, output);
}
}
public static List <LmsUserSelectUnassigned_Result> LmsUserSelectUnassigned()
{
using (var db = new SWC_LMSEntities())
{
var userList = db.LmsUserSelectUnassigned().ToList();
return(userList);
}
}
public ActionResult AddAssignment(Assignment model)
{
using (var db = new SWC_LMSEntities())
{
db.Assignments.Add(model);
db.SaveChanges();
}
return(RedirectToAction("CourseGradebook", "Teacher", new{ courseId = model.CourseId }));
}
public static string GetCourseNameByCourseId(int courseId)
{
var db = new SWC_LMSEntities();
var id = from c in db.Courses
where c.CourseId == courseId
select c.CourseName;
return(id.FirstOrDefault());
}
public static List<AspNetRole> GetAllIdentityUserRoles()
{
var db = new SWC_LMSEntities();
List<AspNetRole> rolesList = new List<AspNetRole>();
foreach (var x in db.AspNetRoles)
{
rolesList.Add(x);
}
return rolesList;
}
public ActionResult DeleteFromRoster(int userId, int rosterId)
{
using (var db = new SWC_LMSEntities())
{
var result = db.Rosters.FirstOrDefault(x => x.UserId == userId && x.RosterId == rosterId);
if (result != null) result.IsDeleted = true;
db.SaveChanges();
return RedirectToAction("CourseRoster", "Teacher", new {courseId = result.CourseId});
}
}
public static List <AspNetRole> GetAllIdentityUserRoles()
{
var db = new SWC_LMSEntities();
List <AspNetRole> rolesList = new List <AspNetRole>();
foreach (var x in db.AspNetRoles)
{
rolesList.Add(x);
}
return(rolesList);
}
public ActionResult DeleteFromRoster(int userId, int rosterId)
{
using (var db = new SWC_LMSEntities())
{
var result = db.Rosters.FirstOrDefault(x => x.UserId == userId && x.RosterId == rosterId);
if (result != null)
{
result.IsDeleted = true;
}
db.SaveChanges();
return(RedirectToAction("CourseRoster", "Teacher", new { courseId = result.CourseId }));
}
}
public static int GetRosterId(int userId, int courseId)
{
var result = 0;
using (var db = new SWC_LMSEntities())
{
var firstOrDefault = db.Rosters.FirstOrDefault(x => x.UserId == userId && x.CourseId == courseId);
if (firstOrDefault != null)
{
result = firstOrDefault.RosterId;
}
}
return(result);
}
public ActionResult StudentDashboard(int id)
{
var db = new SWC_LMSEntities();
var student = new LmsUser();
var user = db.GetUserById(id);
foreach (var x in user)
{
student.FirstName = x.FirstName;
student.LastName = x.LastName;
student.UserId = x.UserId;
}
return View(student);
}
public ActionResult StudentDashboard(int id)
{
var db = new SWC_LMSEntities();
var student = new LmsUser();
var user = db.GetUserById(id);
foreach (var x in user)
{
student.FirstName = x.FirstName;
student.LastName = x.LastName;
student.UserId = x.UserId;
}
return(View(student));
}
public static List <GradebookModel> GetGradebookDataRepo(int courseId)
{
var db = new SWC_LMSEntities();
var gradebookData = from a in db.Assignments
join ra in db.RosterAssignments
on a.AssignmentId equals ra.AssignmentId
join r in db.Rosters
on ra.RosterId equals r.RosterId
join l in db.LmsUsers
on r.UserId equals l.UserId
where a.CourseId == courseId
select new
{
l.FirstName,
l.LastName,
ra.Grade,
ra.Percentage,
l.UserId,
a.AssignmentId,
a.PossiblePoints,
ra.PointsEarned,
a.CourseId,
a.AssignmentName
};
var modelList = new List <GradebookModel>();
foreach (var x in gradebookData)
{
GradebookModel model = new GradebookModel
{
FirstName = x.FirstName,
LastName = x.LastName,
Grade = x.Grade,
Percentage = Convert.ToDecimal(x.Percentage),
PointsEarned = Convert.ToDecimal(x.PointsEarned),
PossiblePoints = Convert.ToDecimal(x.PossiblePoints),
CourseId = x.CourseId,
UserId = x.UserId,
AssignmentId = x.AssignmentId,
AssignmentName = x.AssignmentName
};
modelList.Add(model);
}
return(modelList);
}
public static LmsUser GetLmsUserById(int id)
{
using (var db = new SWC_LMSEntities())
{
LmsUser newUser = new LmsUser();
var user = db.GetUserById(id);
foreach (var x in user)
{
newUser.UserId = x.UserId;
newUser.FirstName = x.FirstName;
newUser.LastName = x.LastName;
newUser.GradeLevelId = x.GradeLevelId;
newUser.SuggestedRole = x.SuggestedRole;
newUser.Id = x.Id;
newUser.Email = x.Email;
}
return(newUser);
}
}
public static LmsUser GetLmsUserById(int id)
{
using (var db = new SWC_LMSEntities())
{
LmsUser newUser = new LmsUser();
var user = db.GetUserById(id);
foreach (var x in user)
{
newUser.UserId = x.UserId;
newUser.FirstName = x.FirstName;
newUser.LastName = x.LastName;
newUser.GradeLevelId = x.GradeLevelId;
newUser.SuggestedRole = x.SuggestedRole;
newUser.Id = x.Id;
newUser.Email = x.Email;
}
return newUser;
}
}
public static List <StudentCourse> GetStudentCourses(int userId)
{
var db = new SWC_LMSEntities();
var courseList = new List <StudentCourse>();
var courses = from r in db.Rosters
where r.UserId == userId
select r;
foreach (var x in courses)
{
var c = new StudentCourse
{
CourseId = x.CourseId,
CurrentGrade = x.CurrentGrade,
CourseName = GetCourseNameByCourseId(x.CourseId)
};
courseList.Add(c);
}
return(courseList);
}
public static List<StudentCourse> GetStudentCourses(int userId)
{
var db = new SWC_LMSEntities();
var courseList = new List<StudentCourse>();
var courses = from r in db.Rosters
where r.UserId == userId
select r;
foreach (var x in courses)
{
var c = new StudentCourse
{
CourseId = x.CourseId,
CurrentGrade = x.CurrentGrade,
CourseName = GetCourseNameByCourseId(x.CourseId)
};
courseList.Add(c);
}
return courseList;
}
public static List <CourseRosterModel> GetCourseRosterData(int courseId)
{
var db = new SWC_LMSEntities();
var rosterData = from l in db.LmsUsers
join r in db.Rosters
on l.UserId equals r.UserId
join c in db.Courses
on r.CourseId equals c.CourseId
where r.CourseId == courseId && r.IsDeleted == false
select new
{
l.FirstName,
l.LastName,
l.Email,
r.CourseId,
c.CourseName,
l.UserId,
r.IsDeleted
};
var modelList = new List <CourseRosterModel>();
foreach (var x in rosterData)
{
var model = new CourseRosterModel
{
FirstName = x.FirstName,
LastName = x.LastName,
Email = x.Email,
CourseId = x.CourseId,
CourseName = x.CourseName,
UserId = x.UserId,
IsDeleted = x.IsDeleted
};
modelList.Add(model);
}
return(modelList);
}
public static List<CourseRosterModel> GetCourseRosterData(int courseId)
{
var db = new SWC_LMSEntities();
var rosterData = from l in db.LmsUsers
join r in db.Rosters
on l.UserId equals r.UserId
join c in db.Courses
on r.CourseId equals c.CourseId
where r.CourseId == courseId && r.IsDeleted == false
select new
{
l.FirstName,
l.LastName,
l.Email,
r.CourseId,
c.CourseName,
l.UserId,
r.IsDeleted
};
var modelList = new List<CourseRosterModel>();
foreach (var x in rosterData)
{
var model = new CourseRosterModel
{
FirstName = x.FirstName,
LastName = x.LastName,
Email = x.Email,
CourseId = x.CourseId,
CourseName = x.CourseName,
UserId = x.UserId,
IsDeleted = x.IsDeleted
};
modelList.Add(model);
}
return modelList;
}
public string GetSubjectNameSproc(int subjectId)
{
using (var db = new SWC_LMSEntities())
{
var result = db.GetSubjectName(subjectId);
return result.FirstOrDefault();
}
}
public static int GetRosterId(int userId, int courseId)
{
var result = 0;
using (var db = new SWC_LMSEntities())
{
var firstOrDefault = db.Rosters.FirstOrDefault(x => x.UserId == userId && x.CourseId == courseId);
if (firstOrDefault != null)
{
result = firstOrDefault.RosterId;
}
}
return result;
}
public int GetCurrentStudentCountInCourse(int courseId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetStudentsInCourse(courseId).Count();
return results;
}
}
public static List<LmsUserSelectUnassigned_Result> LmsUserSelectUnassigned()
{
using (var db = new SWC_LMSEntities())
{
var userList = db.LmsUserSelectUnassigned().ToList();
return userList;
}
}
public List<GetCourseInfo_Result> GetCourseInfo(int courseId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetCourseInfo(courseId).ToList();
return results;
}
}
public List<GetCoursesByTeacherId_Result> GetClassesByTeacherId(int userId)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetCoursesByTeacherId(userId).ToList();
return results;
}
}
public static List<GradebookModel> GetGradebookDataRepo(int courseId)
{
var db = new SWC_LMSEntities();
var gradebookData = from a in db.Assignments
join ra in db.RosterAssignments
on a.AssignmentId equals ra.AssignmentId
join r in db.Rosters
on ra.RosterId equals r.RosterId
join l in db.LmsUsers
on r.UserId equals l.UserId
where a.CourseId == courseId
select new
{
l.FirstName,
l.LastName,
ra.Grade,
ra.Percentage,
l.UserId,
a.AssignmentId,
a.PossiblePoints,
ra.PointsEarned,
a.CourseId,
a.AssignmentName
};
var modelList = new List<GradebookModel>();
foreach (var x in gradebookData)
{
GradebookModel model = new GradebookModel
{
FirstName = x.FirstName,
LastName = x.LastName,
Grade = x.Grade,
Percentage = Convert.ToDecimal(x.Percentage),
PointsEarned = Convert.ToDecimal(x.PointsEarned),
PossiblePoints = Convert.ToDecimal(x.PossiblePoints),
CourseId = x.CourseId,
UserId = x.UserId,
AssignmentId = x.AssignmentId,
AssignmentName = x.AssignmentName
};
modelList.Add(model);
}
return modelList;
}
