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