internal bool RemoveUser(string username)
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
var userMgr = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
userMgr.Delete(userMgr.FindByName(username));
return true;
}
internal bool UpdateUser(string username, string realUsername, string permission)
{
IdentityResult result = null;
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
var userMgr = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
var user = userMgr.FindByName(username);
if (!string.IsNullOrEmpty(realUsername))
{
user.RealUserName = realUsername;
result = userMgr.Update(user);
}
if (!string.IsNullOrEmpty(permission) && !userMgr.IsInRole(user.Id, permission))
{
userMgr.RemoveFromRoles(user.Id, "read", "edit", "administrator");
switch (permission)
{
case "administrator":
result = userMgr.AddToRole(user.Id, "administrator");
break;
case "edit":
result = userMgr.AddToRole(user.Id, "edit");
break;
default:
result = userMgr.AddToRole(user.Id, "read");
break;
}
}
if (result == IdentityResult.Success) return true; else return false;
}
internal void AddUserAndRole()
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
IdentityResult IdRoleResult;
IdentityResult IdUserResult;
var roleStore = new RoleStore<IdentityRole>(context);
var roleMgr = new RoleManager<IdentityRole>(roleStore);
if (!roleMgr.RoleExists("administrator"))
{
IdRoleResult = roleMgr.Create(new IdentityRole { Name = "administrator" });
}
var userMgr = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
var appUser = new ApplicationUser
{
UserName = "******",
ImgUrl = "user2-160x160.jpg",
Description = "High Level",
SinceDate = new DateTime(2016, 1, 1)
};
IdUserResult = userMgr.Create(appUser, "1qaz2wsxE");
var user = userMgr.FindByName("administrator");
if (!userMgr.IsInRole(user.Id, "administrator"))
{
IdUserResult = userMgr.AddToRole(userMgr.FindByName("administrator").Id, "administrator");
}
}
internal void AddUserAndRole()
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
IdentityResult IdRoleResult;
IdentityResult IdUserResult;
var roleStore = new RoleStore<IdentityRole>(context);
var roleMgr = new RoleManager<IdentityRole>(roleStore);
if (!roleMgr.RoleExists("administrator"))
{
IdRoleResult = roleMgr.Create(new IdentityRole { Name = "administrator" });
}
var userMgr = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
var appUser = new ApplicationUser
{
UserName = "******",
};
IdUserResult = userMgr.Create(appUser, "1qaz2wsxE");
var user = userMgr.FindByName("administrator");
if (!userMgr.IsInRole(user.Id, "administrator"))
{
//userMgr.RemoveFromRoles(user.Id, "read", "edit");
IdUserResult = userMgr.AddToRole(userMgr.FindByName("administrator").Id, "administrator");
}
}
private List<int> SelectedCharacters()
{
using (var db = new Models.ApplicationDbContext())
{
var currentUser = db.Users.First(user => user.UserName == User.Identity.Name);
return currentUser.Characters.Select(ownedCharacters => ownedCharacters.ID).ToList();
}
}
internal void createAdmin()
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
IdentityResult IdRoleResult;
IdentityResult IdUserResult;
var roleStore = new RoleStore<IdentityRole>(context);
}
public ActionResult Index()
{
using (var db = new Models.ApplicationDbContext())
{
return View(
new Models.CharactersViewModel(db.Characters.AsEnumerable(), SelectedCharacters())
);
}
}
internal List<object> GetBindingDate()
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
var query = from u in context.Users
from ur in u.Roles
from r in context.Roles
where ur.RoleId == r.Id
select new { u.UserName, u.RealUserName, Permission = r.Name };
return query.ToList<object>();
}
public override IEnumerable<DynamicNode> GetDynamicNodeCollection(ISiteMapNode node_)
{
using (var db = new Models.ApplicationDbContext())
{
var nodes = new List<DynamicNode>();
var items = db.tForumLists.ToList();
foreach (var item in items)
{
var node = new DynamicNode {Key = "ForumList_" + item.Id.ToString()};
// ключ должен быть уникальным для каждой ноды
node.RouteValues.Add("id", item.Id);
node.Action = "Index";
node.Controller = "ForumThemes";
node.Title = item.tForumList_name;
nodes.Add(node);
if (item.tForumThemes == null) continue;
var c = new DynamicNode
{
Key = "CreateForumThemes_" + item.Id.ToString(),
ParentKey = node.Key,
Action = "Create",
Controller = "ForumThemes",
Title = "Создать новую тему"
};
c.RouteValues.Add("id", item.Id);
nodes.Add(c);
foreach (var item2 in item.tForumThemes)
{
var node2 = new DynamicNode
{
Key = "ForumMessages_" + item2.Id.ToString(),
ParentKey = node.Key
};
node2.RouteValues.Add("id", item2.Id);
node2.RouteValues.Add("id_list", item2.tForumList.Id);
node2.Action = "Index";
node2.Controller = "ForumMessages";
if (item2.tForumThemes_name.Length > 30)
{
node2.Title = item2.tForumThemes_name.Substring(0,30)+"...";
}
else
{
node2.Title = item2.tForumThemes_name;
}
nodes.Add(node2);
}
}
db.Dispose();
return nodes;
}
}
internal void createAdmin()
{
// Access the application context and create result variables.
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
IdentityResult IdRoleResult;
IdentityResult IdUserResult;
// Create a RoleStore object by using the ApplicationDbContext object.
// The RoleStore is only allowed to contain IdentityRole objects.
var roleStore = new RoleStore<IdentityRole>(context);
// Create a RoleManager object that is only allowed to contain IdentityRole objects.
// When creating the RoleManager object, you pass in (as a parameter) a new RoleStore object.
var roleMgr = new RoleManager<IdentityRole>(roleStore);
// Then, you create the "Administrator" role if it doesn't already exist.
if (!roleMgr.RoleExists("Teacher"))
{
IdRoleResult = roleMgr.Create(new IdentityRole("Teacher"));
if (!IdRoleResult.Succeeded)
{
// Handle the error condition if there's a problem creating the RoleManager object.
}
}
//// Create a UserManager object based on the UserStore object and the ApplicationDbContext
//// object. Note that you can create new objects and use them as parameters in
//// a single line of code, rather than using multiple lines of code, as you did
//// for the RoleManager object.
//var userMgr = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
//var appUser = new ApplicationUser()
//{
// UserName = "******",
//};
//IdUserResult = userMgr.Create(appUser, "Pa$$word");
//// If the new "Admin" user was successfully created,
//// add the "Admin" user to the "Administrator" role.
//if (IdUserResult.Succeeded)
//{
// IdUserResult = userMgr.AddToRole(appUser.Id, "Administrator");
// if (!IdUserResult.Succeeded)
// {
// // Handle the error condition if there's a problem adding the user to the role.
// }
//}
//else
//{
// // Handle the error condition if there's a problem creating the new user.
//}
}
public void UpdateCharacters(List<int> characters)
{
using (var db = new Models.ApplicationDbContext())
{
var currentUser = db.Users.First(user => user.UserName == User.Identity.Name);
currentUser.Characters.Clear();
if (characters.Count() > 0)
{
var charactersToAdd = db.Characters.Where(character => characters.Contains(character.ID));
foreach (var characterToAdd in charactersToAdd)
{
currentUser.Characters.Add(characterToAdd);
}
}
db.SaveChanges();
}
}
public static ChartLogic.chartData getUserPledgeContributionsForCharity(Models.Charities.Charity C)
{
var Amounts = new List<ChartLogic.chartData.chartDataItem>();
var Labels = new List<ChartLogic.chartData.chartDataItem>();
var Ledgends = new List<ChartLogic.chartData.chartDataItem>();
var db = new Models.ApplicationDbContext();
var AllCharityPledgeContributions = db.PledgeContributors.Where(PC => PC.Pledge.Charity.ID == C.ID ).ToList();
var GroupedPledgeContributions = AllCharityPledgeContributions.GroupBy(pc => pc.Sinner).Select(g => new { g,Sum = CurrencyLogic.ToBase(g.ToList()) }).ToList();
foreach (var gPC in GroupedPledgeContributions.OrderByDescending(a => a.Sum))
{
Amounts.Add(new ChartLogic.chartData.chartDataItem(gPC.Sum.ToString("0.00")));
Labels.Add(new ChartLogic.chartData.chartDataItem(gPC.Sum.ToString("0.00")));
Ledgends.Add(new ChartLogic.chartData.chartDataItem(gPC.g.Key.UserName));
}
return new ChartLogic.chartData(Ledgends, Amounts, Labels, GenericLogic.HTML.USER_HTML + " Users",true);
}
internal void CreateProductionUser()
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
IdentityResult IdRoleResult;
IdentityResult IdUserResult;
var roleStore = new RoleStore<IdentityRole>(context);
var roleMgr = new RoleManager<IdentityRole>(roleStore);
if (!roleMgr.RoleExists("Production"))
{
IdRoleResult = roleMgr.Create(new IdentityRole("Production"));
if (!IdRoleResult.Succeeded)
{
}
}
var userMgr = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
var appUser = new ApplicationUser()
{
UserName = "******",
};
IdUserResult = userMgr.Create(appUser, "Pa$$word");
if (IdUserResult.Succeeded)
{
IdUserResult = userMgr.AddToRole(appUser.Id, "Production");
if (!IdUserResult.Succeeded)
{
}
}
else
{
}
}
public ActionResult Index()
{
var context = new Models.ApplicationDbContext();
var rolelist = context.Roles.OrderBy(r => r.Name).ToList().Select(rr =>
new SelectListItem {
Value = rr.Name.ToString(), Text = rr.Name
}).ToList();
ViewBag.Roles = rolelist;
var userlist = context.Users.OrderBy(u => u.UserName).ToList().Select(uu =>
new SelectListItem {
Value = uu.UserName.ToString(), Text = uu.UserName
}).ToList();
ViewBag.Users = userlist;
ViewBag.Message = "";
return(View());
}
public static ChartLogic.chartData getTeamPledgeContributionsForCharity(Models.Charities.Charity C)
{
var Amounts = new List <ChartLogic.chartData.chartDataItem>();
var Labels = new List <ChartLogic.chartData.chartDataItem>();
var Ledgends = new List <ChartLogic.chartData.chartDataItem>();
var db = new Models.ApplicationDbContext();
var AllCharityPledgeContributions = db.PledgeContributors.Where(PC => PC.Pledge.Charity.ID == C.ID).ToList();
var GroupedPledgeContributions = AllCharityPledgeContributions.GroupBy(pc => pc.Sinner.Team).Select(pc => new { pc, Sum = CurrencyLogic.ToBase(pc.ToList()) });
foreach (var gPC in GroupedPledgeContributions.OrderByDescending(a => a.Sum))
{
Amounts.Add(new ChartLogic.chartData.chartDataItem(gPC.Sum.ToString("0.00")));
Labels.Add(new ChartLogic.chartData.chartDataItem(gPC.Sum.ToString("0.00")));
Ledgends.Add(gPC.pc.Key == null
? new ChartLogic.chartData.chartDataItem("Unaffiliated")
: new ChartLogic.chartData.chartDataItem(gPC.pc.Key.Name));
}
return(new ChartLogic.chartData(Ledgends, Amounts, Labels, GenericLogic.HTML.TEAM_HTML + " Teams", true));
}
protected override void Seed(Models.ApplicationDbContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
//if (context.Students.Count() == 0)
//{
// context.Students.AddOrUpdate(
// new
// );
//}
}
public IQueryable <DTO_CUS_DOC_File_Actitity> Get()
{
var result = BS_CUS_DOC_File_Actitity.get_CUS_DOC_File_Actitity(db, PartnerID, QueryStrings).ToList();
if (result != null)
{
var context = new Models.ApplicationDbContext();
var users = context.Users.ToList();
foreach (var item in result)
{
var u = users.FirstOrDefault(d => d.Email == item.CreatedBy);
if (u != null)
{
item.ModifiedByName = u.FullName;
item.Avatar = u.Avatar;
}
}
}
return(result.AsQueryable());
}
//
// GET: /Roles/Edit/5
public ActionResult Edit(string roleName)
{
var context = new Models.ApplicationDbContext();
var thisRole = context.Roles.Where(r => r.Name.Equals(roleName, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
var rolelist = context.Roles.OrderBy(r => r.Name).ToList().Select(rr =>
new SelectListItem {
Value = rr.Name.ToString(), Text = rr.Name
}).ToList();
ViewBag.Roles = rolelist;
var userlist = context.Users.OrderBy(u => u.UserName).ToList().Select(uu =>
new SelectListItem {
Value = uu.UserName.ToString(), Text = uu.UserName
}).ToList();
ViewBag.Users = userlist;
ViewBag.Message = "";
return(View(thisRole));
}
public bool BookIsBounded(long book_id, long second_id, int n)
{
using (var context = new Models.ApplicationDbContext())
{
if (n == 0)
{
if (context.Book_Authors.Any(ba => ba.BookId == book_id && ba.AuthorId == second_id))
{
return(true);
}
else
{
return(false);
}
}
else if (n == 1)
{
if (context.Book_Genres.Any(bg => bg.BookId == book_id && bg.GenreId == second_id))
{
return(true);
}
else
{
return(false);
}
}
else
{
if (context.Book_Series.Any(bs => bs.BookId == book_id && bs.SeriesId == second_id))
{
return(true);
}
else
{
return(false);
}
}
}
}
public ActionResult Sort(string sortOrder)
{
var context = new Models.ApplicationDbContext();
ViewBag.NameSortParam = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.QuantitySortParam = sortOrder == "Quantity" ? "quantity_desc" : "Quantity";
ViewBag.PriceSortParam = sortOrder == "Price" ? "price_desc" : "Price";
List <Models.Products> list = context.Products.ToList();
switch (sortOrder)
{
case "name_desc":
list = list.OrderByDescending(x => x.ProductName).ToList();
break;
case "Price":
list = list.OrderBy(x => x.UnitPrice).ToList();
break;
case "price_desc":
list = list.OrderByDescending(x => x.UnitPrice).ToList();
break;
case "Quantity":
list = list.OrderBy(x => x.Quantity).ToList();
break;
case "quantity_desc":
list = list.OrderByDescending(x => x.Quantity).ToList();
break;
default:
list = list.OrderBy(x => x.ProductName).ToList();
break;
}
return(View(nameof(List), list));
}
public ActionResult GetRoles(string UserName)
{
if (!string.IsNullOrWhiteSpace(UserName))
{
var context = new Models.ApplicationDbContext();
ApplicationUser user = context.Users.Where(u => u.UserName.Equals(UserName, StringComparison.CurrentCultureIgnoreCase)).FirstOrDefault();
var userStore = new UserStore <ApplicationUser>(context);
var userManager = new UserManager <ApplicationUser>(userStore);
ViewBag.RolesForThisUser = userManager.GetRoles(user.Id);
var rolelist = context.Roles.OrderBy(r => r.Name).ToList().Select(rr => new SelectListItem {
Value = rr.Name.ToString(), Text = rr.Name
}).ToList(); ViewBag.Roles = rolelist;
var userlist = context.Users.OrderBy(u => u.UserName).ToList().Select(uu => new SelectListItem {
Value = uu.UserName.ToString(), Text = uu.UserName
}).ToList(); ViewBag.Users = userlist;
ViewBag.Message = "Roles retrieved successfully!!!!";
}
return(View("Index"));
}
public static ChartLogic.chartData getTeamPledgeContributionsForCharity(Models.Charities.Charity C)
{
var Amounts = new List<ChartLogic.chartData.chartDataItem>();
var Labels = new List<ChartLogic.chartData.chartDataItem>();
var Ledgends = new List<ChartLogic.chartData.chartDataItem>();
var db = new Models.ApplicationDbContext();
var AllCharityPledgeContributions = db.PledgeContributors.Where(PC => PC.Pledge.Charity.ID == C.ID).ToList();
var GroupedPledgeContributions = AllCharityPledgeContributions.GroupBy(pc => pc.Sinner.Team).Select(pc => new {pc, Sum=CurrencyLogic.ToBase(pc.ToList())});
foreach (var gPC in GroupedPledgeContributions.OrderByDescending(a => a.Sum))
{
Amounts.Add(new ChartLogic.chartData.chartDataItem(gPC.Sum.ToString("0.00")));
Labels.Add(new ChartLogic.chartData.chartDataItem(gPC.Sum.ToString("0.00")));
Ledgends.Add(gPC.pc.Key == null
? new ChartLogic.chartData.chartDataItem("Unaffiliated")
: new ChartLogic.chartData.chartDataItem(gPC.pc.Key.Name));
}
return new ChartLogic.chartData(Ledgends, Amounts, Labels, GenericLogic.HTML.TEAM_HTML+ " Teams", true);
}
public HttpResponseMessage ADUsuario(V_Usuarios usuario)
{
Models.ApplicationDbContext db = new Models.ApplicationDbContext();
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
var Usuario = db.Users.FirstOrDefault((u) => u.Id == usuario.id);
if (Usuario == null)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.NotFound);
response.Content = new StringContent("Usuario Invalido", Encoding.Unicode);
return response;
}
if (Usuario.LockoutEnabled)
Usuario.LockoutEnabled = false;
else
Usuario.LockoutEnabled = true;
db.Entry(Usuario).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.NotFound);
response.Content = new StringContent(ex.Message, Encoding.Unicode);
return response;
}
HttpResponseMessage response2 = Request.CreateResponse(HttpStatusCode.OK);
if (Usuario.LockoutEnabled)
response2.Content = new StringContent("EL Usuario: " + Usuario.UserName + " ha sido Desactivado Temporalmente", Encoding.Unicode);
if (!Usuario.LockoutEnabled)
response2.Content = new StringContent("EL Usuario: " + Usuario.UserName + " ha sido Activado", Encoding.Unicode);
return response2;
}
protected override void Seed(Models.ApplicationDbContext context)
{
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
if (!context.Roles.Any(r => r.Name == "Admin"))
{
roleManager.Create(new IdentityRole {
Name = "Admin"
});
}
ApplicationUser adminUser = null;
if (!context.Users.Any(p => p.UserName == "*****@*****.**"))
{
adminUser = new ApplicationUser();
adminUser.UserName = "******";
adminUser.Email = "*****@*****.**";
adminUser.FirstName = "Admin";
adminUser.LastName = "User";
userManager.Create(adminUser, "Pass-Word!");
}
else
{
adminUser = context.Users.Where(p => p.UserName == "*****@*****.**")
.FirstOrDefault();
}
if (!userManager.IsInRole(adminUser.Id, "Admin"))
{
userManager.AddToRole(adminUser.Id, "Admin");
}
}
private void PopulateBooks(Models.ApplicationDbContext context)
{
for (int i = 0; i < 10; i++)
{
var category = new Category
{
Name = "Category " + i,
};
for (int j = 0; j < 10; j++)
{
category.Books.Add(new Book
{
Title = "Book " + i + " " + j,
Content = "Content " + i + " " + j,
Author = "Author " + i + " " + j,
Category = category
});
}
context.Categories.Add(category);
}
}
public PartialViewResult ListUserWithRole()
{
var context = new Models.ApplicationDbContext();
var ListUserWithRole = (from user in context.Users
select new
{
UserId = user.Id,
Username = user.UserName,
Email = user.Email,
RoleNames = (from userRole in user.Roles
join role in context.Roles on userRole.RoleId
equals role.Id
select role.Name).ToList()
}).ToList().Select(p => new UsersWithRoleViewModel()
{
UserId = p.UserId,
UserName = p.Username,
Email = p.Email,
RoleName = string.Join(",", p.RoleNames)
});
return(PartialView(ListUserWithRole));
}
public ActionResult Edit(int id, FormCollection collection)
{
ApplicationDbContext SubContext = new Models.ApplicationDbContext();
using (var transactionQueue = SubContext.Database.BeginTransaction())
{
try
{
Submission[] Submissions = SubContext.SubmissionDB.FindBySubmissionID(id).ToArray();
Submissions[0].grade = Int32.Parse(collection.Get("grade"));
Submissions[0].feedbackText = collection.Get("feedbackText");
Submissions[0].feedbackAuthor = User.Identity.GetUserId();
SubContext.SaveChanges();
transactionQueue.Commit();
return(RedirectToAction("../"));
}
catch (DbEntityValidationException exception) {
foreach (var errors in exception.EntityValidationErrors)
{
foreach (var error in errors.ValidationErrors)
{
ModelState.AddModelError(error.PropertyName, error.ErrorMessage);
}
}
Submission[] Submissions = SubContext.SubmissionDB.FindBySubmissionID(id).ToArray();
return(View("Details", Submissions));
}
catch {
transactionQueue.Rollback();
Submission[] Submissions = SubContext.SubmissionDB.FindBySubmissionID(id).ToArray();
ModelState.AddModelError("fileError", "There was an error with talking to the database.");
return(View("Details", Submissions));
}
}
}
public ActionResult AddRole(AspNetRole Ar)
{
if (ModelState.IsValid)
{
try
{
var context = new Models.ApplicationDbContext();
context.Roles.Add(new Microsoft.AspNet.Identity.EntityFramework.IdentityRole()
{
Name = Ar.Name
});
context.SaveChanges();
ViewBag.Message = "Role created successfully !";
return(RedirectToAction("Index", "Home"));
}
catch
{
return(View());
}
}
return(View(Ar));
}
public UserController()
{
db = new ApplicationDbContext();
var allreadyExist = db.Users.Any(x => x.email == "*****@*****.**");
if (!allreadyExist)
{
db.Users.Add(new Users {
UserId = 1, name = "Morten", email = "*****@*****.**", password = "******", isAdmin = true
});
db.SaveChanges();
}
var allreadyExist1 = db.Users.Any(x => x.name == "test");
if (!allreadyExist1)
{
db.Users.Add(new Users {
UserId = 3, name = "test", email = "*****@*****.**", password = "******"
});
db.SaveChanges();
}
}
public List<System.Web.Mvc.SelectListItem> GetPerfiles()
{
Models.ApplicationDbContext db = new Models.ApplicationDbContext();
var Result = new List<System.Web.Mvc.SelectListItem>();
var Grupo = new System.Web.Mvc.SelectListGroup() { Name = "Perfiles" };
var ListaRoles = from U in db.Roles
select U;
foreach (var Role in ListaRoles)
Result.Add(new System.Web.Mvc.SelectListItem() { Group = Grupo, Text = Role.Name, Value = Role.Name });
return Result;
}
public PlanesController()
{
_dbContext = new Models.ApplicationDbContext();
}
public IHttpActionResult getUsuarios()
{
Models.ApplicationDbContext db = new Models.ApplicationDbContext();
var data = (from C in db.Users
select new
{
id = C.Id
,
UserName = C.UserName
,
Email = C.Email
,
PhoneNumber = C.PhoneNumber
,
Perfil = ""
,
LockoutEnabled = C.LockoutEnabled
});
return Ok(data);
}
//class AddingRoles.Models.ApplicationDbContext
public RoleController()
{
context = new Models.ApplicationDbContext();
}
public static System.Collections.Generic.List <City> getCities(Models.ApplicationDbContext context)
{
List <City> Cities = new List <City> {
new City()
{
CityName = "Surrey",
Population = 2000,
},
new City()
{
CityName = "Richmond",
Population = 1000,
//ProvinceName = context.Provinces.Find("British Columbia").ProvinceName,
},
new City()
{
CityName = "Port Moody",
Population = 500,
//ProvinceName = context.Provinces.Find("British Columbia").ProvinceName,
},
new City()
{
CityName = "Surrey",
Population = 2000,
//ProvinceName = context.Provinces.Find("British Columbia").ProvinceName,
},
new City()
{
CityName = "Edmonton",
Population = 5000,
//ProvinceName = context.Provinces.Find("Alberta").ProvinceName,
},
new City()
{
CityName = "Calgary",
Population = 500,
//ProvinceName = context.Provinces.Find("Alberta").ProvinceName,
},
new City()
{
CityName = "LethBridge",
Population = 2000,
//ProvinceName = context.Provinces.Find("Alberta").ProvinceName,
},
new City()
{
CityName = "Saskatoon",
Population = 2000,
//ProvinceName = context.Provinces.Find("Saskatchwen").ProvinceName,
},
new City()
{
CityName = "Prarie",
Population = 8,
//ProvinceName = context.Provinces.Find("Saskatchwen").ProvinceName,
},
new City()
{
CityName = "Wheat",
Population = 4,
//ProvinceName = context.Provinces.Find("Saskatchwen").ProvinceName,
},
};
return(Cities);
}
public static List<Models.Charities.Charity> GetTopCharitiesByAmountRaised()
{
var db = new Models.ApplicationDbContext();
return db.Charities.ToList().OrderByDescending(c => c.Pledges.ToList().Sum(p => p.Contributors.ToList().Sum(con => CurrencyLogic.ToBase(con.Currency, con.Amount)))).Take(5).ToList();
}
public SkolerController()
{
_context = new ApplicationDbContext();
}
public ContactPersonsController()
{
_context = new ApplicationDbContext();
}
public RoleController()
{
context = new Models.ApplicationDbContext();
}
public CustomerRatesEditModel(Models.ApplicationDbContext context)
{
_context = context;
}
public OrdersController()
{
db = new ApplicationDbContext();
}
public PoisRepository(Models.ApplicationDbContext applicationDbContext)
{
// TODO: Complete member initialization
this.db = applicationDbContext;
}
public PoisRepository()
{
// TODO: Complete member initialization
this.db = new ApplicationDbContext();
}
public string GetAspNetUsersXML()
{
var appDbContext = new Models.ApplicationDbContext();
DTOs.AspNetUserDataDTO theTransferObject = new DTOs.AspNetUserDataDTO();
theTransferObject.Users = new List <DTOs.AspNetUsersDTO>();
theTransferObject.Roles = new List <DTOs.AspNetRolesDTO>();
theTransferObject.UserLogins = new List <DTOs.AspNetUserLoginsDTO>();
theTransferObject.UserRoles = new List <DTOs.AspNetUserRolesDTO>();
var userManager = new UserManager <Models.ApplicationUser>(new UserStore <Models.ApplicationUser>(appDbContext));
foreach (var item in appDbContext.Users.ToList())
{
theTransferObject.Users.Add(new DTOs.AspNetUsersDTO()
{
Id = item.Id,
Email = item.Email,
EmailConfirmed = item.EmailConfirmed,
PasswordHash = item.PasswordHash,
SecurityStamp = item.SecurityStamp,
PhoneNumber = item.PhoneNumber,
PhoneNumberConfirmed = item.PhoneNumberConfirmed,
TwoFactorEnabled = item.TwoFactorEnabled,
LockoutEndDateUtc = item.LockoutEndDateUtc.HasValue ? item.LockoutEndDateUtc.Value : (DateTime?)null,
LockoutEnabled = item.LockoutEnabled,
AcccessFailedCount = item.AccessFailedCount,
UserName = item.UserName
});
foreach (var login in item.Logins.ToList())
{
theTransferObject.UserLogins.Add(new DTOs.AspNetUserLoginsDTO()
{
UserId = login.UserId,
LoginProvider = login.LoginProvider,
ProviderKey = login.ProviderKey
});
}
}
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(appDbContext));
foreach (var item in roleManager.Roles.ToList())
{
theTransferObject.Roles.Add(new DTOs.AspNetRolesDTO()
{
Id = item.Id,
Name = item.Name
});
foreach (var ruser in item.Users)
{
theTransferObject.UserRoles.Add(new DTOs.AspNetUserRolesDTO()
{
UserId = ruser.UserId,
RoleId = ruser.RoleId
});
}
}
XmlSerializer serializer = new XmlSerializer(typeof(DTOs.AspNetUserDataDTO));
var xml = "";
using (var sww = new StringWriter())
{
using (XmlWriter writer = XmlWriter.Create(sww))
{
writer.WriteProcessingInstruction("xml", "version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"");
serializer.Serialize(writer, theTransferObject);
xml = sww.ToString();
}
}
return(xml);
}
internal List<ApplicationUser> GetAllUsers()
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
var userMgr = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
return userMgr.Users.ToList();
}
public HttpResponseMessage AltaUser(Usuario usuario)
{
if (!ModelState.IsValid)
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
if (usuario.Password != usuario.ConfirmPassword)
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
try
{
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
AltaUsuario(context, new Models.ApplicationUser() { Email = usuario.Email, UserName = usuario.UserName }, usuario.Password, usuario.Perfil);
}
catch (DbUpdateConcurrencyException ex)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.NotFound);
response.Content = new StringContent(ex.Message, Encoding.Unicode);
return response;
}
HttpResponseMessage okresponse = Request.CreateResponse(HttpStatusCode.OK);
okresponse.Content = new StringContent("Usuario Registrado: " + usuario.UserName, Encoding.Unicode);
return okresponse;
}
public HttpResponseMessage DeleteUser(V_Usuarios usuario)
{
Models.ApplicationDbContext db = new Models.ApplicationDbContext();
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
var Usuario = db.Users.FirstOrDefault((u) => u.Id == usuario.id);
if (Usuario == null)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.NotFound);
response.Content = new StringContent("Usuario Invalido", Encoding.Unicode);
return response;
}
db.Users.Remove(Usuario);
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.NotFound);
response.Content = new StringContent(ex.Message, Encoding.Unicode);
return response;
}
HttpResponseMessage response2 = Request.CreateResponse(HttpStatusCode.OK);
response2.Content = new StringContent("EL Usuario: " + Usuario.UserName + " ha sido Eliminado", Encoding.Unicode);
return response2;
}
public SuperherosController()
{
context = new Models.ApplicationDbContext();
}
public static List<Models.Charities.Charity> GetTopCharities()
{
var db = new Models.ApplicationDbContext();
return db.Charities.OrderByDescending(c => c.Pledges.Count()).Take(5).ToList();
}
public async Task<ActionResult> Create(tblUserExt tblUserExtended)
{
try
{
db = new dbTIREntities();
modelService = new ModelServices();
siteUser = ((SiteUser)Session["SiteUser"]);
userService = new UserService(siteUser, db);
schoolService = new SchoolService(siteUser, db);
int userAssignedDistrict = siteUser.Districts[0].Id;
string currentSchoolYear = schoolService.GetCurrentSchoolYear();
if (ModelState.IsValid)
{
if (tblUserExtended.SelectedSchools != null && tblUserExtended.SelectedSchools.Count() > 0)
{
var context = new Models.ApplicationDbContext();
var userManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
// 1. Create ASPNET user
string userName = tblUserExtended.UserName;
string password = tblUserExtended.Password;
var isPasswordValid = password != null && password.Length >= 6 ? true : false;
var isUserNameExist = userManager.FindByName(userName);
bool isEmailAddressExist = db.tblUsers.Where(x => x.UserEmail == tblUserExtended.UserEmail).Count() > 0 ? true : false;
bool isStateIdExist = db.tblUsers.Where(x => x.StateId == tblUserExtended.StateId).Count() > 0 ? true : false;
if ((isUserNameExist == null) && (!isEmailAddressExist) && (!isStateIdExist) && (isPasswordValid))
{
var user = new ApplicationUser() { UserName = userName };
var result = await userManager.CreateAsync(user, password);
if (result.Succeeded)
{
// 2. Create EDS user
ApplicationUser newAspNetUser = userManager.FindByName(userName);
if (newAspNetUser != null)
{
userService.CreateEdsUser(newAspNetUser.Id, tblUserExtended);
}
}
else
{
throw new Exception(String.Format("ERROR: {0}", result.Errors));
}
return RedirectToAction("Index");
}
else
{
if (isUserNameExist != null)
ModelState.AddModelError("UserName", "Duplicate name - please choose a unique name.");
if (isEmailAddressExist)
ModelState.AddModelError("UserEmail", "Duplicate email - please choose a unique email.");
if (isStateIdExist)
ModelState.AddModelError("StateId", "Duplicate state id - please choose a unique state.");
if (!isPasswordValid)
ModelState.AddModelError("Password", "Please enter password at least 6 characters.");
}
}
else
{
ViewBag.SchoolMessage = "Required";
}
}
tblUserExtended.Schools = userService.GetSelectedSchoolCheckBoxes(tblUserExtended);
ViewBag.RoleId = new SelectList(modelService.GetRolesForRole((int)(siteUser.Role)), "RoleId", "RoleDesc", tblUserExtended.RoleId);
FillViewBagValues(siteUser.Districts[0].Name, string.Empty, siteUser.RoleDesc, tblUserExtended.SchoolYearId);
return View(tblUserExtended);
}
catch (Exception ex)
{
Logging log = new Logging();
log.LogException(ex);
return View("GeneralError");
}
}
public BaseService()
{
db = new Models.ApplicationDbContext();
}
public ActionResult Edit(int? id, int schoolYearId)
{
try
{
db = new dbTIREntities();
modelService = new ModelServices();
siteUser = ((SiteUser)Session["SiteUser"]);
schoolService = new SchoolService(siteUser, db);
userService = new UserService(siteUser, db);
//tblUserExt tbluserExtended = null;
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
tblUser tbluser = db.tblUsers.Find(id);
if (tbluser == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
var context = new Models.ApplicationDbContext();
var userManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
string aspNetUserName = "******";
if (!String.IsNullOrEmpty(tbluser.AspNetUserId))
{
ApplicationUser aspNetUser = userManager.FindById(tbluser.AspNetUserId);
if (aspNetUser != null)
{
aspNetUserName = aspNetUser.UserName;
}
}
//Get RoleId from tblUserDistrict instead of tblUser
int roleId = userService.GetRoleId(id, schoolYearId);
tblUserExt tbluserExtended = new tblUserExt()
{
UserId = tbluser.UserId,
UserName = aspNetUserName,
FirstName = tbluser.FirstName,
LastName = tbluser.LastName,
UserEmail = tbluser.UserEmail,
StateId = tbluser.StateId,
Schools = tbluser.Schools,
SchoolYearId = schoolYearId,
RoleId = roleId
};
//Check that edited user's school must be from EDSUser schools or edsUser must have permissions to view user school
bool isUserHasPermissionForSchool = userService.IsUserHasPermissionForSchool(tbluserExtended);
if (!isUserHasPermissionForSchool)
{
return RedirectToAction("Index");
}
//Get User schools
tbluserExtended.Schools = userService.GetUserSchoolWithCheckBoxes(tbluserExtended);
var dropDownEmpty = Enumerable.Repeat(new SelectListItem { Value = "", Text = "" }, count: 1);
FillViewBagValues(siteUser.Districts[0].Name, string.Empty, siteUser.RoleDesc, schoolYearId);
FillUserExtendedCommanData(modelService, tbluserExtended);
return View(tbluserExtended);
}
catch (Exception ex)
{
Logging log = new Logging();
log.LogException(ex);
return View("GeneralError");
}
}
protected override void Seed(Models.ApplicationDbContext context)
{
// Classes to work with users and roles (provided by Microsoft packages)
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
//Check if the roles are already created.
//If not, create them.
if (!context.Roles.Any(r => r.Name == "Admin"))
{
roleManager.Create(new IdentityRole {
Name = "Admin"
});
}
if (!context.Roles.Any(r => r.Name == "Moderator"))
{
roleManager.Create(new IdentityRole {
Name = "Moderator"
});
}
//Check if the admin user is already created.
//If not, create it.
ApplicationUser adminUser = null;
ApplicationUser modUser = null;
if (!context.Users.Any(p => p.UserName == "*****@*****.**"))
{
adminUser = new ApplicationUser();
adminUser.UserName = "******";
adminUser.Email = "*****@*****.**";
adminUser.FirstName = "Admin";
adminUser.LastName = "User";
adminUser.DisplayName = "Admin User";
userManager.Create(adminUser, "Password-1");
}
if (!context.Users.Any(p => p.UserName == "*****@*****.**"))
{
modUser = new ApplicationUser();
modUser.UserName = "******";
modUser.Email = "*****@*****.**";
modUser.FirstName = "Moderator";
modUser.LastName = "User";
modUser.DisplayName = "Mod User";
userManager.Create(modUser, "Password-2");
}
else
{
adminUser = context.Users.Where(p => p.UserName == "*****@*****.**")
.FirstOrDefault();
}
//Check if the adminUser is already on the Admin role
//If not, add it.
if (!userManager.IsInRole(adminUser.Id, "Admin"))
{
userManager.AddToRole(adminUser.Id, "Admin");
}
if (!userManager.IsInRole(modUser.Id, "Mod"))
{
userManager.AddToRole(modUser.Id, "Mod");
}
}
public CustomerToTypesController()
{
_context = new ApplicationDbContext();
}
public testController()
{
_context = new ApplicationDbContext();
}
public ReviewController()
{
db = new ApplicationDbContext();
}
public EmployerController(Models.ApplicationDbContext dbContext, IConfiguration iconfiguration)
{
applicationDbContext = dbContext;
configuration = iconfiguration;
}
public HttpResponseMessage MUsuario(V_Usuarios usuario)
{
if (!ModelState.IsValid)
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
Models.ApplicationDbContext context = new Models.ApplicationDbContext();
Models.ApplicationUser Usuario = context.Users.FirstOrDefault((u) => u.Id == usuario.id);
if (Usuario == null)
{
return Request.CreateResponse(HttpStatusCode.NotFound);
}
Usuario.LockoutEnabled = usuario.LockoutEnabled;
Usuario.Email = usuario.Email;
Usuario.PhoneNumber = usuario.PhoneNumber;
Usuario.UserName = usuario.UserName;
context.Entry(Usuario).State = EntityState.Modified;
try
{
context.SaveChanges();
CambiarRool(context, Usuario.Id, usuario.Perfil);
}
catch (Exception ex)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.NotFound);
response.Content = new StringContent(ex.Message, Encoding.Unicode);
return response;
}
HttpResponseMessage okresponse = Request.CreateResponse(HttpStatusCode.OK);
okresponse.Content = new StringContent("Ha Sido Modificado el Usuario: " + usuario.UserName, Encoding.Unicode);
return okresponse;
}
