public IActionResult UpdateInfo([FromBody] EmployeeInfoToShare updatedInfo, int id)
{
if (updatedInfo != null)
{
var newEmployeeUtils = new EmployeeUtils();
if (updatedInfo.FirstName != null)
{
updatedInfo.EmployeeId = id;
if (newEmployeeUtils.EditEmployeeAccount(updatedInfo))
{
return(NoContent());
}
}
return(BadRequest("Invalid Input!!!"));
}
else
{
var newEmployeeUtils = new EmployeeUtils();
var empToClean = newEmployeeUtils.GetEmployeeById(id);
if (empToClean != null)
{
return(Ok(empToClean));
}
return(NotFound($"Couldnt find an Employee with the ID: {id}"));
}
}
public static EmployeeInfoToShare RemovePersonalInfo(Employee toClean)
{
var cleanedInfo = new EmployeeInfoToShare();
cleanedInfo.Active = toClean.Active;
cleanedInfo.EmployeeId = toClean.EmployeeId;
cleanedInfo.EmployeeTitle = toClean.EmployeeTitle;
cleanedInfo.EmployeeType = toClean.EmployeeType;
cleanedInfo.FirstName = toClean.FirstName;
cleanedInfo.LastName = toClean.LastName;
cleanedInfo.PhoneNumber = toClean.PhoneNumber;
return(cleanedInfo);
}
public bool EditEmployeeAccount(EmployeeInfoToShare updatedEmployee)
{
var updateEmployeeInfoQuery = $"UPDATE {DatabaseUtils.Databasename}.employeelist " +
$"SET EMP_Name_First = '{updatedEmployee.FirstName}', " +
$"EMP_Name_Last = '{updatedEmployee.LastName}', " +
$"EMP_Active = '{Convert.ToInt32(updatedEmployee.Active)}', " +
$"EMP_Type = '{updatedEmployee.EmployeeType}', " +
$"EMP_PhoneNumber = '{updatedEmployee.PhoneNumber}' " +
$"WHERE EMP_ID = '{updatedEmployee.EmployeeId}';";
var updateEmployee = DatabaseUtils.Instance();
return(updateEmployee.MakeDbQuery(updateEmployeeInfoQuery));
}
public IActionResult UpdateInfo([FromBody] EmployeeInfoToShare updatedInfo, int id)
{
if (updatedInfo != null)
{
var newEmployeeUtils = new EmployeeUtils();
if (updatedInfo.FirstName != null)
{
updatedInfo.EmployeeId = id;
if (newEmployeeUtils.EditEmployeeAccount(updatedInfo))
{
return(NoContent());
}
}
}
return(BadRequest("Invalid Input!!!"));
}