public IActionResult UpdateUserMachineData(bool isAdmin, string userID, string[] machineKeys)
{
try
{
var _user = _context.Users.SingleOrDefault(m => m.UserID == userID);
if (_user != null)//update
{
_user.IsAdmin = isAdmin;
var _userMachine = _context.UserMachines.Where(m => m.UserID == userID).ToList();
if (_userMachine != null)
{
_context.UserMachines.RemoveRange(_userMachine);
}
}
_context.SaveChanges();
if (!isAdmin)
{
foreach (string machineKey in machineKeys)
{
UserMachine userMachine = new UserMachine();
userMachine.UserID = userID;
userMachine.MachineKey = machineKey;
_context.UserMachines.Add(userMachine);
}
}
_context.SaveChanges();
return(Ok("success"));
}
catch (Exception ex)
{
return(ExceptionHandler(ex, "Update Error."));
}
}
public void DBHasUser(string username)
{
var HasUser = _context.Users.Where(u => u.UserID == username).FirstOrDefault();
if (HasUser == null)
{
User addUser = new User();
addUser.UserID = username;
addUser.IsAdmin = false;
_context.Users.Add(addUser);
_context.SaveChanges();
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new PostgresSQLContext(
serviceProvider.GetRequiredService <DbContextOptions <PostgresSQLContext> >()))
{
// Look for any machines. note:DB has been seeded
if (context.Machines.Any())
{
return; // DB has been seeded
}
context.Machines.AddRange(
new Machine
{
Name = "Server 1",
IP = "172.0.0.1",
LoginID = "Allen",
Password = "******",
OS = "Windos",
HostIP = "192.168.0.1",
Description = "Server 1 Desc",
},
new Machine
{
Name = "Server 2",
IP = "172.0.0.2",
LoginID = "Rong",
Password = "******",
OS = "Linux",
HostIP = "192.168.0.1",
Description = "Server 2 Desc",
}
);
//insert to DB
context.SaveChanges();
}
}
public IActionResult InsertMachineData(MachineUserViewModel machineUserViewModel)
{
try
{
if (machineUserViewModel.Password == null)
{
return(StatusCode(400, "PasswordIsNull"));
}
else
{
byte[] encodedBytes = System.Text.Encoding.UTF8.GetBytes(machineUserViewModel.Password);
machineUserViewModel.Password = Convert.ToBase64String(encodedBytes);
}
Machine machine = new Machine();
machine.Key = machineUserViewModel.MachineKey;
machine.IP = machineUserViewModel.IP;
machine.Name = machineUserViewModel.Name;
machine.LoginID = machineUserViewModel.LoginID;
machine.Password = machineUserViewModel.Password;
machine.OS = machineUserViewModel.OS;
machine.HostIP = machineUserViewModel.HostIP;
machine.Description = machineUserViewModel.Description;
_context.Add(machine);
_context.SaveChanges();
//Insert userMachine table
if (machineUserViewModel.AssignUserKeys != null)
{
foreach (var machineUserID in machineUserViewModel.AssignUserKeys)
{
UserMachine userMachine = new UserMachine();
userMachine.MachineKey = machineUserViewModel.MachineKey;
userMachine.UserID = machineUserID;
_context.UserMachines.Add(userMachine);
}
_context.SaveChanges();
}
return(Ok("success"));
}
catch (Exception ex)
{
return(ExceptionHandler(ex, "Insert Error."));
}
}