/// <summary>
/// Updates a school class in the database
/// </summary>
/// <param name="schoolClass">
/// School class to update
/// </param>
/// <returns>
/// Returns a bool indicating success or notdd
/// </returns>
public bool UpdateSchoolClass(SchoolClassModels schoolClass)
{
_context.Entry(schoolClass).State = EntityState.Modified;
_context.SaveChanges();
return(_context.SchoolClasses.Where(o => o.SchoolClassID == schoolClass.SchoolClassID).Any());
}
/// <summary>
/// Adds a new school class to the database
/// </summary>
/// <param name="model">
/// The school class
/// </param>
/// <returns>
/// Returns a bool value indicating success or not
/// </returns>
public async Task <bool> CreateNewSchoolClassAsync(SchoolClassModels model)
{
_context.SchoolClasses.Add(model);
await _context.SaveChangesAsync();
return(_context.SchoolClasses.Where(o => o.Name == model.Name).Any());
}
/// <summary>
/// Removes a school class from the database
/// </summary>
/// <param name="schoolClass">
/// School class to remove
/// </param>
/// <returns>
/// Returns a bool indicating success or not
/// </returns>
public async Task <bool> RemoveSchoolClassByIdAsync(SchoolClassModels schoolClass)
{
SchoolClassModels c = await _context.SchoolClasses.SingleAsync(o => o.SchoolClassID == schoolClass.SchoolClassID);
_context.SchoolClasses.Remove(c);
await _context.SaveChangesAsync();
return(!(_context.SchoolClasses.Where(o => o.SchoolClassID == schoolClass.SchoolClassID).Any()));
}
public async Task <ActionResult> RemoveSchoolClass(SchoolClassModels schoolClass)
{
bool isRemoved = await _repo.RemoveSchoolClassByIdAsync(schoolClass);
if (isRemoved)
{
return(new HttpStatusCodeResult(HttpStatusCode.OK, "School class successfully removed"));
}
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Could not remove school class"));
}
public ActionResult UpdateSchoolClass(SchoolClassModels schoolClass)
{
bool isUpdated = _repo.UpdateSchoolClass(schoolClass);
if (isUpdated)
{
return(new HttpStatusCodeResult(HttpStatusCode.OK, "School class successfully updated"));
}
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Could not update school class"));
}
//[HttpPost]
private void RemoveStudentsFromSchoolClass(string SchoolClassId, string[] StudentsSSN)
{
SchoolClassModels SchoolClass = _context.SchoolClasses.SingleOrDefault(sc => sc.SchoolClassID == SchoolClassId);
//Tar bort en student i skolklass
foreach (string ssn in StudentsSSN)
{
ApplicationUser student = _context.Users.SingleOrDefault(s => s.SSN == ssn);
SchoolClass.Students.Remove(student);
}
_context.Entry(SchoolClass).State = EntityState.Modified;
_context.SaveChanges();
}
public async Task <ActionResult> CreateNewSchoolClass(SchoolClassModels model)
{
if (ModelState.IsValid)
{
bool isCreated = await _repo.CreateNewSchoolClassAsync(model);
if (isCreated)
{
return(new HttpStatusCodeResult(HttpStatusCode.OK, "New school class created"));
}
}
return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Could not create new school class"));
}
//[HttpPost]
public void AddStudentsToSchoolClass(string SchoolClassId, string[] StudentsSSN)
{
List <ApplicationUser> studentsInClass = new List <ApplicationUser>();
SchoolClassModels SchoolClass = _context.SchoolClasses.SingleOrDefault(sc => sc.SchoolClassID == SchoolClassId);
//Lägger till student i skolklass
foreach (string ssn in StudentsSSN)
{
ApplicationUser student = _context.Users.SingleOrDefault(s => s.SSN == ssn);
SchoolClass.Students.Add(student);
}
_context.Entry(SchoolClass).State = EntityState.Modified;
_context.SaveChanges();
//ViewBag.SchoolClasses = new SelectList(schoolClasses, "SchoolClassID", "SchoolClassID");
//ViewBag.SchoolClassStudents = new SelectList(schoolClassStudents, "Id", "Lastname");
//ViewBag.Students = new SelectList(studentsInClass, "Id", "Lastname");
//return View();
}
protected override void Seed(ApplicationDbContext context)
{
// Create handlers //
var UserStore = new UserStore <ApplicationUser>(context);
var UserManager = new UserManager <ApplicationUser>(UserStore);
//Create schoolclass
var TempSchoolClass = new SchoolClassModels()
{
SchoolClassID = "1", Name = "SchoolClass 9a", Students = new List <ApplicationUser>()
};
context.SchoolClasses.Add(TempSchoolClass);
context.SaveChanges();
// Create a temp user //
var TmpUser = new ApplicationUser()
{
UserName = "******", Email = "*****@*****.**", PhoneNumber = "0701234567",
Firstname = "Test", Lastname = "User", ProfileImage = null, SSN = "185201052663",
SchoolClassModelId = TempSchoolClass.SchoolClassID
};
var TmpUser2 = new ApplicationUser()
{
UserName = "******",
Email = "*****@*****.**",
PhoneNumber = "0701234567",
Firstname = "Test2",
Lastname = "User",
ProfileImage = null,
SSN = "185201052663",
//SchoolClassModelId = TempSchoolClass.SchoolClassID
};
// Set password for user 'TmpUser' to 'Test@123' //
UserManager.Create(TmpUser, "Test@123");
UserManager.Create(TmpUser2, "Test@123");
// Create roll Teacher //
if (!context.Roles.Any(o => o.Name == "Teacher"))
{
var RoleStore = new RoleStore <IdentityRole>(context);
var RoleManager = new RoleManager <IdentityRole>(RoleStore);
var Role = new IdentityRole()
{
Name = "Teacher"
};
RoleManager.Create(Role);
}
// Create roll Student //
if (!context.Roles.Any(o => o.Name == "Student"))
{
var RoleStore = new RoleStore <IdentityRole>(context);
var RoleManager = new RoleManager <IdentityRole>(RoleStore);
var Role = new IdentityRole()
{
Name = "Student"
};
RoleManager.Create(Role);
}
// Set temp user role to teacher //
UserManager.AddToRole(TmpUser.Id, "Student");
UserManager.AddToRole(TmpUser2.Id, "Student");
// Save all changes //
context.SaveChanges();
}
