public bool EditSupporter(Supporter editedSupporter)
{
using (var db = new SqlConnection(_connectionString))
{
db.Open();
var result = db.Execute(@"UPDATE Employees
SET Name = @name, TItle = @Title, ManagerId = @ManagerId
WHERE EmployeeId = @EmployeeId", editedSupporter);
return(result == 1);
}
}
public bool AddSupporter(Supporter supporter)
{
using (var db = new SqlConnection(_connectionString))
{
db.Open();
var result = db.Execute(@"INSERT INTO Employees
(
Name,
Title,
ManagerId
)
VALUES
(
@Name,
@Title,
@ManagerId
)", supporter);
return(result == 1);
}
}
public StatusCodes EditEmployee(Supporter supporter)
{
bool checkSupporter;
try
{
checkSupporter = _repo.GetSupporterById(supporter.EmployeeId);
}
catch (SqlException)
{
return(StatusCodes.Unsuccessful);
}
catch (Exception)
{
return(StatusCodes.NotFound);
}
var editSupporter = _repo.EditSupporter(supporter);
return(editSupporter
? StatusCodes.Success
: StatusCodes.Unsuccessful);
}
