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); }