public async Task <IActionResult> AddUserV(int id, UserVDetailDto userVDetailDto) { var userFromRepo = await _repo.GetUser(id, true); var userV = new UserV(); userV.Id = userVDetailDto.Id; userV.Created = DateTime.Now; userV.DisplayNameRus = userVDetailDto.DisplayNameRus; userV.DisplayNameEng = userVDetailDto.DisplayNameEng; userV.DisplayNameKaz = userVDetailDto.DisplayNameKaz; userV.FromNameRus = userVDetailDto.FromNameRus; userV.FromNameEng = userVDetailDto.FromNameEng; userV.FromNameKaz = userVDetailDto.FromNameKaz; userV.ToNameRus = userVDetailDto.ToNameRus; userV.ToNameEng = userVDetailDto.ToNameEng; userV.ToNameKaz = userVDetailDto.ToNameKaz; userV.Priority = userVDetailDto.Priority; userV.Disabled = userVDetailDto.Disabled; userV.DepartmentVId = userVDetailDto.departmentVId; // _mapper.Map(userForUpdateDto, userFromRepo); userFromRepo.UserVs.Add(userV); if (await _repo.SaveAll()) { return(NoContent()); } throw new Exception($"Updating user {id} failed on save"); }
// public void SeedUsers() // { // if (!_userManager.Users.Any()) // { // var userData = System.IO.File.ReadAllText("Data/SeedData/UserSeedData.json"); // var users = JsonConvert.DeserializeObject<List<User>>(userData); // var roles = new List<Role> // { // new Role{Name = "Member"}, // new Role{Name = "Admin"}, // new Role{Name = "Moderator"}, // new Role{Name = "VIP"}, // }; // foreach (var role in roles) // { // _roleManager.CreateAsync(role).Wait(); // } // var departmentId = _context.DepartmentVs.FirstOrDefault(x => x.Name == "DepartmentV_2_2").Id; // foreach (var user in users) // { // // user.DepartmentVId=departmentId; // _userManager.CreateAsync(user, "password").Wait(); // _userManager.AddToRoleAsync(user, "Member").Wait(); // // user.UserVs.Add(new UserV(){ // // Id = Guid.NewGuid(), // // Created = DateTime.Now, // // DisplayNameRus = "DisplayNameRus", // // DisplayNameEng = "DisplayNameEng", // // DisplayNameKaz = "DisplayNameKaz", // // FromNameRus = "FromNameRus", // // FromNameEng = "FromNameEng", // // FromNameKaz = "FromNameKaz", // // ToNameRus = "ToNameRus", // // ToNameEng = "ToNameEng", // // ToNameKaz = "ToNameKaz", // // Priority = 0, // // Disabled = false // // }); // } // var adminUser = new User // { // UserName = "******", // // DepartmentVId=departmentId // }; // IdentityResult result = _userManager.CreateAsync(adminUser, "password").Result; // if (result.Succeeded) // { // var admin = _userManager.FindByNameAsync("Admin").Result; // _userManager.AddToRolesAsync(admin, new[] { "Admin", "Moderator" }).Wait(); // } // } // } public void SeedUserV() { if (!_context.UserVs.Any()) { var users = _context.Users.ToList(); foreach (var user in users) { var userTemp = _context.UserTemps.FirstOrDefault(x => x.Name == user.UserName); if (userTemp != null) { var departmentId = Guid.Parse("0ABABC65-69D2-4854-A0AD-07402FE6462C"); var dep = _context.Departments.FirstOrDefault(x => x.KeyIndex == userTemp.DepartmentName); if (dep != null) { var depV = _context.DepartmentVs.FirstOrDefault(x => x.DepartmentId == dep.Id); if (depV != null) { departmentId = depV.Id; } } else { departmentId = _context.DepartmentVs.FirstOrDefault().Id; } var userv = new UserV() { Id = Guid.NewGuid(), Created = DateTime.Now, DisplayNameRus = userTemp.DisplayNameRus, DisplayNameEng = userTemp.DisplayNameEng, DisplayNameKaz = userTemp.DisplayNameKaz, FromNameRus = userTemp.FromNameRus, FromNameEng = userTemp.FromNameEng, FromNameKaz = userTemp.FromNameKaz, ToNameRus = userTemp.ToNameRus, ToNameEng = userTemp.ToNameEng, ToNameKaz = userTemp.ToNameKaz, Priority = 0, Disabled = false, UserId = user.Id, DepartmentVId = departmentId }; _context.UserVs.Add(userv); } } _context.SaveChanges(); } }
public ActionResult <List <UserV> > GetUsers() { var result = this.db.Users.ToList(); List <UserV> userVs = new List <UserV>(); foreach (User u in result) { UserV userV = new UserV { Id = u.Id, Fullname = u.Fullname, Email = u.Email, Role = u.Role }; userVs.Add(userV); } return(userVs); }
//Get user by name public UserV GetUserByName(string userName) { UserV user = null; DbParameter name = DbFactory.GetParameter(_provider); name.ParameterName = "@name"; name.Value = userName; name.DbType = DbType.String; DbDataReader reader = _dataProvider.ExecuteReader("usp_SelectUserByName", new DbParameter[] { name }); while (reader.Read()) { user = new UserV(); user.Id = (Guid)reader["Id"]; user.Password = (string)reader["Password"]; user.Name = (string)reader["Name"]; user.NickName = (string)reader["NickName"]; user.LastConnectionDate = (DateTime)reader["LastConnectionDate"]; user.IsConnected = (bool)reader["IsConnected"]; } reader.Close(); _dataProvider.CloseConnection(); return(user); }