public async Task <String> ChangeSupervisor(int empId, int spvsrId)
{
AzureModels.HRHCMDataEntities databaseEntity = new AzureModels.HRHCMDataEntities();
AzureModels.Table table = new AzureModels.Table();
var newSupervisorName = (from Table in databaseEntity.Tables
where Table.EmployeeID == spvsrId
select Table.EmployeeName);
var employeeDetails = (from Table in databaseEntity.Tables
where Table.EmployeeID == empId
select Table);
foreach (Table Table in employeeDetails)
{
Table.SupervisorID = spvsrId;
Table.SupervisorName = newSupervisorName.Single();
}
try
{
databaseEntity.SaveChanges();
return(newSupervisorName.Single());
}
catch (Exception e)
{
return(null);
}
}
public async Task <String> EmpValidityCheck(int empId, int spvsrId)
{
AzureModels.HRHCMDataEntities databaseEntity = new AzureModels.HRHCMDataEntities();
AzureModels.Table table = new AzureModels.Table();
var employeeName = (from Table in databaseEntity.Tables
where Table.EmployeeID == empId
select Table.EmployeeName);
var currentSupervisorName = (from Table in databaseEntity.Tables
where Table.EmployeeID == empId
select Table.SupervisorName);
var newSupervisorName = (from Table in databaseEntity.Tables
where Table.EmployeeID == spvsrId
select Table.EmployeeName);
var output = currentSupervisorName.Single() + "||" + newSupervisorName.Single();
return(output);
}
