public ActionResult Create([Bind(Include = "ID,CourseName,CategoryID")] Course course) { if (ModelState.IsValid) { db.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "ID", "CategoryName", course.CategoryID); return(View(course)); }
public override void AddUsersToRoles(string[] usernames, string[] roleNames) { if (usernames.Any(un => String.IsNullOrWhiteSpace(un))) { throw new ArgumentException("Usernames cannot contain username that is null, empty string or whitespace"); } if (roleNames.Any(rn => String.IsNullOrWhiteSpace(rn))) { throw new ArgumentException("RoleName cannot contain role name that is null, empty string or whitespace"); } using (var db = new MysenseiEntities()) { var users = db.Users.Where(u => usernames.Contains(u.Email)).ToList(); var roles = db.Roles.Where(r => roleNames.Contains(r.RoleNname)).ToList(); foreach (var user in users) { foreach (var role in roles) { if (!user.Roles.Contains(role)) { user.Roles.Add(role); } } } db.SaveChanges(); } }
public override void RemoveUsersFromRoles(string[] usernames, string[] roleNames) { if (usernames.Any(un => String.IsNullOrWhiteSpace(un))) { throw new ArgumentException("Usernames cannot contain username that is null, empty string or whitespace"); } if (roleNames.Any(rn => String.IsNullOrWhiteSpace(rn))) { throw new ArgumentException("RoleName cannot contain role name that is null, empty string or whitespace"); } using (var db = new MysenseiEntities()) { var users = db.Users.Include(i => i.Roles).Where(a => usernames.Contains(a.Email)); foreach (var user in users) { foreach (var roleName in roleNames) { var role = user.Roles.FirstOrDefault(r => r.RoleNname == roleName); if (role != null) { user.Roles.Remove(role); } } } db.SaveChanges(); } }
public ActionResult SignUpPartial(User user) { if (ModelState.IsValid) { DB.Users.Add(user); DB.SaveChanges(); } return(RedirectToAction("Login", "Login")); }
public override bool DeleteRole(string roleName, bool throwOnPopulatedRole) { ThrowOnNullOrWhiteSpace(roleName, "roleName"); using (var db = new MysenseiEntities()) { var role = db.Roles.FirstOrDefault(r => r.RoleNname == roleName); if (role == null) { throw new Exception("Role with given roleName does not exist"); } if (throwOnPopulatedRole && role.Users.Any()) { throw new ProviderException("Role is populated with users"); } db.Roles.Remove(role); db.SaveChanges(); return(true); } }
public override void CreateRole(string roleName) { ThrowOnNullOrWhiteSpace(roleName, "roleName"); if (roleName.Contains(',')) { throw new ArgumentException("roleName should not contain comma (\",\")"); } if (roleName.Length > 50) { throw new ArgumentException("roleName cannot be longer than 50 characters"); } using (var db = new MysenseiEntities()) { var role = new Role() { RoleNname = roleName }; db.Roles.Add(role); db.SaveChanges(); } }