public ActionResult SaveCourse(Course course)
{
try
{
// grab course from DB
using (var context = new SWC_LMSEntities())
{
var dbCourse = context.Courses.FirstOrDefault(x => x.CourseId == course.CourseId);
// update course with incoming view model
dbCourse.CourseId = course.CourseId;
dbCourse.CourseName = course.CourseName;
dbCourse.CourseDescription = course.CourseDescription;
context.SaveChanges();
ViewBag.Message = "Save successful";
}
}
catch (Exception)
{
ViewBag.Message = "Error saving user.";
// throw;
}
return View("UserDetails", course);
}
public static string GetId(string email)
{
using (var db = new SWC_LMSEntities())
{
var results = db.GetGUID(email).FirstOrDefault();
return results;
}
}
public static List<AspNetRole> GetAllRoles()
{
using (var db = new SWC_LMSEntities())
{
var roles = db.AspNetRoles; // from r in db.AspNetRoles select r; // db.AspNetRoles.ToList();
return roles.OrderBy(r => r.Name).ToList();
}
}
public static List<LmsUserSelectUnassignedResult> LmsUserSelectUnassigned()
{
using (var db = new SWC_LMSEntities())
{
var results = db.LmsUserSelectUnassigned().FirstOrDefault();
return LmsUserSelectUnassigned();
}
}
public static void InsertNewUserToAspNetUserRoles(LmsUserViewModel reg, string id)
{
using (var db = new SWC_LMSEntities())
{
var output = new ObjectParameter("UserId", typeof(int));
db.InsertToAspNetUserRoles(reg.UserId.ToString(), reg.Roles.ToString());
}
}
public static void InsertNewUserToDb(RegisterViewModel reg, string id)
{
using (var db = new SWC_LMSEntities())
{
var output = new ObjectParameter("UserId", typeof(int));
db.LmsUserInsert(id, reg.Fname, reg.Lname, reg.Email,
reg.GradeLevelId, reg.SuggestedRole, output);
}
}
public static LmsUser GetUserWithRoles(int id)
{
using (var db = new SWC_LMSEntities())
{
var dbUser = db.LmsUsers.FirstOrDefault(x => x.UserId == id);
// dbUser.Roles =
}
return null;
}
// public static void AddCourse(CourseViewModel course)
// {
// SWC_LMSEntities context = new SWC_LMSEntities();
// {
// var startDate = DateTime.Parse(course.StartDate);
// var endDate = DateTime.Parse(course.EndDate);
// context.AddCourse(course.CourseId, course.SubjectId, course.CourseName, course.CourseDescription, course.IsArchived, startDate, endDate);
//context.SaveChanges();
// }
// }
public static void EditCourse(CourseViewModel course)
{
SWC_LMSEntities context = new SWC_LMSEntities();
{
Course newCourse = new Course();
newCourse.CourseName = "Test Info";
newCourse.CourseDescription = "Test Info Desc";
newCourse.StartDate = DateTime.Now;
newCourse.EndDate = DateTime.Now;
context.Courses.Add(newCourse);
context.SaveChanges();
}
}
public ActionResult SaveUserDetails(LmsUserViewModel user)
{
try
{
// grab user from DB
using (var context = new SWC_LMSEntities())
{
var dbUser = context.LmsUsers.FirstOrDefault(x => x.UserId == user.UserId);
// update user with incoming view model
dbUser.FirstName = user.FirstName;
dbUser.LastName = user.LastName;
dbUser.GradeLevelId = user.GradeLevelId;
dbUser.IsApproved = user.IsApproved;
//the following was an attempt to activate the stored procedure
//to input this user's unique ID into the AspNetUserRoles table on DB.
if (dbUser.SuggestedRole == "Administrator"){
var idToPass = dbUser.Email;
TheOneRepo.InsertUserToAdmin(idToPass);
}
else if (dbUser.SuggestedRole == "Teacher")
{
var idToPass = dbUser.Email;
TheOneRepo.InsertUserToTeacher(idToPass);
}
else if (dbUser.SuggestedRole == "Student")
{
var idToPass = dbUser.Email;
TheOneRepo.InsertUserToStudent(idToPass);
}
else if (dbUser.SuggestedRole == "Parent")
{
var idToPass = dbUser.Email;
TheOneRepo.InsertUserToParent(idToPass);
}
//THIS WORKS
// TODO ROLEs...
// save user
context.SaveChanges();
ViewBag.Message = "Save successful";
}
}
catch (Exception)
{
ViewBag.Message = "Error saving user.";
// throw;
}
return View("UserDetails", user);
}
public ActionResult UserDetails(int? UserId)
{
if (UserId.HasValue)
{
LmsUserViewModel user = null;
using (var context = new SWC_LMSEntities())
{
var dbUser = context.LmsUsers.FirstOrDefault(x => x.UserId == UserId);
user = new LmsUserViewModel
{
FirstName = dbUser.FirstName,
LastName = dbUser.LastName,
UserId = dbUser.UserId,
GradeLevelId = dbUser.GradeLevelId,
IsApproved = dbUser.IsApproved ?? false
};
ViewBag.UserRoles = TheOneRepo.GetAllRoles();
}
return View(user);
}
ViewBag.Message = "Invalid User Id.";
return View(new LmsUserViewModel());
}
public static void InsertUserToTeacher(string email)
{
using (var db = new SWC_LMSEntities())
{
db.InsertUserToTeacherRole(email);
}
}
public static void InsertUserToStudent(string email)
{
using (var db = new SWC_LMSEntities())
{
db.InsertUserToStudentRole(email);
}
}
public List<LmsUser> Search(string firstName, string lastName, string eMail)
{
using (var context = new SWC_LMSEntities())
{
return
context.LmsUsers.Where(x => x.FirstName.ToUpper().Contains(firstName.ToUpper()) ||
x.LastName.ToUpper().Contains(lastName.ToUpper()) ||
x.Email.ToUpper().Contains(eMail.ToUpper())).ToList();
}
}
