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