protected override void Dispose(bool disposing)
{
if (disposing)
{
if (dbContext != null)
{
dbContext.Dispose();
dbContext = null;
}
}
base.Dispose(disposing);
}
static void Main(string[] args)
{
var dbContext = new ApplicationDbContext();
using (var uow = new UnitOfWork(dbContext))
{
// Creating user
// var user1 = new User { Login = "******", Password = "******" };
// var userRepo = new UserRepository(dbContext);
//userRepo.Create(user1);
//uow.Commit();
var userRepo = new UserRepository(dbContext);
var user1 = new User { Login = "******", Password = "******" };
var user2 = new User { Login = "******", Password = "******" };
// userRepo.Create(user1);
//userRepo.Create(user2);
// uow.Commit();
var users = userRepo.GetAll();
Console.WriteLine("All users count: " + users.Count());
var anna = userRepo.GetBy(user1.Login);
userRepo.Delete(anna);
uow.Commit();
users = userRepo.GetAll();
Console.WriteLine("All filtered users count: " + users.Count());
Console.ReadLine();
// Creating user article
var article1 = new Article { Title = "Article1", Body = "Article1 BodyText" };
var anna2 = userRepo.GetBy(user2.Login);
userRepo.Delete(anna2);
// anna2.Articles.Add(article1);
uow.Commit();
/*var comment1 = new Comment { Body = "Article1 is my first arctile. (Anna)" };
var articleRepo = new ArticleRepository(dbContext);
anna2.Comments.Add(comment1);
article1.Comments.Add(comment1);
uow.Commit();*/
}
}
public DetailsModel(DAL.ApplicationDbContext context)
{
_context = context;
}
public IndexModel(DAL.ApplicationDbContext context)
{
_context = context;
}
public EditModel(DAL.ApplicationDbContext context)
{
_context = context;
}
public DeleteModel(DAL.ApplicationDbContext context)
{
_context = context;
}
public CreateModel(DAL.ApplicationDbContext context)
{
_context = context;
}
public RecipePageModel(DAL.ApplicationDbContext context)
{
_context = context;
}
public ActionResult DeleteRoleForUser(string userName, string roleName)
{
List<string> userRoles;
List<string> roles;
List<string> users;
using (var context = new ApplicationDbContext())
{
var roleStore = new RoleStore<IdentityRole>(context);
var roleManager = new RoleManager<IdentityRole>(roleStore);
roles = (from r in roleManager.Roles select r.Name).ToList();
var userStore = new UserStore<ApplicationUser>(context);
var userManager = new UserManager<ApplicationUser>(userStore);
users = (from u in userManager.Users select u.UserName).ToList();
var user = userManager.FindByName(userName);
if (user == null)
throw new Exception("User not found!");
if (userManager.IsInRole(user.Id, roleName))
{
userManager.RemoveFromRole(user.Id, roleName);
context.SaveChanges();
ViewBag.ResultMessage = "Role removed from this user successfully !";
}
else
{
ViewBag.ResultMessage = "This user doesn't belong to selected role.";
}
var userRoleIds = (from r in user.Roles select r.RoleId);
userRoles = (from id in userRoleIds
let r = roleManager.FindById(id)
select r.Name).ToList();
}
ViewBag.RolesForThisUser = userRoles;
ViewBag.Roles = new SelectList(roles);
ViewBag.Users = new SelectList(users);
return View("RoleAddToUser");
}
public ActionResult GetRoles(string userName)
{
if (!string.IsNullOrWhiteSpace(userName))
{
List<string> userRoles;
List<string> roles;
List<string> users;
using (var context = new ApplicationDbContext())
{
var roleStore = new RoleStore<IdentityRole>(context);
var roleManager = new RoleManager<IdentityRole>(roleStore);
roles = (from r in roleManager.Roles select r.Name).ToList();
var userStore = new UserStore<ApplicationUser>(context);
var userManager = new UserManager<ApplicationUser>(userStore);
users = (from u in userManager.Users select u.UserName).ToList();
var user = userManager.FindByName(userName);
if (user == null)
throw new Exception("User not found!");
var userRoleIds = (from r in user.Roles select r.RoleId);
userRoles = (from id in userRoleIds
let r = roleManager.FindById(id)
select r.Name).ToList();
}
ViewBag.Roles = new SelectList(roles);
ViewBag.Users = new SelectList(users);
ViewBag.RolesForThisUser = userRoles;
}
return View("RoleAddToUser");
}
public ActionResult RoleAddToUser(string roleName, string userName)
{
List<string> roles;
List<string> users;
using (var context = new ApplicationDbContext())
{
var roleStore = new RoleStore<IdentityRole>(context);
var roleManager = new RoleManager<IdentityRole>(roleStore);
var userStore = new UserStore<ApplicationUser>(context);
var userManager = new UserManager<ApplicationUser>(userStore);
users = (from u in userManager.Users select u.UserName).ToList();
var user = userManager.FindByName(userName);
if (user == null)
throw new Exception("User not found!");
var role = roleManager.FindByName(roleName);
if (role == null)
throw new Exception("Role not found!");
if (userManager.IsInRole(user.Id, role.Name))
{
ViewBag.ResultMessage = "This user already has the role specified !";
}
else
{
userManager.AddToRole(user.Id, role.Name);
context.SaveChanges();
ViewBag.ResultMessage = "Username added to the role succesfully !";
}
roles = (from r in roleManager.Roles select r.Name).ToList();
}
ViewBag.Roles = new SelectList(roles);
ViewBag.Users = new SelectList(users);
return View();
}
public ActionResult RoleAddToUser()
{
List<string> roles;
List<string> users;
using (var context = new ApplicationDbContext())
{
var roleStore = new RoleStore<IdentityRole>(context);
var roleManager = new RoleManager<IdentityRole>(roleStore);
var userStore = new UserStore<ApplicationUser>(context);
var userManager = new UserManager<ApplicationUser>(userStore);
users = (from u in userManager.Users select u.UserName).ToList();
roles = (from r in roleManager.Roles select r.Name).ToList();
}
ViewBag.Roles = new SelectList(roles);
ViewBag.Users = new SelectList(users);
return View();
}
public ActionResult RoleDelete(string roleName)
{
using (var context = new ApplicationDbContext())
{
var roleStore = new RoleStore<IdentityRole>(context);
var roleManager = new RoleManager<IdentityRole>(roleStore);
var role = roleManager.FindByName(roleName);
roleManager.Delete(role);
context.SaveChanges();
}
ViewBag.ResultMessage = "Role deleted succesfully !";
return RedirectToAction("RoleIndex", "Account");
}
public ActionResult RoleIndex()
{
List<string> roles;
using (var context = new ApplicationDbContext())
{
var roleStore = new RoleStore<IdentityRole>(context);
var roleManager = new RoleManager<IdentityRole>(roleStore);
roles = (from r in roleManager.Roles select r.Name).ToList();
}
return View(roles.ToList());
}
