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