/// <summary> /// Create gateway in particular boundary, return true if successfully created else return false /// </summary> /// <param name="gatewayName">GatewayName</param> /// <param name="gatewayMAC">GatewayMAC</param> /// <param name="createdBy">CreatedBy</param> /// <param name="boundaryId">BoundaryId</param> /// <param name="isEnable">IsEnable</param> /// <returns>True if gateway successfully created</returns> /// Author = Ali Abbas, version 1.0 public bool CreateGateway(string gatewayName, string gatewayMAC, string createdBy, int boundaryId, bool isEnable) { try { Gateway gateway = new Gateway() { GatewayName = gatewayName, GatewayMAC = gatewayMAC, CreatedBy = createdBy, BoundaryId = boundaryId, IsEnable = isEnable, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now }; using (db.Database.BeginTransaction()) { db.Entry(gateway).State = EntityState.Added; db.Gateways.Add(gateway); db.SaveChanges(); db.Database.CommitTransaction(); return(true); } } catch (Exception ex) { db.Database.RollbackTransaction(); throw ex; } }
public ActionResult Send(SendMessageViewModel viewModel) { if (ModelState.IsValid) { Message m = new Message(User.Identity.GetUserId(), viewModel.Subject, viewModel.Body); Db.Messages.Add(m); try { string[] gReceivers = viewModel.GroupReceivers.Split(','); foreach (string r in gReceivers) { Group grp = Db.Groups.Where(g => g.Name.Equals(r)).First(); m.GroupReceivers.Add(grp); Db.SaveChanges(); } } catch (Exception e) {} try { string[] uReceivers = viewModel.UserReceivers.Split(','); foreach (string r in uReceivers) { ApplicationUserMessage user_message = new ApplicationUserMessage(m.Id, (Db.Users.First(u => u.Email.Equals(r)).Id.ToString())); Db.ApplicationUserMessages.Add(user_message); Db.SaveChanges(); } }catch (Exception e) {} return(RedirectToAction("Sent")); } return(View()); }
public Role Add(Role t) { if (t != null) { _context.Roles.Add(t); _context.SaveChanges(); } return(t); }
public User Add(User t) { if (t != null) { _context.Users.Add(t); _context.SaveChanges(); } return(t); }
public virtual void Delete(TObject TObject, bool batch = true) { this.DbSet.Remove(TObject); if (!batch) { Context.SaveChanges(); } }
public Task <IdentityResult> Create(Role role) { return(Task <IdentityResult> .Run(() => { role.ID = Guid.NewGuid().ToString(); Context.Set <Role>().Add(role); Context.SaveChanges(); return IdentityResult.Success; })); }
/// <summary> /// 新增一个用户 /// </summary> /// <param name="user"></param> /// <returns></returns> public Task CreateAsync(User user) { return(Task.Run(() => { user.Id = Guid.NewGuid().ToString(); Context.User.Add(user); int i = Context.SaveChanges(); return i; })); }
private void Check5StarMedal(string name) { var user = context.Users.Include(x => x.Medals).FirstOrDefault(x => x.UserName == name); if (guidecontext.GetGuides(guidecontext, user.Id).Any(x => x.Ratings.Any(r => r.OwnerRating == 5)) && !user.Medals.Any(x => x.MedalId == 8)) { AddMedal(8, user); } CheckSuperMedal(name); context.SaveChanges(); }
public ActionResult Create(CreateGroupViewModel gvm) { Group group = new Group(); group.Users = new List <ApplicationUser>(); ApplicationUser currentUser = Db.Users.Find(User.Identity.GetUserId()); group.Name = gvm.Name; Db.Groups.Add(group); group.Users.Add(currentUser); Db.SaveChanges(); return(View()); }
public IActionResult AddCategory(string Name) { User CurrUser = GetCurrentUserAsync().Result; Category NewCategory = new Category { Name = Name, UserId = CurrUser.Id, }; _context.Add(NewCategory); _context.SaveChanges(); return(RedirectToAction("Index")); }
// GET: /<controller>/ public IActionResult StoreMessage(MessageViewModel model) { var userId = HttpContext.User.Identity.Name; MessagesModel message = new MessagesModel { Message = model.Message, SendTo = model.SendTo, SendFrom = userId }; IdentityContext.Messages.Add(message); IdentityContext.SaveChanges(); return(RedirectToAction("ShowChat", new { Id = model.SendTo })); }
public Task CreateAsync(Permission role) { return(Task.Run(() => { var per = FindByNameAsync(role.Name); if (per.Result != null) { throw new Exception("权限已经存在"); } role.Id = Guid.NewGuid().ToString(); role.IsBasic = false; Context.Set <Permission>().Add(role); Context.SaveChanges(); })); }
// GET: /<controller>/ public IActionResult Index() { var user1 = new IdentityUser { UserName = "******", Email = "*****@*****.**" }; var user2 = new IdentityUser { UserName = "******", Email = "*****@*****.**" }; _userManager.CreateAsync(user2, "Password01!"); _userManager.CreateAsync(user1, "Password01!"); JobModel wordpress = new JobModel { Title = "Wordpress Developer", Description = "We are looking for a new wordpress developer that has a lot of good experience writing his own plugins. we need this to customize websites for our customers to give them the post possible results!", Website = "https://wordpress.com", Employment = "40", Skills = "PHP, CSS, JS, HMTL", Price = 60 }; JobModel appsec = new JobModel { Title = "Application security specialist", Description = "We are looking for an expert security specialist to help us with doing security testing on our web applications. It is a pre id you know OWASP and ASVS and how to set up security test automation in CI/CD pipelines", Website = "https://owasp.org", Employment = "40", Skills = "Docker, OWASP, Appsec", Price = 150 }; IdentityContext.Jobs.Add(wordpress); IdentityContext.Jobs.Add(appsec); IdentityContext.SaveChanges(); return(RedirectToAction("Index", "Home")); }
public void GetAccountById_Return_Account() { // Arrange var options = GetContextOptions(); var email = "*****@*****.**"; var account = new AccountModel { Login = "******", Email = email, Password = "******", Role = 1, IsActive = true }; AccountViewModel result; // Act using (var context = new IdentityContext(options)) { context.Accounts.Add(account); context.SaveChanges(); var accoundGuid = context.Accounts.LastOrDefault().Id; IAccountService accountService = new AccountService(_options, context, _mapper); result = accountService.GetAccountByIdAsync(accoundGuid).GetAwaiter().GetResult(); } // Assert Assert.Equal(account.Login, result.Login); Assert.Equal(account.Email, result.Email); Assert.Equal(account.Password, result.Password); Assert.Equal(account.Role, result.Role); Assert.Equal(account.IsActive, result.IsActive); }
public IActionResult Post([FromBody] CsrfViewModel value) { if (ModelState.IsValid) { CsrfModel csrf = new CsrfModel { PrivateData = value.PrivateData, PrivateDateTime = DateTime.Now }; _myContext.Csrf.Add(csrf); _myContext.SaveChanges(); return(Ok("New value was stored succesfull!")); } else { return(BadRequest("Storing the item has failed!")); } }
public void CanUserBeAuthenticated_Return_UserTokenModel() { // Arrange var options = GetContextOptions(); var account = new AccountModel { Login = "******", Email = "*****@*****.**", Password = "******", Role = 1, IsActive = true }; var loginViewModel = new LoginViewModel { Email = "*****@*****.**", Password = "******" }; UserTokenModel result; // Act using (var context = new IdentityContext(options)) { context.Accounts.Add(account); context.SaveChanges(); IAccountService accountService = new AccountService(_options, context, _mapper); result = accountService.AuthenticateAsync(loginViewModel).GetAwaiter().GetResult(); } // Assert Assert.Equal(account.Login, result.UserName); Assert.Equal(account.Role.ConvertRole(), result.Role); }
public static void SeedEmploys(IServiceProvider serviceProvider) { using (var context = new IdentityContext(serviceProvider.GetRequiredService <DbContextOptions <IdentityContext> >())){ if (context.Employ.Any()) { return; // DB has been seeded } ; Technician QueryTechnician = context.Technician .Where(s => s.Name == "Rodrigo Kan") .FirstOrDefault <Technician>(); Project QueryProject = context.Project .Where(s => s.Title == "Toy Story 5") .FirstOrDefault <Project>(); var Employs = new Employ[] { new Employ { Project = QueryProject, Technician = QueryTechnician, TechnicianID = QueryTechnician.TechnicianID, ProjectID = QueryProject.ProjectID, } }; foreach (Employ e in Employs) { context.Employ.Add(e); } context.SaveChanges(); } }
public void LeaveBoard() { _currentUser.Kleur = Kleur.Geen; string roomtoken = _currentUser.SpelToken; _currentUser.SpelToken = null; bool playersStillInRoom = false; foreach (Users user in identityContext.Users.ToList()) { if (user.SpelToken == roomtoken) { playersStillInRoom = true; break; } } if (!playersStillInRoom) { context.Remove(_context); } context.SaveChanges(); identityContext.SaveChanges(); }
public ApiResponse <User> Update(User userData) { //Prevent changing the ID userData.Id = Guid.Empty; var userToChange = GetUserFromIdAsync(userData.Id).Result; // Can only update an existing user if (userToChange == null) { return(new ApiResponse <User>(ApiResponseCode.UnAuthenticated, null)); } // Update the user if (!string.IsNullOrWhiteSpace(userData.PasswordHash) && userData.PasswordHash != userToChange.PasswordHash) { //If the password is unchanged or empty, this does not update the password userData.PasswordHash = userToChange.PasswordHash; } // Automapper is configured to only overwrite the fields that are not null _mapper.Map(userData, userToChange); _identityContext.Update(userToChange); _identityContext.SaveChanges(); return(new ApiResponse <User>(ApiResponseCode.OK, userToChange)); }
public ActionResult DeleteConfirmSecurityGroup(string id) { ApplicationSecurityGroup securityGroup = IdentityContext.SecurityGroups .Include(x => x.Roles).Include(x => x.Users) .FirstOrDefault(x => x.Id == id); securityGroup.Users.ForEach(u => { securityGroup.Roles.ForEach(role => { // Silinecek role başka bir sec grp da var mı? Varsa kullanıcıdan silmemeliyiz. bool hasAnotherSecGroupThatRoleForUser = u.SecurityGroups.Where(x => x.Id != id).ToList() .Any(x => x.Roles.Any(r => r.Id == role.Id)); if (hasAnotherSecGroupThatRoleForUser == false) { UserManager.RemoveFromRole(u.Id, role.Name); } }); }); IdentityContext.SecurityGroups.Remove(securityGroup); IdentityContext.SaveChanges(); return(JavaScript("deletesecuritygroup_success();")); }
public ActionResult EditUser(ApplicationUser User1) { if (ModelState.IsValid) { UserManager <ApplicationUser> UserManager1 = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new IdentityContext())); //جهت فعال کردن امکان ثبت نام فارسی UserManager1.UserValidator = new UserValidator <ApplicationUser>(UserManager1) { AllowOnlyAlphanumericUserNames = false }; if ((UserManager1.FindByName(User1.UserName) == null) || (UserManager1.FindById(User1.Id).UserName == User1.UserName)) { IdentityContext IdentityContext1 = new IdentityContext(); IdentityContext1.Entry(User1).State = System.Data.Entity.EntityState.Modified; IdentityContext1.SaveChanges(); //return RedirectToAction("AllUsers"); return(Json(new { success = true })); } else { ModelState.AddModelError("", "نام" + User1.UserName + "قبلا انتخاب شده است."); } } else { ModelState.AddModelError("", "داده های وارد شده نامعتبراند"); } return(PartialView("_EditUser", User1)); }
public UserId AddIdentity(UserId userId) { userId.IId = Guid.NewGuid(); _identityContext.IdentityUser.Add(userId); _identityContext.SaveChanges(); return(userId); }
public ActionResult DeleteRoleConfirmed(string id) { try { IdentityContext IdentityContext1 = new IdentityContext(); UserManager <ApplicationUser> UserManager1 = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new IdentityContext())); IdentityUser IdentityUser1 = new IdentityUser(); var IdentityUsers = IdentityContext1.Users.Where(u => u.Roles.Any(r => r.RoleId == id)); foreach (IdentityUser user1 in IdentityUsers) { UserManager1.RemoveFromRole(user1.Id, id); } //RoleManager<IdentityRole> RoleManager1 = new RoleManager<IdentityRole>(new RoleStore<IdentityRole>(new ApplicationDbContext())); IdentityRole IdentityRole1 = new IdentityRole(); IdentityRole1 = IdentityContext1.Roles.Find(id); IdentityContext1.Roles.Remove(IdentityRole1); IdentityContext1.SaveChanges(); //return RedirectToAction("AllRoles"); return(Json(new { success = true })); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); return(PartialView("_DeleteRole", id)); } }
public ActionResult DeleteUserConfirmed(string id = null) { try { IdentityContext IdentityContext1 = new IdentityContext(); ApplicationUser IdentityUser1 = IdentityContext1.Users.First(x => x.Id == id); UserManager <ApplicationUser> UserManager1 = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new IdentityContext())); foreach (string UserRole1 in UserManager1.GetRoles(id)) { UserManager1.RemoveFromRole(id, UserRole1); } foreach (System.Security.Claims.Claim UserClaim1 in UserManager1.GetClaims(id)) { UserManager1.RemoveClaim(id, UserClaim1); } foreach (UserLoginInfo UserLoginInfo1 in UserManager1.GetLogins(id)) { UserManager1.RemoveLogin(id, UserLoginInfo1); } IdentityContext1.Users.Remove(IdentityUser1); IdentityContext1.SaveChanges(); //return RedirectToAction("AllUsers"); return(Json(new { success = true })); } catch (Exception ex) { return(Content(ex.Message)); } }
public ActionResult EditRole(string id, string Name) { string RoleNameNew = Name; if (ModelState.IsValid) { RoleManager <IdentityRole> RoleManager1 = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(new IdentityContext())); if (!RoleManager1.RoleExists(RoleNameNew)) { IdentityContext IdentityDbContext1 = new IdentityContext(); IdentityRole Role1 = IdentityDbContext1.Roles.First(x => x.Id == id); Role1.Name = RoleNameNew; IdentityDbContext1.Entry(Role1).State = System.Data.Entity.EntityState.Modified; IdentityDbContext1.SaveChanges(); //return RedirectToAction("AllRoles"); return(Json(new { success = true })); } else { ModelState.AddModelError("", "گروه جدید قبلا ساخته شده است."); } } else { ModelState.AddModelError("", "داده های وارد شده معتبر نیستند."); } return(PartialView("_EditRole", RoleNameNew)); }
public async Task <IActionResult> Register(RegisterViewModel model) { Customers addCustomers = new Customers(); addCustomers.EmailOfCustomer = model.Email; addCustomers.Citi = model.Citi; addCustomers.NameOfComany = model.NameOfComany; addCustomers.NIP = model.NIP; addCustomers.Street = model.Street; addCustomers.PhoneNumber = model.PhoneNumber; addCustomers.NameOfCustomer = model.NameOfCustomer; _context.Add(addCustomers); try { _context.SaveChanges(); } catch (DbUpdateException) { return(Content("Brak dostepu do Bazy")); } RegisterModel addNewUser = new RegisterModel(); addNewUser.Email = model.Email; addNewUser.Login = model.Login; addNewUser.RepeatPassword = model.RepeatPassword; addNewUser.Password = model.Password; if (ModelState.IsValid) { var identity = new UserModel(addNewUser.Login); identity.Email = addNewUser.Email; identity.CustomersID = addCustomers.Id; var result = await _signInManager.UserManager.CreateAsync(identity, addNewUser.Password); if (result.Succeeded) { await _signInManager.PasswordSignInAsync(model.Login, model.Password, false, false); return(RedirectToAction("Index", "Account")); } foreach (var error in result.Errors) { ModelState.AddModelError("", error.Description); } } return(View()); }
public async Task OnPostEditProyectosPersonales_VerSiRealmenteEdita() { // Arrange //Preparamos un contexto que guarde la base de datos en memoria ram. var OptionsBuilder = new DbContextOptionsBuilder <IdentityContext>() .UseInMemoryDatabase("InMemoryDb"); IdentityContext TestIdentityContext = new IdentityContext(OptionsBuilder.Options); ProyectoPersonal ProyectoPersonal = new ProyectoPersonal() { ID = 4, Descripcion = "Book", FechaComienzo = DateTime.Parse("2019/02/12"), FechaFinalizacion = DateTime.Parse("2019/02/12"), TipoDeProyecto = "Foto" }; //Guardamos un Proyecto Personal en bd TestIdentityContext.ProyectoPersonal.Add(ProyectoPersonal); TestIdentityContext.SaveChanges(); //Creo una instancia de Proyecto Personal para comparar más adelante ProyectoPersonal ProyectoPersonalEsperado = new ProyectoPersonal() { ID = 4, Descripcion = "Camara", FechaComienzo = DateTime.Parse("2019/03/12"), FechaFinalizacion = DateTime.Parse("2019/04/12"), TipoDeProyecto = "camara" }; // Act //Creamos una pagina de tipo EditModel (de Proyectos Personales), la cual es la que se encarga de la logica //de editar Proyectos Personales en bd. EditModel PageEditModel = new EditModel(TestIdentityContext); //Simulamos haber hecho el edit en un Proyectos Personales con el id await PageEditModel.OnGetAsync(ProyectoPersonal.ID); //Modificamos los valores de los atributos de la instancia "ProyectoPersonal" de Proyecto Personal PageEditModel.ProyectoPersonal.Descripcion = ProyectoPersonalEsperado.Descripcion; PageEditModel.ProyectoPersonal.FechaComienzo = ProyectoPersonalEsperado.FechaComienzo; PageEditModel.ProyectoPersonal.FechaFinalizacion = ProyectoPersonalEsperado.FechaFinalizacion; PageEditModel.ProyectoPersonal.TipoDeProyecto = ProyectoPersonalEsperado.TipoDeProyecto; //Simulamos un post que envíe el formulario de la pagina y por ende guarda los cambios de la edicion await PageEditModel.OnPostAsync(); // Assert //Buscamos si aún esta en bd el Proyecto Personal que debió haber sido editada por la pagina ProyectoPersonal ProyectoPersonalRecibida = await TestIdentityContext.ProyectoPersonal.FindAsync(ProyectoPersonal.ID); Assert.Equal( ProyectoPersonalEsperado.Descripcion.ToString(), ProyectoPersonalRecibida.Descripcion.ToString()); Assert.Equal( ProyectoPersonalEsperado.FechaComienzo.ToString(), ProyectoPersonalRecibida.FechaComienzo.ToString()); Assert.Equal( ProyectoPersonalEsperado.FechaFinalizacion.ToString(), ProyectoPersonalRecibida.FechaFinalizacion.ToString()); Assert.Equal( ProyectoPersonalEsperado.TipoDeProyecto.ToString(), ProyectoPersonalRecibida.TipoDeProyecto.ToString()); //Si se ejecuta correctamente, significa que el programa modifica correctamente Proyectos Personales }
public IActionResult Post([FromBody] IdorViewModel idor) { if (ModelState.IsValid) { string username = _httpContextAccessor.HttpContext.Request.Cookies.FirstOrDefault(x => x.Key == "User").Value.ToString(); IdorModel value = new IdorModel { IdorValue = idor.IdorValue, Owner = username }; _myContext.Idor.Add(value); _myContext.SaveChanges(); return(Ok("New value was stored succesfull!")); } else { return(BadRequest("Storing the item has failed!")); } }
public static void SeedProjects(IServiceProvider serviceProvider) { using (var context = new IdentityContext(serviceProvider.GetRequiredService <DbContextOptions <IdentityContext> >())) { if (context.Project.Any()) { return; // DB has been seeded } ; var Projects = new Project[] { new Project { Title = "Reclame UCU Enseña", Date = DateTime.Parse("2019-02-01"), Description = "Reclame de 5 minutos", CompletionStatus = false }, new Project { Title = "Propaganda Copa América", Date = DateTime.Parse("2019-03-02"), Description = "Titulares y Highlights de la Copa 2015", CompletionStatus = false }, new Project { Title = "Kung Fu Panda 5", Date = DateTime.Parse("2019-07-03"), Description = "Trailer de la nueva Película", CompletionStatus = false }, new Project { Title = "Open Fing Clases", Date = DateTime.Parse("2019-11-04"), Description = "Grabar Curso 779283 completo ", CompletionStatus = false }, new Project { Title = "Toy Story 5", Date = DateTime.Parse("2019-12-05"), Description = "Trailer de la Nueva Pelicula de Pixar", CompletionStatus = false }, new Project { Title = "Mi Villano Favorito", Date = DateTime.Parse("2019-10-04"), Description = "Mindstorming de la nueva Película", CompletionStatus = false }, new Project { Title = "Podcast con Alumnos", Date = DateTime.Parse("2019-04-06"), Description = "Entrevistas casuales acerca de la vida estudiantil en UCU", CompletionStatus = true }, new Project { Title = "VideoClip Musical Survivors", Date = DateTime.Parse("2019-09-07"), Description = "Filmar el nuevo videoclip para Survivors", CompletionStatus = false } }; foreach (Project p in Projects) { Client query = context.Client .Where(s => s.Name == "ESPN") .FirstOrDefault <Client>(); p.Client = query; p.ClientID = query.ClientID; context.Project.Add(p); } ; context.SaveChanges(); } }
public IActionResult AddRoom(RoomDescriptionModel roomDescription) { var listFromDataBase = _context.RoomDescriptionModels .Where(x => x.NameOfRoom == roomDescription.NameOfRoom) .ToList(); //for (int i = 0; i < listFromDataBase.Count; i++) //{ // string name = listFromDataBase[i].NameOfRoom; // if (name == roomDescription.NameOfRoom) // { // TempData["Massege"] = "Sala o podanej nazwie juz istneje"; // return AddRoom(); // } //} //if (listFromDataBase.Contains(name)) //{ //} //if (string.IsNullOrEmpty(roomDescription.NameOfRoom)) //{ // return Content("Prosze podać nazwę sali"); //} if (ModelState.IsValid) { _context.Add(roomDescription); try { _context.SaveChanges(); } catch (DbUpdateException) { if (roomDescription.Id != default(int)) { roomDescription.Id = default(int); _context.SaveChanges(); } } } return(AddRoom()); }