public IActionResult UpdateMachineData(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);
}
//insert machine table
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.Update(machine);
_context.SaveChanges();
/**Delete MachineKey in intermediary table, Then, Insert new MachineKey and User in intermediary talbe**/
//Delete
var _machineUser = _context.UserMachines.Where(um => um.MachineKey == machineUserViewModel.MachineKey).ToList();
if (_machineUser.Count != 0)
{
_context.UserMachines.RemoveRange(_machineUser);
_context.SaveChanges();
}
//Insert
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, "Update Error."));
}
}
public IActionResult DeleteMachineData(MachineUserViewModel machineUserViewModel)
{
try
{
Machine _machine = _context.Machines.SingleOrDefault(m => m.Key == machineUserViewModel.MachineKey);
_context.Remove(_machine);
_context.SaveChanges();
return(Ok("success"));
}
catch (Exception ex)
{
return(ExceptionHandler(ex, "Delete Error."));
}
}
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."));
}
}
