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 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; }