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; }